Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now

Excel 2013 Power Shortcuts

with Curt Frye

Video: Welcome

These comprehensive Excel tutorials reveal over 65 Excel tips, tricks, and shortcuts.
Expand all | Collapse all
  1. 2m 1s
    1. Welcome
    2. What you should know before watching this course
    3. Using the exercise files
  2. 32m 35s
    1. Entering numbers with leading zeros
      4m 15s
    2. Entering a data series using the fill handle
      4m 40s
    3. Adding text to a number format
      2m 57s
    4. Printing a sheet on a set number of pages
      2m 51s
    5. Using an Excel table column as a named range
      3m 17s
    6. Numbering rows in a range or table
      2m 44s
    7. Creating hyperlinks to other resources
      3m 37s
    8. Analyzing data using the Quick Analysis Lens
      2m 55s
    9. Super-hiding worksheets
      3m 39s
    10. Creating recommended PivotTables
      1m 40s
  3. 16m 33s
    1. Controlling the user interface using your keyboard
      3m 26s
    2. Customizing the Ribbon
      4m 57s
    3. Customizing the Quick Access Toolbar
      3m 46s
    4. Finding commands not on the Ribbon
      2m 16s
    5. Hiding sheet tabs and scrollbars
      2m 8s
  4. 13m 48s
    1. Moving among worksheets quickly
      1m 57s
    2. Displaying a workbook's full path
      2m 6s
    3. Setting the number of worksheets in a workbook
      1m 59s
    4. Limiting a worksheet's scroll area
      2m 26s
    5. Setting a print area
      2m 32s
    6. Zooming in or out quickly
      2m 48s
  5. 22m 59s
    1. Creating a custom view
      4m 16s
    2. Creating a table using Ctrl+L
      2m 54s
    3. Applying a table style and replacing existing formatting
      2m 48s
    4. Creating a linked picture of a range
      3m 26s
    5. Finding a target value
      3m 24s
    6. Creating substitute data sets using scenarios
      6m 11s
  6. 24m 22s
    1. Entering a line break in a cell
      1m 54s
    2. Wrapping and shrinking cell text
      2m 32s
    3. Entering data into every cell in a range
      2m 39s
    4. Picking data from a list
      1m 40s
    5. Entering data into cells across multiple sheets
      2m 26s
    6. Entering data using an AutoCorrect value
      3m 1s
    7. Creating a data entry form
      3m 25s
    8. Finding a specific color using RGB values
      2m 33s
    9. Basing conditional formats on a formula
      4m 12s
  7. 13m 3s
    1. Extending a date series
      3m 47s
    2. Using a custom list with the fill handle
      3m 37s
    3. Using Flash Fill to manage data
      2m 5s
    4. Removing duplicate values
      3m 34s
  8. 13m 8s
    1. Inserting the current date or time
      2m 44s
    2. Displaying times that exceed twenty-four hours
      2m 49s
    3. Calculating days between dates
      2m 23s
    4. Calculating time to reach an investment goal
      2m 38s
    5. Displaying thousandths of a second
      2m 34s
  9. 21m 39s
    1. Generating a list of unique random numbers
      3m 48s
    2. Using INDEX and MATCH to look up data without using the left-most column
      5m 47s
    3. Summarizing data on the status bar
      2m 29s
    4. Rounding values
      6m 30s
    5. Calculating remainders and whole units
      3m 5s
  10. 17m 37s
    1. Calculating running totals
      1m 55s
    2. Creating and selecting named ranges quickly
      3m 27s
    3. Commenting within a formula
      2m 28s
    4. Displaying a cell formula using FORMULATEXT
      1m 54s
    5. Exiting a cell without saving changes
      1m 28s
    6. Analyzing a formula for errors
      3m 9s
    7. Watching a cell's value
      3m 16s
  11. 18m 17s
    1. Creating a chart by pressing one key (or two)
      1m 34s
    2. Creating recommended charts
      1m 37s
    3. Summarizing data using a sparkline
      3m 44s
    4. Using a PivotTable value in a formula
      3m 44s
    5. Delaying PivotTable updates
      2m 28s
    6. Creating separate sheets from a PivotTable
      3m 5s
    7. Drilling down into PivotTable data
      2m 5s
  12. 56s
    1. Additional resources

please wait ...
Excel 2013 Power Shortcuts
Video duration: 0s 3h 16m Intermediate


Discover over 65 tips, tricks, and shortcuts in Microsoft Excel. In this course, Curt Frye reveals how to invoke commands, manage and organize data, and build formulas in Excel. Curt shares his power shortcuts for saving time on basic tasks, from entering data and selecting cell ranges to summarizing data with charts and tables and quickly finding information.

Topics include:
  • Entering a data series using the fill handle
  • Creating hyperlinks
  • Setting a print area
  • Applying a table style
  • Creating substitute data sets using scenarios
  • Wrapping and shrinking text
  • Creating a data entry form
  • Removing duplicate values
  • Inserting the current date or time
  • Generating a list of unique random numbers
  • Calculating running totals
  • Analyzing a formula for errors
  • Summarizing data with charts and PivotTables
Excel Office Office 365


(music playing) Hi! I am Curt Frye. Welcome to Excel 2013 Power Shortcuts. In this course I will show you how to use Excel 2013 efficiently. You'll learn how to use an Excel table column in a formula, create hyperlinks to other resources, and analyze data using the new Quick Analysis Lens. Next, I'll show you how to control the Excel program and its user interface, such as by customizing the Quick Access Toolbar and finding commands that aren't on the Ribbon.

I'll then move on to managing workbooks and worksheets. I cover skills such as finding a target value, picking data from a list, and using the new Flash Fill feature to manage your data. You'll learn how to generate a list of unique random numbers, analyze formulas for errors, and create a chart by pressing one key. I am sure you'll find that your time with Excel 2013 Power Shortcuts will be time well spent. Dive right in.

There are currently no FAQs about Excel 2013 Power Shortcuts.






Don't show this message again
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.

Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

* Estimated file size

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.

Mark all as unwatched Cancel


You have completed Excel 2013 Power Shortcuts.

Return to your organization's learning portal to continue training, or close this page.


Upgrade to View Courses Offline


With our new Desktop App, Annual Premium Members can download courses for Internet-free viewing.

Upgrade Now

After upgrading, download Desktop App Here.

Become a Member and Create Custom Playlists

Join today and get unlimited access to the entire library of online learning video courses—and create as many playlists as you like.

Get started

Already a member?

Log in

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

You started this assessment previously and didn’t complete it.

You can pick up where you left off, or start over.

Resume Start over

Learn more, save more. Upgrade today!

Get our Annual Premium Membership at our best savings yet.

Upgrade to our Annual Premium Membership today and get even more value from your subscription:

“In a way, I feel like you are rooting for me. Like you are really invested in my experience, and want me to get as much out of these courses as possible this is the best place to start on your journey to learning new material.”— Nadine H.

Thanks for signing up.

We’ll send you a confirmation email shortly.

Sign up and receive emails about and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from

Sign up and receive emails about and our online training library:

Here’s our privacy policy with more details about how we handle your information.

submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.