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.

Subscribe to this Course

Course Content

Expand All | Collapse All

Lessons Status

1

Lesson 1 – Linking and 3-D Calculation

Excel 2016 – 2.1.9 – Nest VAT in the ROUND Function

Excel 2016 – 2.1.8 – Visual Rounding Causing Incorrect Results

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

Excel 2016 – 2.1.6 – Calculate Across Workbooks Using a Function

Excel 2016 – 2.1.5 – Calculate Across Workbooks Using a Formula

Excel 2016 – 2.1.4 – Calculate Across Worksheets Using a Function

Excel 2016 – 2.1.3 – Calculate Across Worksheets Using a Formula

Excel 2016 – 2.1.2 – Link to Another Workbook

Excel 2016 – 2.1.1 – Link to Another Worksheet

2

Lesson 2 – Using Naming

Excel 2016 – 2.2.4 – Edit/Delete Names

Excel 2016 – 2.2.3 – Auto-create Named Ranges

Excel 2016 – 2.2.2 – Name a Single Cell

Excel 2016 – 2.2.1 – About Naming

3

Lesson 3 – Working with the IF AND & OR Functions

Excel 2016 – 2.3.8 – Explanation of IF Within IF

Excel 2016 – 2.3.7 – Using IF with Nested IF

Excel 2016 – 2.3.6 – Using IF with Nested OR

Excel 2016 – 2.3.5 – Using IF with Nested AND

Excel 2016 – 2.3.4 – Using the AND Function

Excel 2016 – 2.3.3 – Using the IF Function with Text

Excel 2016 – 2.3.2 – Using the IF Function

Excel 2016 – 2.3.1 – About IF

4

Lesson 4 – Working with Related IF Functions

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

Excel 2016 – 2.4.7 – Use the COUNTIFS Function

Excel 2016 – 2.4.6 – Use the AVERAGEIFS Function

Excel 2016 – 2.4.5 – Use the SUMIFS Function

Excel 2016 – 2.4.4 – Use the COUNTIF Function

Excel 2016 – 2.4.3 – Use the AVERAGEIF Function

Excel 2016 – 2.4.2 – How SUMIF Works

Excel 2016 – 2.4.1 – Use the SUMIF Function

5

Lesson 5 – Sorting Data

Excel 2016 – 2.5.6 – Sort by Row

Excel 2016 – 2.5.5 – Create a Custom Sort

Excel 2016 – 2.5.4 – Sort by Colour

Excel 2016 – 2.5.3 – Create a Multi-level Sort

Excel 2016 – 2.5.2 – Create a Single Sort

Excel 2016 – 2.5.1 – How to Structure Your Data

6

Lesson 6 – Filtering

Excel 2016 – 2.6.7 – Calculating With a Filter

Excel 2016 – 2.6.6 – Create Date Filters

Excel 2016 – 2.6.5 – Create a Top 10 Filter

Excel 2016 – 2.6.4 – Create a Price Range Filter

Excel 2016 – 2.6.3 – Apply a Filter Using Multiple Criteria

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

Excel 2016 – 2.6.1 – Create a Basic Filter

7

Lesson 7 – Advanced Filtering

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

Excel 2016 – 2.7.3 – Show Unique Items From a Column

Excel 2016 – 2.7.2 – Create An Advanced Filter

Excel 2016 – 2.7.1 – Why Use An Advanced Filter?

8

Lesson 8 – Subtotal

Excel 2016 – 2.8.6 – Use Visible Cells to Copy Subtotals

Excel 2016 – 2.8.5 – Create a Multi-level Subtotal

Excel 2016 – 2.8.4 – Create Two Separate Subtotals

Excel 2016 – 2.8.3 – Remove a Subtotal

Excel 2016 – 2.8.2 – Create a Subtotal

Excel 2016 – 2.8.1 – Why Use The Subtotal Feature?

9

Lesson 9 – Working with Tables

Excel 2016 – 2.9.8 – Remove The Table Feature

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

Excel 2016 – 2.9.6 – Calculate Outside Of a Table

Excel 2016 – 2.9.5 – Explanation of Structured References

Excel 2016 – 2.9.4 – Calculate In a Table

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

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

Excel 2016 – 2.9.1 – Create a Table

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

12

Lesson 12 – The FILTER Function

Excel 2016 – 2.12.1 – About the FILTER Function

Excel 2016 – 2.12.2 – Basic FILTER Function

Excel 2016 – 2.12.3 – FILTER Function with Multiple AND Criteria

Excel 2016 – 2.12.4 – FILTER Function with Multiple OR Criteria

Excel 2016 – 2.12.5 – FILTER Function Using > (Greater Than)

Excel 2016 – 2.12.6 – FILTER #Spill Error

Excel 2016 – 2.12.7 – FILTER Function with Tables

Excel 2016 – 2.12.8 – FILTER Due Dates

Excel 2016 – 2.12.9 – Conditional Formatting to Highlight Dates

Excel 2016 – 2.12.10 – FILTER to Show Specific Columns

Excel 2016 – 2.12.11 – How to Sort with FILTER

Excel 2016 – 2.12.12 – FILTER to Show Non-contiguous Columns