Lynda.com - Excel 2010 Power Shortcuts
File List
- 00 Introduction/0001 Welcome.mov 18.5 MB
- 12 Charting and Visual Object Tips/1204 Linking and unlinking pictures.mov 12.9 MB
- 03 Display Shortcuts/0301 Split screens and frozen titles in a flash.mov 12.7 MB
- 06 Data Entry and Editing Shortcuts/0604 Custom lists for rapid entry.mov 11.6 MB
- 09 Operational Shortcuts/0901 Controlling rows and columns.mov 11.0 MB
- 10 Formatting Shortcuts/1001 Formatting numbers.mov 10.3 MB
- 03 Display Shortcuts/0302 Repeating title creation and suppression.mov 9.8 MB
- 10 Formatting Shortcuts/1005 Creating custom formats.mov 9.0 MB
- 11 Database Techniques/1102 Cleaning up spaces.mov 9.0 MB
- 10 Formatting Shortcuts/1003 Adding background color for readability.mov 8.3 MB
- 04 Navigation Shortcuts/0403 Navigating within worksheets.mov 7.8 MB
- 06 Data Entry and Editing Shortcuts/0601 Accelerating data entry.mov 7.5 MB
- 09 Operational Shortcuts/0903 Handling blank cells.mov 7.5 MB
- 02 Ribbon and Quick Access Toolbar Tips/0203 Quick Access toolbar display tips.mov 7.2 MB
- 05 Selection Shortcuts/0502 Selecting noncontiguous ranges and visible cells only.mov 6.8 MB
- 08 Formula Shortcuts/0802 Selecting all cells that depend on the active cell.mov 6.6 MB
- 05 Selection Shortcuts/0503 Selecting the current region and moving around region corne.mov 6.6 MB
- 04 Navigation Shortcuts/0402 Tips for navigating between workbooks.mov 6.5 MB
- 11 Database Techniques/1103 Identifying duplicates.mov 6.3 MB
- 01 Top Ten Shortcuts/0110 Zooming in and out quickly.mov 6.3 MB
- 12 Charting and Visual Object Tips/1203 Creating and manipulating shapes.mov 6.2 MB
- 06 Data Entry and Editing Shortcuts/0602 Auto-Fill techniques for entering dates.mov 6.1 MB
- 09 Operational Shortcuts/0904 Collapsing and expanding detail.mov 5.7 MB
- 08 Formula Shortcuts/0805 Rounding shortcuts.mov 5.5 MB
- 05 Selection Shortcuts/0501 Selecting an entire row column or worksheet.mov 5.3 MB
- 10 Formatting Shortcuts/1002 Aligning data.mov 5.1 MB
- 11 Database Techniques/1104 Splitting columns.mov 5.0 MB
- 01 Top Ten Shortcuts/0105 Instantly displaying all worksheet formulas.mov 5.0 MB
- 01 Top Ten Shortcuts/0109 Undo Redo Repeat.mov 4.8 MB
- 07 Drag-and-Drop Techniques/0703 Dragging and inserting variations.mov 4.7 MB
- 08 Formula Shortcuts/0801 Rapid formula creation.mov 4.6 MB
- 08 Formula Shortcuts/0807 Counting unique entries.mov 4.3 MB
- 11 Database Techniques/1106 Forcing dates to be weekdays only.mov 4.3 MB
- 10 Formatting Shortcuts/1007 Applying strikethroughs and borders.mov 4.3 MB
- 07 Drag-and-Drop Techniques/0704 Instantly displaying Paste Special options.mov 4.2 MB
- 07 Drag-and-Drop Techniques/0701 Copy Move acceleration tips.mov 4.2 MB
- 08 Formula Shortcuts/0806 Generating random numbers.mov 3.9 MB
- 01 Top Ten Shortcuts/0103 Copying data or formulas down a column instantly.mov 3.8 MB
- 08 Formula Shortcuts/0808 Performing calculations without formulas.mov 3.7 MB
- 10 Formatting Shortcuts/1006 Formatting periods over 24 hours.mov 3.7 MB
- 04 Navigation Shortcuts/0401 Navigation shortcuts.mov 3.7 MB
- 11 Database Techniques/1101 Sorting shortcuts.mov 3.6 MB
- 01 Top Ten Shortcuts/0102 Converting formulas to values with a simple drag.mov 3.5 MB
- 08 Formula Shortcuts/0803 Selecting all cells that can affect the active cell.mov 3.4 MB
- 06 Data Entry and Editing Shortcuts/0605 Cell editing tips.mov 3.3 MB
- 07 Drag-and-Drop Techniques/0702 Worksheet Copy Move shortcuts.mov 3.3 MB
- 01 Top Ten Shortcuts/0104 Adjusting all or selected column widths or row heights in a.mov 3.3 MB
- 08 Formula Shortcuts/0804 AutoSum shortcuts.mov 3.2 MB
- 12 Charting and Visual Object Tips/1201 Placing and adjusting charts.mov 3.2 MB
- 11 Database Techniques/1105 Ensuring unique entries.mov 3.0 MB
- 06 Data Entry and Editing Shortcuts/0603 Auto-Fill techniques for entering times.mov 3.0 MB
- 10 Formatting Shortcuts/1004 Formatting data conditionally.mov 2.8 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.7 MB
- 09 Operational Shortcuts/0902 Realigning imported text.mov 2.7 MB
- 03 Display Shortcuts/0303 Customizing your display of Status Bar totals.mov 2.7 MB
- 01 Top Ten Shortcuts/0101 Entering data or formulas in non-adjacent cells simultaneou.mov 2.7 MB
- 12 Charting and Visual Object Tips/1202 Creating chart titles from cell content.mov 2.7 MB
- 11 Database Techniques/1107 Displaying unique items from large lists.mov 1.9 MB
- 01 Top Ten Shortcuts/0107 Print Preview.mov 1.7 MB
- 01 Top Ten Shortcuts/0106 Two quick shortcuts for creating charts.mov 1.5 MB
- 01 Top Ten Shortcuts/0108 Instant date or time entry.mov 1.4 MB
- Exercise Files/Chapter04.xlsx 597.1 KB
- 00 Introduction/0002 Using the exercise files.mov 339.7 KB
- Exercise Files/Chapter11.xlsx 283.0 KB
- Exercise Files/Chapter10.xlsx 227.4 KB
- Exercise Files/Chapter01.xlsx 158.1 KB
- 13 Conclusion/1301 Goodbye.mov 131.8 KB
- Exercise Files/Chapter06.xlsx 118.1 KB
- Exercise Files/Chapter07.xlsx 116.8 KB
- Exercise Files/Chapter09.xlsx 115.8 KB
- Exercise Files/Chapter03.xlsx 114.8 KB
- Exercise Files/Chapter12.xlsx 112.8 KB
- Exercise Files/Chapter08.xlsx 106.5 KB
- Exercise Files/Chapter02.xlsx 106.0 KB
- Exercise Files/Chapter05.xlsx 105.3 KB
- Exercise Files/Chapter04A.xlsx 26.7 KB
Download Torrent
Related Resources
Copyright Infringement
If the content above is not authorized, please contact us via activebusinesscommunication[AT]gmail.com. Remember to include the full url in your complaint.