A new accounting game launched this month by the American Institute of CPAs, Bank On It, challenges high school students on accounting fundamentals and real-world workplace scenarios in the context of an online board game.
Building complex spreadsheets without lookup formulas, such as VLOOKUP, is akin to putting a screw in the wall with a hammer. It’s possible, but the results aren’t pretty, and most probably won’t maintain integrity.
The noise about using social media as a means to grow your business has become so constant it almost blends into the background at this point. With Facebook, Twitter, and LinkedIn pushing their advertising platforms and Google+ touting better search optimization, it’s inescapable.
David Ringstrom shares three of the best Excel-related questions he received during a question-and-answer session after a recent AccountingWEB webinar he conducted, "High Impact Excel: Pivot Table Edition."
The web-based application, launched last week by the founders of the Ohio-based online accounting firm Upsourced Accounting, efficiently collects and manages information for professional service organizations.
In this session Excel expert David Ringstrom will introduce beginners to the VLOOKUP function, and then go beyond the basics with a discussion of with the MATCH, CHOOSE, INDEX, SUMIF, SUMIFS, and SUMPRODUCT functions.
Although the IRS is still madly preparing for the 2013 filing season, one man remains ahead of the curve. Glenn Reeves has released his seventeenth spreadsheet-based version of the US Individual Income Tax Return, commonly known as Form 1040, which taxpayers can download and use for free.
The American Institute of CPAs has unveiled a new version of its Total Tax Insights calculator just before the start of income tax-filing season. The calculator, which can help taxpayers gauge the impact of twenty different taxes, reflects data applicable in 2013.
It’s a new year, which brings the promise of fresh starts, and resolutions to work smarter. Keyboard shortcuts are one of the best ways to both save time and reduce wear and tear on your wrists when working in Microsoft Excel.
What do accountants count on most to do their jobs well? Yes, coffee is a good answer. No, I'm not thinking of booze. If you eliminate any and all kinds of medicating, the smart money is on Microsoft Excel.
Spending time on social networks appears to be normal behavior at most workplaces. Employers need to deal with its risks and minimize its costs. Employees should consider the potential ramifications of every post they make.
Following up on the success of his popular High Impact Excel session, this time around David H. Ringstrom, CPA turns his attention to pivot tables. In one hour you'll learn how to whip unwieldy data into shape, and then quickly build meaningful reports by dragging and dropping with your mouse. David will also discuss techniques for improving pivot table data integrity. Detailed handouts with numbered steps will be provided for a variety of Excel versions.