Posts

Posted on

Use Autosum to speed up data analysis In Excel

You can learn how to get more out of your data with Excel 2010 training courses London. For example, Autosum offers you so much more than just, well, auto-summing. It belongs in the Formulas tab, but you’ll also find it tucked away on the Home tab.

Tip:  I use Autosum so much I like to add it to my quick access toolbar.  To do this, right click on the Autosum icon, and select “Add to Quick Access Toolbar”.

The Autosum button offers you a quick way to access common calculations such including:

  • Sum
  • Average
  • Count numbers
  • Maximum
  • Minimum

This is a really quick way to get the results to these common questions, so when you are asked to give an answer in a few seconds, you can do it.

Here is my list of fictitious students.  I want to know the average score from their exam.  I select the exam results  and then go to the Autosum icon, on the Formulas tab.

autosum-options-excel-2010-training-london
Autosum options…so easy to access…

I choose Average, and Excel will give me the result below the selected results.  I can use the same method to find out the minimum result, maximum result, count up the number of students….etc etc.

Average-results-excel-2010-training-london
Ta da! The results are in.
Posted on

Using number filters in Excel

I can filter data in my Excel worksheet, using the number filters.  This is another time-saving feature that helps me to get the data I need, quickly and easily.

list-of-students-course-on-excel-2010-training-course
The list of students

You can access the number filters, by selecting the down arrow next to the filter in the column you want to review.

number-filters-in-excel-2010-training-courses
Number filter options – so you can get the information you need in one click.

The filters offer you the apply number filters including:

  • Equals
  • Does not equal
  • Greater than
  • Greater than Or Equal to
  • Less than
  • Less than or equal to
  • Between
  • Top 10
  • Above average
  • Below average

If you click on a number filter, a dialogue box will open and you can type in the figures to complete your task.

For example, I want to sort my list by those students with results between 55 and 70.

number-filter-greater-than-or-equal-to-excel-2010-training-courses
Filter options appear when you click, to figure out results between 55 and 70. I’m going to use “Greater than Or Equal to”

Excel now gives me a dialogue box and I can add the range I want to find, and use the additional options in this box to customise my search.

add-values-to-filter-excel-2010-training-courses
Setting up the range using number filters

Once I press ok, Excel gives me the results.

results-from-filter-excel-2010-training-course
The results using the filter.

Using filters is included in our Excel 2010 training courses.  Take a look at what you can learn https://www.stl-training.co.uk/syl/26/excel-formulas-functions.html