Excel UPPER Function

The Excel UPPER function converts a text string to all uppercase letters. Numbers, punctuation, and spaces are not affected. Purpose  Convert text to upper case Return value  Uppercase text. Syntax  =UPPER (text) Arguments  text - The text that converts to upper case. Usage notes  The UPPER function converts a text string...
Read More

Working with Multiple Sheets

In certain situations, you might have to Set up workbooks in which several worksheets have a similar format or structure.Get information for these worksheets from another worksheet.Summarize the results from these worksheets into a summary worksheet. For example, you might have to track sales information region wise and month wise...
Read More

Excel LOWER Function

The Excel LOWER function converts a text string to all lowercase letters. Numbers, punctuation, and spaces are not affected. Purpose  Convert text to lower case Return value  Text in lower case. Syntax  =LOWER (text) Arguments  text - The text that should be converted to lower case. Usage notes  The LOWER function...
Read More

Sorting in Excel

Sorting data is an integral part of Data Analysis. You can arrange a list of names in alphabetical order, compile a list of sales figures from highest to lowest, or order rows by colors or icons. Sorting data helps you quickly visualize and understand your data better, organize and find...
Read More

Excel RIGHT Function

The Excel RIGHT function extracts a given number of characters from the right side of a supplied text string. For example, RIGHT("apple",3) returns "ple". Purpose  Extract text from the right of a string Return value  One or more characters. Syntax  =RIGHT (text, [num_chars]) Arguments  text - The text from which to extract characters...
Read More

Excel LEFT Function

              The Excel LEFT function extracts a given number of characters from the left side of a supplied text string. For example, LEFT("apple",3) returns "app". Purpose  Extract text from the left of a string Return value  One or more characters. Syntax  =LEFT (text, [num_chars]) Arguments  text - The text from which...
Read More

HLOOKUP Function

HLOOKUP Function HLOOKUP stands for Horizontal Lookup and can be used to retrieve information from a table by searching a row for the matching data and outputting from the corresponding column. While VLOOKUP searches for the value in a column, HLOOKUP searches for the value in a row. Formula =HLOOKUP...
Read More

Excel UNICODE Function

The Excel UNICODE function returns a number (code point) corresponding to a Unicode character. Unicode is computing standard for the unified encoding, representation, and handling of text in most of the world's writing systems.  Purpose  Get number from Unicode character Return value  Unicode code point in decimal notation Syntax  =UNICODE...
Read More

Excel UNICHAR Function

The Excel UNICHAR function returns a Unicode character based on a given number. Purpose  Get Unicode character by number Return value  Unicode character Syntax  =UNICHAR (number) Arguments  number - Code point for a Unicode character in decimal. Uses  The UNICHAR function returns the Unicode character at a given code point, provided...
Read More

If Function in Excel

The Excel IF function runs a logical test and returns one value for a TRUE result, and another for a FALSE result. For example, to "pass" scores above 70: =IF(A1>70,"Pass","Fail"). More than one condition can be tested by nesting IF functions.  Purpose  Test for a specific condition Return value  The...
Read More

Excel Data Analysis – Subtotals with Ranges

Excel Data Analysis - Subtotals with Ranges If you have a list of data that you want to group and summarize, you can use Excel Subtotal and Outline to display summary rows or columns. You can use PivotTable also for this purpose, but using Subtotal and Outline is the quickest way to analyze a range of data. Note that Subtotal and Outline can be...
Read More

Excel TIMEVALUE Function

The Excel TIMEVALUE function converts a time represented as text into a proper Excel time. For example, the formula =TIMEVALUE("9:00 AM") returns 0.375, the numeric representation of 9:00 AM in Excel's time system. Numeric time values are more useful than text since they can be directly manipulated with formulas and...
Read More

Excel DATEVALUE Function

The Excel DATEVALUE function converts a date represented as a text string into a valid excel date. For example, the formula =DATEVALUE("3/10/1975") returns a serial number (27463) in the Excel date system that represents March 10, 1975. Proper Excel dates are more useful than text dates since they can be directly manipulated...
Read More

Excel TRANSPOSE Function

The Excel TRANSPOSE function "flips" the orientation of a given range or array: TRANSPOSE flips a vertical range to a horizontal range, and flips a horizontal range to a vertical range. Purpose  Flip the orientation of a range of cells Return value  An array in a new orientation. Syntax  =TRANSPOSE...
Read More

How To Remove Duplicates And  Converting Table to Range

When you gather data from different sources, you probably can have duplicate values. You need to remove the duplicate values before going further with the analysis. Look at the following data where you have information about various products of various brands. Suppose, you want to remove duplicates from this data....
Read More

Table Name In Excel

Table Name Excel assigns a name to every table that is created. Step 1 − To look at the name of the table you just created, click table, click on table tools – design tab on the Ribbon. Step 2 − In the Properties group, in the Table Name box, your Table Name will be displayed. Step 3 −...
Read More

How To Create Table In Excel

TABLE IN EXCEL A Table is a rectangular range of structured data. The key features are − Each row in the table corresponds to a single record of the data. Example - Employee information.Each column contains a specific piece of information. Example - The columns can contain data such as name, employee...
Read More

How to use SUM function in excel

The Excel SUM function returns the sum of the values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments. Purpose  Add numbers together Return value  The sum of values supplied. Syntax  =SUM (number1, [number2], [number3], ...)...
Read More

How to create Macros In excel

HOW TO CREATE MACROS IN EXCEL With Excel VBA you can automate tasks in Excel by writing so-called macros. In this chapter, learn how to create a simple macro that will be executed after clicking on a command button. First, turn on the Developer tab. Developer Tab To turn on the Developer tab, execute...
Read More

Top Reasons why you should use Power BI

According to Microsoft, “Power BI is a business analytics solution that lets you visualise your data, share insights across your organisation, or embed them in your app or website.” It is a collection of products and services for individuals and teams in the areas of business intelligence (BI), reporting, and data...
Read More
1 2 3 4 34