CPA - small firm
CPA - medium firm
Other
Do you import data into Excel from other sources (such as CSV files, text files, web pages, databases or SharePoint)? Does the data that you import need to be "cleaned" before it can be used? (cleaning refers to things like removing duplicate rows, removing blank rows, removing unnecessary columns, converting case, changing date formats and more). Do you spend more time than necessary performing data cleaning tasks? If the answer to any of these questions is yes, you need to learn how to use Power Query! If you work with, analyze and generate reports from large datasets, having a good understanding and working knowledge of Power Query is a must!
Learning Objectives:
- Learn how to import data into Excel from text files, web pages and databases.
- Learn how to avoid the "million-rows" limitation by connecting to external sources
- Learn how to create Pivot Tables from external data sources
- Understand how to use the Power Query Editor to create calculated columns in pivot tables and to clean and transform data
This training is aimed at users of Excel (2010, 2013 and 2016 for Windows) who wish to learn about Power Query. Attendees should have at least intermediate knowledge of Excel and be familiar with formulas and creating Pivot tables.
IMPORTANT NOTE: Power Query is only available for Excel 2010, Excel 2013 and 2016 for Windows in Office Professional Plus, Office 365 Professional Plus or the standalone editions of Excel 2013 & 2016. If in doubt whether this training is relevant for your version of Excel, please check with your IT department.
Nancy Miller (SPJST)
"The Power Query webinar was excellent. The instructor explained the function of the software, capably demonstrated various ways to create data from different sources, and provided clear instructions for multiple options to quickly clean / format the downloaded data for one time or repetitive future use to meet one's specific needs."
Cheryl Geiger (Cheryl Geiger)
"I try to learn something new every day. Today I hit the jackpot! This was one of the BEST webinars I've ever attended and Mike Thomas is an outstanding instructor. His presentation is organized, well-paced, relevant, easy to understand and eye-opening. If you are an Excel user at any level, don't miss any of Mike's webinars!"
Karen Wood (Environmental Education Finance Collaborative)
"Mike Thomas is a fantastic trainer; too many trainers skip over some of the more fundamental steps and concepts, leaving gaps in my knowledge. Sometimes it's the little things that can become major obstacles and he took the time to make sure every step was covered, without the presentation feeling like it was dragging."
Kathleen Hon (RETIRED)
"Mike is soooo knowledgeable and has no problem conveying the information. He answers questions on the fly. The only problem is that the course is too short. I can't wait for the second part or any other class he does!"
Beth Young (Metro Government of Nashville & Davidson County)
"Excellent course - I highly recommend this course for anyone to take. This course provides excellent tips and tools that will allow you to extract or feed data that will benefit your business needs."
Michael Moss (Self Employed)
"Information shared in the webinar was helpful with understanding a technical subject. The instructor provided excellent examples for the subject area. Thank you for having meaningful topics."
CLETUS NWACHUKWU (CLETUS E. NWACHUKWU, CPA)
"Mike did an excellent job in the webinar. He clearly demonstrated his knowledge, skills and experience. I cannot wait to take Part 2 any time it is offered."
Tammy Galenza (TLGBKS)
"This was an excellent introduction to Power Query, and I have already thought of 6 different ways I can use this tool to become more efficient."
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies, including Microsoft Office and Apple Mac.
In 2012 Mike founded theexceltrainer.co.uk, where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and, in his career, delivered hundreds of courses and webinars on a wide variety of technology-related topics.
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 sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate critical business tasks and processes.
About Our Presenter
In 2012 Mike founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials.
He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a wide variety of technology-related topics.
Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors.
In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
- CPE Credits
- Support and FAQs
- Terms and Conditions
- Privacy Policy
- CPAwebengage, Inc.