A skill which is imperative in every organization is MS Excel. Whether you are an entry-level manager, or the CEO of your own company, without Excel running a business is hard. And you know it!

Come and master MS Excel in just 10 powerful sessions where we teach you from basics of Excel to advanced tools available in Microsoft Excel software.

The course Structure follows the following layout:

1. Introduction to Excel
1. What is Excel?
2. Interface walkthrough
3. Introduction to cells/rows/columns/references
2. Basic Operations & Formatting
1. Cell/row/column formatting
2. Table formatting & Quick data presentation
3. Conditional formatting basics
4. Basic operations
3. Essential functions and formulas
1. Basic formulas
2. Auto functions
3. Math functions
4. String functions
5. Logical functions
4. Data Organization & Basic visuals
1. Sorting & Filtering
2. Chart creation
3. Various elements of charts
4. Combo charts
5. Chart formatting
5. Advanced functions
1. Combined functions
2. Subtotal functions
3. Formula check & evaluation
6. Lookup functions
1. Index + Match
2. Lookup function
3. Vlookup / Hlookup
4. Xlookup
5. Restrictions of lookup functions
7. Pivot Tables
1. Creating a Pivot Table
2. Definition of 4 fields
3. Power of Pivots
8. Pivot Charts
1. Creating a Pivot Charts
2. Inserting sparklines
3. Inserting Slicers / Timelines
9. Visualising data
1. Creating MIS Dashboards
2. Merge/Append tables
3. Name Manager
4. Create drop down lists
10. Final session
1. Goto function
2. Goal seek function
3. Lock cells & sheets
4. Protect workbooks

At the end of each session, you will be given an assignment that will test your learning in that and the previous classes. With each session, you will grow stronger and more proficient in using MS Excel.