Cleaning Data without Complex Functions - A Course for Data Analysts

Are you tired of the tedious task of cleaning your Excel data before you can analyze it? Are you tired of having to use complicated functions? Would you like to automate the process without learning how to code? In this webinar, learn about one of the best additions to Excel – Power Query. Most of your data cleanup tasks are one click away, and your actions are recorded so that you can easily reuse the steps – a boon in situations where you run the same reports each week or month. 

• Introduction and Overview: Understand the capabilities of Power Query and how it simplifies data cleaning and preparation in Excel.
• Importing Data from Multiple Sources: Learn how to import data from various sources, including Excel, CSV files, folders, and more than 200 additional data sources.
• Exploring the Power Query Editor: Gain familiarity with the Power Query Editor interface and its features for efficient data transformation.
• Performing Simple Data Cleanup Tasks: Master basic tasks such as splitting columns, removing duplicates, and reshaping data for better analysis.
• Performing Complex Data Cleanup Tasks: Tackle advanced data preparation challenges like unpivoting data, combining data from multiple sources, and transforming data formats.
• Using Power Query as a VLOOKUP/XLOOKUP Alternative: Discover how to replace complex Excel functions with Power Query for easier data merging and retrieval.
• Automating Data Cleanup Processes: Learn how to record and reuse transformation steps for repetitive tasks, saving time and reducing errors.
• Exporting Cleaned Data: Understand how to export transformed data into Excel tables, pivot tables, or other formats for reporting and analysis.

• Introduction to Power Query: Overview of its purpose, benefits, and integration with Excel for data cleaning and transformation.
• Importing Data: Techniques for importing data from various sources like Excel, CSV files, folders, websites, SharePoint, and more.
• Navigating the Power Query Editor: A walkthrough of the interface, including key tools and features for data transformation.
• Simple Data Cleaning Tasks: Performing tasks such as splitting columns, removing duplicates, renaming headers, and filtering data.
• Advanced-Data Cleaning Tasks: Handling complex transformations, including unpivoting data, merging datasets, and extracting specific data elements.
• Using Power Query as a Formula Alternative: Replacing functions like VLOOKUP, XLOOKUP, and other complex Excel formulas with Power Query’s intuitive tools.
• Automating Repetitive Tasks: Setting up reusable queries for recurring data processing needs with minimal manual intervention.
• Exporting and Sharing Data: Exporting cleaned and processed data into Excel tables, pivot tables, and other formats.
• Power Query for Power BI: Exploring how skills learned in Excel transfer to Power BI for advanced analytics and visualization projects.
• Real-World Applications: Demonstrating practical examples of using Power Query in everyday data analysis tasks.

1. Effortlessly import data from multiple sources. You can import data from Sharepoint Lists, Websites, CSV and Text files, folders, pdf, and over 200+ other sources. 
2. No more nested XLOOKUPs or VLOOKUPs. Power Query provides a much easier way to match data from multiple sources, to retrieve exactly what you need. No more nested VLOOKUPs, MATCH, or INDEX functions. 
3. Easy Data Cleanup. Say bye-bye to using a combination of functions to separate names, unpivot data, extract data, or separate data. 
4. Automation without learning macros. Do you process similar files each week or month to create your reports? With Power Query, you can save the steps so repeating the process simply involves clicking Refresh. 
5. Export data to various formats. Your data can be exported to Excel tables or directly into Pivot tables. 
6. Get a jump start on learning Power BI. The Power Query skills you learn for Excel are easily transferable to cleaning data in Power BI. If learning Power BI is on your list, you can get a jump start by attending this webinar. 

• Data Analyst
• Business Analyst
• Financial Analyst
• Operations Analyst
• IT Specialist
• Project Manager
• Marketing Analyst
• HR Analyst
• Small Business Owner
• Students or Aspiring Data Professionals

Jackie Kiadii is an MVP and Microsoft Certified Trainer specializing in Excel, Power Query, and Power BI. For the past 20 years. She has taught business professionals how to use software to increase their productivity. In addition to training, Jackie works as a consultant helping companies manage their data and automate their Excel processes

Jackie Kiadii started off as a consultant in 2001, and somewhere along the way she discovered that she has a passion for teaching people how to get the most out of their software in the shortest time possible. She draws people into her presentation with real life examples, adding a touch of natural humour.