Patricia's Published Articles
This SumIF article which was published in the Missouri Society of CPAs "The
Asset" in May 08. If you are not familiar with this function take a look.
Essentially you are automatically summing data if it meets the criteria
specified. If you are currently doing an IF statement, copying it down a column
and then adding up that column then this function is for you.
Go to page 31
to read my article on SumIF
Interactive or dynamic charts are exciting. Create the chart once and as you
add more rows of data to your spreadsheet, the chart will automatically redraw
itself! Check out my article from the Journal of Accountancy on Interactive
Charts.
JOA article on Interactive Charts
Check out my article on "Get Linked" which is found in the Arizona CPA Society E-News. This shows you how to link an Excel chart into Powerpoint. Two different ways to link.
Other Interesting Articles
Spreadsheet review and controls is always an important topic. Everyone creates a spreadsheet, perhaps they check it when it is initially set up for errors and then happily use the same spreadsheet for months or years without ever checking it again for errors. When was the last time you looked at your budget spreadsheet?
Spreadsheet Fraud - By M.Schaeffer - March 2008
8 of the Worst Spreadsheet Blunders - CIO.com
Sloppy Spreadsheets: Readers
Speak Out - CFO.com June 18, 2008