01. Navigation and selection keyboard shortcuts & download resources
02. Functions in Excel – mathematical, logical and date
03. Range vs table
04. Data formatting and number formats in Excel
05. Database functions and subtotal in Excel
06. Relative, absolute and mixed referencing in Excel
07. Complex logical and nested formulas in Excel
08. IF, AND, OR, NOT & download resources
09. Nested IF and IFS
10. SUMIF and COUNTIF
11. SUMIFS and COUNTIFS
12. Data cleaning techniques in Excel
13. Remove errors and blanks & download resources
14. Remove duplicates
15. Dividing data from single column
16. Replace and substitute
17. Left, right & mid
18. Concat, find and replace
19. Trim & case change
Master Excel Basics With Functions
Contact us for more information regarding the course.