Category: "Excel"

Excelling With Access

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

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

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 »