One of the neat features of Excel is how there are so many cool ways to automatically show off your data; and one of those ways is by using Conditional Formatting. In short Conditional Formatting is where Excel causes formatting to occur based on the contents of the cell. To see how this works, create Post from: How to Use Conditional Formatting with Excel 2010

Read the rest here:
How to Use Conditional Formatting with Excel 2010

Microsoft Excel has had a fill feature of some kind going back several versions, and while each version did much the same as the last, you couldn’t always count on things just exactly the same way; below is the way it works in Excel 2010.

Read the original here:
How to Use the Excel 2010 Basic Fill Feature

One of the best ways to speed up your work in Excel, especially repetitive tasks, is to record macros that perform the things you do over and over. Another way is to use buttons to tell Excel to do things that you may not always remember how to do.

The rest is here:
Create a Simple Macro in Excel 2010 and Assign it to a Button

Microsoft Excel has long allowed users to create and use range names in earlier versions, of Excel, but that doesn’t mean everyone learned how to use them, which is a shame, because the main purpose of range names is to make things easier for you when creating and using spreadsheets. In Excel, 2010, creating a Post from: Create and Use Range Names in Excel 2010

See the rest here:
Create and Use Range Names in Excel 2010

A lot of people use Microsoft Excel as a database because they don’t want to learn how to use an actual database program, or because they don’t want to spend the money; whatever the reason, using Excel 2010 as a database is something that can be done relatively easy, so long as you keep things Post from: Create and Use a Simple Database in Excel 2010

View original post here:
Create and Use a Simple Database in Excel 2010