Building Useful Excel Templates

Foundational Data: Tables, Data Validation, and Power Query

When building a workbook, there are layers of aesthetics and organization, as well as prebuilt resources, that can set up the busy professional for success. In this session, we take your construction efforts to the next level by adding polish and structure to templated files.

Topics include:

• Defining workbook structure and building workbook resources
• Controlling visibility and editability within a workbook
• Developing queries and dataflows
• Using best practices for workbook formatting

Power Query, absolute and relative references, and experience creating Excel functions

Introduction to formulas and functions (linkedin.com)