Subjects
PRICING
COURSES
SIGN IN
Start Free Trial
Ethan T.
Data Analyst at Chmura Economics & Analytics, CPA, and Enthusiastic Teacher
Tutor Satisfaction Guarantee
Microsoft Excel
TutorMe
Question:

If you have two different tables with a matching column, what function(s) could you use to quickly pull data from one table to another?

Ethan T.
Answer:

There are two answers: the VLOOKUP function and the combination of the INDEX and MATCH functions. The VLOOKUP function is ideal for situations when the matching column is the far left column in the table you are retrieving data from. The INDEX/MATCH combo is ideal for situations when the matching column is not the far left column in the table you are retrieving data from.

Professional Development
TutorMe
Question:

During a job interview, how should the interviewee structure their answers to behavioral questions?

Ethan T.
Answer:

I would recommend the time-tested STAR method: Situation, Task, Action, Result. Explain the situation you were in, clearly state the task at hand, thoroughly describe your actions to complete the task, and reflect on the results after completion of the task.

Accounting
TutorMe
Question:

Would an increase in a company's liabilities lead to an increase or decrease in the company's assets?

Ethan T.
Answer:

It would lead to an increase in the company's assets. For example, if a company takes out a loan for $5,000, they are simultaneously incurring a liability and increasing their cash (asset).

Send a message explaining your
needs and Ethan will reply soon.
Contact Ethan
Ready now? Request a lesson.
Start Session
FAQs
What is a lesson?
A lesson is virtual lesson space on our platform where you and a tutor can communicate. You'll have the option to communicate using video/audio as well as text chat. You can also upload documents, edit papers in real time and use our cutting-edge virtual whiteboard.
How do I begin a lesson?
If the tutor is currently online, you can click the "Start Session" button above. If they are offline, you can always send them a message to schedule a lesson.
Who are TutorMe tutors?
Many of our tutors are current college students or recent graduates of top-tier universities like MIT, Harvard and USC. TutorMe has thousands of top-quality tutors available to work with you.