Start learning with our library of video tutorials taught by experts. Get started

Excel 2013 Tips and Tricks
Illustration by Neil Webb

Excel 2013 Tips and Tricks

with Dennis Taylor

Video: Welcome

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.
Expand all | Collapse all
  1. 1m 1s
    1. Welcome
      43s
    2. Using the exercise files
      18s
  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
      28s

Watch this entire course now —plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
Excel 2013 Tips and Tricks
4h 34m Appropriate for all Jul 16, 2014

Viewers: in countries Watching now:

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
Subjects:
Business Productivity Spreadsheets
Software:
Excel Office
Author:
Dennis Taylor

Welcome

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.

 
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

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

Congratulations

You have completed Excel 2013 Tips and Tricks.

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


OK
Become a member to add this course to a playlist

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

Get started

Already a member ?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

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:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferences from the dropdown menu.

Continue to classic layout Stay on new layout
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.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com 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 lynda.com.

Sign up and receive emails about lynda.com 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.