Excel 2013 Level 2

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.

Buy a Subscription to this Course

Course Content

Expand All | Collapse All

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

2

Lesson 2 – Using Naming

Excel 2013 - 2.2.1 - About Naming

Excel 2013 - 2.2.2 - Name a Single Cell

Excel 2013 - 2.2.3 - Auto-create Named Ranges

Excel 2013 - 2.2.4 - Edit/Delete a Named Reference

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

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

5

Lesson 5 – Sorting Data

Excel 2013 – 2.5.1 – How to Structure your Data Lists

Excel 2013 – 2.5.2 – Carry out a Single Sort

Excel 2013 – 2.5.3 – Carry out a Multi-level Sort

Excel 2013 – 2.5.4 – Sort by Colour

Excel 2013 – 2.5.5 – Create a Custom Sort

Excel 2013 – 2.5.6 – Sort by Row Instead of by Column

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

7

Lesson 7 – Advanced Filtering

Excel 2013 – 2.7.1 – Why use an Advanced Filter?

Excel 2013 – 2.7.2 – Create an Advanced Filter

Excel 2013 – 2.7.3 – Show Unique Records from One Column

Excel 2013 – 2.7.4 – Filter and Copy Selected Data

8

Lesson 8 – Subtotals

Excel 2013 – 2.8.1 – Why use the Subtotals Feature?

Excel 2013 – 2.8.2 – Create a Subtotal

Excel 2013 – 2.8.3 – Remove a Subtotal

Excel 2013 – 2.8.4 – Create Two Separate Subtotals

Excel 2013 – 2.8.5 – Create a Multilevel Subtotal

Excel 2013 – 2.8.6 – Use Visible Cells to Copy Subtotals

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