From the course: Excel Copilot: Working with PivotTables
Join today to access over 25,500 courses taught by industry experts.
Challenge: Cleaning and structuring data for PivotTable
From the course: Excel Copilot: Working with PivotTables
Challenge: Cleaning and structuring data for PivotTable
(upbeat music) - [Narrator] In this chapter, you've learned strategies for preparing your source data to maximize Copilot's effectiveness when working with PivotTables. Now, this challenge offers an opportunity for you to practice and expand those skills by taking a data set and getting it ready for use with PivotTables and Copilot. The source data for this exercise is copilot-setup-challenge, which includes two tables, records, and buildings. The records table tracks energy consumption in kilowatt hours across various buildings, each identified by a unique record ID. It includes details like date, building identifier, geographical region, and zip code. Start by tidying up the zip code column. Currently leading zeros are missing, making it unclear that these are five digit zip codes. If you're unsure of how to fix this, try asking Copilot for assistance. Alternatively, tackle it yourself if you've handled this kind of data prep before. Next, you'll notice inconsistencies in the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.