Curriculum
1 Section
13 Lessons
2 Hours
Expand all sections
Collapse all sections
Excel - Formulas and Functions
13
2.1
Basic Maths
2 Minutes
2.2
Excel Must-Know Formulas and Functions – 1 – Building basic math formulas
8 Minutes
2.3
Excel Must-Know Formulas and Functions – 2 – Autosum and Relative references
9 Minutes
2.4
Excel Must-Know Formulas and Functions – 3 – Absolute references
6 Minutes
2.5
Excel Must-Know Formulas and Functions – 4 – Named Ranges
6 Minutes
2.6
Excel Must-Know Formulas and Functions – 5 – Linking sheets and workbooks
6 Minutes
2.7
Excel Must-Know Formulas and Functions – 6 – If, And, Or, and the nested If functions
16 Minutes
2.8
Excel Must-Know Formulas and Functions – 7 – Countif, Sumif, Averageif, Sumifs, and Countifs functions
9 Minutes
2.9
Excel Must-Know Formulas and Functions – 8 – Vlookup and Hlookup functions
15 Minutes
2.10
Excel Must-Know Formulas and Functions – 9 – Match and Index functions
7 Minutes
2.11
Excel Must-Know Formulas and Functions – 10 – Date and time formulas and functions
13 Minutes
2.12
Excel Must-Know Formulas and Functions – 11 – Text functions
11 Minutes
2.13
Excel Must-Know Formulas and Functions – 12 – Tracing formulas
8 Minutes
Excel – Must Know Formulas and Functions
Search
This content is protected, please
login
and enroll in the course to view this content!
Login with your site account
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Are you a member?
Login now
Modal title
Main Content