Here are top 13 Excel hacks for accountants and finance professionals ... kzitem.info/news/bejne/wG2ryHV_al-eoqQ
@nsanch0181
3 жыл бұрын
I really enjoyed the pivot table lesson. Thank you for sharing.
@LearnAccountingFinance
3 жыл бұрын
Thank you N Sanch01. Glad you enjoyed it.
@DarkWhippy
2 жыл бұрын
Awesome job! Just learned a few tricks to maximize my time. Thank you!
@LearnAccountingFinance
2 жыл бұрын
Glad you liked it. Thanks
@vijaysahal4556
2 жыл бұрын
Very useful sir nd yours teaching way is also unique sir 👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻💯
@LearnAccountingFinance
2 жыл бұрын
Thank you Vijay.
@jerrydellasala7643
3 жыл бұрын
The two tables with different columns would be much quicker and easier to merge using Power Query. That would also mean updates to either table would be reflected in the merged table or pivot table once they are refreshed.
@rajnimohan6660
3 жыл бұрын
Excellent way of explaining,Sir. Kindly make a video on price mix
@yaziedgaffoor168
3 жыл бұрын
Thank you sir, your video has been most helpful.
@xierli8585
3 жыл бұрын
This is so useful, thank you!
@sunilsomanath3208
3 жыл бұрын
You explained very well & your data is superb ❤️👍👍👍👍❤️
@LearnAccountingFinance
3 жыл бұрын
Thank you Sunil.
@AcousticBihari
3 жыл бұрын
Very insightful. Thanks
@umairmomin8868
3 жыл бұрын
Learned something which has worth
@A-broken-clay-jar
2 жыл бұрын
Great tutorial video!
@LearnAccountingFinance
2 жыл бұрын
Thanks
@jerrydellasala7643
3 жыл бұрын
Great tutorial. However, when formatting data in a pivot table, using the standard formatting tools in the Home tab only formats the data in the selected cells. To format the Pivot Table itself, one should RIGHT CLICK on any cell within the data set and select NUMBER FORMAT. This will bring up the same format window as using the standard Format option, however there are no other tabs available for Font, Border, etc. This will set the Data (in this case "Sum of Standard Margin %") to the desired format, and will extend to all values displayed for that data no matter what row or column changes are made. This will update the entire column. While selecting all of the data in the column does work, setting the format for the data set is easier as only one cell needs to be selected. Note that if the column formatted using this is removed and then added back, the format will need to be set again.
@LearnAccountingFinance
3 жыл бұрын
Jerry Dellasala Thank you for the tip on formatting. I think to some extent its a matter of choice as well. I like to remove and add back columns (play with the pivot table fields a lot). Using the Home tab formatting option retains the formatting for the columns, but its important to know the formatting option within the pivot table, and thanks for sharing this.
@happymm2008
4 жыл бұрын
Thank you. This is a great tutorial. Could you please provide the excel file to download so that I can practice with your tutorial step by step to learn?
@LearnAccountingFinance
3 жыл бұрын
Thank you. Here is the link to download the file bit.ly/37Sfe4v
@sachinkishore4115
4 жыл бұрын
thank you for tht tips. i love pivot table
@LearnAccountingFinance
4 жыл бұрын
Thank you sachin. I love pivot tables too :)
@raja86sekhar78
2 жыл бұрын
wow excellent
@waqasahmad8225
3 жыл бұрын
This is a great video on pivot table. would you mind if you provide the excel file to download so that every one can practice with your tutorial step by step to learn? Practice makes a man perfect. thanks in advance
@LearnAccountingFinance
3 жыл бұрын
Thank you. Here is the link to download the file Here is the link to download the file bit.ly/37Sfe4v
@elactecnology
3 жыл бұрын
Thank you for your explanation. But would you please share the workbook you are using. That would be a wonderful way of practicing what you are explaning.
@LearnAccountingFinance
3 жыл бұрын
Thank you. Here is the link to download the file bit.ly/37Sfe4v
@queenofhearts2207
3 жыл бұрын
Thank you so much for this - its incredible! For the adding of budget info, couldn't you do a vlookup and add column to your actual table?
@LearnAccountingFinance
3 жыл бұрын
Thank you Queen of Hearts. Vlookup only looks at one lookup value. It may actually give incorrect results. Because you may be looking up using customer name, and it will find the first value for that customer and bring in that value, while there may be multiple other data cells related to the customer. We are trying to get multiple fields such as customer and part number and period data etc, so vlookup is definitely not going to do it. We could use "sumifs" depending on the size of data. I have noticed that using sumifs slows excel performance significantly if the formula is repeated large number of times. There are definitely better automated ways of doing it. This is a lazy yet very effective way though.
@Liz-jp3ng
3 жыл бұрын
Please do more
@MrMosoani
3 жыл бұрын
subscribed! I do data analysis and this is very helpful. Can you post videos about set value as? those percentages their differences and when or what scenarios they are best used for? Just to be more accurate with my reporting.
@LearnAccountingFinance
3 жыл бұрын
Thank you for your feedback. I will keep this in mind for future videos.
@hosseinhosseinpoor4845
3 жыл бұрын
thanks...
@LearnAccountingFinance
3 жыл бұрын
Glad you found it useful Hossein
@shashidharkajekar9461
3 жыл бұрын
Helpful
@LearnAccountingFinance
3 жыл бұрын
Thank you!
@k0925sk
7 ай бұрын
Thanks!
@LearnAccountingFinance
7 ай бұрын
thanks SK KONG! Appreciate it!
@aa-ow6by
3 жыл бұрын
It's not letting me group that country section. What should I do now ?
@aphrovergi
2 жыл бұрын
Some things are not used the way they should in Excel 365... When In Excel Tables, Freeze Panes is no longer necessary, When Formatting shouldn't use the Home tab, To combine two sheets use the Auto-Connect tool by a primary key
@shoppersdream
3 жыл бұрын
Don't you have this workbook for us to practice? Thanks
@LearnAccountingFinance
3 жыл бұрын
Here is the link to download the file bit.ly/37Sfe4v
Пікірлер: 45