![Lineth Dela Cruz](/img/default-banner.jpg)
- Видео 135
- Просмотров 345 850
Lineth Dela Cruz
Филиппины
Добавлен 22 янв 2021
This channel will feature "MS Excel tutorial" for beginners and advanced users.
This include but not limited to tutorials, formulas, features, other uses, and tricks.
If you think you like to learn spreadsheet you can subscribe in this channel! :)
This include but not limited to tutorials, formulas, features, other uses, and tricks.
If you think you like to learn spreadsheet you can subscribe in this channel! :)
Remove Empty Columns Automatically using Power Query Function
In this video, I will be sharing the function that I’ve created using power query to automatically delete empty columns in a table.
0:00 Intro
1:00 Function for Remove Empty Columns
3:59 Final checking & Outro
Watch the whole video for further explanation of the process!
Visit my channel: ruclips.net/user/LinethDelaCruz
Link to download the sample file:
www.dropbox.com/s/5ycoo3j9qz6ti29/PQFxRemoveEmptyCols1.xlsx?dl=0
Link on Playlist: Learn Spreadsheet Power Query: ruclips.net/video/7IILCyP_YBc/видео.html
Thanks for your time and I hope you learn something from it.
Help me to reach my target audience by sharing my videos with the right people.
Don’t forget to SUBSCRIBE!
0:00 Intro
1:00 Function for Remove Empty Columns
3:59 Final checking & Outro
Watch the whole video for further explanation of the process!
Visit my channel: ruclips.net/user/LinethDelaCruz
Link to download the sample file:
www.dropbox.com/s/5ycoo3j9qz6ti29/PQFxRemoveEmptyCols1.xlsx?dl=0
Link on Playlist: Learn Spreadsheet Power Query: ruclips.net/video/7IILCyP_YBc/видео.html
Thanks for your time and I hope you learn something from it.
Help me to reach my target audience by sharing my videos with the right people.
Don’t forget to SUBSCRIBE!
Просмотров: 1 320
Видео
Combine Text from Different Rows into One Cell using Power Query
Просмотров 1,6 тыс.2 года назад
In this video, I will share with you a specific problem for combining text coming from different rows into one cell solved using the Power Query. 0:00 Intro 1:00 Group the Table 2:46 Further steps to Combine Texts 4:52 Final checking & Outro Watch the whole video for further explanation of the process! Visit my channel: ruclips.net/user/LinethDelaCruz Link to download the sample file: www.dropb...
Power Query Function for Bulk Renaming of Columns
Просмотров 6192 года назад
In this video, I will share with you the function that I’ve created to rename column names or headers in bulk using the Power Query. 0:00 Intro 0:48 Create the function in PQ 2:26 Test the function & outro Watch the whole video for further explanation of the process! Visit my channel: ruclips.net/user/LinethDelaCruz Link to download the sample file: www.dropbox.com/s/rf7v4ko7mbhji9g/PQfxRenameC...
Replicating SumProduct in Power Query
Просмотров 2,9 тыс.2 года назад
In this video, I will do two things in the Power Query. First is to replicate the SUMPRODUCT formula in Excel and second is to insert a new row using Table.InsertRows. 0:00 Intro & Sumproduct in Excel 1:12 Replicate Sumproduct in Advanced Editor 4:46 Insert new row with Table.InsertRows 6:56 Final checking & outro Watch the whole video for further explanation of the process! Visit my channel: r...
How to Add Leading Zeros in Excel Formula and Power Query
Просмотров 4612 года назад
In this video, I will show you how to add leading zeros in your data. I have three simple solutions for that. One is using the REPT & LEN functions in Excel. Second is the Text.Repeat and Text.Length in Power Query. And the third option is the Text.PadStart in the Power Query. 0:00 Intro & REPT LEN Solution 1:35 Text.Repeat Text.Length Solution 3:08 Text.PadStart Solution 4:21 Final checking & ...
How to Use Parameters in Power Query
Просмотров 2,4 тыс.2 года назад
In this video, I will show you how to use parameters in power query when filtering and/or sorting data, and changing sheets references. 0:00 Intro & Get Data from Excel Workbook 0:54 Use Parameters in Filtering 2:09 Use Parameters in Navigating into Sheet Names 3:32 Use Parameters in Sorting 5:00 Load to spreadsheet, checking, & outro Watch the whole video for further explanation of the process...
Aging of Receivables Report using Power Query
Просмотров 2,6 тыс.2 года назад
In this video, I am gonna do aging of receivables report using the power query. 0:00 Intro 0:37 Edit data and Add Age 1:00 Set reference table using fxPastDueDaysLabel function 1:25 Calculate past due days 2:23 Perform Approximate Match 4:33 Use try otherwise in Past Due column 5:16 Load into Pivot Table Report 5:57 Final checking and outro Watch the whole video for further explanation of the p...
Power Query List.Numbers Example turn into a Reference Table
Просмотров 1,1 тыс.2 года назад
In this video, I will show you one way of using List.Numbers as a reference table in an Aging of Receivables report. 0:00 Intro & List.Numbers 0:46 Make the list a reference table 4:35 Make a function 5:21 Test the function & Outro Watch the whole video for further explanation of the process! Visit my channel: ruclips.net/user/LinethDelaCruz Link to download the sample file: www.dropbox.com/s/k...
Power Query Fiscal Quarter Label Custom Function
Просмотров 4612 года назад
In this video, I will show you my created function for Fiscal Quarter label based on a given date and any start of fiscal period of your choice. 0:00 Intro 0:59 Put formula using Advanced Editor 4:18 Invoke the Function 4:53 Final checking & Outro Watch the whole video for further explanation of the process! Visit my channel: ruclips.net/user/LinethDelaCruz Link to download the sample file: www...
Power Query Fiscal Year Label Custom Function
Просмотров 1,3 тыс.2 года назад
In this video, I will show you my created function for Fiscal Year label based on a given date and any start of fiscal period of your choice. 0:00 Intro 0:43 Put formula using Advanced Editor 3:58 Load DATE example and Invoke the Function 4:58 Final checking & Outro Watch the whole video for further explanation of the process! Visit my channel: ruclips.net/user/LinethDelaCruz Link to download t...
How to Get the Applicable Rate with Approximate Match in Power Query
Просмотров 3952 года назад
In this video, I will show you how to get rate based on a graduated table that is usually solve using approximate match in Power Query. This can be applicable in getting different commission, bonus, or penalty rates based on the range of amount. 0:00 Intro & Load tables in PQ 1:04 LET function 1st variable 1:55 2nd variable with List.Select & List.Last 3:38 3rd variable with Table.SelectRows & ...
Power Query Time Range per Time Interval Template with List.Generate
Просмотров 3,1 тыс.2 года назад
Power Query Time Range per Time Interval Template with List.Generate
Create a List of Random Product Name using the List Generate in Power Query
Просмотров 6472 года назад
Create a List of Random Product Name using the List Generate in Power Query
How to Get the Maximum Sales per Product per Latest Entry Date with Power Query Table Buffer
Просмотров 8182 года назад
How to Get the Maximum Sales per Product per Latest Entry Date with Power Query Table Buffer
Get the Sales Contribution of each Promotion solved using Power Query
Просмотров 3692 года назад
Get the Sales Contribution of each Promotion solved using Power Query
Create Repeating Rows based on Trip Count and Distribute Budget per Trip in Power Query
Просмотров 1492 года назад
Create Repeating Rows based on Trip Count and Distribute Budget per Trip in Power Query
Get the List of Repeat Customer using the List Intersect in Power Query
Просмотров 8822 года назад
Get the List of Repeat Customer using the List Intersect in Power Query
Power Query List Difference to Get the List of New Data from Multiple Tables
Просмотров 1,1 тыс.2 года назад
Power Query List Difference to Get the List of New Data from Multiple Tables
Power Query Table Group and Text Split Formula Combined
Просмотров 3502 года назад
Power Query Table Group and Text Split Formula Combined
Assign Tasks Evenly to Team Members using Modulo in Power Query
Просмотров 3 тыс.2 года назад
Assign Tasks Evenly to Team Members using Modulo in Power Query
Power Query Text.PositionOf instead of using Search and Lookup Function in Excel
Просмотров 1,3 тыс.2 года назад
Power Query Text.PositionOf instead of using Search and Lookup Function in Excel
Power Query List Split with 2 Examples
Просмотров 3,2 тыс.2 года назад
Power Query List Split with 2 Examples
How to handle DUPLICATES when using Merge Queries Left Outer in Power Query
Просмотров 18 тыс.2 года назад
How to handle DUPLICATES when using Merge Queries Left Outer in Power Query
Power Query Average Unit Price based on the LAST N DAYS
Просмотров 9812 года назад
Power Query Average Unit Price based on the LAST N DAYS
Networkdays Template in Power Query
Просмотров 1,4 тыс.2 года назад
Networkdays Template in Power Query
Arranging Online Survey Data with Unpivot in Power Query and Pivot Table
Просмотров 4432 года назад
Arranging Online Survey Data with Unpivot in Power Query and Pivot Table
Power Query Get the Unique Combination of Two List
Просмотров 6762 года назад
Power Query Get the Unique Combination of Two List
Rename Multiple Column Names in Power Query
Просмотров 1,7 тыс.2 года назад
Rename Multiple Column Names in Power Query
Power Query Get the Weighted Average Unit Cost with Multiple Grouping
Просмотров 5 тыс.2 года назад
Power Query Get the Weighted Average Unit Cost with Multiple Grouping
Power Query List Accumulate for Running Total
Просмотров 4,8 тыс.2 года назад
Power Query List Accumulate for Running Total
Cool
the formula to make the project start day does not work with me. it gives me #name . how to fix this plz
Thank you so much
Nice 👍
This video not clear please post again three way vlook ups
Nice
Cool formula
It saves so much time
Thank you so much
❤👍
thank you very much... very useful
Hi Lineth what if we had quantity sold under three different heads like Shirt Type 1, Shirt Type 2 and Shirt Type 3. We also should be able to filter by shirt type along with days year and months. How de we handle this scenario?
very very helpful❤
Grabe ka paspas maam😢😢😢
Nice
Thank you for this great video. It is well explained and easy to understand. GBU
qolum
The best video to illustrate the issue and solution with Table.Buffer 👍👍. Thank you so much ❤❤🌹🌹
wow been looking for this function....can we consider quarter based on any condition lets say i have downloadeddata for q3 butdate will be in q2....can we do it
Wow😂❤❤
Thank you very much
Hats off
Time saver
Nice
Really nice it is really useful
I cannot use this formula for completed progress in google sheet. How can I do? Please advise me. Thank you
HI PAANO KUNG HINDI MO ISAMA ANG WEEKEND LIKE SUNDAY? THANK YOU
I didn't see what you input in the custom field before insert the data bar.
Thank you. I have to search text strings (all different formats) in large transaction files for names, identify them by source (15 different and they change), give the out put a certain code and then sort by source. I have been using the if and search function and it is time consuming, and prone to error to update. This is a much better solution. You have saved me time and worry! Thank you for sharing this information!!
Thank you very much, I am just looking to know how to use right function as text ❤❤❤
What if the Product is Orange 1, Orange 2, Orange 3.. How do I get the sum for Orange 1 only?
you are talking to yourself 🙄🙄
thank you :)
THANK YOU SOOOOOOO MUCHHHH!!!!
Thank you for posting this. I used your solution in Power BI. It's tricky how you execute the function instead of the standard function calling.
great video.. thanks
Great Job! Saved me hours of manual work renaming columns! Thank you!!!
This is so gooood Lineth. Marry me if you're not married. Just joking. Thank you it worked for me. Mmuah mmuah
Thank you so much
Many many thks!
SumIFS bhi work karega
Thanks! Very useful!
How to did anchor on the task_start, task_end and progress? After clicking name manager, there is no option for anchoring
superawesome!
Super helpful po ma'am, thank you po. Merry Christmas. 🎉
This video just saved me hours of manual work! Thank you!
Great
YOU ARE THE BEST! IVE BEEN TRYING TO DO THIS FOR TWO HOURS NONE OF THE OTHER VIDEOS HELPED!
how to format if I want to search more than one text i.e K5:K10
👍💯