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