Lynda Excel 2013 Power Shortcuts Torrent Download Locations

Lynda - Excel 2013 Power Shortcuts
     Creating substitute data sets using scenarios-123796.mp4 -

     Rounding values-123822.mp4 -

     Using INDEX and MATCH to look up data without using the left-most column-123820.mp4 -

     Customizing the Ribbon-123780.mp4 -

     Welcome-123764.mp4 -

     Basing conditional formats on a formula-123806.mp4 -

     Creating a custom view-123791.mp4 -

     Summarizing data using a sparkline-123835.mp4 -

     Using a custom list with the fill handle-123809.mp4 -

     Using a PivotTable value in a formula-123836.mp4 -

     Entering a data series using the fill handle-123769.mp4 -

     Controlling the user interface using your keyboard-123779.mp4 -

     Creating separate sheets from a PivotTable-123838.mp4 -

     Zooming in or out quickly-123789.mp4 -

     Entering numbers with leading zeros-123768.mp4 -

     Generating a list of unique random numbers-123819.mp4 -

     Creating a linked picture of a range-123794.mp4 -

     Customizing the Quick Access Toolbar-123781.mp4 -

     Creating hyperlinks to other resources-123774.mp4 -

     Creating a data entry form-123804.mp4 -

     Creating and selecting named ranges quickly-123826.mp4 -

     Printing a sheet on a set number of pages-123771.mp4 -

     Super-hiding worksheets-123776.mp4 -

     Extending a date series-123808.mp4 -

     Creating a table using Ctrl+L-123792.mp4 -

     Applying a table style and replacing existing formatting-123793.mp4 -

     Removing duplicate values-123811.mp4 -

     Entering data into every cell in a range-123800.mp4 -

     Entering data using an AutoCorrect value-123803.mp4 -

     Finding a target value-123795.mp4 -

     Watching a cell's value-123831.mp4 -

     Analyzing a formula for errors-123830.mp4 -

     Using an Excel table column as a named range-123772.mp4 -

     Analyzing data using the Quick Analysis Lens-123775.mp4 -

     Drilling down into PivotTable data-123839.mp4 -

     Setting a print area-123788.mp4 -

     Hiding sheet tabs and scrollbars-123783.mp4 -

     Calculating remainders and whole units-123823.mp4 -

     Delaying PivotTable updates-123837.mp4 -

     Displaying times that exceed twenty-four hours-123814.mp4 -

     Numbering rows in a range or table-123773.mp4 -

     Adding text to a number format-123770.mp4 -

     Inserting the current date or time-123813.mp4 -

     Limiting a worksheet's scroll area-123787.mp4 -

     Wrapping and shrinking cell text-123799.mp4 -

     Calculating time to reach an investment goal-123816.mp4 -

     Displaying thousandths of a second-123817.mp4 -

     Summarizing data on the status bar-123821.mp4 -

     Moving among worksheets quickly-123784.mp4 -

     Entering data into cells across multiple sheets-123802.mp4 -

     Commenting within a formula-123827.mp4 -

     Finding a specific color using RGB values-123805.mp4 -

     Using Flash Fill to manage data-123810.mp4 -

     Finding commands not on the Ribbon-123782.mp4 -

     Creating recommended PivotTables-123777.mp4 -

     Calculating days between dates-123815.mp4 -

     Displaying a workbook's full path-123785.mp4 -

     Setting the number of worksheets in a workbook-123786.mp4 -

     Displaying a cell formula using FORMULATEXT-123828.mp4 -

     Entering a line break in a cell-123798.mp4 -

     Creating recommended charts-123834.mp4 -

     Calculating running totals-123825.mp4 -

     Creating a chart by pressing one key (or two)-123833.mp4 -

     Picking data from a list-123801.mp4 -

     Exiting a cell without saving changes-123829.mp4 -

     Additional resources-123841.mp4 -

     Using the exercise files-123766.mp4 -

     What you should know before watching this course-123765.mp4 -

    Ex_Files_Excel2013_PwrShort_Free
          Free Exercise Files/Excel_2013_Power_Shortcuts.pdf -

    Ex_Files_Excel2013_PwrShort
          Exercise Files/Chapter03/SalesByDepartment.xlsx -

          Exercise Files/Chapter09/DisplayFormula.xlsx -

          Exercise Files/Chapter09/Exiting.xlsx -

          Exercise Files/Chapter01/Superhide.xlsx -

          Exercise Files/Chapter03/PrintArea.xlsx -

          Exercise Files/Chapter03/Zooming.xlsx -

          Exercise Files/Chapter05/EveryCell.xlsx -

          Exercise Files/Chapter04/Scenarios.xlsx -

          Exercise Files/Chapter10/GetPivot.xlsx -

          Exercise Files/Chapter10/DrillDown.xlsx -

          Exercise Files/Chapter10/SeparateSheets.xlsx -

          Exercise Files/Chapter10/DelayUpdate.xlsx -

          Exercise Files/Chapter10/Sparklines.xlsx -

          Exercise Files/Chapter01/PrintingOnSheets.xlsx -

          Exercise Files/Chapter09/Watch.xlsx -

          Exercise Files/Chapter01/Hyperlink.xlsx -

          Exercise Files/Chapter01/AddText.xlsx -

          Exercise Files/Chapter09/NamedRange.xlsx -

          Exercise Files/Chapter01/NumberRows.xlsx -

          Exercise Files/Chapter10/RecommendedChart.xlsx -

          Exercise Files/Chapter05/MultipleSheets.xlsx -

          Exercise Files/Chapter05/FindRGB.xlsx -

          Exercise Files/Chapter05/Conditional.xlsx -

          Exercise Files/Chapter01/RecPT.xlsx -

          Exercise Files/Chapter03/FullPath.xlsx -

          Exercise Files/Chapter04/TableFormat.xlsx -

          Exercise Files/Chapter03/ScrollArea.xlsx -

          Exercise Files/Chapter02/HideTabs.xlsx -

          Exercise Files/Chapter05/WrapText.xlsx -

          Exercise Files/Chapter01/ColumnAsRange.xlsx -

          Exercise Files/Chapter08/SummarizeOnStatusBar.xlsx -

          Exercise Files/Chapter08/UniquelyRandom.xlsx -

          Exercise Files/Chapter07/MoreThan24.xlsx -

          Exercise Files/Chapter01/QuickAnalysis.xlsx -

          Exercise Files/Chapter08/Rounding.xlsx -

          Exercise Files/Chapter09/Errors.xlsx -

          Exercise Files/Chapter05/AutoCorrect.xlsx -

          Exercise Files/Chapter04/GoalSeek.xlsx -

          Exercise Files/Chapter02/ControlInterface.xlsx -

          Exercise Files/Chapter02/CustomizeRibbon.xlsx -

          Exercise Files/Chapter10/CreateChart.xlsx -

          Exercise Files/Chapter02/CustomizeQAT.xlsx -

          Exercise Files/Chapter02/NotOnRibbon.xlsx -

          Exercise Files/Chapter08/CasesAndRemainders.xlsx -

          Exercise Files/Chapter06/DateSeries.xlsx -

          Exercise Files/Chapter09/Comment.xlsx -

          Exercise Files/Chapter09/RunningTotal.xlsx -

          Exercise Files/Chapter03/SetNumber.xlsx -

          Exercise Files/Chapter08/Lookup.xlsx -

          Exercise Files/Chapter04/CustomView.xlsx -

          Exercise Files/Chapter05/DataForm.xlsx -

          Exercise Files/Chapter04/CreateTable.xlsx -

          Exercise Files/Chapter07/Investment.xlsx -

          Exercise Files/Chapter05/PickFromList.xlsx -

          Exercise Files/Chapter05/LineBreak.xlsx -

          Exercise Files/Chapter06/Duplicates.xlsx -

          Exercise Files/Chapter04/LinkedPicture.xlsx -

          Exercise Files/Chapter07/DateDiff.xlsx -

          Exercise Files/Chapter07/Thousandths.xlsx -

          Exercise Files/Chapter07/CurrentDateAndTime.xlsx -

          Exercise Files/Chapter06/CustomList.xlsx -

          Exercise Files/Chapter01/FillSeries.xlsx -

          Exercise Files/Chapter01/LeadingZeros.xlsx -

          Exercise Files/Chapter06/FlashFill.xlsx -