Excel: Handling Data

(3 reviews)

by Alan Murray

Part of a series on 2024 Excel. This short course looks at improvements to how we import and handle data in Excel, making use of new data conversion settings and explaining how data can be linked and connected.

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

  • Handling data

How it works

Author

Alan Murray

Alan has over 20 years’ experience as an Excel trainer and loves to help companies improve their business processes and learn how to harness the power of Excel.

Reviews

5
(3 reviews)
5
4
3
2
1
 
 
 
 
    AK
    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.
    MM
    Mark M
    16 Oct 2024
    16 Oct 2024
    Learnt so much about connecting to different data sources including web pages
    OG
    Ompontshitse G
    18 Sep 2024
    18 Sep 2024
    good for analysing
Recommended

Why not upgrade?

Find the best way to complete your CPD

Course

Need just a few unitshourshours?

Pick n Mix

All you need for this year's CPD.

Licence

All you need for this year and more.

Team

Keep your whole team up to date.

Access to this course
Total CPD unitshourshours1 unitshourshours21 units20 hours21 hours1,500+ unitshourshours1,500+ unitshourshours
Access period120 days120 days12 months12+ 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 moreLearn moreLearn 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.