Excel 2010 Level 2
Excel 2010 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 2010 – 2.1.1 – Link to another Worksheet
-
Excel 2010 – 2.1.2 – Link to another Workbook
-
Excel 2010 – 2.1.3 – Calculate across Worksheets using a Formula
-
Excel 2010 – 2.1.4 – Calculate across Worksheets using a Function
-
Excel 2010 – 2.1.5 – Calculate across Workbooks using a Formula
-
Excel 2010 – 2.1.6 – Calculate across Workbooks using a Function
-
Excel 2010 – 2.1.7 – Calculate with a constant VAT value across Worksheets
-
Excel 2010 – 2.1.8 – How Visual Rounding can create incorrect results
-
Excel 2010 – 2.1.9 – Nest a constant VAT Formula into the ROUND Function
- Excel 2010 – 2.1.1 – Link to another Worksheet
- Excel 2010 – 2.1.2 – Link to another Workbook
- Excel 2010 – 2.1.3 – Calculate across Worksheets using a Formula
- Excel 2010 – 2.1.4 – Calculate across Worksheets using a Function
- Excel 2010 – 2.1.5 – Calculate across Workbooks using a Formula
- Excel 2010 – 2.1.6 – Calculate across Workbooks using a Function
- Excel 2010 – 2.1.7 – Calculate with a constant VAT value across Worksheets
- Excel 2010 – 2.1.8 – How Visual Rounding can create incorrect results
- Excel 2010 – 2.1.9 – Nest a constant VAT Formula into the ROUND Function
3
Lesson 3 – Working with IF and Related Functions
-
Excel 2010 – 2.3.1 – About the IF Function
-
Excel 2010 – 2.3.2 – Create an IF Function
-
Excel 2010 – 2.3.3 – Use Text with the IF Function
-
Excel 2010 – 2.3.4 -The AND Function
-
Excel 2010 – 2.3.5 – Nesting an AND Function into an IF Function
-
Excel 2010 – 2.3.6 – Nesting an OR Function into an IF Function
-
Excel 2010 – 2.3.7 – Nesting an IF Function into an IF Function
-
Excel 2010 – 2.3.8 – How does nesting IF Functions within IF Functions work?
-
Excel 2010 – 2.3.9 – Create and use a SUMIF Function
-
Excel 2010 – 2.3.10 – Create and use an AVERAGEIF Function
-
Excel 2010 – 2.3.11 – Create and use a COUNTIF Function
-
Excel 2010 – 2.3.12 – Using SUMIFS
-
Excel 2010 – 2.3.13 – Using AVERAGEIFS
-
Excel 2010 – 2.3.14 – Using COUNTIFS
- Excel 2010 – 2.3.1 – About the IF Function
- Excel 2010 – 2.3.2 – Create an IF Function
- Excel 2010 – 2.3.3 – Use Text with the IF Function
- Excel 2010 – 2.3.4 -The AND Function
- Excel 2010 – 2.3.5 – Nesting an AND Function into an IF Function
- Excel 2010 – 2.3.6 – Nesting an OR Function into an IF Function
- Excel 2010 – 2.3.7 – Nesting an IF Function into an IF Function
- Excel 2010 – 2.3.8 – How does nesting IF Functions within IF Functions work?
- Excel 2010 – 2.3.9 – Create and use a SUMIF Function
- Excel 2010 – 2.3.10 – Create and use an AVERAGEIF Function
- Excel 2010 – 2.3.11 – Create and use a COUNTIF Function
- Excel 2010 – 2.3.12 – Using SUMIFS
- Excel 2010 – 2.3.13 – Using AVERAGEIFS
- Excel 2010 – 2.3.14 – Using COUNTIFS
4
Lesson 4 – Working with the LOOKUP Functions
-
Excel 2010 – 2.4.1 – About LOOKUP Functions
-
Excel 2010 – 2.4.2 – Create a VLOOKUP Function
-
Excel 2010 – 2.4.3 – How a VLOOKUP Function can produce the wrong result
-
Excel 2010 – 2.4.4 – Create a VLOOKUP without using an ‘exact match’
-
Excel 2010 – 2.4.4 – Create a VLOOKUP without using an 'exact match'
-
Excel 2010 – 2.4.5 – Create a VLOOKUP to another Workbook
-
Excel 2010 – 2.4.6 – Combine the VLOOKUP Function with the Naming feature
-
Excel 2010 – 2.4.7 – Create a VLOOKUP with a Named Range to another Workbook
-
Excel 2010 – 2.4.8 – Create a Dropdown Menu with Data Validation
-
Excel 2010 – 2.4.9 – Create a HLOOKUP
-
Excel 2010 – 2.4.10 – Create a Vector LOOKUP
-
Excel 2010 – 2.4.11 – Create an Array LOOKUP
- Excel 2010 – 2.4.1 – About LOOKUP Functions
- Excel 2010 – 2.4.2 – Create a VLOOKUP Function
- Excel 2010 – 2.4.3 – How a VLOOKUP Function can produce the wrong result
- Excel 2010 – 2.4.4 – Create a VLOOKUP without using an ‘exact match’
- Excel 2010 – 2.4.4 – Create a VLOOKUP without using an 'exact match'
- Excel 2010 – 2.4.5 – Create a VLOOKUP to another Workbook
- Excel 2010 – 2.4.6 – Combine the VLOOKUP Function with the Naming feature
- Excel 2010 – 2.4.7 – Create a VLOOKUP with a Named Range to another Workbook
- Excel 2010 – 2.4.8 – Create a Dropdown Menu with Data Validation
- Excel 2010 – 2.4.9 – Create a HLOOKUP
- Excel 2010 – 2.4.10 – Create a Vector LOOKUP
- Excel 2010 – 2.4.11 – Create an Array LOOKUP
5
Lesson 5 – Sorting Data
-
Excel 2010 – 2.5.1 – Tips on the Best Way to Layout a Table or List of Data
-
Excel 2010 – 2.5.2 – Carry out a Basic Sort
-
Excel 2010 – 2.5.3 – Carry out a Multi-level Sort
-
Excel 2010 – 2.5.4 – Sort by Colour
-
Excel 2010 – 2.5.5 – Create a Custom Sort
-
Excel 2010 – 2.5.6 – Sort by Row instead of by Column
- Excel 2010 – 2.5.1 – Tips on the Best Way to Layout a Table or List of Data
- Excel 2010 – 2.5.2 – Carry out a Basic Sort
- Excel 2010 – 2.5.3 – Carry out a Multi-level Sort
- Excel 2010 – 2.5.4 – Sort by Colour
- Excel 2010 – 2.5.5 – Create a Custom Sort
- Excel 2010 – 2.5.6 – Sort by Row instead of by Column
6
Lesson 6 – Filtering Data
-
Excel 2010 – 2.6.1 – Create a Basic Filter
-
Excel 2010 – 2.6.2 – Create a Quick Filter using the Right Click
-
Excel 2010 – 2.6.3 – Apply a Filter using Multiple Criteria
-
Excel 2010 – 2.6.4 – Create a Numeric Filter (e.g. a Price Range)
-
Excel 2010 – 2.6.5 – Create a Top 10 Filter
-
Excel 2010 – 2.6.6 – Create Date Filters
-
Excel 2010 – 2.6.7 – Things to know about when Calculating with a Filter
-
Excel 2010 – 2.6.8 – Create an Advanced Filter
-
Excel 2010 – 2.6.9 – Show Unique Records from One Column
-
Excel 2010 – 2.6.10 – Filter and Copy Data to another Worksheet
- Excel 2010 – 2.6.1 – Create a Basic Filter
- Excel 2010 – 2.6.2 – Create a Quick Filter using the Right Click
- Excel 2010 – 2.6.3 – Apply a Filter using Multiple Criteria
- Excel 2010 – 2.6.4 – Create a Numeric Filter (e.g. a Price Range)
- Excel 2010 – 2.6.5 – Create a Top 10 Filter
- Excel 2010 – 2.6.6 – Create Date Filters
- Excel 2010 – 2.6.7 – Things to know about when Calculating with a Filter
- Excel 2010 – 2.6.8 – Create an Advanced Filter
- Excel 2010 – 2.6.9 – Show Unique Records from One Column
- Excel 2010 – 2.6.10 – Filter and Copy Data to another Worksheet
8
Lesson 8 – Tables
-
Excel 2010 – 2.8.1 – Set or Remove the Table feature
-
Excel 2010 – 2.8.2 – Some useful Table Features
-
Excel 2010 – 2.8.3 – Calculate Data in a Table
-
Excel 2010 – 2.8.4 – Insert Table Rows and Columns
-
Excel 2010 – 2.8.5 – Create a Calculation outside a Table
-
Excel 2010 – 2.8.6 – Issues with Relative Referencing and Calculations outside a Table
- Excel 2010 – 2.8.1 – Set or Remove the Table feature
- Excel 2010 – 2.8.2 – Some useful Table Features
- Excel 2010 – 2.8.3 – Calculate Data in a Table
- Excel 2010 – 2.8.4 – Insert Table Rows and Columns
- Excel 2010 – 2.8.5 – Create a Calculation outside a Table
- Excel 2010 – 2.8.6 – Issues with Relative Referencing and Calculations outside a Table
9
Lesson 9 – Present Data as a Chart
-
Excel 2010 – 2.9.1 – Create a Basic Column Chart
-
Excel 2010 – 2.9.2 – Format a Chart using the Design Tab
-
Excel 2010 – 2.9.3 – Format a Chart using the Layout Tab
-
Excel 2010 – 2.9.4 – Format a Chart using the Format Tab
-
Excel 2010 – 2.9.5 – The Special Printing features of Charts
-
Excel 2010 – 2.9.6 – Create a Pie Chart
-
Excel 2010 – 2.9.7 – Specific Formats for a Pie Chart
- Excel 2010 – 2.9.1 – Create a Basic Column Chart
- Excel 2010 – 2.9.2 – Format a Chart using the Design Tab
- Excel 2010 – 2.9.3 – Format a Chart using the Layout Tab
- Excel 2010 – 2.9.4 – Format a Chart using the Format Tab
- Excel 2010 – 2.9.5 – The Special Printing features of Charts
- Excel 2010 – 2.9.6 – Create a Pie Chart
- Excel 2010 – 2.9.7 – Specific Formats for a Pie Chart