Overview
The goal of this course is to provide you with the knowledge required to use more advanced formulas and work with various tools to analyse data in spreadsheets, such as sorting, filtering, conditional formatting and auditing. You will also organise table data and present data as charts. You will discover how Excel spreadsheets are constructed and be given a clear path on how to create templates. The course emphasises hands-on experience, with a series of self-guided exercises integrated into the training.
Learning Outcomes
- Calculate with advanced formulas
- Audit formulas using the auditing tools
- Work with Excel tables
- Organise worksheet data so that data can be sorted and filtered
- Create and modify Charts
- Create Excel templates
- Apply Conditional Formatting
Absolute references
1
Absolute cell references
2
Using the $ sign
Range names
1
Creating range names
2
Editing/deleting range names
Conditional formulae
1
Creating a single =IF formula
2
Using =SUMIFS and =COUNTIFS
3
Combining conditions (AND, OR and NOT)
Productivity Hacks to Get More Done in 2018
— 28 February 2017
- Facebook News Feed Eradicator (free chrome extension) Stay focused by removing your Facebook newsfeed and replacing it with an inspirational quote. Disable the tool anytime you want to see what friends are up to!
- Hide My Inbox (free chrome extension for Gmail) Stay focused by hiding your inbox. Click "show your inbox" at a scheduled time and batch processs everything one go.
- Habitica (free mobile + web app) Gamify your to do list. Treat your life like a game and earn gold goins for getting stuff done!
Be the first to add a review.
Please, login to leave a review
Microsoft Excel (Intermediate)
Price:
£300