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.

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%