Introduction

1. Refresher on basic features of Excel
2. Excel Templates and creating your own Text styles
3. Advanced Pasting options

Learning about Tables and Pivots

1. Creating Tables and its features
2. Playing with data in tabular format
3. Create summaries
4. Making dynamic tabular representations

Working with Graphics and Shapes

1. Use of complex shapes and its use
2. Inserting and deleting objects
3. Formatting objects
4. Enhancing presentation of data

Introduction to charts

5. Few tips and shortcuts
6. Shortcuts to create charts
7. Quick graphical analysis tool
8. Customizing charts and graphs
9. Hands on graphical representations

Something more than just learning formulae’s

1. Learn most commonly used formulae’s
2. Practical scenarios on applicability of formulas
3. 3D referencing for formulae’s and formatting options
4. Shortcuts of looking at formulae’s

Playing with Data and make it comprehensible

1. Quick tricks in data mining
2. Embedding objects
3. Advanced selections options
4. Getting unique set of values
5. Using Text to columns
6. Inserting screenshots

Some Basic Analysis

1. Quick Analysis Tools
2. What if Analysis
3. Shortcuts to forecast data

Learning on Data mining and slicing and dicing the data

1. Creating, inserting and modifying hyperlinks
2. Using specialized pasting options
3. Moving and copying worksheets and cells

Additional Features

1. Work on daily reports and schedules using Calendars in Excel
2. Working with multiple scenarios in finance world
3. Shortcuts to conversions
4. Making excel file show results as “Live” web