3 Sections
9 Lessons
3 Weeks
Expand all sections
Collapse all sections
Working Smart in Excel
4 Items
Structure, navigation and clean data
1.1
How Professional Spreadsheets Are Structured
25 Minutes
1.2
Cleaning and Preparing Data
30 Minutes
1.3
Sorting, Filtering and Conditional Formatting
25 Minutes
1.4
Section 1 Quiz: Working Smart
10 Minutes
5 Questions
Formulas Employers Expect
4 Items
Calculations, logic and lookups
2.1
Essential Formulas and References
30 Minutes
2.2
Logic With IF, AND, OR and IFS
25 Minutes
2.3
SUMIFS, COUNTIFS and XLOOKUP
35 Minutes
2.4
Section 2 Quiz: Formulas
10 Minutes
5 Questions
PivotTables and Charts
4 Items
Summarising and visualising data
3.1
PivotTables From Zero
30 Minutes
3.2
Charts That Tell a Clear Story
25 Minutes
3.3
Building a One-Page Dashboard
30 Minutes
3.4
Section 3 Quiz: PivotTables and Dashboards
10 Minutes
5 Questions
Microsoft Excel for Business: Formulas, PivotTables and Dashboards
Curriculum
This content is protected, please
login
and enroll in the course to view this content!
Your amount to pay has been updated
The previous conversion quote has expired. Here is your new quote:
Total
$
You Pay
Home
Courses
Search
Search
Account
Login with your site account
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Want to become an instructor?
Are you a member?
Login now
Modal title
Main Content