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

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

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