
External Data and Workbook Tools: Learn Excel 365
Manage external data, link workbooks, and customize Excel 365 for efficient, accurate, and real-time updates.
External Data and Workbook Tools: Learn Excel 365
External Data & Workbook Tools: Learn Excel 365 gives you the skills to manage and analyze data with greater accuracy, efficiency, and control. You will learn to link and synchronize information across multiple worksheets and workbooks, ensuring updates happen automatically and reducing the need for manual data entry.
You’ll explore the Watch Window, a powerful tool for monitoring important cells and ranges in large spreadsheets without constantly scrolling. The course also shows you how to customize the Excel Ribbon, creating personalized tabs and groups that fit your workflow for faster navigation.
You will connect to external data sources such as other Excel files, Access databases, and web pages, using Power Query to import, clean, and transform data. Live connections keep your information current, helping you work with accurate and up-to-date datasets.
In addition, you’ll gain advanced skills with Excel tables, including filtering, sorting, structured references, and custom styles to improve analysis and presentation. These techniques will help you easily organize data and extract meaningful insights quickly.
Whether you manage large spreadsheets, collaborate with colleagues, or prepare reports for decision-makers, the practical skills in this course will streamline your workflow, improve data accuracy, and boost productivity. With these tools, you can confidently manage complex datasets and enhance your effectiveness as a data-driven professional in Excel 365.
In this course, you will learn how to:
- Create dynamic Excel workbook data links.
- Master Excel's Watch Window for cell change monitoring.
- Customize the Excel Ribbon for enhanced productivity.
- Import and manage live external data connections in Excel.
- Cleanse and transform data with Power Query Editor.
- Import Access database tables into Excel spreadsheets.
- Import web data into Excel using Power Query.
- Efficiently manage Excel data using tables.
- Filter, sort, and calculate data within Excel tables.
- Utilize structured references in Excel tables
for formulas.
Course Format
- This is a video-led course. You can preview some videos below.
- This course includes practice exercises.
- This course is aimed at PC Excel users.
Course Certificate Included
This course includes an optional online quiz that will generate a course certificate upon completion.
14-Day Guarantee
We offer an unconditional, 14-day, full money-back guarantee, no questions asked. This is our way of ensuring you have complete confidence in your Stream Skill purchase. If you don’t learn, you don’t pay.
Why Trust Us?
Stream Skill is part of the Simon Sez IT family and has been in business 14+ years and taught over 1 million students in that time. We’ve created over 130 software training courses, 8,000+ video tutorials, and we’ve helped thousands of people across the world learn how to use Microsoft Office. We’ve now created Microsoft Excel courses for the last five versions and continue to help people get to grips with this essential tool.
Your Instructor

Course Curriculum
-
Free PreviewCourse Introduction (1:41)
-
StartDOWNLOAD ME: Course Files
-
StartDOWNLOAD ME: Exercise Files
-
Free PreviewConnecting to Other Excel Workbooks (6:59)
-
StartConnecting an Excel Workbook to an Access Database (2:35)
-
StartRetrieving Data from Web Sources (4:24)
-
StartConnecting to External Data Exercise (1:19)
-
StartWorking with Links (5:18)
-
StartUsing the Watch Window (3:32)
-
StartCustomizing the Ribbon (5:22)
-
StartCreating and Customizing Table Styles (4:05)
-
StartWorking with Tables (15:00)
-
StartCourse Conclusion (1:20)