Excel for Auditors & Accountants | AR Aging Report Example | Must Know Shortcuts

[@k4i808]

Vlook up and pivot tables please!! This was extremely helpful

[@BryanCarretoCPA]

I will definitely make a video on this topic next! Appreciate the thumbs up everyone

[@surajprakash8180]

​@@BryanCarretoCPASir please make a Video on most Excel Formulas used in Auditing with Live examples. Thank you

[@m.bk05]

I have watched so many tutorials.. this was by far the best...the only needed for a new auditor ...and your other videos are just binge worthy

[@pecsure]

I was literarily screaming after seeing your TB audit video and it was so helpful for the Audit i will be doing for a company next week. Thanks a lot for all the nuggets and analysis tips. They were so helpful. Please could you do videos for auditing all line items on the balance sheet? Thanks🍀

[@eisenhoward1]

Nice thanks for the tips! Any advice for running through Tickmarks on workpapers? I always get lost in the sea of Tickmarks!

[@captainhindsight2431]

Thanks for making videos about this, as a first year auditor it really helps.

[@allprolemontonz8448]

Vlook ups and pivot tables, I start audit in August so any tips on how to actually audit as a first year would be great

[@jnkvngz2965]

You're an amazing coach, Bryan. Grateful for you!

[@singineileen1]

This was extremely helpful and very easy to understand and follow. I literally took notes and feel a tad more competent.

[@CC-wo2xc]

Great job. It will only get better. Also, Alt + H + I + R is a common one for me.

[@ruthmunoz4907]

Loveee your videos!! 💗

[@emmanuelruiz488]

That was really hopeful man, thank you

[@l3fty280]

Thank you much for these useful tips, I am also an auditor and struggled my way to format a client's aging schedule. have not looked at your other videos, but if you don't have a video on how to format a GL detail, can you please educate us on that?

[@wonwoooyah]

Thanks for this video.This is very helpful to accounting professionals🙂more excel content for accountant please. 😊

[@mohammadidreesSwati-dn8ks]

Your nationality and qualifications

[@gohitoyo7280]

Hi Bryan, and thanks for videos. They are very helpful. How can I seek your help directly?

[@BryanCarretoCPA]

Hi DM me on instagram @bryan_carreto

[@allprolemontonz8448]

Very helpful

[@madrasiinbeautifulbc3421]

Alt W J will zoom it to 100%. Of course to adjust it to other zoom%ges, the Alt W Q tab and entering the percentage works great! Could you please do a video on testing revenues, payroll and expenses? I have been enjoying your videos. Thanks for showing real life examples and templates and not just talking theory!!

[@lindaxiong7588]

More excels videos. Please 🙏 thank you 😊

[@BryanCarretoCPA]

You got it! ;)

[@CPATuttle]

It was great thank you

[@AndreA-qp6in]

Awesome video, thanks! How long did it take you to memorize all these shortcuts?

[@jonathanromelus5839]

Question, what's the best way for an auditor/accountant to real grasp journal entries and knowing how they affect/impact financial statements across the board (cashflow, balance sheet, tax returns, etc). I really want to get strong in this area. See an entry and know exactly where it will ended up and its affect on the reports. What can I do to sharpen this? Appreciate your insight. Thanks!

[@stephensawyer2511]

Prep a corporate tax return without using QuickBooks. Export the Income Statement, Balance Sheet, and GL Detail to excel. From there make your necessary adjustments (manually record journal entries and reference them to/from the right account) and make sure any changes flow from/to the proper account and have the correct ending balance.. Always pay attention to how equity changes as this is usually the last (and most difficult) step. In short: you can do this if you don't know anything about taxes, but you will need excel and QB. Just make an adjustment in QB...find the changes...then manually do it in excel. Hope this helps.

[@jayeshshukla5207]

The Gridlines alt+W+VG go away from the entire sheet, how did your data table didn't had any affect?

[@stevemiguel3880]

Where can I get a sample template of this? Wanting to follow but wanted this exact template to work through it as you explain. Thanks!!

[@BryanCarretoCPA]

Please send me an email and I am happy to share it [e-mail] - If it helped please tag me or share it with your friends to help grow the channel. Best of luck

[@CC-wo2xc]

An alternative to decimal points, you can go to the settings in the control panel and change the default to zero decimals places. Control panel > change date, time, and number formats > advanced settings > currency > No. of digits after decimal Lmk if anyone else has shortcuts they’ve found practical.

[@jennifersanchez964]

Can you please do a video on vlookup and pivot tables! I love your videos! ❤️❤️

[@BryanCarretoCPA]

I am working on this video as we speak lol... Thank you soooo much. Always here to help if you have questions

[@JellyfishHawaii]

How to make notes/narrative nicely fit? And when I do copy and paste it always look ugly.

[@bassem1656]

For next time, can you please upload the excel file on youtube so we can download it and follow your steps to practice. Thank You.

[@TuomasEvikoski]

the echo of your voice is really bad in this video. Get some matrsesses or something in your room so that it wont sound like you are in empty hall

[@mohammadidreesSwati-dn8ks]

Brilliant teacher may I get your cell number plz sir