Search course
image
Cancel
Office Productivity >
Microsoft Office >
Career Development
Video play icon

Microsoft Excel Keyboard Shortcuts: What You Need to Know

Discover valuable MS Excel keyboard shortcuts and techniques to enhance productivity. Learn to streamline your workflow for efficient time management.

210 views
Last updated 5/2024
English

Overview

Are you tired of spending countless hours working harder than necessary in Microsoft Excel, wasting precious time on repetitive tasks that could be done more efficiently?

If so, then this online course is perfect for you.

Designed to provide valuable Excel shortcuts, this course is suitable for all versions of MS Excel.

By enrolling in this course, you will gain access to a comprehensive range of Excel keyboard shortcuts that will significantly enhance your productivity. Additionally, the course also offers guidance on creating custom keyboard shortcuts, allowing you to tailor Excel to your specific needs. Don't miss out on this opportunity to streamline your Excel workflow and save valuable time.

Course Content

  • Unveiling hidden functionality by knowing when and where to double-click or right-click with your mouse
  • Restoring the classic print preview screen in Excel 2010 and later
  • Exploring an alternative to the merged cells feature
  • Having Excel read numbers aloud to you
  • Efficiently locking and unlocking worksheet cells, along with superior alternatives
  • Materials covering Excel 2016, 2013, 2010, and 2007
  • Adding the hidden Form Command back to Excel 2007 and later
  • Easily converting Excel 2003 files to modern workbook formats
  • Creating a keyboard shortcut for Excel's Freeze Panes feature
  • Saving workbooks as .XLS files using the Compatibility Checker
  • Filtering based on cell contents with a single keystroke or mouse click to bypass filter drop-down lists
  • Converting .XLS workbooks to .XLSX format with just two keystrokes
  • Quickly accessing folders and workbooks, regardless of their storage location
  • Automatic techniques for providing fallback positions to view earlier versions of your Excel spreadsheet
  • Double-checking manual inputs by having Excel read numbers aloud to you
  • Eliminating duplicates from a list with just a few mouse clicks
  • Monitoring text reduction on a page
  • Leveraging the Table feature for efficient filtering tasks
  • Worksheet navigation with ease using hidden menus and keyboard shortcuts
  • Restoring classic Print Preview functionality in Excel 2007 and later
  • Simplifying repetitive tasks by creating personalized keyboard shortcuts
  • Managing long data lists through filtering instead of sorting

Who this course is for

  1. Anyone who wants to learn the importance of effectively communicating with their peers and superiors, trainee accountants and administrators that have recently joined the workplace as well as organisations and individuals who want to improve customer service and build long term customer relationships.
  2. Business professionals that require the skills to make successful presentations will also benefit from this self-study package as well as practitioners who may benefit from learning shortcuts that will enable them to use Microsoft Excel and Word more effectively and efficiently.

What you'll learn

  1. When and where to double-click or right-click with your mouse to uncover hidden functionality
  2. How to restore the classic print preview screen in Excel 2010 and later
  3. How to have Excel read numbers aloud to you
  4. Locking and unlocking worksheet cells, as well as alternatives that are more efficient
  5. Bypass filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click
  6. Eliminate duplicates from a list with just a few mouse clicks
  7. Simplify repetitive tasks by creating your own keyboard shortcuts

Requirements

No experience needed.

Show all

Course Content

6 Sections 22 Lectures 51m total length

Show more
0 Comments

Find Your Place in The World

Uplyrn-Logo

Learn from Industry Experts and Enhance Your Skills & Find jobs.

Company

Community

Lecturing

Mentoring 11

Terms Privacy Support
Terms Privacy Support