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

• 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

Microsoft Copilot Chat in Action

• What Is Microsoft Copilot Chat?
• The Magic Prompt Formula
• Work Smarter with AI