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.

What’s included

85 : Lectures
6h 7m : Duration

$14.99/24.99

Introducing the Microsoft Excel User Interface

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

1.1 Create Worksheets and Workbooks

Lectures	Duration
1. 1.1.1 Create a Workbook- 3m	3m
2. 1.1.2 Importing Data from a Delimited Text File- 5m	5m
3. 1.1.3 Add a Worksheet to an Existing Workbook- 2m	2m
4. 1.1.4 Copy and Move a Worksheet- 3m	3m
5. Exercises Domain 1.1- 8m	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	8m
2. 1.2.2 Named Ranges- 4m	4m
3. 1.2.3 Insert and Remove hyperlinks- 4m	4m
4. Exercises Domain 1.2- 8m	8m

1.3 Format Worksheets and Workbooks

Lectures	Duration
1. 1.3.1 to 1.3.3 Changing Worksheet Characteristics- 2m	2m
2. 1.3.4 Modify Page Setup- 7m	7m
3. 1.3.5 Insert and Delete Columns or Rows (and Cells)- 5m	5m
4. 1.3.6 Change Workbook Themes- 2m	2m
5. 1.3.7 Adjust Row Height and Column Width- 3m	3m
6. 1.3.8 Insert Headers and Footers- 5m	5m
7. Exercises Domain 1.3- 7m	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	2m
2. 1.4.3 Customise the Quick Access Toolbar- 2m	2m
3. 1.4.4 Change Workbook Views- 3m	3m
4. 1.4.5 Change Window Views- 8m	8m
5. 1.4.6 Modify Document Properties- 2m	2m
6. 1.4.7 Change Magnification by using Zoom Tools- 1m	1m
7. 1.4.8 Display Formulas- 2m	2m
8. Exercises Domain 1.4- 5m	5m

1.5 Configure Worksheets and Workbooks for Distribution

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

2.1 Insert Data in Cells and Ranges

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

2.2. Format Cells and Ranges

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

2.3 Summarise and Organise Data

Lectures	Duration
1. 2.3.1 Insert Sparklines- 4m	4m
2. 2.3.2 and 2.3.3 Outline Data and Insert Subtotals- 8m	8m
3. 2.3.4 Apply Conditional Formatting- 5m	5m
4. Exercises Domain 2.3- 5m	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	5m
2. 3.1.3 Add or Remove Table rows and Columns- 2m	2m
3. 3.2.1 to 3.2.3 Table Styles- 2m	2m
4. Exercises Domain 3.1 and 3.2- 2m	2m

3.3 Filter and Sort a Table

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

4.1 Summarise Data by Using Functions

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

4.2 Perform Conditional Operations by Using Functions

Lectures	Duration
1. 4.2.1 Perform Logical Operations by using the IF Function- 11m	11m
2. 4.2.2 to 4.2.4 Using the AverageIF, COUNTIF and SUMIF Functions- 4m	4m
3. Exercises Domain 4.2- 9m	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	8m
2. Exercises Domain 4.3- 4m	4m

5.1 Create Charts

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

5.2 Format Charts

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

5.3 Insert and Format Objects

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