ADVANCED OFFICE PACKAGE

Enroll View Details

Course Synopsis

MS Excel - Level 1 course is designed to teach essential Excel skills, including navigating the user interface, worksheet calculations, basic math, statistics, and logic functions. MS Excel - Level 2 course is designed for beginners who wish to learn how to Create Charts, Analyze Data using Pivot Tables, Slicers and Pivot Charts, Goal Seek and Solver, and Use Macro in Microsoft Excel. MS Excel-Level 3 is designed to learn syntax, near match techniques, and effective lookup table management. Handle missing data seamlessly. Ideal for Excel users seeking advanced data retrieval skills.

Required Textbooks 

1. Excel All-in-one for Dummies 2019. 
2. Book 2: Slaying the Excel Dragon: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun.
3. Book 3: Excel Basics in 30 Minutes (3rd Edition): The Quick Guide to Excel and Google Sheets.

Completion Criteria

After fulfilling all of the following criteria, the student will be deemed to have finished the Module: 

1. Has attended 90% of all classes held.
2. Has received an average grade of 80% on all assignment. 
3. Has received an average of 60% in assessments.
4. The tutor believes the student has grasped all of the concepts and is ready to go on to the next module.

Prerequisites

1. There is no prior educational level requirement for this course. 
2. If you are only interested in theory and have no interest/patience in spending at least 10 hours every week throughout the duration of the course, then this course might not be for you.
3. If you have absolutely no idea about programming or do not see yourself doing programming in the next six -odd months, then this class may not be for you!