Excel Xpo

Lesson 03 - Excel Formulas

As you have now completed the introductory part of this tutorial, I have no doubt that you are now ready and prepared to go further into something more interesting and trust me, Excel is much more easy than you thought. In this lesson, we shall be looking at basic terms and uses of Microsoft excel and how to perform series of calculations - just basic tools you may require while using an Excel spreadsheet application for now. Lesson Objectives At the end of this lesson the reader should be; <ul>
<li>Familiar with the term Excel Formulas </li>
<li>Able to understand how to perform simple formulas </li>
<li>Able to Understand the meaning of cell Identity </li>
<li>Familiar with Cell references and the various types of cell referencing </li>
<li>Able to understand excel arguments and syntax in formulas </li>
<li>Able to use Excel Auto functions </li>
<li>Able to do Excel Auto calculate </li>
<li>Able to understand how excel performs its calculations </li>
<li>Able to use cell comment </li>
</ul>
 Excel Formulas <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCk9R0cMR1yXwpNGWQCkveSlsry01g1SkZya73gHN7O7VqgUysVNjRk0fQG_cX1_duN3cwmZy5ezwBD9hGfC6o2WBWjLchKY2vzmrZJKkPodW6uVXpsBdTIYaLMcJRegwpGddtxfZL6JME/s1600/42.png"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCk9R0cMR1yXwpNGWQCkveSlsry01g1SkZya73gHN7O7VqgUysVNjRk0fQG_cX1_duN3cwmZy5ezwBD9hGfC6o2WBWjLchKY2vzmrZJKkPodW6uVXpsBdTIYaLMcJRegwpGddtxfZL6JME/s1600/42.png" /></a> The Basics of Excel Formulas What are Excel formulas? Excel formulas may be described as a way of giving a set of commands to excel Cell(s) in order to perform a particular function in an excel worksheet. This function of Excel is what makes it the best Spreadsheet application ever, as virtually everything and anything you can think about is possible - to the tune of you defining your personal formulas (UDF) - this is what interest me most about Excel, just like building up a robot and programming it to perform a particular task, all what is required is just a one time setup and oops! the robot keep performing the task seamlessly. Do not worry you would soon start making up your own formulas on Excel. Our focus for now is looking at the basics of Excel formulas and gradually integrate into slightly complex formulas and functions. Functions (fx) <div>
A function may be define as a single predefined formula and Excel has over 300 of such built-in Functions installed by default which are divided into ten categories: Financial, Date & Time, Math & Trig, Statistical, Lookup & Reference, Database, Text, Logical etc. to see all the functions open an excel workbook, on the formula bar click on “fx” then open up the category box. <a href="http://www.excelxpo.blogspot.com/"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhccJ-yWhG5RkvD-WT3e1rIniQfKPaYUDRV-ZFOFZN1BNtxHXd34ZH8WpcwDJI5b_yTI10PHR8PhwZHOctQI9spsooh50X-Om4aisNzog44eR6XYsTAvnuXhiVuSp9yyHYmXUVFF7gtDyU8/s640/Icon7.png" /></a> Most times, we might have to combine more than one Excel functions in order to create a particular formula, don’t be scared about the length of the characters, you can perfect and design much shorter forms later. I have found this technique very useful and it works for me, always have a schematics of what formula you want to build and follow the simple steps I shall be discussing below. For example we might use the IFERROR, IF, SUM and the COUNT function together in the same cell to create a single formula. Simple rules to creating a Formula and Function <ul>
<li>All Formulas And Functions Must Begin With A = (Equal Sign) </li>
<li>A Plus (+) minus (-) or Macintosh ({}) may also be used to some formulas </li>
<li>For every open parenthesis (brackets) there must be a closing Parenthesis. </li>
</ul>
 <a href="http://excelxpo.blogspot.com/2017/02/lesson-04-excel-formula-contd.html">Click here to go to the lesson continuation....</a> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimwrgg0x6LZ-ZGHPfY3qISlhyfmBro4vg0gckJQxzxCq801wbe1U_esGy4yB2wZl9VH-Jv9S93BztiIOflHbbekxVT3tnBdbwi84OXrzOoBaO-QCyeGQrYtYBI1yVf1Oni3m7Oerd59iNo/s1600/Justbrokem.JPG"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimwrgg0x6LZ-ZGHPfY3qISlhyfmBro4vg0gckJQxzxCq801wbe1U_esGy4yB2wZl9VH-Jv9S93BztiIOflHbbekxVT3tnBdbwi84OXrzOoBaO-QCyeGQrYtYBI1yVf1Oni3m7Oerd59iNo/s1600/Justbrokem.JPG" /></a> </div>

Lesson 03 - Excel Formulas

As you have now completed the introductory part of this tutorial, I have no doubt that you are now ready and prepared to go further into som...

Lesson 06 - Excel Formulas Contd.

0 8:41 AM

Lesson Objectives At the end of this lesson the reader should be; <ul>
<li>Able to create understand how to create formulas </li>
<li>Able to use the Sum function </li>
<li>Familiar with Cell references and the various types of cell referencing </li>
<li>Able to understand excel arguments and syntax in formulas </li>
<li>Able to use Excel Auto functions </li>
<li>Able to do Excel Auto calculate </li>
<li>Give name to a cell or Ranges as an alternative to Cell References </li>
<li>Able to understand how excel performs its calculations</li>
</ul>
<div>
<ul>
</ul>
</div>
 
 
<h3>
Creating a formula in Excel using the “SUM function” </h3>
 Recall from our previous lesson, we discussed that to make a valid Excel formula, there are basically two rules to follow; 
 
 
<ol>
<li>The formula must start with an equal to sign (=), Plus sign (+), minus sign (-) or a Macintosh ({}) used for an array type of formulas.</li>
<li>The right use of brackets and a comma to separate arguments from each other is very important</li>
</ol>
The SUM function is used to add up numbers in cells. Note if there are text within the range selected for the SUM function, the Sum function will ignore those text. There are 2 basic reading the system understands "text" and "strings", strings are basically numbers while text are alphabets, punctuation marks etc. Note: A number may also be stored as a text by applying an apostrophe at the front of the figure.  
 
 
<h4>
How to apply the SUM function</h4>
Type the number 1 to 10 in cell A1:J1, then on cell K1, type (=sum) then type an Open bracket “(“ , and type (A1:J1) then type a close bracket “)”. Your formula on cell K1 should look like this “ =sum(A1:J1)” 
 Also try this on Cell K2 – Type (=sum) then type an Open bracket “(“ , and type (A1) then type a comma “,” type (C1), type a comma “,”, then type (J1) and then close the bracket “)”. Your formula should look like this “=Sum(A1,C1,J1)” 
 Now let’s analyze the two formulas  
 Sum (A1:J1) – Contains a single argument and excel will always add up anything withing the range A1 through J1 
 Sum(A1,C1,J1) – Contains 3 arguments and excel will only add up the specified cells (A1, C1 and J1)  
 Note – Some functions requires one arguments while others can require more e.g. a “VLOOKUP()” function will take only four arguments. 
 
<h3>
Auto Functions /Insert Functions(fx)</h3>
The Excel auto functions/insert functions makes the use of Excel functions easier and you don’t have to worry about forgetting any formula. Just open up the fx category box as I explained earlier and you can read the uses of each predefined functions 
 Let’s try this with an Excel AutoSum Function. On a clean Worksheet insert any numbers In the Range D5:D10 and F5:J5, Select Cell D15 and Click the AutoSum Icon on the Standard Toolbar or select the Sum function from the function category box.  
 You should get the formula =SUM(D5:D14)  
 
<h3>
Excel AutoCalculate</h3>
There might be times when you wish to find out the sum of a range of numbers quickly without having to add a formula to the Worksheet. The AutoCalculate feature of Excel would make this very easy and possible for you. To make use of this function, select a range of cells containing the numbers you want to sum and look in the Status bar for the result. If the Status bar is not visible go to View - Status bar. If the range of cells you wish to sum are not on same rows hold down the Ctrl key while selecting the ranges. You change to other functions like count and average if you are using the older version of Excel, otherwise the newer version would automatically display all available result for you. 
 Other commonly used functions in excels are the; AVERAGE, COUNT, COUNTBLANK, COUNTA, COUNTIF, MAX, MIN, SUMIF, AVERAGEIF,  
 
<h3>
AVERAGE</h3>
The AVERAGE function is used to return the average of the arguments supplied. 
 Syntax 
 AVERAGE(number1,number2, . . . ) 
 The AVERAGE function can take up to 30 arguments. 
 The arguments supplied must be numeric or references to numeric values. Text and/or references to text are ignored. It is important to note that cells containing zeros are NOT ignored. This can give you unexpected results if you are not aware of it. 
 =AVERAGE(A1:A3) would equal 10 if A1:A3 contained 15, 5, 10 respectively 
 
 
<h4>
COUNT</h4>
The COUNT function is used to count numbers or references to numbers in a range. 
 Syntax 
 COUNT(value1,value2, . . . ) 
 The COUNT function takes up to 30 arguments and each argument can be a variety of data types, but only numbers are counted. 
 If the range reference supplied contains valid dates these will also be counted. 
 =COUNT(A1:A5) would equal 3 if cells A1:A5 contained Boy, Man, house, 8, dog 
 
 
 
<h4>
COUNTA</h4>
The COUNTA function is used to count non-empty cells. 
 Syntax 
 COUNTA(value1,value2, . . . ) 
 The COUNTA function takes up to 30 arguments and each argument should be a reference to a range. Cells within the range can be a variety of data types, but only non-empty cells are counted. 
 =COUNTA(A1:A5) would equal 4 if cells A1:A5 contained “ “, Man, house, Cat, dog. 
 Note A1 is empty and so is not counted while all other cells are. 
 
 
<h4>
COUNTBLANK</h4>
The COUNTBLANK function is used to count empty cells. It is the opposite of the COUNTA function 
 Syntax 
 COUNTBLANK(range) 
 The COUNTBLANK function takes 1 argument and this argument should be a reference to a range. Cells within the range can be a variety of data types, but only empty cells are counted 
 =COUNTBLANK(A1:A5) would equal 1 if cells A1:A5 contained “ “, Man, house, Cat, dog. 
 In other words A1 is empty and so is counted while all other cells are not. 
 
 
<h4>
COUNTIF</h4>
The COUNTIF function is used to count cells within a range that meet a specified criterion. 
 Syntax 
 COUNTIF(range,criteria) 
 The COUNTIF function takes two (2) arguments. The range argument is a reference to a range of cells, while the criteria argument is the criterion that should be met by the cells within range before they are counted. The criteria specified can be in the form of a number, text or an expression. 
 Number criteria 
 =COUNTIF(A1:A5,20) would equal 1 if cells A1:A5 contained 2000, 10000, 20, 0,1 
 In other words A3 is the only cell that meets the criteria of 20 
 Text criteria 
 =COUNTIF(A1:A5,”Lami”)  
would equal 2 if cells A1:A5 contained Bidemi, Ife, Lami, Femi, Lami 
 In other words A3 and A5 are the only cell that meets the criteria of “dog” 
 Expression criteria 
 =COUNTIF(A1:A5,”<20”) would equal 3 if cells A1:A5 contained 15, 30, 20, 0, 1. 
 In other words A1, A4 and A5 are the only cells that meets the criteria of “<20”. 
 
 
 
<h4>
MAX</h4>
The MAX function is used to return the largest number from a set of values. 
 Syntax 
 MAX(number1,number2,. . . ) 
 The MAX function takes up to 30 arguments and will ignore text. 
 =MAX(A1:A5) would equal 3 if cells A1:A5 contained 1, 2, 0, 3, -10 
 
 
 
<h4>
MIN </h4>
The MIN function is used to return the smallest number from a set of values. 
 Syntax 
 MIN(number1,number2,. . . ) 
 The MIN function takes up to 30 arguments and will ignore text. 
 =MIN(A1:A5) would equal -6 if cells A1:A5 contained 9, 8, -6, 10, 1. 
 
 
 
<h4>
SUMIF</h4>
The SUMIF function is used to return the sum value from a specified range that meets a criterion. This selection of the range must start from the range that contains the Criteria and covers the Sum_range where the result to sum is always start 
 Syntax 
 SUMIF(range,criteria,sum_range) 
 The SUMIF takes 3 arguments. The range is the range of cells to check the specified criteria from. Criteria is the Identity to look for in the range, the criteria specified can be in the form of a number, text or an expression. The sum_range is the range of cells to sum but only if the corresponding cells in the range meet the specified criteria. If sum_range is omitted then the cells within the range are summed up. 
 =SUMIF(A1:A5,10) would equal 30 if cells A1:A5 contained 10, 8, 5, 10, 10 (cells A1, A4 and A5 would be summed as they meet the criteria and NO sum_range was supplied). 
 =SUMIF(A1:A5,5,B1:B5) would equal 2 if cells A1:A5 contained 5, 4, 1, 9, 5 and cells B1:B5 contained 1,1,3,8,1.(cells B1 and B5 would be summed as the corresponding cells in A1:A5 have a value of 5). 
 =SUMIF(A1:A5,”Boy”,B1:B5) would equal 15 if cells A1:A5 contained Boy, Boy, Boy, Girl, Girl and cells B1:B5 contained 5,5,5,8,11 
 ( cells B1,B2 and B3 would be summed as the corresponding cells in A1:A5 contain the text “Boy” ). 
 =SUMIF(A1:A5,”>5”) would equal 35 if cells A1:A5 contained 10, 15, 0, 10, 5 and In other words cells A1, A2 and A4 would be summed as they meet the criteria of >5. 
 
<h3>
Customize/Label Ranges as an alternative to Cell References</h3>
 In Excel we can give name to ranges for easy formula write-ups. For example we could name range A1: A7 Periods and name range B1:B7 Sales. If we are to use a SUMIF Function we would be referencing to range (B1:B7) as Sales and (A1:A7) Periods. Which makes the formula easy to comprehend and read. There are however certain rules one have to consider while naming a cell reference. These includes; 
 1. The first character of the name must be a character or an underscore “_” 
 2. Names cannot be the same as a cell reference e.g. XD100 or R1C1. 
 3. Spaces are not allowed, an underscore character may be used to separate words 
 4. A name can contain up to 255 Characters. 
 
<h4>
How to name ranges </h4>
Step 1.  
 This is the simplest way of naming a cell range in an Excel and very easy to use. 
 1. Type The Word Amounts In Cell B1 And Names In Cell C1 
 2. Type 5, 20, 40, 50, 100, 200 in Cell B2:B7 Respectively.  
 3. Type The Names; Femi, Nehita, Blessing, Jecky, Femi, Oye In Cells C2:C7 Respectively 
 4. Now select the Range B2:B7  
 5. Locate the “name box” in the already opened workbook by the top left hand-side corner at the back of the “fx” button. Then type the name you want to give to the cell reference already selected in step 4 above.  
 Step 2. 
 1. Type The Word Amounts In Cell B1 And Names In Cell C1. 
 2. Type 5, 20, 40, 50, 100, 200 in Cell B2:B7 Respectively.  
 3. Type The Names; Femi, Nehita, Blessing, Jecky, Ife, Oye In Cells C2:C7 Respectively 
 4. Now Select The Range B1:B7 go to Insert – Name - Create. This Is The Create Names Dialog Box And Is Used To Create Names Based On The Current Region Row And/Or Column Headings. In This Case We Only Have Column Headings So Ensure That Only The "Top Row" Check Box Is Checked. What We Have Done By Doing This Is Told Excel That We Wish To Name The Range B2:B7 Amounts And The Range C2:C7 Names 
 Test 
 Perform step 1 in a new Excel workbook.  
 1. Type The Word Amounts In Cell C1 And Names In Cell B1 
 2. Type 5, 20, 40, 50, 100, 200 in Cell C2:C7 Respectively.  
 3. Type The Names; Femi, Nehita, Blessing, Jecky, Femi, Oye In Cells B2:B7 Respectively 
 4. Now select the Range C2:C7  
 5. Locate the “name box” in the already opened workbook by the top left hand-side corner at the back of the “fx” button. Then type the name you want to give to the cell reference already selected in step 4 above, do similar for range B2 : B7 
 In Cell E7, use a SUMIF function to find the Amount spent by Femi 
 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9tNSCMeaD5GHApU4r_IEhU67Z2rqFUORqRUSffICpjuwzPVTqos60fJ82uaxbBQthBXHhBY88j7LQeiz1CEwNdfsWHBLlcBzDVoj4I508uXCqF466_DEf7S0PDIzFaXB0aAA1HMI35_dn/s1600/errrr.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9tNSCMeaD5GHApU4r_IEhU67Z2rqFUORqRUSffICpjuwzPVTqos60fJ82uaxbBQthBXHhBY88j7LQeiz1CEwNdfsWHBLlcBzDVoj4I508uXCqF466_DEf7S0PDIzFaXB0aAA1HMI35_dn/s1600/errrr.JPG" /></a></div>
 Note: Excel formulas only read strings therefore whenever it is required to use text in our formula, we first need to convert the text in a string format. to do this you will just append an apostrophe at the front of the text and immediately after the last character of the text. 
 So, putting Femi in our expression would become 'Femi' 
Joseph will become 'Joseph' 
Boy will become 'Boy' 
 
<div class="MsoNormal" style="line-height: 18pt; text-align: justify;">
<div style="margin: 0px;">
Congratulations! you have now successfully completed this lesson</div>
</div>
<div class="MsoNormal" style="line-height: 18pt; text-align: justify;">
<div style="margin: 0px;">
 </div>
</div>
<div class="MsoNormal" style="line-height: 18pt; text-align: justify;">
<div style="margin: 0px;">
 
 
 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjP-xasMPHp77PuqsvjCC6ett06SG-ZVm1zZIo75iK0xg5WoVUyXxAM_qcTR5O4Q9aoXDIZsecA4r3fvT83pJweAeFvN5LMON5SHuTsfh5-x8E1_huhu5sJ3l-ZQdpF6Cl5CekHZ0_i7BZg/s1600/Justbrokem.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjP-xasMPHp77PuqsvjCC6ett06SG-ZVm1zZIo75iK0xg5WoVUyXxAM_qcTR5O4Q9aoXDIZsecA4r3fvT83pJweAeFvN5LMON5SHuTsfh5-x8E1_huhu5sJ3l-ZQdpF6Cl5CekHZ0_i7BZg/s1600/Justbrokem.JPG" /></a></div>
 
<div>
 </div>
</div>
</div>

Lesson 06 - Excel Formulas Contd.

Lesson Objectives At the end of this lesson the reader should be; Able to create understand how to create formulas Able to use the Sum f...

Lesson 07 - VLOOKUP Function

0 8:38 AM

<div class="MsoNormal" style="margin: 0in;">
 
 VLOOKUP Function</div>
<div class="MsoNormal" style="margin: 0in;">
 </div>
<div class="MsoNormal" style="margin: 0in;">
 <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAm2szUygr-cVl8C6zy4YAFL2uMWFM42ACUlcpQ7pqY8WbtMLVdo2NJMmhoDM-OBGfic1i3HyvaLM4uSvplswa14Vr7P2AGC3xsI-dzFhafrfZV97odqIy73XoBtJiYzv_1iiyruB5lAGQ/s1600/lk.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAm2szUygr-cVl8C6zy4YAFL2uMWFM42ACUlcpQ7pqY8WbtMLVdo2NJMmhoDM-OBGfic1i3HyvaLM4uSvplswa14Vr7P2AGC3xsI-dzFhafrfZV97odqIy73XoBtJiYzv_1iiyruB5lAGQ/s1600/lk.JPG" /></a> 
 
 
 
Just like every other excel functions, Composing a formula with them is quite simple</div>
<div class="MsoNormal" style="margin: 0in;">
<o:p></o:p></div>
 
 
<div class="MsoNormal" style="margin: 0in;">
You know functions are the inbuilt excel functionality(fx) used in building up other formulas and there are tons of them, the likes of VLookup function =VLOOKUP( ), IF Fuction = IF( ), Index Function =Index( ) etc...</div>
<div class="MsoNormal" style="margin: 0in;">
 </div>
<div class="MsoNormal" style="margin: 0in;">
<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0in;">
We are concerned with VLOOKUP for now but just as I said early, </div>
<div class="MsoNormal" style="margin: 0in;">
it is the same approach to compose every other formula.</div>
<div class="MsoNormal" style="margin: 0in;">
<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0in;">
In my earlier posts I explained that a formula could be combination of more than one functions, just as you required it, we could add an IF function with a Sum function to make a single formula.</div>
<div class="MsoNormal" style="margin: 0in;">
 </div>
<div class="MsoNormal" style="margin: 0in;">
What is a VLOOKUP function? This is an Excel function used to search (lookup) for a data in a vertical array and return a desired result in front of the searched data within the selected range </div>
<div class="MsoNormal" style="margin: 0in;">
 </div>
<div class="MsoNormal" style="margin: 0in;">
<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0in;">
The major thing to understand about all these Functions are; Their Arguments and Syntax</div>
<div class="MsoNormal" style="margin: 0in;">
<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0in;">
Each argument is completed with a comma "," and these are our guide to making an active formula<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0in;">
 </div>
<div class="MsoNormal" style="margin: 0in;">
E.g VLOOKUP("Nehita",A2:B8,2,False) In the above Formula write up We have used only one function</div>
<div class="MsoNormal" style="margin: 0in;">
<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0in;">
 
 </div>
<div class="MsoNormal" style="margin: 0in;">
The Syntax in other words, is the type of input required in each arguments, note when a wrong input is inserted there is a syntax error and the result would not be correct.</div>
<div class="MsoNormal" style="margin: 0in;">
<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0in;">
 </div>
 
 
<div class="MsoNormal" style="margin: 0in;">
E.g =VLOOKUP(Lookup_Value, table_array, col_index_num, (range_lookup))<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0in;">
 </div>
<div class="MsoNormal" style="margin: 0in;">
From the above example, there are four Arguments - Lookup_Value, table_array, col_index_num, (range_lookup)</div>
<div class="MsoNormal" style="margin: 0in;">
 </div>
<div class="MsoNormal" style="margin: 0in;">
Lookup_Value as the name implies is the Data to Search out for E.g "Nehita"</div>
<div class="MsoNormal" style="margin: 0in;">
Table_Array is the range of your table starting from where the data to be looked up for is located</div>
<div class="MsoNormal" style="margin: 0in;">
 Col_index_num meaning Column index number, it is the count of the column within the selected range where desired result should be lifted from. 
 Range_lookup This is an additional functionality which enables us to specify how strictly the lookup value should be treated, whether Exact match of the search criteria or an Approximate match.</div>
<div class="MsoNormal" style="margin: 0in;">
 </div>
<div class="MsoNormal" style="margin: 0in;">
To Use this function,</div>
<div class="MsoNormal" style="margin: 0in;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJNAQ7m3ZqzcTN42G4hngqsN6u6FO_HUQZEtIm8NjQiSh2frjpYJf4ezvUSiIDANqRYfQdz6Pq1wW1Y7wDXVVmDnUVCIBTnePcpxcc2gRgWBXKZ2E0iBxgeTVJbwBLovcJLWXom2ixkQ1S/s1600/v.JPG.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="217" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJNAQ7m3ZqzcTN42G4hngqsN6u6FO_HUQZEtIm8NjQiSh2frjpYJf4ezvUSiIDANqRYfQdz6Pq1wW1Y7wDXVVmDnUVCIBTnePcpxcc2gRgWBXKZ2E0iBxgeTVJbwBLovcJLWXom2ixkQ1S/s400/v.JPG.png" width="400" /></a>Type " =VLOOKUP( " Excel would automatically bring up a pop up guide on how to complete this function</div>
<div class="MsoNormal" style="margin: 0in;">
Supply each argument using the right syntax and close up each argument with a Comma ","</div>
<div class="MsoNormal" style="margin: 0in;">
 </div>
<div class="MsoNormal" style="margin: 0in;">
Check for examples in the earlier lessons. 
 
<div class="MsoNormal" style="line-height: 18pt; text-align: justify;">
<div style="margin: 0px;">
 
 
 
 
Congratulations! you have now successfully completed this lesson</div>
</div>
<div class="MsoNormal" style="line-height: 18pt; text-align: justify;">
<div style="margin: 0px;">
 </div>
</div>
 
<div class="MsoNormal" style="line-height: 18pt; text-align: justify;">
<div style="margin: 0px;">
<a href="http://www.excelxpo.blogspot.com/">Please Check back soon for the next Lesson</a></div>
</div>
</div>
 
<div class="MsoNormal" style="margin: 0in;">
</div>
 
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; margin: 0in; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<div style="margin: 0px;">
 </div>
</div>

Lesson 07 - VLOOKUP Function

VLOOKUP Function Just like every other excel functions, Composing a formula with them is quite simple You know functions a...

Lesson 03 - Excel Formulas

Lesson 06 - Excel Formulas Contd.

Lesson 07 - VLOOKUP Function

Ads