Microsoft Office & 365 Apps
Excel Part 3 - Advanced Excel
Advanced Excel in one day.
1 dayAdvanced7 modules
About this course
Advanced Excel in one day. You will manage multiple worksheets and workbooks, collaborate and protect files, automate with macros, master lookup functions and use forecasting tools.
What you'll learn
- Work with multiple worksheets and workbooks.
- Share and protect workbooks to ensure secure collaboration.
- Automate workbook functionality with macros and advanced tools.
- Use Lookup functions and perform formula auditing to troubleshoot and enhance spreadsheets.
- Forecast and analyze data trends.
- Create Sparklines and map data for dynamic, visual reporting.
Curriculum
7 modules
- Create links between workbooks and use external references
- Work with 3-D references across worksheets
- Combine and consolidate data from multiple sources
- Co-author workbooks and manage collaboration features
- Protect worksheet content and control access permissions
- Set up data validation rules to control user input
- Find and fix invalid data and formula errors
- Automate repetitive actions with recorded macros
- Use advanced Lookup functions to retrieve data
- Trace cell relationships and troubleshoot formulas
- Monitor calculations with the Watch Window and Evaluate Formulas
- Explore scenarios for strategic decision-making
- Apply the Goal Seek tool to backtrack solutions
- Build simple forecasts based on historical data
- Summarize trends with Sparklines inside cells
- What Is Microsoft Copilot Chat?
- The Magic Prompt Formula
- Work Smarter with AI
Who it's for
Experienced Excel users who want to automate, audit formulas and forecast.
Before you start
- Students should have completed Microsoft Excel - Part 1 (Introduction) and Microsoft Excel - Part 2 (Intermediate) , or have equivalent knowledge and experience. You should be comfortable entering and formatting data, creating basic formulas, using functions like SUM and IF, and working with simple PivotTables and charts.
Related courses
More in Microsoft Office & 365 Apps →Intermediate
Excel - Formulas & Charts
Microsoft Office & 365 Apps
View course →Foundation
Excel Part 1: Excel for Beginners
Microsoft Office & 365 Apps
View course →Intermediate
Excel Part 2 - Excel Intermediate
Microsoft Office & 365 Apps
View course →Advanced
55205 Mastering Microsoft Project 2016
Microsoft Office & 365 Apps
View course →Intermediate
55234 SharePoint 2016 Site Collections and Site Owner Administration
Microsoft Office & 365 Apps
View course →Intermediate
55238 SharePoint Online for Administrators
Microsoft Office & 365 Apps
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.