Microsoft Excel Keyboard Shortcuts: What You Need to Know

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

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.

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

No experience needed.