Excel Flash Fill – The Data Entry Shortcut You’ve Been Looking For

Excel’s Flash Fill is an amazing tool that combines elements of text-to-columns, concatenate, and find & replace. Not only is it powerful but it’s unbelievably simple to use.

Forcing Page Breaks in Excel

Sometimes page breaks fall at inconvenient places in your spreadsheet. But you can do more than just adjust your margins. Excel allows you to insert and even move page breaks. I’ll show you two methods for controlling page breaks in your Excel workbooks. First we’ll cover the old-school method. It’s simple but effective. Just put […]

Customizing Default Email Text in Sage 50

Do you email invoices, quotes, purchase orders, or other forms out of Sage 50? Have you ever wished you could change the standard text that Sage 50 puts in those emails? We’ll you can, and it’s really easy to do. Open the Maintain menu and choose Email Setup. In the Email Setup window select a […]

Introducing Sage 50cloud

As part of Sage’s new Sage Business Cloud initiative, Sage has announced Sage50cloud. Here are some common questions and answers about this exciting new development: Q: Is Sage 50 now being offered as a cloud product? A: No. Q: Is Sage 50cloud just the new name for Sage 50c? A: Yes. Q: If it’s still […]

E-filing 1099s from Sage 50

It recently came to my attention that the state of Oklahoma is now requiring anyone who sends out more than five 1099s to e-file a copy with the state. Since I’m in Oklahoma I felt like I needed to address this. The IRS also requires anyone filing more than 250 1099s to e-file. So this […]

How to Split One Column into Multiple Columns In Excel

Many times on a project you have the right data, but in the wrong format. In this tip I’ll show you how you can break apart a single column of data into two or more columns in Excel using the Text To Columns feature.

Sage 50 Crashing After Windows 10 Update

After installing the latest Windows 10 update (the Fall Creators Update) Sage 50 is crashing when launching certain tasks. The solution, until Sage releases a patch, is to run Sage 50 in compatibility mode for Windows 8. Just follow these steps: Right-click the Sage 50 Accounting icon on your desktop and select properties. Click the […]

Sage 50 2018.1 New Features

2018.1 Update for Sage 50: In November Sage released an update to Sage 50 2018. All users with a current subscription or Business Care Plan should be automatically notified when it is ready to be installed. If you don’t want to wait for it you can go to the Services menu and choose Check For […]

1099 Vendor Report – It’s not just for January

Year end is always a busy time for accountants and bookkeepers. The 1099 Vendor Report lets you review your 1099 data any time so you can resolve problems now, instead of in January when the deadline is looming.

Taking Advantage of Tables in Excel

In the general sense, a table is just data that you have arranged into columns and rows. But in Excel, when you use the Format As Table button to define an area on your spreadsheet as an Excel table, there are several things you’ll be able to take advantage of that make entering and working […]