Some really useful tips on using pivot tables for reporting and analysis ... kzbin.info/www/bejne/oJDYmImimMugZs0
@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.
@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!
@narasimhauppala92323 жыл бұрын
Very informative and easy way of doing.
@LearnAccountingFinance3 жыл бұрын
Thank you!
@ca-indu2 жыл бұрын
Amazing work...had a great value addition to excel knowledge...excellent...keep posting such useful vedios for excel and SAP fico
@LearnAccountingFinance2 жыл бұрын
Thank you!
@DreamFirms3 жыл бұрын
Learned a lot!
@cindy7lee2 жыл бұрын
Great Tutorial. Thank you. :) If you upload the excel file you used in the tutorial that will be even better.
@axion87883 жыл бұрын
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 KZbinrs to overlook you which if true, is very unfortunate. You are one of the best Excel teachers.
@LearnAccountingFinance3 жыл бұрын
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.
@jasonkim43752 жыл бұрын
Much appreciated!
@LearnAccountingFinance2 жыл бұрын
thank you!
@khalidmajeed28862 жыл бұрын
best for learners.
@LearnAccountingFinance2 жыл бұрын
Thanks Khalid
@cuteaditya9436 Жыл бұрын
Pj /1)8
@ubaidillahmuhammad203 жыл бұрын
nice. Given the file Sir
@Lyriks_2 жыл бұрын
Hello i want to buy your course, will i get enough for my money ?