- 216
- 113 026
DSmart Exceller
เข้าร่วมเมื่อ 15 ต.ค. 2017
Microsoft Excel is a very powerful tool in today's business and personal life, for eg: check or curb unnecessary expenses, create analysis,Check progress.
There are drastic changes in Excel from past two decades ,new features like
Power BI,
Power Pivot(DAX formulas),
Power Query
Array formulas
VB
and others have added powerful impact in each individuals life.
The problem is we should know how to use the tools efficiently for desired results.
It is like a mini software that can be developed.
The Creator has found that other videos in TH-cam just cover the surface and do not dive deep into the surface.
The Creator has created videos based on corporate world examples and personal day to day challenges faced in real life.
The creator would love to know any interesting or better ways to create new things in a creative way.
Please comment on any videos if you have a better solution.
Learning is the process which never ends.
Please subscribe this channel if you feel it has a difference.
There are drastic changes in Excel from past two decades ,new features like
Power BI,
Power Pivot(DAX formulas),
Power Query
Array formulas
VB
and others have added powerful impact in each individuals life.
The problem is we should know how to use the tools efficiently for desired results.
It is like a mini software that can be developed.
The Creator has found that other videos in TH-cam just cover the surface and do not dive deep into the surface.
The Creator has created videos based on corporate world examples and personal day to day challenges faced in real life.
The creator would love to know any interesting or better ways to create new things in a creative way.
Please comment on any videos if you have a better solution.
Learning is the process which never ends.
Please subscribe this channel if you feel it has a difference.
CHARTS :X,Y Scatter with straight lines and markers
CHARTS :X,Y Scatter with straight lines and markers
มุมมอง: 41
วีดีโอ
CHARTS: Line with markers for selected data (PMP)
มุมมอง 193 หลายเดือนก่อน
How to have chart lines with markers for particular data for data visualization, planning.
CHARTS : Correlation types in excel graphs
มุมมอง 484 หลายเดือนก่อน
CHARTS : Correlation types in excel graphs
Ratio Analysis : segregating partnership ratios
มุมมอง 77 หลายเดือนก่อน
This video is about segregation or bifurcation of portion to be received by each partner or firm. This tool can be used for any kind of analysis in segregation
Six Sigma-Anova Single factor to find F test
มุมมอง 209 หลายเดือนก่อน
How to find ANOVA, which stands for Analysis of Variance, is a statistical test used to analyze the difference between the means of more than two groups. A one-way ANOVA uses one independent variable, while a two-way ANOVA uses two independent variables
R2 & regression analysis in excel
มุมมอง 1611 หลายเดือนก่อน
This video is the continuation of the previous video on regression analysis. th-cam.com/video/WXyYX83A4qw/w-d-xo.html
Linear Regression: Calculate the point where x and y collide
มุมมอง 18ปีที่แล้ว
This video is for Six sigma black belt, data scientist, statistics where simple way to calculate X and Y collide and how to calculate their collision in a simple way through excel
Histogram: How to analyze data Histogram in Excel
มุมมอง 31ปีที่แล้ว
This video is for Six sigma black belt- how to use Histogram in excel
Correlation: formula and Analysis tool pack usage
มุมมอง 12ปีที่แล้ว
Correlation is a very simple tool, the two easy methods to use and understand correlation is shown in this video.
Sumproduct: How to use and what is the use
มุมมอง 5ปีที่แล้ว
Sumproduct: How to use and what is the use
Comparison without min qty on sheet and 3 variables
มุมมอง 11ปีที่แล้ว
Comparison without min qty on sheet and 3 variables
Comparison for min amount on different columns
มุมมอง 19ปีที่แล้ว
second part in the link below th-cam.com/video/H-bIjx-PRDI/w-d-xo.html
Data entry restriction in cells -for template -vid 3
มุมมอง 12ปีที่แล้ว
How to restrict users in an excel template, so users can fill relevant information and don't misuse with wrong information
Data entry restriction in cells -for template -vid 2
มุมมอง 8ปีที่แล้ว
How to restrict users in an excel template, so users can fill relevant information and don't misuse with wrong information
Data entry restriction in cells -for template -vid 1
มุมมอง 14ปีที่แล้ว
Data entry restriction in cells -for template -vid 1
Match or XMatch -The easy way to compile report from different sheets- vid 2
มุมมอง 79ปีที่แล้ว
Match or XMatch -The easy way to compile report from different sheets- vid 2
Match or XMatch -The easy way to compile report from different sheets- vid 1
มุมมอง 27ปีที่แล้ว
Match or XMatch -The easy way to compile report from different sheets- vid 1
Break Even Point :BEP How to get a break even Full Video -Vid 3
มุมมอง 15ปีที่แล้ว
Break Even Point :BEP How to get a break even Full Video -Vid 3
Break Even Point :BEP How to get a break even -Vid 2
มุมมอง 10ปีที่แล้ว
Break Even Point :BEP How to get a break even -Vid 2
Break Even Point (BEP) How to get a break even in Excel ? -Vid 1
มุมมอง 42ปีที่แล้ว
Break Even Point (BEP) How to get a break even in Excel ? -Vid 1
Use of Subtotals and how to replace formats ?
มุมมอง 30ปีที่แล้ว
Use of Subtotals and how to replace formats ?
Cond format :How to select whole row for single word inside two descriptions Vid 3
มุมมอง 6ปีที่แล้ว
Cond format :How to select whole row for single word inside two descriptions Vid 3
Cond format: How to highlight a whole row for one word in a description vid 2
มุมมอง 102 ปีที่แล้ว
Cond format: How to highlight a whole row for one word in a description vid 2
Cond format: Highlighting specific text in color- Vid 1
มุมมอง 12 ปีที่แล้ว
Cond format: Highlighting specific text in color- Vid 1
Standard deviation and Variance- difference in Population & Sample
มุมมอง 72 ปีที่แล้ว
Standard deviation and Variance- difference in Population & Sample
What is Standard deviation or sigma in simple lay man terms?
มุมมอง 222 ปีที่แล้ว
What is Standard deviation or sigma in simple lay man terms?
Cond format :Highlight Rows Based on a Cell Value in Excel-Simple
มุมมอง 202 ปีที่แล้ว
Cond format :Highlight Rows Based on a Cell Value in Excel-Simple
Cond format :Highlight rows based on a cell value in excel -Standard formula
มุมมอง 292 ปีที่แล้ว
Cond format :Highlight rows based on a cell value in excel -Standard formula
Thanks you very much !
Helped me. thanks. you could have shortened your vdo though.
Definitely
Unfortunately, this does not work for data that have more than 2 merged cells.
Hi
Do you have time to help on a similar case. I'll pay for that> plz reply.
Hai Abdullah, similar case like, can you please elaborate ?if I can I will defiantly help
Well explained but where is the quantity of description and how to add
👍
The video sound is not ok
He wasted 11mins of our time
Thank You
Simple approach to a complex problem, thanks for sharing bro!
Please how do you add the subtotals under the groups? to make it look like subtotals im Excel
Please check the link below th-cam.com/video/p3SVPD9DnWk/w-d-xo.html
Thanks a lot
Can you recomend a book about Loops ?
Thanks a lot ....
DISASTER...………………………………………...
Really this is very help full for me... Infinite like for this video
Can you explain the rule? Need the basic
You were not very clear in yoru communication, you got to be a bit more slow
sure sir
thanks kind man.
Thanks Sir
Welcome
DEAR VIDEO QUALITY IS VERY LOW. NOT ABLE TO SEE FORMULAS U APPLIED
How to find for colums bro?
Hi Bro, check this link, the vid is made for your knowledge th-cam.com/video/XOh6Y3aiLM8/w-d-xo.html
For columns?
Superb
Thanks 🤗
I think this is because excel don't know for sure which value to transfer as the merged column contains different types of data
Thank you brother, you s saved me a lot of time.
how to skip zeros in this format
Hi Sir. Can You please teach how and where to use list and table in power query?
Hi Aleksandr, Table can be used to future works after compiling the data base. list is a way to copy some required columns for any purposes. I will make a video on how to use tables and later re use it. Thanks for the comment.
Bade beware ki trha smjhaye ho yr. Koi interest he nai aya samjhane me.
tum pagal khane jaooo...........Jahil namoona
Hi am trying to merge a column from a excel sheet which contains numbers(date) and text both for which it's not extracting any data in this columns and showing errors 'cannot be converted to numbers'... Pls suggest solution to this
Hi Raghavendra, Happy new year, I hope u have cracked the above query, if not this link might help. th-cam.com/video/qO11SU215YM/w-d-xo.html
Tanks a lot for your superb way of explaining a problem I struggled with quite some time. Keep your good advice up
Is table me jo drop down me jo filter ate hai uske bare me batay ya apka numbr send kare
Filters ke liye appko home ya data me sort & filters click karna padega. Cursor ko upar top me rakhey
Hi, Audio is very low.... cant here .....
This video provide PQ extensive knowledge; but kindly request you to post short video of 5-8 minute.