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.
The IRS is piloting a program that would allow employees access to work e-mail and other services on their personal smartphones, but according TIGTA, the IRS program should be cost effective and a full cost-benefit analysis is needed.
In this exciting presentation Excel expert David H. Ringstrom, CPA shares dozens of tricks that he uses to fly through Excel every day. Remember, either you work Excel, or it works you!
This webcast is sponsored by SurePayroll.
Accounting firms have until the end of the month to participate in the First Annual Accounting Firm Operations and Technology Survey, which gauges what types of technology accounting professionals are using in their practices.