About the Course

This 24-Hours workshop is an entry level training designed especially for beginners to help them get their work done with the power of Excel, with not only the basics, but also the powerful tools that have become essential in the regular tasks of today’s work. This includes organizing data, performing basic calculations and preparing smart visualizations and outstanding reports, and many other tasks and tools that are generally related to business.

Prerequisite: Attendees need to have good practical knowledge in using computers and MS Windows operating system.

The training is aimed at business users, admins, and all people who want to learn the Excel basics and powerful tools and integrate them in their work.

Goals of the Training:

• Getting familiar with Excel environment
• Creating and managing Excel workbooks and worksheets
• Entering and formatting data
• Using visualizations, illustrations and hyperlinks
• Performing basic calculations using formulas and basic functions
• Creating Pivot Tables
• Creating charts and Pivot Charts
• Printing and sharing workbooks and worksheets

Course Modules:

Module 1: Discovering Excel Environment

Module 2: Managing Workbooks and worksheets

Module 3: Entering data and formatting cells

Module 4: Organizing, sorting and filtering data

Module 5: Creating Charts and Sparklines

Module 6: Preparing reports using Pivot Tables and Pivot Charts

Module 7: Formulas and calculation basics

Module 8: Using summary functions

Module 9: Using If function

Module 10: Printing and sharing workbooks

Outline is subject to be customized including several hands on tasks that fits in the basic needs of the attendees.

Hands-on Tasks:

Bring your own laptop to run and follow up the exercises and tasks provided by the instructor. To be sure that you can perform all tasks, the most recent version of MS Office is required. The outline and hands-on tasks can be customized to fit the version you use in your company.