Easy way to improve your Excel skills

Got a database you need to sort, need some figures collating? Microsoft Excel is the perfect application to make your spreadsheet needs possible, here are some of the best tips to sharpen your ability in Microsoft Excel


How to add up figures FAST

Easy way to improve your Excel skills


Being able to tally up data within tables, rows and columns is invaluable - This tip will save you so much time for when it comes to carrying out tasks like accounting, sales forecasts and large sums.

Best tips to improve your Excel skills

The function is called an "AutoSum", to execute this, simply click on the cell to the right of the last number in your row of numbers, this is for if you want to figure out the sum of a row. Alternatively, you can click on the cell beneath your last number in a column to AutoSum a column of numbers. Once you click on the corresponding cell, press the AutoSum button located in the top right of your Excel interface, then once the AutoSum range pops up, hit "Enter".


Locate all cells with the same value

Easy way to improve your Excel skills


This trick helps massively when trying to find the percentage of certain outcomes from things like data entry and surveys that you have collated into Excel.


Best tips to improve your Excel skills

To search for a value or certain letter or word, press "Ctrl-A" to select every cell, or click on the