Curriculum
- 4 Sections
- 27 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- DATA PRESENTATION AND REPORTING10
- 1.1Overview5 Minutes
- 1.2Report transpose7 Minutes
- 1.3Data Filtering – 25 Minutes
- 1.4Data Validation and Restrictions – 18 Minutes
- 1.5Data Validation and Restrictions – 28 Minutes
- 1.6File and Sheet Restriction Using Password – 27 Minutes
- 1.7Handling Duplicate Items7 Minutes
- 1.8Pivot Table Analysis10 Minutes
- 1.9Document Printing – Single Page Document6 Minutes
- 1.10Document Printing – Multiple Pages10 Minutes
- WORKING WITH FUNCTIONS9
- 2.1CELL REFERENCE6 Minutes
- 2.2SUM and SUMIF6 Minutes
- 2.3AVERAGE and AVERAGEIF7 Minutes
- 2.4IF and Nested IF8 Minutes
- 2.5CONCATENATE and AMPERSAND3 Minutes
- 2.6TEXTJOIN, FLASH FILL and CONCAT6 Minutes
- 2.7TRIM, TEXT TO COLUMNS and FLASH FILL5 Minutes
- 2.8COUNTIF, COUNTIFS and FREQUENCY9 Minutes
- 2.9IFS and RANK6 Minutes
- THE LOOKUP FUNCTIONS8
- Questions1
Company
Course Categories
Copyright © 2024. Tabs & Icons Consulting Limited. All rights reserved. Site by TLC CREW