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 Covered

Module 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 attend

This 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-requisites

Participants 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 bring

1) 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