|
|
Accelerate Copy, Move, and Paste actions with the right mouse button-182305.mp4
|
MP4
|
12.82 MB
|
|
|
Accelerate copy-and-move tasks-182301.mp4
|
MP4
|
10.98 MB
|
|
|
Accelerate data entry-182295.mp4
|
MP4
|
16.14 MB
|
|
|
Accelerate worksheet copying and moving-182302.mp4
|
MP4
|
11.34 MB
|
|
|
Accentuate date with alignment tools-182323.mp4
|
MP4
|
12.21 MB
|
|
|
Access Ribbon commands with Alt key sequences-182280.mp4
|
MP4
|
8.83 MB
|
|
|
Add a color background to every fifth row in a range-182324.mp4
|
MP4
|
19.74 MB
|
|
|
Add and remove a strikethrough or a border with keystroke shortcuts-182329.mp4
|
MP4
|
13.6 MB
|
|
|
Adjust all or selected column widths or row heights in a flash-182271.mp4
|
MP4
|
8.14 MB
|
|
|
Adjust the Quick Access Toolbar-182281.mp4
|
MP4
|
9.25 MB
|
|
|
Become more proficient with these short tips-182345.mp4
|
MP4
|
17.96 MB
|
|
|
Clean up spaces quickly-182332.mp4
|
MP4
|
17.31 MB
|
|
|
Collapse and expand detail quickly with outlining shortcuts-182319.mp4
|
MP4
|
17.21 MB
|
|
|
Convert formulas to values with a simple drag-182269.mp4
|
MP4
|
8.47 MB
|
|
|
Copy data or formulas down a column instantly-182270.mp4
|
MP4
|
4.63 MB
|
|
|
Count the number of unique entries-182313.mp4
|
MP4
|
13.48 MB
|
|
|
Create and manipulate shapes and use Shift and Ctrl keys-182342.mp4
|
MP4
|
10.87 MB
|
|
|
Create chart titles from cell content-182341.mp4
|
MP4
|
4.22 MB
|
|
|
Create charts instantly with either of these keystroke shortcuts-182273.mp4
|
MP4
|
3.07 MB
|
|
|
Create custom formats - Dot leaders and more-182327.mp4
|
MP4
|
13.89 MB
|
|
|
Create double-spaced or triple-spaced printouts quickly-182320.mp4
|
MP4
|
7.84 MB
|
|
|
Create formulas rapidly-182307.mp4
|
MP4
|
13.41 MB
|
|
|
Create linked dynamic and static images-182343.mp4
|
MP4
|
26.55 MB
|
|
|
Create split screens and frozen titles in a flash-182283.mp4
|
MP4
|
26.66 MB
|
|
|
Customize the display of Status bar totals-182285.mp4
|
MP4
|
9.15 MB
|
|
|
Display Paste Special options instantly-182304.mp4
|
MP4
|
10.85 MB
|
|
|
Display a print preview instantly-182274.mp4
|
MP4
|
4.39 MB
|
|
|
Display unique items from large lists-182338.mp4
|
MP4
|
9.95 MB
|
|
|
Drag and insert with the Shift key-182303.mp4
|
MP4
|
5.71 MB
|
|
|
Enhanced editing tools-182299.mp4
|
MP4
|
8.48 MB
|
|
|
Ensure unique entries with data validation rules-182336.mp4
|
MP4
|
6.41 MB
|
|
|
Enter data or formulas in non-adjacent cells simultaneously-182268.mp4
|
MP4
|
4.69 MB
|
|
|
Enter dates and date series efficiently-182296.mp4
|
MP4
|
15.91 MB
|
|
|
Enter times and time series efficiently-182297.mp4
|
MP4
|
5.82 MB
|
|
|
Ex_Files_Excel_2013_Tips
|
|
|
Expand and collapse the Ribbon and full-screen views-182279.mp4
|
MP4
|
7.89 MB
|
|
|
Force typed dates to be only weekdays with data validation rules-182337.mp4
|
MP4
|
7.26 MB
|
|
|
Generate random numbers-182312.mp4
|
MP4
|
11.63 MB
|
|
|
Identify and eliminate duplicates-182333.mp4
|
MP4
|
11.26 MB
|
|
|
Insert, delete, hide, and unhide columns and rows rapidly-182316.mp4
|
MP4
|
19.91 MB
|
|
|
Instantly display all worksheet formulas-182272.mp4
|
MP4
|
4.84 MB
|
|
|
Instantly enter today's date or time-182275.mp4
|
MP4
|
2.3 MB
|
|
|
Join data from multiple columns into one column with Flash Fill-182335.mp4
|
MP4
|
5.37 MB
|
|
|
Manipulate chart placement with dragging techniques-182340.mp4
|
MP4
|
8.03 MB
|
|
|
Navigate between workbooks efficiently-182287.mp4
|
MP4
|
8.18 MB
|
|
|
Navigate between worksheets efficiently-182288.mp4
|
MP4
|
11.84 MB
|
|
|
Navigate within worksheets-182289.mp4
|
MP4
|
20.67 MB
|
|
|
Next steps-182347.mp4
|
MP4
|
1.31 MB
|
|
|
Perform calculations without formulas-182314.mp4
|
MP4
|
8.82 MB
|
|
|
Realign imported text-182317.mp4
|
MP4
|
8.78 MB
|
|
|
Restore missing labels and hide repeating labels-182284.mp4
|
MP4
|
20.51 MB
|
|
|
Select all cells that can affect the active cell-182309.mp4
|
MP4
|
12.42 MB
|
|
|
Select all cells that depend on the active cell-182308.mp4
|
MP4
|
10.48 MB
|
|
|
Select an entire row, column, or worksheet-182291.mp4
|
MP4
|
19.4 MB
|
|
|
Select and manipulate blank cells-182318.mp4
|
MP4
|
13.93 MB
|
|
|
Select noncontiguous ranges and visible cells only-182292.mp4
|
MP4
|
24.58 MB
|
|
|
Select the current region of cells and move around region corners-182293.mp4
|
MP4
|
22.31 MB
|
|
|
Sort data with single buttons-182331.mp4
|
MP4
|
10.76 MB
|
|
|
Split column data into multiple columns with Flash Fill-182334.mp4
|
MP4
|
12.32 MB
|
|
|
Undo, Redo, and Repeat with keystrokes-182276.mp4
|
MP4
|
10.37 MB
|
|
|
Use AutoSum shortcuts-182310.mp4
|
MP4
|
7.39 MB
|
|
|
Use Conditional Formatting based on comparison criteria-182325.mp4
|
MP4
|
7.6 MB
|
|
|
Use Conditional Formatting to highlight formula cells only-182326.mp4
|
MP4
|
7.87 MB
|
|
|
Use Custom Lists for rapid data entry and list-based sorting-182298.mp4
|
MP4
|
20.98 MB
|
|
|
Use keystroke shortcuts for frequently needed numeric formats-182322.mp4
|
MP4
|
14.82 MB
|
|
|
Use rounding shortcuts-182311.mp4
|
MP4
|
10.31 MB
|
|
|
Use special formats for times over 24 hours-182328.mp4
|
MP4
|
9.04 MB
|
|
|
Using the exercise files-182266.mp4
|
MP4
|
1.29 MB
|
|
|
Welcome-182265.mp4
|
MP4
|
6.22 MB
|
|
|
Zoom in and out quickly-182277.mp4
|
MP4
|
6.64 MB
|
