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

Don't be a Sales & Use Tax Dummy!

Posted by B/P News & Notes on June 15, 2018 at 3:35 PM

We all love a short break in the workday. And we all love thinking about taxes! Okay...maybe not that second thing. Still, grab your warm drink of choice, and let’s play a quick game that tests your knowledge on current sales & use tax regulations. How many of the following questions will you get right?

Read More

Topics: Business Technology, Business Essentials, Taxes

Sage 100, Sage 100Cloud, and the New Statewide Transit Tax

Posted by Sue on June 12, 2018 at 3:40 PM

Sage Software will only be updating Sage 100 version 2018 and Sage 100Cloud version 2018 to accommodate the new, statewide Oregon Transit Tax, which goes into effect on July 1 of this year. As we mentioned in our preview last month, the Transit Tax is 0.1% of each and every Employee’s Withholding Wage, is to be reported quarterly, and is reported on a separate form that is not part of the Oregon OQ Quarterly filing. For Sage Payroll clients on versions 2014, 2015, 2016, or 2017 (or even older versions!), we’ve had to be creative to accommodate the new tax. For clients using Sage Payroll version 2018, you’ll receive the update automatically through the new 2018 Tax Engine at month end.

Read More

Topics: Sage 100c, Sage 100 Payroll, Sage 100, Payroll, Taxes

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

Excel Tip Tuesday: The fill handle has other options

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

It's fairly common practice to right-click on a cell - or a group of cells - to get some additional options. These options broaden what you can do with the content of that particular selection. But did you know that right-clicking just the fill handle offers a whole other set of choices?

Read More

Topics: Excel

Are you ready for employment changes taking effect July 1, 2018?

Posted by Christy Putnam on May 16, 2018 at 3:57 PM

 

In addition to the (hopefully) sunny days of summer, July 1 of this year brings with it a host of legislative changes that will impact employers and their employees. Here are three of the most critical employment changes that you'll want to know about. 

Read More

Topics: Human Resources, Payroll, Taxes

Excel Tip Tuesday: How did you copy all that data?

Posted by Lisa on May 15, 2018 at 10:30 AM

When I'm teaching a class or doing a demo in Excel, people will often stop me suddenly and ask, "Wait, wait, wait! How did you just copy all of that data so fast?" Here's how you can speed things up for yourself.

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