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.
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.
Good understanding of Excel
Upon completing this course, you will: Design spreadsheets with greater efficiency and accuracy, Understand how to use advanced Excel functionsUse auditing techniques to build more accurate spreadsheets, Use advanced analytical tools to summarize detailed data, Make your spreadsheets more professional in appearance.
Bryan L. Smith, CPA, CITP, CISA is the co-founder of CPA Crossings in Rochester, MI. He is a CPA with a strong background in information technology and serves as a virtual CIO to CPA firms and professional organizations. He specializes in the planning and deployment of effective technology solutions. Bryan and John Higgins recently authored Ten Steps to a Digital Practice in the Cloud, which has been published by the AICPA.
Bryan helps firm leaders understand the opportunities associated with deploying information technology to improve productivity, enhance client services, and increase profitability. He uses his extensive knowledge and experience to help CPAs bridge the gap between business and technology.
He is a past chair of the Michigan Association of CPAs Information Technology Committee and the Leadership Committee.
Non-Member Price $299.00
Member Price $199.00