Category: "Excel"

Excelling With Access

January 16th, 2015
Introduction If all of your financial records are maintained in Excel spreadsheets then you may be missing out on many of the advantages of using Access databases. Microsoft Access may already be available in your version of Microsoft Office. It is a… more »

Controlling Excel Windows

October 19th, 2012
Excel Window Displays Unless you change the default, Excel 2007/2010 opens all new workbooks in maximized view. In maximized view you do not see both workbooks at the same time. The confusion about this is so common that I put together the following ex… more »

Spreadsheet Mania

October 27th, 2006
One of the things that always baffles me at work is the amount of time that is spent entering and re-entering data into the computer to create a report. The way that reports are generally formatted the data in them aren't generally re-useable without bei more »