Lynda - Excel 2013 Power Shortcuts
- Type:
- Other > Other
- Files:
- 133
- Size:
- 340.57 MiB (357111133 Bytes)
- Tag(s):
- Business
- Uploaded:
- 2016-01-16 11:20:09 GMT
- By:
-
2boweb
- Seeders:
- 0
- Leechers:
- 1
- Comments
- 0
- Info Hash: E8E0473FEB84096B2EA55F38F32192E7BAA79802
(Problems with magnets links are fixed by upgrading your torrent client!)
Lynda - Excel 2013 Power Shortcuts This Course will be good to the Best for DL within 30 days after has been posed, after that it might not be good DL already, please do me favour to continue seeding to keep this torrent alive. 3h 16m Intermediate Feb 28, 2013 | Uploaded in Jan 16, 2016 by 2boweb Subject: Business Software: Excel Office Office 365 Author: Curt Frye Discover over 65 tips, tricks, and shortcuts in Microsoft Excel. In this course, Curt Frye reveals how to invoke commands, manage and organize data, and build formulas in Excel. Curt shares his power shortcuts for saving time on basic tasks, from entering data and selecting cell ranges to summarizing data with charts and tables and quickly finding information. Topics include: • Entering a data series using the fill handle • Creating hyperlinks • Setting a print area • Applying a table style • Creating substitute data sets using scenarios • Wrapping and shrinking text • Creating a data entry form • Removing duplicate values • Inserting the current date or time • Generating a list of unique random numbers • Calculating running totals • Analyzing a formula for errors • Summarizing data with charts and PivotTables ////////////////////////////////////////////////////////////////////
| Creating substitute data sets using scenarios-123796.mp4 | 9.86 MiB |
| Rounding values-123822.mp4 | 9.78 MiB |
| Using INDEX and MATCH to look up data without using the left-most column-123820.mp4 | 8.9 MiB |
| Customizing the Ribbon-123780.mp4 | 8.62 MiB |
| Welcome-123764.mp4 | 8.48 MiB |
| Basing conditional formats on a formula-123806.mp4 | 8.01 MiB |
| Creating a custom view-123791.mp4 | 7.29 MiB |
| Summarizing data using a sparkline-123835.mp4 | 7.14 MiB |
| Using a custom list with the fill handle-123809.mp4 | 6.99 MiB |
| Using a PivotTable value in a formula-123836.mp4 | 6.88 MiB |
| Entering a data series using the fill handle-123769.mp4 | 6.87 MiB |
| Controlling the user interface using your keyboard-123779.mp4 | 6.86 MiB |
| Creating separate sheets from a PivotTable-123838.mp4 | 6.82 MiB |
| Zooming in or out quickly-123789.mp4 | 6.71 MiB |
| Entering numbers with leading zeros-123768.mp4 | 6.46 MiB |
| Generating a list of unique random numbers-123819.mp4 | 6.45 MiB |
| Creating a linked picture of a range-123794.mp4 | 6.26 MiB |
| Customizing the Quick Access Toolbar-123781.mp4 | 6.13 MiB |
| Creating hyperlinks to other resources-123774.mp4 | 6.09 MiB |
| Creating a data entry form-123804.mp4 | 6.05 MiB |
| Creating and selecting named ranges quickly-123826.mp4 | 5.92 MiB |
| Printing a sheet on a set number of pages-123771.mp4 | 5.83 MiB |
| Super-hiding worksheets-123776.mp4 | 5.74 MiB |
| Extending a date series-123808.mp4 | 5.6 MiB |
| Creating a table using Ctrl+L-123792.mp4 | 5.46 MiB |
| Applying a table style and replacing existing formatting-123793.mp4 | 5.34 MiB |
| Removing duplicate values-123811.mp4 | 5.28 MiB |
| Entering data into every cell in a range-123800.mp4 | 5.21 MiB |
| Entering data using an AutoCorrect value-123803.mp4 | 5.2 MiB |
| Finding a target value-123795.mp4 | 5.18 MiB |
| Watching a cell's value-123831.mp4 | 5.16 MiB |
| Analyzing a formula for errors-123830.mp4 | 5 MiB |
| Using an Excel table column as a named range-123772.mp4 | 4.98 MiB |
| Analyzing data using the Quick Analysis Lens-123775.mp4 | 4.78 MiB |
| Drilling down into PivotTable data-123839.mp4 | 4.76 MiB |
| Setting a print area-123788.mp4 | 4.74 MiB |
| Hiding sheet tabs and scrollbars-123783.mp4 | 4.66 MiB |
| Calculating remainders and whole units-123823.mp4 | 4.44 MiB |
| Delaying PivotTable updates-123837.mp4 | 4.37 MiB |
| Displaying times that exceed twenty-four hours-123814.mp4 | 4.32 MiB |
| Numbering rows in a range or table-123773.mp4 | 4.32 MiB |
| Adding text to a number format-123770.mp4 | 4.26 MiB |
| Inserting the current date or time-123813.mp4 | 4.25 MiB |
| Limiting a worksheet's scroll area-123787.mp4 | 4.08 MiB |
| Wrapping and shrinking cell text-123799.mp4 | 3.98 MiB |
| Calculating time to reach an investment goal-123816.mp4 | 3.96 MiB |
| Displaying thousandths of a second-123817.mp4 | 3.89 MiB |
| Summarizing data on the status bar-123821.mp4 | 3.87 MiB |
| Moving among worksheets quickly-123784.mp4 | 3.81 MiB |
| Entering data into cells across multiple sheets-123802.mp4 | 3.79 MiB |
| Commenting within a formula-123827.mp4 | 3.77 MiB |
| Finding a specific color using RGB values-123805.mp4 | 3.77 MiB |
| Using Flash Fill to manage data-123810.mp4 | 3.64 MiB |
| Finding commands not on the Ribbon-123782.mp4 | 3.61 MiB |
| Creating recommended PivotTables-123777.mp4 | 3.55 MiB |
| Calculating days between dates-123815.mp4 | 3.55 MiB |
| Displaying a workbook's full path-123785.mp4 | 3.42 MiB |
| Setting the number of worksheets in a workbook-123786.mp4 | 3.19 MiB |
| Displaying a cell formula using FORMULATEXT-123828.mp4 | 3.07 MiB |
| Entering a line break in a cell-123798.mp4 | 3.01 MiB |
| Creating recommended charts-123834.mp4 | 2.95 MiB |
| Calculating running totals-123825.mp4 | 2.94 MiB |
| Creating a chart by pressing one key (or two)-123833.mp4 | 2.51 MiB |
| Picking data from a list-123801.mp4 | 2.46 MiB |
| Exiting a cell without saving changes-123829.mp4 | 2.32 MiB |
| Additional resources-123841.mp4 | 1.7 MiB |
| Using the exercise files-123766.mp4 | 878.73 KiB |
| What you should know before watching this course-123765.mp4 | 609.7 KiB |
| Ex_Files_Excel2013_PwrShort_Free/Free Exercise Files/Excel_2013_Power_Shortcuts.pdf | 90.55 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter03/SalesByDepartment.xlsx | 33.95 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter09/DisplayFormula.xlsx | 27.47 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter09/Exiting.xlsx | 27.45 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter01/Superhide.xlsx | 26.1 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter03/PrintArea.xlsx | 22.77 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter03/Zooming.xlsx | 22.61 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter05/EveryCell.xlsx | 22.55 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter04/Scenarios.xlsx | 21.94 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter10/GetPivot.xlsx | 15.96 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter10/DrillDown.xlsx | 15.96 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter10/SeparateSheets.xlsx | 15.84 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter10/DelayUpdate.xlsx | 13.83 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter10/Sparklines.xlsx | 11.82 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter01/PrintingOnSheets.xlsx | 11.35 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter09/Watch.xlsx | 11.11 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter01/Hyperlink.xlsx | 10.7 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter01/AddText.xlsx | 10.54 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter09/NamedRange.xlsx | 10.23 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter01/NumberRows.xlsx | 10.17 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter10/RecommendedChart.xlsx | 1 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter05/MultipleSheets.xlsx | 9.59 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter05/FindRGB.xlsx | 9.52 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter05/Conditional.xlsx | 9.46 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter01/RecPT.xlsx | 9.44 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter03/FullPath.xlsx | 9.43 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter04/TableFormat.xlsx | 9.4 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter03/ScrollArea.xlsx | 9.28 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter02/HideTabs.xlsx | 9.26 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter05/WrapText.xlsx | 9.13 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter01/ColumnAsRange.xlsx | 9.09 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter08/SummarizeOnStatusBar.xlsx | 9.08 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter08/UniquelyRandom.xlsx | 9.08 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter07/MoreThan24.xlsx | 9.04 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter01/QuickAnalysis.xlsx | 9.03 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter08/Rounding.xlsx | 8.93 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter09/Errors.xlsx | 8.93 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter05/AutoCorrect.xlsx | 8.86 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter04/GoalSeek.xlsx | 8.83 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter02/ControlInterface.xlsx | 8.83 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter02/CustomizeRibbon.xlsx | 8.83 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter10/CreateChart.xlsx | 8.83 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter02/CustomizeQAT.xlsx | 8.83 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter02/NotOnRibbon.xlsx | 8.83 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter08/CasesAndRemainders.xlsx | 8.81 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter06/DateSeries.xlsx | 8.75 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter09/Comment.xlsx | 8.73 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter09/RunningTotal.xlsx | 8.68 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter03/SetNumber.xlsx | 8.68 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter08/Lookup.xlsx | 8.52 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter04/CustomView.xlsx | 8.52 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter05/DataForm.xlsx | 8.42 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter04/CreateTable.xlsx | 8.4 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter07/Investment.xlsx | 8.4 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter05/PickFromList.xlsx | 8.37 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter05/LineBreak.xlsx | 8.32 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter06/Duplicates.xlsx | 8.25 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter04/LinkedPicture.xlsx | 8.16 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter07/DateDiff.xlsx | 8.13 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter07/Thousandths.xlsx | 8.1 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter07/CurrentDateAndTime.xlsx | 8.08 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter06/CustomList.xlsx | 8.02 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter01/FillSeries.xlsx | 8.02 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter01/LeadingZeros.xlsx | 7.99 KiB |
| Ex_Files_Excel2013_PwrShort/Exercise Files/Chapter06/FlashFill.xlsx | 7.89 KiB |
