Excel for Advanced Users

- Excel options and settings - Tips and tricks for working with data and formulas: AutoFill, data validation, named ranges, AutoComplete formulas, deduplication - Arranging data on screen: Freezing rows and columns, split window - Formatting and layout: Table style templates, cell style templates, custom number formats, conditional formatting, creating and using style templates - Arranging and grouping data - Protecting cells, worksheets and workbooks - Create use and change Excel templates - What-if analyses: goal seek, scenario manager