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.
Created for the 2014-15 academic year, the American Institute of CPAs Foundation Two-Year Transfer Scholarship provides $1,000 to recipients who have earned an associate’s degree in business, accounting, finance, or economics and declared their intent to major in accounting at a four-year college or university.
A team of accounting students from the University of Portland turned into personal financial planners – and devised an award-winning plan to help a fictional young entrepreneur take control of his finances and pay off his debt.
The undergraduate accounting programs at Michigan State University and Brigham Young University received the endorsement of the Institute of Management Accountants (IMA) as higher education programs that provide management accounting curriculum and skills for students.
A new year beckons and I harken back to when my daughter was four years old. Her mother and I bought her an old, upright piano. It was a little beat up, a little banged up, and was missing a few keys, but hey, for a 4-year old, it was fine.
Just days before his retirement from the MSCPA, AccountingWEB sat down with Theodore J. Flynn to discuss the major changes that have impacted the profession over the last four decades, the current state of the CPA industry, and where things are headed in the future.
For the last few years, in many of my presentations to the CPA profession, I have been warning firm leaders that they need to be prepared for involving the parents of new college graduates as they participate in the college recruiting adventure.
In today's increasingly litigious society, there's certainly no shortage of lawsuits or the lawyers needed to negotiate those proceedings. There's a new player emerging as an indispensable part of many attorneys' legal teams: the forensic accountant.
America's business community has instituted many wonderful programs to help veterans transition from the military to the corporate world. Deloitte officials say they're proud to add their own innovative CORE Program to the mix.
The days of listening to stodgy diatribes about technical accounting standards are over, or at least they should be, according to Tom Hood, executive director and CEO of the Maryland Association of CPAs and the Business Learning Institute.
Reflection is something I do a lot of – I have for many years quite regularly in my daily or weekly goings on. At certain holiday times and other milestones every year, I reflect on my year and perspectives at that snapshot in time.
Tammie Schaefer, CPA, is just one of the twelve "newly minted" PhDs, and the first wave of ADS Program graduates, who are currently teaching their first classes this fall semester on college campuses across the country.
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.