Your cart is empty.
Keep shopping
External Data and Workbook Tools: Learn Excel 365
2 students
External Data and Workbook Tools: Learn Excel 365
Manage external data, link workbooks, and customize Excel 365 for efficient, accurate, and real-time updates.
Created bySimon Sez IT
Last updated 8/2025
English
What you'll learn
- Establish and maintain dynamic data links between workbooks.
- Add, manage, and utilize the Watch Window for data monitoring.
- Create custom Excel Ribbon tabs and groups with personalized commands.
- Import data from external sources and maintain live data connections.
- Clean and transform external data using Power Query Editor.
- Import data from Access databases and manage connection properties.
- Import and clean web-based data using Power Query's functions.
- Convert data ranges into Excel tables and apply table styles.
- Use Excel tables to filter, sort, and calculate data efficiently.
- Apply structured references within Excel tables for formulas.
- Utilize Excel tables' total row feature for automatic calculations.
- Create and apply custom table styles to enhance data presentation.
Explore related topics
Course content
2 sections • 14 lectures • 54m total length
Requirements
- Basic Excel knowledge.
- Access to Microsoft Excel 365.
- Basic computer literacy.
- A computer with internet access.
Description
This course includes downloadable course instructor and exercise files to work with and follow.
External Data and Workbook Tools: Learn Excel 365 equips you with the skills to manage data efficiently across multiple worksheets, workbooks, and external sources. You will learn to link and synchronize data to stay accurate, dynamic, and consistent without repetitive manual updates.
You’ll start by setting up your Excel environment for maximum productivity, including customizing the Ribbon with tabs and groups tailored to your workflow. You will practice creating links between cells in the same workbook, across different workbooks, and to external sources such as other Excel files, Access databases, and web data.
The course also covers importing data using Power Query, cleaning and transforming it, and establishing live connections for real-time updates. You will explore tools like the Watch Window, which lets you monitor key data points in large datasets without endless scrolling, and learn strategies to ensure your connections remain secure and dependable.
You will also work with Excel tables to improve organization, formatting, and analysis. This includes applying structured references for efficient formulas, using filters and slicers for interactive insights, and creating custom table styles to match your needs.
By the end, you’ll be able to manage complex datasets with more speed, accuracy, and flexibility. These skills will save you time, reduce errors, and help you make confident decisions based on up-to-date information in Excel 365.
This course includes:
54 minutes of video tutorials
11 individual video lectures
Course and Exercise Files to follow along
Certificate of completion
Who this course is for:
- Business professionals who work with multiple reports and need accurate, real-time updates across workbooks.
- Data analysts and researchers who need to import, clean, and transform large datasets from different sources.
- Project managers and administrators who regularly track information across several files and want to reduce manual updates.
- Students and learners who want to strengthen their Excel skills for academic or career growth.
- Finance and accounting staff who depend on linked workbooks and tables to keep financial data consistent and reliable.