Advanced Online Excel Training 

0102 Using The Included Files

0103 New For 2013: Its All In The Cloud

0104 The Very Clever Flash Fill

0201 The Basic SUM, COUNT, MIN, And MAX

0202 AVERAGE, MODE, MEAN, And MEDIAN

0203 SUMIF For Selective Adding Up

0204 COUNTIF For Selective Counting

0205 AVERAGEIF For The Mean Of Selected Cells

0206 Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF

0207 Area And Volume Calculations

0301 IF Syntax And Uses

0302 Nesting The IF Statement

0303 Use Of The AND Operator Within An IF

0304 Use Of The OR Operator Within An IF

0305 The NOT Operator Within AND And OR Statements

0306 Display Cell Formulas In Another Cell

0401 VLOOKUP: Syntax And Usage

0402 VLOOKUP In Live Action

0403 HLOOKUP: Variation On A Theme

0404 Using A Near Match In The Lookup

0405 Dealing With Missing Data In A Lookup

0406 Managing The Lookup Table

0407 Lookups Nested Within Lookups

0501 Creating A Sparkline

0502 Altering The Design Of Sparklines

0503 Dealing With Empty Cells

0504 Comparing Sparklines Within A Sparkline Group

0505 Removing Sparklines From A Worksheet

0601 Working With Time In Excel

0602 Calculations Using Time

0603 Useful Time And Date Functions

0604 Rounding Decimal Places

0605 MOD And INT Functions And Uses

0606 Generate And Use A Random Number

0607 Loan And Investment Calculations

0608 Loan Calculation Elements And Functions

0701 Create An Outline Automatically

0702 Adding An Outline Manually

0703 Editing And Removing Outlining

0801 Setting Up A Set Of Scenarios

0802 Displaying And Editing The Different Scenarios

0803 How To Work Out Which Scenario You Are Displaying

0804 Merging And Deleting Scenarios

0805 Producing A Summary Of Scenarios

0901 Custom Views Explained

0902 Use Of Outlining To Help Setup Custom Views

0903 Editing And Deleting Custom Views

0904 Add Quick Access To Custom Views

1001 LEFT And RIGHT: Text Manipulation

1002 LEN And TRIM: String Extractions

1003 FIND And MID: Text Functions Working Together

1004 CONCATENATE: Building Strings From Multiple Cells

1005 Changing Case Functions

1006 REPLACE And SUBSTITUTE: Two More String Manipulation Functions

1007 Use Of CHAR Function For More Obscure Characters

1008 Formatting Numeric And Date Values Using TEXT

1009 Keeping The Values Created By String Manipulation

1101 Arrays And Creating A New Array Formula

1102 Array Formulas With IF Statements

1103 Conditional Evaluation With No IFs

1104 The Array-Only TRANSPOSE Function

1201 Using The MATCH Function

1202 How The INDEX Function Works

1203 Handling Out Of Range Index Requests

1204 The CHOOSE Lookup Function

1205 MATCH And INDEX Functions Working Together

1301 Introducing IS Functions

1302 Error Checking Using ISERR, ISERROR, And IFERROR

1303 OFFSET Function Syntax

1304 OFFSET Function: Creating A Dynamic Named Range

1305 INDIRECT Function To Build Dynamic Formulas

1306 Dealing With INDIRECT Errors

1307 The CELL Function And Determining File Or Sheet Names

1401 What Are Tracer Arrows

1402 Adding And Removing Tracer Arrows

1403 Auditing Tools: Error Checking And Tracing

1404 Step-By-Step Formula Processing

1405 Using The Watch Window In Troubleshooting

1501 What Is A PivotTable?

1502 The New Recommended PivotTable Route

1503 Creating Your Own PivotTables

1504 Changing The Formatting And Formulas In PivotTable Summaries

1505 Creating Multiple PivotTables On The Same Dataset

1506 Moving And Deleting PivotTables

1507 Making Use Of The Report Filter Options

1508 Sorting The PivotTable Columns

1509 Refreshing A PivotTable

1510 Drilling Down Behind The Pivot Numbers

1511 Multiple Fields In Row, Column, Or Data Sections

1512 Controlling Grand Totals And Subtotals

1513 Dealing With Empty Cells And Other Additional Options

1514 PivotTable Styles

1515 Creating Your Own PivotTable Styles

1516 Creating And Using Calculated Fields

1517 Using The New Timeline Filter Option

1518 Adding And Using The Data Slicer

1519 Using Data From An SQL Server In A PivotTable

1520 Managing The External Connection To SQL Server