Excel IF Function (10 Examples)
Excel IF Function The Excel IF function returns a value for TRUE and another result for FALSE. For example, if we write the formula =IF(B2>75, “Pass”, “Fail”) will return “Pass” if the value of B2>75. The Excel IF function allows to test multiple conditions by nesting IF. IF function can also be combined with AND/OR. […]
Excel SWITCH Function (5 Examples)
Excel SWITCH Function The Excel SWITCH function evaluates a given value against a list of values and returns the result corresponding to the first matching value. In this section: Advertisements Syntax of SWITCH Function. Product category based on rating. Calculate scholarship based on merits. Calculate discount based on membership type. Returns weekdays and weekend. To […]
Excel REPT Function (5 Examples)
Excel REPT Function The Excel REPT Function repeats text or values a given number of times. For example, =REPT(“Love”, 3) returns LoveLoveLove. In this section: Advertisements Syntax of REPT Function Repeat text 5 times. Create pipe charts in cells next to data. Insert Star Symbols for Ratings. Insert Bar charts next to data. REPT Function […]
Excel RIGHT Function (7 Examples)
Excel RIGHT Function The Excel RIGHT function returns the last character or characters in a text string, based on the number of characters users specify. for example, if we write the formula as =RIGHT(“Rich Brody”, 5), it returns Brody, the 5 characters from the last. In this section: Advertisements Syntax of RIGHT Function Extract the […]
Excel LEFT Function (7 Examples)
Excel LEFT Function The Excel LEFT Function, a text function, returns certain number of text specified by users. For example, if we write the formula as =LEFT(“AMAZON”, 3), it returns AMA, the first three characters from left. We can see that the LEFT function uses two arguments–the text or the cell references with the text […]
Excel MATCH Function (6 examples)
Excel MATCH Function The Excel MATCH Function returns the location reference of a particular value in a cell or range or a table. The MATCH function can be used for partial matching, exact matching, and wildcards. The MATCH function is used combined with the INDEX Function. In this section: Advertisements Syntax Exact Match Approximate Match […]
Excel INDEX Function (5 Examples)
Excel INDEX Function Using the reference to the row and column, the Excel INDEX function returns the value of given location of the worksheet (either from range or an array). Users use excel INDEX Function to check individual values, or entire rows and column. In this section: Advertisements Syntax Return row 5 column 3 value. […]
Excel CHOOSE Function (8 examples)
Excel CHOOSE Function The Excel CHOOSE function returns a value from a given data range or array based on the position (index) specified. The Excel CHOOSE function, for example, will return “Messi”, if we use the formula =CHOOSE(3, “MBappe”, “Neymar”, “Messi”, “Salah”). We can also use the index reference as a cell, which can be […]
How to Install Tableau Desktop
Install Tableau Desktop Before starting the use of Tableau, users need to install Tableau. Tableau Software is an American interactive data visualization software company focused on business analysis.  To install Tableau Desktop, users need to first download the software .exe file, then click on install and follow the remaining steps. After completing the installation, users need to […]
Connecting Tableau to a Data Set
Connecting Tableau to a Data Set Before starting to work on Tableau, users are required to connect data set with Tableau. It is not difficult to connect data set with Tableau. Users can connect Excel, Text, and many different forms of data set with Tableau. In this section: Advertisements How to connect a data set […]