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.

Company's Profile

NETCRATZ is an EC-Council accredited Training and Examination Center for CEH (Certified Ethical Hacker), located at Banaswadi, BANGALORE. We have more than 15 years of experience in retail and Corporate training. We have conducted several Workshop and Seminars on various topics like Networking, Hacking, Server Management, Android and many more.

Workshop Details

Pre-requisites:  
Basic MS Excel.

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

Workshop timing: 9:30am to 4:00pm

Venue:
NETCRAFTZ, #84, 1st Floor, Subanpalya, Banaswadi Main Road. Opp to Ayappa Temple. Bangalore - 560033

Workshop Topics
Formulae                                                                 
Formulae that Add/Subtract/Multiply/Divide
Working with Functions
Summing Non-Contiguous Ranges •Count/ Average/Maximum/Minimum Functions
Absolute Referencing
Problems with Absolute/Relative Cell Referencing, Creating Absolute/Mixed References
PivotTables
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.
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