Microsoft Office Tools

Day 1

Outlook Essentials

• Get Started and Connect Accounts

•  Read Mail

•  Organize Mail

• Create and Send Mail

• Create Contacts and Work with People

• Use Outlook's Accessibility Features

• Work with Delegates

• Work with the Calendar

• Work with Tasks and Settings

Day 2

Introduction to Microsoft Word

• Document Views

• Entering and Editing Text

• Saving and Opening Documents

• Navigating and Selecting Text

• Editing, Copying, and Moving Text

• Formatting Documents

• Using Bulleted and Numbered Lists

• Using Tabs

• Introduction to Tables

• Inserting Pictures

• Page Layout and Printing

• Introduction to Styles, Themes, and Templates

• Managing Bulleted and Numbered Lists

• Customizing Tables and using Formulas

• Inserting Text Objects

• Inserting Graphic Objects

• Using Quick Parts

• Multi-Section Documents

• Headers and Footers in large documents

• Proofing Tools

Day 3

Introduction to Microsoft PowerPoint

• Creating a Presentation

• Entering and Editing Text

• Managing Text

• Text Boxes and Tables

• Pictures and Drawings

• SmartArt and Charts

• Presentation Designs and Formatting

• Printing PowerPoint Presentations

• Simple Animations

• Running Slide Shows

• Integrating with Word and Excel

• Managing Slide Masters

• Multimedia Objects

• Custom Animations

• Collaborating with Colleagues

• Publishing a Presentation

• Preparing and Presenting a Show

Day 4

Introduction to Microsoft Excel

• Entering and Amending Data

• Saving and Opening Workbooks

• Navigating and Selecting Ranges

• Entering Formulas

• Inserting/Deleting Rows and Columns

• Formatting Worksheets

• Using Simple Functions

• Copying, Moving and AutoFill

• Relative vs. Absolute References

• Previewing and Printing

• Find and Replace

• Introduction to Range Names

• Using Multiple Worksheets

• Cell Styles and Conditional Formatting

• Paste Special

• Text and Date Formulas

• IF Function

• Using Charts

• Sorting and Filtering Lists

• Using Tables

• SmartArt and Drawings

• Comments and Hyperlinks

• Importing and Exporting Data

• Managing Range Names

• Date and Time Formulas

• Custom Formats

• IF and Related Functions

• VLOOKUP and Related Functions

• Advanced Filter / Subtotals

• Database Functions

• Multiple Workbooks / Consolidation

• Data Validation

• Auditing

• Pivot Tables

• Shared Workbooks / Tracking

• Protecting Worksheets

• Using Templates

Day 5

Power BI Essential

• Get started with Power BI

• Get Data

• Create a report with Visualizations

• Modify and print a report

• Create a dashboard

• Ask questions about your data

• share data with colleagues and others

• Using Power BI mobile apps

• Using Power BI desktop