Back to Search

Excel Bootcamp - Building Great Spreadsheets Webinar

CPE

When
April 8
9:00 a.m. - 5:00 p.m.

CPE Credits
8-Other

Details

 Pricing

PICPA Member: $199 | Nonmember: $299


 More Information

Course No.
CXEXCL015W8
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

Whether you are relatively new to the accounting industry or have been around for a number of years, there is a good chance that you are developing your Excel spreadsheets the hard way and leaving them susceptible to errors and omissions of important data. This course is designed to teach you the fundamentals of good spreadsheet design that will increase your accuracy and efficiency when creating Excel spreadsheets. You will also learn how to perform powerful data analysis using Excel. It will be well worth attending this course because of all the time it will save you in building your spreadsheets and analyzing your data. This is a fast-paced course that is sure to provide valuable knowledge to EVERY Excel user. 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:

Upon completing this course, you will …

  • Design spreadsheets with greater efficiency and accuracy
  • Understand how to use advanced Excel functions
  • Use auditing techniques to build more accurate spreadsheets
  • Use advanced analytical tools to summarize detailed data
  • Make your spreadsheets more professional in appearance

Highlights

The key topics that will be covered in this course include:

  • Building your spreadsheets for maximum efficiency and accuracy
  • The most popular functions and formulas
  • How to audit your spreadsheets to detect errors in formula logic
  • How to analyze your data with PivotTables and Excel's Power BI Tools
  • Tools for presenting your spreadsheets in a meaningful way


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

Roadmap to Becoming an Excel Expert Webinar
April 15 | Webinar
Most Excel users do not take advantage of all that Excel has to offer and use only a fraction of Excel's functionality. It is often difficult and time-consuming to learn ...
Excel - Using Charts for a Non-Financial Audience Webinar
April 16 | 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
April 20 | 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 ...