Book Online Tickets for Advance Excel Workshop, Bengaluru.  
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: 

Advance Excel Workshop

 

Invite friends

Contact Us

Page Views : 9

About The Event

 

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

 

 

 

More Events From Same Organizer

Similar Category Events

Venue Map