Excel 365/2016 Level 2

Excel 365/2016 Level 2

Excel 365/2016 Level 2 is suitable for those who are familiar with the topics on the Level 1 course and/or those who are self-taught and would like to pick up some tips. Even if you work with a different version of Excel, there are many videos that cross those boundaries.

Buy a Subscription to this Course

Course Content

Expand All | Collapse All

Lessons Status

1

Lesson 1 - Linking and 3-D Calculation

Excel 2016 - 2.1.1 - Link to Another Worksheet

Excel 2016 - 2.1.2 - Link to Another Workbook

Excel 2016 - 2.1.3 - Calculate Across Worksheets Using a Formula

Excel 2016 - 2.1.4 - Calculate Across Worksheets Using a Function

Excel 2016 - 2.1.5 - Calculate Across Workbooks Using a Formula

Excel 2016 - 2.1.6 - Calculate Across Workbooks Using a Function

Excel 2016 - 2.1.7 - Link a Constant VAT Value Across Sheets

Excel 2016 - 2.1.8 - Visual Rounding Causing Incorrect Results

Excel 2016 - 2.1.9 - Nest VAT in the ROUND Function

2

Lesson 2 - Using Naming

Excel 2016 - 2.2.1 - About Naming

Excel 2016 - 2.2.2 - Name a Single Cell

Excel 2016 - 2.2.3 - Auto-create Named Ranges

Excel 2016 - 2.2.4 - Edit/Delete Names

3

Lesson 3 - Working with the IF AND & OR Functions

Excel 2016 - 2.3.1 - About IF

Excel 2016 - 2.3.2 - Using the IF Function

Excel 2016 - 2.3.3 - Using the IF Function with Text

Excel 2016 - 2.3.4 - Using the AND Function

Excel 2016 - 2.3.5 - Using IF with Nested AND

Excel 2016 - 2.3.6 - Using IF with Nested OR

Excel 2016 - 2.3.7 - Using IF with Nested IF

Excel 2016 - 2.3.8 - Explanation of IF Within IF

4

Lesson 4 - Working with Related IF Functions

Excel 2016 - 2.4.1 - Use the SUMIF Function

Excel 2016 - 2.4.2 - How SUMIF Works

Excel 2016 - 2.4.3 - Use the AVERAGEIF Function

Excel 2016 - 2.4.4 - Use the COUNTIF Function

Excel 2016 - 2.4.5 - Use the SUMIFS Function

Excel 2016 - 2.4.6 - Use the AVERAGEIFS Function

Excel 2016 - 2.4.7 - Use the COUNTIFS Function

Excel 2016 - 2.4.8 - Mixed Reference Absolutes in a SUMIFS Function

5

Lesson 5 - Sorting Data

Excel 2016 - 2.5.1 - How to Structure Your Data

Excel 2016 - 2.5.2 - Create a Single Sort

Excel 2016 - 2.5.3 - Create a Multi-level Sort

Excel 2016 - 2.5.4 - Sort by Colour

Excel 2016 - 2.5.5 - Create a Custom Sort

Excel 2016 - 2.5.6 - Sort by Row

6

Lesson 6 - Filtering

Excel 2016 - 2.6.1 - Create a Basic Filter

Excel 2016 - 2.6.2 - Create a Quick Filter Using the Right Click

Excel 2016 - 2.6.3 - Apply a Filter Using Multiple Criteria

Excel 2016 - 2.6.4 - Create a Price Range Filter

Excel 2016 - 2.6.5 - Create a Top 10 Filter

Excel 2016 - 2.6.6 - Create Date Filters

Excel 2016 - 2.6.7 - Calculating With a Filter

7

Lesson 7 - Advanced Filtering

Excel 2016 - 2.7.1 - Why Use An Advanced Filter?

Excel 2016 - 2.7.2 - Create An Advanced Filter

Excel 2016 - 2.7.3 - Show Unique Items From a Column

Excel 2016 - 2.7.4 - Filter and Copy Data To Another Worksheet

8

Lesson 8 - Subtotal

Excel 2016 - 2.8.1 - Why Use The Subtotal Feature?

Excel 2016 - 2.8.2 - Create a Subtotal

Excel 2016 - 2.8.3 - Remove a Subtotal

Excel 2016 - 2.8.4 - Create Two Separate Subtotals

Excel 2016 - 2.8.5 - Create a Multi-level Subtotal

Excel 2016 - 2.8.6 - Use Visible Cells to Copy Subtotals

9

Lesson 9 - Working with Tables

Excel 2016 - 2.9.1 - Create a Table

Excel 2016 - 2.9.2 - Three Quick Tips For Using a Table

Excel 2016 - 2.9.3 - Insert & Delete Table Rows and Columns

Excel 2016 - 2.9.4 - Calculate In a Table

Excel 2016 - 2.9.5 - Explanation of Structured References

Excel 2016 - 2.9.6 - Calculate Outside Of a Table

Excel 2016 - 2.9.7 - Fill Handling a Calculation Outside a Table

Excel 2016 - 2.9.8 - Remove The Table Feature

10

Lesson 10 - Working with Dates and Time

Excel 2016 - 2.10.1 - About Dates and Formatting

Excel 2016 - 2.10.2 - Custom Date Formatting

Excel 2016 - 2.10.3 - Subtract Dates and Formatting Issues

Excel 2016 - 2.10.4 - Addition with Dates

Excel 2016 - 2.10.5 - Calculate Date and Time

Excel 2016 - 2.10.6 - EDATE Function

Excel 2016 - 2.10.7 - EOMONTH Function

Excel 2016 - 2.10.8 - DATEDIF Function

Excel 2016 - 2.10.9 - WEEKDAY Function

Excel 2016 - 2.10.10 - NETWORKDAYS Function

Excel 2016 - 2.10.11 - WORKDAY Function

Excel 2016 - 2.10.12 - DATEVALUE Function

Excel 2016 - 2.10.13 - Time Formatting

Excel 2016 - 2.10.14 - Subtract Time

Excel 2016 - 2.10.15 - Timesheet Removing Break Times

Excel 2016 - 2.10.16 - Find Future Times

Excel 2016 - 2.10.17 - Calculate Time With Currency

Excel 2016 - 2.10.18 - Calculate Minutes With Currency

Excel 2016 - 2.10.19 - Time Exceeds 24 Hours

Excel 2016 - 2.10.20 - The TIMEVALUE Function

11

Lesson 11 - Working with Text

Excel 2016 - 2.11.1 - Manual Concatenation

Excel 2016 - 2.11.2 - The CONCATENATE Function

Excel 2016 - 2.11.3 - The CONCAT Function

Excel 2016 - 2.11.4 - The TEXTJOIN Function

Excel 2016 - 2.11.5 - TEXTJOIN Over CONCAT

Excel 2016 - 2.11.6 - Multiple Delimiters