Advance Excel Workshop

Overview of the Workshop

Intermediate and Advance level one day Workshop on MS Excel. The focus of the workshop is to increase the efficiency of individuals in working with Ms Excel.

Workshop Details

Pre-requisites: 
Basic MS Excel.

Benefits: 
100% Practical
Participation Certificate
Exercise files will be given for practice

Workshop timing: 10:00am to 5:00pm

Workshop Topics
                                                              
Creating, Formatting Simple PivotTables • Page Field in a PivotTable • Formatting a PivotTable • Creating/Modifying a PivotChart
Dashboards, Creating dynamic dashboard using pivot table and charts
LOOKUP Functions
The VLOOKUP/HLOOKUP Functions • MATCH with VLOOKUP Functions
Logical Functions
IF's and Nested IF Functions • Using AND/OR/NOT Functions
Date/Time Functions
Using The TODAY • NOW & DATE Functions • Using The DATEDIF/ NETWORKDAYS/ EOMONTH Functions.
Text Functions
Using The MID/ SEARCH/ LEFT/ RIGHT Functions • Using The TRIM/ CLEAN/ UPPER/ LOWER Functions.
Power Functions
Countif, Sumif, Averageif
Chart Data Techniques
The Chart Wizard • Chart Types • Adding Title/Legends/Lables • Printing Charts • Adding Data to a Chart • Formatting/Renaming/Deleting Data Series • Changing the Order of Data Series