Following are the topics covered for MS Excel :
 
Overview of Basics
- Introduction to MS EXCEL
- MS Excel Interface
 
Data Management
- Data Creation
- Data Editing / updation
- Cell Referencing (Absolute & Relative)
- Creation and using Named ranges
- Data Formatting & Conditional Formatting 
 
Data Sorting & Filtering
- Sorting tables
- Filtering data using Auto Filter
 
Data Validation & Forecasting
- Data importing / exporting 
- Data Validation
- Importing data from Text File, HTML/Website 
- What if Analysis
- Using Excel forms for data management 
 
Working with Excel Functions
- Mathematical Functions
- Logical Functions - including Vlookup, Hlookup etc
- String Functions
 
Using various Graphs & Charts
- Different types of Graphs
- Using Trend lines / Spark lines 
 
Working with Reports
- Pivot Tables
- Pivot Charts
- Creating and Using Slicers 
- Multiple sheets Data Consolidation 
- Sub-Total creation in Pivots
- Creation of Dashboards
 
Data protection
- Data-Range Protection
- Locking & Hiding Data
- Worksheet Protection 
- Workbook Protection 
 
Introduction to Macros
Time Saving techniques in Excel
- Working with Ready made Excel Templates
- Using Worksheet Short Cuts
 
Minimum No. Sessions: 12
 
Pre-Requisites 
- Computer/laptop 
- MS Excel installed on system 
- Dedicated Internet connection
- Zoom connection