INTERMEDIATE EXCEL
This programme is designed for those who have used excel consistently, for a minimum of two years and should be familiar with basic excel functions up to the IF STATEMENT and whose job functions will still require grater knowledge to …
Overview
This programme is designed for those who have used excel consistently, for a minimum of two years and should be familiar with basic excel functions up to the IF STATEMENT and whose job functions will still require grater knowledge to achieve efficiency.
Curriculum
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