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 👏
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 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!
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.
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.
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?
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!
Wow thanks a lot!
Very helpful video! I am preparing for my Junior Financial Controller interview and Your videos help to refresh my Excel knowledge.
Best of luck!
Great content Guru!! Include Ctrl + T!, Tables in Excel which is a hidden Gem 💎 💎 not usually used
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 👏
The XLOOKUP portion of the video was so nice & easy- thank you! 🤓
You’re welcome 😊
You should have millions of followers! you're such a great tutor!
Thank you! 😊
Accountants unite. =)
accountants ASSEMBLE!!!
Your videos are so helpful. I am starting a new job and they will be a life saver.!
Best of luck!
Thanks for the video Bill! Very helpful
Glad it was helpful!
I am glad I found your videos. You are a good instructor
I appreciate that!
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.
Thank you!
Thank you. Please do other Excel functions pertaining to FP&A roles. Thank you in advance
Great job your video is pretty accurate for us auditors.
Thank you!
I just chanced on your videos and i must testify that their top-notch. Please keep it up.
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!
Brent I have no doubt you will ace it!
I learnt xlookup today…. Thanks 🙏🏾
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).
Thanks Bill! Can use that today right away
Thanks so much Sir, this is very helpful
You are most welcome
Great video, and will applied it when searching for sampling
Loved the video! Are there any other formulas that could be used when reconciling balance sheet accounts? This was super helpful.
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 like your videos, thank you so much 😊
Love all your videos!
Thank you so much!!
You will become my mentor. 👊🏿
Awesome ok
Bravo! Veloce ed efficace
Thanks Bill 👍
You are very welcome
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.
Love to see more videos like this
Great insightful video brother
Much appreciated
Thank you Sir.
very helpful thank you Sir
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
Xlookup is fairly new anyways!
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)
This is so helpful! 🎉😊
Glad you think so!
Can you add the subtitles for your each video? Thank you so much!
I will try!
@@TheFinancialController Cheers mate!
Awesome video!
Hi Bill. Are you giving any personal classes (I mean via Zoom, Teams, etc.)?
I wish the controller I worked under was nearly as organized as this. The first close I had I was surprised to learn there was no checklists
Go teach him/her :)
Very nice!
We can use find function so what is point on xlookup 😅?
You are awesome
I followed your formula exacting and get the #Name? error mesage. What can I do to correct? Thanks
TQ!
I didn't see any If functions in this video. I assume it's not as popular as the rest.
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
Yes, but don't make your job hops too short. I like to see 1 or 1.5 years in a role at minimum
Why the actual have I been using index and match and I didn't know xlookup exsisted :(
Hello is a cpa valuable to get if you are in a developing country which has a lot of American companies and big 4
How common, if at all, is paid overtime in industry for someone in a assistant/controller position?
I’ve never seen one
❤ Smartcountant ❤
How change the w.sheet in pdf and reverse
Bill, Do you offer mentoring/coaching for new accountants?
I teach via the Controller Academy. There is a link in the video description
Do you still have office hours on Patreabout
My end of month formula isn't giving me months in Words. What can I do?
simply right-click on the cell, click 'Format cell", choose "Date" and find the date format you like to appear!
Those formula were do u get them
How does one get good in Excel? Right now I'm just teaching myself how to use it with youtube.
But the Xlookup function only available in latest excel versiona
The alternative is index match. Check my video on that one
Do accountants make use of power query a lot as well?
Depends on the role, but not as much as you might think
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.
Tommy leep is one rich guy,
Where did you go to school? If you don't mind me asking
City university of New York
@@TheFinancialController perhaps I should transfer there to get my bachelor's... you are so knowledgeable... do they have dorms or??
@@petertenay1785 the knowledge is from work not school really
@@TheFinancialController oh, thank you for that.
Too fast on the sumif function Bill
I don't have that format
✍️
Still dont get how to use eomonth lol
I am from India can i get a job if you have a accounting firm.
I am accounts executive where I handle Canadian businesses. I preparr financial statements and end to end accounting.
If you can provide me an opportunity to work form home that will be a great opportunity.
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?
Hi. You can email me. My email address is on my website