Posts

Posted on

Zoom in and out and Switch Views in Excel

Using different views in Excel can help speed up the quick analysis of data.  Using Views is a great tool for viewing and organising large spreadsheets.

Zoom in on current selection
I use Excel for 90% of my work and using views is an effective way to zoom in and out on data.  To access this tool, go to the View tab and select Zoom to Selection.  Click on this and Excel will zoom in on your selected area.

view-tab-zoom-view-microsoft-excel-training
The View tab includes this fantastic little widget…the Zoom Feature.

Tip: you can use your mouse to zoom in and out of your worksheet.  Hold down the Control key and use the central wheel on your mouse to zoom in and out.

Switch Windows
I tend to have several Excel documents open at the same time, so I like to be able to switch between them easily.  In the View tab, I can use the Switch Windows tab to do this.

Switch-windows-microsoft-excel-courses
Switch Windows quickly using this nifty little tool in the View tab

Tip: If you switch between Excel documents a lot, try adding the Switch Windows function to your Quick Access Toolbar.  To do this, right click on the Switch Windows icon and select “Add to quick Access toolbar”.

 

Viewing and organising data is included in our Microsoft Excel courses.  https://www.stl-training.co.uk/microsoft/excel-training-london.php

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.