| | 0001 Welcome.mov | 18.46 MB |
| | 0002 Using the exercise files.mov | 339.74 KB |
| | 0110 Zooming in and out quickly.mov | 6.27 MB |
| | 0105 Instantly displaying all worksheet formulas.mov | 4.98 MB |
| | 0109 Undo Redo Repeat.mov | 4.85 MB |
| | 0103 Copying data or formulas down a column instantly.mov | 3.77 MB |
| | 0102 Converting formulas to values with a simple drag.mov | 3.46 MB |
| | 0104 Adjusting all or selected column widths or row heights in a | 3.27 MB |
| | 0101 Entering data or formulas in non-adjacent cells simultaneou | 2.69 MB |
| | 0107 Print Preview.mov | 1.67 MB |
| | 0106 Two quick shortcuts for creating charts.mov | 1.46 MB |
| | 0108 Instant date or time entry.mov | 1.36 MB |
| | 0203 Quick Access toolbar display tips.mov | 7.2 MB |
| | 0201 Expanding and collapsing the Ribbon and Full Screen view.mov | 2.8 MB |
| | 0202 Keyboard command access.mov | 2.72 MB |
| | 0301 Split screens and frozen titles in a flash.mov | 12.71 MB |
| | 0302 Repeating title creation and suppression.mov | 9.78 MB |
| | 0303 Customizing your display of Status Bar totals.mov | 2.71 MB |
| | 0403 Navigating within worksheets.mov | 7.82 MB |
| | 0402 Tips for navigating between workbooks.mov | 6.53 MB |
| | 0401 Navigation shortcuts.mov | 3.68 MB |
| | 0502 Selecting noncontiguous ranges and visible cells only.mov | 6.78 MB |
| | 0503 Selecting the current region and moving around region corne | 6.57 MB |
| | 0501 Selecting an entire row column or worksheet.mov | 5.33 MB |
| | 0604 Custom lists for rapid entry.mov | 11.6 MB |
| | 0601 Accelerating data entry.mov | 7.48 MB |
| | 0602 Auto-Fill techniques for entering dates.mov | 6.13 MB |
| | 0605 Cell editing tips.mov | 3.31 MB |
| | 0603 Auto-Fill techniques for entering times.mov | 2.97 MB |
| | 0703 Dragging and inserting variations.mov | 4.72 MB |
| | 0704 Instantly displaying Paste Special options.mov | 4.25 MB |
| | 0701 Copy Move acceleration tips.mov | 4.2 MB |
| | 0702 Worksheet Copy Move shortcuts.mov | 3.29 MB |
| | 0802 Selecting all cells that depend on the active cell.mov | 6.64 MB |
| | 0805 Rounding shortcuts.mov | 5.53 MB |
| | 0801 Rapid formula creation.mov | 4.57 MB |
| | 0807 Counting unique entries.mov | 4.35 MB |
| | 0806 Generating random numbers.mov | 3.88 MB |
| | 0808 Performing calculations without formulas.mov | 3.75 MB |
| | 0803 Selecting all cells that can affect the active cell.mov | 3.41 MB |
| | 0804 AutoSum shortcuts.mov | 3.2 MB |
| | 0901 Controlling rows and columns.mov | 11.04 MB |
| | 0903 Handling blank cells.mov | 7.46 MB |
| | 0904 Collapsing and expanding detail.mov | 5.75 MB |
| | 0902 Realigning imported text.mov | 2.72 MB |
| | 1001 Formatting numbers.mov | 10.27 MB |
| | 1005 Creating custom formats.mov | 8.97 MB |
| | 1003 Adding background color for readability.mov | 8.27 MB |
| | 1002 Aligning data.mov | 5.08 MB |
| | 1007 Applying strikethroughs and borders.mov | 4.29 MB |
| | 1006 Formatting periods over 24 hours.mov | 3.71 MB |
| | 1004 Formatting data conditionally.mov | 2.83 MB |
| | 1102 Cleaning up spaces.mov | 8.97 MB |
| | 1103 Identifying duplicates.mov | 6.31 MB |
| | 1104 Splitting columns.mov | 5.02 MB |
| | 1106 Forcing dates to be weekdays only.mov | 4.33 MB |
| | 1101 Sorting shortcuts.mov | 3.59 MB |
| | 1105 Ensuring unique entries.mov | 2.99 MB |
| | 1107 Displaying unique items from large lists.mov | 1.95 MB |
| | 1204 Linking and unlinking pictures.mov | 12.92 MB |
| | 1203 Creating and manipulating shapes.mov | 6.15 MB |
| | 1201 Placing and adjusting charts.mov | 3.17 MB |
| | 1202 Creating chart titles from cell content.mov | 2.67 MB |
| | 1301 Goodbye.mov | 131.85 KB |
| | Chapter04.xlsx | 597.1 KB |
| | Chapter11.xlsx | 282.98 KB |
| | Chapter10.xlsx | 227.43 KB |
| | Chapter01.xlsx | 158.09 KB |
| | Chapter06.xlsx | 118.13 KB |
| | Chapter07.xlsx | 116.84 KB |
| | Chapter09.xlsx | 115.82 KB |
| | Chapter03.xlsx | 114.79 KB |
| | Chapter12.xlsx | 112.78 KB |
| | Chapter08.xlsx | 106.54 KB |