top of page
Hero background

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. 1

Introduction

Interface, workbooks and worksheets, entering and formatting data.
2

Formulas and functions

Cell references, common functions, formula auditing.
3

Charts

Bar, pie and line charts, formatting, sparklines.
4

Data management

Sorting, filtering, validation, tables, duplicates.
5

Advanced functions

IF, AND, OR, VLOOKUP, HLOOKUP, INDEX, MATCH and text functions.
6

PivotTables

Grouping, summarizing, slicers and pivot charts.
7

What-If analysis

Scenario Manager, Goal Seek, data tables and Solver.
8

Advanced visualization

Combo and 3D charts, dashboards and form controls.
9

Macros

Recording, editing and assigning macros.
10

Collaboration

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 skills

Support 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 work

Our 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 class

Ready 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

Ten topics

From the basics to automation.1

Introduction

Interface, workbooks and worksheets, entering and formatting data.
2

Formulas and functions

Cell references, common functions, formula auditing.
3

Charts

Bar, pie and line charts, formatting, sparklines.
4

Data management

Sorting, filtering, validation, tables, duplicates.
5

Advanced functions

IF, AND, OR, VLOOKUP, HLOOKUP, INDEX, MATCH and text functions.
6

PivotTables

Grouping, summarizing, slicers and pivot charts.
7

What-If analysis

Scenario Manager, Goal Seek, data tables and Solver.
8

Advanced visualization

Combo and 3D charts, dashboards and form controls.
9

Macros

Recording, editing and assigning macros.
10

Collaboration

Sharing, protecting, Excel Online and add-ins.

Course assessment

How learning is checked.1

Assessments

✓Weekly quizzes to assess understanding✓Hands-on projects to apply knowledge✓Final project: create a professional document showcasing various Excel skills

Support and salient features

Career support and classroom features that come with the course.1

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 work
2

Our 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 class
 

Ready 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
ITExps Assistant
Hello! I am your ITExps assistant. How can I help you today?