I’ve gotten multiple calls in the last few days about an error regarding invalid email addresses when preparing to print W-2s. You have to fix the problems before you can print W-2s even if you don’t need the email addresses. The first part of the error message says “The following errors occurred with your employee […]
Filtering By Color In Excel
Jan 15
Have you ever gone through a spreadsheet highlighting cells that need attention and then found that your list is so long it was still hard to located those cells even though they were bright yellow or red? There is an easy solution. You can filter your list to show you only selected colors. Filtering, or […]
You can easily compare this year’s income and expenses to last year’s, and calculate the difference both in dollars and as a percentage using a report generated by Sage 50. You don’t even need to send it to Excel to calculate the change. One of the build in financial statements, <Standard> Income 2 yrs, gives […]
Last month we covered the basics of sorting a list in Excel. Now let’s look at some more advanced options including case sensitive sorting, sorting from left to right instead of top to bottom, sorting by color, and creating custom sort orders.
I often get questions about how to do direct deposit payroll in Sage 50. There are a few different options, each with different benefits and different costs. Since people often considering implementing new procedures at the beginning of a year, I thought this would be a good time to cover this subject. OPTION 1 – […]
Sorting In Excel
Nov 25
Usually we think about Excel saving us time by performing lengthy or repetitive calculations for us. But sorting is another great time saving feature. It can do simple sorting with just two clicks or more complex multilevel sorting with an easy to use tool. You can sort your whole worksheet or just selected cells. In […]
If you have ever charged a customer sales tax when you shouldn’t have, you probably learned that correcting the mistake can be tricky. First let me point out a couple of common mistakes people make and why they don’t work. Mistake #1 – Using the sales tax field alone to issue the credit. Whether you […]
Today’s tip is about how you can discover some of Excel’s power on your own. Built into Excel are many helpful tools called functions. Functions are shortcuts that make it easier for you to accomplish things that would otherwise require long, complex formulas. For example, the best known function is Sum. You’ve probably used it […]
By default, most numbers in Sage 50 show 2 decimals. But you have the option of changing that. To change the number of decimals used on screen, open the Options menu and choose Global. On the Accounting tab are you can choose the number decimal places for Quantity fields, Unit Price fields, and Standard Fields. […]
You probably know that you can hide columns or rows in an Excel spreadsheet simply by selecting one or more rows or columns (for simplicity, I’ll only talk about rows, but everything here applies to columns also), then right-clicking and choosing Hide. You can unhide them by selecting a range of rows that includes the […]
