MS Excel Basics to Intermediate
Introduction to MS Excel:
Overview of the Excel
interface and navigation.
Creating and saving workbooks.
Basic text, number, and date
formatting.
Adjusting column width, row
height, and cell alignment.
Basic Formulas and Functions:
Simple arithmetic formulas:
SUM, AVERAGE, COUNT.
Logical functions: IF, AND,
OR.
Text functions: CONCATENATE,
LEFT, RIGHT, MID.
Date and time functions:
TODAY, NOW, DATE, YEAR.
Working with Data:
Sorting and filtering data.
Using Find and Replace tools.
Using Excel Tables for
structured data.
Data Visualization with Charts:
Creating basic charts: Column,
Line, Pie, Bar.
Customizing charts with
labels, titles, and legends.
Working with different chart
types based on data.
Introduction to PivotTables:
Creating basic PivotTables.
Summarizing data with
PivotTables.
Filtering data within
PivotTables.
Advanced MS Excel Features
Advanced Formulas and Functions:
Lookup functions: VLOOKUP,
HLOOKUP, INDEX, MATCH.
Conditional formatting for
dynamic data visualization.
Advanced text functions: FIND,
SUBSTITUTE, TEXT.
Array formulas and their
applications.
Advanced Data Analysis with PivotTables:
Grouping data in PivotTables.
Creating calculated fields and
calculated items.
PivotCharts for graphical
representation of data.
Data Validation and Protection:
Setting up data validation
rules.
Creating drop-down lists and
custom data validation.
Protecting cells and
worksheets for security.
Excel Macros and Automation:
Introduction to macros:
Recording and running macros.
Editing macros in VBA (Visual
Basic for Applications).
Automating repetitive tasks
using macros.
Collaborative Features and Final Review:
Sharing and collaborating on
Excel files.
Protecting and tracking
changes in shared documents.
Final hands-on practical
exercises to test key concepts.
