Peter G. Aitken wrote Excel Programming Weekend Crash Course to give you a quick and basic learning tool for Excel programming.
Jul 17
Excel VBA Programming for Dummies
John Walkenbach wrote the books Excel 2007 VBA Programming for Dummies and Excel VBA Programming for Dummies. These book will explain everything you need to know about VBA programming.
Jul 17
XML for Dummies
Written by Lucinda Dykes and Ed Tittel, XML for Dummies is a great tool to help learn the basics about XML.
Jul 17
XBRL for Dummies
Charles Hoffman is the “father” of XBRL, and is credited with the idea of applying XML data to financial reporting. XBRL for Dummies is a great tool to make sure you know the most about your XBRL.
Jul 17
Excel Data Analysis For Dummies
Stephen L. Nelson created Excel Data Analysis For Dummies to help everyone with basic data analysis when using Excel.
Jul 17
Microsoft Office Excel 2010: Data Analysis and Business Modeling
Wayne Winston wrote the book Microsoft Office Excel 2010: Data Analysis and Business Modeling to assist you in analyzing data and business modeling using Excel 2010.
Jul 17
Excel 2010 Data Analysis
Denise Etheridge wrote the book Excel 2010 Data Analysis as a visual blue print for creating and analyzing data, charts, and Pivot tables.
Jul 17
Spreadsheets Check and Control
Spreadsheets Check and Control by Patrick O’Beirne is a guide to help you get the most out of your spreadsheets.
Jul 16
First Thoughts on Excel 2013
by David H. Ringstrom The “customer preview,” or public beta version, of Office 2013 became available online today. I’ll give you a quick read on what I found in my first spin through Excel 2013. I’ll have much more to report in the coming months. Microsoft hasn’t yet confirmed a shipment date for the final …
Jul 16
First Look at Excel 2013
By David H. Ringstrom The “customer preview,” or public beta version, of Office 2013 became available online today. I’ll give you a quick read on what I found in my first spin through Excel 2013. I’ll have much more to report in the coming months. Microsoft hasn’t yet confirmed a shipment date for the final release, …
Jul 13
Is This Excel Worksheet Protected?
By David H. Ringstrom, CPA Long-term Excel users are familiar with the prompt shown in Figure 1. In Excel 2003 and earlier, there were two ways to determine if a worksheet was protected. One way involved attempting to modify a locked cell, which would trigger the aforementioned prompt. The second approach involved choosing Tools, Protection, …
Jul 10
Access Step By Step Book
The book that we recommend for anyone wanting to learn about Microsoft Access is Access Step By Step. There are versions for Access 2007 and Access 2010.
Jul 10
Sage 50/Peachtree Software Updates
You can download the latest service packs, also known as bug fixes, for Sage 50/Peachtree products from the Sage 50 web site. If you’re using a Peachtree product, select the Sage 50 version that matches your Peachtree product. For instance, Peachtree Complete users would click the link for Sage 50 Complete. From there you’ll see …
Jul 05
Excel Speed Tips: Do You Know the Tricks?
There is not one among us who would not benefit from using Excel more effectively. When you discover helpful features (that were always there!) you can save significant time. Do you use the Table and Form features to easily sift through large data sets? Do you know the keyboard shortcuts that help you blaze through …
Jun 28
Excel Formulas
John Walkenbach has written a series of books titled Excel Formulas for Excel 2013, Excel 2010, Excel 2007, and Excel 2003. We always recommend this book when someone asks what to buy to learn more about worksheet functions and formulas in Excel.