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
Excel Must-Know Formulas and Functions – 1 – Building basic math formulas
https://dwnk32xmy75f1.cloudfront.net/wp-content/uploads/Excel-Must-Know-Formulas-and-Functions-1-Building-basic-math-formulas.mp4
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