Excel: Top 10 Functions for Accountants

Learning objectives

After completing this course, the learner should be able to: 

  • Review lookup functions (VLOOKUP, XLOOKUP, MATCH, INDEX)
  • Review if functions (IF, IFS)
  • Review conditional math functions (COUNTIF, SUMIF, SUMPRODUCT)
  • Review PivotTables (GETPIVOTDATA)
  • Review use of formatting and conditional formatting
Get access to hundreds of courses like this with a CPE subscription
Mike Brown Headshot

Instructor bio

Michael (“Mike”) Brown’s extensive experience confirms his presence as a leader in the accounting community—with a commitment for student success and a passion for teaching. For over 15 years, Mike has been a senior national instructor with Becker Professional Education. He has impacted hundreds of thousands of individual students—just since 2019—in Becker’s CPA and CMA Review courses and so many more through his presentations at conferences, accounting firms, universities, and in the online community. Mike’s teaching is enhanced by his vast accounting experience in many industries, including manufacturing, financial, retail, real estate and service. With Becker's CPA Review course, Mike is heavily involved in the concept lecture videos in four sections: AUD, FAR, BAR, and ISC. After completing a term on the Beta Alpha Psi Board of Directors in 2021, he now serves as Becker's Professional Partner to the organization. He is a licensed CPA in the State of North Carolina, currently residing in Raleigh with his wife and two children.

Education

  • University of Virginia 
    • BS Commerce (Accounting and MIS concentrated)
  • University of Science 
    • MS Accounting (Audit concentrated)

Licenses & designations

  • CPA
  • CMA
  • CIA
  • CSCA
  • CGMA

Teaching & instruction

Organizations

Podcasts

Awards & recognition 

  • Becker Senior Faculty Award
  • Professional Education Award (2017)
  • Adtalem Global Education TEACH Award (2019)

What do you love about Becker?

"I love that Becker never accepts that what we have is good enough and is always willing to challenge the status quo in an effort to improve. I love the scale of the impact we are able to have both in terms of the number of students we can reach and the impact of the profession as a whole. I love that it gives me the opportunity to do what I love!"

What would you tell an accounting student today?

"The possibilities for a career in accounting are truly limitless - even if you could list all the opportunities available today, the list would be out of date by tomorrow. Never forget, that first and foremost, accounting is a people business - as long as you cultivate your ability to connect with others, you will have opportunities to succeed!"

Becker fun fact

"I've visited 48 of the 50 states (just Alaska and North Dakota left to go!). I love playing board games - in fact, I have a whole room of my house devoted to my board game collection."

Connect

 

National Registry of CPE Sponsors

A Becker Professional Education is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

Becker Professional Education Sponsor I.D. Numbers NASBA: 107294, New York: 002087, New Jersey: 20CE00226700, Texas: 009580, Ohio: CPE.186, Illinois 158.002405, Pennsylvania: PX177823

Now Leaving Becker.com

You are leaving the Becker.com website. Once you click “continue,” you will be brought to a third-party website. Please be aware, the privacy policy may differ on the third-party website. Adtalem Global Education is not responsible for the security, contents and accuracy of any information provided on the third-party website. Note that the website may still be a third-party website even the format is similar to the Becker.com website.

Continue