MS Office Training

MS Word:

  • 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

MS Power point:

  • 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

MS Excel:

  • 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