Information
Please visit our international page to see all the numbers matching your region.
Flat rate
$19 per month
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.
In this course, you’ll 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.
The learning content is designed for anyone who wants to gain SAP knowledge in a simple, compact, and practical way. Our learning platform offers content for beginners, advanced learners, and experts. This enables you to expand your knowledge step by step and continuously develop your skills toward becoming an SAP expert.
Our products—whether books, videos, or online training—deliver SAP knowledge concisely and practically, so you can apply it directly in your daily work, even if you have limited time. You benefit from a broad coverage of relevant SAP topics, high-quality content in four languages, and learning formats designed to fit your individual needs. This ensures that you can stay up to date and continuously develop your expertise.
Our books are characterized by a clear practical focus and a compact, easy-to-understand presentation. We explain complex SAP topics concisely—without unnecessary marketing buzzwords—so readers can quickly grasp the essentials and apply the new knowledge directly.
Our print books can be returned within 14 days, in original condition. Return shipping is at your own cost.
We currently only ship books directly within Germany. If you are ordering from outside Germany, we recommend purchasing via Amazon. You can find the link by selecting “Buy eBook” on any product in our webshop and Amazon will then show you both the eBook and print versions available for purchase.
Alternatively, you can access all our content with a digital subscription, starting at $19 per month.
Our team is always happy to help and will respond to your questions as quickly as possible (usually within 1–2 days). You can also contact us if you have questions for one of the authors. Email: contact@espresso-tutorials.com
