•  Introduction 
•  Getting started on Windows, macOS, and Linux 
•  How to ask great questions 
•  FAQ’s 

Excel Overview
Start Excel Spreadsheet
Enter Text and Numbers
Relative References
Working with ranges
Save and Save as Actions
File Extensions, Share, Export, and Publish files

Adding rows and columns to a table
Modifying Rows and Column lengths

Copy, Cut, and Paste
Copying Formulas

Page setup options
Fit to print on One Page
Print Workbooks

Sorting Data Ascending Order
Sorting Data Descending Order
Filter Data

Creating Basic Formulas
Datetime Formulas
Mathematical formulas phase1
Mathematical formulas phase2

VLOOKUP formula
HLOOKUP formula

XLOOKUP
Handling #NA and Approximates match in XLOOKUP

Split Text into columns
Flash Fill
Data Validation
Remove Duplicates
Import Data from Text files
Import Data from .CSV files

Formatting Font
Formatting Alignment
Formatting Numbers
Formatting Date
Formatting Tables

Pivot Tables
Pivot Charts

Excel Charts – Categories
Elements of a chart
Creating Charts
Column or Bar charts
Formatting Charts
Line Charts
Pie and Doughnut charts

Overview
Start PowerPoint Presentation
Screen setting and Views

Presentation Tips and Guidelines
Creating a New Presentation
Working with Slides
Save a Presentation
Print Slides

Formatting text
Slide Text Alignments
Multi-Column Text Alignments
Adding Bullets and Numbered List Items

Insert Shapes
Insert Icons
Insert Graphics
Add 3D Models
Insert Pictures

Picture Options
Picture Cropping
Applying Built-in Picture Styles

Add SmartArt Graphic
Modifying SmartArt
Creating a Target Chart using SmartArt

Create a Table on Slide
Formatting Tables
Inserting Tables
Table Layouts

Add a Chart
Formatting Charts
Insert Chart from Microsoft Excel

Adding Video to a Presentation
Adding Audio to a Presentation
Screen Recording and Adding

Applying Transitions to Presentation

Object Animation
Effect Options
Advanced Animation
Triggers to control animation

Onscreen Presentation
Hiding Slides
Changing Order of Slides
Copying Slides

Overview of MS Word
Start MS Word 2021

Create a new blank document
Creating a paragraph text
Non-printing characters
Save a document
Open a document
Find and replace

AutoCorrect options
Formatting text
Copy cut and paste
Character formatting
Format painter
Work with numbers
Add bullets
Outline creation

Creating a table
Adding rows and columns to a table
Formatting table data
Borders and shading
Sorting in a table
Draw a table
Convert text to table
Convert table to text
Insert a spreadsheet
Quick tables – readily available formats

Working with styles
Creating styles
Clear formatting

Margins
Orientation
Page size setting
Adding columns
Page break – section break
Adding watermark
Headers and footers

Create envelops
Creating labels

Creating a mail merge document

Thesaurus and spell check
Word count
Speech – read aloud
Language – translate
Tracking