Lynda com Excel 2007 Power Shortcuts | 6972A151CC950136C04303085B0F60F5F49DC3A2

Lynda com Excel 2007 Power Shortcuts

Name	Lynda.com - Excel 2007 Power Shortcuts	DOWNLOAD Copy Link
Total Size	166.7 MB
Total Files	49
Hash	6972A151CC950136C04303085B0F60F5F49DC3A2

/00. Introduction/
00 01. Welcome.mov	14.7 MB
00 02. Using the exercise files.mov	876.3 KB
/01. The Top 10/
01 06. Adding custom keyboard shortcuts via macros.mov	5.2 MB
01 03. Changing the Excel 2007 defaults.mov	3.8 MB
01 04. The Format Painter.mov	3.8 MB
01 05. Creating charts with a keyboard shortcut.mov	3.5 MB
01 08. Getting statistics from the Status bar.mov	3.1 MB
01 09. Expanding and collapsing the Formula bar.mov	3.1 MB
01 01. The Repeat command.mov	2.5 MB
01 02. The AutoSum keyboard shortcut.mov	1.9 MB
01 10. Autofitting all columns and rows to data.mov	1.8 MB
01 07. Sharing a spreadsheet using the Send command.mov	1.5 MB
/02. Ribbon and Toolbar Shortcuts/
02 04. Customizing the Quick Access toolbar.mov	4.9 MB
02 05. Using the Quick Access toolbar keyboard shortcuts.mov	4.0 MB
02 02. Revealing and using the Ribbon keytips.mov	3.7 MB
02 03. Accessing the Mini toolbar.mov	2.9 MB
02 01. Hiding the Ribbon.mov	2.7 MB
/03. Sheet Navigation Shortcuts/
03 02. Moving around a worksheet.mov	7.5 MB
03 05. Hiding and revealing rows and columns.mov	5.8 MB
03 03. Zooming in and out with the keyboard.mov	3.6 MB
03 04. The Zoom to Selection command.mov	2.5 MB
03 01. The Go To command.mov	2.5 MB
/04. Cell Selection Shortcuts/
04 05. Selecting the same cell range in multiple sheets.mov	3.8 MB
04 06. Selecting, copying, and pasting content between cells.mov	3.4 MB
04 07. Grouping rows or columns to create collapsible regions.mov	3.4 MB
04 03. Selecting non-adjacent cells.mov	2.7 MB
04 04. Selecting entire rows and columns.mov	2.1 MB
04 01. Selecting a range of cells with the keyboard.mov	1.9 MB
04 02. Selecting the current region of cells.mov	1.4 MB
/05. Data Entry Shortcuts/
05 01. Extending a series or pattern with Autofill.mov	5.3 MB
05 04. Creating a custom data drop-down list.mov	5.0 MB
05 08. Keeping row and column headings in view.mov	4.3 MB
05 03. Data entry shortcuts with AutoCorrect.mov	4.3 MB
05 02. Creating a custom list for Autofill.mov	3.4 MB
05 05. Inserting the current date andor time.mov	2.6 MB
05 06. Entering fractions versus dates.mov	2.1 MB
05 07. Removing duplicate rows of data.mov	1.3 MB
/06. Formatting Shortcuts/
06 06. Shading every other row automatically.mov	6.4 MB
06 03. Custom date formats.mov	4.0 MB
06 04. Custom time formats.mov	3.7 MB
06 10. Changing colors by picking a different theme.mov	3.7 MB
06 01. Quick formatting shortcuts.mov	3.0 MB
06 09. Removing automatic hyperlinks.mov	3.0 MB
06 05. Adding time values and formatting them correctly.mov	2.8 MB
06 07. Parsing names into multiple columns.mov	2.8 MB
06 02. Adding and removing cell borders.mov	2.0 MB
06 08. Changing uppercase text to proper case with the Proper function.mov	1.9 MB
/07. Conclusion/
07 01. Goodbye.mov	426.7 KB
/Exercise Files/
Ex_Files_Excel07_PwrCuts.zip	262.4 KB
Total files 49