The workshop is conducted over 16 hours over 2 days with a break for lunch. Participants are provided with an Excel workbook with examples and exercises which are demonstrated by the faculty and then practiced by each participant individually.

Topics Covered

Keyboard Shortcuts Sorting, Filtering Date / Time functions Logic functions String functions Finance functions Engineering functions Statistical functions Database functions Lookup functions Mathematical functions Data consolidation Pivot Table Protection Importing Data (csv, txt) Data Validation Conditional Formatting Hyperlinks Exporting to Powerpoint Charts

Who should attend

Working Professionals

Pre-requisites

Basic Knowledge of Ms-Excel

What you need to bring

Laptop with Ms-Excel 2007/10.

Key Takeaways

The session helps participants to • Increase productivity • Create dashboards • Eliminate errors • Cut down costs • Automate repetitive tasks