Dreading sorting, cleaning, and organizing it all?
It is nearing the end of the year, which means lots of reporting and projecting. If you have data all over in databases on your computer and online, then how (and when do you have the time) to get
ALL of that data in one organized spot to report on? Excel Power Query is your answer. But how do you use Power Query?
We can help with that:
On November 20, 2018 @ 1pm ET
Excel Power Query: Import and Clean Your Big Data
See full webinar information here:
https://www.learnexcelnow.com/event/excel-power-query/ The Excel Trainer, Mike Thomas, will be joining us live from the UK to present for 90 minutes. He has been in the IT training business for almost 30 years! He also designs and develops Microsoft
Office-based solutions that automate key business tasks and processes. Let him make your life easier with thorough training to transform big data more efficiently with fast and powerful data
gathering and cleansing capabilities.
Mike will cover:
* Importing data into Excel from text files, web pages, and a database
* How to avoid the "million-rows" limitation by connecting to external sources
* Creating Pivot Tables from external data sources
* Using the Query Editor
* * Create calculated columns in pivot tables
* * Clean and transform data
The best value deal is to choose the bundle at checkout. At only $249, it includes:
* $199-value live registration to follow along with demonstrations by Mike Thomas and ask him your questions
* $199-value on-demand webinar to refer back to and play/pause when you put your skills to the test later
Choose the live, on-demand, or bundle here:
https://www.learnexcelnow.com/event/excel-power-query/ IMPORTANT NOTE FOR THE WEBINAR:
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.
Questions about the webinar? Call 1-800-964-6033
Learn Excel Now
https://www.learnexcelnow.com/ 384 Technology Drive Malvern, PA 19355
Unsubscribe http://optout.learnexcelnow.com/oo?U=1_2143W_35PVY
