Excel: Advanced Reporting with PowerPivot and Power Query

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Excel: Advanced Reporting with PowerPivot and Power Query March   7 3 pm - 4:40 pm ET Presenter: Mike Thomas, IT training instructor Credits: CPE (Credit Details) Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. Viewing Options: View on your computer, tablet, or smartphone Learn More Register Today Course Description   In this webinar, you'll learn how to use Power Query and Power Pivot to work with, analyze and generate reports from large datasets. Upon completion of this course, you'll be able to: Use Power Pivot to quickly and easily create Pivot Tables from multiple data sets without using VLOOKUP Analyze your data in new ways Work with datasets that span millions of rows Install the addins Import data into Power Pivot from external sources Create relationships in Power Pivot Recognize DAX formulas in Power Pivot Use Power Query to connect to data sources and quickly shape, transform, clean and refine your data Identify Power Query data sources Clean, transform, merge, and unpivot data IMPORTANT NOTE: Power Pivot is only available in Excel 2013 and 2016 for Windows in Office Professional Plus, Office 365 Professional Plus or the standalone editions of Excel 2013 & 2016. Learn More Register Today About The Presenter   Mike Thomas has worked in the IT training business since 1989. Mr. Thomas is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. Mr. Thomas has produced nearly 200 written and video-based Excel tutorials and regularly presents on a variety of Excel topics. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes. Learn More Register Today All-Access Membership   ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 75 live webinars each month ● More than 1,000 on-demand courses Learn More Upcoming Webinars Forecasting with Excel's Powerful Sensitivity Tools February 27 at 3 pm ET Learn More Mastering Form 5471 for Interests in Foreign Entities February 28 at 1 pm ET Learn More Filtering and Formatting Excel Data with Ease March 1 at 1 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 4601 N. Fairfax Dr., Ste 1200 | Arlington | VA | 22203 Remove me from future emails. Manage email preferences. This email was sent to virginia.duffy.planetduffy@blogger.com. If you are receiving it in error, please reply to this email.