Excel Advanced Training

Code : IT003
Request In-house Training Proposal

 

This 30-Hours workshop is focused on the advanced Excel tools and features that goes beyond the basics and enable users to go from only editing and formatting sheets to creating their own advanced calculations and reports instead of working on previously prepared ones. This includes validating and transferring inputs to awesome meaningful data using the most advanced functions. In addition, you will learn other Excel advanced tools of data validation, analysis, and management, such as Goal Seek, Data Validation Tool, Conditional Formatting advanced tools, and more… 


Prerequisite:

Attendees need to have good practical knowledge in using Microsoft Excel. They need to be aware of basic Excel skills like entering and formatting data, sorting and filtering, using tables and charts, printing, and writing basic formulas.

The training is aimed at business users, admins, accountants, assistants, and all people who want to enhance their Excel knowledge beyond the regular basic common tasks, to become unique and more valuable asset in the work environment. 


Goals of the Training:

Mastering Excel most important functions

Creating integrated advanced workbooks with the concept of Inputs, valid outputs, and processing

Using Excel advanced analysis and management tools


Course Outline:

Module 1: Reviewing basic formulas and functions

Module 2: Using logical functions

Module 3: Using powerful summarizing functions

Module 4: Using different formations of lookup functions

Module 5: Manipulating text-using functions

Module 6: Performing advanced date and time calculations using the proper date and time functions

Module 7: Handling function errors and validating data input

Module 8: Advanced conditional formatting with formulas

Module 9: Pivot Tables review, and Introduction to PowerPivot

Module 10: Working with data analysis tools and the Solver tool

Module 11: Using Macros and creating forms in Excel

Outline is subject to be customized including several hands on tasks that fit 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.


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

10 - 14 Jan 2021
Cairo | Instructor-led
$2250
5 Sessions

Search in Courses