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: 18
Pre-Requisites
- Computer/laptop
- MS Excel installed on system
- Dedicated Internet connection
- Zoom connection
top of page
₹500.00Price
Related Products
bottom of page