ACPD logo

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.

£100+vat
1 CPD hours
120 days' access

This course 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 course

      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.

    Look inside

    Contents

    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
    JS
    Smith J
    19 Nov 2025
    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.
    JS
    Smith J
    19 Nov 2025
    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.
    JS
    Smith J
    19 Nov 2025
    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.

    You might also like

    Take a look at some of our bestselling courses

    alt

    2025 Autumn Budget

    alt

    2025 Winter Update: UK Tax

    alt

    2025 Tax Bulletin: December

    alt

    The Accountant as Company Secretary

    Got a team of 2 or more?

    Develop and retain a talented finance team with our team subscriptions.

    Use ACPD101 for 10% off any purchase.