Sub-Total: $0.00
Use Copilot in Excel to teach you about the data
Learn how to work with public population data using Excel Copilot and Power Query. Aggregated datasets often include both state- and county-level records, which can inflate totals if left unstructured. In this Data Survival Skills session, Robin shows how to clean and prepare data for analysis by converting it into a table, separating Alabama’s state totals from county data, and documenting context like record counts and population codes. You’ll learn how to prompt Copilot to answer quick data questions, capture insights for later research, and then use Power Query to filter, merge, and reshape the dataset for accuracy. By combining Copilot for exploration with Power Query for transformation, you can turn messy public data into a reliable foundation for research and community insight.
#DataAnalytics #Excel #Copilot #PowerQuery #BusinessIntelligence #DataSkills #DataPreparation #ExploratoryAnalysis #Productivity
If you’re a data analyst, you’ve no doubt learned different skills, techniques, and tools pertaining to data. But sometimes it can be difficult to know when and why to apply these tools. In this weekly series, instructor Robin Hunt explains a new skill, secret, tip, technique, best practice, or golden piece of advice in each installment. Robin covers topics that can help you do your job better, such as joining data and data designs, privacy for data, transforming and cleaning data, and making data sets and visualizing data.
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.