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: 15 Hours 

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

• Two Day per week.

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