Name: Microsoft Excel - Use VLOOKUP Function to Populate data
Uploaded: 2022-12-30T17:35:57.000Z
Duration: 11 min 22 s
Description: This video shows how to use the VLOOKUP function in Microsoft Excel to populate a column in a data sheet. This includes an introduction into how to fix cell references using dollar signs, which allows you to copy a formula down for an entire column.

This video shows how to use the VLOOKUP function in Microsoft Excel to populate a column in a data sheet. This includes an introduction into how to fix cell references using dollar signs, which allows you to copy a formula down for an entire column.

Microsoft Excel

I am very excited at the prospect of helping you in  Math or Microsoft Excel. I have always greatly enjoyed Math, and even more enjoy that moment when a difficult concept just clicks for a student. I have tutored Math since high school, and I believe I have a knack for explaining difficult concepts in a straightforward way. 

I have worked professionally as a tutor while I was in college and graduate school, where I received a Masters in Mathematical Finance. Though math came naturally to me, I spent a lot of time honing my skills on how to explain it to others.

Studies have shown that building confidence helps students perform better on math exams, and I aim to build confidence by providing a solid foundation in understanding key concepts, and by sharing test-taking strategies as well. I am patient in my explanations and versatile to match each individual student’s learning style.

I have been tutoring for the past year and have enjoyed working with students at a variety of math levels. Prior to that I worked as a manager in the Finance industry for 15+ years. Although not direct tutoring, as a manager I successfully trained many new employees on complex concepts in financial mathematics - experience which I believe will translate to my tutoring practice. I am now tutoring on TakeLesson's platform while I return to graduate school.

I look forward to hearing from you and helping you succeed in your  studies!

Microsoft Excel - Use VLOOKUP Function to Populate data

eceedcf3-ac5a:37756;isclassifiedstrendingsuggestionsenableddt:42136;316f64c0-2415:46048;b2454379-d6cf:44572;335d7519-3303:46159;6d3f11ff-ee6c:47314;1a645375-144d:47316;ei83g319:53872;47h3f766:58362;fg008402:58376;i6jj6667:86739;istutorredesignv2_1:73124;a5gbd220:61179;blogpwt:71359;5db3b892:67466;2a2j8400:70238;b534g232:70741;j91hb444:69773;18h21436:69961;85h98405:81245;0eie7335:76839;cia78296:75037;9b4gd804:78753;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;241d3193:100431;9ab7j510:99496;86afb588:101093;bfb37872:105751;7f8gg909:114000;e36bg556:114647;

Algebra 1

Geometry

Statistics

Pre Calculus

Test Prep

Trigonometry

ACT Math

Math

Algebra 2

Beginner

Intermediate

Advanced

Market Risk Manager

English

Microsoft Excel is a powerful tool and I look forward to showing you all it can do. I will show you various ways to achieve what you are looking to do in Excel and also point out common pitfalls to watch out for. I have significant experience tutoring/training others and am patient, versatile to match each individual's learning style, and clear in my explanations. I look forward to working with you!

We got directly to my specific needs,  I loved that she could screen share, but let me  navigate so I could make the mistakes.  very helpful!

Danielle explains Excel in such a way that it’s easy to understand. She is an excellent teacher. 

Danielle is so patient easy to understand. She makes learning Excel a breeze. 

So nice, happy and encouraging! She made it easy to understand and I didn't even use the entire hour! I will definitely be coming back to Danielle. I feel very lucky to have found her!

Good job.  Got requested input.  Will use again .

Mrs. Danielle. She is sweet, kind, funny and joyful. She encourages you to do your best and be your best. She is filled of joy no matter what. And she knows her stuff! She works with my sister who is 5! I kid you not she says "Is there another class" and if I join another class "Is this the one with the blond hair who helps me with math?" So hop right in her class!  Its very fundamental.- love K&A

Conditional Formatting sounds complicated, but Microsoft Excel makes it simple. This video shows how to use conditional formatting to highlight cells that meet certain conditions, or criteria, such as the largest or lowest values in a range. This can be helpful for enhancing your reporting, or to help you quickly identify extreme values in your data.

Conditional Formatting in Microsoft Excel

Learn how to use filters in Microsoft Excel to quickly reveal data of interest in large data sets. Filters are very helpful to find extreme values or missing data, or to drill down to analyze records that meet given criteria. This video is useful for those with beginner or intermediate expertise.

Microsoft Excel - Using Filters to Quickly Find Data

Learn how to format tables in Microsoft Excel to visually enhance your reports. This video will walk you through how to format cells to create a polished look for reporting.

Formatting Tables in Microsoft Excel

Learn how to use Vlookup to combine data on different spreadsheets. In my experience, vlookup is one of the more commonly used Excel features in the workplace, as it enables users to combine data to make consolidated reports and to perform data reconciliations. This video describes how to perform vlookups and some of the common mistakes to look out for. It is appropriate for beginners or intermediate users.

Microsoft Excel - Use Vlookup to combine data from different sources

In order to use Microsoft Excel functionality, one must first often select (or highlight) ranges of cells. There are a number of ways to do this, and this video goes through some options that allow you to select large ranges of cells quickly.  

Microsoft Excel- Selecting Ranges of Cells 

Learn how to create and use pivot tables in Microsoft Excel! A pivot table is a user-friendly, flexible tools to help you quickly summarize data, which is much easier to use than it sounds. This video shows you how to create a pivot table. This video is appropriate even for beginners to Microsoft Excel. 

Creating Pivot Tables in Microsoft Excel

This video shows how to use the IF function in Microsoft Excel. This function is helpful when creating formulas that have different values depending on some other condition being met.

Microsoft Excel - IF function

This video goes over how to use the SumIf function in Microsoft Excel

Danielle W.

Microsoft Excel - Use VLOOKUP Function to Populate data

Danielle's Microsoft Excel videos

Conditional Formatting in Microsoft Excel

Microsoft Excel - Using Filters to Quickly Find Data

Formatting Tables in Microsoft Excel

Microsoft Excel - Use Vlookup to combine data from different sources

Microsoft Excel- Selecting Ranges of Cells

Creating Pivot Tables in Microsoft Excel

Microsoft Excel - IF function

Microsoft Excel - SUMIF Function

Microsoft Excel - Use VLOOKUP Function to Populate data

Teacher Reviews (6)

Book online lesson

How to Use RANK Function in Microsoft Excel

How to Use ROW Function in Microsoft Excel

Active Rows and Columns Highlighter in Microsoft Excel

How to Take Screenshot Using Microsoft Excel In-Built Camera

How to Use VSTACK Function in Microsoft Excel

How to Insert a Empty Row After Each Row in Microsoft Excel

How to create a step chart with Excel

Excel actual, budget, forecast chart tutorial

How to Create Folders for the List of Names using Microsoft Excel

How to Remove Spaces in Words In Microsoft Excel

Related Subjects