Thanks Chandoo - I've watched many of your shorter videos and find them very helpful and enjoy the entertaining style so I am trying to this longer version one!
Thank you so much Chandoo - ppl may not realize the effort & time it goes into understanding the data then, making a script and then recording video. You're doing noble work for beginner DA!
In Pakistan Study we studied that Indians are our enemies but believe me you are the great teacher and i learn much more from Indian instead of Pakistan. Love from Dubai
if you're watching this and finding it difficult to memorize the CTRL + SHIFT + 4 or CTRL + SHIFT + 3, he stated earlier.......... Just remember that the number key stands for what it does. 4 is USD when u press shift
"Awesome video! I am a financial analyst myself. Instead of data, I focus more on numbers…. However, I would say I would have done things about 85% similar to what you did, with a few exceptions in terms of formulas. I might not have used power query, although that's the purpose of the video. It's amazing how much we have learned, and you don't even realize your own knowledge until you watch a video and find yourself predicting the actions before they are even performed! Great video!"
Hey Buddy! This is my transcript. A. Did google Analytics Course B. Did from Udemy “The Complete Financial Analyst course 2023” C. Studied Business Management/Accounting D. MBA in Finance Current Tittle: Financial Analyst for Central America & Caribbean at a S&P 500 company. If you have a degree plus good excel skills, and a good understanding of $$$ and/or ### you can have a great carrer! Yet without school degree, you will have to start from rock bottom and prove yourself up!
Thank you so much, brother. The thing I like about you is that you teach from the basics and share your different perspectives while analysing. May you get your reward in double for the amount of effort you put into this video.
One of the best tutorials by far because you took several steps further from simple lookup formulas and other type av what I call "typical" tutorials that you can find in most channels. Extremely insightful and useful since it can be used in a lot of business situations when you work in this type of environments. A big thank you from Sweden!
💥SAMPLE FILES & CHAPTER MARKERS 📁 Sample files: Blank data file (perfect for following along) - chandoo.org/wp/wp-content/uploads/2023/06/blank-data-file.xlsx Completed workbook - chandoo.org/wp/wp-content/uploads/2023/06/data-analysis-03.xlsx ⏱ Video Timestamps: ================== 0:00 - Introduction & Topic Coverage 1:50 - Data Cleaning with Excel 6:17 - Ad-hoc Analysis of Data 10:23 - Using Power Query to combine & clean data in one go 21:25 - 5 Business Questions for Data Analysis 23:12 - Quick Analysis of Data - Summaries & Statistics 31:17 - Building an information finder using Lookup Formulas 36:59 - Information Finder v2.0 41:43 - Male vs. Female Comparison with Pivots 48:15 - Calculating Bonus based on Business Rules 51:03 - 4 Data Visualization Themes 52:46 - Understanding the salary spread with histograms & box plots 59:50 - Salary vs. Employee Rating Correlation 1:08:50 - Employee Trend over time 1:19:19 - Creating a Report Card to compare NZ vs. India
Analysis Adhoc Row bottom of columns 6:32 Total 6:54 Average salary Shortcuts formatting 7:21 Currency: Control Shift 4 8:21 Dates: Control Shift 3 Combining Two tables: 11:32 Into Power Query 13:00 Duplicate 13:28 With second duplicate selected, in formula replace name with name of other table. Now the second duplicate will show the other data. Re name it. 14:06 First data selected: Add column with country of that data. To identify that data is from that country for example. Repeat for second. 15:30 Combining tables; Append queries as new: Can then name it staff rather than each country Clean up: 16:26 Remove duplicates 17:33 Values missing: Right click: Replace values: Replace "Null" with "Other" Close and Load: 19:25 Close and Load to: New connection: Only create connection In Excel: New tab called all staff In all staff tab: Add in the "Staff" from queries: Right click: Load to: Table in existing worksheet
Kindly tell me about power query topic when we apply from table / Range then show me large formula bar not like sir chandoo formula and not change the india _ staff formula
I can view the formula bar in 13.28 but the contents are different, it was displaying the headers of the table and I am finding it difficult to edit as it does not show NZ_staff instead it displays all table headers.
Chandoo, bless you and your family. This is an incredible tutorial, I can't thank you enough. Aiming to transition from Carpentry into Data Analysis shortly and you've helped me immensely.
Thank you chandoo for making this video👍..a genuine request from my end is that i want you to make more videos about how data analyst's are using excel, SQL, python and power BI/tableau and using other tools/ techniques to solve the problems (like an end to end video) . Because these kind of videos will help everyone to get more clarity on how data analyst's get things done.
I loved this video. As i am learning to be in the field of data analyst i have already gone through all your videos but this is the best and most helpful as it gives the idea of working in a data set in real life rather than other videos which is more specific in certain topic Please make this kind of videos which is summary of all the topics❤
Hi Chandu! I'm very thankful for your videos. My excel knowledge was zero and now I'm getting much better through your videos. And I love your explanation :-)
Thank you so much! I really appreciate that you went through the whole project and explained so clearly as it progressed. Your teaching method is great!
Awesome tutorial. Thank you so much for being clear and detailed in what you are doing (the steps) and telling us different ways we can analyze the data.
The best tutorial no doubt you are just amazing. Well explained, clear what steps we have to take in each next minute and how we have to move on each analysis. Just make more videos bro
Thank you chandoo in this video the every part is explained so clearly. Please make such videos more whenever you are available. Once again thank you for your content. Keep it as always😃
Dear Sir, without any question this video is simply great, I have a request, would you please have a video for us in which explain every chart by example avaiable now a days for visualization, i.e. scatter plot, histogram. temp, box................... please accept my Thank you in advance.
Helloo. Thank you very much for this tutorial, i recently came across it and find it very helpful, but i am stack at where you combined (Time on the video 10:30 +) the two tables ( New Zeland and Indian data). i can't find the tool to help with combining the tables togerther. i am using excel 2010. Are you using same verson or a higher version of excel. dose this have to do with compartibility or not. kindly help me.
I have FILTER and CHOOSE function in my excel, But CHOOSECOLS not showing. Is there any other formula to extract column that you did on information finder2.0 at time 39:46 instead of using CHOOSECOLS? Edited: I did it with this formula (SORT(FILTER(FILTER(All_stuff[[Name]:[Salary]],All_stuff[Department]='Information finder'!D8),{1,0,0,1,0,0,1}),3,-1)) but it does not sort column order as yours as 1, 7, 4, it returns 1, 4, 7.
Excellent video. Thanks for your efforts. Am about to put together something similar where my client wants to consolidate a bunch of stuff from social media and more. How about some direction for a front end method of updating those tables with new weekly or monthly data
Thank you so much for this awesome video. I am having trouble with the choosecols function. It probably has something to do with my excel version because I don’t have the function. Is there a way to bypass it or an alternative?Thank you!
I'm using excel office 2021. is there any alternative to the filter function? Thanks in advance. This tutorial is superb. Thank you very much Chandoo..God speed
Sir please One detailed video on chatGPT code interpreter or future AI tech will replace data analyst or not ? Replacement in the sense 1 Analyst required against 10 Please make this video for future of us, thanks in advance
Thanks for the video, it's very interesting. If you need to add more data to the tables that needs to be cleansed, what is the easiest way to do this? Thanks
It is very easy to remember ctrl+shift+3="date formatting",ctrl+shift+4="currency formatting" consider english alphabets A=1,B=2,C=3,D=4 so for d(d)ate formatting here it is ctrl+shift+3 .....d=3 so for c(c)uurrency formatting here it is ctrl+shift+4.......c=4 just reverse the values ....
Or, you could look at the symbols on the numbers. Shift 4 is $ symbol, which is for currency Shift 3 is # symbol, so numbers -> date shift 5 is percent, so percentage formatting shift 2 is @, so time formatting.
thanku sir for one of the most amazing tutorial .it revises many of steps that are always needed in data analysis love your videos thnaku for your efforts love from India😇
Hello Chandon, thank you for this incredible tutorial, I find your videos very helpful. Quick one! I’m stuck, I’m trying to load my data into power query and I can’t seem to locate the ’From Table/Range’ icon on my Data ribbon. Please I need your help on how to locate it on my excel version. Thank you.
Count the number of >90k =Countifs(staff[salary],">90000") Count the salary Ratio-- Count the number of >90k/Count the salary Then covert into ratio Ctrl+shift+5
@@surbhirautaray6872 ah thanks. I divided formula for 63 by formula for total staff count. Then I clicked the percent icon present in the ribbon in Home tab.
@chandoo Thank you very much chandoo. please I am stuck because as I got to 13:28 With second duplicate selected, in formula replace name with name of other table. Now the second duplicate will show the other data. Re name it. I followed your step but it didn't work on my excel. This was the result Expression.Error: We couldn't find an Excel table named 'india_staff'. Details: india_staff. and I used the correct command = Excel.CurrentWorkbook(){[Name="india_staff"]}[Content]. Please assist
When I tried to roundup the decimal points at the timeframe of 50:12, instead of zeros disappearing it is showing as .00 (2 zero decimal points). Is there any alternative formula for this?
you are amazing sir, lots of love from Pakistan( Peshawar City), Sir I have face a Problem I started Data science so which Topics I will learn in excel for data science or data analysist
@Chandoo, I am stuck in VlookUp (time stamp "34:02"). Please help me out. I am unable to get the results for Vlookup. My formula is: =XLOOKUP(K17, Staff(Name), Staff((Gender):(tenure))). I am using the same table and the same sheet. I have paused the video and copied the formula, still facing same issue such #REF!. Hoping for a reply
@@chandoo_ Thank you very much for your prompt response. I will study it carefully because I am a beginner diving into the field of data analysis. I initially struggled with the appendic step, so I had to rest and come back to it. I finally got it. And the assignment, "How many employees earned more than $90,000 and the ratio". I used the Countifs function =Countifs(F:F, < "90,000") and got 121 and 66% respectively.
Thanks Chandoo - I've watched many of your shorter videos and find them very helpful and enjoy the entertaining style so I am trying to this longer version one!
You are welcome @Hopspowered. Thanks for the super too 😍
Where can I get this data used on this example?
Thank you so much Chandoo - ppl may not realize the effort & time it goes into understanding the data then, making a script and then recording video. You're doing noble work for beginner DA!
Amen
In Pakistan Study we studied that Indians are our enemies but believe me you are the great teacher and i learn much more from Indian instead of Pakistan. Love from Dubai
We Indians(99.90%) don't hate Pakistanis, we always doubt your Dictator Army Chief. Your Army Chief is damaging our relationships.
if you're watching this and finding it difficult to memorize the CTRL + SHIFT + 4 or CTRL + SHIFT + 3, he stated earlier.......... Just remember that the number key stands for what it does. 4 is USD when u press shift
Great tip. That is how I remember it too.
Count number of >90k$ staffs: =COUNTIFS(Employee[Salary],">90000"), and the ratio is number of >90k$ staffs/ count of staffs ~= 34%
Thanks I was struggling to find the right formula
thanks for the formula, but may I ask. why do we put quotation marks on >90000, isn't quotation marks used to input strings with text type only?
@@enisusilowati8549 you mixing SQL with Excel
instead using COUNTIFS you use =COUNTIF(Employee[Salary], ">90000")
"Awesome video! I am a financial analyst myself. Instead of data, I focus more on numbers…. However, I would say I would have done things about 85% similar to what you did, with a few exceptions in terms of formulas. I might not have used power query, although that's the purpose of the video. It's amazing how much we have learned, and you don't even realize your own knowledge until you watch a video and find yourself predicting the actions before they are even performed!
Great video!"
Hello want to become a financial analyst myself , what courses + skillset will you recommend I learn ? Would be grateful for the information...
Hey Buddy!
This is my transcript.
A. Did google Analytics Course
B. Did from Udemy “The Complete Financial Analyst course 2023”
C. Studied Business Management/Accounting
D. MBA in Finance
Current Tittle: Financial Analyst for Central America & Caribbean at a S&P 500 company.
If you have a degree plus good excel skills, and a good understanding of $$$ and/or ### you can have a great carrer!
Yet without school degree, you will have to start from rock bottom and prove yourself up!
Thank you so much, brother. The thing I like about you is that you teach from the basics and share your different perspectives while analysing. May you get your reward in double for the amount of effort you put into this video.
One of the best tutorials by far because you took several steps further from simple lookup formulas and other type av what I call "typical" tutorials that you can find in most channels. Extremely insightful and useful since it can be used in a lot of business situations when you work in this type of environments. A big thank you from Sweden!
💥SAMPLE FILES & CHAPTER MARKERS
📁 Sample files:
Blank data file (perfect for following along) - chandoo.org/wp/wp-content/uploads/2023/06/blank-data-file.xlsx
Completed workbook - chandoo.org/wp/wp-content/uploads/2023/06/data-analysis-03.xlsx
⏱ Video Timestamps:
==================
0:00 - Introduction & Topic Coverage
1:50 - Data Cleaning with Excel
6:17 - Ad-hoc Analysis of Data
10:23 - Using Power Query to combine & clean data in one go
21:25 - 5 Business Questions for Data Analysis
23:12 - Quick Analysis of Data - Summaries & Statistics
31:17 - Building an information finder using Lookup Formulas
36:59 - Information Finder v2.0
41:43 - Male vs. Female Comparison with Pivots
48:15 - Calculating Bonus based on Business Rules
51:03 - 4 Data Visualization Themes
52:46 - Understanding the salary spread with histograms & box plots
59:50 - Salary vs. Employee Rating Correlation
1:08:50 - Employee Trend over time
1:19:19 - Creating a Report Card to compare NZ vs. India
Analysis Adhoc
Row bottom of columns
6:32 Total
6:54 Average salary
Shortcuts formatting
7:21 Currency: Control Shift 4
8:21 Dates: Control Shift 3
Combining Two tables:
11:32 Into Power Query
13:00 Duplicate
13:28 With second duplicate selected, in formula replace name with name of other table. Now the second duplicate will show the other data. Re name it.
14:06 First data selected: Add column with country of that data. To identify that data is from that country for example. Repeat for second.
15:30 Combining tables; Append queries as new: Can then name it staff rather than each country
Clean up:
16:26 Remove duplicates
17:33 Values missing: Right click: Replace values: Replace "Null" with "Other"
Close and Load: 19:25
Close and Load to: New connection: Only create connection
In Excel: New tab called all staff
In all staff tab: Add in the "Staff" from queries: Right click: Load to: Table in existing worksheet
🎉🎉🎉🎉 awesome 😎😎😎😎
Kindly tell me about power query topic when we apply from table / Range then show me large formula bar not like sir chandoo formula and not change the india _ staff formula
@@Sehar3728 if you couldnt able to see the formula bar, in the power query, go to "view" and enable "formula bar"
I can view the formula bar in 13.28 but the contents are different, it was displaying the headers of the table and I am finding it difficult to edit as it does not show NZ_staff instead it displays all table headers.
Chandoo, bless you and your family. This is an incredible tutorial, I can't thank you enough. Aiming to transition from Carpentry into Data Analysis shortly and you've helped me immensely.
After introduction to the topics i realized that this is the most wanted video by me.
Kya jhoot bolta hai
Thank you chandoo for making this video👍..a genuine request from my end is that i want you to make more videos about how data analyst's are using excel, SQL, python and power BI/tableau and using other tools/ techniques to solve the problems (like an end to end video) . Because these kind of videos will help everyone to get more clarity on how data analyst's get things done.
I loved this video. As i am learning to be in the field of data analyst i have already gone through all your videos but this is the best and most helpful as it gives the idea of working in a data set in real life rather than other videos which is more specific in certain topic
Please make this kind of videos which is summary of all the topics❤
Hi Chandu! I'm very thankful for your videos. My excel knowledge was zero and now I'm getting much better through your videos. And I love your explanation :-)
Thank you for being a very few amount of Indian UA-camr that speak in English, you earned m subscribe.
Thank you so much, Chandoo! I really appreciated this more in-depth example of cleaning, analyzing and presenting.
Sir thank you so much for the patience and the teaching. It is amazing. I learn a lot. You have one subscriber .
Thanks!
You are welcome @santhoshnaidu3592 Thanks for the super 😍
sir please make more videos like this one it very very helpful in understanding of how we have to clean ,analyze and present the data
It's the best video I've ever had in Excel so far. The best part is it went through the whole process. I learnt so much! Thanks a million!
This video is going to be the top viewed video on your channel !
This is one of the best data analysis tutorials I hv watched step by step so easy to understand
Thank you so much! I really appreciate that you went through the whole project and explained so clearly as it progressed. Your teaching method is great!
Assalam, Chando, I am your big Fan. God Bless you.
Thank you Chandoo sir. This course is excellent.!! Very concise and organized!!
Sir, it's most awaited video.... Please create more with different dataset... And also guide for interview...
Awesome tutorial. Thank you so much for being clear and detailed in what you are doing (the steps) and telling us different ways we can analyze the data.
The best tutorial no doubt you are just amazing. Well explained, clear what steps we have to take in each next minute and how we have to move on each analysis. Just make more videos bro
Hello Chandoo - I am follower of your website from 10 years. Just discovered you are on YT too...Subscribed!!
how are you so good with excel? how long did it take you to become an expert? i wish i can be at this level one day...
Thank you chandoo in this video the every part is explained so clearly. Please make such videos more whenever you are available. Once again thank you for your content. Keep it as always😃
Hopefully you have a lesson like this for SQL where we can follow what you do on videos, for us to understand regarding the topic.
I do. here it is - ua-cam.com/video/l8DCPaHc5TQ/v-deo.html
Dear Sir, without any question this video is simply great, I have a request, would you please have a video for us in which explain every chart by example avaiable now a days for visualization, i.e. scatter plot, histogram. temp, box................... please accept my Thank you in advance.
I think this video may charge my carrier.🎉❤
You're my idol chandoo, I have learned a lot from your videos. Thank you. Please keep uploading more videos like this.
This is so insightful. I took my time to go through every step. Thank you so much
You're really help many people to share this precious video Chandoo...many thanks. Wish you all the best
Thank you very much, I consider Excel better than I thought.
Masha Allah, He makes everything look easier!!😊
Helloo. Thank you very much for this tutorial, i recently came across it and find it very helpful, but i am stack at where you combined (Time on the video 10:30 +) the two tables ( New Zeland and Indian data). i can't find the tool to help with combining the tables togerther. i am using excel 2010. Are you using same verson or a higher version of excel. dose this have to do with compartibility or not. kindly help me.
When I do Total Row in India Data, it gives me the total of the salaries! Total Row worked perfectly well in the NZ data sheet
You are heaven sent, great work indeed.
Hey,
What a great video made by you...
We actually need these kinds of videos to help us out.
Thank you so much ❤
Thx, a delightful video. learns a lot. Appreciate your efforts to make things simple
This video is well explained, take your medal!!!
Is anything can be more simpler than this? I mean love you 3000. 📙
Really this is an in-depth video and I enjoyed it and learned a lot. Thanks Chandoo
Glad you liked it!
I'm an aspiring Data Analyst and got to know about your channel from @codebasics . You're the best ever Excel teacher Chandoo😄
Very good explanation of real business scenarios. Good job.
thank you, a good refresher, coming from the R world to Excel
Thanks for the knowledge Chandoo sir, May Allah blesses you and your family
Awesome and clear explanation. Really enjoyed it . Thanks for making it.
Thank you for your channel it helps me a lot.... you impart your knowledge well.... God bless you more...
Thank you Sir! You are the gem of a teacher 🙏
I have FILTER and CHOOSE function in my excel, But CHOOSECOLS not showing. Is there any other formula to extract column that you did on information finder2.0 at time 39:46 instead of using CHOOSECOLS?
Edited: I did it with this formula (SORT(FILTER(FILTER(All_stuff[[Name]:[Salary]],All_stuff[Department]='Information finder'!D8),{1,0,0,1,0,0,1}),3,-1)) but it does not sort column order as yours as 1, 7, 4, it returns 1, 4, 7.
same here
Same problem won't do that part though is too messy
very lovely and helpful video.
Thank you chandoo Bhaiya, we love you very much.
Chandoo, excellent course. Namaste
Excellent tutorial Chandoo. Thank you.
Excellent video. Thanks for your efforts. Am about to put together something similar where my client wants to consolidate a bunch of stuff from social media and more. How about some direction for a front end method of updating those tables with new weekly or monthly data
Thank you so much for this awesome video. I am having trouble with the choosecols function. It probably has something to do with my excel version because I don’t have the function. Is there a way to bypass it or an alternative?Thank you!
Thank u chandoo sir. Learnt new things. Plz bring more such videos
Remarkable Video! Thank you so much. It teaches me a lot of things.
Amazing chandoo i really appreciate it!
I'm using excel office 2021. is there any alternative to the filter function? Thanks in advance. This tutorial is superb. Thank you very much Chandoo..God speed
Thank you for this video chandoo sir, I learned a lot from it
Please make video on data analysis using SQL
Fantastic Video. I love your Videos Chandoo!!
Sir please
One detailed video on chatGPT code interpreter or future AI tech will replace data analyst or not ? Replacement in the sense 1 Analyst required against 10
Please make this video for future of us, thanks in advance
As always a great content! Tks Chandoo!
Wow. This my dream course. ❤❤❤❤ Thanks chandoo.
I really enjoyed sir, Thank you for sharing such valuable content, I want learn complex formulas like the way you use in validation etc.,
You're always an expert on it. Just thank you for the knowledge share.
I love your knowledge Chandoo master😍
Thanks for the video, it's very interesting. If you need to add more data to the tables that needs to be cleansed, what is the easiest way to do this? Thanks
It is very easy to remember ctrl+shift+3="date formatting",ctrl+shift+4="currency formatting"
consider english alphabets A=1,B=2,C=3,D=4
so for d(d)ate formatting here it is ctrl+shift+3 .....d=3
so for c(c)uurrency formatting here it is ctrl+shift+4.......c=4
just reverse the values ....
Or, you could look at the symbols on the numbers. Shift 4 is $ symbol, which is for currency
Shift 3 is # symbol, so numbers -> date
shift 5 is percent, so percentage formatting
shift 2 is @, so time formatting.
@@chandoo_ TQ XL GURUJI
thanku sir for one of the most amazing tutorial .it revises many of steps that are always needed in data analysis love your videos thnaku for your efforts love from India😇
You are most welcome
Can you do videos on how to perform Forcasting in excel
Amazing Chandoo, thanks!!
Glad you like it Chris :)
Hello ! About the information finder, we can either use data validation or filter functions right ?
You are really a good teacher
Hello Chandon, thank you for this incredible tutorial, I find your videos very helpful.
Quick one! I’m stuck, I’m trying to load my data into power query and I can’t seem to locate the ’From Table/Range’ icon on my Data ribbon.
Please I need your help on how to locate it on my excel version. Thank you.
What a great video in excel. Thank you so much for this extraordinary video material.
Glad it was helpful!
I always learn some new point which I am going to use inside my reports.
Thanks for your session
Regards
Arif
Genpact India
My pleasure
Thank you! it was very informative!
Count the number of >90k
=Countifs(staff[salary],">90000")
Count the salary
Ratio-- Count the number of >90k/Count the salary
Then covert into ratio
Ctrl+shift+5
han bahut easy hai woh toh
maine bhi kiya hai
63 is the answer??
Yeah right but Should convert into percentage
(63/total staff)×100
@@surbhirautaray6872 ah thanks. I divided formula for 63 by formula for total staff count. Then I clicked the percent icon present in the ribbon in Home tab.
@chandoo Thank you very much chandoo. please I am stuck because as I got to 13:28 With second duplicate selected, in formula replace name with name of other table. Now the second duplicate will show the other data. Re name it. I followed your step but it didn't work on my excel. This was the result Expression.Error: We couldn't find an Excel table named 'india_staff'.
Details:
india_staff. and I used the correct command = Excel.CurrentWorkbook(){[Name="india_staff"]}[Content]. Please assist
When I tried to roundup the decimal points at the timeframe of 50:12, instead of zeros disappearing it is showing as .00 (2 zero decimal points). Is there any alternative formula for this?
Chandoo Sir, choosecols function is not available. how to get it (I am using office 365)
Thanks as always Mr. Chandoo
thank you sir, would you plz tell me how did you added the green bar in power query.
you are amazing sir, lots of love from Pakistan( Peshawar City), Sir I have face a Problem I started Data science so which Topics I will learn in excel for data science or data analysist
Hello Mr Chandoo
Thanks for your presentation & it's possible show Nz VS India (x /Y ) analysis based on Gender/Salary & ratings!
🙌
Thanks Chandoo. Please I don't use excel 365 where can I find the "Get and transform data" part on the data tab for excel 2010?
Amazing tutorial ! thank you for your work
Glad you liked it!
@Chandoo, I am stuck in VlookUp (time stamp "34:02"). Please help me out. I am unable to get the results for Vlookup. My formula is: =XLOOKUP(K17, Staff(Name), Staff((Gender):(tenure))). I am using the same table and the same sheet. I have paused the video and copied the formula, still facing same issue such #REF!. Hoping for a reply
You are using () brackets for table columns.
Use [] brackets. Like this:
Staff[Name]
excellent work sir and sir homework ka answer bhi bta diya karen
Gave me reasons not to use power bi😂
Great work
Thanks 🙏 for sharing the knowledge ☺️
Thank you for the lesson. However, I would like you to explain how to consolidate the two files assuming they have different headings.
Thank you.
You are welcome. For the different header situation, see this - ua-cam.com/video/ECtJQDc8uF8/v-deo.html
@@chandoo_ Thank you very much for your prompt response. I will study it carefully because I am a beginner diving into the field of data analysis. I initially struggled with the appendic step, so I had to rest and come back to it. I finally got it. And the assignment, "How many employees earned more than $90,000 and the ratio". I used the Countifs function =Countifs(F:F, < "90,000") and got 121 and 66% respectively.
However, I am stuck on the second stage: VLOOKUP I keep getting an error message.