Filename Size 01 Getting Started with Excel 2013/01_01-ExcelUses.mp4 5.4 MB 01 Getting Started with Excel 2013/01_02-menu.mp4 7.2 MB 01 Getting Started with Excel 2013/01_03-QuickAccess.mp4 14.5 MB 01 Getting Started with Excel 2013/01_04-Worksheet.mp4 5.9 MB 01 Getting Started with Excel 2013/01_05-Formula.mp4 3.1 MB 01 Getting Started with Excel 2013/01_06-status.mp4 3.5 MB 01 Getting Started with Excel 2013/01_07-navigation.mp4 7.1 MB 01 Getting Started with Excel 2013/01_08-shortcutMenu.mp4 5.4 MB 01 Getting Started with Excel 2013/01_09-help.mp4 5.2 MB 01 Getting Started with Excel 2013/01_10-files.mp4 4.4 MB 02 Entering Data/02_01-dataEntry.mp4 4.9 MB 02 Entering Data/02_02-AutoFill.mp4 4.6 MB 02 Entering Data/02_03-DatesTimes.mp4 4.1 MB 02 Entering Data/02_04-UndoRedo.mp4 4.9 MB 02 Entering Data/02_05-comments.mp4 3.9 MB 02 Entering Data/02_06-FileSave.mp4 6.1 MB 03 Creating Formulas and Functions/03_01-simpleFormulas.mp4 8.5 MB 03 Creating Formulas and Functions/03_02-copyFormulas.mp4 3.1 MB 03 Creating Formulas and Functions/03_03-YTD.mp4 3.8 MB 03 Creating Formulas and Functions/03_04-PctIncr.mp4 6.6 MB 03 Creating Formulas and Functions/03_05-absolute.mp4 7.2 MB 03 Creating Formulas and Functions/03_06-SUMAverage.mp4 6.3 MB 03 Creating Formulas and Functions/03_07-otherFunctions.mp4 9.1 MB 04 Formatting/04_01-fonts.mp4 10.3 MB 04 Formatting/04_02-columnwidth.mp4 8.7 MB 04 Formatting/04_03-alignment.mp4 4.6 MB 04 Formatting/04_04-borders.mp4 6.3 MB 04 Formatting/04_05-numeric.mp4 13.1 MB 04 Formatting/04_06-datetime.mp4 10.3 MB 04 Formatting/04_07-conditional.mp4 11.7 MB 04 Formatting/04_08-tables.mp4 18.6 MB 04 Formatting/04_09-insertVisuals.mp4 10.5 MB 05 Adjusting Worksheet Layout and Data/05_01-insertDelete.mp4 14.2 MB 05 Adjusting Worksheet Layout and Data/05_02-hide.mp4 7.9 MB 05 Adjusting Worksheet Layout and Data/05_03-moveCopy.mp4 18.8 MB 05 Adjusting Worksheet Layout and Data/05_04-findReplace.mp4 5.3 MB 06 Printing/06_01-PageLayout.mp4 19.9 MB 06 Printing/06_02-PageBreak.mp4 17 MB 06 Printing/06_03-PageSetup.mp4 13.8 MB 07 Introduction to Charting/07_01-CreatingCharts.mp4 8.2 MB 07 Introduction to Charting/07_02-ChartTypes.mp4 8.8 MB 07 Introduction to Charting/07_03-formatting.mp4 9.8 MB 07 Introduction to Charting/07_04-ChartElements.mp4 6.6 MB 07 Introduction to Charting/07_05-Sparklines.mp4 12.7 MB 08 Adjusting Worksheet Views/08_01-Freezing.mp4 19 MB 08 Adjusting Worksheet Views/08_02-Split.mp4 16.2 MB 08 Adjusting Worksheet Views/08_03-Outlining.mp4 13.9 MB 09 Multiple Worksheets and Workbooks/09_02-rename.mp4 4.6 MB 09 Multiple Worksheets and Workbooks/09_03-MoveCopy.mp4 8.5 MB 09 Multiple Worksheets and Workbooks/09_04-LinkingFormulas.mp4 8.3 MB 09 Multiple Worksheets and Workbooks/09_05-ManagingLinks.mp4 12.2 MB 10 IF, VLOOKUP, and Power Functions/10_01-IFfunction.mp4 8 MB 10 IF, VLOOKUP, and Power Functions/10_02-vlookupApprox.mp4 10.2 MB 10 IF, VLOOKUP, and Power Functions/10_03-vlookupExact.mp4 15.1 MB 10 IF, VLOOKUP, and Power Functions/10_04-countif.mp4 8.5 MB 11 Security and Sharing/11_01-ProtectWorksheet.mp4 11.8 MB 11 Security and Sharing/11_02-ProtectWorkbook.mp4 5.6 MB 11 Security and Sharing/11_03-WorkbookPassword.mp4 7.4 MB 11 Security and Sharing/11_04-SharingWorkbook.mp4 7.2 MB 11 Security and Sharing/11_05-TrackingChanges.mp4 8.8 MB 12 The Database Features of Excel/12_01-sorting.mp4 17.3 MB 12 The Database Features of Excel/12_02-subtotal.mp4 50.3 MB 12 The Database Features of Excel/12_03-filter.mp4 20.6 MB 12 The Database Features of Excel/12_04-splitting.mp4 15.9 MB 12 The Database Features of Excel/12_05-duplicates.mp4 8.4 MB 13 PivotTables/00 Introduction/00_01-Welcome.mp4 9.6 MB 13 PivotTables/00 Introduction/00_02-ExFiles.mp4 907.1 KB 13 PivotTables/13_01-createPivotTable.mp4 22.8 MB 13 PivotTables/13_02-manipulating.mp4 10.5 MB 13 PivotTables/13_03-grouping.mp4 11.4 MB 13 PivotTables/13_04-groupingOther.mp4 9.3 MB 13 PivotTables/13_05-slicers.mp4 6 MB 13 PivotTables/13_06-PivotChart.mp4 7.4 MB 14 Data Analysis Tools/14_01-GoalSeek.mp4 10.6 MB 14 Data Analysis Tools/14_02-Solver.mp4 9.1 MB 14 Data Analysis Tools/14_03-Scenario.mp4 14.1 MB 14 Data Analysis Tools/14_04-DataTable.mp4 5.3 MB 15 Introduction to Macros/15_01-MacroDefinition.mp4 15.1 MB 15 Introduction to Macros/15_02-CreateMacro.mp4 10.8 MB 15 Introduction to Macros/15_03-RunMacro.mp4 16 MB 16 Conclusion/16_01-NextSteps.mp4 1.6 MB Exercise Files/Ch01/01-Examples.xlsx 365.2 KB Exercise Files/Ch01/01-Getting Started.xlsx 150.1 KB Exercise Files/Ch04/04-Formatting.xlsx 198 KB Exercise Files/Ch05/05-Layout.xlsx 183.2 KB Exercise Files/Ch06/06-Printing.xlsx 188.5 KB Exercise Files/Ch07/07-Charting.xlsx 64.4 KB Exercise Files/Ch08/08-Worksheet Views.xlsx 192.1 KB Exercise Files/Ch09/09-04-EmployeeTable.xlsx 292.4 KB Exercise Files/Ch09/09-05-EmployeeTable.xlsx 290.5 KB Exercise Files/Ch09/09-EmployeeTable.xlsx 292.2 KB Exercise Files/Ch09/09-Home Product Line.xlsx 79.6 KB Exercise Files/Ch10/10-IF VLOOKUP COUNTIF.xlsx 215.1 KB Exercise Files/Ch11/11-Security&Sharing.xlsx 161.9 KB Exercise Files/Ch11/TrackingChanges.xlsx 129.6 KB Exercise Files/Ch12/12-DatabaseFeatures.xlsx 287.5 KB Exercise Files/Ch13/13-PivotTables.xlsx 156.7 KB Exercise Files/Ch14/14-DataAnalysis.xlsx 137.6 KB Exercise Files/Ch15/15-Macros.xlsx 136 KB