Mastering spreadsheet shortcuts in MS Excel


Earning a Microsoft Excel certification can set you apart in the job market and shows employers and hiring managers that you have the necessary skills to do the job.


Study in your own time with the comprehensive Mastering Spreadsheet Shortcuts in MS Excel course for Accounting Professionals Online Course


Are you working Excel or is it working you? Many users end up working harder than necessary in Excel carrying out repetitive tasks in an inefficient manner. This online Excel course focuses on helpful shortcuts that can be used in all versions of Excel. The online course also covers many Excel keyboard shortcuts and even shows you how to create your own custom keyboard shortcuts.

Course Content:

when and where to double-click or right-click with your mouse to uncover hidden functionality,
how to restore the classic print preview screen in Excel and later,
an alternative to the merged cells feature, and
how to have Excel read numbers aloud to you
locking and unlocking worksheet cells, as well as alternatives that are more efficient
materials cover Excel and.
add the hidden Form Command back to Excel and later
converting Excel files to modern workbook formats with ease.
creating a keyboard shortcut for Excel Freeze Panes feature
saving workbooks as .XLS files by dispatching the Compatibility Checker
bypass filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click
convert .XLS workbooks to the up-to-date .XLSX format with just two keystrokes
discover how to quickly access folders and workbooks, regardless of whether they are stored on your computer or on a network
discover techniques that automatically provide fallback positions in the event you need to see an earlier version of your spreadsheet
double-check manual inputs easily by having Excel read numbers aloud to you
eliminate duplicates from a list with just a few mouse clicks
keep an eye on how much your text is being reduced as you try to squeeze more on a page
learn how the Table feature allows you to transform filtering tasks
navigate large workbooks with ease by way of a hidden menu as well as keyboard shortcuts
restore classic Print Preview functionality in Excel and later
simplify repetitive tasks by creating your own keyboard shortcuts
wrangle long lists of data by filtering instead of sorting

Who will this package benefit?

Anyone who wants to learn to 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.

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.

white printing paper with numbers


There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

We want you to be satisfied, so all eligible courses purchased on Vogate can be refunded within 14 days. For whatever reason, if you are unhappy with a course, you can request a refund, provided the request meets the guidelines in our refund policy.

Certain restrictions may apply and some purchases may only be eligible for credit refunds. For more information regarding our refund policy, please see below.

How to submit a refund request

If you’re looking for instructions on how to submit a refund request, please visit our support and help section

Our 14-day policy

While our 14-day refund policy is to allow customers to learn risk free, we must also protect our vendors from fraud and provide them a reasonable payment schedule. Payments are sent to vendor after 30 days, so we will not process refund requests received after 14 days of purchase.

Additional reasons for denied refunds

We reserve the right, in our sole discretion, to limit or deny refund requests in cases where we believe there is refund abuse, including but not limited to the following:

  • A significant portion of the course has been consumed or downloaded by a customer before the refund was requested.
  • Multiple refunds have been requested by a customer for the same course or other courses
  • Excessive refunds have been requested by a customer.
  • Users who have their account reported, banned or course access disabled due to a violation of our Terms or Trust & Safety Guidelines. 
  • We do not grant refunds for any subscription services.

These refund restrictions will be enforced to the extent permitted by applicable law.