Excel Essential Training

Code : IT023
Request In-house Training Proposal

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.



Ayman Hassan has been working with Excel since 2006. He used the different versions of the software starting with Office 2000 up to Office 2016. He delivered courses on Excel and Office using Excel 2007 and all later versions to wide range of audiences including HR managers, seniors and specialists, senior accountants and financial managers, Engineers, teachers, and students.

More info at: http://eg.linkedin.com/in/aymanhassanmct

Apply now
Course Details
Personal Details
ACAD Professional Certificate - APC
ACAD Training & Consulting uses the power of its network to bring about positive, tangible change. We champion the training courses profession and the interests of individuals, engaged in that profession, for the benefit of all. ACAD Professional Certificates are designed for those who are enthusiastic to challenge themselves to reach the extra mile. Participants who fully attend an APC course and successfully pass the exam on the last training day, will receive an ACAD Professional Certificate (APC). APC are regionally recognized and can be esteemed when applying for more senior roles in Egypt and MENA region.

Exam Details:

Duration: 1 hour | Multiple Choice | Closed book | Pass mark: 65%

Course Schedule

Course Location and Date

04 - 08 Apr 2021
Cairo | Instructor-led
5 Sessions

Course Location and Date

22 - 26 Aug 2021
Cairo | Instructor-led
5 Sessions

Course Location and Date

26 - 30 Dec 2021
Cairo | Instructor-led
5 Sessions

Search in Courses