K2's Advanced Excel 26-27

If you're ready to move beyond Excel's fundamental features, participate in K2's Advanced Excel. This course will teach you about collaboration options, security techniques, tables, data models, PivotTables, and advanced formulas.

Objectives

• 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

Highlights

• Collaboration and security techniques
• Tables, data models, and PivotTables
• Advanced formulas
• Data queries
• Creating effective visualizations

Credits