When you want to see one formula, just click in that cell and look in the formula bar. But have you ever found yourself going to cell after cell to check all of your formulas? In that situation, it would be a lot better to be able to see all the formulas on your spreadsheet. […]
Archive for category All
The list windows in Sage 50/Peachtree can do a lot more for you than what most people realize. Of course we all know them as a way to choose a transaction we want to look at in one of the task windows. But do you realize how many ways they can help you locate a […]
In Excel, the other cells that are referred to in a formula are called precedents. Conversely, the cell containing the formula is a dependent because it needs the cell containing the data to complete its function. I’ve written before about the ability to trace precedents and dependents, But I recently learned two keyboard shortcuts that […]
One of the new features in version 2014 of Sage 50 that I have really come to appreciate is the ability to set a pop-up reminder message for any customer. The message pops up on quotes, proposals, sales orders, invoices, or credit memos. Since you can set up a different message for each customer it’s […]
Have you ever wanted to create a new column on a spreadsheet with part of the information already in another column? For example, you might have a column of zip codes with 4 digit extensions and you want to put the 5 digit zip code in column by itself and the 4 digit extension in […]
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 – […]
