Formulate the best techniques to secure Excel data and collaborate with others efficiently

Evaluate the usefulness of tables and take advantage of their advanced features, such as dynamic data ranges, structured reference formulas, and the ability to relate multiple tables together into a Data Model

Assess Power Query’s capability to link and transform data from external data sources into Excel

Formulate calculations that reference functions such as XLOOKUP, GROUPBY, PIVOTBY and others

Evaluate worksheet data using techniques such as Data Tables, Subtotals, Slicers, Filters, and PivotTables

Assess techniques used to create, manipulate, and customize charts for analyzing and communicating information