About the Course
This workshop will start with a brief introduction on basic Excel 2007 and then we shall do hands on about the Advanced Excel 2007 features. In the workshop all popular Excel 2007 functions will be discussed.
Topics CoveredModule 1: Conditional Functions
Module 2: Lookup Functions
Module 3: Cell Restriction
Module 4: Conditional Formatting
Module 5: Working with Pivot Table
Module 6: Auditing
Module 7: Working with Charts
Module 8: Data Handling
Module 9: Protection
Module 10: Macros
Who should attendThis course will help organizations and as well as professionals, to enrich with features of Advanced Excel 2007, thus increasing the organizational effectiveness and productivity.
Pre-requisitesParticipants should understand the basic concepts of creating an Excel Spreadsheet, writing mathematical expression, using basic functions like sum, max, min, average and count, using sort, auto filter, subtotal, etc.
What you need to bring1) ID Card for individual identification
2) Personal Laptops are preferable
3) Other documents for registration formalities
Key Takeaways# Create more powerful reports within a less amount of time
# Do complex conditional calculation efficiently
# Check and resolve the errors
# Record macros