This is perfect info, as I currently have to do this pulling financial data monthly, and usually just combined globs of annual data all into one sheet. This way I can just pull the data and add it on as separate files, so thank you!
Hello Kenji! I love your teaching style. You always use clear and vivid examples, making the lessons easy to understand and thoughtfully delivered. As a loyal fan, I’ve bought several bundles. I wanted to ask if it would be possible to update the courses in bundles such finance analyst course content periodically if needed-I’m eager to keep learning more from you!
Hi there! Yes, 2 months ago we updated the Excel for Business & Finance course, 6 months ago we updated the Power BI course, and our SQL, Python, M&A, LBO, finacial accounting, and recruiting courses were released less than one year ago. Whenever there's large updates to any of these softwares, we also include new lessons for that. For example, Excel recently released functions, so we added those as bonus lessons. We will continue to do so with all our courses.
Hi Kenji, Your presentation is perfect, its pitch perfect, and to the point explanation. Please keep up the good work BTW, can you please upload videos on - Expectation on Grocery Pick List [Requirement] as below: 1. User opens google sheets in mobile 2. selects items like diary products--> curd, butter, ghee; fruits--> apple , orange, mango, banana,; vegetables--> potato, onion, tomato, ginger [spice], green chilies, cabbage; beverages--> coffee, tea, happiness drink, malt drink; cold drinks--> Mr. Pepper [soda], Lemonade, fruit drink [some brands], as drop down list, as dependent list because new entries of the list should get added too 3. Select the Quantity as 1, to 10 as drop down list 4. Select the Weight as 1Lbs, or grams, box, ounce, piece 5. Price: auto filled based on the previous selection say for example: if Product, selected as curd, vegetable as selected as potato, beverages selected as happiness drink, cold drinks selected as fruit juice, then the each filler should display the price and sum up as it gets added Note: some logic to ensure that this the final for the time date purchased and an auto mail or whatsapp push to the email id or mobile or cell number with auto generated unique OTP and the summary of the purchase Last but not the least if a dashboard is done based on the purchases made by date, which will be good for analysis of data based on entries made by the user and can suggest tips to improve his/her grocery list This should work in PC as well mobile phones- requested Thanks
I truly appreciate the valuable content you provide; your videos are a lifesaver! I'm very interested in joining your data analyst course, but the course fee of $450 is equivalent to about seven months of my salary. This amount is particularly challenging for me, as my annual income is low and I work from 9 AM to 9 PM, sometimes even until 10 PM, with no holidays. It's disheartening to see such a high cost when I’m eager to learn and grow in this field. I hope to see more affordable options in the future
At least in my version of Excel, PowerQuery won't let me load the tables as a data source when I'm working from the workbook AS the data source. I have to open a new workbook, and use the attached example. "... because it is being used by another process". However, clicking on the Table, Data Tab> Get New Data from Table/Range, will load table into power query.
Hi, Kenji I really need your help!!!! Do you know is there a way that I could do for example: I have lots staff and they each have their own position in total : 9 positions, each staff will be promoted based on how many years they work in each position. and I want those 9 specific position to set with years like if position 1 work more than 2 years I want it to be color highlight but the thing I know how to do it with one position but not more than 2.
Hello, one question, when u double click a number in the pivot table, a new sheet opens, is there any way for this sheet to automatically have a number format (a coma & decimals) ? Thanks for your content really helps ❤
🚀 Take our Data Analyst Program here: www.careerprinciples.com/career-track/the-data-analyst-program
Is there a discount in any chance?
I am India but understand very clear what you speak in video. WOW all the lecture is best of best and of course i want to wish you very good luck.
This is perfect info, as I currently have to do this pulling financial data monthly, and usually just combined globs of annual data all into one sheet. This way I can just pull the data and add it on as separate files, so thank you!
Great timing then! Glad it was helpful :)
I have been looking for this tutorial for over a year.
Thaaaaaaaank you❤
Awesome thanks for watching!
I’m learning something new because of Kenji. Thank you.
Thank you for watching!!
Brother what are you doing
Hello Kenji! I love your teaching style. You always use clear and vivid examples, making the lessons easy to understand and thoughtfully delivered. As a loyal fan, I’ve bought several bundles. I wanted to ask if it would be possible to update the courses in bundles such finance analyst course content periodically if needed-I’m eager to keep learning more from you!
Hi there! Yes, 2 months ago we updated the Excel for Business & Finance course, 6 months ago we updated the Power BI course, and our SQL, Python, M&A, LBO, finacial accounting, and recruiting courses were released less than one year ago. Whenever there's large updates to any of these softwares, we also include new lessons for that. For example, Excel recently released functions, so we added those as bonus lessons. We will continue to do so with all our courses.
Epic. Thank you for sharing the lesson.
Hi Kenji, Your presentation is perfect, its pitch perfect, and to the point explanation. Please keep up the good work
BTW, can you please upload videos on - Expectation on Grocery Pick List [Requirement] as below:
1. User opens google sheets in mobile
2. selects items like diary products--> curd, butter, ghee; fruits--> apple , orange, mango, banana,; vegetables--> potato, onion, tomato, ginger [spice], green chilies, cabbage; beverages--> coffee, tea, happiness drink, malt drink; cold drinks--> Mr. Pepper [soda], Lemonade, fruit drink [some brands], as drop down list, as dependent list because new entries of the list should get added too
3. Select the Quantity as 1, to 10 as drop down list
4. Select the Weight as 1Lbs, or grams, box, ounce, piece
5. Price: auto filled based on the previous selection
say for example: if Product, selected as curd, vegetable as selected as potato, beverages selected as happiness drink, cold drinks selected as fruit juice, then the each filler should display the price and sum up as it gets added
Note: some logic to ensure that this the final for the time date purchased and an auto mail or whatsapp push to the email id or mobile or cell number with auto generated unique OTP and the summary of the purchase
Last but not the least if a dashboard is done based on the purchases made by date, which will be good for analysis of data based on entries made by the user and can suggest tips to improve his/her grocery list
This should work in PC as well mobile phones- requested
Thanks
I truly appreciate the valuable content you provide; your videos are a lifesaver! I'm very interested in joining your data analyst course, but the course fee of $450 is equivalent to about seven months of my salary. This amount is particularly challenging for me, as my annual income is low and I work from 9 AM to 9 PM, sometimes even until 10 PM, with no holidays. It's disheartening to see such a high cost when I’m eager to learn and grow in this field. I hope to see more affordable options in the future
Excellent
Easy explanation
❤❤❤❤
Superrrr helpful tutorial!! Thanks Kenji
Thisnis great is magical i used this already is a game changer for me
Thank you! I really needed this.
Very interesting Kenji. Thank you very much!!
Kenji pls more videos on sql for data analysis
You earned my subscribe and my respect!
Wow! Greate!
Thanks.
I leraned something new😊
Thank you
You're a bless from God 🙏🏼
At least in my version of Excel, PowerQuery won't let me load the tables as a data source when I'm working from the workbook AS the data source. I have to open a new workbook, and use the attached example. "... because it is being used by another process". However, clicking on the Table, Data Tab> Get New Data from Table/Range, will load table into power query.
Thank you. Could PIVOTBY and GROUPBY be used as well?
Hi, Kenji I really need your help!!!! Do you know is there a way that I could do for example: I have lots staff and they each have their own position in total : 9 positions, each staff will be promoted based on how many years they work in each position. and I want those 9 specific position to set with years like if position 1 work more than 2 years I want it to be color highlight but the thing I know how to do it with one position but not more than 2.
Супер полезно !!
From two sheets which have different data where only one column name id was same is it possible to combined pivot
Hello, one question, when u double click a number in the pivot table, a new sheet opens, is there any way for this sheet to automatically have a number format (a coma & decimals) ? Thanks for your content really helps ❤
Any discount
Great sir! But I am waiting for python tutorial best of luck for that
Awesome will keep it noted!
can you make a full pivot table vidoe?
Got a few on the channel check it out!
and retro function. Wizard Pivot Tables from a few diapason consolidation.... but it's difficult and not comfy