77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation

77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation

Get ready for your exam by enrolling in our comprehensive training course. This course includes a full set of instructional videos designed to equip you with in-depth knowledge essential for passing the certification exam with flying colors.

$14.99 / $24.99

Introducing the Microsoft Excel User Interface

  • 1. Introducing the Excel User Interface
    9m
  • 2. Essential Navigation Skills
    10m
  • 3. Entering Information
    17m

1.1 Create Worksheets and Workbooks

  • 1. 1.1.1 Create a Workbook
    3m
  • 2. 1.1.2 Importing Data from a Delimited Text File
    5m
  • 3. 1.1.3 Add a Worksheet to an Existing Workbook
    2m
  • 4. 1.1.4 Copy and Move a Worksheet
    3m
  • 5. Exercises Domain 1.1
    8m

1.2 Navigate in Worksheets and Workbooks

  • 1. 1.2.1 & 1.2.2 Search & Navigate to a Named Cell, Range, of Workbook Element
    8m
  • 2. 1.2.2 Named Ranges
    4m
  • 3. 1.2.3 Insert and Remove hyperlinks
    4m
  • 4. Exercises Domain 1.2
    8m

1.3 Format Worksheets and Workbooks

  • 1. 1.3.1 to 1.3.3 Changing Worksheet Characteristics
    2m
  • 2. 1.3.4 Modify Page Setup
    7m
  • 3. 1.3.5 Insert and Delete Columns or Rows (and Cells)
    5m
  • 4. 1.3.6 Change Workbook Themes
    2m
  • 5. 1.3.7 Adjust Row Height and Column Width
    3m
  • 6. 1.3.8 Insert Headers and Footers
    5m
  • 7. Exercises Domain 1.3
    7m

1.4 Customise Options and Views for Worksheets and Workbooks

  • 1. 1.4.1 and 1.4.2 Hide or Unhide Worksheets, Columns and Rows
    2m
  • 2. 1.4.3 Customise the Quick Access Toolbar
    2m
  • 3. 1.4.4 Change Workbook Views
    3m
  • 4. 1.4.5 Change Window Views
    8m
  • 5. 1.4.6 Modify Document Properties
    2m
  • 6. 1.4.7 Change Magnification by using Zoom Tools
    1m
  • 7. 1.4.8 Display Formulas
    2m
  • 8. Exercises Domain 1.4
    5m

1.5 Configure Worksheets and Workbooks for Distribution

  • 1. 1.5.1
    1m
  • 2. 1.5.2 Save Workbooks in Alternative File Formats
    2m
  • 3. 1.5.3 Print All of Part of a Workbook
    1m
  • 4. 1.5.4 Set Print Scaling
    4m
  • 5. 1.5.5 Display Repeating Row and Column Titles on Multipage Worksheets
    2m
  • 6. 1.5.6 Inspect a Workbook for Hidden Properties or Personal Information
    2m
  • 7. 1.5.7 Inspect a Workbook for Accessibility Issues
    4m
  • 8. 1.5.8 Inspect a Workbook for Compatibility Issues
    3m
  • 9. Exercises 1.5
    3m

2.1 Insert Data in Cells and Ranges

  • 1. 2.1.1 Replace Data
    3m
  • 2. 2.1.2 Cut, Copy or Paste Data
    4m
  • 3. 2.1.3 Paste Data by using Special Paste Options
    4m
  • 4. 2.1.4 Fill Cells by using Auto Fill
    3m
  • 5. 2.1.5 Insert and Delete Cells
    1m
  • 6. Exercises Domain 2.1
    6m

2.2. Format Cells and Ranges

  • 1. 2.2.1 Merge Cells
    2m
  • 2. 2.2.2 Modify Cell Alignment and Indentation
    2m
  • 3. 2.2.3 Format Cells by using Format Painter
    2m
  • 4. 2.2.4 Wrap Text Within Cells
    1m
  • 5. 2.2.5 Apply Number Formats
    7m
  • 6. 2.2.6 Apply Cell Formats
    7m
  • 7. 2.2.7 Apply Cell Styles
    2m
  • 8. Exercises Domain 2.2
    7m

2.3 Summarise and Organise Data

  • 1. 2.3.1 Insert Sparklines
    4m
  • 2. 2.3.2 and 2.3.3 Outline Data and Insert Subtotals
    8m
  • 3. 2.3.4 Apply Conditional Formatting
    5m
  • 4. Exercises Domain 2.3
    5m

3.1 and 3.2 Create and Manage Tables

  • 1. 3.1.1 and 3.1.2 Create an Excel Table from a Cell Range and Reverse
    5m
  • 2. 3.1.3 Add or Remove Table rows and Columns
    2m
  • 3. 3.2.1 to 3.2.3 Table Styles
    2m
  • 4. Exercises Domain 3.1 and 3.2
    2m

3.3 Filter and Sort a Table

  • 1. 3.3.1 Filter Records
    5m
  • 2. 3.3.2 and 3.3.3 Sort Data
    6m
  • 3. 3.3.4 Remove Duplicate Records
    1m
  • 4. Exercises Domain 3.3
    4m

4.1 Summarise Data by Using Functions

  • 1. 4.1.1 (Part I) Insert References
    10m
  • 2. 4.1.1 (Part II) Absolute References
    6m
  • 3. 4.1.2 Perform Calculations by using the SUM Function
    5m
  • 4. 4.1.3 to 4.1.5 Using the Average, MIN, MAX and COUNT Functions
    4m
  • 5. Exercises Domain 4.1
    7m

4.2 Perform Conditional Operations by Using Functions

  • 1. 4.2.1 Perform Logical Operations by using the IF Function
    11m
  • 2. 4.2.2 to 4.2.4 Using the AverageIF, COUNTIF and SUMIF Functions
    4m
  • 3. Exercises Domain 4.2
    9m

4.3 Format and Modify Text by Using Functions

  • 1. 4.3.1 Format Text by using RIGHT, LEFT and MID Functions
    8m
  • 2. Exercises Domain 4.3
    4m

5.1 Create Charts

  • 1. 5.1.1 Create a New Chart
    4m
  • 2. 5.1.2 and 5.1.3 Add Additional Data Series and Switch Rows and Columns
    1m
  • 3. 5.1.4 Analyse Data by using Quick Analysis
    2m
  • 4. Exercises Domain 5.1
    3m

5.2 Format Charts

  • 1. 5.2.1 Resize Charts
    2m
  • 2. 5.2.2 Add and Modify Chart Elements
    2m
  • 3. 5.2.3 and 5.2.4 Apply Chart Layouts and Styles and Move Charts
    2m
  • 4. Exercises Domain 5.2
    3m

5.3 Insert and Format Objects

  • 1. 5.3.1 Insert Text Boxes and Shapes
    2m
  • 2. 5.3.2 Insert Images
    3m
  • 3. 5.3.3 Modify Object Properties
    10m
  • 4. 5.3.4 Add Alternative Text to Objects for Accessibility
    1m
  • 5. Exercises Domain 5.3
    5m