Excel 2013 - Essentials - Tutorials - Videos & Exercise Files (Size: 814.25 MB)
| | | 01_03-QuickAccess.mp4 | 14.52 MB |
| | | 01_02-menu.mp4 | 7.23 MB |
| | | 01_07-navigation.mp4 | 7.05 MB |
| | | 01_04-Worksheet.mp4 | 5.9 MB |
| | | 01_01-ExcelUses.mp4 | 5.42 MB |
| | | 01_08-shortcutMenu.mp4 | 5.36 MB |
| | | 01_09-help.mp4 | 5.2 MB |
| | | 01_10-files.mp4 | 4.38 MB |
| | | 01_06-status.mp4 | 3.55 MB |
| | | 01_05-Formula.mp4 | 3.14 MB |
| | | 02_06-FileSave.mp4 | 6.07 MB |
| | | 02_04-UndoRedo.mp4 | 4.89 MB |
| | | 02_01-dataEntry.mp4 | 4.88 MB |
| | | 02_02-AutoFill.mp4 | 4.56 MB |
| | | 02_03-DatesTimes.mp4 | 4.08 MB |
| | | 02_05-comments.mp4 | 3.92 MB |
| | | 03_07-otherFunctions.mp4 | 9.08 MB |
| | | 03_01-simpleFormulas.mp4 | 8.45 MB |
| | | 03_05-absolute.mp4 | 7.24 MB |
| | | 03_04-PctIncr.mp4 | 6.61 MB |
| | | 03_06-SUMAverage.mp4 | 6.34 MB |
| | | 03_03-YTD.mp4 | 3.8 MB |
| | | 03_02-copyFormulas.mp4 | 3.1 MB |
| | | 04_08-tables.mp4 | 18.6 MB |
| | | 04_05-numeric.mp4 | 13.1 MB |
| | | 04_07-conditional.mp4 | 11.7 MB |
| | | 04_09-insertVisuals.mp4 | 10.51 MB |
| | | 04_01-fonts.mp4 | 10.34 MB |
| | | 04_06-datetime.mp4 | 10.29 MB |
| | | 04_02-columnwidth.mp4 | 8.69 MB |
| | | 04_04-borders.mp4 | 6.3 MB |
| | | 04_03-alignment.mp4 | 4.63 MB |
| | | 05_03-moveCopy.mp4 | 18.77 MB |
| | | 05_01-insertDelete.mp4 | 14.25 MB |
| | | 05_02-hide.mp4 | 7.88 MB |
| | | 05_04-findReplace.mp4 | 5.32 MB |
| | | 06_01-PageLayout.mp4 | 19.94 MB |
| | | 06_02-PageBreak.mp4 | 16.99 MB |
| | | 06_03-PageSetup.mp4 | 13.82 MB |
| | | 07_05-Sparklines.mp4 | 12.7 MB |
| | | 07_03-formatting.mp4 | 9.82 MB |
| | | 07_02-ChartTypes.mp4 | 8.8 MB |
| | | 07_01-CreatingCharts.mp4 | 8.23 MB |
| | | 07_04-ChartElements.mp4 | 6.58 MB |
| | | 08_01-Freezing.mp4 | 18.95 MB |
| | | 08_02-Split.mp4 | 16.16 MB |
| | | 08_03-Outlining.mp4 | 13.87 MB |
| | | 09_05-ManagingLinks.mp4 | 12.2 MB |
| | | 09_03-MoveCopy.mp4 | 8.47 MB |
| | | 09_04-LinkingFormulas.mp4 | 8.34 MB |
| | | 09_02-rename.mp4 | 4.64 MB |
| | | 10_03-vlookupExact.mp4 | 15.05 MB |
| | | 10_02-vlookupApprox.mp4 | 10.23 MB |
| | | 10_04-countif.mp4 | 8.54 MB |
| | | 10_01-IFfunction.mp4 | 7.97 MB |
| | | 11_01-ProtectWorksheet.mp4 | 11.78 MB |
| | | 11_05-TrackingChanges.mp4 | 8.8 MB |
| | | 11_03-WorkbookPassword.mp4 | 7.43 MB |
| | | 11_04-SharingWorkbook.mp4 | 7.24 MB |
| | | 11_02-ProtectWorkbook.mp4 | 5.64 MB |
| | | 12_02-subtotal.mp4 | 50.31 MB |
| | | 12_03-filter.mp4 | 20.56 MB |
| | | 12_01-sorting.mp4 | 17.31 MB |
| | | 12_04-splitting.mp4 | 15.88 MB |
| | | 12_05-duplicates.mp4 | 8.4 MB |
| | | 00_01-welcome.mp4 | 9.59 MB |
| | | 00_02-exfiles.mp4 | 907.15 KB |
| | | 13_01-createPivotTable.mp4 | 22.81 MB |
| | | 13_03-grouping.mp4 | 11.42 MB |
| | | 13_02-manipulating.mp4 | 10.54 MB |
| | | 13_04-groupingOther.mp4 | 9.33 MB |
| | | 13_06-PivotChart.mp4 | 7.4 MB |
| | | 13_05-slicers.mp4 | 5.97 MB |
| | | 14_03-Scenario.mp4 | 14.11 MB |
| | | 14_01-GoalSeek.mp4 | 10.61 MB |
| | | 14_02-Solver.mp4 | 9.12 MB |
| | | 14_04-DataTable.mp4 | 5.28 MB |
| | | 15_03-RunMacro.mp4 | 15.96 MB |
| | | 15_01-MacroDefinition.mp4 | 15.12 MB |
| | | 15_02-CreateMacro.mp4 | 10.75 MB |
| | | 16_01-NextSteps.mp4 | 1.6 MB |
| | | 01-Examples.xlsx | 365.17 KB |
| | | 01-Getting Started.xlsx | 150.14 KB |
| | | 09-04-EmployeeTable.xlsx | 292.44 KB |
| | | 09-EmployeeTable.xlsx | 292.21 KB |
| | | 09-05-EmployeeTable.xlsx | 290.53 KB |
| | | 09-Home Product Line.xlsx | 79.62 KB |
| | | 09-02-RegionalSales.xlsx | 55.92 KB |
| | | 09-05-RegionalSales.xlsx | 43.41 KB |
| | | 09-RegionalSales.xlsx | 41.37 KB |
| | | 09-04-RegionalSales.xlsx | 40 KB |
| | | 09-03-RegionalSales.xlsx | 39.79 KB |
| | | 12-DatabaseFeatures.xlsx | 287.46 KB |
| | | 10-IF VLOOKUP COUNTIF.xlsx | 215.11 KB |
| | | 04-Formatting.xlsx | 198.02 KB |
| | | Twenty Second Sneakers_with logo_91548475.jpg | 61.13 KB |
| | | No_Obstacles_logo_transparent.jpg | 51.69 KB |
| | | Bamboo_Slicker_with logo_YELLOW_101817957.jpg | 49.11 KB |
| | | Thumbs.db | 10 KB |
| | | 08-Worksheet Views.xlsx | 192.14 KB |
| | | 06-Printing.xlsx | 188.5 KB |
| | | 05-layout.xlsx | 183.21 KB |
| | | 11-Security&Sharing.xlsx | 161.94 KB |
| | | TrackingChanges.xlsx | 129.58 KB |
| | | 11-Workbook before Sharing.xlsx | 56.87 KB |
| | | 13-PivotTables.xlsx | 156.74 KB |
| | | 14-DataAnalysis.xlsx | 137.59 KB |
Description
Whether you're a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.
Topics include:
What is Excel and what is it used for?
Using the menus
Working with dates and times
Creating simple formulas
Formatting fonts, row and column sizes, borders, and more
Inserting shapes, arrows, and other graphics
Adding and deleting rows and columns
Hiding data
Moving, copying, and pasting
Sorting and filtering data
Printing your worksheet
Securing your workbooks
Tracking changes
Sharing Widget