Advanced Excel Workshop

Microsoft Excel is one of the most powerful tools for managing and presenting data in today’s working environment. It is a must for anyone to have basic knowledge of Excel to make any job more manageable. Excel is excellent for data manipulation, analysis, and visualization; you can sort, filter, format, and chart your data all within one program.

Excel is the world's most-used spreadsheet program.


Quick Overview:

  • Duration: 20 Hours 

  • Number of Sessions: 4 Sessions (5 Hours per each)

  • One Day per week (Friday from 4 PM till 9 PM)

Register Now

Outline & Objective

Upon completion of this workshop, participants will be able to:

  • Build up data in Excel from scratch

  • Deals with numerical data in Excel

  • Basic Formulas & Functions in Excel

  • Align text data in Excel

  • Data Collection, gathering, and matching by using the proper and accurate Methods.

  • Using Power & Lookup functions- Inserting files & objects

  • The hyperlink between different sheets

  • Summarize and design the data quickly and accurately and report it with visual charts.

  • Data Validation Techniques

  • Using Pivot Tables

  • Date & Time Formatting & Calculations

  • Useful Human Resources Functions for Excel

  • The most common human resources sheets, formulas & metrics :(KPIs, Taxes, Insurance, Payroll Sheet,..)

  • Introduction to Data Analysis Basics

© Copyright. All rights reserved.