I consider myself an Excel poweruser. I program in it daily (20ish hours a week) and manage a few thousand lines of code for my personal use (stocks and finance). Outside of Excel, I know very little ...

Microsoft Access provides tools that make it relatively easy to load data from a variety of external data sources and in many different formats. There is no connection type specific to Microsoft SQL ...

Spreadsheets contain many tools for analyzing and manipulating data. The trouble is much of the data CPAs need to analyze resides in company databases or on the Internet. So, after finding the ...