Microsoft Excel - Shortcut Guide

Video description

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.

Table of contents

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

Product information

  • Title: Microsoft Excel - Shortcut Guide
  • Author(s):
  • Release date: September 2013
  • Publisher(s): Infinite Skills
  • ISBN: 9781771371582