Microsoft Excel is a powerful spreadsheet program used for calculating, data analysis, graphing etc. CELLS AND RANGE A cell is where a data is entered while a range is a selection of multiple cells. FORMULAS It is used to perform calculations with basic arithmetic operations. FUNCTIONS: e.g.SUMSum (Number 1,Numberb 2). It adds value in the …
What is Index? Index can be defined as a simple way of getting the value of a particular data from an array of table using row number and column number. It’s like a search tool that fetch out the specific value from a table array. If you are able to follow the examples in this …
SUMIF Function in exceḷ What is Sumif? Sumif can be defined as the addition of numbers based on condition or criteria. It can divided into two : a single column type and a double column type. I will be explaining further the difference between the 2 types in the example below In using a …
SUMIFS function is a little bit different from SUMIF function in that you can use it to get summation output/result from multiple criteria unlike SUMIF function that can only to get the summation based on a particular condition or criteria. The table below will help you to comprehend the difference between the two functions and …
GOAL SEEK GOAL SEEK is an excel in built in what_if_analysis tool that shows how one value is a formula impacts another.THE GOAL SEEK changes the variable to study the variation in the results…… It also determines what value you should input in a cell to get the desired results in a formula.. Steps …
HOW TO CREATE PIVOT TABLE AND CHART *CREATE A TABEL WITH THE REQUIRED INFORMATION. *GO TO INSERT , CLICK ON PIVOT TABLE OR CHART. *A PIVOT TABLE RANGE WILL BE PRESENTED. *FILL IN THE NECESSARY DATA REQUIRED THEN CLICK ON ENTER. *THE PIVOT TABL WILL BE SHOWN DEPENDING WETHER YOU CHOSE IT TO BE ON …
SCENARIO MANAGER EXCEL SCENARIO MANAGER is a collection of digital tools that allows a user to create ,analyze and compare data results in different business situations Key uses of scenario manager 1.RECORD SCENARIOS 2.CREATE TESTSTEPS AND TESTSTEPVALUES MANUALLY 3.MERGE TESTSTEPS 4.ADD ATTACHMENTS 5.RECORD ,EDIT AND EXPORT PICTURES E.T.C
HOW TO CREATE A FORM USING EXCEL *Create a table with header in microsoft excel *Go to files then click on “OPTIONS” *After clicking on “OPTIONS”,Click on “QUICK ACCESS TOOL BAR” *Under “CHOOSE COMMANDS FROM” Click on “COMMAND NOT IN RIBBON” *Then search for “FORM” and click on ENTER *Back to home; Highlight the cells …
INDEX Index function is a function in excel which gives the exact value in an array of data using the ROW NUMBER and the COLOUMN COLOUR FORMULA =INDEX(ARRAY,ROW_NUMBER,COLOUMN_NUMBER) MATCH MATCH FUNCTION is a function in excel which gives the relative position on an array of data using a specified order FORMULA =MATCH(LOOKUP_VALUE,LOOKUP_ARRAY,MATCH …
