This course runs for a duration of 1 Day.
The class will run daily from 8 AM CT to 4 PM CT.
Class Location: Virtual LIVE Instructor Led - Virtual Live Classroom.
Ready to take your spreadsheet skills to the next level? This Advanced Excel Training course is designed for professionals who want to work smarter—not harder—with Microsoft Excel. You’ll build upon the foundational and intermediate knowledge from Microsoft Excel – Part 1 and Microsoft Excel – Part 2, helping you get the most out of your Excel experience.
Learn to collaborate more effectively with colleagues, automate complex or repetitive tasks, and use conditional logic to create powerful formulas and functions. The more you master Excel’s advanced tools, the more you can shift your focus from manual work to extracting the insights your organization needs from its vast amounts of data. From building dynamic dashboards to forecasting trends, this course unlocks the full potential of Excel at your fingertips.
Upon successful completion of this course, you will be able to:
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.
Audience
Advanced Excel Training is ideal for business professionals, analysts, project managers, accountants, and anyone who needs to perform high-level data analysis, reporting, or spreadsheet management tasks. If you already use Excel regularly and are ready to deepen your capabilities, this course is for you.
Managing Multiple Worksheets and Workbooks
Create links between workbooks and use external references
Work with 3-D references across worksheets
Combine and consolidate data from multiple sources
Collaborating and Securing Your Workbooks
Co-author workbooks and manage collaboration features
Protect worksheet content and control access permissions
Streamlining Tasks with Automation
Set up data validation rules to control user input
Find and fix invalid data and formula errors
Automate repetitive actions with recorded macros
Mastering Lookup Functions and Formula Auditing
Use advanced Lookup functions to retrieve data
Trace cell relationships and troubleshoot formulas
Monitor calculations with the Watch Window and Evaluate Formulas
Predicting and Forecasting Data Trends
Analyze possible outcomes using data tables
Explore scenarios for strategic decision-making
Apply the Goal Seek tool to backtrack solutions
Build simple forecasts based on historical data
Visualizing Data with Sparklines and Maps
Summarize trends with Sparklines inside cells
Create basic geographic maps to display data visually
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.
