All courses available in-class or via remote login

13 tips for using excel efficiently from nexacu

13 Excel Shortcuts You Need to Know

May 18, 2017

Want to use Excel more efficiently?

Then here are our 13 most useful Excel shortcuts you need to know.

Excel is an extremely powerful tool for for analysing and collating data but if you find yourself entering in the same data constantly all the while thinking "there must be a better way" then you're probably not doing it right. There is a better way, you just don't know it yet. Not only do excel shortcuts save you time but they also improve your accuracy and the overall efficiency of your spreadsheets. Apart from the commonly known excel shortcuts such as CTRL + C (copy), CTRL + V (paste) and CTRL + X (cut). There are plenty of other extremely useful short cuts in Excel worth knowing.

The list below are a couple of our personal favourites that will improve your efficiency and expedite your daily routine tasks.

 

#1 Add a new line to a cell

  +   

Ever wondered how to move down to the next line in the same cell? Alt + Enter is the solution.

 

#2 Value Replace

 + 

This brilliant shortcut replaces all values in a current worksheet with the formulas working in the backend. Use the shortcut again to revert back to the values.

 

#3 AutoSUM

 + 

This short cut works as a AutoSum. It not only plugs into the SUM function but automatically selects all cells to be added.

 

#4 Select an entire column

 + 

 

#5 Select an entire row

 + 

 

#6 Hide Selected column(s)

 + 

 

#7 Hide Selected Row(s)

 

#8 Perform a quick spell check of the entire sheet

 

 

#9 Edit selected cell

 +  + 

 

#10 Apply currency format on selected cell

 + 

 

#11 Moves you to the next right worksheet

 + 

 

#12 Moves you to the left worksheet

 + 

 

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 25944 Reviews
Good course and presenter, easy to follow remotely. Well paced and timed. a couple of exercises needed Dax Studio - if I had known this I could have requested IT load it for me - although potentially I missed this as I had to switch to remote after I had registered. -Power BI DAX Remote Online
Sharon - Power BI DAX, .
Excellent examples of the Power BI course, will definitely be able to use these in the dashboards at work. -Power BI DAX Perth
Hooi - Power BI DAX, .
good coverage and explanation of issues -Power BI DAX Perth
Luke - Power BI DAX, .
trainer is extremely attentive to student's questions and feedback, and strive to answer fully. trainer is humorous, creating a relaxing atmosphere to learn loads of information packed in a day. -Power BI DAX Perth
Yalin - Power BI DAX, .
Excellent course with an excellent facilitator. -Power BI DAX Perth
Steven - Power BI DAX, .
Being custom arranged for what is used in this workplace was a large benefit and Steven use the Nexacu examples but made sure he referred to how it related to QR examples. -Excel Customised Brisbane
Phoebe - Excel Customised, .
Course was use full. Step by step analysis of formulas and executing them was very much usefull. -Excel Customised Brisbane
Karan - Excel Customised, .
Good course -Excel Customised Brisbane
Mark - Excel Customised, .
Well constructed 1 day course. I felt it was at a good pace, worth while in certain items and excellent presentation. Steven did not go too far without ensuring everyone was up to date! Time to get some practice! -Excel Customised Brisbane
Colin - Excel Customised, .
Good and efficient training. -Excel Customised Brisbane
Sabine - Excel Customised, .
Very well run course -Excel Customised Brisbane
Sam - Excel Customised, .
A very informative course. -Excel Customised Brisbane
Andrew - Excel Customised, .
Steven was great, thank you -Excel Customised Brisbane
Tahlia - Excel Customised, .
Very useful -Excel Customised Brisbane
Nadia - Excel Customised, .
Great Session,Steven was very knowledgeable, kept us on track, willing to answer questions and very engaging. Thank you Steven. -Excel Customised Brisbane
Caralee - Excel Customised, .
Well presented and informative -Office365 Advanced Adelaide
Annie - Office365 Advanced, .
The instructor (Michael) is very good in explanation and has a good example to make everything clear and easy to understand. -SharePoint Site Owner Sydney
Nawaporn - SharePoint Site Owner, .
This has been a thorough learning experience covering all aspects SharePoint. The training was delivered professionally and was easy to understand. -SharePoint Site Owner Sydney
David - SharePoint Site Owner, .
Course was well run. -Office365 Advanced Adelaide
Stacey - Office365 Advanced, .
Great! Very easy to follow and informative -Power BI Beginner Melbourne
Connie - Power BI Beginner, .

Trusted by Business

Procured by Government

Awards and Accreditations

Map of Australia

Follow us