DIGITAL LITERACY

ADVANCED MICROSOFT EXCEL 2013

MODULE 1

0101.Will I Be Able To Keep Up.mp4

I Will Be Able To Keep Up

0102.Using The Included Files.mp4

Using The Included Files

0103.New For 2013 Its All In The Cloud.mp4

New For 2013 - Its All In The Cloud

0104.The Very Clever Flash Fill.mp4

The Very Clever Flash Fill

MODULE 2

0201.The Basic SUM, COUNT, MIN, And MAX.mp4

The Basic SUM, COUNT, MIN and MAX

0202.AVERAGE, MODE, MEAN, And MEDIAN.mp4

AVERAGE, MODE, MEAN, And MEDIAN

0203.SUMIF For Selective Adding Up.mp4

SUMIF For Selective Adding Up

0204.COUNTIF For Selective Counting.mp4

COUNTIF For Selective Counting

0205.AVERAGEIF For The Mean Of Selected Cells.mp4

AVERAGEIF For The Mean Of Selected Cells

0206.Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF.mp4

Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF

0207.Area And Volume Calculations.mp4

Area And Volume Calculations

MODULE 3

0301.IF Syntax And Uses.mp4

IF Syntax And Uses

0302.Nesting The IF Statement.mp4

Nesting The IF Statement

0303.Use Of The AND Operator Within An IF.mp4

Use Of The AND Operator Within An IF

0304.Use Of The OR Operator Within An IF.mp4

Use Of The OR Operator Within An IF

0305.The NOT Operator Within AND And OR Statements.mp4

The NOT Operator Within AND And OR Statements

0306.Display Cell Formulas In Another Cell.mp4

Display Cell Formulas In Another Cell

MODULE 4

0401.VLOOKUP Syntax And Usage.mp4

VLOOKUP Syntax And Usage

0402.VLOOKUP In Live Action.mp4

VLOOKUP In Live Action

0403.HLOOKUP Variation On A Theme.mp4

HLOOKUP Variation On A Theme

0404.Using A Near Match In The Lookup.mp4

Using A Near Match In The Lookup

0405.Dealing With Missing Data In A Lookup.mp4

Dealing With Missing Data In A Lookup

0406.Managing The Lookup Table.mp4

Managing The Lookup Table

0407.Lookups Nested Within Lookups.mp4

Lookups Nested Within Lookups

MODULE 5

0501.Creating A Sparkline.mp4

Creating A Sparkline

0502.Altering The Design Of Sparklines.mp4

Altering The Design Of Sparklines

0503.Dealing With Empty Cells.mp4

Dealing With Empty Cells

0504.Comparing Sparklines Within A Sparkline Group.mp4

Comparing Sparklines Within A Sparkline Group

0505.Removing Sparklines From A Worksheet.mp4

Removing Sparklines From A Worksheet

MODULE 6

0601.Working With Time In Excel.mp4

Working With Time In Excel

0602.Calculations Using Time.mp4

Calculations Using Time

0603.Useful Time And Date Functions.mp4

Useful Time And Date Functions

0604.Rounding Decimal Places.mp4

Rounding Decimal Places

0605.MOD And INT Functions And Uses.mp4

MOD And INT Functions And Uses

0606.Generate And Use A Random Number.mp4

Generate And Use A Random Number

0607.Loan And Investment Calculations.mp4

Loan And Investment Calculations

0608.Loan Calculation Elements And Functions.mp4

Loan Calculation Elements And Functions

MODULE 7

0701.Create An Outline Automatically.mp4

Create An Outline Automatically

0702.Adding An Outline Manually.mp4

Adding An Outline Manually

0703.Editing And Removing Outlining.mp4

Editing And Removing Outlining

MODULE 8

0801.Setting Up A Set Of Scenarios.mp4

Setting Up A Set Of Scenarios

0802.Displaying And Editing The Different Scenarios.mp4

Displaying And Editing The Different Scenarios

0803.How To Work Out Which Scenario You Are Displaying.mp4

How To Work Out Which Scenario You Are Displaying.

0804.Merging And Deleting Scenarios.mp4

Merging And Deleting Scenarios

0805.Producing A Summary Of Scenarios.mp4

Producing A Summary Of Scenarios

MODULE 9

0901.Custom Views Explained.mp4

Custom Views Explained

0902.Use Of Outlining To Help Setup Custom Views.mp4

Use Of Outlining To Help Setup Custom Views

0903.Editing And Deleting Custom Views.mp4

Editing And Deleting Custom Views

0904.Add Quick Access To Custom Views.mp4

Add Quick Access To Custom Views

MODULE 10

1001.LEFT And RIGHT Text Manipulation.mp4

LEFT And RIGHT Text Manipulation

1002.LEN And TRIM String Extractions.mp4

LEN And TRIM String Extractions

1003.FIND And MID Text Functions Working Together.mp4

FIND And MID Text Functions Working Together

1004.CONCATENATE Building Strings From Multiple Cells.mp4

CONCATENATE Building Strings From Multiple Cells

1005.Changing Case Functions.mp4

Changing Case Functions

1006.REPLACE And SUBSTITUTE Two More String Manipulation Functions.mp4

REPLACE And SUBSTITUTE Two More String Manipulation Functions

1007.Use Of CHAR Function For More Obscure Characters.mp4

Use Of CHAR Function For More Obscure Characters

1008.Formatting Numeric And Date Values Using TEXT.mp4

Formatting Numeric And Date Values Using TEXT

1009.Keeping The Values Created By String Manipulation.mp4

Keeping The Values Created By String Manipulation

MODULE 11

1101.Arrays And Creating A New Array Formula.mp4

Arrays And Creating A New Array Formula

1102.Array Formulas With IF Statements.mp4

Array Formulas With IF Statements

1103.Conditional Evaluation With No IFs.mp4

Conditional Evaluation With No IFs

1104.The Array-Only TRANSPOSE Function.mp4

The Array-Only TRANSPOSE Function

MODULE 12

1201.Using The MATCH Function.mp4

Using The MATCH Function

1202.How The INDEX Function Works.mp4

How The INDEX Function Works

1203.Handling Out Of Range Index Requests.mp4

Handling Out Of Range Index Requests

1204.The CHOOSE Lookup Function.mp4

The CHOOSE Lookup Function

1205.MATCH And INDEX Functions Working Together.mp4

MATCH And INDEX Functions Working Together

MODULE 13

1301.Introducing IS Functions.mp4

Introducing IS Functions

1302.Error Checking Using ISERR, ISERROR, And IFERROR.mp4

Error Checking Using ISERR, ISERROR, And IFERROR

1303.OFFSET Function Syntax.mp4

OFFSET Function Syntax

1304.OFFSET Function Creating A Dynamic Named Range.mp4

OFFSET Function Creating A Dynamic Named Range

1305.INDIRECT Function To Build Dynamic Formulas.mp4

INDIRECT Function To Build Dynamic Formulas

1306.Dealing With INDIRECT Errors.mp4

Dealing With INDIRECT Errors

1307.The CELL Function And Determining File Or Sheet Names.mp4

The CELL Function And Determining File Or Sheet Names

MODULE 14

1401.What Are Tracer Arrows.mp4

What Are Tracer Arrows

1402.Adding And Removing Tracer Arrows.mp4

Adding And Removing Tracer Arrows

1403.Auditing Tools Error Checking And Tracing.mp4

Auditing Tools Error Checking And Tracing

1404.Step-By-Step Formula Processing.mp4

Step-By-Step Formula Processing

1405.Using The Watch Window In Troubleshooting.mp4

Using The Watch Window In Troubleshooting

MODULE 15

1501.What Is A PivotTable.mp4

What Is A PivotTable

1502.The New Recommended PivotTable Route.mp4

The New Recommended PivotTable Route

1503.Creating Your Own PivotTables.mp4

Creating Your Own PivotTables

1504.Changing The Formatting And Formulas In PivotTable Summaries.mp4

Changing The Formatting And Formulas In PivotTable Summaries

1505.Creating Multiple PivotTables On The Same Dataset.mp4

Creating Multiple PivotTables On The Same Dataset.

1506.Moving And Deleting PivotTables.mp4

Moving And Deleting PivotTables

1507.Making Use Of The Report Filter Options.mp4

Making Use Of The Report Filter Options

1508.Sorting The PivotTable Columns.mp4

Sorting The PivotTable Columns

1509.Refreshing A PivotTable.mp4

Refreshing A PivotTable

1510.Drilling Down Behind The Pivot Numbers.mp4

Drilling Down Behind The Pivot Numbers

1511.Multiple Fields In Row, Column, Or Data Sections.mp4

Multiple Fields In Row, Column, Or Data Sections

1512.Controlling Grand Totals And Subtotals.mp4

Controlling Grand Totals And Subtotals

1513.Dealing With Empty Cells And Other Additional Options.mp4

Dealing With Empty Cells And Other Additional Options

1514.PivotTable Styles.mp4

PivotTable Styles

1515.Creating Your Own PivotTable Styles.mp4

Creating Your Own PivotTable Styles

1516.Creating And Using Calculated Fields.mp4

Creating And Using Calculated Fields

1517.Using The New Timeline Filter Option.mp4

Using The New Timeline Filter Option

1518.Adding And Using The Data Slicer.mp4

Adding And Using The Data Slicer

1519.Using Data From An SQL Server In A PivotTable.mp4

Using Data From An SQL Server In A PivotTable

1520.Managing The External Connection To SQL Server.mp4

Managing The External Connection To SQL Server

MODULE 16

1601.Creating A PivotChart.mp4

Creating A PivotChart

1602.Changing The Fields Used In A PivotChart.mp4

Changing The Fields Used In A PivotChart

1603.Formatting The PivotChart.mp4

Formatting The PivotChart

1604.Changing The PivotChart Type.mp4

Changing The PivotChart Type

1605.Filtering A PivotChart.mp4

Filtering A PivotChart

1606.Hiding The PivotChart Buttons.mp4

Hiding The PivotChart Buttons

1607.Moving And Deleting PivotCharts.mp4

Moving And Deleting PivotCharts

MODULE 17

1701.What-If Analysis Using Goal Seek.mp4

What-If Analysis Using Goal Seek

1702.Activating The Solver Add-In.mp4

Activating The Solver Add-In

1703.Using Solver To Complete A What-If.mp4

Using Solver To Complete A What-If.

1704.Adding Constraints To Solver.mp4

Adding Constraints To Solver

MODULE 18

1801.What Is A Macro.mp4

What Is A Macro

1802.Creating And Running Your First Macro.mp4

Creating And Running Your First Macro

1803.Saving Workbooks With Macros.mp4

Saving Workbooks With Macros

1804.Macro Security Settings For Workbooks With Macros.mp4

Macro Security Settings For Workbooks With Macros

1805.The Personal Macro Workbook.mp4

The Personal Macro Workbook

1806.Deleting Macros.mp4

Deleting Macros

1807.Use Of Relative Or Absolute Referencing.mp4

Use Of Relative Or Absolute Referencing

1808.Trigger A Macro With A Keyboard Shortcut.mp4

Trigger A Macro With A Keyboard Shortcut

1809.Formatting With A Macro.mp4

Formatting With A Macro

1810.Switch Scenarios And Views With Macros.mp4

Switch Scenarios And Views With Macros

1811.Use Of Worksheet Buttons To Trigger Macros.mp4

Use Of Worksheet Buttons To Trigger Macros

1812.Customizing Form Buttons And Other Shape Triggers.mp4

Customizing Form Buttons And Other Shape Triggers

1813.Assigning Macros To Ribbon Icons.mp4

Assigning Macros To Ribbon Icons

1814.Create Your Own Ribbon.mp4

Create Your Own Ribbon

1815.View And Edit Macro Code.mp4

View And Edit Macro Code

1816.Add An Are You Sure Box To Macros.mp4

Add An Are You Sure Box To Macros

MODULE 19

1901.What Have I Learned.mp4

What Have I Learned

1902.About The Author.mp4

About The Author

Working Files

Completion Form

Page updated

Report abuse