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.
Businesses, organizations, and individuals now have until March 17 to provide comments to the Public Company Accounting Oversight Board on its reproposed standard that would require public accounting firms to disclose the name of the engagement partner, as well as information about certain other audit participants, in the auditor’s report.
The Financial Accounting Standards Board (FASB) used the results of a recent survey of stakeholders as a guide for the reorganization of its future project agenda. The FASB also targeted several research projects that will be included in its prioritization initiative.
The American Institute of CPAs (AICPA) earlier this month released additional guidance, "Statement on Standards in Personal Financial Planning Services," that ensures the profession’s “rigorous code of professional conduct” applies to all CPA financial planners.
NFL players are well-paid, even the rookies. But the biggest winners this year – the Denver Broncos and the Seattle Seahawks – are playing in the Super Bowl this weekend. However, all of the Denver and Seattle players will owe the state of New Jersey taxes, thanks to the “jock tax.”
A new type of retirement account, "MyRA," which President Obama proposed during his 2014 State of the Union address on January 28 and authorized the creation of yesterday, is intended to encourage retirement savings by workers who currently aren’t participating in an employer-sponsored retirement plan.
A recent study by RAND Corporation revealed that when it comes to workplace wellness programs, there may be a distinct difference in the type of programs that reduce costs and lower net savings. However, many accounting firm leaders say their workplace wellness programs do not have costs or savings in mind. Instead, they are designed to keep employees engaged, healthy, and happy.
With just a few scant days until the official start of tax-filing season, the IRS approved a final draft of new Form 8960, "Net Investment Income Tax—Individuals, Estates, and Trusts." This form will be used to compute the new 3.8 percent Medicare surtax on net investment income on 2013 federal income tax returns.
The Financial Accounting Foundation could contribute as much as $3 million this year to the International Financial Reporting Standards (IFRS) Foundation in support of several convergence projects that the Financial Accounting Standards Board and the International Accounting Standards Board are working to complete.
Password was a popular TV show back in the day, in which TV personalities teamed up with regular Joes and competed for prizes based on giving one-word “passwords” to their teammates to guess the “Password” that only the studio audience and TV viewers saw.
In the newest installment of his series, CPA Larry Perry looks at how lease accounting and income tax accounting differ within US GAAP and the American Institute of CPAs "Framework for Small- and Medium-Sized Entities."
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.