|
|
Adding text to a number format-123770.mp4
|
MP4
|
4.26 MB
|
|
|
Additional resources-123841.mp4
|
MP4
|
1.7 MB
|
|
|
Analyzing a formula for errors-123830.mp4
|
MP4
|
5 MB
|
|
|
Analyzing data using the Quick Analysis Lens-123775.mp4
|
MP4
|
4.78 MB
|
|
|
Applying a table style and replacing existing formatting-123793.mp4
|
MP4
|
5.34 MB
|
|
|
Basing conditional formats on a formula-123806.mp4
|
MP4
|
8.01 MB
|
|
|
Calculating days between dates-123815.mp4
|
MP4
|
3.55 MB
|
|
|
Calculating remainders and whole units-123823.mp4
|
MP4
|
4.44 MB
|
|
|
Calculating running totals-123825.mp4
|
MP4
|
2.94 MB
|
|
|
Calculating time to reach an investment goal-123816.mp4
|
MP4
|
3.96 MB
|
|
|
Commenting within a formula-123827.mp4
|
MP4
|
3.77 MB
|
|
|
Controlling the user interface using your keyboard-123779.mp4
|
MP4
|
6.86 MB
|
|
|
Creating a chart by pressing one key (or two)-123833.mp4
|
MP4
|
2.51 MB
|
|
|
Creating a custom view-123791.mp4
|
MP4
|
7.29 MB
|
|
|
Creating a data entry form-123804.mp4
|
MP4
|
6.05 MB
|
|
|
Creating a linked picture of a range-123794.mp4
|
MP4
|
6.26 MB
|
|
|
Creating a table using Ctrl+L-123792.mp4
|
MP4
|
5.46 MB
|
|
|
Creating and selecting named ranges quickly-123826.mp4
|
MP4
|
5.92 MB
|
|
|
Creating hyperlinks to other resources-123774.mp4
|
MP4
|
6.09 MB
|
|
|
Creating recommended PivotTables-123777.mp4
|
MP4
|
3.55 MB
|
|
|
Creating recommended charts-123834.mp4
|
MP4
|
2.95 MB
|
|
|
Creating separate sheets from a PivotTable-123838.mp4
|
MP4
|
6.82 MB
|
|
|
Creating substitute data sets using scenarios-123796.mp4
|
MP4
|
9.86 MB
|
|
|
Customizing the Quick Access Toolbar-123781.mp4
|
MP4
|
6.13 MB
|
|
|
Customizing the Ribbon-123780.mp4
|
MP4
|
8.62 MB
|
|
|
Delaying PivotTable updates-123837.mp4
|
MP4
|
4.37 MB
|
|
|
Displaying a cell formula using FORMULATEXT-123828.mp4
|
MP4
|
3.07 MB
|
|
|
Displaying a workbook's full path-123785.mp4
|
MP4
|
3.42 MB
|
|
|
Displaying thousandths of a second-123817.mp4
|
MP4
|
3.89 MB
|
|
|
Displaying times that exceed twenty-four hours-123814.mp4
|
MP4
|
4.32 MB
|
|
|
Drilling down into PivotTable data-123839.mp4
|
MP4
|
4.76 MB
|
|
|
Entering a data series using the fill handle-123769.mp4
|
MP4
|
6.87 MB
|
|
|
Entering a line break in a cell-123798.mp4
|
MP4
|
3.01 MB
|
|
|
Entering data into cells across multiple sheets-123802.mp4
|
MP4
|
3.79 MB
|
|
|
Entering data into every cell in a range-123800.mp4
|
MP4
|
5.21 MB
|
|
|
Entering data using an AutoCorrect value-123803.mp4
|
MP4
|
5.2 MB
|
|
|
Entering numbers with leading zeros-123768.mp4
|
MP4
|
6.46 MB
|
|
|
Ex_Files_Excel2013_PwrShort
|
|
Exercise Files
|
|
Chapter01
|
|
|
Chapter02
|
|
|
Chapter03
|
|
|
Chapter04
|
|
|
Chapter05
|
|
|
Chapter06
|
|
|
Chapter07
|
|
|
Chapter08
|
|
|
Chapter09
|
|
|
Chapter10
|
|
|
|
|
Ex_Files_Excel2013_PwrShort_Free
|
|
|
Exiting a cell without saving changes-123829.mp4
|
MP4
|
2.32 MB
|
|
|
Extending a date series-123808.mp4
|
MP4
|
5.6 MB
|
|
|
Finding a specific color using RGB values-123805.mp4
|
MP4
|
3.77 MB
|
|
|
Finding a target value-123795.mp4
|
MP4
|
5.18 MB
|
|
|
Finding commands not on the Ribbon-123782.mp4
|
MP4
|
3.61 MB
|
|
|
Generating a list of unique random numbers-123819.mp4
|
MP4
|
6.45 MB
|
|
|
Hiding sheet tabs and scrollbars-123783.mp4
|
MP4
|
4.66 MB
|
|
|
Inserting the current date or time-123813.mp4
|
MP4
|
4.25 MB
|
|
|
Limiting a worksheet's scroll area-123787.mp4
|
MP4
|
4.08 MB
|
|
|
Moving among worksheets quickly-123784.mp4
|
MP4
|
3.81 MB
|
|
|
Numbering rows in a range or table-123773.mp4
|
MP4
|
4.32 MB
|
|
|
Picking data from a list-123801.mp4
|
MP4
|
2.46 MB
|
|
|
Printing a sheet on a set number of pages-123771.mp4
|
MP4
|
5.83 MB
|
|
|
Removing duplicate values-123811.mp4
|
MP4
|
5.28 MB
|
|
|
Rounding values-123822.mp4
|
MP4
|
9.78 MB
|
|
|
Setting a print area-123788.mp4
|
MP4
|
4.74 MB
|
|
|
Setting the number of worksheets in a workbook-123786.mp4
|
MP4
|
3.19 MB
|
|
|
Summarizing data on the status bar-123821.mp4
|
MP4
|
3.87 MB
|
|
|
Summarizing data using a sparkline-123835.mp4
|
MP4
|
7.14 MB
|
|
|
Super-hiding worksheets-123776.mp4
|
MP4
|
5.74 MB
|
|
|
Using Flash Fill to manage data-123810.mp4
|
MP4
|
3.64 MB
|
|
|
Using INDEX and MATCH to look up data without using the left-most column-123820.mp4
|
MP4
|
8.9 MB
|
|
|
Using a PivotTable value in a formula-123836.mp4
|
MP4
|
6.88 MB
|
|
|
Using a custom list with the fill handle-123809.mp4
|
MP4
|
6.99 MB
|
|
|
Using an Excel table column as a named range-123772.mp4
|
MP4
|
4.98 MB
|
|
|
Using the exercise files-123766.mp4
|
MP4
|
878.73 KB
|
|
|
Watching a cell's value-123831.mp4
|
MP4
|
5.16 MB
|
|
|
Welcome-123764.mp4
|
MP4
|
8.48 MB
|
|
|
What you should know before watching this course-123765.mp4
|
MP4
|
609.7 KB
|
|
|
Wrapping and shrinking cell text-123799.mp4
|
MP4
|
3.98 MB
|
|
|
Zooming in or out quickly-123789.mp4
|
MP4
|
6.71 MB
|
2boweb
