Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

Microsoft Excel 3: ETL with Power Query in Excel

Microsoft Excel 3: ETL with Power Query

Description

The most critical starting point for a successful spreadsheet is clean, accurate, and current data. The most effective and modern way to accomplish this task is with a newer feature of Excel called Power Query. With Power Query, we perform operations that Extract, Transform, and Load (ETL) data from the original source into our workbook. Topics include:

  • Understanding Power Query in the context of an Excel workbook
  • Extracting data from various sources
  • Performing transformations on dirty data
  • Combining and comparing data
  • Setting up automated refreshes of external data

Similar events

Microsoft Word 1: Navigation, Selection, and Editing - Hands-on

Microsoft Word 1: Navigation, Selection, and Editing

More Information
Microsoft Word 2: Essential Formatting and Structures - Hands-on

Micosoft Word 2: Essential Formatting and Structures

More Information
Microsoft Word 3: Tabs and Tables - Hands-on

Microsoft Word 3: Tabs and Tables

More Information
Microsoft Word 4: References and File Structure - Hands-on

Microsoft Word 4: References and File Structure

More Information
Microsoft Word 5: Forms and Mail Merge - Hands-on

Microsoft Word 5: Forms and Mail Merge

More Information
Microsoft Word 6: Automation - Hands-on

Microsoft Word 6: Automation

More Information
Microsoft Word for Legal Practices - Hands-on

MS Word for Legal Practices

More Information
Microsoft Excel 1: Essential Spreadsheet Skills - Hands-on

Microsoft Excel 1: Essential Spreadsheet Skills

More Information
Microsoft Excel 2: References and Calculations - Hands-on

Microsoft Excel 2: References and Calculations

More Information
Microsoft Excel 4: List and Table Management - Hands-on

Microsoft Excel 4: List and Table Management

More Information
Microsoft Excel 5: Text, Date, and Management Functions - Hands-on

Microsoft Excel 5: Text, Date, and Management Functions

More Information
Microsoft Excel 6: Lookup and Logical Functions - Hands-on

Microsoft Excel 6: Lookup and Logical Functions

More Information
Microsoft Excel 7: Pivot Tables and Pivot Charts - Hands-on

Microsoft Excel 7: Pivot Tables and Pivot Charts

More Information
Microsoft Excel 8: Power Pivot and Modern Excel - Hands-on

Microsoft Excel 8: Power Pivot and Modern Excel

More Information
Microsoft Excel 9: Data Visualization Essentials - Hands-on

Microsoft Excel 9: Data Visualization Essentials

More Information
Microsoft Excel 10: Forecasting and Analysis - Hands-on

Microsoft Excel 10: Forecasting and Analysis

More Information
Microsoft Excel 11: Professional Polish for Spreadsheet - Hands-on

Microsoft Excel 11: Professional Polish for Spreadsheets

More Information
Microsoft Excel 12: Automation in Excel - Hands-on

Microsoft Excel 12: Automation in Excel

More Information
Microsoft PowerPoint 1: Essential Slide Creation and Formatting

Core PowerPoint Techniques

More Information
Microsoft PowerPoint 2: Theme and Template Foundation - Hands-on

Microsoft PowerPoint 2: Theme and Template Foundation

More Information
Microsoft PowerPoint 3: Images, Icons, and Diagrams - Hands-on

Microsoft PowerPoint 3: Images, Icons, and Diagrams

More Information
Microsoft PowerPoint 4: Charting in PowerPoint - Hands-on

Microsoft PowerPoint 4: Charting in PowerPoint

More Information
Microsoft PowerPoint 5: Media and Motion - Hands-on

Microsoft PowerPoint 5: Media and Motion

More Information
Microsoft PowerPoint 6: Advanced Theme Development - Hands-on

Microsoft PowerPoint 6: Advanced Theme Development

More Information
Microsoft PowerPoint 7: Nonlinear Presentations - Hands-on

Microsoft PowerPoint 7: Nonlinear Presentations

More Information
Microsoft PowerPoint 8: Presentation Structure and Best Practices - Hands-on

Microsoft PowerPoint 8: Presentation Structure and Best Practices

More Information
Microsoft Outlook 1: Outlook Essentials - Hands-on

Microsoft Outlook 1: Outlook Essentials

More Information
Microsoft Outlook 2: Inbox Management - Hands-on

Microsoft Outlook 2: Inbox Management

More Information
Microsoft Outlook 3: Calendar Management - Hands-on

Microsoft Outlook 3: Calendar Management

More Information
Microsoft Outlook 4: Tasks and Contacts - Hands-on

Microsoft Outlook 4: Tasks and Contacts

More Information
Microsoft OneNote 1: Information Management - Hands-on

Microsoft OneNote 1: Information Management

More Information
Microsoft OneNote 2: Integrations and Workflows - Hands-on

Microsoft OneNote 2: Integrations and Workflows

More Information
Microsoft Visio 1: Essential Diagram Design - Hands-on

Microsoft Visio 1: Essential Diagram Design

More Information
Microsoft Visio 2: Data-Driven Diagrams - Hands-on

Microsoft Visio 2: Data-Driven Diagrams

More Information
Microsoft 365 1: Understanding Microsoft 365 - Seminar

Microsoft 365 1: Understanding Microsoft 365

More Information
Microsoft 365 2: Integrations Between Teams and SharePoint - Seminar

Microsoft 365 2: Creating and Modifying Microsoft 365 Groups

More Information
Teams 1: Understanding Microsoft Teams - Hands-on

Teams 1: Understanding Microsoft Teams

More Information
Teams 2: Chat and Meetings - Hands-on

Teams 2: Chat and Meetings

More Information
Teams 3: Creating Teams and Channels - Hands-on

Teams 3: Creating Teams and Channels

More Information
Teams 4: Integrations - Hands-on

Teams 4: Integrations

More Information
SharePoint 1: Understanding SharePoint - Hands-on

SharePoint 1: Understanding SharePoint

More Information
SharePoint 2: Personalization - Hands-on

SharePoint 2: Personalization

More Information
SharePoint 3: Site Access Management - Hands-on

SharePoint 3: Site Access Management

More Information
SharePoint 4: Content Mangement - Hands-on

SharePoint 4: Content Management

More Information
SharePoint 5: Experience Mangement - Hands-on

SharePoint 5: Experience Management

More Information
SharePoint 6: Integration Management - Hands-on

SharePoint 6: Integration Management

More Information
OneDrive: OneDrive for Individual Projects - Hands-on

OneDrive: OneDrive for Individual Projects

More Information
Tasks: Planner, To-Do, and Microsoft Lists - Hands-on

Tasks: Planner, To-Do, and Microsoft Lists

More Information
Data Handling with Forms and Flows - Hands-on

Data Handling: Microsoft Forms and Flows

More Information
Design 1: Essential Design Principles for Business Professionals - Hands-on

Design 1: Essential Design Principles for Business Professionals

More Information
Design 2: Customizing a Corporate Design Theme - Hands-on

Design 2: Customizing a Corporate Design Theme

More Information
Design 3: Preattentive Attributes in File Construction - Hands-on

Design 3: Preattentive Attributes in File Construction

More Information
Design 4: Gestalt Principles in Visual Design - Hands-on

Design 4: Gestalt Principles in Visual Design

More Information
Office 1: Creating a Corporate Office Theme - Hands-on

Office 1: Creating a Corporate Office Theme

More Information
Office 2: Templatizing Word and Excel Files - Hands-on

Office 2: Templatizing Word and Excel Files

More Information
Office 3: Creating a Corporate Presentation Layout - Hands-on

Office 3: Creating a Corporate Presentation Layout

More Information
Office 4: Customizing a Presentation Theme - Hands-on

Office 4: Customizing a Presentation Theme

More Information
PowerPoint 1: Presentation Planning - Hands-on

PowerPoint 1: Presentation Planning

More Information
PowerPoint 2: Presentation Design - Hands-on

PowerPoint 2: Presentation Design

More Information
PowerPoint 3: Design Principles in Visual Design - Hands-on

PowerPoint 3: Design Principles in Visual Design

More Information
PowerPoint 4: Data-Rich Presentations - Hands-on

PowerPoint 4: Data-Rich Presentations

More Information
PowerPoint 5: Presentation Experience Design - Hands-on

PowerPoint 5: Presentation Experience Design

More Information
PowerPoint 6: Virtual Presentations - Hands-on

PowerPoint 6: Virtual Presentations

More Information

Press enter to see more results