Shopping Cart
Webinar Instruction will be emailed on your registered email address 3 days prior to webinar | Web Download / e-Transcript will be shared in 7 working days from the date of webinar
Turn bad data into great data in minutes!
Do you spend more time than is necessary importing and updating data from external sources such as databases, CSV files, and web pages?
Does the phrase "it's taking too long" describe how you feel about the time it takes to get your data into the right format for your reports?
Do you regularly perform repetitive, time-consuming "data cleaning and transforming" tasks such as removing unnecessary rows and columns, filtering out data that you don’t need, converting text to numbers or dates, splitting or merging columns, removing "weird" characters, or combining files together?
Would you like to be able to do all the above with the click of a button? If the answer Is yes, you need Power Query (known as Get and Transform in Excel 2016 and later).
This training will focus on two main topics…How to import data into Excel from a variety of sources, and how to automate the data cleaning process.
Ares Covered
Why Should You Attend
Power Query / Get and Transform can save you a ton of time when working with imported data. In many cases, when you get data from external sources, it needs work on before it can be used. Although this can be done using Excel functionality, Power Query / Get and Transform is a lot faster and is repeatable with a couple of clicks.
Credits and Other information:
Who Will Benefit:
Coder Archives is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
My name is Mike Thomas. I live in Manchester, UK and I work in and have a passion for tech. I have 30+ years experience of working in IT Training, designing and delivering training to businesses and individuals. My areas of focus include Microsoft Office and Power BI. I also have a wealth of experience with Apple Mac and iOS.
In addition to training, I design and develop MS Office based automated solution (using VBA – the automation/programming language built into all the Office apps)
In January 2024 I became a Microsoft MVP in Excel. The MVP program is a Microsoft-run initiative which it stands for Most Valuable Professional. It’s purpose is to recognize exceptional community leaders for their technical expertise, leadership, speaking experience, online influence, and commitment to solving real world problems.
I set this website up in 2008 as a knowledge-sharing blog.Although haven’t posted anything since January 2019, rather than remove all the posts I decided to leave them as published because a) a lot of the content is still relevant and b) for those older out-of-date posts, it’s like a trip down memory lane. You can access the posts via the Blog option on the menu.
We are approved to provide CPE/CE credits to Tax Professionals
We reports the educational credits to the respective licensing/regulatory bodies in 5 business days.
The credentials to log into your account is your EMAIL ADDRESS & PASSWORD used during account creation.
When you register for any of our webinars/product, you receive will the instruction 24 hours prior to the conference. Also, the instructions are avilable in your account under ‘My Webinars’ section.
You can cancel your registration to by email at support@pro2learn.com. If you cancel your registration for the paid webinar, the amount shall be credited back in your payment method within 7 business days.
The conference materials are available 4 hours prior to the webinar. You can download it from the webinar page or by logging to your account.
Our seamlessly integrated with ZOOM, WebX and, Goto for delivering continuing education webinars. The system requirements are :
Our package courses are the bundles of various continuing education courses which have been specially designed to meet your continuing education requirements for a particular Qualification.
On demand session is when we conduct the webinar as per your available dates after the live training. You will get access to the training for 24 hours.
To access a course that you have already purchased, all you must have to create/log in to your account. Click on the "Log In" button in the top right of the screen. Once you are logged in, you will have immediate access to all your purchased CPE courses, packages and other self-service or you can write on support@pro2learn.com.
We will email your certificate within 3 working days of the end of the webinar, or you can login your account at www.pro2learn.com. If you don’t receive the email within 3 working days of the end of the webinar, check your spam/junk folder. If it’s not there, we recommend that you send us an email at support@pro2learn.com or connect over the online chatroom.
| Date | Conferences | Duration | Price | Buy |
|---|---|---|---|---|
| Aug 22, 2025 | Getting Started With Power BI - Transforming Data Into Stunning Visuals | 90 min | $149 | Buy |
