Filename Size 0104.The Very Clever Flash Fill.mp4 12.5 MB 0203.SUMIF For Selective Adding Up.mp4 13.1 MB 0206.Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF.mp4 16.5 MB 0301.IF Syntax And Uses.mp4 17.1 MB 0302.Nesting The IF Statement.mp4 17.4 MB 0303.Use Of The AND Operator Within An IF.mp4 15.4 MB 0304.Use Of The OR Operator Within An IF.mp4 9.5 MB 0305.The NOT Operator Within AND And OR Statements.mp4 10.7 MB 0306.Display Cell Formulas In Another Cell.mp4 12.6 MB 0401.VLOOKUP Syntax And Usage.mp4 12 MB 0402.VLOOKUP In Live Action.mp4 19.6 MB 0403.HLOOKUP Variation On A Theme.mp4 14.2 MB 0405.Dealing With Missing Data In A Lookup.mp4 13.1 MB 0406.Managing The Lookup Table.mp4 18.2 MB 0407.Lookups Nested Within Lookups.mp4 18.9 MB 0501.Creating A Sparkline.mp4 13.8 MB 0502.Altering The Design Of Sparklines.mp4 12.1 MB 0504.Comparing Sparklines Within A Sparkline Group.mp4 11.2 MB 0601.Working With Time In Excel.mp4 23.4 MB 0602.Calculations Using Time.mp4 10.9 MB 0603.Useful Time And Date Functions.mp4 11.5 MB 0604.Rounding Decimal Places.mp4 10.4 MB 0605.MOD And INT Functions And Uses.mp4 10.9 MB 0606.Generate And Use A Random Number.mp4 13.6 MB 0607.Loan And Investment Calculations.mp4 12.9 MB 0608.Loan Calculation Elements And Functions.mp4 9.6 MB 0701.Create An Outline Automatically.mp4 10 MB 0702.Adding An Outline Manually.mp4 10.4 MB 0703.Editing And Removing Outlining.mp4 19 MB 0801.Setting Up A Set Of Scenarios.mp4 20.6 MB 0803.How To Work Out Which Scenario You Are Displaying.mp4 13.1 MB 0804.Merging And Deleting Scenarios.mp4 10.8 MB 0805.Producing A Summary Of Scenarios.mp4 14.6 MB 0902.Use Of Outlining To Help Setup Custom Views.mp4 11.9 MB 0903.Editing And Deleting Custom Views.mp4 12.2 MB 0904.Add Quick Access To Custom Views.mp4 10.8 MB 1001.LEFT And RIGHT Text Manipulation.mp4 14.6 MB 1002.LEN And TRIM String Extractions.mp4 22.5 MB 1003.FIND And MID Text Functions Working Together.mp4 23.3 MB 1004.CONCATENATE Building Strings From Multiple Cells.mp4 23 MB 1005.Changing Case Functions.mp4 13.4 MB 1006.REPLACE And SUBSTITUTE Two More String Manipulation Functions.mp4 16.9 MB 1007.Use Of CHAR Function For More Obscure Characters.mp4 20.2 MB 1008.Formatting Numeric And Date Values Using TEXT.mp4 16.6 MB 1009.Keeping The Values Created By String Manipulation.mp4 11.9 MB 1101.Arrays And Creating A New Array Formula.mp4 13.7 MB 1102.Array Formulas With IF Statements.mp4 15.4 MB 1103.Conditional Evaluation With No IFs.mp4 24.2 MB 1104.The Array-Only TRANSPOSE Function.mp4 16 MB 1201.Using The MATCH Function.mp4 20.7 MB 1202.How The INDEX Function Works.mp4 15 MB 1203.Handling Out Of Range Index Requests.mp4 9.3 MB 1204.The CHOOSE Lookup Function.mp4 9.9 MB 1205.MATCH And INDEX Functions Working Together.mp4 15 MB 1302.Error Checking Using ISERR, ISERROR, And IFERROR.mp4 16.3 MB 1303.OFFSET Function Syntax.mp4 10.4 MB 1304.OFFSET Function Creating A Dynamic Named Range.mp4 16.5 MB 1305.INDIRECT Function To Build Dynamic Formulas.mp4 11.8 MB 1306.Dealing With INDIRECT Errors.mp4 9.5 MB 1307.The CELL Function And Determining File Or Sheet Names.mp4 18.1 MB 1401.What Are Tracer Arrows.mp4 12.1 MB 1403.Auditing Tools Error Checking And Tracing.mp4 17.4 MB 1404.Step-By-Step Formula Processing.mp4 10.7 MB 1405.Using The Watch Window In Troubleshooting.mp4 13.1 MB 1501.What Is A PivotTable.mp4 24.7 MB 1502.The New Recommended PivotTable Route.mp4 17.9 MB 1503.Creating Your Own PivotTables.mp4 18.3 MB 1504.Changing The Formatting And Formulas In PivotTable Summaries.mp4 14.6 MB 1505.Creating Multiple PivotTables On The Same Dataset.mp4 16.9 MB 1506.Moving And Deleting PivotTables.mp4 11.6 MB 1507.Making Use Of The Report Filter Options.mp4 14.9 MB 1508.Sorting The PivotTable Columns.mp4 17.5 MB 1509.Refreshing A PivotTable.mp4 10.2 MB 1510.Drilling Down Behind The Pivot Numbers.mp4 13.3 MB 1511.Multiple Fields In Row, Column, Or Data Sections.mp4 17 MB 1512.Controlling Grand Totals And Subtotals.mp4 15.3 MB 1513.Dealing With Empty Cells And Other Additional Options.mp4 17.1 MB 1514.PivotTable Styles.mp4 21.9 MB 1515.Creating Your Own PivotTable Styles.mp4 20.5 MB 1516.Creating And Using Calculated Fields.mp4 12.4 MB 1517.Using The New Timeline Filter Option.mp4 15.3 MB 1518.Adding And Using The Data Slicer.mp4 19.7 MB 1519.Using Data From An SQL Server In A PivotTable.mp4 14.6 MB 1601.Creating A PivotChart.mp4 11.5 MB 1602.Changing The Fields Used In A PivotChart.mp4 11.6 MB 1603.Formatting The PivotChart.mp4 16.1 MB 1604.Changing The PivotChart Type.mp4 12.7 MB 1605.Filtering A PivotChart.mp4 10.2 MB 1607.Moving And Deleting PivotCharts.mp4 13.3 MB 1703.Using Solver To Complete A What-If.mp4 13.4 MB 1704.Adding Constraints To Solver.mp4 11.4 MB 1802.Creating And Running Your First Macro.mp4 12.1 MB 1804.Macro Security Settings For Workbooks With Macros.mp4 10.4 MB 1810.Switch Scenarios And Views With Macros.mp4 15.5 MB 1811.Use Of Worksheet Buttons To Trigger Macros.mp4 14.1 MB 1812.Customizing Form Buttons And Other Shape Triggers.mp4 13.1 MB 1813.Assigning Macros To Ribbon Icons.mp4 14 MB 1815.View And Edit Macro Code.mp4 16.8 MB 1816.Add An Are You Sure Box To Macros.mp4 21.5 MB
