All courses available in-class or via remote login

Numbers on screen

What are the best Excel tips and tricks?

November 13, 2019

What are the best Excel tips and tricks?

We all use Excel, it’s one of the most well-known Microsoft programs that makes so many of our work processes more efficient and the organisation of data sets so simple.  We also all know that Excel is a beast, and the things it can do for you are almost limitless.  As long as you have the right formula, Excel will pretty much do anything for you automatically, making it easy to make sense of your data.  Here are five of our favourite formulas and tips and tricks to use in Excel.

Using Pivot Tables

Pivot Tables help you summarise and explore data interactively within a spreadsheet.  They can help you to sum up values and compare different data sets depending on what you’d like to look at.

Check out this blog to learn how to make your own Pivot Table.

 

Using filters to simplify data

Huge datasets can be very overwhelming to look at, and sometimes you only want to be looking at certain rows at the one time.  Excel allows you to apply filters to each column so you can then choose which cells you want to view at once.  Simply click the Data tab in Excel and select Filter to customise what you’d like to view.

 

Calculation formulas

Excel makes even the simplest of mathematics easier, and a few keyboard shortcuts can make the process incredibly quick and easy.

Some basics nobody should go without:

To add, use +

To subtract, use –

To multiply, use *

To divide, use /

 

Using VLOOKUP

The VLOOKUP function allows you to pull data from one area of a sheet to another.  This is perfect for when you have two sets of data on two different spreadsheets that you want to combine.  This is where the VLOOKUP formula, =VLOOKUP(lookup value, table array, column number, [range lookup]) becomes your greatest ally.

Check out this blog for VLOOKUP troubleshooting.

 

Adding drop-down menus

Excel spreadsheets are useful to track processes and other qualitative items.  Rather than writing ‘Yes’ and ‘No’ values repetitively, you can add a Drop Down list into your spreadsheet to quickly mark descriptive things about what you’re tracking.

Check out this blog to learn how to create your own Drop Down list.

 

To learn more about Excel and how to best use it for your business, check out our courses across Australia.

What is Remote Training?

Valued by Individuals

 

4.8/5
Over 21559 Reviews
Thank you for everything and sharing information for external sources. Wonderful Teacher -Power Apps Intermediate Brisbane
Natasha - Power Apps Intermediate, .
Great course, gave me lots of ideas on how to improve processes in my workplace. It also helped me move away from the SharePoint is the be all and end all mindset I have been in. Thank you! -Power Apps Intermediate Brisbane
Katie - Power Apps Intermediate, .
Excellent as always -Analysis & Dashboards Melbourne
Jonathan - Analysis & Dashboards, .
Thank you for all the hard work. You are a great Teacher and very helpful.. -Power Apps Beginner Perth
Natasha - Power Apps Beginner, .
great course!! -Power Apps Beginner Perth
Wayne - Power Apps Beginner, .
very informative, enjoyed course -Power Apps Beginner Perth
Shannon - Power Apps Beginner, .
Excellent fast paced training, I really enjoyed the training style. Jagg answered all questions and was very knowledgeable -SharePoint Site Owner Adelaide
Chevaun - SharePoint Site Owner, .
Good session and learnt lots -SharePoint Site Owner Adelaide
Melodee - SharePoint Site Owner, .
Great informative session -SharePoint Site Owner Adelaide
Mandy - SharePoint Site Owner, .
Very good presenter. Patient and knowledgeable, thanks! Good content for someone new to Sharepoint. -SharePoint Site Owner Adelaide
Tanya - SharePoint Site Owner, .
Session was very informative and all questions answered -SharePoint Site Owner Adelaide
Tim - SharePoint Site Owner, .
Bit fast paced for me but worth doing as an introduction to the Sharepoint platform -SharePoint Site Owner Adelaide
DAVID - SharePoint Site Owner, .
Comprehensive training -SharePoint Site Owner Adelaide
Victoria - SharePoint Site Owner, .
Productive day. Learned a lot about SharePoint (still another day to complete where more knowledge will be shared). Trainer spoke clearly, concisely and in a way that assists with learning -SharePoint Site Owner Adelaide
Natalie - SharePoint Site Owner, .
Jagg had to manage multiple competency levels and IT issues, but ensured everyone kept together so no-one left behind which was good. -SharePoint Site Owner Adelaide
Kelly - SharePoint Site Owner, .
Great overview. -Project Beginner Brisbane
James - Project Beginner, .
Really good with the fundamentals which is exactly what I was after -Project Beginner Brisbane
Shane - Project Beginner, .
Clear and concise delivery, easy to follow, good level for beginners. -Project Beginner Brisbane
Julia - Project Beginner, .
Very informative and helped with digging myself out of the holes that i kept finding myself in. -Project Beginner Brisbane
Luke - Project Beginner, .
Excellent teaching, Awesome course -Project Beginner Brisbane
Justin - Project Beginner, .

Trusted by Business

Procured by Government

Map of Australia