Microsoft Excel

Time: 24 hours



Course overview:


Microsoft Excel is a Desktop based electronic spreadsheet program for storing, manipulating and organizing data with easy to use interface. Excel is ideal for entering, calculating and analyzing company data such as sales figures, sales taxes or commissions. It can be used with any type of office data to quickly organize and gain insight. Excel can perform formula-based calculations and many other mathematical functions.

Course Content


Getting Started

  • Spreadsheet Concepts 

  • Overview of Microsoft Excel 

  • Setup Excel on your computer 

  • Explore the user interface 

Managing Worksheets and Workbooks

  • Create a blank workbook 

  • Creating Workbooks from templates 

  • Entering data in Worksheets 

  • Adding Worksheets to Workbook 

  • Managing Worksheets and Workbooks

      (Save, save in different formats, Open, Delete)



  • Formatting Columns, Cells and Rows  

  • Applying Colors 

  • Manipulating Rows, Columns and Cells 

      (Insert, Update, Delete) 

  • Page setup for printing 

  • Adjusting Margins, Rows & Column heights 

  • Customizing Views

      (Hiding and Displaying Rows and Columns) 

  • Managing Headers and Footers 

  • Merge and Split Cells 

  • Highlight tables 

Data Manipulation

  • Creating Tables 

  • Managing data tables (Create, Modify, Filter, Sort) 

  • Looking up data in tables 

  • Search for Data 

  • Cell Ranges 

  • Sorting the Data 

  • Filtering data 

  • Grouping the data 

Special notes:

Additional Theory + Labs


Formulas and Functions 

  • Using inbuilt functions 

  • Using Cell ranges with functions 

  • Summarizing data with functions (SUM, AVERAGE, MIN, MAX, COUNT) 

  • Conditional logic 

  • Applying formulas to cell ranges 

  • Copying formulas to new cells  

  • Using Date functions 

  • Using Text function

Charts and Objects 

  • Creating charts and Graphs 

  • Configuring Charts and Graphs (Series, Data Ranges, Grouping) 

  • Formatting Charts - Adding Legends, Resizing, Modifying parameters, Layouts and styles 

  • Creating Formatting objects – Inserting Control objects like 

  • Text Boxes 

  • Smart Arts 

  • Images 

  • Borders 

  • Formatting objects – Object Positions, Colors, backgrounds, changing properties 

Staffing Support
  • Resume Preparation

  • Mock Interview Preparation

  • Phone Interview Preparation

  • Face to Face Interview Preparation

  • Project/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 / Exam

  • Regular support beyond the classroom

  • Students can re-take the class at no cost

  • Dedicated conf. rooms for group project work

  • Live streaming for the remote students

  • Video recording capability to catch up the missed class


951 N Plum Grove Rd, Suite B,

Schaumburg IL 60173

Branch Office:

1560 Wall Street, Suite #111,

Naperville, IL 60563

Branch Office:

O'Hare Lake Office Park,

2400 East Devon Ave, Suite #257

Des Plaines, IL 60018

Tel: 847 350 9034

  • LinkedIn Social Icon
  • Facebook Social Icon

Disclaimer: At this time, we are not offering any training programs for Nebraska residents.

 'PMP' and 'PMI' are registered marks of the Project Management Institute, Inc.

'GI Bill' is a registered trademark of the U.S. Department of Veterans Affairs (VA).

InfoTekGuide - A Leading IT Training Provider in Schaumburg and Naperville