Excel 2010 Level 2

Excel 2010 Level 2

Current Status

Not Enrolled

Price

Closed

Get Started

Subscribe to this Course

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

Expand All

Lesson 1 – Linking and 3-D Calculation 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

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

Lesson 2 – Naming Cells and Ranges 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Excel 2010 – 2.2.1 – About Naming Cells and Ranges

Excel 2010 – 2.2.2 – Name a Cell

Excel 2010 – 2.2.3 – Autocreate Names

Excel 2010 – 2.2.4 – Edit or Delete Names

Lesson 3 – Working with IF and Related Functions 14 Topics

Expand

Lesson Content

0% Complete 0/14 Steps

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

Lesson 4 – Working with the LOOKUP Functions 12 Topics

Expand

Lesson Content

0% Complete 0/12 Steps

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

Lesson 5 – Sorting Data 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

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

Lesson 6 – Filtering Data 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

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

Lesson 7 – Subtotals 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Excel 2010 – 2.7.1 – Create a Basic Subtotal

Excel 2010 – 2.7.2 – Create Multiple Subtotals

Excel 2010 – 2.7.3 – Create a Multi-level Subtotal

Excel 2010 – 2.7.4 – Use ‘visible cells only’ to Copy Subtotals

Excel 2010 – 2.7.4 – Use 'visible cells only' to Copy Subtotals

Lesson 8 – Tables 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

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

Lesson 9 – Present Data as a Chart 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

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

Lesson 10 – Working with Large Data 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Excel 2010 – 2.10.1 – Freeze Panes

Excel 2010 – 2.10.2 – Split Screen

Excel 2010 – 2.10.3 – Show the same Workbook Twice on the Screen

Excel 2010 – 2.10.4 – Scale Data to Fit on One Printed Page