Excel – Use Sort & Filter to View Data (Excel 2007 & Excel 2010)
You can use the "Sort & Filter" feature to view data in a worksheet in many different ways.
This post is only available to members.
Excel – Use ‘Auto Sum’ in a Worksheet (Excel 2007 & Excel 2010)
You can sum a group of numbers in Excel 2007 & Excel 2010 with one click of a button!
This post is only available to members.
Excel – Use Merge & Center for Text (Excel 2007 & Excel 2010)
Merge & Center allows you to group cells (e.g. a header over multiple columns) and center the text within that group of cells.
This post is only available to members.
Excel – Wrap Text in a Cell (Excel 2003, Excel 2007 & Excel 2010)
If you are typing text into a cell and it is longer then the cell allows for, you can ‘Wrap Text’ to allow all text to appear in one cell. This will work in Excel 2007 & Excel 2010.
This post is only available to members.
Excel- Using ‘Auto Fill’ Options (Excel 2010/2007/2003)
By default Excel will fill in numbers and dates when you use the ‘Auto Fill’ handle. Did you know that it will also fill in days of the weeks and months? This will work in Excel 2007 & Excel 2010.
This post is only available to members.