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 introduces 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.
Predominantly, when I meet with new firms and go over the Cloud accounting services opportunity, the first thing they want to do is start putting together a marketing plan. Most firms quickly find they're lost when they start this way.