Excel Tip Tuesday: Recent Workbooks and Using Pins

Posted by Lisa on December 11, 2018 at 10:00 AM

You may have dozens of Excel workbooks that you use, but chances are that there are a select few that you work with frequently and intensely. There are a couple ways within Excel to make those commonly used workbooks faster to access so that you can get your work accomplished with less clicking around.

Read More

Topics: Excel, Excel Tip Tuesday

Excel Tip Tuesday: How to do Absolute References FAST!

Posted by Lisa on December 4, 2018 at 10:00 AM

Now that you've followed Part 1 and Part 2 of our Absolute References series, you may be saying, "Yeah, but it takes a lot of time when creating formulas to type in the dollar sign ($), especially when building long, complicated formulas. Well, there’s a shortcut to fill in the dollar sign quickly and make your work super fast: just use the F4 key.

Read More

Topics: Excel

Excel Tip Tuesday: More Options with Absolute References

Posted by Lisa on November 27, 2018 at 10:00 AM

Last week in Part 1 of this series - before you were crushed under all those leftovers - I showed you a simple Absolute Reference to just one cell. But what if you have multiple references and need to copy the formula into many cells of various rows and columns? You could - if you really, really, really, needed something to do - edit the formula in every result cell to show the correct cell reference. However, a faster option is to use those Absolute References (remember...the dollar sign $). 

Read More

Topics: Excel

Excel Tip Tuesday: How to work with Absolute References

Posted by Lisa on November 20, 2018 at 10:00 AM
Happy almost Thanksgiving!!

Do you spend a lot of time rewriting or editing formulas because the cell references change (e.g. you copy a formula, but you want B2 to remain B2 and not change to C2 or D2 to E2 to on and on, but all your new formulas are broken and displaying error messages)? Using Absolute References correctly can help you avoid this common problem and save quite a bit of time. They can help you so much that our next three posts are going to be dedicated to working with Absolute References. Don't worry...it's mainly pictures.

Read More

Topics: Excel

Excel Tip Tuesday: Making Excel Speak!

Posted by Lisa on November 13, 2018 at 10:15 AM

Have you ever worked late and wished that there was someone to talk? Maybe even someone who could help you do your work? Did you know that Excel can actually speak? And it's a really diligent co-worker, too. Making Excel speak can come in handy if you need someone to read numbers to you while you check them off of a report for the purposes of reconciling the books. It can also recite poetry, but maybe we’ll get to that in another blog…

You might be really excited by now and enthusiastically asking, "How do you make Excel speak?" Remember when we went over customizing the Quick Access Toolbar? We’re going to use that knowledge now to create a shortcut, and then you will have that person - oh okay...that A.I. - that can read numbers to you while you're doing all that reconciling.

Read More

Topics: Excel

Excel Tip Tuesday: Quiz Time!

Posted by Lisa on November 6, 2018 at 10:30 AM

For several months now, I've been providing you with tips and tricks to help you use Excel more intelligently and efficiently. We've looked at Auto Filters in order to be smart about filtering and sorting data, we've played with grouping as an intelligent alternative to hiding - and losing - rows and columns, we've seen what more the fill handle can do, and we've had fun with formulas.

Read More

Topics: Excel

Excel Tip Tuesday: Customizing the Quick Access Toolbar

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

How much extra time do you spend clicking back and forth between the tabs on the ribbon in Excel? Are there things you do often enough that having a simple shortcut to them would be a huge time saver? For example, remember the previous Excel Tips for freezing panes, grouping (rather than hiding), and using the Format Painter? All of these and more can be added to the Quick Access Toolbar in Excel, giving you almost instant access to the features you use on a routine basis. Here's how.

Read More

Topics: Excel

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

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