The importance of Defined Names and Excel Tables is detailed in this course. This course is designed to demonstrate how you can use these features to build better spreadsheets that are easier to read, easier to update and more accurate. Learn about the INDIRECT function and how to use it with Defined Names to build a summary table. You will also learn the importance of Consistent Column Calculations and how tables can help. We will demonstrate the use of Structured Table References, as this is the foundation for using the advanced data analytics. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.
Using the INDIRECT function with Defined Names. The importance of consistent column calculations. Ways to create consistent column calculations. Using structured table references in formulas.
Familiarity with defined names and tables in Excel.
Anyone who wants to take their Excel skills to the next level.
Use the INDIRECT function and Defined Names to build a summary table. Determine the importance of having consistent column calculations. Use Excel Tables to build consistent column calculations. Build formulas that use structured table references.
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 $99.00
Member Price $79.00