Introduction
  • What is Microsoft Office Specialist (MOS) Certification?
  • Understanding the Objective Domain
  • How is the exam be conducted and what will it be like?
  • Try It Yourself Exercises
Introducing the Microsoft Excel User Interface
  • Introducing the Excel User Interface
  • Essential Navigation Skills
  • Entering Information
Student Exercise Files
  • Course Exercise Workbook
  • Student Files
1.1 Create Worksheets and Workbooks
  • 1.1.1 Create a Workbook
  • 1.1.2 Importing Data from a Delimited Text File
  • 1.1.3 Add a Worksheet to an Existing Workbook
  • 1.1.4 Copy and Move a Worksheet
  • Exercises Domain 1.1
1.2 Navigate in Worksheets and Workbooks
  • 1.2.1 & 1.2.2 Search & Navigate to a Named Cell, Range, or Workbook Element
  • 1.2.2 Named Ranges
  • 1.2.3 Insert and Remove hyperlinks
  • Exercises Domain 1.2
1.3 Format Worksheets and Workbooks
  • 1.3.1 to 1.3.3 Changing Worksheet Characteristics
  • 1.3.4 Modify Page Setup
  • 1.3.5 Insert and Delete Columns or Rows (and Cells)
  • 1.3.6 Change Workbook Themes
  • 1.3.7 Adjust Row Height and Column Width
  • 1.3.8 Insert Headers and Footers
  • Exercises Domain 1.3
1.4 Customise Options and Views for Worksheets and Workbooks
  • 1.4.1 and 1.4.2 Hide or Unhide Worksheets, Columns and Rows
  • 1.4.3 Customise the Quick Access Toolbar
  • 1.4.4 Change Workbook Views
  • 1.4.5 Change Window Views
  • 1.4.6 Modify Document Properties
  • 1.4.7 Change Magnification by using Zoom Tools
  • 1.4.8 Display Formulas
  • Exercises Domain 1.4
1.5 Configure Worksheets and Workbooks for Distribution
  • 1.5.1. Set a Print Area
  • 1.5.2 Save Workbooks in Alternative File Formats
  • 1.5.3 Print All of Part of a Workbook
  • 1.5.4 Set Print Scaling
  • 1.5.5 Display Repeating Row and Column Titles on Multipage Worksheets
  • 1.5.6 Inspect a Workbook for Hidden Properties or Personal Information
  • 1.5.7 Inspect a Workbook for Accessibility Issues
  • 1.5.8 Inspect a Workbook for Compatibility Issues
  • Exercises 1.5
2.1 Insert Data in Cells and Ranges
  • 2.1.1 Replace Data
  • 2.1.2 Cut, Copy or Paste Data
  • 2.1.3 Paste Data by using Special Paste Options
  • 2.1.4 Fill Cells by using Auto Fill
  • 2.1.5 Insert and Delete Cells
  • Exercises Domain 2.1
2.2. Format Cells and Ranges
  • 2.2.1 Merge Cells
  • 2.2.2 Modify Cell Alignment and Indentation
  • 2.2.3 Format Cells by using Format Painter
  • 2.2.4 Wrap Text Within Cells
  • 2.2.5 Apply Number Formats
  • 2.2.6 Apply Cell Formats
  • 2.2.7 Apply Cell Styles
  • Exercises Domain 2.2
2.3 Summarise and Organise Data
  • 2.3.1 Insert Sparklines
  • 2.3.2 and 2.3.3 Outline Data and Insert Subtotals
  • 2.3.4 Apply Conditional Formatting
  • Exercises Domain 2.3
3.1 and 3.2 Create and Manage Tables
  • 3.1.1 and 3.1.2 Create an Excel Table from a Cell Range and Reverse
  • 3.1.3 Add or Remove Table rows and Columns
  • 3.2.1 to 3.2.3 Table Styles
  • Exercises Domain 3.1 and 3.2
3.3 Filter and Sort a Table
  • 3.3.1 Filter Records
  • 3.3.2 and 3.3.3 Sort Data
  • 3.3.4 Remove Duplicate Records
  • Exercises Domain 3.3
4.1 Summarise Data by Using Functions
  • 4.1.1 (Part I) Insert References
  • 4.1.1 (Part II) Absolute References
  • 4.1.2 Perform Calculations by using the SUM Function
  • 4.1.3 to 4.1.5 Using the Average, MIN, MAX and COUNT Functions
  • Exercises Domain 4.1
4.2 Perform Conditional Operations by Using Functions
  • 4.2.1 Perform Logical Operations by using the IF Function
  • 4.2.2 to 4.2.4 Using the AverageIF, COUNTIF and SUMIF Functions
  • Exercises Domain 4.2
4.3 Format and Modify Text by Using Functions
  • 4.3.1 to 4.3.3 Format Text by using Text Functions
  • Exercises Domain 4.3
5.1 Create Charts
  • 5.1.1 Create a New Chart
  • 5.1.2 and 5.1.3 Add Additional Data Series and Switch Rows and Columns
  • 5.1.4 Analyse Data by using Quick Analysis
  • Exercises Domain 5.1
5.2 Format Charts