Lynda Excel 2013 Power Shortcuts | E8E0473FEB84096B2EA55F38F32192E7BAA79802

Lynda Excel 2013 Power Shortcuts

Name	Lynda - Excel 2013 Power Shortcuts	DOWNLOAD Copy Link
Total Size	357.1 MB
Total Files	133
Hash	E8E0473FEB84096B2EA55F38F32192E7BAA79802

/
Creating substitute data sets using scenarios-123796.mp4	10.3 MB
Rounding values-123822.mp4	10.3 MB
Using INDEX and MATCH to look up data without using the left-most column-123820.mp4	9.3 MB
Customizing the Ribbon-123780.mp4	9.0 MB
Welcome-123764.mp4	8.9 MB
Basing conditional formats on a formula-123806.mp4	8.4 MB
Creating a custom view-123791.mp4	7.6 MB
Summarizing data using a sparkline-123835.mp4	7.5 MB
Using a custom list with the fill handle-123809.mp4	7.3 MB
Using a PivotTable value in a formula-123836.mp4	7.2 MB
Entering a data series using the fill handle-123769.mp4	7.2 MB
Controlling the user interface using your keyboard-123779.mp4	7.2 MB
Creating separate sheets from a PivotTable-123838.mp4	7.1 MB
Zooming in or out quickly-123789.mp4	7.0 MB
Entering numbers with leading zeros-123768.mp4	6.8 MB
Generating a list of unique random numbers-123819.mp4	6.8 MB
Creating a linked picture of a range-123794.mp4	6.6 MB
Customizing the Quick Access Toolbar-123781.mp4	6.4 MB
Creating hyperlinks to other resources-123774.mp4	6.4 MB
Creating a data entry form-123804.mp4	6.3 MB
Creating and selecting named ranges quickly-123826.mp4	6.2 MB
Printing a sheet on a set number of pages-123771.mp4	6.1 MB
Super-hiding worksheets-123776.mp4	6.0 MB
Extending a date series-123808.mp4	5.9 MB
Creating a table using Ctrl+L-123792.mp4	5.7 MB
Applying a table style and replacing existing formatting-123793.mp4	5.6 MB
Removing duplicate values-123811.mp4	5.5 MB
Entering data into every cell in a range-123800.mp4	5.5 MB
Entering data using an AutoCorrect value-123803.mp4	5.4 MB
Finding a target value-123795.mp4	5.4 MB
Watching a cell's value-123831.mp4	5.4 MB
Analyzing a formula for errors-123830.mp4	5.2 MB
Using an Excel table column as a named range-123772.mp4	5.2 MB
Analyzing data using the Quick Analysis Lens-123775.mp4	5.0 MB
Drilling down into PivotTable data-123839.mp4	5.0 MB
Setting a print area-123788.mp4	5.0 MB
Hiding sheet tabs and scrollbars-123783.mp4	4.9 MB
Calculating remainders and whole units-123823.mp4	4.7 MB
Delaying PivotTable updates-123837.mp4	4.6 MB
Displaying times that exceed twenty-four hours-123814.mp4	4.5 MB
Numbering rows in a range or table-123773.mp4	4.5 MB
Adding text to a number format-123770.mp4	4.5 MB
Inserting the current date or time-123813.mp4	4.5 MB
Limiting a worksheet's scroll area-123787.mp4	4.3 MB
Wrapping and shrinking cell text-123799.mp4	4.2 MB
Calculating time to reach an investment goal-123816.mp4	4.1 MB
Displaying thousandths of a second-123817.mp4	4.1 MB
Summarizing data on the status bar-123821.mp4	4.1 MB
Moving among worksheets quickly-123784.mp4	4.0 MB
Entering data into cells across multiple sheets-123802.mp4	4.0 MB
Commenting within a formula-123827.mp4	4.0 MB
Finding a specific color using RGB values-123805.mp4	4.0 MB
Using Flash Fill to manage data-123810.mp4	3.8 MB
Finding commands not on the Ribbon-123782.mp4	3.8 MB
Creating recommended PivotTables-123777.mp4	3.7 MB
Calculating days between dates-123815.mp4	3.7 MB
Displaying a workbook's full path-123785.mp4	3.6 MB
Setting the number of worksheets in a workbook-123786.mp4	3.3 MB
Displaying a cell formula using FORMULATEXT-123828.mp4	3.2 MB
Entering a line break in a cell-123798.mp4	3.2 MB
Creating recommended charts-123834.mp4	3.1 MB
Calculating running totals-123825.mp4	3.1 MB
Creating a chart by pressing one key (or two)-123833.mp4	2.6 MB
Picking data from a list-123801.mp4	2.6 MB
Exiting a cell without saving changes-123829.mp4	2.4 MB
Additional resources-123841.mp4	1.8 MB
Using the exercise files-123766.mp4	899.8 KB
What you should know before watching this course-123765.mp4	624.3 KB
/.../Free Exercise Files/
Excel_2013_Power_Shortcuts.pdf	92.7 KB
/Exercise Files/Chapter03/
SalesByDepartment.xlsx	34.8 KB
PrintArea.xlsx	23.3 KB
Zooming.xlsx	23.2 KB
FullPath.xlsx	9.7 KB
ScrollArea.xlsx	9.5 KB
SetNumber.xlsx	8.9 KB
/Exercise Files/Chapter09/
DisplayFormula.xlsx	28.1 KB
Exiting.xlsx	28.1 KB
Watch.xlsx	11.4 KB
NamedRange.xlsx	10.5 KB
Errors.xlsx	9.1 KB
Comment.xlsx	8.9 KB
RunningTotal.xlsx	8.9 KB
/Exercise Files/Chapter01/
Superhide.xlsx	26.7 KB
PrintingOnSheets.xlsx	11.6 KB
Hyperlink.xlsx	11.0 KB
AddText.xlsx	10.8 KB
NumberRows.xlsx	10.4 KB
RecPT.xlsx	9.7 KB
ColumnAsRange.xlsx	9.3 KB
QuickAnalysis.xlsx	9.3 KB
FillSeries.xlsx	8.2 KB
LeadingZeros.xlsx	8.2 KB
/Exercise Files/Chapter05/
EveryCell.xlsx	23.1 KB
MultipleSheets.xlsx	9.8 KB
FindRGB.xlsx	9.7 KB
Conditional.xlsx	9.7 KB
WrapText.xlsx	9.3 KB
AutoCorrect.xlsx	9.1 KB
DataForm.xlsx	8.6 KB
PickFromList.xlsx	8.6 KB
LineBreak.xlsx	8.5 KB
/Exercise Files/Chapter04/
Scenarios.xlsx	22.5 KB
TableFormat.xlsx	9.6 KB
GoalSeek.xlsx	9.0 KB
CustomView.xlsx	8.7 KB
CreateTable.xlsx	8.6 KB
LinkedPicture.xlsx	8.4 KB
/Exercise Files/Chapter10/
GetPivot.xlsx	16.3 KB
DrillDown.xlsx	16.3 KB
SeparateSheets.xlsx	16.2 KB
DelayUpdate.xlsx	14.2 KB
Sparklines.xlsx	12.1 KB
RecommendedChart.xlsx	10.2 KB
CreateChart.xlsx	9.0 KB
/Exercise Files/Chapter02/
HideTabs.xlsx	9.5 KB
ControlInterface.xlsx	9.0 KB
CustomizeRibbon.xlsx	9.0 KB
CustomizeQAT.xlsx	9.0 KB
NotOnRibbon.xlsx	9.0 KB
/Exercise Files/Chapter08/
SummarizeOnStatusBar.xlsx	9.3 KB
UniquelyRandom.xlsx	9.3 KB
Rounding.xlsx	9.1 KB
CasesAndRemainders.xlsx	9.0 KB
Lookup.xlsx	8.7 KB
/Exercise Files/Chapter07/
MoreThan24.xlsx	9.3 KB
Investment.xlsx	8.6 KB
DateDiff.xlsx	8.3 KB
Thousandths.xlsx	8.3 KB
CurrentDateAndTime.xlsx	8.3 KB
/Exercise Files/Chapter06/
DateSeries.xlsx	9.0 KB
Duplicates.xlsx	8.4 KB
CustomList.xlsx	8.2 KB
FlashFill.xlsx	8.1 KB
Total files 133