Microsoft Excel 365: External Data & Workbook Tools

Course Overview

External Data & Workbook Tools: Learn Excel 365 gives you the skills to efficiently manage data across multiple workbooks and connect to diverse external sources. You will learn how to link worksheets, create dynamic updates, and keep information accurate without repetitive manual work.

You’ll discover how to use Excel’s Watch Window to track important cells in large datasets, saving time and reducing scrolling. The lessons also show you how to customize the Excel Ribbon, creating tabs and groups that fit your workflow. You will connect to external data sources such as other Excel files, Access databases, and web data, enabling real-time updates and consistent information across your projects.

This learning experience shows you how to clean, format, and organize data using advanced table features, structured references, and custom styles. These tools will help you present data more clearly and perform analysis more easily.

By the end, you’ll be able to streamline processes, improve data accuracy, and boost productivity. With these practical skills, you can manage complex datasets with more control, efficiency, and confidence in Excel 365.

Learning Objectives:

In this course, you will learn how to:

• Link and synchronize data between Excel workbooks.
• Use Excel's Watch Window to monitor cell changes.
• Customize the Excel Ribbon for improved workflow.
• Connect Excel to external data sources for live updates.
• Import and manage external data using Power Query.
• Import Access database tables into Excel.
• Import data from web sources into Excel using Power Query.
• Apply structured references in Excel tables