for Enterprise Subscriptions
$25/user
(Minimum 10 users)
$199/user
(Minimum 3 users)
You have Not Selected the Monthly or Annual Plan
Create your Free Account | Get Unlimited Access only @$199/Year ( View Details )
Trusted by 250,000+ Professionals for Continuing Education
Already have an account? Log In
To Continue using Trial, please verify your email address
You can cancel anytime during your trial period.
Trusted by 250,000+ Professionals
Steven was knowledgeable and thorough in his information about the product and what is offered. He was empathetic to my situation. He went above and beyond answering all of my many questions. Excellent service!
Great service and very patient as I asked several questions. Steven answered all my questions and helped me make the right decision in my subscription purchase. Thank you.
It is what it advertised to be. Professional quality training and CPE tracking and certificates; systems knows AZ CPA CPE requirements and categories. I've needed help on several occasions and the assistance was quick and effective; however, there were some problems with data entry. The assistance sometimes asks for input, but when I try to type it is dissallowed for some reason. On several occasions I had to close the popup to get it out of my way.
Great customer service. Classes are pertinent. Great value
Select the topics of your interest to receive Webinars/Virtual Events/E-Books/Podcasts of your interest.
Import , Clean Up, and Transform Data
Reviewed
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?
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 Getting and Transform in Excel 2016 and later).
This CPE/CPD webinar will focus on how to import data into Excel from a variety of sources and how to automate the data-cleaning process.
Major topics covered in this CPE course on Excel:
Owner, The Excel Trainer
In a career spanning 30+ years, Mike Thomas, a UK-based IT Trainer, has delivered thousands of courses and produced hundreds of written and video-based tutorials.
He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) on both the Windows and Mac platforms and Power BI.
Mike is a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organizations across a diverse range of industries including healthcare, pharmaceutical and public sector.
In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
Duration
Course Level
Instructional Method
Pre-requisites
Advance Preparation
MY-CPE LLC, 1600 Highway 6 south, suite 250, sugar land, TX, 77478
MY-CPE LLC (Sponsor Id#: 143597) 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.
228 Ratings
Excellent
147
Very Good
67
Average
9
Poor
4
Terrible
0
AF
Nov 20th, 2022
Outstanding introduction to Power Query. Would love to see additional courses offered on this topic with this instructor. Power Query can be a huge time saver for accountants working in industry.
MV
Mar 23rd, 2023
Excellent instructor. He explains very well with detailed steps so I can catch them all. Thanks a lot. I learn a great deal in one hour session.
UC
Dec 28th, 2023
I've been meaning to learn more about power query. This is a great place to start. This webinar is super easy to follow and very informative.
JM
Jan 25th, 2024
These excel courses are transformative and will help us use data better and save time.
MM
Nov 13th, 2023
Mike Thomas is an incredible instructor, thoughtful explanations in layman's terms.
Access to 13,000+ Hours of Continuing Education Approved Content Know More
Subscribe to AccessCPE
General
CPD
CE
Your inquiry has been received. We will notify you once this webinar is available
CloseThank you for subscribing 7 Days Free Trial.
Experience myCPE at its best! Upgrade your browser for a more interactive, user-friendly interface, and stay ahead in your professional development journey.
Upgrade NowWe were looking so hard for you now that you are finally here, So would you tell us how you found out about us?
Thank you for submitting your inquiry! We will contact you soon.
Close