Join us on January 18th to expand your excel and power query skills! Register early and save!!! Early bird pricing ends 12/18.
In person and virtual options available
Registration Closes January 15th
Wells Fargo Connections Center
2800 S Price Road
Chandler AZ
9:00 am - 4:00 pm
6 Hours
Pracitical Skills a Data Worker Needs
This course was developed to teach real world tech skills in Excel to the people who encounter data in spreadsheets in their day-to-day work. This course gives you a foundation for working with data. We will dive into the practical skills needed by a data worker and we will show you how to approach and handle data with Microsoft Excel. This course is not for an Excel beginner.
 
Functions & Formulas
  • Basic date & time functions (TODAY, NOW, DAY/MONTH/YEAR)
  • Advanced date functions
  • Text conversion functions
  • Parse and cleaning functions
  • Logical functions
  • IF function
  • Absolute/relative referencing
  • VLOOKUPs and other fun functions
Conditional Formats and Data Commands
  • Work with conditional formats
  • Data commands
  • Sort and filter data
  • Remove duplicates
PivotTables
  • Understand PivotTables
  • Create a PivotTable
  • Connect data to a PivotTable
  • Build a pivot
  • Filter pivot data
  • Drilldown on a pivot for filtered data
  • Format pivots
  • Create a PivotChart
  • Visualize pivot data with PivotCharts
  • Update the data
  • Linking data from PivotTables to worksheet

This course was developed to teach real world tech skills in Excel to people who encounter data in spreadsheets in their day-to-day work. If you work with macros, clean data, or use multiple workbooks to create reports, you need to know about Power Query! We dive into practical skills and show you how to approach and handle data with Power Query. This course is not for an Excel beginner.

Get Data
  • Queries & connections
  • Access queries & connections
  • Navigate Power Query Editor
Data Cleaning & Applied Steps
  • Delete unnecessary columns
  • Use Choose Columns to remove columns
  • Change column order
  • Change data case
  • Replace values
  • Convert data types
  • Remove spaces & non-printable characters
  • Use gear for adjustments
  • Change step order
  • Name steps
  • Delete steps
Sort and filter data in Power Query
  • Sort data in Power Query
  • Filter data in Power Query
Custom Columns & Calculations
  • Index columns
  • Custom columns
  • Conditional columns
  • Duplicate columns
  • Merge columns
  • Split columns
Working with Applied Steps and adjustments
  • Use the gear for adjustments
  • Change the step order
  • Name a step
  • Delete a step
Advanced Editor
  • Access Advanced Editor
  • Understanding “M” code
Getting Data into Excel Sheet
  • Loading data to workbook
  • How to disconnect data from the source
Refresh and changing the data source
  • Refresh inside of the Power Query Editor
  • Refresh the data from the sheet
  • Change the data source

 

January 18, 2024
9:00 am - 12:00 pmExcel Data Worker
Speaker: Robin Hunt, Co-Founder and Partner, ThinkData Solutions, Inc.
12:00 pm - 1:00 pmLunch and Networking
1:00 pm - 4:00 pmPower Query in Excel
Speaker: Robin Hunt, Co-Founder and Partner, ThinkData Solutions, Inc.
Robin Hunt
ThinkData Solutions, Inc.
Robin Hunt has spent 20 years+ inspiring people to think something new about their everyday work life with data. As co-founder and partner of ThinkData Solutions, Inc., she works to encourage people to invest in themselves and never stop learning.
Along with her business partner Daniel Bishop, Robin has built a woman- and minority-owned business. While based in Birmingham, Alabama, ThinkData’s impact extends nationally and internationally.
Robin has created customized curricula that offer a path to a data analytics career and a great starting point into data analytics. She has developed effective, practical courses for LinkedIn Learning, including Career Essentials in Data Analysis by Microsoft and LinkedIn, the data analyst career learning path of the Microsoft Global Skills Initiative, the collaboration of Linkedin, Microsoft, and GitHub to offer free skills development learning.
She is the author of the Official CompTIA Data+ Content and she is the co-author of the Official CompTIA Data Systems+ Content. ThinkData offers training for these certifications as an authorized training organization.
Her commitment to education and data extends to an ongoing partnership with the Alabama Department of Early Childhood Education and the Alabama Department of Education. ThinkData provides datasets that meet the requirements of the Family Educational Rights and Privacy Acts to a research team that includes the Public Affairs Research Council of Alabama, University of Alabama at Birmingham School of Public Health, UAB School of Education, and the University of Alabama.
She is a member of the State of Alabama Office of Education & Workforce Statistics Advisory Board, a member of the Alabama Committee on Credentialing and Career Pathways’ Information Technology Technical Advisory Committee and is a Microsoft Certified Learning Partner and a Microsoft Certified Trainer.
Robin Hunt strives to leave a lasting impact in data analytics and beyond through her unwavering commitment to empower others through education and data.
 

Thank you to our Sponsors!