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.
Course Content
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
- 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
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
- 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
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
- 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
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
- 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'
- 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
- 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