Sale Date Ended
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.
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.
Basic MS Excel.
Exercise files will be given for practice
Workshop timing: 9:30am to 4:00pm
NETCRAFTZ, #84, 1st Floor, Subanpalya, Banaswadi Main Road. Opp to Ayappa Temple. Bangalore - 560033
Formulae that Add/Subtract/Multiply/Divide
Working with Functions
Summing Non-Contiguous Ranges •Count/ Average/Maximum/Minimum Functions
Problems with Absolute/Relative Cell Referencing, Creating Absolute/Mixed References
Creating, Formatting Simple PivotTables • Page Field in a PivotTable • Formatting a PivotTable • Creating/Modifying a PivotChart
Creating dynamic dashboard using pivot table and charts
The VLOOKUP/HLOOKUP Functions • MATCH with VLOOKUP Functions
IF's and Nested IF Functions • Using AND/OR/NOT Functions
Using The TODAY • NOW & DATE Functions • Using The DATEDIF/ NETWORKDAYS/ EOMONTH 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