Lynda - Excel 2013 Power Shortcuts
Magnet LinkFile List
- Creating substitute data sets using scenarios-123796.mp4 10.09 MB
- Rounding values-123822.mp4 10.01 MB
- Using INDEX and MATCH to look up data without using the left-most column-123820.mp4 9.11 MB
- Customizing the Ribbon-123780.mp4 8.83 MB
- Welcome-123764.mp4 8.68 MB
- Basing conditional formats on a formula-123806.mp4 8.20 MB
- Creating a custom view-123791.mp4 7.47 MB
- Summarizing data using a sparkline-123835.mp4 7.31 MB
- Using a custom list with the fill handle-123809.mp4 7.15 MB
- Using a PivotTable value in a formula-123836.mp4 7.05 MB
- Entering a data series using the fill handle-123769.mp4 7.04 MB
- Controlling the user interface using your keyboard-123779.mp4 7.03 MB
- Creating separate sheets from a PivotTable-123838.mp4 6.98 MB
- Zooming in or out quickly-123789.mp4 6.87 MB
- Entering numbers with leading zeros-123768.mp4 6.61 MB
- Generating a list of unique random numbers-123819.mp4 6.61 MB
- Creating a linked picture of a range-123794.mp4 6.41 MB
- Customizing the Quick Access Toolbar-123781.mp4 6.28 MB
- Creating hyperlinks to other resources-123774.mp4 6.23 MB
- Creating a data entry form-123804.mp4 6.20 MB
- Creating and selecting named ranges quickly-123826.mp4 6.06 MB
- Printing a sheet on a set number of pages-123771.mp4 5.96 MB
- Super-hiding worksheets-123776.mp4 5.88 MB
- Extending a date series-123808.mp4 5.74 MB
- Creating a table using Ctrl+L-123792.mp4 5.59 MB
- Applying a table style and replacing existing formatting-123793.mp4 5.46 MB
- Removing duplicate values-123811.mp4 5.41 MB
- Entering data into every cell in a range-123800.mp4 5.33 MB
- Entering data using an AutoCorrect value-123803.mp4 5.32 MB
- Finding a target value-123795.mp4 5.31 MB
- Watching a cell's value-123831.mp4 5.29 MB
- Analyzing a formula for errors-123830.mp4 5.12 MB
- Using an Excel table column as a named range-123772.mp4 5.09 MB
- Analyzing data using the Quick Analysis Lens-123775.mp4 4.90 MB
- Drilling down into PivotTable data-123839.mp4 4.88 MB
- Setting a print area-123788.mp4 4.85 MB
- Hiding sheet tabs and scrollbars-123783.mp4 4.77 MB
- Calculating remainders and whole units-123823.mp4 4.54 MB
- Delaying PivotTable updates-123837.mp4 4.47 MB
- Displaying times that exceed twenty-four hours-123814.mp4 4.43 MB
- Numbering rows in a range or table-123773.mp4 4.42 MB
- Adding text to a number format-123770.mp4 4.36 MB
- Inserting the current date or time-123813.mp4 4.36 MB
- Limiting a worksheet's scroll area-123787.mp4 4.18 MB
- Wrapping and shrinking cell text-123799.mp4 4.08 MB
- Calculating time to reach an investment goal-123816.mp4 4.05 MB
- Displaying thousandths of a second-123817.mp4 3.99 MB
- Summarizing data on the status bar-123821.mp4 3.97 MB
- Moving among worksheets quickly-123784.mp4 3.90 MB
- Entering data into cells across multiple sheets-123802.mp4 3.88 MB