Excel Tip Tuesday: More IF Functions

Posted by Lisa on October 23, 2018 at 10:30 AM

After reading last week's blog post on the IF formula, perhaps you started browsing through other Logical Functions using the fx button in the formula bar. If so, you might have noticed that there are several different IF functions. These are useful, say, for IF you want to add together a list of values based on a specific criteria. Or what IF you want to count data based on a specific criteria or even find the average? Here are some examples of what you can do with the SUMIF, COUNTIF, and AVERAGEIF functions in Excel. In the first two columns I show samples, the next column is a description of the formula, then a view of the formula, and, finally, the formula results in the last column.

Read More

Topics: Excel

Excel Tip Tuesday: What IF?

Posted by Lisa on October 16, 2018 at 10:30 AM

The IF formula is considered a Logical Function in Excel, but sometimes it can seem anything but logical. Years ago, I created a cheat sheet in Excel for IF formulas that has helped me, and so I want to share it here with you.

Read More

Topics: Excel

Excel Tip Tuesday: Which formula should I use?

Posted by Lisa on October 9, 2018 at 10:30 AM

I’m sure you’ve all been working in Excel at some point or another and wanting to accomplish something specific. You know there must be a formula that does what you want, but you don’t have a clue what the formula is. Luckily, there is a way to search for formulas in Excel. Start by re-familiarizing yourself with the fx button in the formula bar:

Read More

Topics: Excel

Excel Tip Tuesday: What Those Formula Errors Mean

Posted by Lisa on October 2, 2018 at 1:37 PM

Remember early last month when I showed you IFERROR, which you can use to hide those error formulas we’ve all seen at one time or another? It's unpleasant to have to look at them, but have you ever really wanted to know what the errors actually mean? Here’s a handy little table that shows exactly what it means when you do see those errors - right before you correct or hide them.

Read More

Topics: Excel

Excel Tip Tuesday: Hide Those Formula Errors

Posted by Lisa on September 4, 2018 at 9:30 AM

Excel's IFERROR function returns a custom specified result when a formula generates an error, and it presents a standard result when no error is detected. IFERROR is an easy way to hide formula errors without using more complicated and nested IF statements (blech!).

Read More

Topics: Excel

Excel Tip Tuesday: Using Date Formulas

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

Are you constantly updating and changing the date on your reports? Just because time keeps going by doesn't mean that you should have to do a bunch of manual changes (or worse...forget to do them). There are several different date functions built to save you time.

Read More

Topics: Excel

Excel Tip Tuesday: Keyboard Shortcuts

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

Here's a super simple one that can yield super results. Do you ever watch advanced Excel users zip around their spreadsheets so fast that you have no idea how they are doing it? Well, instead of navigating with your mouse and selecting items from the menu there, is probably a keyboard shortcut that can save you time and give you this same super-Excel-ability.

Read More

Topics: Excel

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

Subscribe to B/P Impressions

Impressive Impressions

a blog that is also a resource for businesses

Bennett/Porter's Impressions blog provides sensible insight into the places where technology and business intersect. Yet beyond practical reflections, you'll find actual resources to help keep your business operations optimized. These resources include:

  • critical announcements about the ERP systems we support
  • efficient strategies for network management
  • tips and tricks on using business software
So read on, and get the inside track from the Pacific Northwest's premier experts in ERP software and Managed IT & Cloud Hosting services.

Recent Posts