Ways to Sum Data with Errors
Excel Techniques to Sum Data with Errors There are times that you need to know the sum of numeric data even though there may be… Read More »Ways to Sum Data with Errors
functions
Formatting Alternate Rows
Formatting alternate Rows Thanks to Diana Lawless for sending in this Excel tip. Using the Shift key and the Format Painter icon together allows you to format… Read More »Formatting Alternate Rows
Grouping Data by Date
Techniques for Grouping Data by Date in Excel If you have a large data set that includes transaction dates, you may want to aggregate amounts… Read More »Grouping Data by Date
The N() function. Comments Anyone?
Most people are familiar with Insert>Comment. Just right-click on a cell and select Insert>Comment. Very easy. Right-click on the comment to display it, edit it or… Read More »The N() function. Comments Anyone?
Using Workday to Calculate Invoice Dates
This is just a quick tip as Excel is not necessarily that date friendly. If you want to calculate an invoice date or a project… Read More »Using Workday to Calculate Invoice Dates