Have you ever wanted to create a new column on a spreadsheet with part of the information already in another column? For example, you might have a column of zip codes with 4 digit extensions and you want to put the 5 digit zip code in column by itself and the 4 digit extension in […]
Archive for category General Tips
Filtering By Color In Excel
Jan 15
Have you ever gone through a spreadsheet highlighting cells that need attention and then found that your list is so long it was still hard to located those cells even though they were bright yellow or red? There is an easy solution. You can filter your list to show you only selected colors. Filtering, or […]
Last month we covered the basics of sorting a list in Excel. Now let’s look at some more advanced options including case sensitive sorting, sorting from left to right instead of top to bottom, sorting by color, and creating custom sort orders.
Sorting In Excel
Nov 25
Usually we think about Excel saving us time by performing lengthy or repetitive calculations for us. But sorting is another great time saving feature. It can do simple sorting with just two clicks or more complex multilevel sorting with an easy to use tool. You can sort your whole worksheet or just selected cells. In […]
Today’s tip is about how you can discover some of Excel’s power on your own. Built into Excel are many helpful tools called functions. Functions are shortcuts that make it easier for you to accomplish things that would otherwise require long, complex formulas. For example, the best known function is Sum. You’ve probably used it […]
You probably know that you can hide columns or rows in an Excel spreadsheet simply by selecting one or more rows or columns (for simplicity, I’ll only talk about rows, but everything here applies to columns also), then right-clicking and choosing Hide. You can unhide them by selecting a range of rows that includes the […]
If you need to calculate a date in Excel based on another date, such as a due date that is 30 days after an invoice date, or scheduling a follow-up 3 months after a meeting, you can do so using a simple formula to add a number of days to a date, or using the EDATE function to get the same date in a future (or past) month.
If you have ever needed to shut down Windows 7 in a hurry only to discover updates waiting to install, this is the tip you’ve been waiting for.
Centering text across multiple columns in Excel is easy with this quick formatting tip.
Have you ever wished you could take a picture of your computer screen to use in a document? Well most Microsoft Office 2010 programs finally give you a convenient way to do this.
