DESIGNED FOR OFFICE INTERMEDIATE & ADVANCED USERS

Microsoft Office Proficiency

Our in-depth intermediate and Advanced Lessons for  Microsoft Office (2013) is designed to get you comfortable and at ease when using any of these Office products.

In this course, you’ll learn

Microsoft Word Intermediate 1

  • Introduction
  • View Types + Exercise
  • View Size + Exercise
  • Viewing Multiple Documents + Exercise
  • Spacing + Exercise
  • Rulers + Exercise
  • Indenting Paragraphs + Exercise
  • Bullets & Numbering + Exercise
  • Superscript and Subscript + Exercise
  • Tabs-Part 2 + Exercise
  • Formatting Marks + Exercise
  • Quiz 1
  • Header & Footer-Part 1 + Exercise
  • Header & Footer-Part 2 + Exercise
  • Page Numbers + Exercise
  • Page Breaks + Exercise
  • Section Breaks + Exercise
  • Footnotes + Exercise
  • Endnotes + Exercise
  • Hyperlinks
  • Bookmarks
  • Symbols and Special Characters
  • Highlighting Text
  • Document Statistics
  • Templates
  • Quiz 2

Microsoft Word Intermediate 2

  • Introduction
  • Text Borders and Shading + Exercise
  • Page Borders and Color + Exercise
  • Styles-Part 1 + Exercise
  • Styles-Part 2 + Exercise
  • Inserting Pictures + Exercise
  • Resizing and Rotating Pictures + Exercise
  • Enhancing Pictures + Exercise
  • Cropping Pictures + Exercise
  • Compressing Pictures + Exercise
  • Positioning Pictures + Exercise
  • Adding Drawings + Exercise
  • Modifying Drawings + Exercise
  • Adding and Modifying Word Art + Exercise
  • Adding and Modifying Drop Caps + Exercise
  • Themes + Exercise
  • Quiz 1
  • Inserting Tables + Exercise
  • Drawing Tables + Exercise
  • Formatting a Table’s Text + Exercise
  • Inserting and Deleting Table Rows and
  • Columns + Exercise
  • Resizing Table Rows and Columns + Exercise
  • Splitting and Merging Table Cells + Exercise
  • Performing Calculations in a Table + Exercise
  • Table Borders and Shading + Exercise
  • Table Styles + Exercise
  • Sorting Table Data + Exercise
  • Converting Text to a Table + Exercise
  • Quiz 2
  • End

Microsoft Word – Proficient

  • Introduction
  • Document Outline + Exercise
  • Document Comments + Exercise
  • Tracking Changes + Exercise
  • Insert & Overtype Modes + Exercise
  • Creating Text Columns + Exercise
  • Inserting Objects + Exercise
  • Paste Options + Exercise
  • Protecting Documents + Exercise
  • Quiz
  • End

Microsoft Excel – Intermediate

  • Filling Cells + Exercise
  • Editing Data Efficiently + Exercise
  • Inserting and Deleting Cells + Exercise
  • Inserting and Deleting Rows & Columns + Exercise
  • Data Fitting Error
  • Spelling Check + Exercise
  • Find and Replace + Exercise
  • Formulas Containing Multiple Operators + Exercise
  • Commonly Used Functions + Exercise
  • Inserting Functions in Formulas + Exercise
  • Modifying Formulas and Functions + Exercise
  • Copying Formulas and Functions + Exercise
  • Formula and Function Errors + Exercise
  • Organizing Worksheets + Exercise
  • Templates + Exercise
  • Time Saving Tips + Exercise
  • RS-Save Formats + Exercise

Microsoft Excel – Advanced

  • Wrapping Text in a Cell + Exercise
  • Changing the Orientation of Data + Exercise
  • Cell Borders + Exercise
  • Cell Shading + Exercise
  • Styles + Exercise
  • Inserting Pictures + Exercise
  • Resizing Pictures + Exercise
  • Adding Drawings + Exercise
  • Modifying Drawings + Exercise
  • Sorting Data + Exercise
  • Filtering Data + Exercise
  • Hiding Rows and Columns + Exercise
  • Page Breaks + Exercise
  • Header and Footer + Exercise
  • Print Area + Exercise
  • Print Scaling + Exercise
  • Printing Titles and Gridlines + Exercise
  • Creating Chart + Exercise s
  • Modifying Charts-Part 1 & 2 + Exercise
  • Interpreting Data and Charts
  • RS-Guidelines for Creating Spreadsheets

Microsoft PowerPoint – Intermediate

  • Adding Text Boxes + Exercise
  • Formatting Placeholders and Text Boxes + Exercise
  • Tabs + Exercise
  • Header and Footer + Exercise
  • Spelling Check + Exercise
  • Find and Replace + Exercise
  • Hyperlinks + Exercise
  • Inserting Pictures + Exercise
  • Modifying Pictures + Exercise
  • Adding Drawings + Exercise
  • Modifying Drawings + Exercise
  • Overlaying and Grouping Drawings + Exercise
  • Inserting Tables + Exercise
  • Inserting Charts + Exercise
  • Inserting Videos and Sounds + Exercise
  • Inserting Screenshots + Exercise
  • Changing Slide Layouts + Exercise
  • Slide Master + Exercise
  • Templates + Exercise
  • Slide Transitions + Exercise
  • RS-Guidelines for Creating Presentations
  • RS-Distributing a Presentation

Microsoft Access

  • Introduction
  • Database Overview
  • Getting Started with Access + Exercise
  • Tables-Part 1 & 2 + Exercise
  • Modifying, Sorting and Filtering Data + Exercise
  • Queries + Exercise
  • Forms + Exercise
  • Reports + Exercise
  • Table Relationships + Exercise
  • Queries Based on Related Tables + Exercise
  • Enabling a Database’s Content + Exercise
  • Quiz
  • End

Get Started ⟶  141 Lessons 

$1,880.00

Checkout All Bundles + Pricing

BAND MEMBERS

Get discounted pricing, when you select multiple members for this training.

Learn More