Excel 2013 Level 2
Excel 2013 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 2013 – 2.1.1 – Link to Another Worksheet
-
Excel 2013 – 2.1.2 – Link to Another Workbook
-
Excel 2013 – 2.1.3 – Calculate across Worksheets using a Formula
-
Excel 2013 – 2.1.4 – Calculate across Worksheets using a Function
-
Excel 2013 – 2.1.5 – Calculate across Workbooks using a Formula
-
Excel 2013 – 2.1.6 – Calculate across Workbooks using a Function
-
Excel 2013 – 2.1.7 – Link a Constant VAT Value across Sheets
-
Excel 2013 – 2.1.8 – Visual Rounding Causing Incorrect Results in Excel
-
Excel 2013 – 2.1.9 – Nesting in the ROUND Function
- Excel 2013 – 2.1.1 – Link to Another Worksheet
- Excel 2013 – 2.1.2 – Link to Another Workbook
- Excel 2013 – 2.1.3 – Calculate across Worksheets using a Formula
- Excel 2013 – 2.1.4 – Calculate across Worksheets using a Function
- Excel 2013 – 2.1.5 – Calculate across Workbooks using a Formula
- Excel 2013 – 2.1.6 – Calculate across Workbooks using a Function
- Excel 2013 – 2.1.7 – Link a Constant VAT Value across Sheets
- Excel 2013 – 2.1.8 – Visual Rounding Causing Incorrect Results in Excel
- Excel 2013 – 2.1.9 – Nesting in the ROUND Function
3
Lesson 3 – Working with the IF, AND & OR Functions
-
Excel 2013 – 2.3.1 – About IF
-
Excel 2013 – 2.3.2 – Using the IF Function
-
Excel 2013 – 2.3.3 – Using the IF Function with Text
-
Excel 2013 – 2.3.4 – Using the AND Function
-
Excel 2013 – 2.3.5 – Using the IF with Nested AND
-
Excel 2013 – 2.3.6 – Using IF with Nested OR
-
Excel 2013 – 2.3.7 – Using IF with Nested IF
-
Excel 2013 – 2.3.8 – Explanation of IF within IF
- Excel 2013 – 2.3.1 – About IF
- Excel 2013 – 2.3.2 – Using the IF Function
- Excel 2013 – 2.3.3 – Using the IF Function with Text
- Excel 2013 – 2.3.4 – Using the AND Function
- Excel 2013 – 2.3.5 – Using the IF with Nested AND
- Excel 2013 – 2.3.6 – Using IF with Nested OR
- Excel 2013 – 2.3.7 – Using IF with Nested IF
- Excel 2013 – 2.3.8 – Explanation of IF within IF
4
Lesson 4 – Working with Related IF Functions
-
Excel 2013 – 2.4.1 – How to use the SUMIF Function
-
Excel 2013 – 2.4.2 – How to use the AVERAGEIF Function
-
Excel 2013 – 2.4.3 – How to use the COUNTIF Function
-
Excel 2013 – 2.4.4 – How to use the SUMIFS Function
-
Excel 2013 – 2.4.5 – How to use the AVERAGEIFS Function
-
Excel 2013 – 2.4.6 – How to use the COUNTIFS Function
-
Excel 2013 – 2.4.7 – Using a Mixed Reference Absolute in a SUMIFS Function
- Excel 2013 – 2.4.1 – How to use the SUMIF Function
- Excel 2013 – 2.4.2 – How to use the AVERAGEIF Function
- Excel 2013 – 2.4.3 – How to use the COUNTIF Function
- Excel 2013 – 2.4.4 – How to use the SUMIFS Function
- Excel 2013 – 2.4.5 – How to use the AVERAGEIFS Function
- Excel 2013 – 2.4.6 – How to use the COUNTIFS Function
- Excel 2013 – 2.4.7 – Using a Mixed Reference Absolute in a SUMIFS Function
6
Lesson 6 – Filtering Data
-
Excel 2013 – 2.6.1 – Create a Basic Filter
-
Excel 2013 – 2.6.2 – Create a Quick Filter using the Right Click
-
Excel 2013 – 2.6.3 – Apply a Filter using Multiple Criteria
-
Excel 2013 – 2.6.4 – Create a Price Range Filter
-
Excel 2013 – 2.6.5 – Create a Top 10 Filter
-
Excel 2013 – 2.6.6 – Create Date Filters
-
Excel 2013 – 2.6.7 – Things to Know When Calculating with a Filter
- Excel 2013 – 2.6.1 – Create a Basic Filter
- Excel 2013 – 2.6.2 – Create a Quick Filter using the Right Click
- Excel 2013 – 2.6.3 – Apply a Filter using Multiple Criteria
- Excel 2013 – 2.6.4 – Create a Price Range Filter
- Excel 2013 – 2.6.5 – Create a Top 10 Filter
- Excel 2013 – 2.6.6 – Create Date Filters
- Excel 2013 – 2.6.7 – Things to Know When Calculating with a Filter
9
Lesson 9 – Working with Tables
-
Excel 2013 – 2.9.1 – Create a Table
-
Excel 2013 – 2.9.2 –3 Quick Tips for Using a Table
-
Excel 2013 – 2.9.3 – Insert & Delete Table Rows and Columns
-
Excel 2013 – 2.9.3 – Insert & Delete Table Rows and Columns
-
Excel 2013 – 2.9.4 – Calculate in a Table
-
Excel 2013 – 2.9.5 – Explanation of Structured References
-
Excel 2013 – 2.9.6 – Create a Calculation Outside a Table
-
Excel 2013 – 2.9.7 – Issues with Fill Handling a Calculation Outside a Table
-
Excel 2013 – 2.9.8 – Remove a Table
- Excel 2013 – 2.9.1 – Create a Table
- Excel 2013 – 2.9.2 –3 Quick Tips for Using a Table
- Excel 2013 – 2.9.3 – Insert & Delete Table Rows and Columns
- Excel 2013 – 2.9.3 – Insert & Delete Table Rows and Columns
- Excel 2013 – 2.9.4 – Calculate in a Table
- Excel 2013 – 2.9.5 – Explanation of Structured References
- Excel 2013 – 2.9.6 – Create a Calculation Outside a Table
- Excel 2013 – 2.9.7 – Issues with Fill Handling a Calculation Outside a Table
- Excel 2013 – 2.9.8 – Remove a Table