top of page

Microsoft Excel module, Office AdminExcel Training: Formulas to Macros
Microsoft Excel is ideal for entering, calculating and analyzing company data. Learn to organize data and gain insight with formulas, charts and PivotTables.
Book an appointmentCall 847-350-9034
10 topicsWeekly quizzesFinal project
Ten topics
From the basics to automation. 1Introduction
Interface, workbooks and worksheets, entering and formatting data.2Formulas and functions
Cell references, common functions, formula auditing.3Charts
Bar, pie and line charts, formatting, sparklines.4Data management
Sorting, filtering, validation, tables, duplicates.5Advanced functions
IF, AND, OR, VLOOKUP, HLOOKUP, INDEX, MATCH and text functions.6PivotTables
Grouping, summarizing, slicers and pivot charts.7What-If analysis
Scenario Manager, Goal Seek, data tables and Solver.8Advanced visualization
Combo and 3D charts, dashboards and form controls.9Macros
Recording, editing and assigning macros.10Collaboration
Sharing, protecting, Excel Online and add-ins.Course assessment
How learning is checked.Assessments
✓Weekly quizzes to assess understanding✓Hands-on projects to apply knowledge✓Final project: create a professional document showcasing various Excel skillsSupport and salient features
Career support and classroom features that come with the course.Staffing support
✓Resume preparation✓Mock interview preparation✓Phone interview preparation✓Face to face interview preparation✓Project and technology preparation✓Internship with internal project work✓Externship with client project workOur salient features
✓Hands-on labs and homework✓Group discussion and case study✓Course project work✓Regular quiz and exam✓Regular support beyond the classroom✓Students can re-take the class at no cost✓Dedicated conference rooms for group project work✓Live streaming for remote students✓Video recording to catch up on a missed classReady to master Excel?
Call 847-350-9034 or book an appointment to talk about this course and funding options.Book an appointmentCall 847-350-9034Education grant programTen topics
From the basics to automation.1Introduction
Interface, workbooks and worksheets, entering and formatting data.2Formulas and functions
Cell references, common functions, formula auditing.3Charts
Bar, pie and line charts, formatting, sparklines.4Data management
Sorting, filtering, validation, tables, duplicates.5Advanced functions
IF, AND, OR, VLOOKUP, HLOOKUP, INDEX, MATCH and text functions.6PivotTables
Grouping, summarizing, slicers and pivot charts.7What-If analysis
Scenario Manager, Goal Seek, data tables and Solver.8Advanced visualization
Combo and 3D charts, dashboards and form controls.9Macros
Recording, editing and assigning macros.10Collaboration
Sharing, protecting, Excel Online and add-ins.Course assessment
How learning is checked.1Assessments
✓Weekly quizzes to assess understanding✓Hands-on projects to apply knowledge✓Final project: create a professional document showcasing various Excel skillsSupport and salient features
Career support and classroom features that come with the course.1Staffing support
✓Resume preparation✓Mock interview preparation✓Phone interview preparation✓Face to face interview preparation✓Project and technology preparation✓Internship with internal project work✓Externship with client project work2Our salient features
✓Hands-on labs and homework✓Group discussion and case study✓Course project work✓Regular quiz and exam✓Regular support beyond the classroom✓Students can re-take the class at no cost✓Dedicated conference rooms for group project work✓Live streaming for remote students✓Video recording to catch up on a missed classReady to master Excel?
Call 847-350-9034 or book an appointment to talk about this course and funding options.Book an appointmentCall 847-350-9034Education grant program
bottom of page