Excel Tip Tuesday: Subtotals (for those filtered columns from last week)

Posted by Lisa on August 14, 2018 at 9:30 AM

Remember last week when we learned how to use Auto Filters? Well, what if you need totals for those spiffy new filtered columns of yours? Use the SUBTOTAL function! And it’s seriously easy when you already have a filtered list. Go to the bottom of the column and click the AutoSum button on the Home Tab...

Read More

Topics: Excel

Excel Tip Tuesday: Auto Filters

Posted by Lisa on August 7, 2018 at 9:30 AM

We took a few weeks off. Hey! It's summer! But we're back with more tips to improve your use of Excel. Let's begin with Auto Filters.

Using Auto Filters is my favorite ways to filter and sort data! Let's start with a worksheet that contains a data table I'd like to analyze. First, I have to turn on Auto Filters. To do that, I navigate to the Home tab and select Sort & Filter > Filter, like this:

Read More

Topics: Excel

Excel Tip Tuesday: Move or Copy Worksheets

Posted by Lisa on July 17, 2018 at 10:00 AM

Have you ever copied the data from a worksheet in your Excel workbook to another workbook - or even a worksheet - and then you spend time reformatting the data you copied because it didn’t copy everything? Let's look at how to make that not happen and shorten the time between original and copy.

Read More

Topics: Excel

Excel Tip Tuesday: Navigating Worksheets with the Sheet Tab

Posted by Lisa on July 10, 2018 at 10:00 AM

Do you have an Excel workbook that has a ton of worksheets? And does it take you forever to find the specific sheet you are looking for? If you answered "yes" and "yes," then there's a shortcut you should be using to see all sheets in one place.

Read More

Topics: Excel

Excel Tip Tuesday: Fun with Formulas

Posted by Lisa on July 3, 2018 at 10:00 AM

Do you ever need to know the number of characters in a cell? What about changing the case of text in a cell automatically? Or even something as basic but useful as removing those pesky spaces at the beginning or end of text? Try these formulas.

Read More

Topics: Excel

Excel Tip Tuesday: Freeze Panes

Posted by Lisa on June 26, 2018 at 10:00 AM

Do you waste time scrolling in Excel? Do you ever have so much data in Excel that, when you scroll down or to the right, you lose the headers and have to scroll back up to see what the column heading is? You can prevent all the extra scrolling by doing one little trick in Excel called Freeze Panes, which allows you to scroll and keep the first rows or columns visible at all times.

Read More

Topics: Excel

Excel Tip Tuesday: Should your columns be rows?

Posted by Lisa on June 19, 2018 at 10:00 AM

Have you ever been creating a spreadsheet in Excel when you suddenly realize: "Oh no! These columns should actually be rows." (Or the other way around?) Then you proceed to delete all of your column headers and re-type them as rows? Wouldn't you rather just have them magically switch direction? They actually can!

Read More

Topics: Excel

Excel Tip Tuesday: Using the Format Painter

Posted by Lisa on June 12, 2018 at 10:00 AM

Did you ever wonder what that little paintbrush on the Home tab in Excel does? It's called the Format Painter, and it can save you so much time - and so many extra menu clicks - when you want to make mismatched formatting uniform. In other words, the Format Painter is a one-click option to copy formatting from one cell to many others.

Read More

Topics: Excel

Excel Tip Tuesday: Don't hide. Group!

Posted by Lisa on June 5, 2018 at 10:00 AM

Are you guilty of hiding columns and rows in Excel? Sometimes there is information that you don’t want to show on your Excel report, but you need to have the information there for reference or for notes or formulas. The most common thing to do is HIDE, which I think should be a punishable offense. Hiding column A or row 1 can sometimes be difficult to unhide. Or you might forget - or not realize - that there are hidden rows or columns. Is there a better way? Yes, there is!

Read More

Topics: Excel

Excel Tip Tuesday: Teach the fill handle a new list

Posted by Lisa on May 29, 2018 at 10:00 AM

Are you typing the same list into Excel over and over? And over? If you have between 2 and 240 items in a list that you use time and again, you can teach Excel that list so that it can recall it for you.

Read More

Topics: Excel

Don't Miss a Thing!

Subscribe to our blog

Subscribe to our blog

    Recent Posts

    Posts by Topic

    see all