Microsoft Excel, Word, PowerPoint Combined 3 Day Training With CoPilot

Section 1: Formulas and Functions 

Entering Formulas
Excel Arithmetic Operators
Using AutoFill Options
Commonly Used Functions

Section 2: Organizing Worksheet and 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: Working 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: Customizing & Enhancing Workbooks

Customizing Excel to Your Work
Creating Hyperlinks
Customizing Quick Access Toolbar

Section 7: Analyze and transform data with 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 pane to chat with Copilot in Word
Linking files in Copilot in Word
Facilitate Collaboration 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