I would be teaching basic to advance Excel which will be purely practical in nature. This will cover all aspects which is sufficient to get a good score in interviews and perform with excellence in your day to day work.

Topics Covered

Topics Covered would be (but not limited to) Formatting Cells and Paste Special Option (Shortcuts & Tricks) Sorting and Filtering Data Freezing Panes Grouping Text to Columns and Extracting Unique Values Types of Functions: – Text – Statistical and Mathematical Functions – Logical – Look up and Reference – Date and Time – General useful functions for day to day work (Will cover important aspects) Data Validation Excel Charts Pivot Tables and Reports Excel Tables & Related Tricks Basics of Dashboards Forms Control Making a Dashboard

Who should attend

Anyone who is looking for a new job and is already working which requires lot of Excel work on a day to day basis should attend

Pre-requisites

Laptop & Excel 2010 (2007 if not 2010)

What you need to bring

Laptop, Pen & Notepad

Key Takeaways

You would sure return with confidence and would start loving Excel for your work. Praise your boss and hiring manager with the Excel skills. You would surely learn how to think creatively and use of Excel to resolve issues faster and quicker