Author's posts
Sep 10
Microsoft Adds Key Features to Excel for iPad
David H. Ringstrom, CPA, heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at david@acctadv.com or follow him on Twitter. David speaks at conferences about Microsoft Excel and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link.
Sep 04
When Excel Dates Mysteriously Shift by 4 Years
David H. Ringstrom, CPA, heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at david@acctadv.com or follow him on Twitter. David speaks at conferences about Microsoft Excel and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link.
Aug 28
Hasten Your Departure with Pre-written Resignation Letter
David H. Ringstrom, CPA, heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at david@acctadv.com or follow him on Twitter. David speaks at conferences about Microsoft Excel and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link.
Aug 07
Exploring the Nuances of Excel’s SUM Function
David H. Ringstrom, CPA, heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at david@acctadv.com or follow him on Twitter. David speaks at conferences about Microsoft Excel and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link.
Aug 04
Maximizing Excel’s Alt-Down Arrow Keyboard Shortcut
David H. Ringstrom, CPA, heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at david@acctadv.com or follow him on Twitter. David speaks at conferences about Microsoft Excel and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link.
Jul 22
Automating an Excel-Based Financial Statement
David H. Ringstrom, CPA, heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at david@acctadv.com or follow him on Twitter. David speaks at conferences about Microsoft Excel and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link.
Jun 25
Use Excel Pivot Tables to Analyze QuickBooks Data
by David Ringstrom
When it’s time to crunch numbers in QuickBooks, most users rely on reports within the software, while others turn to analytics programs. In either case, you may still sometimes need to analyze your accounting data in new ways. Pivot tables can make quick work of figuring out patterns or issues with your data that might be hard to discover otherwise. Pivot tables allow you to create instant reports and/or charts by dragging and dropping fields with your mouse. This means you can quickly rearrange even enormous reports into interactive, yet compact summaries.
See www.sleeter.com to read the rest of the article.
David H. Ringstrom, CPA heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at david@acctadv.com or follow him on Twitter. David speaks at conferences about Microsoft Excel, and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link.
Jun 19
Embed Frequently Used Lists into Excel
David H. Ringstrom, CPA, heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at david@acctadv.com or follow him on Twitter. David speaks at conferences about Microsoft Excel and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link.
Jun 12
Why Solid State Drives are Worth the Extra Cost
David H. Ringstrom, CPA, heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at david@acctadv.com or follow him on Twitter. David speaks at conferences about Microsoft Excel and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link.
Jun 05
Creating an Equivalent to the MAXIF Function
David H. Ringstrom, CPA, heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at david@acctadv.com or follow him on Twitter. David speaks at conferences about Microsoft Excel and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link.
May 01
Hackers have Discovered a Way into the Internet Explorer
David H. Ringstrom, CPA, heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at david@acctadv.com or follow him on Twitter. David speaks at conferences about Microsoft Excel and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link.
Apr 29
Make QuickBooks Data Analysis More Simple in Excel
by David Ringstrom
If you’re unfamiliar with certain naunces within the two programs, analyzing QuickBooks data in Excel can be an exercise in frustration. In this article, I’ll show you techniques for both programs that can transform how you crunch numbers. Among other things, I’ll share my favorite report for QuickBooks data analysis in Excel, a technique for creating one-click report access in QuickBooks, and a brief overview of the Table feature in Excel.
See www.sleeter.com to read the rest of the article.
David H. Ringstrom, CPA heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at david@acctadv.com or follow him on Twitter. David speaks at conferences about Microsoft Excel, and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link
Apr 18
My First Impressions of Excel for iPad
by David Ringstrom, CPA
Four years after the first iPad spreadsheet, users finally have a Microsoft-sanctioned solution. When I first installed Excel on my iPad, I immediately focused on its limitations, but upon reflection I see that Excel for iPad has certain strengths as well. To be sure, tablet computers have far to go before any heavy Excel user would be highly effective with this version. And out of the gate there are some key limitations to keep in mind:
The free version of the Excel for iPad app limits you to viewing documents onscreen. Any true functionality requires an Office 365 subscription, which for most users will run $99/year. Resist the urge to activate Excel for iPad within the app—sign up for the free 30 day trial online instead. Students can pay $79 for 4 years, or savvy searchers can purchase discounted Office 365 subscription keycards online through an online reseller.
Continue reading this article where it first appeared: www.accountingweb.com.
David H. Ringstrom, CPA heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at david@acctadv.com or follow him on Twitter. David speaks at conferences about Microsoft Excel, and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link
Apr 17
Step by Step
Steve and Joan Lambert have written a series of books titled Step by Step for Access 2013, Access 2010, and Access 2007.
Apr 11
Spreadsheet Check and Control
Patrick R O'Beirve created Spreadsheet Check and Control which helps users build better spreadsheets.