Course Content

Introduction to Data Analysis With Excel

20m 17s

How to use LearnVern

3m 20s

What is data analysis and where to use it

16m 29s

How to use Percentage Variance and Round functions in Excel

32m 25s

How to use count and different types of count functions?

18m 10s

How to perform calculations on string data using excel spread sheet functions?

24m 30s

How to calculate age and words count using excel spread sheet functions?

22m 13s

How to perform calculations using Date and Time functions

20m 48s

How To Perform Calculations On Time and Completion of Year Percentage Using Excel Spread Sheet Formulas

17m 55s

How To Find The Last Day And Nth Weekday Of The Month Using Date Functions

30m 43s

How To Perform Conditions Using Date And Time Functions

19m 46s

How To Perform Calculations Using Logical Operators On Given Data With Excel Spread Sheet Functions

21m 10s

How To Perform Calculations On Data Using Excel Spread Sheet Functions And Conditions

30m 28s

Excel With Formulas Quiz

5m

What Is Conditional Statements And How To Perform Calculations Using Logical Operators

13m 37s

How To Perform Calculations On Different Data Types With Multiple Conditions Using Logical And Operator

35m 26s

How To Use Multiple AND & OR Logical Operator With Conditions In Excel Spread Sheet

16m 30s

How To Perform Calculations Using One Logical OR and Multiple AND Operators with Ifelce Conditions

17m 39s

How To Perform Calculations And Check Output In Different Way Using Logical OR and NOT Operator

26m 13s

How And Where To Perform Calculations Using Logical XOR Operators With IFELSE conditions

24m 12s

Assignment On Conditional Statements and Logical Operators Assignment

12m 10s

Conditional Statement & Logical Operators Quiz

4m

What Is Statistics And Statistical Function

27m

What Is Intermediate Statistical Functions

17m 13s

What Is Difference Between Absolute And Relative Cell Reference

28m 59s

What And How To Use Index Function

17m 51s

What And How To Use Match Function

21m 50s

How To Use MMM Formula In Excel Spread Sheet

27m 23s

How To Use Percentiles In Excel Spread Sheet With Example

12m 56s

How To Use Quartile Using Match Function

12m 56s

What Is Outliers And Statistical Outliers

21m 25s

How To Use Leveraged Interquartile Range IQR

29m 35s

How To De Seasonalize Data Before Forecasting Using Excel Spread Sheet

40m 24s

Common Excel Spread Sheet Statistical Functions Quiz

5m

What And How To Use Conditional Formatting

20m 13s

Examples Using Conditional Formatting

22m 59s

Examples That Highlight Dates And Statistical Outliers Using Conditional Formatting

34m 19s

Assignment On Formula Based Conditional Formatting

8m 8s

Formula based Conditional Formatting Quiz

5m

What Is Data Visualization And How To Use

21m 46s

What Is The Importance Of Data Visualization

26m 59s

What Are The Common Data Types While Analysing Data

34m 32s

How To Use Different Charts For Data Analysis Presentation And Reporting

18m 49s

When To Use Histogram And Bullet Chart

24m 38s

When To Use Actual vs Target And Funnel Chart

23m 1s

How To Calculate Gross Profit Margin And Gross Profit Margin Percent

18m 18s

How To Calculate COGS EBIT And EBITDA

27m 34s

How To Calculate Customer Churn Return On Equity And Avg. Customer Lifetime Value In Excel Spread Sheet

25m 15s

How To Calculate Employee Turnover And Interest Rates

21m 32s

How To Calculate Effective Rate With FV

10m 12s

How To Create Loan Payment Calculator In Excel Spread Sheet

5m 9s

How To Create Mortgage Amortization Schedule And Dates Instead Of Payment Numbers

25m 43s

How To Calculate Depreciation Accelerated Depreciation And Present Value

39m 50s

How To Calculate Present Value Of Future Payments And Net Present Value

20m 16s

How To Calculate IRR Positive And Negative And Non-Periodic Cash Flows

30m 41s

When To Use Each Chart Or Graph Type In Excel Spread Sheet

21m 43s

How To Use Data Visualizations Examples On Extraction Of Data

23m 5s

Assignment On Data Visualization

5m 27s

Data Visualization And Financial Formulas Quiz

5m

How To Format And Customize Chart In Excel Spread Sheet

27m 49s

How To Customize Axes In Excel Spread Sheet Charts

18m 16s

How To Add Labels Hiding And Editing Data In Excel Spread Sheet Charts

26m 58s

When To Use Each Chart Or Graph Type In Excel Spread Sheet

21m 43s

How To Use Scatter Area Stock Radar And Waterfall Chart In Excel Spread Sheet

24m 13s

Assignment On Excel Chart Formatting and Customization

3m 12s

What Is Mastering Advance Excel Spread Sheet Chart And Graph

35m 13s

How To Create a DOT PLOT Chart In Excel Spread Sheet

28m 1s

How To Create a DUMBELL And PANEL Chart In Excel Spread Sheet

39m 16s

Assignment On Mastering Advance Excel Charts and Graphs

2m 35s

What When And How To Use Pivot Table

22m 55s

How To Group Pivot Table Items And Get Data In Right Format With Pivot Tables

34m 52s

How To Use Frequency Distribution And Slicers To Filter Pivot Tables Data

26m 40s

How To Update Pivot Table And Perform Calculations In Excel Spread Sheet

29m 9s

Assignment On Formatting Data with Pivot Tables

4m 44s

Formatting Data With Pivot Tables Quiz

4m

How To Perform Sorting Filtering And Grouping Data With Pivot Tables Using Excel Spread Sheet

31m 57s

Assignment On Sorting, Filtering and Grouping with Pivot Tables

1m 2s

What Is Calculated Field And How To Use Them

19m 46s

Steps To Add Calculated Field In Pivot Table With Excel Spread Sheet

13m 13s

How To See Or List All Calculated Fields In Excel Spread Sheet

21m 22s

How To Delete Or Hide Calculated Fields

30m 40s

Assignment On Enriching Data With Pivot Table

2m 30s

How To Visualize Data With Pivot Charts

23m 45s

Why And How To Use Forecasting Linear Regression In Excel Spread Sheet

25m 42s

How To Implement Linear Regression

7m 57s

What Is Logistic Regression And Difference Between Linear And Logistic Regression

37m 50s

Visualizing Data with Excel Spread Sheet Pivot Charts Quiz

2m

How To Implement Linear Regression Analysis In Excel Spread Sheet

43m 25s

How To Implement Logistic Regression Analysis In Excel Spread Sheet

18m 13s

Linear & Logistic Regression Quiz

5m

Different Types Of Examples Using Lookup Function

Excel For Data Analysis Lookup Reference Text Date & Time Functions

Enroll Now For Free
Previous Next
Discussion
Previous Discussion Next
Previous
Next
  • Formulas

Course Content

Introduction to Data Analysis With Excel

20m 17s

How to use LearnVern

3m 20s

What is data analysis and where to use it

16m 29s

How to use Percentage Variance and Round functions in Excel

32m 25s

How to use count and different types of count functions?

18m 10s

How to perform calculations on string data using excel spread sheet functions?

24m 30s

How to calculate age and words count using excel spread sheet functions?

22m 13s

How to perform calculations using Date and Time functions

20m 48s

How To Perform Calculations On Time and Completion of Year Percentage Using Excel Spread Sheet Formulas

17m 55s

How To Find The Last Day And Nth Weekday Of The Month Using Date Functions

30m 43s

How To Perform Conditions Using Date And Time Functions

19m 46s

How To Perform Calculations Using Logical Operators On Given Data With Excel Spread Sheet Functions

21m 10s

How To Perform Calculations On Data Using Excel Spread Sheet Functions And Conditions

30m 28s

What Is Conditional Statements And How To Perform Calculations Using Logical Operators

13m 37s

How To Perform Calculations On Different Data Types With Multiple Conditions Using Logical And Operator

35m 26s

How To Use Multiple AND & OR Logical Operator With Conditions In Excel Spread Sheet

16m 30s

How To Perform Calculations Using One Logical OR and Multiple AND Operators with Ifelce Conditions

17m 39s

How To Perform Calculations And Check Output In Different Way Using Logical OR and NOT Operator

26m 13s

How And Where To Perform Calculations Using Logical XOR Operators With IFELSE conditions

24m 12s

Assignment On Conditional Statements and Logical Operators Assignment

12m 10s

What Is Statistics And Statistical Function

27m

What Is Intermediate Statistical Functions

17m 13s

What Is Difference Between Absolute And Relative Cell Reference

28m 59s

What And How To Use Index Function

17m 51s

What And How To Use Match Function

21m 50s

How To Use MMM Formula In Excel Spread Sheet

27m 23s

How To Use Percentiles In Excel Spread Sheet With Example

12m 56s

How To Use Quartile Using Match Function

12m 56s

What Is Outliers And Statistical Outliers

21m 25s

How To Use Leveraged Interquartile Range IQR

29m 35s

How To De Seasonalize Data Before Forecasting Using Excel Spread Sheet

40m 24s

What And How To Use Conditional Formatting

20m 13s

Examples Using Conditional Formatting

22m 59s

Examples That Highlight Dates And Statistical Outliers Using Conditional Formatting

34m 19s

Assignment On Formula Based Conditional Formatting

8m 8s

What Is Data Visualization And How To Use

21m 46s

What Is The Importance Of Data Visualization

26m 59s

What Are The Common Data Types While Analysing Data

34m 32s

How To Use Different Charts For Data Analysis Presentation And Reporting

18m 49s

When To Use Histogram And Bullet Chart

24m 38s

When To Use Actual vs Target And Funnel Chart

23m 1s

How To Calculate Gross Profit Margin And Gross Profit Margin Percent

18m 18s

How To Calculate COGS EBIT And EBITDA

27m 34s

How To Calculate Customer Churn Return On Equity And Avg. Customer Lifetime Value In Excel Spread Sheet

25m 15s

How To Calculate Employee Turnover And Interest Rates

21m 32s

How To Calculate Effective Rate With FV

10m 12s

How To Create Loan Payment Calculator In Excel Spread Sheet

5m 9s

How To Create Mortgage Amortization Schedule And Dates Instead Of Payment Numbers

25m 43s

How To Calculate Depreciation Accelerated Depreciation And Present Value

39m 50s

How To Calculate Present Value Of Future Payments And Net Present Value

20m 16s

How To Calculate IRR Positive And Negative And Non-Periodic Cash Flows

30m 41s

When To Use Each Chart Or Graph Type In Excel Spread Sheet

21m 43s

How To Use Data Visualizations Examples On Extraction Of Data

23m 5s

Assignment On Data Visualization

5m 27s

How To Format And Customize Chart In Excel Spread Sheet

27m 49s

How To Customize Axes In Excel Spread Sheet Charts

18m 16s

How To Add Labels Hiding And Editing Data In Excel Spread Sheet Charts

26m 58s

When To Use Each Chart Or Graph Type In Excel Spread Sheet

21m 43s

How To Use Scatter Area Stock Radar And Waterfall Chart In Excel Spread Sheet

24m 13s

Assignment On Excel Chart Formatting and Customization

3m 12s

What Is Mastering Advance Excel Spread Sheet Chart And Graph

35m 13s

How To Create a DOT PLOT Chart In Excel Spread Sheet

28m 1s

How To Create a DUMBELL And PANEL Chart In Excel Spread Sheet

39m 16s

Assignment On Mastering Advance Excel Charts and Graphs

2m 35s

What When And How To Use Pivot Table

22m 55s

How To Group Pivot Table Items And Get Data In Right Format With Pivot Tables

34m 52s

How To Use Frequency Distribution And Slicers To Filter Pivot Tables Data

26m 40s

How To Update Pivot Table And Perform Calculations In Excel Spread Sheet

29m 9s

Assignment On Formatting Data with Pivot Tables

4m 44s

How To Perform Sorting Filtering And Grouping Data With Pivot Tables Using Excel Spread Sheet

31m 57s

Assignment On Sorting, Filtering and Grouping with Pivot Tables

1m 2s

What Is Calculated Field And How To Use Them

19m 46s

Steps To Add Calculated Field In Pivot Table With Excel Spread Sheet

13m 13s

How To See Or List All Calculated Fields In Excel Spread Sheet

21m 22s

How To Delete Or Hide Calculated Fields

30m 40s

Assignment On Enriching Data With Pivot Table

2m 30s

How To Visualize Data With Pivot Charts

23m 45s

Why And How To Use Forecasting Linear Regression In Excel Spread Sheet

25m 42s

How To Implement Linear Regression

7m 57s

What Is Logistic Regression And Difference Between Linear And Logistic Regression

37m 50s

How To Implement Linear Regression Analysis In Excel Spread Sheet

43m 25s

How To Implement Logistic Regression Analysis In Excel Spread Sheet

18m 13s

FAQs

When you need to search in a single row or column and find a value from the same point in a second row or column, use LOOKUP, one of the lookup and reference functions. Consider the following scenario: you know the component number for a car part but not the price.

  • The function of ADDRESS.
  • THE FUNCTION OF THE AREAS
  • UNIQUE PURPOSE.
  • SELECT A FUNCTION.
  • COLUMN PURPOSE.
  • COLUMNS ARE USEFUL.
  • INDEX PURPOSE.

The VLOOKUP function does a vertical lookup by searching the first column of a table for a value and returning it in the index number position in the same row. The VLOOKUP function is a Lookup/Reference Function that comes with Excel.

Select the data from cells A2 through C6 to designate the range for Vlookup. Then, in the Name Box, we may give the table range any name we want, as shown below. As illustrated below, modify the name to Sales Info. We'll use Vlookup in the second table once more, just like we did before.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere