Back to Search

Excel - Functions and Formula Shootout Webinar

CPE

When
Aug. 3
12:00 - 2:00 p.m.

CPE Credits
2-Other

Details

 Pricing

PICPA Member: $79 | Nonmember: $104


 More Information

Course No.
CXOXLS201W2
Level
Intermediate
Prerequisites
Good understanding of Excel
Note
This webinar is hosted by PICPA's partner, CPA Crossings, LLC. After registering, you will receive an email from messenger@webex.com with the log-in information.

Description

Are you aware there are 470+ formula functions in Excel? Do you realize that they add new functions in every major version of Excel? Did you know that Microsoft adds new functions throughout the year in the Office 365 version of Excel? Are you stuck using old or simple functions like SUM or ROUND? Do you want to expand your knowledge of the extensive function library in Excel? If these questions peak your interest in becoming an Excel function expert, this course is right up your alley. This past-paced course digs into some of the most powerful functions in Excel. Although we cannot cover 470 functions, we will look at over 20 functions that will allow you to create advanced calculations in your spreadsheets. Some examples are: VLOOKUP, IF, IFS, FORECAST, RAND, SWITCH, TEXTJOIN, UNIQUE, SUBTOTAL, IS, TEXT and more! We will also provide example files that will include all the functions used during the class. It's time to take your Excel spreadsheets to the next level. This session is presented using Excel 2019/Office 365. Most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Learning Objectives:
After attending this presentation you will be able to...
  • Apply formula creation best practices when developing spreadsheets
  • Use Excel functions to create better calculations in your spreadsheets
  • Select Excel functions to create advanced calculations

Highlights

The major topics that will be covered in this class include:

  • Review of formula creation best practices
  • Demonstration of various Excel functions to enhance calculations
  • Using Excel functions to perform advanced calculations


Speaker(s)

Bryan L. Smith, CPA.CITP, CISA

Bryan is an author and top-rated presenter of numerous courses on technology related topics for CPAs. He also serves as virtual CIO advisor for CPA firms and professional service organizations. He focuses on helping firm leaders understand the issues and opportunities associated with deploying information technology to improve productivity and enhance client services and increase profitability.

Professional Experience and Credentials

  • Past Chair, MACPA Information Technology Task Force
  • Master of Science in Information Assurance
  • Past Member, AICPA CITP Credential Committee
  • Past Treasurer of the Microsoft Project Users Group (Detroit Chapter)
  • Past Chair, MACPA Leadership Task Force
  • Regional Director in charge of mid-market technology services for top 10 accounting firm
  • Executive Manager of top 100 firm serving as Regional Director of consulting and IT  audit services
  • Former Senior Manager of top 100 firm responsible for developing and leading IT consulting services group
  • Certified Information System Auditor (CISA)
  • Member of the Information System Audit and Control Association
  • Extensive experience in leading world class organizations through mission critical IT systems deployment

You May Also Like

Excel - Two Must Know Features: Defined Names & Tables Webinar
Aug. 12 | Webinar
Excel has over 500 functions and among those, Defined Names is one of the top choices in creating formulas that make your spreadsheets work better for you. After understanding what ...
Excel - Using Charts for a Non-Financial Audience Webinar
Aug. 12 | Webinar
This webinar will show you how to use Excel's charting and formatting features to present financial data to a non-financial audience. As the saying goes, "A picture is worth ...
Excel - Building Powerful Lookup & Reference Formulas Webinar
Aug. 18 | Webinar
Excel has over 500 functions that are built-in and ready to use. You just have to figure out which one to use and when. Integrating functions into each and every ...