Microsoft Excel VBA Value Özelligi Ve Kullanımıİleri Excel 13 Ders

Name: Microsoft Excel VBA Value Özelligi Ve Kullanımıİleri Excel 13 Ders
Uploaded: 2020-05-25T14:59:29.000Z
Duration: 24 min 55 s

Introduction to VLOOKUP

In this video, the speaker introduces the concept of VLOOKUP and explains how it can be used to retrieve data from a table.

Definition of VLOOKUP

VLOOKUP is a function that retrieves data from a table based on a specified value in a particular column.

It can be used to find an exact match or an approximate match using wildcards.

The function takes four arguments: lookup_value, table_array, col_index_num, and range_lookup.

Using VLOOKUP in Excel

To use VLOOKUP in Excel, first select the cell where you want to display the result.

Then enter "=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)" into the formula bar.

Replace "lookup_value" with the value you want to search for in the table.

Replace "table_array" with the range of cells that contains your table data.

Replace "col_index_num" with the number of the column containing the data you want to retrieve.

Finally, replace "range_lookup" with either TRUE or FALSE depending on whether you want an approximate match or an exact match.

Examples of Using VLOOKUP

The speaker provides examples of using VLOOKUP by selecting a cell and entering "=VLOOKUP(lookup_value,A1:B10,2,FALSE)" into the formula bar.

This will return the value in column 2 of A1:B10 where lookup_value is found in column 1.

The speaker also demonstrates how to use wildcards for approximate matches by changing range_lookup to TRUE.

Using Range Function

In this section, the speaker explains how to use the Range function in Excel.

Definition of Range Function

The Range function is used to select a range of cells in Excel.

It takes two arguments: start_cell and end_cell.

Using Range Function in Excel

To use the Range function, first select the cell where you want to display the result.

Then enter "=Range(start_cell:end_cell)" into the formula bar.

Replace "start_cell" with the cell where you want to start your range selection.

Replace "end_cell" with the cell where you want to end your range selection.

Examples of Using Range Function

The speaker provides examples of using the Range function by selecting a cell and entering "=Range(A1:B10)" into the formula bar.

This will select all cells between A1 and B10.

Using IFERROR Function

In this section, the speaker explains how to use the IFERROR function in Excel.

Definition of IFERROR Function

The IFERROR function is used to handle errors that may occur when using other functions in Excel.

It takes two arguments: value and value_if_error.

Using IFERROR Function in Excel

To use the IFERROR function, first select the cell where you want to display the result.

Then enter "=IFERROR(value,value_if_error)" into the formula bar.

Replace "value" with any formula or expression that may produce an error.

Replace "value_if_error" with any value or expression that should be displayed if an error occurs.

Examples of Using IFERROR Function

The speaker provides examples of using IFERROR by selecting a cell and entering "=IFERROR(1/0,"Error")" into the formula bar.

This will display "Error" if the formula 1/0 produces an error.

Using Empty Quotes to Clear Cell Contents

In this section, the speaker explains how to use empty quotes to clear cell contents in Excel.

Using Empty Quotes in Excel

To clear the contents of a cell in Excel, select the cell and enter "" into the formula bar.

This will replace any existing content with an empty string.

Examples of Using Empty Quotes

The speaker provides examples of using empty quotes by selecting a cell and entering "" into the formula bar.

This will clear any existing content from the selected cell.

Adding Buttons to Excel Sheets

In this section, the speaker explains how to add buttons to Excel sheets.

Adding Buttons in Excel

To add a button to an Excel sheet, first go to the Developer tab and click on Insert.

Then select a button shape from the list of available shapes.

Drag and drop

Matematiksel İşlemler

In this section, the speaker demonstrates how to perform basic mathematical operations in Excel. They also show how to use the CONCATENATE function to combine text strings.

Basic Mathematical Operations

The speaker performs a simple addition operation by typing "200 + 13" into a cell and pressing enter.

They explain that Excel automatically performs the calculation and displays the result.

The speaker demonstrates how to use the CONCATENATE function to combine text strings.

They explain that it is not possible to perform multiplication or other mathematical operations on text strings.

Using Parentheses

The speaker explains that parentheses can be used in Excel formulas to control the order of operations.

They demonstrate how to use parentheses in a formula by typing "(10 + 1) * 2" into a cell and pressing enter.

Font Özellikleri

In this section, the speaker discusses font properties such as size, typeface, color, boldness, italics, and underlining.

Font Properties

The speaker explains that font properties can be adjusted using various formatting options in Excel.

They demonstrate how to adjust font properties such as size and color using these formatting options.

Combining Text Strings with Font Properties

The speaker shows how combining text strings with font properties can create visually appealing documents.

They encourage viewers to practice using these techniques in their own work.