This provides an easy way to create in-cell bar charts. One of my favorites is the ability to have solid fill in a cell based on the value in it. Improved Conditional Formatting:Įxcel 2010 added a lot of simple but effect improvements to conditional formatting. MS has bought all these to fore-front with Paste Previews feature in Office 2010. There are a ton of cool paste features buried in the Paste Special Options in earlier versions of Excel. This could be very useful for those of us in teaching industry as you can quickly embed screenshots in to your teaching material (like slides or documents). Now, using Excel (or any other Office 2010 app) you can grab a screenshot of any open window. (I still prefer the excel 2003 style one click filtering).

When working with tables in Excel 2010, you can see the table filtering & sorting options even when you scroll down (the column headings – A,B,C… change to table headings)Īlso, in Excel 2010, data filters have a nifty search option to quickly search and filter values you want. They are an easy way to slice and dice a pivot table (what is a pivot table – tutorial).

We learn more about using them in tomorrows article. They add rich information analysis capability to mundane tables or dashboards. These are small charts that can be shown inside a cell and are linked to data in other cells.You can insert a line chart, win-loss chart or column chart type of spark line in excel 2010. There are a ton of new and cool features in Excel 2010. (with free upgrade to Office 2010 in June) What is new in Excel 2010? Leave a comment to win a copy of Office 2007 – Home & Student Edition

Download excel 2010 for windows 10 free