This workshop will deepen your expertise in Excel 2016 by exploring advanced workbook options and settings, custom data formats, and layouts. You’ll learn how to save workbooks as templates complete with colors, fonts, and themes, and how to reference data both within and across workbooks. Participants will master workbook protection, internationalization preparation, and apply advanced conditional formatting and filtering. Additional skills include using form controls, working with macros, defining named ranges, applying complex functions, performing data transformations, troubleshooting formulas, creating advanced charts, and managing PivotTables for powerful data analysis.