by | Released September 2013 | ISBN: 9781771371582

In this Microsoft Excel – Shortcut Guide training course, expert author Guy Vaccaro takes you beyond the basics of Excel, showing you numerous useful shortcuts within this spreadsheet program. This course is designed for users that already have a basic working knowledge of Excel. You will start by learning simple shortcuts, such as adding hyperlinks to Excel objects and using the fill handle for quick data patterns. You will then jump into learning Excel interface shortcuts, how to move swiftly between workbooks and worksheets, and creating and using custom views. Guy proceeds to teach you how to work with dates and times, as well as working with data and formula. Finally, this video tutorial will show you shortcuts for creating charts and pivot tables, including referencing a pivot table value in a formula and separating worksheets from a single pivot table. By the completion of this video based training course, you will be comfortable with using many of these shortcuts in Microsoft Excel. Working files are included, allowing you to follow along with the author throughout the lessons. Show and hide more Publisher resources Download Example Code

1. Welcome
   • Introduction 00:03:25
   • Using The Working Files 00:02:10
   • About The Author 00:01:18
2. The Simple Ones Are The Best Ones
   • How To Enter Numbers And Retain The Leading Zero 00:04:18
   • Using The Fill Handle For Quick Data Patterns 00:06:30
   • Controlling Pages On Printing 00:05:54
   • Adding Hyperlinks To Excel Objects 00:04:34
   • Recommended Pivot Tables 00:04:42
   • Recommended And Quick Creation Charts 00:04:24
   • Ctrl Keyboard Shortcuts 00:09:47
3. Excel Interface Shortcuts
   • Accessing Ribbon Commands With The Keyboard 00:05:00
   • Customize The Ribbons And Quick Access Toolbar 00:07:13
   • Activating And Deactivating Interface Options 00:05:25
4. Workbooks And Worksheets
   • Moving Swiftly Between Workbooks And Worksheets 00:04:33
   • Displaying File Path, File Name And Sheet Name 00:05:19
   • Controlling The Quantity Of Worksheets 00:03:31
5. Data Organization
   • Creating A Table 00:03:17
   • Table Styles Of Your Own 00:04:46
   • Creating And Using Custom Views 00:05:22
   • Testing What Ifs With Goal Seek 00:05:18
   • Use Scenarios To Experiment With Different Values 00:05:55
6. Entering Data And Formatting
   • Managing Cells With Large Text Content 00:05:21
   • Creating And Managing A Pick List 00:04:46
   • Multiple Sheet Data Entry And Sheet Management 00:05:04
7. Working With Dates And Times
   • Inserting The Date And Time As Static Or Dynamic 00:04:13
   • Time Difference And Duration: Particularly Over 24 Hours 00:06:46
   • Calculate Time Required To Reach Investment Goal 00:04:09
8. Working With Data And Formulas
   • Create Your Own Fill Handle Lists 00:06:56
   • Flash Fill In Action - Completing Data Columns 00:04:50
   • Removing Duplicate Values 00:03:35
   • Work Out Mortgage Repayments 00:05:56
   • Adding Comments To Formulas 00:03:40
   • Displaying The Formula In Use: Formula Text 00:03:59
   • Use Watch To Keep An Eye On A Cell Value 00:04:47
   • Adding Formulas To Text Boxes 00:04:26
9. Charts And Pivot Tables
   • Create A Chart With A Single Key 00:04:49
   • Summarizing Data Using A Sparkline 00:06:32
   • Reference A Pivot Table Value In A Formula 00:04:49
   • Separate Worksheets From A Single Pivot Table 00:03:59
   • Drilling Down Into Pivot Table Data 00:04:27
10. Conclusion
    • Shortcut Summary 00:03:08
Show and hide more