This module will enable you to
- Customise automatic data conversion settings
- Understand the updates to the new workbook links experience
- Insert data from Power BI into Excel as a connected table
- Import data from the web with the new and improved web connector
About the module
In Excel, we often find ourselves getting data from an external source - linking to another file, importing data, or simply copy and pasting.
With the latest update, new data conversion options cover how to handle the infamous leading zero issue, and some changes to the way workbooks and spreadsheets are linked. There is also improved connectivity to import data from the web and from Power BI.
Contents
How it works
Author
Reviews
Anna K
09 Feb 2025
09 Feb 2025
Liked to read and try to do myself first and then watch a video about how to do it to iron out any issues.
Mark M
16 Oct 2024
16 Oct 2024
Learnt so much about connecting to different data sources including web pages
Ompontshitse G
18 Sep 2024
18 Sep 2024
good for analysing
| Recommended | ||||
Why not upgrade?Find the best way to complete your CPD | CourseNeed just a few unitshourshours? | Pick n MixAll you need for this year's CPD. | LicenceAll you need for this year and more. | TeamKeep your whole team up to date. |
|---|---|---|---|---|
| Access to this course | ||||
| Total CPD unitshourshours | 1 unitshourshours | 21 units20 hours21 hours | 1,500+ unitshourshours | 1,500+ unitshourshours |
| Access period | 120 days | 120 days | 12 months | 12+ months |
| Audit-proof CPD completion certificate | ||||
| Immediate access to our entire CPD catalogue | ||||
| Monthly webinars, 15-minute CPD Bites, video interviews with industry leaders, and more! | ||||
| Account manager on hand to support your team’s needs | ||||
| Learn more | Learn more | Learn more | ||
Why not upgrade?
Find the best way to complete your CPD
More in this series
Take a look more modules from the series: Excel Updates 2024-25
This course is only available as part of an accountingcpd licence.