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!
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.
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 RUclipsrs to overlook you which if true, is very unfortunate. You are one of the best Excel teachers.
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.
Some really useful tips on using pivot tables for reporting and analysis ... ruclips.net/video/j_ugVlcfm0k/видео.html
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!
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.
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..
thanks!
Amazing work...had a great value addition to excel knowledge...excellent...keep posting such useful vedios for excel and SAP fico
Thank you!
Very informative and easy way of doing.
Thank you!
Great Tutorial. Thank you. :) If you upload the excel file you used in the tutorial that will be even better.
Learned a lot!
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 RUclipsrs to overlook you which if true, is very unfortunate. You are one of the best Excel teachers.
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.
best for learners.
Thanks Khalid
Much appreciated!
thank you!
Hello i want to buy your course, will i get enough for my money ?
Pj
/1)8
nice. Given the file Sir
Osama