# 215|EXCEL – Powering Up PowerQuery

**URL:** https://www.techhub.training/t/215-excel-powering-up-powerquery/2699
**Category:** Challenges
**Tags:** powerquery, business, excel, beginner, pivottable, real-world-challenges
**Created:** [May 14, 2024, 7:31pm UTC](https://www.techhub.training/t/215-excel-powering-up-powerquery/2699 "2024-05-14T19:31:09Z")
**Posts on this page:** 4
**Page:** 3

<div class="post-metadata">

### Author: ![Shiro\_Contreras](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/shiro_contreras/32/7171_2.png) [@Shiro\_Contreras](https://www.techhub.training/u/Shiro_Contreras)
#### Post date: [March 13, 2025, 6:59am UTC](https://www.techhub.training/t/215-excel-powering-up-powerquery/2699/41 "2025-03-13T06:59:07Z")

</div>

time: 60 min  
difficulty: intermediate

solution:  
[challenge 215 PowerQuery.xlsx](https://www.techhub.training/uploads/short-url/m7jgPIcvFo5midoSVSpppI9VmUn.xlsx) (109.4 KB)

---

<div class="post-metadata">

### Author: ![George\_Guo](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/george_guo/32/7628_2.png) [@George\_Guo](https://www.techhub.training/u/George_Guo)
#### Post date: [March 13, 2025, 4:21pm UTC](https://www.techhub.training/t/215-excel-powering-up-powerquery/2699/42 "2025-03-13T16:21:01Z")

</div>

[Powering up.xlsx](https://www.techhub.training/uploads/short-url/bKZJKdrjLkH58Sz1rkCpf7mILYB.xlsx) (108.9 KB)

---

<div class="post-metadata">

### Author: ![Kaden\_Westerlind](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/kaden_westerlind/32/7468_2.png) [@Kaden\_Westerlind](https://www.techhub.training/u/Kaden_Westerlind)
#### Post date: [March 13, 2025, 4:46pm UTC](https://www.techhub.training/t/215-excel-powering-up-powerquery/2699/43 "2025-03-13T16:46:21Z")

</div>

Time to complete 30 Min  
Difficulty Intermediate  
It was cool learning a new data function!  
[Power Query Finished.xlsx](https://www.techhub.training/uploads/short-url/2k0f4h7EwnPKQLJEO0I6rwsuXXv.xlsx) (109.4 KB)

---

<div class="post-metadata">

### Author: ![Scott\_Johnston](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/scott_johnston/32/7418_2.png) [@Scott\_Johnston](https://www.techhub.training/u/Scott_Johnston)
#### Post date: [March 13, 2025, 5:38pm UTC](https://www.techhub.training/t/215-excel-powering-up-powerquery/2699/44 "2025-03-13T17:38:46Z")

</div>

Time to complete: 15 min  
Difficulty: Beginner  
Solution:  
[EXCEL POWER QUERY CHALLENGE.xlsx](https://www.techhub.training/uploads/short-url/vCdy563WwVLXVTkGEOsNMICrdEL.xlsx) (24.8 KB)

[Previous page](https://www.techhub.training/t/215-excel-powering-up-powerquery/2699.md?page=2)