Women in Business Discussion Group Tuesday 27 July 2021| 6 – 8pm | Via Webex
The Women in Business Discussion Group are delighted to welcome back Neale Blackwood, Microsoft Excel expert. Neale will demonstrate how Power Query allows you to automatically perform data cleansing routines on your data sources - no manual intervention required. Simply refresh and your data is ready to use. You can use csv files; txt files; databases and existing Excel tables as your data sources.
Continuing his Power Query tips from his last session, Neale will start working with multiple files. For example, you may have 12 separate CSV files in a folder. All with the same layout, one for each month of the year. Power Query can import all 12 files as if they were a single file and create a table for the whole year
This session covers
- importing multiple CSV files from a folder
- a technique to capture the file name in a field (column)
- importing multiple Excel files
- merging data from multiple tables
- Extracting header information into a column from multiple CSV files
Neale Blackwood is a Microsoft Excel expert with over 30 years’ experience as an Accountant and consultant and over 25 years’ experience using and writing about Excel. Neale has been a regular contributor to INTHEBLACK since 2002. He has written over 200 Excel articles for the magazine. He answers Excel questions via email from CPAs from around the world.
He has written and presented numerous Excel sessions at CPA events around Australia over the past 10 years. He has recorded over two dozen Excel podcasts for the CPA Australia podcast series. His first book, Advanced Excel Reporting for Management Accountants, was published in 2014 by Wiley. He has presented over 350 live webinars on Excel since 2012 and written over 400 blog posts.
Neale works with organisations, large and small, to help them make the most of Excel by:
Speeding up reporting processes by re-engineering their current Excel files
Reducing re-keying by creating new reporting solutions
Removing manual processes by automating tasks using Power Query and macros
Providing targeted Excel coaching (in person and online)
Providing customised Excel training (in person and online)
Running live online webinars both free and paid
