Forum Discussion
Janedb
Jun 15, 2021Iron Contributor
VoIP billing in Excel
Hi All, I am trying to create a spreadsheet to calculate my client's VoIP call cost. Unfortunately, all clients are on one excel CSV spreadsheet, so I want it to separate the one spreadsheet into mul...
- Jun 15, 2021
Janedb Okay, then you need to do some studying first. A good starting point could be here:
https://exceloffthegrid.com/power-query-introduction/ , and there are many more resources on-line. Just Google and pick a few.
Don't expect it to be super easy from the start, but as said, once you have started using PQ, you will find it difficult to not use for almost everything you do in Excel.
Janedb
Jun 18, 2021Iron Contributor
Riny_van_Eekelen Thank you for your help. Didnt take to long to figure the PQ out. Got the results I was looking for and it works perfectly.
Riny_van_Eekelen
Jun 18, 2021Platinum Contributor
Janedb Great! Spread the word.