Forum Discussion

Iron Contributor

Jun 15, 2021

Solved

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...

VoIP Test.xlsx29 KB

excel

Riny_van_Eekelen
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

Iron Contributor

Jun 15, 2021

Hi Riny, I have never worked on PQ yet. How do I link the csv?

Riny_van_Eekelen

Platinum Contributor

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
Iron Contributor
Jun 15, 2021
This is definitely something that would trigger the "I want to know" lol
- Janedb
  Iron Contributor
  Jun 18, 2021
  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
    Platinum Contributor
    Jun 18, 2021
    Janedb Great! Spread the word.