top of page

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

Learn Microsoft Excel

₹500.00Price
  • Duration

    60min

  • Age Group

    8-16yrs

  • Available Time Slot

    Check the latest batch/private session timings

    Mail Or WhatsApp

Related Products