Excel 2013: Shortcuts

Introduction

• Welcome
• What you should know before watching this course
• Using the exercise files

1. Top Ten Shortcuts

• Entering numbers with leading zeros
• Entering a data series using the fill handle
• Adding text to a number format
• Printing a sheet on a set number of pages
• Using an Excel table column as a named range
• Numbering rows in a range or table
• Creating hyperlinks to other resources
• Analyzing data using the Quick Analysis Lens
• Super-hiding worksheets
• Creating recommended PivotTables

2. Controlling the Excel Program and Interface

• Controlling the user interface using your keyboard
• Customizing the Ribbon
• Customizing the Quick Access Toolbar
• Finding commands not on the Ribbon
• Hiding sheet tabs and scrollbars

3. Managing Workbooks and Worksheets

• Moving among worksheets quickly
• Displaying a workbook's full path
• Setting the number of worksheets in a workbook
• Limiting a worksheet's scroll area
• Setting a print area
• Zooming in or out quickly

4. Organizing Data

• Creating a custom view
• Creating a table using Ctrl+L
• Applying a table style and replacing existing formatting
• Creating a linked picture of a range
• Finding a target value
• Creating substitute data sets using scenarios

5. Entering and Formatting Data

• Entering a line break in a cell
• Wrapping and shrinking cell text
• Entering data into every cell in a range
• Picking data from a list
• Entering data into cells across multiple sheets
• Entering data using an AutoCorrect value
• Creating a data entry form
• Finding a specific color using RGB values
• Basing conditional formats on a formula

6. Managing a Data Series

• Extending a date series
• Using a custom list with the fill handle
• Using Flash Fill to manage data
• Removing duplicate values

7. Working with Dates and Times

• Inserting the current date or time
• Displaying times that exceed twenty-four hours
• Calculating days between dates
• Calculating time to reach an investment goal
• Displaying thousandths of a second

8. Creating Useful Formulas

• Generating a list of unique random numbers
• Using INDEX and MATCH to look up data without using the left-most column
• Summarizing data on the status bar
• Rounding values
• Calculating remainders and whole units

9. Managing Formulas

• Calculating running totals
• Creating and selecting named ranges quickly
• Commenting within a formula
• Displaying a cell formula using FORMULATEXT
• Exiting a cell without saving changes
• Analyzing a formula for errors
• Watching a cell's value

10. Summarizing Data Using Charts and PivotTables

• Creating a chart by pressing one key (or two)
• Creating recommended charts
• Summarizing data using a sparkline
• Using a PivotTable value in a formula
• Delaying PivotTable updates
• Creating separate sheets from a PivotTable
• Drilling down into PivotTable data

Conclusion

• Additional resources