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.
Learning 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
Major Topics
• Collaboration and security techniques
• Tables, data models, and PivotTables
• Advanced formulas
• Data queries
• Creating effective visualizations