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.
Course Content
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
- 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
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
- 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
- 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
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
- 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
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
- 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
- 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