[RS] Lynda.com - Excel 2007 Power Shortcuts

[Nguyen Trung Hoa]

Lynda.com - Excel 2007 Power Shortcuts

Code:

Introduction
   Welcome   01:10   14.1 MB
   Using the exercise files   00:53   0.8 MB
1. The Top 10
   The Repeat command   02:07   2.4 MB
   The AutoSum keyboard shortcut   01:41   1.8 MB
   Changing the Excel 2007 defaults   03:13   3.6 MB
   The Format Painter   02:55   3.6 MB
   Creating charts with a keyboard shortcut   02:39   3.3 MB
   Adding custom keyboard shortcuts via macros   04:28   4.9 MB
   Sharing a spreadsheet using the Send command   01:14   1.4 MB
   Getting statistics from the Status bar   02:46   3.0 MB
   Expanding and collapsing the Formula bar   02:26   3.0 MB
   Autofitting all columns and rows to data   01:28   1.7 MB
2. Ribbon and Toolbar Shortcuts
   Hiding the Ribbon   02:15   2.5 MB
   Revealing and using the Ribbon keytips   03:15   3.5 MB
   Accessing the Mini toolbar   02:37   2.8 MB
   Customizing the Quick Access toolbar   04:04   4.7 MB
   Using the Quick Access toolbar keyboard shortcuts   03:22   3.8 MB
3. Sheet Navigation Shortcuts
   The Go To command   01:52   2.4 MB
   Moving around a worksheet   05:03   7.2 MB
   Zooming in and out with the keyboard   02:00   3.4 MB
   The Zoom to Selection command   01:43   2.4 MB
   Hiding and revealing rows and columns   03:51   5.5 MB
4. Cell Selection Shortcuts
   Selecting a range of cells with the keyboard   01:34   1.9 MB
   Selecting the current region of cells   01:01   1.3 MB
   Selecting non-adjacent cells   02:17   2.6 MB
   Selecting entire rows and columns   01:42   2.0 MB
   Selecting the same cell range in multiple sheets   03:02   3.6 MB
   Selecting, copying, and pasting content between cells   02:49   3.2 MB
   Grouping rows or columns to create collapsible regions   02:41   3.2 MB
5. Data Entry Shortcuts
   Extending a series or pattern with Autofill   04:35   5.0 MB
   Creating a custom list for Autofill   03:00   3.3 MB
   Data entry shortcuts with AutoCorrect   03:57   4.1 MB
   Creating a custom data drop-down list   04:30   4.7 MB
   Inserting the current date and/or time   02:14   2.5 MB
   Entering fractions versus dates   02:05   2.0 MB
   Removing duplicate rows of data   01:10   1.3 MB
   Keeping row and column headings in view   02:17   4.1 MB
6. Formatting Shortcuts
   Quick formatting shortcuts   02:54   2.8 MB
   Adding and removing cell borders   01:58   1.9 MB
   Custom date formats   03:41   3.9 MB
   Custom time formats   03:27   3.5 MB
   Adding time values and formatting them correctly   02:20   2.7 MB
   Shading every other row automatically   03:55   6.1 MB
   Parsing names into multiple columns   02:15   2.6 MB
   Changing uppercase text to proper case with the Proper function   01:38   1.8 MB
   Removing automatic hyperlinks   03:01   2.8 MB
   Changing colors by picking a different theme   02:53   3.5 MB
Conclusion
   Goodbye

Download :

Code:

http://rapidshare.com/files/325816971/Lynda.com_-_Excel_2007_Power_Shortcuts.rar

Password :

Code:

www.free-offline.com