Basic MS Excel Course Details

Objective:

To introduce new users to Microsoft Excel and provide foundational skills for creating spreadsheets, performing simple calculations, and organizing data.

Duration:

3 Months

Key Topics:

Introduction to Excel

Excel interface: Ribbon, tabs, workbook, worksheet
Understanding rows, columns, cells
Creating, saving, and opening workbooks

Data Entry and Formatting

Entering text, numbers, and dates
Cell formatting (font, color, alignment)
Using number formats (currency, percentage, etc.)
Adjusting column width and row height

Basic Formulas and Functions

Introduction to formulas: =SUM(A1:A5), =AVERAGE(), =MIN(), =MAX()
AutoSum and Quick Analysis tools
Copying formulas (relative vs. absolute references)

Managing Worksheets

Insert, rename, delete, move, copy sheets
Freeze panes, split screen
Page layout and printing basics

Sorting and Filtering Data

Sorting (A-Z, Z-A, custom)
Basic filtering using Filter tool

Charts and Visualization

Creating basic charts (Column, Line, Pie)
Formatting charts and adding labels

Basic Data Validation

Drop-down lists
Restricting cell input (e.g., only numbers)

Advanced MS Excel Course Details

Objective:

To equip users with powerful tools and techniques for data analysis, automation, and advanced reporting using Excel.

Duration: 6 Months ( Including 3 months of Basic MS Excel )

Key Topics:

Advanced Formulas and Functions

Logical: IF, IFS, IFERROR
Lookup: VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP
Text: LEFT, RIGHT, MID, TEXT, CONCATENATE, TEXTJOIN
Date and Time: TODAY, NOW, DATEDIF, NETWORKDAYS
Array formulas and dynamic arrays (FILTER, SORT, UNIQUE)

Data Tools

Data validation (advanced options)
Consolidate data from multiple sheets
Remove duplicates
Flash Fill

PivotTables and PivotCharts

Creating PivotTables from large datasets
Customizing fields, filters, slicers
Grouping data in PivotTables
Using calculated fields

Conditional Formatting (Advanced)

Rules using formulas
Heat maps, data bars, icon sets

Advanced Charting Techniques

Combination charts (e.g., bar + line)
Dynamic charts with dropdowns
Sparklines

Macros and VBA (Optional for Advanced Users)

Recording Macros
Understanding the VBA editor
Writing basic VBA scripts

Power Query (Get & Transform)

Importing data from different sources
Cleaning and transforming data
Merging and appending queries

Power Pivot and Data Modeling

Creating relationships between tables
Using DAX functions (CALCULATE, RELATED, etc.)

Collaboration & Security

Protecting sheets/workbooks
Sharing workbooks
Tracking changes

Events

SWATI SHARMA