MSO201.KZ1 ISBN: 979-8-90059-176-6
Advanced Excel: Formulas, Functions & Automation
Master professional data analysis, complex formula auditing, and workflow automation with this comprehensive, hands-on Advanced Excel certification course.
What you will be able to do
- Formula Auditing: Mastery of troubleshooting complex nested functions and identifying logical errors in large-scale financial models.
- Dynamic Data Modeling: Proficiency in utilizing XLOOKUP, dynamic arrays, and LET functions to create responsive, high-performance business dashboards.
- Workflow Automation: Ability to record, edit, and secure VBA macros while integrating Microsoft Copilot for advanced predictive data analysis.
- Data Governance: Expertise in workbook security, version control, and accessibility standards to ensure enterprise-grade data integrity and compliance.
Intermediate A tu propio ritmo · 1 año de acceso
31 LiveLabs prácticos
Practice real IT tasks in guided environments.
- Entornos reales
- Calificación automática
- Sin instalación
01 / About
Acerca de este curso
Try Free →
No se requiere tarjeta de crédito
Stop relying on basic spreadsheets. This Advanced Excel: Formulas, Functions & Automation course forces you to build robust, scalable business solutions. You will move beyond simple lookups to master dynamic arrays, LET functions, and complex PivotTable modeling. We prioritize technical precision, teaching you how to audit formulas, sanitize messy datasets, and implement responsible AI via Microsoft Copilot. With 12 hands-on labs and 90 quizzes, you gain practical experience, not just theory. Be warned: this curriculum demands rigorous attention to detail. You will face real-world constraints, including data governance limitations and macro security risks, ensuring you emerge as a highly capable, security-conscious Excel power user.
02 / Lecciones y laboratorios
See exactly what you will learn and practice
Plan de estudios
10 Lecciones interactivas · 57 topics01 Preface +
02 Advanced Formula Fundamentals and Integrity 6 topics · 21 Laboratorio en vivo +
- Reviewing Advanced Formula Foundations
- Working with Named Ranges and Named Formulas
- Using Formula Auditing Tools
- Troubleshooting Formula Errors
- Applying Formula Best Practices
- Summary
21 Laboratorio en vivo in this lesson — see the labs panel →
03 Advanced Functions for Business Calculations 6 topics · 1 Laboratorio en vivo +
- Using Logical Functions
- Working with Lookup Functions
- Using INDEX, MATCH, and XMATCH
- Working with Text Functions
- Combining Functions to Solve Business Problems
- Summary
1 Laboratorio en vivo in this lesson — see the labs panel →
04 Modern Excel Functions and Dynamic Arrays 6 topics · 1 Laboratorio en vivo +
- Using Date and Time Functions
- Applying Statistical Functions
- Using Conditional Functions
- Working with Dynamic Array Functions
- Using LET and SWITCH for Efficient Formulas
- Summary
1 Laboratorio en vivo in this lesson — see the labs panel →
05 Advanced Data Management & Sanitation 6 topics · 1 Laboratorio en vivo +
- Creating and Managing Excel Tables
- Advanced Sorting and Filtering
- Applying Advanced Data Validation Rules
- Cleaning and Preparing Data
- Consolidating Data from Multiple Sources
- Summary
1 Laboratorio en vivo in this lesson — see the labs panel →
06 Advanced Data Analysis and Trends 7 topics · 1 Laboratorio en vivo +
- Creating and Customizing PivotTables
- Building PivotCharts
- Using Slicers and Timelines
- Applying Conditional Formatting for Analysis
- Using What-If Analysis Tools
- Interpreting Business Data Ethically
- Summary
1 Laboratorio en vivo in this lesson — see the labs panel →
07 Visual Analytics and Accessible Dashboards 7 topics · 2 Laboratorio en vivo +
- Creating Advanced Charts
- Using Sparklines and KPI Indicators
- Selecting Effective and Ethical Visualizations
- Designing Interactive Excel Dashboards
- Applying Accessibility and UDL Principles
- Presenting Business Insights Effectively
- Summary
2 Laboratorio en vivo in this lesson — see the labs panel →
08 Automation, Productivity, and Responsible AI 7 topics · 2 Laboratorio en vivo +
- Planning Automation and Productivity Workflows
- Recording and Running Basic Macros
- Editing Macro Settings and Managing Macro Security
- Using Microsoft Copilot in Excel for Advanced Analysis
- Applying Responsible AI and Digital Citizenship
- Automating Repetitive Business Tasks
- Summary
2 Laboratorio en vivo in this lesson — see the labs panel →
09 Collaboration, Governance, and Security 6 topics · 2 Laboratorio en vivo +
- Sharing and Co-Authoring Workbooks
- Protecting Worksheets, Workbooks, and Formulas
- Managing Workbook Versions, Links, and References
- Inspecting Workbooks and Using Accessibility Features
- Applying Workbook Security and Governance Best Practices
- Summary
2 Laboratorio en vivo in this lesson — see the labs panel →
10 Advanced Excel for Business Solutions and Capstone 6 topics · 1 Laboratorio en vivo +
- Building Financial and Budgeting Models
- Analyzing Sales, Inventory, and Performance Data
- Developing Interactive Business Reports and Dashboards
- Solving Real-World Business Case Studies
- Final Capstone: Advanced Excel Business Solution
- Summary
1 Laboratorio en vivo in this lesson — see the labs panel →
Laboratorios prácticos Our edge
31 Laboratorio en vivos- Validating Leave Entry Data
- Analyzing Attendance and Absence Trends with PivotTables and PivotCharts
- Analyzing Attendance Risks and Forecasting Leave Usage
- Creating Attendance Charts and KPI Indicators
- Visualizing Monthly Attendance with Sparklines
- Recording and Running an Attendance Macro
- Protecting Attendance Data and Checking Workbook Accessibility
- Protecting Attendance Data and Checking Workbook Accessibility
- Filtering and Sorting Employees for HR Review
- Building Efficient Attendance Formulas with LET and SWITCH
- Generating Attendance Summaries with Dynamic Arrays
- Analyzing Attendance Trends with Statistical Functions
- Calculating Employee Service and Leave Periods
- Extracting and Standardizing Employee Information
- Matching Employees Across HR Records
- Retrieving Employee Details with Lookup Functions
- Classifying Attendance with Logical and Conditional Functions
- Creating and Auditing Leave-Balance Formulas
- Restoring Integrity to Financial Models
- Setting Up and Organizing the BrightNest Attendance Workbook
- Protecting and Improving Accessibility of the Library Workbook
- Mastering Systematic Formula Debugging
- Resolving Dynamic Array Spill Obstructions
- Defending Advanced Data Filtering Logic
- Defending Analytical Integrity Under Fire
- Selecting Appropriate Excel Charts
- Defending the Visual Dashboard Strategy
- Defending AI-Generated Financial Logic
- Protecting Data Privacy
- Securing High-Stakes Financial Data
- Securing Data Access
- Defending Financial Model Integrity
Los laboratorios se ejecutan en tu navegador; no hay nada que instalar.
03 / Preguntas frecuentes
Preguntas antes de empezar
Is Advanced Excel certification worth it for career growth?+
Yes, if you move beyond basic skills. Employers prioritize candidates who can automate workflows and build secure, audit-ready financial models.
Does this course cover Microsoft Copilot integration?+
Yes, the curriculum includes dedicated modules on using Microsoft Copilot for advanced analysis and applying responsible AI principles in business.
Can I learn dynamic arrays and XLOOKUP here?+
Absolutely. We focus heavily on modern Excel functions, including dynamic arrays, LET, and SWITCH, which are essential for modern data management.
Keep going
You might also like
Master Advanced Excel Skills
Build expertise in advanced formulas, data modeling, and workflow automation to streamline business processes and improve data accuracy.
- 1 año de acceso completo
- 31 LiveLab incluido
- Certificado de finalización
No se requiere tarjeta de crédito