File List
-
00 Introduction/0001 Welcome.mov 18.46 MB
12 Charting and Visual Object Tips/1204 Linking and unlinking pictures.mov 12.92 MB
03 Display Shortcuts/0301 Split screens and frozen titles in a flash.mov 12.71 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.04 MB
10 Formatting Shortcuts/1001 Formatting numbers.mov 10.27 MB
03 Display Shortcuts/0302 Repeating title creation and suppression.mov 9.78 MB
11 Database Techniques/1102 Cleaning up spaces.mov 8.97 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
04 Navigation Shortcuts/0403 Navigating within worksheets.mov 7.82 MB
06 Data Entry and Editing Shortcuts/0601 Accelerating data entry.mov 7.48 MB
09 Operational Shortcuts/0903 Handling blank cells.mov 7.46 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.78 MB
08 Formula Shortcuts/0802 Selecting all cells that depend on the active cell.mov 6.64 MB
05 Selection Shortcuts/0503 Selecting the current region and moving around region corne.mov 6.57 MB
04 Navigation Shortcuts/0402 Tips for navigating between workbooks.mov 6.53 MB
11 Database Techniques/1103 Identifying duplicates.mov 6.31 MB
01 Top Ten Shortcuts/0110 Zooming in and out quickly.mov 6.27 MB
12 Charting and Visual Object Tips/1203 Creating and manipulating shapes.mov 6.15 MB
06 Data Entry and Editing Shortcuts/0602 Auto-Fill techniques for entering dates.mov 6.13 MB
09 Operational Shortcuts/0904 Collapsing and expanding detail.mov 5.75 MB
08 Formula Shortcuts/0805 Rounding shortcuts.mov 5.53 MB
05 Selection Shortcuts/0501 Selecting an entire row column or worksheet.mov 5.33 MB
10 Formatting Shortcuts/1002 Aligning data.mov 5.08 MB
11 Database Techniques/1104 Splitting columns.mov 5.02 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
07 Drag-and-Drop Techniques/0703 Dragging and inserting variations.mov 4.72 MB
08 Formula Shortcuts/0801 Rapid formula creation.mov 4.57 MB
08 Formula Shortcuts/0807 Counting unique entries.mov 4.35 MB
11 Database Techniques/1106 Forcing dates to be weekdays only.mov 4.33 MB
10 Formatting Shortcuts/1007 Applying strikethroughs and borders.mov 4.29 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
08 Formula Shortcuts/0806 Generating random numbers.mov 3.88 MB
01 Top Ten Shortcuts/0103 Copying data or formulas down a column instantly.mov 3.77 MB
08 Formula Shortcuts/0808 Performing calculations without formulas.mov 3.75 MB
10 Formatting Shortcuts/1006 Formatting periods over 24 hours.mov 3.71 MB
04 Navigation Shortcuts/0401 Navigation shortcuts.mov 3.68 MB
11 Database Techniques/1101 Sorting shortcuts.mov 3.59 MB
01 Top Ten Shortcuts/0102 Converting formulas to values with a simple drag.mov 3.46 MB
08 Formula Shortcuts/0803 Selecting all cells that can affect the active cell.mov 3.41 MB
06 Data Entry and Editing Shortcuts/0605 Cell editing tips.mov 3.31 MB
07 Drag-and-Drop Techniques/0702 Worksheet Copy Move shortcuts.mov 3.29 MB
01 Top Ten Shortcuts/0104 Adjusting all or selected column widths or row heights in a.mov 3.27 MB
08 Formula Shortcuts/0804 AutoSum shortcuts.mov 3.2 MB
12 Charting and Visual Object Tips/1201 Placing and adjusting charts.mov 3.17 MB
11 Database Techniques/1105 Ensuring unique entries.mov 2.99 MB
06 Data Entry and Editing Shortcuts/0603 Auto-Fill techniques for entering times.mov 2.97 MB
10 Formatting Shortcuts/1004 Formatting data conditionally.mov 2.83 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
09 Operational Shortcuts/0902 Realigning imported text.mov 2.72 MB
03 Display Shortcuts/0303 Customizing your display of Status Bar totals.mov 2.71 MB
01 Top Ten Shortcuts/0101 Entering data or formulas in non-adjacent cells simultaneou.mov 2.69 MB
12 Charting and Visual Object Tips/1202 Creating chart titles from cell content.mov 2.67 MB
11 Database Techniques/1107 Displaying unique items from large lists.mov 1.95 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
Exercise Files/Chapter04.xlsx 597.1 KB
00 Introduction/0002 Using the exercise files.mov 339.74 KB
Exercise Files/Chapter11.xlsx 282.98 KB
Exercise Files/Chapter10.xlsx 227.43 KB
Exercise Files/Chapter01.xlsx 158.09 KB
13 Conclusion/1301 Goodbye.mov 131.85 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
jgtiso.nfo 7.29 KB
Download Info
-
Tips
“MS EXCEL 2010” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.
-
DMCA Notice and Takedown Procedure
If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.