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 24229 Reviews
Thank you very much for your detailed instruction Domenic! I really enjoyed your course very much. The course was really useful and I can recommend your course to everyone! -Analysis & Dashboards Perth
Saori - Analysis & Dashboards, .
Good and professional training session! thanks to Domenic for carrying out the course. -Analysis & Dashboards Perth
Ayat - Analysis & Dashboards, .
A lot of information covered however course was at a good pace with sufficent breaks. Jason was clear and easy to understand with the way he presented the information. Attending remotely it at times was hard to hear the questions from the people in the room so sometimes a bit confusing I found it really informative and would recommend to collegues and friends Thank you -Power BI Beginner Brisbane
Christine - Power BI Beginner, .
Course was great, and very informative. -Power BI Beginner Brisbane
Mark - Power BI Beginner, .
THe beginner Power BI course run by Jason was fantastic. I really feel like I have had a clear & thourough introduction to the application. -Power BI Beginner Brisbane
Anna - Power BI Beginner, .
Jason was great. Very clear in instructions and went at a good speed for someone with minimal exposure to Power BI. It was a long day of learning but covered a lot of ground -Power BI Beginner Brisbane
Melissa - Power BI Beginner, .
Good training - easy to follow -Power BI Beginner Brisbane
Rachael - Power BI Beginner, .
Excellent !!! -Power BI Beginner Brisbane
Khurram - Power BI Beginner, .
Good interactive and practical course presented well by Jason. -Power BI Beginner Brisbane
Anthony - Power BI Beginner, .
It was very helpful and informative. Steven was very patient and knowledgeable. -Excel Beginner Brisbane
Jessica - Excel Beginner, .
Steve delivered a very interesting and informative session that will support me in my position moving forward -Excel Beginner Brisbane
Margaret - Excel Beginner, .
Great course. I learnt a lot. Steven was a great trainer. -Excel Beginner Brisbane
Alison - Excel Beginner, .
Very practical and informative session. Will be very useful in my daily work. -Excel Beginner Brisbane
Julie - Excel Beginner, .
very patient, relatable presenter. Good examples -Excel Beginner Brisbane
Kate - Excel Beginner, .
Thank you. -Power BI Beginner Adelaide
Shane - Power BI Beginner, .
Excellent fundamental class for R by Tamara -R Basics Perth
Virendra - R Basics, .
It was good but I think I will need to do the Basic Course as some of the techniques were a little beyond me. Thanks Stuart for your patience. -Word Intermediate Brisbane
Carmen - Word Intermediate, .
Thank you Stuart -Word Intermediate Brisbane
Chiho - Word Intermediate, .
Learnt some good techniques. Thanks Stuart -Word Intermediate Brisbane
Millie - Word Intermediate, .
Good course. It was good to uncover details about styles. -Word Intermediate Brisbane
Graham - Word Intermediate, .

Trusted by Business

Procured by Government

Awards and Accreditations

Map of Australia

Follow us