Microsoft Excel 2010

Hints and Tips

Microsoft Excel 2010 saw many changes made to its layout which left many people confused about where to find settings they commonly use. I’m going to explain some of the cool new features Microsoft Excel 2010 offers.

Click on each heading below to find out more about that Excel function.

Styles are pre-defined options which provide a quick and easy way of changing the appearance of selected cells.

Define your styles and save them for later or copy styles from other workbooks.  Microsoft Excel 2010 makes it easy to design workbooks which look the same as each other.

Using Styles

  1. Select the cells you want to apply a style to
  2. Click on the home ribbon
  3. Click “cell styles” in the “styles” group
  4. Select your chosen style or define your own

For more information on Styles please click here.

Conditional formatting will format cells based on their value which you can pre-define.   There are many format styles, including:

  • Data Bars and Colour Scales are like graphs in a cell which will change automatically when cells with the same setting (known as rules) change. 
  • Icon Sets insert little icons in the cell that dynamically change when cells with the same rules change.  

Click here for more information on conditional formatting

Applying a table format to a sheet in excel provides not only a handy way to change the look of the data but also has a number of useful features such as:

Click here for more information on managing data in tables

Here you will find various options for sorting, filtering, filling and calculating data.

On the Insert ribbon, you will find all the possible options you have in Microsoft Excel 2010 for inserting items into your workbook.   Everything from pictures and charts through to Sparklines and slicers.

Slicers are easy-to-use filtering components that enable you to quickly filter the data in a Table or Pivot Table, without the need to open drop-down lists to find the items that you want to filter.  (MS Office website)

Using Slicers

  1. Ensure you have converted yo#tablesur sheet into a table and selected a cell within that table
  2. Got to the Insert ribbon
  3. Click on Slicer under the filter group
  4. In the pop-up screen, select the fields you would like to be able to filter on
  5. Click ok
  6. Move and resize the Slicer as you would a picture
  7. Use the Slicer ribbon to access other options such a formatting and linking it to other pivot tables and graphs

Under the Page Layout ribbon, you can change the pages settings, apply themes and find tools that help you arrange objects within your spreadsheet to make it look good and print as required.

Most of us would have had some point spent a long time working our way through a spreadsheet trying to identify and remove duplicate entries.  The Remove Duplicates tool found on the Data Ribbon does this for you.

We hope you have enjoyed reading this article and have learnt something new.  If there is anything you would like to know how to do, then please leave us a comment and we’ll get back to you with an answer.

Also, don’t forget that we offer a range of Services from Office Administration through to Process Improvement so don’t forget to go check out our main site.

Thank you for reading!

Our Blog

Find out more about us

Contact Us

Share this:

Like this:

Like Loading...
%d bloggers like this: