Getting started with Excel. Getting started with spreadsheets ; Carrying out basic calculations ; Formatting cells and worksheets ; Organizing data and creating tables ; Navigating worksheets and workbooks
Working with formulas and functions. Tapping into formula and function fundamentals ; Saving time with function tools ; Building array formulas and functions ; Fixing errors in formulas
Goring farther with functions. Calculating loans, interest, and depreciation ; Performing functional math ; Working with date and time functions ; Manipulating text with functions
Analyzing data. Using basic data analysis techniques ; Working with data analysis tools ; Analyzing table data with functions
Summarizing, visualizing, and illustrating data. Creating charts ; Creating and using PivotTables ; Performing PivotTable calculations ; Building PivotCharts
Reporting and querying data. Introducing Power Pivot ; Advanced moves with PivotTables ; Working directly with internal data model ; Adding formulas to Power Pivot ; Meeting Power Query and its connection types
Creating dashboards and reports. Getting in the dashboard state of mind ; Building a super model ; Dressing up your data tables ; Formatting your way to visualizations ; Displaying performance against a target
Automating Excel with macros and VBA. Macro fundamentals ; Getting cozy with Visual Basic Editor ; The anatomy of macros ; Working with workbooks
