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