77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation
What’s included
$14.99 / $24.99
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.
Pay once, own it forever
Video Courses
Introducing the Microsoft Excel User Interface
| Lectures | Duration |
|---|---|
| 1. Introducing the Excel User Interface | 9m |
| 2. Essential Navigation Skills | 10m |
| 3. Entering Information | 17m |
1. Introducing the Excel User Interface
9m
2. Essential Navigation Skills
10m
3. Entering Information
17m
1.1 Create Worksheets and Workbooks
| Lectures | Duration |
|---|---|
| 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. 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
| Lectures | Duration |
|---|---|
| 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. 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
| Lectures | Duration |
|---|---|
| 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. 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
| Lectures | Duration |
|---|---|
| 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. 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
| Lectures | Duration |
|---|---|
| 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 |
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
| Lectures | Duration |
|---|---|
| 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 |
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
| Lectures | Duration |
|---|---|
| 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 |
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
| Lectures | Duration |
|---|---|
| 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 |
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
| Lectures | Duration |
|---|---|
| 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 |
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
| Lectures | Duration |
|---|---|
| 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 |
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
| Lectures | Duration |
|---|---|
| 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 |
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
| Lectures | Duration |
|---|---|
| 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 |
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
| Lectures | Duration |
|---|---|
| 1. 4.3.1 Format Text by using RIGHT, LEFT and MID Functions | 8m |
| 2. Exercises Domain 4.3 | 4m |
1. 4.3.1 Format Text by using RIGHT, LEFT and MID Functions
8m
2. Exercises Domain 4.3
4m
5.1 Create Charts
| Lectures | Duration |
|---|---|
| 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 |
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
| Lectures | Duration |
|---|---|
| 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 |
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
| Lectures | Duration |
|---|---|
| 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 |
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