MMP Software

Lynda Excel 2010 Power Shortcuts

Author: Dennis Taylor
Duration (hr:min): 03:41 
Released on: 08/2010
Exercise files: Yes
Software works on: Windows only

In Excel 2010 Power Shortcuts, Excel expert Dennis Taylor shares tips and shortcuts to vastly increase efficiency and get the full power out of Excel 2010. There are tips for working with the Ribbon and Quick Access toolbar, navigating workbooks and selecting cells, rapid data entry and editing, working with formulas, formatting data, working with charts, sorting data, and much more. Exercise files accompany the course.

Topics include:

• Creating charts with keyboard shortcuts
• Converting formulas to values by dragging
• Repeating Undo and Redo actions
• Displaying formulas instantly
• Navigating quickly through worksheets and across workbooks
• Formatting numeric, and date/time data in a flash with keystroke shortcuts
• Inserting dates or times instantly
• Grouping rows or columns to create collapsible regions
• Building data-entry shortcuts with Auto-fill
• Displaying unique items from large lists

Content:

Introduction - 00:01:37

• Welcome - 00:01:17
• Using the exercise files - 00:00:20

1. Top Ten Shortcuts - 00:22:45

• Entering data or formulas in non-adjacent cells simultaneously - 00:02:28
• Converting formulas to values with a simple drag - 00:02:34
• Copying data or formulas down a column instantly - 00:02:56
• Adjusting all or selected column widths or row heights in a flash - 00:02:21
• Instantly displaying all worksheet formulas - 00:03:16
• Two quick shortcuts for creating charts - 00:01:18
• Print Preview - 00:01:07
• Instant date or time entry - 00:01:16
• Undo/Redo/Repeat - 00:03:19
• Zooming in and out quickly - 00:02:10

2. Ribbon and Quick Access Toolbar Tips - 00:07:37

• Expanding and collapsing the Ribbon and Full Screen view - 00:01:23
• Keyboard command access - 00:02:22
• Quick Access toolbar display tips - 00:03:52

3. Display Shortcuts - 00:14:30

• Split screens and frozen titles in a flash - 00:05:56
• Repeating title creation and suppression - 00:06:17
• Customizing your display of Status Bar totals - 00:02:17

4. Navigation Shortcuts - 00:11:31

• Navigation shortcuts - 00:02:30
• Tips for navigating between workbooks - 00:03:48
• Navigating within worksheets - 00:05:13

5. Selection Shortcuts - 00:11:12

• Selecting an entire row, column, or worksheet - 00:03:20
• Selecting noncontiguous ranges and visible cells only - 00:04:39
• Selecting the current region and moving around region corners - 00:03:13

6. Data Entry and Editing Shortcuts - 00:22:16

• Accelerating data entry - 00:06:27
• Auto-Fill techniques for entering dates - 00:04:59
• Auto-Fill techniques for entering times - 00:02:37
• Custom lists for rapid entry - 00:05:54
• Cell editing tips - 00:02:19

7. Drag-and-Drop Techniques - 00:12:38

• Copy/Move acceleration tips - 00:03:27
• Worksheet Copy/Move shortcuts - 00:02:29
• Dragging and inserting variations - 00:03:47
• Instantly displaying Paste Special options - 00:02:55

8. Formula Shortcuts - 00:29:31

• Rapid formula creation - 00:03:48
• Selecting all cells that depend on the active cell - 00:05:24
• Selecting all cells that can affect the active cell - 00:02:38
• AutoSum shortcuts - 00:02:57
• Rounding shortcuts - 00:05:14
• Generating random numbers - 00:03:16
• Counting unique entries - 00:03:11
• Performing calculations without formulas - 00:03:03

9. Operational Shortcuts - 00:17:04

• Controlling rows and columns - 00:05:50
• Realigning imported text - 00:02:27
• Handling blank cells - 00:04:20
• Collapsing and expanding detail - 00:04:27

10. Formatting Shortcuts - 00:28:08

• Formatting numbers - 00:06:49
• Aligning data - 00:03:49
• Adding background color for readability - 00:03:43
• Formatting data conditionally - 00:01:54
• Creating custom formats - 00:06:23
• Formatting periods over 24 hours - 00:03:02
• Applying strikethroughs and borders - 00:02:28

11. Database Techniques - 00:23:43

• Sorting shortcuts - 00:02:40
• Cleaning up spaces - 00:04:47
• Identifying duplicates - 00:04:07
• Splitting columns - 00:03:57
• Ensuring unique entries - 00:02:46
• Forcing dates to be weekdays only - 00:03:56
• Displaying unique items from large lists - 00:01:30

12. Charting and Visual Object Tips - 00:18:38

• Placing and adjusting charts - 00:02:37
• Creating chart titles from cell content - 00:02:22
• Creating and manipulating shapes - 00:05:31
• Linking and unlinking pictures - 00:08:08

Conclusion - 00:00:09

• Goodbye - 00:00:09