Excel Accounts Payable / Accounts Receivable Exercise - Watch Chris Work

[@chrisp7622]

One of the few who explains all the granular stuff like the part of the formula that isn't required. I learned several things watching this video.

[@ChrisMenardTraining]

TY. I appreciate the positive feedback!

[@AdelitaWilliam-dl7ci]

Keep more videos like this coming please. The more in depth and detailed they are the more helpful they are.

[@ChrisMenardTraining]

Will do!

[@danielsmithiv1279]

​Hey there Chris! What aspects of excel would I need to know to do well in this type of job position?@@ChrisMenardTrainingProficiency with Microsoft Office including Outlook, Teams, Word, and Excel · Excel knowledge is required (Mandatory) · SAGE 100 experience a plus · Punctual · Works well under pressure, ability to meet deadlines and thrive in fast paced environment. · Highly organized, trustworthy, and self-directed · Ability to identify and solve problems efficiently and with good judgment. · Desire to move up within the company by demonstrating the highest quality ethics and work standards. · Excellent written and verbal communication skills · Proficient in 10-key pad by touch to process data with speed and accuracy. Job Responsibilities: · Receive, verify, and validate invoices. · Research and work with other departments and customers to resolve invoice discrepancies, claims, and receivables issues. · Correspond with Customers/Vendors and respond to inquiries. · Process Accounts Receivables Payments and Chargebacks Claims · Review accounts receivable aging and reconcile accounts. · Accounts Receivables cash receipt postings · Prepare reports and analysis as needed. · Monitor accounts to ensure payments are up to date. · Assist in month end closing. · Assist Billing Department as Needed processing invoices. · Other tasks as assigned by management. Please take the Skills test: Spreadsheets with Microsoft Excel on Indeed and submit the results with your resume. All interested candidates will be Tested on Excel Skills during the interview.

[@mdnoorulla5618]

Way of Teaching Interesting, Very Simple & Slowly Teaching.its very useful

[@ChrisMenardTraining]

Glad you liked it

[@gayatribanjara3079]

Very simple, clearly and slowly teaching, also very useful, good video. I learn a lot Thank you!

[@ChrisMenardTraining]

You're very welcome!

[@irynasavchenko91]

Thank you Sir for both, tutorial and gratis spreadsheet to follow along! Exactly what I needed!

[@ChrisMenardTraining]

You're very welcome!

[@xianxiong3440]

This is exactly what I am looking for!!!

[@ChrisMenardTraining]

Glad to help.

[@RichellRichJalipa]

Thanks a lot. You are awesome. I will follow you. More success!

[@ChrisMenardTraining]

Thank you!

[@nmp369]

Very helpfull. Thank you Chris!

[@ChrisMenardTraining]

Very welcome!

[@VistmarTeam]

Simple and to the point. Thank you!

[@ChrisMenardTraining]

You're welcome. Thanks, Raúl.

[@victoriaatkins6946]

This was so easy to understand, Thank you.

[@savitavaidya-z3g]

it was very good keep it up

[@ChrisMenardTraining]

Thank you.

[@annie.ttan1412]

Thank you so much Mr Chris. So amazing. Keep up the good work ❤️🔥

[@olayinkaadedeji3901]

Thank you Chris.

[@ChrisMenardTraining]

Very welcome

[@DrewandAlly]

This was great, thank you so much !!!!

[@usamaalii]

Very good explanation method.

[@ChrisMenardTraining]

Thank you.

[@hrashidi100]

Super interesting, thank you! I'm doing finance right now and too much manual input will break my fingers...

[@ChrisMenardTraining]

Thanks, Hannah.

[@Postmann88]

Great video Chris. Thank you. Question: Is there a way to enter two arguments into the formula ie: ("ABC", and ">0") ?

[@juantapia7832]

Hello. Thank you very much for your video, excellent. Can I ask you a question, please? I would like to know what type of value I must to consider in the sale (accounts receivable) : net sale (without VAT) or with VAT? I understand that the sales values, cost, expenses, must always be recorded without VAT. Thank you so much!

[@fcg2122]

this is great i am not sure if i can get a replay but what if you want to add more invoices than the 13 he is using it does not affect invoice entered after i did this formatting. I am not great at all with this I am very new to spread sheets I am sure a 13 year old knows more than myself.

[@JamieModelvsDirector]

Thank you so very Much ❤😊🙏🏾

[@Saad.PS2009]

Thank you so much

[@ChrisMenardTraining]

You're most welcome

[@rofiqulislam7544]

Very good video ❤️

[@ChrisMenardTraining]

Thank you 🤗

[@BeGOoD2022]

first thanks for sharing this skills , but the general not appear in cell when the text formula in moving the cell to else,how i solve it

[@rameshraipur3751]

thank u so,much

[@ChrisMenardTraining]

You are most welcome

[@nisasavenue4419]

is this what account recv interns will need to do ?

[@waliali-x6k]

Thank you

[@JohnJoseph-v2k]

I just want such accounts program.

[@PiuriBeko]

Hello Chris am from Papua New Guinea am very interested to join you in excel accounting

[@Cypherchart]

Thanks.