top of page

MS Excel Module

 

 

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

1. Introduction to Microsoft Excel

  • Overview of Excel's interface

  • Navigating workbooks and worksheets

  • Entering and formatting data

  • Basic cell operations (cut, copy, paste)

2. Excel Formulas and Functions

  • Understanding cell references (absolute, relative, mixed)

  • Common Excel functions (SUM, AVERAGE, COUNT, MAX, MIN)

  • Creating and editing formulas

  • Using the Formula Auditing tools

3. Data Visualization with Charts

  • Creating various types of charts (bar, pie, line, etc.)

  • Formatting and customizing charts

  • Adding data labels and titles

  • Using Spark lines for in-cell mini-charts

4. Data Management Techniques

  • Sorting and filtering data

  • Data validation and drop-down lists

  • Removing duplicates

  • Working with tables and structured references

5. Advanced Excel Functions

  • Logical functions (IF, AND, OR)

  • Lookup and reference functions (VLOOKUP, HLOOKUP, INDEX, MATCH)

  • Text functions (CONCATENATE, LEFT, and RIGHT, MID)

6. Data Analysis with PivotTables

  • Creating PivotTables from large datasets

  • Grouping and summarizing data

  • Slicers and Pivot Charts

  • Calculated fields and items

7. Data Analysis with What-If Analysis Tools

  • Scenario Manager

  • Goal Seek

  • Data Tables

  • Solver for optimization problems

8. Advanced Data Visualization

  • Advanced charting techniques (combo charts, 3D charts)

  • Customizing and formatting charts further

  • Creating interactive dashboards

  • Using Form Controls for user interactivity

9. Automation with Macros

  • Introduction to Excel macros

  • Recording and editing macros

  • Assigning macros to buttons and objects

  • Best practices for macros

10. Collaboration and Data Sharing

  • Sharing workbooks and tracking changes

  • Protecting worksheets and workbooks

  • Introduction to Excel Online and co-authoring

  • Excel add-ins and integration with other Office apps

Course Assessment:

  • Weekly quizzes to assess understanding

  • Hands-on projects to apply knowledge

  • Final project: Create a professional document showcasing various Excel skills

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

Student Portal

Training / Service Center :

951 N. Plum Grove Rd.

Suite A, C
Schaumburg, IL, 60173

Ph: 847 350 9034 x option 1

Email: info@itexps.com

Service Center :

1560 Wall Street,

Suite #111,

Naperville, IL 60563 

Ph: 847 350 9034 x option 2

Email: info@itexps.com

Service Center :

2400 East Devon Ave. Suite#257
Des Plaines, IL 60018

Ph: 847 350 9034 x option 3

Email: info@itexps.com

IT Expert System, Inc is approved to operate by the Private Business and Vocational Schools Division of the Illinois Board of Higher Education.

IT Expert System, Inc is not accredited by a US Department of Education recognized accrediting body. IBHE Mandatory Disclosure Reporting

IT Expert System, Inc Training programs are approved by the Illinois State Approving Agency for the enrollment of qualified veterans and/or other eligible persons to receive Montgomery GI Bill® education benefits.

IT Expert System, Inc is regulated by: Indiana Department of Workforce Development, Office for Career and Technical School

10 N Senate Avenue, Suite SE 308, Indianapolis, IN 46204

OCTS@dwd.in.gov, http://www.in.gov/dwd/2731.htm

‘PMP’ and 'CAPM' are registered marks of the Project Management Institute, Inc.

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

bottom of page