Some really useful tips on using pivot tables for reporting and analysis ... kzitem.info/news/bejne/y5WrzYqinJieY6A
@RA-rh5lb
Жыл бұрын
all of the hacks are so useful. Thanks for the posting. Thank you so much. One of the best video i have seen so far..
@LearnAccountingFinance
Жыл бұрын
thanks!
@msskaggs3911
Жыл бұрын
RE #4 → you can select the Column of 'numbers stored as text,' then click the Yellow [!] sign and select 'Convert to Number:' I believe this is considerably faster than the multiply by 1 hack. I do use a similar hack of sorts, I'll multiply by -1 to switch ranges between positive & negative numbers with the secondary ability to convert number formats. This is useful for an accountant if they're trying to convert a dual column (DR/CR) trial balance into a single column (+/-) trial balance. Just multiply the Credit side by -1, then copy the resulting (negative) credit balance and Paste Special (Values & Subtraction) unto the debit side and it should give you a nice single column t/b that sums to 0 without having to go line-by-line down the accounts. IMO, #8 is the best tip. Thank you!
@LearnAccountingFinance
Жыл бұрын
Thank you for your comment. From my experience in the past, if you have a large data set, convert to number option takes a very long time and even crashes Excel at times. There may be an improvement with recent updates but I have not tried it. Yes it's great for switching positive and negative numbers as well.
@ca-indu
2 жыл бұрын
Amazing work...had a great value addition to excel knowledge...excellent...keep posting such useful vedios for excel and SAP fico
@LearnAccountingFinance
2 жыл бұрын
Thank you!
@narasimhauppala9232
3 жыл бұрын
Very informative and easy way of doing.
@LearnAccountingFinance
3 жыл бұрын
Thank you!
@cindy7lee
2 жыл бұрын
Great Tutorial. Thank you. :) If you upload the excel file you used in the tutorial that will be even better.
@jasonkim4375
2 жыл бұрын
Much appreciated!
@LearnAccountingFinance
2 жыл бұрын
thank you!
@DreamFirms
3 жыл бұрын
Learned a lot!
@axion8788
3 жыл бұрын
Some fantastic methods. I am sure your viewership will grow. The name of your channel doesn't match my perception of what you are offering.... super excel training and insights, from an accounting perspective. This may be causing some KZitemrs to overlook you which if true, is very unfortunate. You are one of the best Excel teachers.
@LearnAccountingFinance
3 жыл бұрын
Thanks a lot for the kind words Axion. Really appreciate it. Yes. Maybe channel name does not fully reflect the content. But I think the content and consistency can be improved too. Working on it 💪 . Love the support from viewers like you.
@khalidmajeed2886
3 жыл бұрын
best for learners.
@LearnAccountingFinance
3 жыл бұрын
Thanks Khalid
@Lyriks_
2 жыл бұрын
Hello i want to buy your course, will i get enough for my money ?
Пікірлер: 21