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.
Conditional formatting will format cells based on their value which you can pre-define. There are many format styles, including:
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:
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)
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!
As an Entrepreneur, one of the main “Hats” you need to wear is that of a bookkeeper, unless of course, you outsource this task. Keeping
5 tasks Plumber’s can outsource to a Virtual Assistant As a plumber or tradesman, you earn your money by working a job, not by sitting