Thanku for creating amazing content for accountants❤ I must say apart from bookish knowledge if someone wants to learn and grow in their accounting career this is the right place!
You really do a great job. I would like to add from my point of view that Xlookup replacing index match. As you know, old version of office, there is no Xlookup. I am following you.. keep going 💪 good job 👏
That x lookup is incredibly convenient! Prior to the x look up being added, I would sometimes have to move the column data to be able to pull the right cells.
Great video Bill! Started dabbling more with excel over the last year, working on a few different excel certifications right now, but excited for the day where I feel more comfortable with it and start using it more. So many great features and excited to become a pro in it over the next few years as I stay in the finance/accounting world early next year!
Thank you for making good and informative clips. It's easy to understand. I've been following it since the first clip I watched. It's great. Thank you.
Great content as always. I have an accounting career question though: I read your comment on another one of your videos that you usually like to move around jobs every five years. I like this idea because every accounting manager job in any accounting specialty (accounts payable, accounts receivable, audit, and tax) all seem to require at least (at bare minimum) 5 years in the specialty for the manager job to which one is applying. I am 40 with a Master's Degree in Accounting because I started late and just got my first accounting job in Accounts Receivable. I hope to get 5 years experience in A/R and then go on to 5 years in A/P before hopefully doing 5 years of staff accounting. But what accounting specialties do you recommend after that? Will I be equipped to be an accounting supervisor or manager by that time? I will be only 55 years old after 5 years in each of the 3 accounting specialties that I just mentioned. I hope to never retire as I enjoy working in general (as I have a very solid work ethic). So, what are your recommendations? Thanks for any help that you can provide. (By the way, I used to live where you live: meaning in Bergen County, NJ. Great place).
OMG!! Thank you very much for explaining it so clearly! 🥰 I was wondering why everyone said XLookup is better than VLookup : now I get it! Yes XlookUp is wonderful. 👍🏾 Also I did know about "end of the month". Thx However personnaly I also use a lot of TEXTE formulas : Concat ; TextAfter; TextBefore ; right; left; etc. If I may suggest to do an 2nd video which include more formula for no-number data analysis. Because nowdays software know how to analyze number as well, if not sometime better than us. But it still need to be improved little bit for no-number analysis. Thus I think in the future, in order to make the difference, accountants will have to analyze more no-number data. At least that's what I think, but I might guess it wrong.
I can do lots of crazy things with excel... how I went 8 years without knowing about xlookup is beyond me... always had to make new tables to refer to. thanks
Hi Bill, thank you for all of the helpful videos! I was wondering if you can advise if you feel someone who has an MBA could transition into an accounting role without a bachelors in Accounting? I have nearly 4 years of previous experience as a manager at a medical clinic in a non-profit facility where I completed a lot of accounting type responsibilities (reviewing contracts for approval of A/P invoices, analyzing contracts and creating new contracts that would save the non-profit money, etc) but I am currently in a higher education role with student facing customer service and non-financial documentation review. Should I work on a certification in quickbooks or something else to prepare me for interviewing for an entry level accounting job? Should I look at obtaining a masters degree in accounting or would my MBA help? I did take accounting and finance courses in my MBA. Thank you for any advice you have! 😊
Hey Joyful, master's in accounting is an overkill since you have an MBA. I would take a couple of online courses on practical accounting in the workplace. check out my controller academy where it's designed exactly for this purpose (showing how accounting is practiced in an actual company)
What if while using the xlookup if there is a person’s name multiple times, the formula only takes the count for the first name. Is there any way to fix this while using the xlookup?
Hi bill, I have a bachelor degree in accounting and been working in AR for almost a year now. If my goal is to become CPA and one day controller should I consider switching jobs/positions to more accounting role? Like staff accountant
I myself use power query and power pivot in my work. Sometimes I use pivot table to create a visual and dynamic presentation to the Financials. It depends on many factors, and as Bill said on the role as well. I am accounting manager.
Hi Bill. I saw your courses. I'm from India. I want to discuss regarding the courses. Its very diffcult indian accountants to access the course. Please let me know how to contact you?