| Attend upcoming webinar and earn continuing education credits. | Excel Power Query Crash Course | | | | | | | Presenter: Andy Lanning, owner of Computer Software Training LLC | | | 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 | | | | | | | | | | | | When the daunting task of 'cleaning up data' comes across your desk, are you using the helpful features of Excel's Power Query? Power Query debuted as a new feature in Excel 2010, and is now a standard part of Excel 2016 and 2019. In this practical webinar, you will learn how to find Power Query, load data into it, begin the process of transforming your redundant tasks (for the last time!), and learn how to Save and Load the Query to Excel to finish your reports. Upon course completion, you will be able to: - Begin a new Power Query
- Extract data from your Source files into the Power Query
- Transform your data and clean it up
- Replicate the Transform process by referencing examples
- Utilize the power of the Query Settings and the Advanced Editor
- Load the data and save the Excel file
- Re-open and edit the Power Query Settings
| | | | | | | | | | Andy Lanning is the owner of Computer Software Training LLC, a computer consulting business. Ms. Lanning has over 20 years of experience teaching computer software in academic and corporate settings. She is a Certified Microsoft Office Specialist. Ms. Lanning is currently an instructor at Boise State University and previously at College of Western Idaho. She is a graduate of Boise State University. | | | | | | | | | | | ● 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,500 on-demand courses | | | | | | |
No comments:
Post a Comment