Mastering Advanced MS Office : Skills to the Next Level!

From advanced formatting and data analysis in Excel to creating dynamic presentations in PowerPoint, you'll learn how to leverage the full potential of Microsoft Office applications. Discover time-saving features, automation tools, and best practices that will streamline your workflow and boost your efficiency.

Key Features:

• In-depth training on advanced features of Microsoft Word, Excel, PowerPoint, and Outlook
• Hands-on exercises and real-world examples to reinforce learning
• Expert guidance from experienced instructors with extensive Microsoft Office expertise
• Practical tips and tricks to increase productivity and effectiveness

Our Course Covers

Session 1: Getting Familiar

• 1.01 Introduction
• 1.02 Interface Overview
• 1.03 Common Buttons, Tabs and Ribbons

Session 2: Document Navigation Tips

• 2.01 Introduction
• 2.02 How Navigation Tips Help
• 2.03 Using The Slider
• 2.04 Keyboard Navigation Tips
• 2.05 Using Browse Objects Tools
• 2.06 Selecting Text Options

Session 3: Manipulating Text

• 3.01 Introduction
• 3.02 Page Layout
• 3.03 Cut, Copy, Paste, Move
• 3.04 Find and Replace

Session 4: Formatting Characters

• 4.01 Introduction
• 4.02 How Formatting Makes a Difference
• 4.03 Changing Fonts
• 4.04 Typical Text Format Options
• 4.05 Bullet and Numbered Lists
• 4.06 Other Formatting Tools

Session 5: Formatting Paragraphs

• 5.01 Introduction
• 5.02 Line Spacing
• 5.03 What Are Quick Styles
• 5.04 More Quick Styles
• 5.05 Creating A New Quick Style
• 5.06 Paragraph Marks

Session 6: Themes and Templates

• 6.01 Introduction
• 6.02 Applying Themes
• 6.03 Opening Existing Templates
• 6.04 Creating Templates
• 6.05 Working With Existing Content

Session 7: Quick Parts

• 7.01 Introduction
• 7.02 Quick Parts - Options
• 7.03 Creating Quick Parts
• 7.04 Quick Parts - Inserting Fields
• 7.05 Quick Parts - Inserting Images

Session 8: Preparing Documents for Printing

• 8.01 Introduction
• 8.02 Spelling and Grammar Check
• 8.03 Saving A Document
• 8.04 Printing And Preview Options

Session 9: Organizing Content

• 9.01 Introduction
• 9.02 Creating Lists
• 9.03 Creating and Formatting Tables
• 9.04 Converting Text To Tables
• 9.05 Table Borders and Shading

Session 10: Tabs, Columns, and Charts

• 10.01 Introduction
• 10.02 Creating Columns
• 10.03 Creating Tabular Lists
• 10.04 Creating Charts

Session 11: Links, Headers, and Footers

• 11.01 Introduction
• 11.02 Creating Web Links
• 11.03 Creating Document Location Links
• 11.04 Creating Email Links
• 11.05 Creating Headers and Footers

Session 12: References

• 12.01 Introduction
• 12.02 Bookmarks
• 12.03 Captions
• 12.04 Footnotes
• 12.05 Citations
• 12.06 Reference Styles for Research
• 12.07 Research Options
• 12.08 Creating Indexes
• 12.09 Bibliographies
• 12.10 Table of Figures
• 12.11 Table of Contents
• 12.12 Cross Reference Bookmarks
• 12.13 Cross Reference Page Numbers

Session 13: Mail Merge

• 13.01 Introduction
• 13.02 Mail Merge for Letters
• 13.03 Mail Merge for Envelopes
• 13.04 Mail Merge for Labels

Session 14: Visual Content

• 14.01 Introduction
• 14.02 Character Spacing
• 14.03 Inserting Shapes
• 14.04 Inserting Images
• 14.05 Using Word Art
• 14.06 Using Pull Quotes
• 14.07 Using Text Boxes
• 14.08 Sorting Text
• 14.09 Using Smart Art

Session 15: Reviewing Documents

• 15.01 Introduction
• 15.02 Document Views
• 15.03 Split Screen View
• 15.04 Tracking Changes
• 15.05 Collaboration Options
• 15.06 Combining and Approving Changes
• 15.07 Using Comments

Session 16: Protecting and Sharing Documents

• 16.01 Introduction
• 16.02 Compatibility Checker
• 16.03 Previous Word Versions Compatibility
• 16.04 Digital Signatures
• 16.05 Restricting Permissions

Session 1: Introduction

• 1.01 Introduction
• 1.02 Interface
• 1.03 Tabs and Ribbons
• 1.04 Document Windows
• 1.05 Navigation Tips
• 1.06 Office Button and Save

Session 2: Entering, Editing and Formatting Data

• 2.01 Introduction
• 2.02 Entering Data
• 2.03 Fonts, Fills, and Alignment
• 2.04 Cut, Copy, and Paste
• 2.05 Paste Special
• 2.06 Undo and Redo
• 2.07 Moving, Finding, and Replacing a Value
• 2.08 Cell Styles
• 2.09 Comments

Session 3: Formatting Numbers

• 3.01 Introduction
• 3.02 Currency Format
• 3.03 Format Painter
• 3.04 Formatting Dates
• 3.05 Custom and Special Formats

Session 4: Managing Worksheets

• 4.01 Introduction
• 4.02 Naming and Moving Worksheets
• 4.03 Copying Worksheets
• 4.04 Adding, Deleting and Hiding Worksheets
• 4.05 Grouping Worksheets
• 4.06 Moving, Copying, Deleting and Hiding Grouped Worksheets

Session 5: Modifying Rows and Columns

• 5.01 Introduction
• 5.02 Inserting and Deleting Columns and Rows
• 5.03 Inserting & Deleting Cells
• 5.04 Inserting Multiple Columns & Rows
• 5.05 Modifying Cell Width and Height
• 5.06 Hiding and Unhiding Rows and Columns

Session 6: Understanding Formulas

• 6.01 Introduction
• 6.02 Using Operations
• 6.03 Creating Formulas
• 6.04 AutoSum
• 6.05 Common Formulas
• 6.06 Searching for Formulas
• 6.07 Copying Formulas
• 6.08 Using Relative and Absolute References

Session 7: Changing Views

• 7.01 Introduction
• 7.02 Workbook Views
• 7.03 Show/Hide
• 7.04 Zoom Features
• 7.05 Freeze Panes
• 7.06 Split Windows
• 7.07 Viewing Multiple Windows
• 7.08 Minimize The Ribbon
• 7.09 Worksheet Backgrounds
• 7.10 Watermarks

Session 8: AutoFill and Custom Lists

• 8.01 Introduction
• 8.02 AutoFill a Series
• 8.03 AutoFill Non-Adjacent Cells
• 8.04 AutoFill on Multiple Sheets
• 8.05 Creating Custom Lists
• 8.06 Series Formatting

Session 9: Conditional Formatting

• 9.01 Introduction
• 9.02 Highlight Cells Rules
• 9.03 Top/Bottom Rules
• 9.04 Data Bars
• 9.05 Color Scales
• 9.06 Custom Formatting Rule

Session 10: Tables

• 10.01 Introduction
• 10.02 Insert a Table and Style Options
• 10.03 Add Rows and Columns
• 10.04 Perform a Function in a Table
• 10.05 Summarise With Pivot Table

Session 11: Data Tools

• 11.01 Introduction
• 11.02 Data Validation
• 11.03 Drop-Down Lists
• 11.04 Removing Duplicates
• 11.05 Text To Columns
• 11.06 Goal Seek
• 11.07 Scenario Manager

Session 12: Referencing Formulas

• 12.01 Introduction
• 12.02 Multiple Sheet References
• 12.03 Consolidating Data - With or Without Links
• 12.04 Trace the Precedents and Dependents
• 12.05 Using the Watch Window

Session 13: Ranges and Dates

• 13.01 Introduction
• 13.02 Cell Names
• 13.03 Named Ranges
• 13.04 Formulas with Cell Names
• 13.05 Date Formulas

Session 14: Lookups

• 14.01 Introduction
• 14.02 VLOOKUP
• 14.03 VLOOKUP Exact Match
• 14.04 HLOOKUP
• 14.05 HLOOKUP Exact Match

Session 15: Conditional Logic

• 15.01 Introduction
• 15.02 IF Statement
• 15.03 Nested IF
• 15.04 AND
• 15.05 OR
• 15.06 NOT
• 15.07 IFERROR
• 15.08 SUMIF
• 15.09 AVERAGEIF
• 15.10 COUNTIF & COUNTIFS
• 15.11 SUMIFS
• 15.12 AVERAGEIFS

Session 16: Text Formulas

• 16.01 Introduction
• 16.02 Case Formulas
• 16.03 Fix Number Fields
• 16.04 Trim Spaces
• 16.05 Substitute Text

Session 17: Introduction to Charts

• 17.01 Introduction
• 17.02 Chart Types
• 17.03 Instant Chart
• 17.04 Update Chart
• 17.05 Column Chart
• 17.06 Picture Fill
• 17.07 Adjust Chart Size
• 17.08 Line Chart
• 17.09 Scatter Chart

Session 18: Formatting Charts

• 18.01 Introduction
• 18.02 Chart Styles
• 18.03 Chart Layouts
• 18.04 Add Labels
• 18.05 Axis Options
• 18.06 Chart Title
• 18.07 Legends
• 18.08 Data Labels

Session 19: Adding Graphics to Spreadsheets

• 19.01 Introduction
• 19.02 Insert Pictures
• 19.03 Modifying Pictures
• 19.04 Insert Shapes
• 19.05 Insert SmartArt
• 19.06 Apply Themes
• 19.07 Arrange

Session 20: Outline, Sort, Filter, and Subtotal

• 20.01 Introduction
• 20.02 Group and Ungroup
• 20.03 Sort Data
• 20.04 Sort Multiple Levels
• 20.05 Filter Data
• 20.06 Advanced Filter
• 20.07 Conditional Sorting and Filtering
• 20.08 Sorting with Custom Lists
• 20.09 Subtotal

Session 21: PivotTables

• 21.01 Introduction
• 21.02 Creating PivotTables
• 21.03 Choosing Fields
• 21.04 PivotTable Layout
• 21.05 Filtering PivotTables
• 21.06 Modifying PivotTable Data
• 21.07 PivotCharts

Session 22: Protecting Data

• 22.01 Introduction
• 22.02 Workbook Passwords
• 22.03 Protecting Workbooks
• 22.04 Unlocking Cells

Session 23: Collaboration

• 23.01 Introduction
• 23.02 Document Properties
• 23.03 Inserting Hyperlinks
• 23.04 Sharing a Workbook
• 23.05 Track Changes
• 23.06 Accept/Reject Changes
• 23.07 Mark as Final

Session 24: Printing

• 24.01 Introduction
• 24.02 Page Orientation
• 24.03 Page Breaks
• 24.04 Print Area
• 24.05 Margins
• 24.06 Print Titles
• 24.07 Headers and Footers
• 24.08 Scaling
• 24.09 Sheet Options

Session 25: Saving a Workbook

• 25.01 Introduction
• 25.02 Save As Previous Version
• 25.03 AutoRecover Save Options
• 25.04 Templates
• 25.05 Save As PDF
• 25.06 Save As Web Page
• 25.07 Macro-Enabled Workbook

Session 26: Macros

• 26.01 Introduction and Macro Security
• 26.02 Recording a Macro
• 26.03 Assign a Macro to a Button or Shape
• 26.04 Run a Macro upon Opening a Workbook
• 26.05 How to Inspect and Modify a Macro

Session 1: Create a Presentation

• 1.01 Create a new presentation
• 1.02 Create a presentation based on a template
• 1.03 Import Word document outlines

Session 2: Insert and Format Slides

• 2.01 Insert specific slide layouts
• 2.02 Duplicate existing slides
• 2.03 Hide and unhide slides
• 2.04 Delete slides
• 2.05 Apply a different slide layout
• 2.06 Modify individual slide backgrounds
• 2.07 Inset slide headers, footers, and page numbers

Session 3: Modify Slides, Handouts, and Notes

• 3.01 Change the slide master theme or background
• 3.02 Modify slide master content
• 3.03 Create a slide layout
• 3.04 Modify a slide layout
• 3.05 Modify the handout master
• 3.06 Modify the notes master

Session 4: Order and Group Slides

• 4.01 Create sections
• 4.02 Modify slide order
• 4.03 Rename sections

Session 5: Change Presentation Options and Views

• 5.01 Change slide size
• 5.02 Change views of a presentation
• 5.03 Set file properties

Session 6: Configure a Presentation for Print

• 6.01 Print all or part of a presentation
• 6.02 Print notes pages
• 6.03 Print handouts
• 6.04 Print in color, grayscale, or black and white

Session 7: Configure and Present a Slide Show

• 7.01 Create custom slide shows
• 7.02 Configure slide show options
• 7.03 Rehearse slide show timing
• 7.04 Present a slide show by using Presenter View

Session 8: Insert and Format Text

• 8.01 Insert text on a slide
• 8.02 Apply formatting and styles to text
• 8.03 Apply WordArt styles to text
• 8.04 Format text in multiple columns
• 8.05 Create bulleted and numbered lists
• 8.06 Insert hyperlinks

Session 9: Insert and Format Shapes and Text Boxes

• 9.01 Insert or replace shapes
• 9.02 Insert text boxes
• 9.03 Resize shapes and text boxes
• 9.04 Format shapes and text boxes
• 9.05 Apply styles to shapes and text boxes

Session 10: Insert and Format Images

• 10.01 Insert images
• 10.02 Resize and crop images
• 10.03 Apply styles and effects

Session 11: Order and Group Objects

• 11.01 Order objects
• 11.02 Align objects
• 11.03 Group objects
• 11.04 Display alignment tools

Session 12: Insert and Format Tables

• 12.01 Create a table
• 12.02 Insert and delete table rows and columns
• 12.03 Apply table styles
• 12.04 Import a table

Session 13: Insert and Format Charts

• 13.01 Create a chart
• 13.02 Import a chart
• 13.03 Change the Chart Type
• 13.04 Add a legend to a chart
• 13.05 Change the chart style of a chart

Session 14: Insert and Format SmartArt graphics

• 14.01 Create SmartArt graphics
• 14.02 Convert lists to SmartArt graphics
• 14.03 Add shapes to SmartArt graphics
• 14.04 Reorder shapes in SmartArt graphics
• 14.05 Change the color of SmartArt graphics

Session 15: Insert and Manage Media

• 15.01 Insert audio and video clips
• 15.02 Configure media playback options
• 15.03 Adjust media window size
• 15.04 Set the video start and stop time
• 15.05 Set media timing options

Session 16: Apply Slide Transitions

• 16.01 Insert slide transitions
• 16.02 Set transition effect options

Session 17: Animate Slide Content

• 17.01 Apply animations to objects
• 17.02 Apply animations to text
• 17.03 Set animation effect options
• 17.04 Set animation paths

Session 18: Set Timing for Transitions and Animations

• 18.01 Set transition effect duration
• 18.02 Configure transition start and finish options
• 18.03 Reorder animations on a slide

Session 19: Merge Content from Multiple Presentations

• 19.01 Inset slides from another presentation
• 19.02 Compare two presentations
• 19.03 Insert comments
• 19.4 Review comments

Session 20: Finalize Presentations

• 20.01 Protect a presentation
• 20.02 Inspect a presentation
• 20.03 Proof a presentation
• 20.04 Preserve presentation content
• 20.05 Export presentations to other formats