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