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

Excel 2013 Tips and Tricks

with Dennis Taylor

Video: Welcome

Discover the best tips and tricks in Excel 2013, and unleash the real power of this popular, powerful software.
Expand all | Collapse all
  1. 1m 1s
    1. Welcome
    2. Using the exercise files
  2. 21m 38s
    1. Enter data or formulas in non-adjacent cells simultaneously
      2m 24s
    2. Convert formulas to values with a simple drag
      3m 35s
    3. Copy data or formulas down a column instantly
      2m 1s
    4. Adjust all or selected column widths or row heights in a flash
      2m 20s
    5. Instantly display all worksheet formulas
      2m 16s
    6. Create charts instantly with either of these keystroke shortcuts
      1m 26s
    7. Display a print preview instantly
      1m 17s
    8. Instantly enter today's date or time
      1m 26s
    9. Undo, Redo, and Repeat with keystrokes
      3m 26s
    10. Zoom in and out quickly
      1m 27s
  3. 9m 11s
    1. Expand and collapse the Ribbon and full-screen views
      2m 21s
    2. Access Ribbon commands with Alt key sequences
      3m 33s
    3. Adjust the Quick Access Toolbar
      3m 17s
  4. 17m 16s
    1. Create split screens and frozen titles in a flash
      6m 19s
    2. Restore missing labels and hide repeating labels
      7m 24s
    3. Customize the display of Status bar totals
      3m 33s
  5. 12m 56s
    1. Navigate between workbooks efficiently
      2m 47s
    2. Navigate between worksheets efficiently
      4m 45s
    3. Navigate within worksheets
      5m 24s
  6. 15m 0s
    1. Select an entire row, column, or worksheet
      4m 43s
    2. Select noncontiguous ranges and visible cells only
      5m 25s
    3. Select the current region of cells and move around region corners
      4m 52s
  7. 28m 24s
    1. Accelerate data entry
      8m 37s
    2. Enter dates and date series efficiently
      6m 44s
    3. Enter times and time series efficiently
      3m 9s
    4. Use Custom Lists for rapid data entry and list-based sorting
      6m 52s
    5. Enhanced editing tools
      3m 2s
  8. 18m 35s
    1. Accelerate copy-and-move tasks
      4m 48s
    2. Accelerate worksheet copying and moving
      3m 16s
    3. Drag and insert with the Shift key
      2m 16s
    4. Display Paste Special options instantly
      3m 35s
    5. Accelerate Copy, Move, and Paste actions with the right mouse button
      4m 40s
  9. 34m 48s
    1. Create formulas rapidly
      5m 34s
    2. Select all cells that depend on the active cell
      3m 34s
    3. Select all cells that can affect the active cell
      3m 46s
    4. Use AutoSum shortcuts
      3m 55s
    5. Use rounding shortcuts
      5m 46s
    6. Generate random numbers
      4m 27s
    7. Count the number of unique entries
      4m 10s
    8. Perform calculations without formulas
      3m 36s
  10. 23m 11s
    1. Insert, delete, hide, and unhide columns and rows rapidly
      5m 21s
    2. Realign imported text
      3m 41s
    3. Select and manipulate blank cells
      5m 28s
    4. Collapse and expand detail quickly with outlining shortcuts
      5m 58s
    5. Create double-spaced or triple-spaced printouts quickly
      2m 43s
  11. 35m 27s
    1. Use keystroke shortcuts for frequently needed numeric formats
      5m 24s
    2. Accentuate date with alignment tools
      4m 29s
    3. Add a color background to every fifth row in a range
      5m 7s
    4. Use Conditional Formatting based on comparison criteria
      3m 4s
    5. Use Conditional Formatting to highlight formula cells only
      3m 13s
    6. Create custom formats: Dot leaders and more
      5m 12s
    7. Use special formats for times over 24 hours
      3m 42s
    8. Add and remove a strikethrough or a border with keystroke shortcuts
      5m 16s
  12. 30m 43s
    1. Sort data with single buttons
      3m 40s
    2. Clean up spaces quickly
      5m 16s
    3. Identify and eliminate duplicates
      3m 17s
    4. Split column data into multiple columns with Flash Fill
      5m 22s
    5. Join data from multiple columns into one column with Flash Fill
      2m 43s
    6. Ensure unique entries with data validation rules
      3m 54s
    7. Force typed dates to be only weekdays with data validation rules
      3m 43s
    8. Display unique items from large lists
      2m 48s
  13. 18m 32s
    1. Manipulate chart placement with dragging techniques
      3m 29s
    2. Create chart titles from cell content
      1m 53s
    3. Create and manipulate shapes and use Shift and Ctrl keys
      5m 8s
    4. Create linked dynamic and static images
      8m 2s
  14. 7m 8s
    1. Become more proficient with these short tips
      7m 8s
  15. 28s
    1. Next steps

please wait ...
Excel 2013 Tips and Tricks
Video duration: 0s 4h 34m Appropriate for all


Increase your Excel productivity with the power user tips and tricks packed into this fast-paced course. Dennis Taylor will show you how to create formulas quickly, split data into columns, apply formatting, build charts, and fast-track routine data-entry chores. Short on time? Make sure to check out the "Top Ten Shortcuts" and "Ten Tiny Tips" chapters for a quick productivity boost. Start now and get an immediate return on your investment, with powerful techniques that will save you hours every week.

Topics include:
  • Converting formulas to values with a simple drag
  • Entering today's date or time instantly
  • Accessing Ribbon commands from the keyboard
  • Creating split screens fast
  • Navigating quickly
  • Entering data more efficiently
  • Performing calculations without formulas
  • Applying formatting with keyboard shortcuts
  • Using database techniques to work with Excel data
Excel Office


Hi, I'm Dennis Taylor and welcome to Excel 2013 Tips and Tricks. In this course, I'll show you how to use this popular software more efficiently. Most Excel users are underutilizing it because they're not aware of the many keystroke shortcuts and techniques that they could be using. Whether you need to create formulas quickly, split data into columns, apply numeric formats, create charts in a flash, accelerate data entry chores, or just learn the top 10 shortcuts that every Excel user should know, you can save time by learning some of the tips in this course.

We've got a lot to cover, so let's get started with Excel 2013 Tips and Tricks.

There are currently no FAQs about Excel 2013 Tips and Tricks.






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.

Join now Already a member? Log in

* 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 Tips and Tricks.

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.