Excel 2010 Level 3

Excel 2010 Level 3

The videos in this suite of Lessons are for those who wish to delve deeper. Specifically through PivotTables you will enhance the presentation and organisation of your data. Investigate also the value of the SumProduct, Index and Match functions and learn to provide focus to text and figures through Conditional Formatting.

Subscribe to this Course

Course Content

Expand All | Collapse All

Lessons Status

1

Lesson 1 – Working with Basic PivotTables

Excel 2010 – 3.1.1 – View and Set up Pivot Data

Excel 2010 – 3.1.2 – Create a Basic PivotTable

Excel 2010 – 3.1.3 – Add a Currency Style to Pivot Data

Excel 2010 – 3.1.4 – Group a PivotTable by Date

Excel 2010 – 3.1.5 – Filter and Ungroup Pivot Data

Excel 2010 – 3.1.6 – Drill into Pivot Data

Excel 2010 – 3.1.7 – Drilldown into Pages

Excel 2010 – 3.1.8 – Create a PivotChart

Excel 2010 – 3.1.9 – Insert and use Slicers

Excel 2010 – 3.1.10 – Manually Refresh PivotTable Data

Excel 2010 – 3.1.11 – Automatically Refresh PivotTable Data

2

Lesson 2 – Customising PivotTables

Excel 2010 3.2.1 – How to Display Blank Cells

Excel 2010 3.2.2 – Rename Field Headings

Excel 2010 3.2.3 – How to Change the Pivot Layout

Excel 2010 3.2.4 – Set PivotTable Styles

3

Lesson 3 – Sorting & Filtering in a PivotTable

Excel 2010 3.3.1 – Basic Sorting in a PivotTable

Excel 2010 3.3.2 – Create a Manual Sort

Excel 2010 3.3.3 – Create a Custom List Sort

Excel 2010 3.3.4 – Filter PivotTable Information by Date

Excel 2010 3.3.5 – Apply the ‘Top 10…’ Filter

Excel 2010 3.3.5 – Apply the 'Top 10…' Filter

Excel 2010 3.3.6 – Applying Slicers to Multiple PivotTables

4

Lesson 4 – Grouping in a PivotTable

Excel 2010 3.4.1 – Group by Numbers

Excel 2010 3.4.2 – Group Dates by Week

Excel 2010 3.4.3 – Group Data by Text

5

Lesson 5 – Calculating in a PivotTable

Excel 2010 3.5.1 – Create Average and Count Calculations

Excel 2010 3.5.2 – Using % Difference From …

Excel 2010 3.5.3 – Using % of Grand Total

Excel 2010 3.5.4 – Using Rank

Excel 2010 3.5.5 – Using % Of …

Excel 2010 3.5.6 – Using % of Row Total

Excel 2010 3.5.7 – Create a Calculated Field

Excel 2010 3.5.8 – Create a Calculated Item

6

Lesson 6 – Working with Macros

Excel 2010 3.6.1 – What is a Macro?

Excel 2010 3.6.2 – Create a Macro

Excel 2010 3.6.3 – Saving a Macro in an Excel Workbook

Excel 2010 3.6.4 – Open a Workbook Containing a Macro

Excel 2010 3.6.5 – Create a Button for a Macro

Excel 2010 3.6.6 – Move a Macro to the Personal Workbook.xlsb

7

Lesson 7 – Conditional Formatting using Formulas

Excel 2010 3.7.1 – Display Icons using Conditional Formatting and a Formula

Excel 2010 3.7.2 – With Conditional Formatting show Today and 7 Days from Now

Excel 2010 3.7.3 – Apply Conditional Formatting with Data Validation

Excel 2010 3.7.4 – Conditional Formatting with Targets

Excel 2010 3.7.5 – Conditional Formatting with Text (e.g. an Issue Log)

Excel 2010 3.7.6 – Conditional Formatting with VLOOKUP

Excel 2010 3.7.7 – Apply Conditional Formatting to Create Banded Rows

Excel 2010 3.7.8 – Use Conditional Formatting to Create a Risk Register

8

Lesson 8 – Applying ‘Left Lookup’

Excel 2010 – 3.8.1 – Why do you need a ‘Left Lookup’?

Excel 2010 – 3.8.1 – Why do you need a 'Left Lookup'?

Excel 2010 – 3.8.2 – How the MATCH Function works

Excel 2010 – 3.8.3 – How the INDEX Function works

Excel 2010 – 3.8.4 – Combine the INDEX and MATCH Functions

Excel 2010 – 3.8.5 – Nest two MATCH Functions into an INDEX Function

Excel 2010 – 3.8.6 – Applying INDEX and MATCH Functions across Worksheets

Excel 2010 – 3.8.7 – Using ‘Left Lookup’ with ‘Naming’

Excel 2010 – 3.8.7 – Using 'Left Lookup' with 'Naming'

9

Lesson 9 – The SUMPRODUCT Function

Excel 2010 – 3.9.1 – Introduction to SUMPRODUCT

Excel 2010 – 3.9.2 – Using Three Fields

Excel 2010 – 3.9.3 – Using Four Fields

Excel 2010 – 3.9.4 – SUMPRODUCT with Conditions

Excel 2010 – 3.9.5 – How SUMPRODUCT Conditions work

Excel 2010 – 3.9.6 – Using Two Conditions with SUMPRODUCT

Excel 2010 – 3.9.7 – Using Three Conditions with SUMPRODUCT

Excel 2010 – 3.9.8 – Calculate a Table of Values with SUMPRODUCT