Easily Make a Pivot Table from Multiple Sheets

Рет қаралды 32,442

Kenji Explains

Күн бұрын

Пікірлер: 37

@KenjiExplains 2 ай бұрын

🚀 Take our Data Analyst Program here: www.careerprinciples.com/career-track/the-data-analyst-program

@colorless_76 2 ай бұрын

Is there a discount in any chance?

@jpking0 2 ай бұрын

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!

@KenjiExplains 2 ай бұрын

Great timing then! Glad it was helpful :)

@OmsaiExcelducation-bn7np Ай бұрын

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.

@rumeeburu3648 2 ай бұрын

I’m learning something new because of Kenji. Thank you.

@KenjiExplains 2 ай бұрын

Thank you for watching!!

@MSshorts..-iq7os 2 ай бұрын

Brother what are you doing

@onlyonecjb001 Ай бұрын

Epic. Thank you for sharing the lesson.

@lilyl9306 2 ай бұрын

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!

@KenjiExplains 2 ай бұрын

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.

@AbdulRahman-yp6oy 2 ай бұрын

Excellent Easy explanation ❤❤❤❤

@camlex6310 2 ай бұрын

Superrrr helpful tutorial!! Thanks Kenji

@8ghaly 2 ай бұрын

I have been looking for this tutorial for over a year. Thaaaaaaaank you❤

@KenjiExplains 2 ай бұрын

Awesome thanks for watching!

@jopethmartecio9518 2 ай бұрын

Thank you! I really needed this.

@antoniop.3586 2 ай бұрын

Very interesting Kenji. Thank you very much!!

@ChronosCooper 2 ай бұрын

You earned my subscribe and my respect!

@sivakumarp9956 2 ай бұрын

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

@soyoyeoluwafunso4586 2 ай бұрын

Thisnis great is magical i used this already is a game changer for me

@zmareyshahi 2 ай бұрын

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

@akulakarter6949 2 ай бұрын

Wow! Greate! Thanks. I leraned something new😊

@favourifiok3240 2 ай бұрын

Kenji pls more videos on sql for data analysis

@CideeStudio Ай бұрын

Thank you

@EweTubesBest 2 ай бұрын

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.

@abdelhakimhilmi8923 2 ай бұрын

You're a bless from God 🙏🏼

@markpodesta4605 2 ай бұрын

Thank you. Could PIVOTBY and GROUPBY be used as well?

@Crouch96wtf 2 ай бұрын

Супер полезно !!

@kimthean3518 2 ай бұрын

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.

@helmyhelmy3767 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 ❤