Name: Basics of VLookup
Uploaded: 2022-10-12T00:11:07.000Z
Duration: 2 min 19 s
Description: This video will explain what VLookup does and how to use it. I will show examples of how to change the inputs as well as the formula itself.

This video will explain what VLookup does and how to use it.  I will show examples of how to change the inputs as well as the formula itself.

Microsoft Excel

Hello all,

I would like to introduce myself: my name is Marc and I would be more than happy to help you with whatever topic you need help with.  I graduated from UConn with a BS in Finance and minors in both Mathematics and Economics. While at UConn, I began tutoring and enjoyed working with a variety of students, teaching them all types of math, from basic to complex content including Statistics and higher level calculus.

Outside of academia, I enjoy playing and watching sports and am a huge San Francisco 49ers fan. I have been playing tennis since I was 5 years old as well as teaching it for over 8 years. Another fun fact-I have been to Disney World over 20 times!

Basics of VLookup

eceedcf3-ac5a:37756;isclassifiedstrendingsuggestionsenableddt:42136;316f64c0-2415:46048;b2454379-d6cf:44572;47b8410f-afc8:46160;6d3f11ff-ee6c:47314;1a645375-144d:47316;jgfi9803:61686;i9de8100:55497;ei83g319:53872;47h3f766:58362;fg008402:58376;i6jj6667:86739;istutorredesignv2_1:73124;2b6i0532:68197;a5gbd220:61179;blogpwt:71359;5db3b892:67466;2a2j8400:70238;b534g232:70741;j91hb444:69773;18h21436:69961;85h98405:81245;0eie7335:76839;cia78296:75037;9b4gd804:78753;4d465237:81260;deisn977:110326;1d789912:110325;slcardst:87990;searchranking_newpqs:91321;b1ff5649:88417;d9c7i206:87231;ajgj0920:88926;dgigc739:92611;15gbg809:92228;6ij3b180:95553;90ahj157:94513;2a718373:100011;gg41j822:94817;3i5dg498:97157;437bb176:97771;06ieg414:100430;9ab7j510:99496;a0ge6769:101092;bfb37872:105751;7f8gg909:114000;e36bg556:114647;

Pre Calculus

Math

AP Calculus

Finance

Test Prep

Pre Algebra

Accounting

Economics

Geometry

Algebra 2

Basic Math

Business

STEM

ACT Math

Elementary Math

Algebra 1

PSAT

Statistics

Calculus

AP Statistics

Algebra

Trigonometry

Macroeconomics

Arithmetic

Microeconomics

Study Skills

Beginner

Intermediate

Advanced

The USTA’s mission is To Promote and Develop the Growth of Tennis.The United States Tennis Association (USTA) is the national governing body for the sport of tennis and the recognized leader in promoting and developing the sport’s growth on every level in the United States, from local communities to the crown jewel of the professional game, the US Open.

Founded in 1913, Beta Gamma Sigma is the international business honor society for AACSB-accredited schools, which are the top 5% of business school programs around the world. Inducted as students, BGS members go on to serve in critical leadership roles in corporate, entrepreneurial, government, non-profit, and academic sectors. Members currently reside in all 50 U. S. states and more than 190 countries. Notable members include Nobel Prize winners, Olympians, inventors, CEOs of major global companies and nonprofit organizations, deans of the top business schools, and others who are making the world a better place at all levels of contribution through social enterprise, service, and leadership. Beta Gamma Sigma is a proud member of the Association of College Honor Societies (ACHS).

Honors Program

Associate in Reinsurance (ARe)

Tutor students in multiple levels of mathematics and statistics.  The groups could be as few as one-on-one to as large as 15 students per tutor.

Q Center Tutor

Worked as a tutor for a local company that comprised of tutoring high school students in AP courses as well as SAT prep.

Mathematics Tutor

One-on-one virtual tutoring with a wide range of topics.

Math & Stat Tutor

Students can expect a tutor with 10+ years of Excel experience on top of someone who uses it for both personal and business use.  Whether its a side project for yourself or an important buisness presentation, know you can lean on me for success in all the areas you may need.

I’m beyond grateful for Marc! He’s patient and so knowledgeable. His ability to break information down is so helpful when one feels lost. He definitely knows his stuff! Thanks so much Marc!!!!

Marc extremely knowledgeable and patient! I’ve learned so much in a short time! So happy I found him.

He explained everything very well. I understood what he explained.

Marc is a great teacher and really knows his Calculus. After taking lessons with Marc my Calculus scores jumped 2 grades. Thanks Marc!

What can I say about this guy.  He helped me get a 34 on the ACT Math section, A 34 OVERALL ON MATH!  The way Marc breaks down concepts and how he is always looks for better ways to explain concepts to me.  11/10 and would recommend for anyone who needs math help!

Marc was incredible.  Not only did he provide old tests for me to practice but he walked me through step by step solutions.  He reinforced what I knew and walked me through what I didn't.  11/10 would recommend to any and everyone!

Marc has been extremely helpful with with homework/review materials for AP calculus. We've been really happy with his ability to step through the process of explaining how to solve problems and work through challenging equations.

Was very helpful with my SAT tutoring and explained everything very well.  Such a smart guy.
thanks marc.

Helped me understand my calculus homework in no time.  Very patient and very thorough. Thank you.

Marc was and still is incredible, because of him I was able to get an 800 on my SAT Math section!  Still waiting to hear from colleges but I think this might give me the leg up to get into my top college choice!  Marc is a miracle worker and I can't thank him enough!

Extremely helpful in getting a handle on what I am dealing with and the challenges I have, and dove straight into my issues and preparing me with both fundamentals and what I need to succeed for a test Wed. Followed up with another appointment time for Tuesday so I can be ready as possible for the test. Stayed late to explain some harder questions and understands this is a very important time for me. Thank you. 100 out of 100.

So my last three grades due to your help are 87 100 87. I’m passing with an A. Thank you for all of your help mark you are the 5th tutor I’ve had and the only one who didn’t get frustrated when I didn’t understand and actually cared. You’re a gem and thanks to you I can finally move on to higher ed. I’m graduating but I’m going to leave you the beat review I can and recommend. Please stay a tutor if you have the ability to in the future (I hope you do lol) and if you are I’ll message you if I have any more calc in grad school. Once again thank you for everything Marc. You’re the best.

He has been really helpful in teaching me concepts and helping me get homework done so I can understand it and be able to practice these concepts on my own which is really helpful. Also it's great to have calculator tips and shortcuts that make problems easier to solve. Marc has been really flexible and available with timing which has been really helpful.

This video will quick explain to you what Vlookup and Xlookup do.  I will go over typing in the formulas and how to set them up.  Finally I will explain the differences and where one shines over the other.

Vlookup vs Xlookup

This Video will go over Averages in Statistics.  You can expect to see these in your standardized tests as well as your statistics tests.  We will go over the difference between Mean, Median, and Mode and their applicability.  By the end of this lesson you will feel confident on the differences between the 3, know how to calculate them given a dataset, and their significance in different scenarios.

Averages: Mean vs Median vs Mode

This class will demonstrate linking websites to cells in Excel.  We will show how to grab the website link and then use the address in the cell.  This will work with your browser of choice but I will be using Google Chrome.

Linking Websites in Excel

In this video I will go over sorting and filtering data and tables in Excel.  I will go over the difference between sorting data and filtering data and how it affects the Excel workbook.  By the end of this video you will know how to sort and filter your data like a pro

Sorting & Filtering Data

In this video I will show you how to activate the Solver Add-In in Excel.  This add-in can do math problems for you as long as you already have your formulas setup.

Solver Add-In (Excel Does Math For You!)

In this video we will go over what conditional formatting is and how you can use it to point out cells with certain characteristics.

Conditional Formatting & It's Uses

This video will walk you through the basics of the Power Rule, Product Rule, & Quotient Rule.  I will start with the base formulas and generic cases.  Then we will do actual examples so you can see derivatives in practice.

Derivatives: Power Rule, Product Rule, & Quotient Rule

In this video we will talk about how to multiply 2 different sets of parentheses together.  We will cover the 2x2 case where we use FOILing.  Then I will broaden your understanding, so you know how to multiply them together regardless of size!

FOILing and Multiplying Parentheses

In this video we will talk about how to multiply 2 different sets of parenthesis together.  We will cover the 2x2 case where we use FOILing.  Then I will broaden your understanding so you know how to multiply them together regardless of size!

Marc L.