Thanks for the video Bill! Very helpful

Very helpful video! I am preparing for my Junior Financial Controller interview and Your videos help to refresh my Excel knowledge.

@TheFinancialController

11 ай бұрын

Best of luck!

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!

@TheFinancialController

Жыл бұрын

Wow thanks a lot!

Great content Guru!! Include Ctrl + T!, Tables in Excel which is a hidden Gem 💎 💎 not usually used

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 all your videos!

I just chanced on your videos and i must testify that their top-notch. Please keep it up.

Thanks Bill! Can use that today right away

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 👏

Bravo! Veloce ed efficace

Great video, and will applied it when searching for sampling

Accountants unite. =)

@ragnadrabinowitz7629

9 ай бұрын

accountants ASSEMBLE!!!

The XLOOKUP portion of the video was so nice & easy- thank you! 🤓

@TheFinancialController

3 ай бұрын

You’re welcome 😊

I am glad I found your videos. You are a good instructor

@TheFinancialController

10 ай бұрын

I appreciate that!

Your videos are so helpful. I am starting a new job and they will be a life saver.!

@TheFinancialController

Жыл бұрын

Best of luck!

Loved the video! Are there any other formulas that could be used when reconciling balance sheet accounts? This was super helpful.

You should have millions of followers! you're such a great tutor!

@TheFinancialController

Ай бұрын

Thank you! 😊

Thank you so much!!

Great job your video is pretty accurate for us auditors.

@TheFinancialController

Жыл бұрын

Thank you!

I learnt xlookup today…. Thanks 🙏🏾

Awesome video!

Love to see more videos like this

I like your videos, thank you so much 😊

very helpful thank you Sir

Thanks so much Sir, this is very helpful

@TheFinancialController

Ай бұрын

You are most welcome

Thank you. Please do other Excel functions pertaining to FP&A roles. Thank you in advance

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).

This is so helpful! 🎉😊

@TheFinancialController

Жыл бұрын

Glad you think so!

Very nice!

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.

Thank you Sir.

Great insightful video brother

@TheFinancialController

Жыл бұрын

Much appreciated

Thanks Bill 👍

@TheFinancialController

5 ай бұрын

You are very welcome

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!

@TheFinancialController

Жыл бұрын

Brent I have no doubt you will ace it!

You will become my mentor. 👊🏿

@TheFinancialController

Жыл бұрын

Awesome ok

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.

@TheFinancialController

8 ай бұрын

Thank you!

Hi Bill. Are you giving any personal classes (I mean via Zoom, Teams, etc.)?

You are awesome

TQ!

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! 😊

@TheFinancialController

5 ай бұрын

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)

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

@TheFinancialController

Жыл бұрын

Yes, but don't make your job hops too short. I like to see 1 or 1.5 years in a role at minimum

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?

Those formula were do u get them

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

@TheFinancialController

11 ай бұрын

Go teach him/her :)

How change the w.sheet in pdf and reverse

Do you still have office hours on Patreabout

I followed your formula exacting and get the #Name? error mesage. What can I do to correct? Thanks

Can you add the subtitles for your each video? Thank you so much!

@TheFinancialController

4 ай бұрын

I will try!

@loganyang619

4 ай бұрын

@@TheFinancialController Cheers mate!

How common, if at all, is paid overtime in industry for someone in a assistant/controller position?

@TheFinancialController

11 ай бұрын

I’ve never seen one

Do accountants make use of power query a lot as well?

@TheFinancialController

Жыл бұрын

Depends on the role, but not as much as you might think

@newmhelemish

Жыл бұрын

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.

Hello is a cpa valuable to get if you are in a developing country which has a lot of American companies and big 4

Why the actual have I been using index and match and I didn't know xlookup exsisted :(

I didn't see any If functions in this video. I assume it's not as popular as the rest.

But the Xlookup function only available in latest excel versiona

@TheFinancialController

Жыл бұрын

The alternative is index match. Check my video on that one

Bill, Do you offer mentoring/coaching for new accountants?

@TheFinancialController

Жыл бұрын

I teach via the Controller Academy. There is a link in the video description

My end of month formula isn't giving me months in Words. What can I do?

@TheFinancialController

10 ай бұрын

simply right-click on the cell, click 'Format cell", choose "Date" and find the date format you like to appear!

❤ Smartcountant ❤

How does one get good in Excel? Right now I'm just teaching myself how to use it with youtube.

I don't have that format

Tommy leep is one rich guy,

Where did you go to school? If you don't mind me asking

@TheFinancialController

Жыл бұрын

City university of New York

@petertenay1785

Жыл бұрын

@@TheFinancialController perhaps I should transfer there to get my bachelor's... you are so knowledgeable... do they have dorms or??

@TheFinancialController

Жыл бұрын

@@petertenay1785 the knowledge is from work not school really

@petertenay1785

Жыл бұрын

@@TheFinancialController oh, thank you for that.

✍️

Too fast on the sumif function Bill

Still dont get how to use eomonth lol

I am from India can i get a job if you have a accounting firm.

@DR-pm6xm

Жыл бұрын

I am accounts executive where I handle Canadian businesses. I preparr financial statements and end to end accounting.

@DR-pm6xm

Жыл бұрын

If you can provide me an opportunity to work form home that will be a great opportunity.

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

@iniester6724

Жыл бұрын

Xlookup is fairly new anyways!

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?

@TheFinancialController

4 ай бұрын

Hi. You can email me. My email address is on my website