Excel in Microsoft Excel 2: Intermediate to Expert advanced

Overview

This course series has been recorded on Excel 2016 and Excel 2010 for the PC, but the content also covers Excel 2013 and 2019.

Syllabus

• Review of Basic Excel Functions
Recap of Formulas and Functions
Navigating Worksheets and Workbooks
Basic Data Formatting and Organization
• Advanced Formula and Function Techniques
Nested Functions
Array Formulas
Use of LOOKUP Functions (VLOOKUP, HLOOKUP, and XLOOKUP)
Error Handling in Formulas
• Data Management and Validation
Importing and Cleaning Data
Data Validation Techniques
Consolidating Data from Multiple Sources
Using Data Forms for Efficient Data Entry
• Advanced Charting and Visualizations
Creating Dynamic and Interactive Charts
Advanced Chart Types (Surface, Radar, Bubble)
Customizing Chart Elements
Conditional Formatting
• PivotTables and PivotCharts
Constructing and Customizing PivotTables
Using Slicers and Timelines
Designing and Analyzing PivotCharts
Calculated Fields and Items in PivotTables
• Advanced Data Analysis
Scenario Analysis and Data Tables
Goal Seek and Solver
Statistical Functions and Analysis ToolPak
Collecting and Analyzing Data in Tables
• Macros and Automation
Introduction to Macros and Recording Macros
Editing Macros with VBA Basics
Automating Tasks and Workflows
Debugging and Error Handling in Macros
• Collaboration and Workbook Security
Sharing and Merging Workbooks
Tracking Changes and Co-Authoring
Protecting Workbooks, Worksheets, and Cells
Data Encryption and Password Protection
• Integration and External Data Connectivity
Connecting to External Data Sources
Using Power Query for Data Transformation
Integrating Excel with Other Office 365 Applications
• Final Project
Applying Advanced Excel Techniques to Solve Real-World Problems
Creating Comprehensive Reports and Dashboards
Peer Review and Feedback Sessions

Taught by

Phillip Burton • 800,000+ students so far and I Do Data Limited

Subjects

Business