- 71
- 361 513
Wilson Powlous
United Arab Emirates
เข้าร่วมเมื่อ 2 ก.พ. 2008
Assigning Unique ID to list of values which are either sorted or unsorted using 3 formulae
This video explains the one of the real life scenario of using combination of COUNTIF(), MAX(), VLOOKUP() formulae in excel. This video shows you how you can generate unique ID for each item in a list which is either sorted or unsorted. This is an advanced version of the previous video
th-cam.com/video/2CqY846-IEw/w-d-xo.html
th-cam.com/video/2CqY846-IEw/w-d-xo.html
มุมมอง: 40
วีดีโอ
Excel Basics Training Session (20-Oct-2023) Unedited
มุมมอง 98ปีที่แล้ว
This video explains the basics of Excel, mainly targeting the new users of excel. But you will find some features which is useful for the advanced users as well. Shortly the Advanced Training session of excel will be uploaded in this channel.
Excel Setup for High productivity, QAT & Ribbon customization
มุมมอง 64ปีที่แล้ว
Excel Setup for High productivity, QAT & Ribbon customization
Pasting multiple copied contents at once in Excel
มุมมอง 76ปีที่แล้ว
This video explains how you can copy the data multiple times and store it in the excel clipboard and paste them at once or selectively as you need. This method of copy pasting saves lots of time and quire efficient.
Excel Power Tips to Work Smarter 1 to 4
มุมมอง 93ปีที่แล้ว
In this video we look at below techniques in Excel. 1. Extracting the file names from the full file path 2. Splitting the full names as first name / second name etc. 3. Removing multiple spaces in the data 4. Converting the dates with multiple formats to single format.
Dynamic Numbering of List using Sequence function in Excel
มุมมอง 196ปีที่แล้ว
In this video we are going to see how we can do a dynamic numbering for a list in Excel using the SEQUENCE function instead of dragging the numbers or using any other complex formula. By doing this you can avoid updating the formula for every addition or deletion of items in the list.
Recording and Editing Macro to create 100's of Excel Sheet copies (Macro with VBA)
มุมมอง 7082 ปีที่แล้ว
This videos explains how you can make 100's of copy of excel sheets using Macro. It explains how to add the developer tab to record macro and to edit the macro. Also shows how to modify the recorded macro code in VBA editor to further customize it.
How to Identify Numbers that Add Up to a Specific Value using Solver Add-in of Excel
มุมมอง 24K3 ปีที่แล้ว
This video explains you, how you can Identify certain numbers that add up to a specific value using Solver Add-in of Excel. This video offers the solution to everyday challenge for the people who works as an auditor, accountants etc. Solver can be used also to find solution for many problems like - optimum scheduling of machineries in a workshop, allocation of employee shift, Optimizing the del...
How to use Use Excel IFS Function (Alternate to nested IF ELSE)
มุมมอง 2924 ปีที่แล้ว
IF function is one of the widely used function in Excel. But using IF formula for multiple conditions will be very challenging. To overcome this difficulty with the IF condition you can use the IFS function if you are using Excel 2019 or Microsoft 365. In this video I will be showing how it is better to use IFS function for the logical testing of multiple conditions. Your code will be much easi...
3 Free Excel Add-Ins which helps in making better Dashboards and Reports (Video Player, QR Code etc)
มุมมอง 1594 ปีที่แล้ว
This video Explains how to use below 3 Excel Add-ins which are free. Web Video Player - Embed any TH-cam videos directly in Excel which could be useful in preparing user manuals, educational guide etc. QR4Office - Using this you can Create QR Codes in Excel People Graph - This is very useful add-in to Create an Infographic of any dataset.
Part 6 of Top 30 Advanced Pivot Table hacks (Tips & Tricks) For Microsoft Excel
มุมมอง 1584 ปีที่แล้ว
In this series of videos we're going to look at the top 30 advanced pivot table tips and tricks (Hacks) for Microsoft Excel. This is part 6 of the series and it contains 5 tips and remaining tips are available in other videos of this series. These techniques are going to make you a super hero at your job. All videos on Top 30 Advanced Pivot Table hacks can be viewed at Part - 1 th-cam.com/video...
Part 5 of Top 30 Advanced Pivot Table hacks (Tips & Tricks) For Microsoft Excel
มุมมอง 1424 ปีที่แล้ว
In this series of videos we're going to look at the top 30 advanced pivot table tips and tricks (Hacks) for Microsoft Excel. This is part 5 of the series and it contains 5 tips and remaining tips are available in other videos of this series. These techniques are going to make you a super hero at your job. All videos on Top 30 Advanced Pivot Table hacks can be viewed at Part - 1 th-cam.com/video...
Part 4 of Top 30 Advanced Pivot Table hacks (Tips & Tricks) For Microsoft Excel
มุมมอง 2034 ปีที่แล้ว
In this series of videos we're going to look at the top 30 advanced pivot table tips and tricks (Hacks) for Microsoft Excel. This is part 4 of the series and it contains 5 tips and remaining tips are available in other videos of this series. These techniques are going to make you a super hero at your job. All videos on Top 30 Advanced Pivot Table hacks can be viewed at Part - 1 th-cam.com/video...
Part 3 of Top 30 Advanced Pivot Table hacks (Tips & Tricks) For Microsoft Excel
มุมมอง 1964 ปีที่แล้ว
In this series of videos we're going to look at the top 30 advanced pivot table tips and tricks (Hacks) for Microsoft Excel. This is part 3 of the series and it contains 5 tips and remaining tips are available in other videos of this series. These techniques are going to make you a super hero at your job. All videos on Top 30 Advanced Pivot Table hacks can be viewed at Part - 1 th-cam.com/video...
Part 2 of Top 30 Advanced Pivot Table hacks (Tips & Tricks) For Microsoft Excel
มุมมอง 2564 ปีที่แล้ว
In this series of videos we're going to look at the top 30 advanced pivot table tips and tricks (Hacks) for Microsoft Excel. This is part 2 of the series and it contains 5 tips and remaining tips are available in other videos of this series. These techniques are going to make you a super hero at your job. All videos on Top 30 Advanced Pivot Table hacks can be viewed at Part - 1 th-cam.com/video...
Part 1 of Top 30 Advanced Pivot Table hacks (Tips & Tricks) For Microsoft Excel
มุมมอง 5804 ปีที่แล้ว
Part 1 of Top 30 Advanced Pivot Table hacks (Tips & Tricks) For Microsoft Excel
How to rotate chart using Camera tool in Excel - Useful while building dashboards
มุมมอง 26K4 ปีที่แล้ว
How to rotate chart using Camera tool in Excel - Useful while building dashboards
How to get Current Date & Time in Excel using Formula and Shortcuts (Both Dynamic & Constant)
มุมมอง 1.2K4 ปีที่แล้ว
How to get Current Date & Time in Excel using Formula and Shortcuts (Both Dynamic & Constant)
How to create Sales Report & Chart Using Pivot Tables in less than a minute
มุมมอง 1.4K4 ปีที่แล้ว
How to create Sales Report & Chart Using Pivot Tables in less than a minute
How to create chart within a single cell to represent data from a range of cells - Spark line chart
มุมมอง 3864 ปีที่แล้ว
How to create chart within a single cell to represent data from a range of cells - Spark line chart
How to keep the Top rows or left columns without scrolling - Use of Freeze Pane option
มุมมอง 2624 ปีที่แล้ว
How to keep the Top rows or left columns without scrolling - Use of Freeze Pane option
Transpose - Interchanging the Rows and Columns
มุมมอง 3064 ปีที่แล้ว
Transpose - Interchanging the Rows and Columns
How to Create Dual Axes Combo Charts in Excel (Display Sales & Profit % on 2 different scales)
มุมมอง 1864 ปีที่แล้ว
How to Create Dual Axes Combo Charts in Excel (Display Sales & Profit % on 2 different scales)
How to create Hyperlinks in Excel to Navigate easily within and outside Excel
มุมมอง 2264 ปีที่แล้ว
How to create Hyperlinks in Excel to Navigate easily within and outside Excel
Excel Intermediate Level Training Session - 3 (Part 1 of 2)
มุมมอง 1754 ปีที่แล้ว
Excel Intermediate Level Training Session - 3 (Part 1 of 2)
Excel Basic Training Session - 2 (Part 3 of 3)
มุมมอง 1264 ปีที่แล้ว
Excel Basic Training Session - 2 (Part 3 of 3)
Excel Training Session - 2 (Part 2 of 3)
มุมมอง 1044 ปีที่แล้ว
Excel Training Session - 2 (Part 2 of 3)
Excel Basic Training Session - 2 (Part 1 of 3)
มุมมอง 1274 ปีที่แล้ว
Excel Basic Training Session - 2 (Part 1 of 3)
Excel Basic Training Session - 1 (Part 2 of 2)
มุมมอง 1464 ปีที่แล้ว
Excel Basic Training Session - 1 (Part 2 of 2)
Excel Basic Training Session - 1 (Part 1 of 2)
มุมมอง 2664 ปีที่แล้ว
Excel Basic Training Session - 1 (Part 1 of 2)
You are a LEGEND!! Thank you!!
Thank you!
Thank you! Very easy to follow!
👌👌👌👌👌👌👌👌👌
Thank for you the comment. I have uploaded a advanced version of this video, see the link in this video description.
Excellent..👍
Thank for you the comment. I have uploaded an advanced version of this video, see the link in this video description.
Found a video that gave this solution right before and it did a great job giving step by step instructions that can actually be followed. However, how you presented this video made me literally understand how it works by demonstrating piece by piece how one change to an option affects the result and that is a major difference in level of functioning, flexibility and comfort in utilizing a resource. As a former teacher of a different field, sir, you have achieved teacher level 500!
Nice explanation
NICE
Can you do this for charts in PowerPoint?
What if the names aren't sorted
Thank for you the comment. I have uploaded an advanced version of this video which takes care of the unsorted list, see the link in this video description.
You are greate
Excellent presentation!
How can i lock different collumns and individual cells🤔
As I explained in the video, first lock all columns and rows. Then select whichever columns or cells which you want to lock together or one by one, then go to the format cells option and mark LOCK CELL option.
@@wilsonpowlous i was playing and figured it out. Thanks for reply😀👍
can it show the more than one combonation
Each run may show different answers if more combinations are available. You may give restrictions to narrow down the answers. But at a time only one result only can be seen
Will it work if we have values in positive and negative?
Yes, it works
Thanks sir
Easy loved ot
Thank you
You're the best, Wilson!
Thank you
thank you
Thank you
Not working if there are too many variable cells 😭😭😭
This was a lifesaver! I was going to have to try and manually match up numbers to try and get to the totals I needed. Thank you for posting.
Thank you
Hello Sir, suppose you have a value 12 and you have to divide the value in 1 into 12 times, and highlight it, in a column, just like a bar graph, please gave some bit idea
Couldn't understand, sorry, Can you please elaborate?
Amazing video. Thank you so much ❤️
Thank you
Oh man you absolute boss. Thank you so much. I work in finance and need to analyse different line items across multiple purchase orders to match my total asset value. I was working across hundreds of lines of costs and this has helped so much and now my boss thinks I’m a genius 😂
Thank you
Thanks for the video. I saw dexterity dictionary in your task bar. Which version you are using currently ?
2018 r2 dex and gp
@@wilsonpowlous Thanks Dear. I heard, there won't be any more upgrade for GP. Do you have any information about this ?
I'm mirroring everything you do, but I'm still getting decimals
Add an integer restriction
THANK YOU VERY MUCH. HELPED ME A LOT DOING THIS FUNCTION
Thank you
what if there are more than one combination?
Each run may give different if there are multiple answers
Thanks and it only works if the duplicated data are clustered , if they are separated it doesn’t work.
I got the same problem, did you solve it?
Thanks for your comments. If you have name in cell A2 and downwards then type 1 in cell B2 and then type this formula in cell B3 and copy the same formula down. =IF(COUNTIF(A$2:A3,A3)=1,MAX(B$2:B2)+1,XLOOKUP(A3,A$2:A2,B$2:B2,-1,0)) This will work even the names are not in order. I will be uploading this video shortly.
This was great how can it be done with 0001 etc
Thank for you the comment. I have uploaded an advanced version of this video which takes care of the unsorted list, see the link in this video description.
If you have 5 cells each one of them value of 2 ... how u get all potential cells that sum of them equal to 8 ??? Using solver please advise
If you have 5 cells each one of them value of 2 ... how u get all potential cells that sum of them equal to 8 ??? Using solver please advise
many Thank Sir Very Helpful and useful
Thank you
Good but when repeat same number the cell become empty, how?????
My god u hv no idea how much u this vid help..i knew how to use if function bt didnt think this way...thanks a lot
Thank you
What about duplicate numbers?
We don't have any control over which one it selects, same setup if we run again, it may give a different solution altogether if available. For the duplicate numbers, if you want to exclude completely, you may do it by adding an helper column with an if condition.
Excellent! 👌🏻
Thank you
Very useful. Thx
Thank you. Really useful❤
Tcrdw
Can't lock them , it says "can't lock merged cells " 😢
not working in decimal figures 😢
It works decimals as well, I have done it many times. Or if you can provide me more details, i can try it.
This is what I'm looking for 10Q
Thank you
Is there a way to see other different possible solutions?
What if your column A contains number that doesn't amount to 52?
It will show as solution not found. To control the time it takes, you may consider entering the maximum time in the options window of the solver.
Thanks 🙏
Awesome video 💕 This is what I'm looking for. Btw, what is the maximum no. of cells in a column for that?
What happens if there are more than one possible solution? How do I see the other possible solutions?
Great! Most useful!
Glad it was helpful!
Completely useless application. You are limited in your search data to 200 values. What kind of accountant works with a data set of less than 200 numbers?
somebody that is not an accountant...