So many people, ignore spreadsheet design but it is important if you are building a complex worksheet or one that you will be referrring bac...

  =SUBTOTAL(9,range) versus =SUBOTAL(109,range) I have been busy revamping CPASelfstudy.com's site design and working on some Excel E...

Sorry- the link in the earlier post did not work for some reason. This is an article I wrote on Interactive Charts for the Journal of Accoun...

Charts in Real Time

Joins- Links Between Tables To retrieve information from multiple tables, there must be a link between the tables. This is commonly known...