Excel Advanced Training

12/11

Code Date Venue Fees Registration
12/11 23 - 27 Sep Cairo 1600 USD Register Now
12/11 14 - 18 Apr 2019 Cairo 1600 USD Register Now
12/11 06 - 10 Oct 2019 Cairo 1600 USD Register Now

 

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.


 Instructor:

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

Search in Courses

Download Training Plan 2018

Register Upcoming Courses