Word, Excel, PowerPoint & Copilot in Microsoft 365 Office

Section 1: Formulas and Functions 

Entering Formulas
Excel Arithmetic Operators
Using AutoFill Options
Commonly Used Functions

Section 2: Organize Worksheet & Table Data

Create and Modify Tables
Sort and Filtering Data
Get Summary Information in a Table

Section 3: Working with Charts

Summarizing Data Using Charts
Customizing Chart Data
Format Chart Legend and Titles
Creating a Pie Chart

Section 4: Work with Graphics

Add Pictures into a Worksheet
Customize Pictures and Objects
Add Drawing Objects
Add SmartArt

Section 5: Managing Large Workbook

Manage Large Workbook Printing
Worksheets Setting
Page Setup Options

Section 6: Customize & Enhance Workbooks

Customizing Excel to Your Work
Creating Hyperlinks
Customizing Quick Access Toolbar

Section 7: Microsoft 365 Copilot in Excel

Analyze your data
Transform your data
Add Tables
Add Charts
Sort & Filter Data

Section 1: Manage documents

Format documents
Save and share documents
Insert text and paragraphs
Format text and paragraphs
Create and configure document sections

Section 2: Manage tables and lists

Create tables
Modify tables
Create and modify lists

Section 3: Create and manage references

Create and manage reference elements
Create and manage reference tables

Section 4: Insert and format graphic elements

Insert illustrations and text boxes
Insert shapes
Insert pictures
Insert SmartArt graphics
Insert screenshots and clips
Insert text boxes
Format illustrations & text boxes
Add text to graphic elements

Section 5: Manage document collaboration

Add and manage comments
Manage change tracking

Section 6: Maximize the AI features using Copilot in Microsoft Word

Draft a new document
Use the Copilot chat in Word
Linking files in Copilot in Word
Collaborate using real-time coauthoring

Section 1: Working With Text 

Using an Outline Adding Text Using Bullets and Numbering Formatting Text & Paragraphs Using Text Boxes Setting Tabs

Section 2: Adding Multimedia Elements

Using Multimedia Elements Working With Pictures Applying Styles & Effects Modifying Hyperlinks Working With SmartArt

Section 3: Enhancing Presentations

Adding Audio & Video Media
Using Animation
Managing Multiple Transitions
Changing Animation Order
Using Slide Transitions

Section 4:  Preparing The Slide Show

Reviewing The Presentation Customizing the Presentation Proofing the Presentation Setting up a Slide Show Using Presentation Tools
Using Presenter View Rehearsing a Presentation Presenting The Slide Show

Section 5: Design captivating presentations with Microsoft 365 Copilot in PowerPoint

Create a new presentation
Transform written documents into presentations
Adjust layouts, reformat text, and time animations