I like your presentations a lot as they are not only easy to follow but you have a very convincing attitude. You talk in the right tempo and well-articulated to follow. Your enthusiasm really works! Thank you!
I have worked on pivot tables for quite a few years but I learned quite a few things just from this video!!I like how you explain things short and to the point.I am looking forward to watching some more of your videos!
Finally I used this method for an appropriated P & L, splicing data from two systems a CRM and Sage Accounts 50c! Brilliant! You make me look like a genius at work! Thank You Very Much and in Welsh "Diolch yn fawr i chi"! :)
Nicely presented, Mynda. This should advance acceptance of table based modeling and PivotTables in general. I'd like to remind viewers that a HUGE advantage of PivotTable financial statements in addition to slicers is DRILLDOWN! This is particularly useful when we pull detail actuals directly from our financial systems using Power Query.
Thanks so much, Craig! Indeed, using Slicers to drill down is one of the main benefits of PivotTables...not to mention they are far more robust than any formula based solution.
Yes Craig! The drill down when you double click to see the transactional detail is one of the best parts of having this kind of information in a pivot table! Mynda showed an awesome example of how a P&L can properly look in a pivot table. Love this.
Thank you for the tutorials. Can you please make tutorial on complete accounting process, from Data Entry Transaction to Trail Balance, Income Statement, Balance Sheet and dashboard only by using Tables pivot tables? This will help me and I believe so many other accounting students. Thanks
So many comments in just one day? Yes... it is very efficiently and masterfully done. I followed it. Too bad that the variable were already done, so I could not create them. But very minor element. Working model is convenient too. I will continue with other lessons.
Excellent! I really like that you provided a file so that I could go through the steps myself. I hadn't done this in a while and needed a refresher. I picked up several things that I hadn't known before. Will be checking out more of your content. Thanks.
Great to hear, Brian! Please consider my PivotTable Quick Start course that'll have you up and running with PivotTables in 1.5hrs: www.myonlinetraininghub.com/excel-pivottable-course-quick-start
@@MyOnlineTrainingHub I have a single question if you do not mind , after completing every thing , how can i prevent my dashboard from being change while being used by my manager
@@MyOnlineTrainingHub update...i publish on demand up to 3 years only financial statements nearly 30 divisions using power query to merge chart of accounts, opening balances, current activity, posted and not posted for well over 600,000 transactions. best part is that i can show Financial statements segregated by posted and waiting to be posted so that we can predict what the statements will show once posted. what rakes others a full day, just takes me to refresh and in about 20 minutes its done. who needs college? best bang for the buck for this 40 year accountant are videos like this.
Many thanks for this great tutorial Mynda! I think this P&L report would be easier to read if there was a bit more whitespace between the lines. I strongly prefer to scroll down rather than read scrunched reports (even if the whole report can be seen on one screen). Just some feedback for what it's worth... 🙂
Excelent explanation ! But too nice to be true... if as it is almost always the actual and budget are not different fields but rather one field sorted by year / budget (it is not possible then to calculate the variance )
That is fantastic. Thank you! I spent 2 days doing something similar in Power BI, but this is so much easier! my question is though, when would you choose power bi over excel?
Awesome to hear! I use Power Query whenever I have multiple steps I need to perform to clean data, or if it's something I'm going to want to do again when new data gets added to the source I'm referencing. If it's a one time and done task, then I'll probably use one of the Excel tools.
You have put an end to my worry with this video. I have been looking for a simple way to automate my month-end report. I have used this knowledge together with power pivot and power query in my current work to prepare some important reports. Please, is there a way to manually edit the value fields may be during a management meeting(adjust the values). You are great. Thanks and Thanks. Problem solver.
Thank you mam. Today i practiced everything shown in the video and learned new formatting technique to present report. If you know that in india most of the companies use either SAP accounting or Quickbook or Tally and dld reports in csv or excel file. From this i learned how to present report in structured and in cleaned manner. Thank you mam
I love you 💕💕 I've developed a P&L that uses some source data from an SQL database (the P&L can be different as I work with different companies. This could just give me the 'portable' solution I need . Thank you
@@MyOnlineTrainingHub I've got a question. Related to my comment above. I'm finding the performance of a pivottable version of my previously created P&L is significantly quicker at updating than my pivottable alternative (using your great video above). Any tips on how to make it almost instant with ~1600 rows of source data? (Note I'm also bringing in my financial period data for the entire FY)
I have learned a lot of ins and outs of pivot tables from your videos. There is one thing that has me totally baffled. In a pivot table P&L, how do you subtotal items that have several components such as "Auto Expense:Fuel" "Auto Expense:Repairs" "Auto Expense:Registrations". I tried to insert a calculated item to sum these items BUT the subtotal for "Auto Expense" adds itself to the expense total and essentially doubles the auto expense. There has to be a way to accomplish this to show a subtotal for multiple related items. ie. Insurance:General, Insurance:Professional Liability etc.
You can try grouping the items, or add another column to your source data for this intermediary group as shown here: www.linkedin.com/posts/myndatreacy_excel-excel-activity-7018580085964242944-ww9y
Hi Mynda.. this is excellent. I've been looking for a quick tutorial on this. You made it nice and easy. One thing I learned that might help others.. if you need to modify your Calculated Fields.. start w/pointer in Pivot Table => PivotTable Analyze => Fields, Items & Sets => Calculated Field.. then from the Name Field, click on the downward facing arrow on the right side of the Name Field to reveal the field list of the Calculated Fields you have created. From there, you can select the one you want to edit, delete, etc. Seems like a simple and or obvious thing, but I kept getting tripped up by clicking into the Fields list to try and select a Calculated Field to modify or delete.. does not work.. must be selected from the drop down. Thanks again for this great video. Really learned a lot and is super useful and immediately applicable to my work. Thumbs up!! PS - Also.. love your tip below to Signal Mas re. dynamic titles.. super!! :))
Glad you can use it, Zubair. If you have messy data you can clean it first with Power Query. Here's an example of using Power Query to unpivot data: ruclips.net/video/-IMqkg35adA/видео.html
Hi, Thank you for the tutorial. It is very clear and informative. Can we add subfields in the pivot table? Income - COGS = Gross profit. After the Gross profit level, I want to give the break up of expenses. The heading should be "Less Operating Expenses" and under this group A) Staff Costs and under this, there will be accounts. Then " B) Rent Expenses" and under this, there will be all the rent expenses. Thank you
Thanks a lot for the useful tutorial! A quick question, please: if I added a row of Net Profit as a calculated item and now I would like to add Net Profit percentage (from Revenue) also in a row, how do I do it correctly so it will not summarize all percentages below on the total level?
You can't add the percentage as another item, you'd have to add it in a separate column and use the 'Show Values As' setting as explained here: www.myonlinetraininghub.com/show-values-as-percentage-of-another-pivottable-column-total
@@MyOnlineTrainingHub thank you for your reply, but I need it in row not in column, that's the issue. In columns I have years and in rows all P&L accounts, like revenue, cogs, opex, fin. exp., etc. and the net profit is calculated in rows as well. Thanks again!
Very interesting techniques. Congratulations. Loved it. I have a question: If you have the data separated by month, how do you do this report for a year-to-date period? Regards and thank you very much for asking my question.
Great to hear! If your data is separated by month then you need to consolidate it into a single table. You can use Power Query to do automate this. Depending on how it's separated, you might find this useful: ruclips.net/video/YOC-pEIuHpA/видео.html
A good everyday use of Excel: working with P&L statements. Thanks for the real life, down-to-earth demo.
Thanks! Glad you liked it :-)
Yes thank u..can u show the balance sheet also...
I like your presentations a lot as they are not only easy to follow but you have a very convincing attitude. You talk in the right tempo and well-articulated to follow. Your enthusiasm really works! Thank you!
Thanks! Glad you like them, Perry :-)
I learned more from an eight minute video than multi hour courses I take on other sites. Thank you!
Wow! So pleased you're getting value from my videos :-)
I have worked on pivot tables for quite a few years but I learned quite a few things just from this video!!I like how you explain things short and to the point.I am looking forward to watching some more of your videos!
Glad it was worth your time to watch, Yvette!
Mynda, you have so sweet voice and you are giving information so clear, so I have no words, it makes 100% sense
Thanks so much!
Finally I used this method for an appropriated P & L, splicing data from two systems a CRM and Sage Accounts 50c! Brilliant! You make me look like a genius at work! Thank You Very Much and in Welsh "Diolch yn fawr i chi"! :)
Congratulations, Sam!
Exactly what I needed to do. Sage 50 + Budgets + CRM. Brilliant.
you literally saved my career...i have been stuck since Jan and now you just got me free
Wow, so pleased I could help :-)
Absolutely loved this one. Previously I have prepared P&L statement using the getpivotdata function. But this solution is simpler and more effective.
Great to know you can use it!
The best person to learn from. I have built my P&L sheet in 15 mins and now it looks so professional. I am so grateful to you.
Wow, that's awesome to hear!
Never been this excited for learning something from someone. Thank you.
Wow, so pleased to hear that, Firoz! Have fun with Power Query :-)
Nicely presented, Mynda. This should advance acceptance of table based modeling and PivotTables in general.
I'd like to remind viewers that a HUGE advantage of PivotTable financial statements in addition to slicers is DRILLDOWN! This is particularly useful when we pull detail actuals directly from our financial systems using Power Query.
Thanks so much, Craig! Indeed, using Slicers to drill down is one of the main benefits of PivotTables...not to mention they are far more robust than any formula based solution.
Yes Craig! The drill down when you double click to see the transactional detail is one of the best parts of having this kind of information in a pivot table! Mynda showed an awesome example of how a P&L can properly look in a pivot table. Love this.
Thank you for this, you won't believe I have spent years trying to figure this out. This will make my reporting easier. Thank you once again.
Glad you’ll find it helpful 😊
Thank you for the tutorials. Can you please make tutorial on complete accounting process, from Data Entry Transaction to Trail Balance, Income Statement, Balance Sheet and dashboard only by using Tables pivot tables? This will help me and I believe so many other accounting students. Thanks
Thanks for the suggestion, Irfan!
OMG - you are a genius. How much time have I wasted? Insane. This is a turbocharged video. I'm ashamed I'm so stupid.
So pleased it will be helpful. Better to discover it late than never 😉
I am an accountant but I never used advance level of pivot, I really appreciate you for doing video on pivot & expecting more of these.
Great to know you appreciated it :-)
So many comments in just one day? Yes... it is very efficiently and masterfully done. I followed it. Too bad that the variable were already done, so I could not create them. But very minor element. Working model is convenient too. I will continue with other lessons.
Glad you liked it. Not sure what you mean by 'variable were already done'?
Excellent! I really like that you provided a file so that I could go through the steps myself. I hadn't done this in a while and needed a refresher. I picked up several things that I hadn't known before. Will be checking out more of your content. Thanks.
Great to hear, Arthur!
You are a genius! Not kidding...this is brilliant stuff. Thanks for introducing me to a new concept. Jim in FL
Wow, thanks so much!
Fabulous video....your style is so clear and helpful...thank you!
Thanks for your kind words! Glad it was useful 😊
Thank you again Mynda! Yours are the only courses that I binge watch! LOL!
:-D wow, thanks!
Thank you very much for your extra input. Everything works great now!
Great to hear!
Thank you so much for this. I wish i could like this video a thousand times. Wheew!!
Thanks so much, Aine! 😊
She is a very good teacher. Best wishes for her.
Thanks so much!
Thanks so much for this. Pivot tables is something I need to get to grips with and your video will help me a lot going forward! Just brilliant!
Great to hear, Brian! Please consider my PivotTable Quick Start course that'll have you up and running with PivotTables in 1.5hrs: www.myonlinetraininghub.com/excel-pivottable-course-quick-start
That is actualy amazing i realy injoy that , now every night before sleep i have to watch you
Glad you enjoyed it 😊
@@MyOnlineTrainingHub I have a single question if you do not mind , after completing every thing , how can i prevent my dashboard from being change while being used by my manager
Finally an easy understandable discussion on calculated items
So pleased to hear that 😊
@@MyOnlineTrainingHub update...i publish on demand up to 3 years only financial statements nearly 30 divisions using power query to merge chart of accounts, opening balances, current activity, posted and not posted for well over 600,000 transactions. best part is that i can show Financial statements segregated by posted and waiting to be posted so that we can predict what the statements will show once posted. what rakes others a full day, just takes me to refresh and in about 20 minutes its done.
who needs college? best bang for the buck for this 40 year accountant are videos like this.
Dear Mynda, thank you so much for sharing your expertise and knowledge to a new learner like me, you are truly an expert, four thumbs up :D
Thank you so much. Lily!
Thank you so much! I'm preparing for an interview that I'm really excited about and this gave me a ton of confidence and knowledge :)
Great to hear! Good luck with the interview!
I always get amazed with your knowledge and skills. They are very easy to follow as well. 😄
Thanks so much!
Excellent tutorial. You are a genius. Thanks a lot for sharing.
Thanks for watching, Kevin!
It is still a bit tricky to have all this done ; every day is a new learning curve ; Thanx for the wonderful insights.
You're very welcome, Farhan.
Yet another great presentation and shows how simple its on - Thank you
Glad you liked it!
Excellent work Mynda. It is an outstanding tutorial. Very complete. Thank you very much.
Cheers, Ivan!
Thanks for the helpful Excell techniques. Helping me a lot to work more efficiently on P&L as well as Balance sheet. Amir
Glad it was helpful, Amir!
Thank you for this video, it would go a long way saving me at work.
Glad to help :-)
This is amazing, it actually made my day and i am no accountant :D. Thank you for sharing your wisdom xxxx
Wow, so pleased you found it useful :-)
Thanks for your presentations. Good Job!
Glad you like them!
Excellent video, I never thought of consolidating P&L statements with slicers. You're really pretty as well.
Glad it was helpful! 🙏
Thank you very much for this amazing tutorial. Hoping many more financial analysis types of will be provided to all of us,
My pleasure, Amit!
Always worthwhile to watch Your Videos. Thank You!
Great to hear, Ankur :-)
Thank you very much for another clean and straight forward video and most important, very useful content
So pleased you enjoyed it :-)
This video is extremely brilliant. Many thanks to my teacher!
Glad it was helpful!
Many thanks for this great tutorial Mynda! I think this P&L report would be easier to read if there was a bit more whitespace between the lines. I strongly prefer to scroll down rather than read scrunched reports (even if the whole report can be seen on one screen). Just some feedback for what it's worth... 🙂
With a PivotTable you can only insert one blank row after each item, but you can always make those rows wider if you prefer.
Superb !!! Dear Lady - Awesome!!!
Thank you so much 😀
Useful technique and great explanation, thanks
You're welcome!
Excelent explanation ! But too nice to be true... if as it is almost always the actual and budget are not different fields but rather one field sorted by year / budget (it is not possible then to calculate the variance )
Thanks, although I'm not following your point.
That is fantastic. Thank you! I spent 2 days doing something similar in Power BI, but this is so much easier!
my question is though, when would you choose power bi over excel?
Awesome to hear! I use Power Query whenever I have multiple steps I need to perform to clean data, or if it's something I'm going to want to do again when new data gets added to the source I'm referencing. If it's a one time and done task, then I'll probably use one of the Excel tools.
Very good and very easy. Thank you so much for sharing this tutorial and file!!!
Glad you like it!
thanks you. you shared valuable things. I also apply this exercise at my work. very useful . thanks for your sharing.👍👍👍
Great to hear 😊
You have put an end to my worry with this video. I have been looking for a simple way to automate my month-end report. I have used this knowledge together with power pivot and power query in my current work to prepare some important reports.
Please, is there a way to manually edit the value fields may be during a management meeting(adjust the values).
You are great. Thanks and Thanks. Problem solver.
So pleased it has been helpful! You can't edit the value fields of a PivotTable, but you can edit the source data that's feeding the PivotTable.
Excellent resource for a newbie like myself! Thank you so much.
Great to hear 😊
This is just amazing! Thank you for sharing.
So pleased you liked it 😊
Loved this! I didn't know you could move the pivot rows around so easily!
Glad you discovered some tips you can use :-)
Superb, Mynda. Thanks!
Cheers, Ian!
This is great! Thank you so much. I’m looking to also add a Gross Profit % but having challenges achieving it with Calculated Items. Any suggestions?
Thank you verry much Mynda. This is a great tutorial. Very helpful and usefull plus saving a lots of time.
Great to know it was helpful, Serge!
Very high quality content!
Glad you think so!
I am glad that I subscribed your channel.
Thanks for subbing!
Very useful working pls make some more videos in accounting in excel wonderful job thank you.
Glad it was helpful 🙏
As always very creative and made easy lesson
Thanks, Shad :-)
Thank you mam. Today i practiced everything shown in the video and learned new formatting technique to present report. If you know that in india most of the companies use either SAP accounting or Quickbook or Tally and dld reports in csv or excel file. From this i learned how to present report in structured and in cleaned manner. Thank you mam
Wonderful to hear, Deependra!
Excellent work. Thank you for the specified work. I really appreciate your work.
My pleasure!
I've been struggling for years for nothing. It's very simple.
Indeed :-)
Many thanks
Well Done Mynda
Cheers, Shakira!
Perfect Video.
Very Informative❤
Glad you liked it 🙏
This is very helpful. Thank you so much.
You're very welcome!
I love you 💕💕 I've developed a P&L that uses some source data from an SQL database (the P&L can be different as I work with different companies. This could just give me the 'portable' solution I need . Thank you
That is awesome!
@@MyOnlineTrainingHub I've got a question. Related to my comment above. I'm finding the performance of a pivottable version of my previously created P&L is significantly quicker at updating than my pivottable alternative (using your great video above). Any tips on how to make it almost instant with ~1600 rows of source data? (Note I'm also bringing in my financial period data for the entire FY)
Definite like from a professional public auditor)
Thanks so much 🙏
Amazing, Lovely & Wonderful. You are Aowsome Dear MAM.
Glad you liked it 😊
Thank you for sharing this video, with you the excel is piece of cake 😊
My pleasure 😊
I have been looking for this all day!! Thanks
Glad you found it useful, Leroy!
Super useful! Thanks a lot! ☺
Glad to hear that!
we need more videos focusing in financial reports please
I'll keep it in mind, Ashraf!
I’m gonna try this for current month reporting. Loved it 👍🏻
Awesome to hear!
Thank you so much for this. Pivot tables are really amazing.
Glad you like them!
thank you very much for another excellent video!! I have truly enjoy the several I have watch. Yours are my fav. :)
Glad you like them, Calvin!
Always love your video.
Thanks, Cepy!
Thank you Mynda, as usual another great tutorial...
Cheers, Silvano!
Thank you so much! please make financial position like this
Glad you liked it, Elias!
I have learned a lot of ins and outs of pivot tables from your videos. There is one thing that has me totally baffled. In a pivot table P&L, how do you subtotal items that have several components such as "Auto Expense:Fuel" "Auto Expense:Repairs" "Auto Expense:Registrations". I tried to insert a calculated item to sum these items BUT the subtotal for "Auto Expense" adds itself to the expense total and essentially doubles the auto expense. There has to be a way to accomplish this to show a subtotal for multiple related items. ie. Insurance:General, Insurance:Professional Liability etc.
You can try grouping the items, or add another column to your source data for this intermediary group as shown here: www.linkedin.com/posts/myndatreacy_excel-excel-activity-7018580085964242944-ww9y
Really! an amazing video. I enjoyed the video and please keep sharing your best ideas in future too. Thanks.
Thank you, I will :-)
Dear Sis, Thanks u so much for this .It is very precious for me.
So pleased it'll be useful :-)
Another great one!
Thank you! Cheers!
Hi Mynda.. this is excellent. I've been looking for a quick tutorial on this. You made it nice and easy. One thing I learned that might help others.. if you need to modify your Calculated Fields.. start w/pointer in Pivot Table => PivotTable Analyze => Fields, Items & Sets => Calculated Field.. then from the Name Field, click on the downward facing arrow on the right side of the Name Field to reveal the field list of the Calculated Fields you have created. From there, you can select the one you want to edit, delete, etc. Seems like a simple and or obvious thing, but I kept getting tripped up by clicking into the Fields list to try and select a Calculated Field to modify or delete.. does not work.. must be selected from the drop down. Thanks again for this great video. Really learned a lot and is super useful and immediately applicable to my work. Thumbs up!!
PS - Also.. love your tip below to Signal Mas re. dynamic titles.. super!! :))
Awesome to hear, Wayne! Thanks for the tip. I remember struggling to find where to edit and delete calculated fields and items too.
@@MyOnlineTrainingHub Thanks Mynda :)) Also.. love your tip below to Signal Mas re. dynamic titles.. super!!
This is extremely helpful. Although it is very rare to get data in such a clean format.
Glad you can use it, Zubair. If you have messy data you can clean it first with Power Query. Here's an example of using Power Query to unpivot data: ruclips.net/video/-IMqkg35adA/видео.html
Calculated field and items provid boosting power in pivot table . Nice video thanks
Thanks, Ali!
Hi, Thank you for the tutorial. It is very clear and informative. Can we add subfields in the pivot table? Income - COGS = Gross profit. After the Gross profit level, I want to give the break up of expenses. The heading should be "Less Operating Expenses" and under this group A) Staff Costs and under this, there will be accounts. Then " B) Rent Expenses" and under this, there will be all the rent expenses. Thank you
Thanks a lot for the useful tutorial! A quick question, please: if I added a row of Net Profit as a calculated item and now I would like to add Net Profit percentage (from Revenue) also in a row, how do I do it correctly so it will not summarize all percentages below on the total level?
You can't add the percentage as another item, you'd have to add it in a separate column and use the 'Show Values As' setting as explained here: www.myonlinetraininghub.com/show-values-as-percentage-of-another-pivottable-column-total
@@MyOnlineTrainingHub thank you for your reply, but I need it in row not in column, that's the issue. In columns I have years and in rows all P&L accounts, like revenue, cogs, opex, fin. exp., etc. and the net profit is calculated in rows as well. Thanks again!
Absolutely amazing! thanks
Glad you liked it, Saleem!
Very interesting techniques. Congratulations. Loved it. I have a question: If you have the data separated by month, how do you do this report for a year-to-date period? Regards and thank you very much for asking my question.
Great to hear! If your data is separated by month then you need to consolidate it into a single table. You can use Power Query to do automate this. Depending on how it's separated, you might find this useful: ruclips.net/video/YOC-pEIuHpA/видео.html
definitely "you are the one" , as Robbie would say! thanks al lot! :)
:-) thanks so much, Ignacio!
This is great! Thanks for this video.
Glad you liked it!
Thank of million for your sharing. Really awesome!!! Hopefully for the next video.
My pleasure :-)
You bring always fantastics stufs. Congratulations from Guinea-Bissau!
Thank you :-) Glad you like the videos.
That's wonderful.
Exactly what I was looking for. Thank you so so much.
Glad it was helpful!
Awesome Mynda ,,,You alwz shared with us very fantastic trick great
Thank you so much 😊
Great content!
Thank you!
Like always you have amazing idea and thoughts, Thank you very much for this session.
Thanks so much, Akilesh!
Great, beautiful. Thanks Mynda!👍
Thanks, Luciano!
Love this. My slicer will be Job number!
Awesome! So pleased you can use this technique.