Tag

Excel

How to use Clean Function in Excel

The CLEAN Function in Excel takes a text string and returns a text that has been “cleaned” of line breaks and other non-printable characters. What is a CLEAN Function? What is the syntax for CLEAN Function? How to use CLEAN Function? And finally, What are the applications of CLEAN Function? ➡ What is Clean Function in...
Read More

How to use the Excel Choose Function

The CHOOSE Function in Excel returns a value from a list using a given position or index. The values provided to CHOOSE can include references. Let’s have a look below to get more details about CHOOSE Function. ➡ What is Excel Choose Function? CHOOSE Function is a function in Excel that helps you to get...
Read More

How to use the Excel Code Function

The CODE Function in Excel returns a numeric code for a given character. The CODE Function can be used to understand numeric codes given to the CHAR Function as it is the reverse process of CHAR Function. ➡ What is Code Function in Excel? The Function that accepts one argument, for the text for which you...
Read More

How to use the Excel Column Function

The COLUMN function in Excel returns the column number for a reference. In other words, Column Function too will return the column number of the cell which contains formula when reference is not provided. ➡ What is Column Function in Excel? The function which will returns column number for a reference is called Excel COLUMN Function....
Read More

How to use Char Function in Excel

The CHAR Function in Excel returns a character when given a valid Character Code. CHAR Function is used to specify the characters that are difficult to enter in a formula in Excel. Now, let us study in detail the CHAR Function as given below. What is a CHAR Function in Excel? What is the formula...
Read More

Text To Column in Excel | Split Cells

Excel Text to Columns or Split Cells in Excel is used in data cleaning and data re-arrangement. Excel text to columns formula technique is used for following: How to Apply Text to Column to Split Cells Split the text as last name and first name in two different columns. If a cell has got more than just a word...
Read More

Special Character Symbol List with Shortcodes in Excel

To activate the special character, you need to use an Alt keyboard sequence: Num Lock key must be pressed, to activate the numeric key section of the keyboard (you can find on right top corner side). Press Alt key, and hold. While the Alt key is pressed, type the sequence of numbers (on the numeric keypad) from the Alt...
Read More

How to use AVERAGEIFS FUNCTION in Excel

The AVERAGEIFS Function of Excel computes the average of the figures in a range that meet one or more delivered conditions. The criteria of the AVERAGEIFS Function also supports the logical operators and wildcard operators in Excel. What Is The Averageifs Function In Excel? AVERAGEIFS Function averages cells in a range that is equivalent to...
Read More

How To Lock Cells in Excel | Unprotect Excel

Most of the times when you’ve worked on a Data set and you share your Spreadsheet with anyone you don’t want the Cells to change or shift. To avoid Modifications, MS Excel 2016 and its earlier versions lets you lock cells in MS Excel. You can lock Cells in Excel or Lock Specified Cells in...
Read More

Separate Content of One Excel Cells into Separate Columns

Do you know what Text to Columns is feeling right now? It is feeling sad and unappreciated. It is because it gets less credit than it actually deserves. Text to Columns in Excel is one of the most wonderful features in Excel. Here in this tutorial, you’ll learn about the various things you can do...
Read More

How to Transpose Excel Columns to Rows | Paste Special Method

‘Paste Special Transpose’ option can be used to switch between Rows to Columns or Vice Versa. In case, if you don’t wish to Paste Special then you can even use the Transpose Function. While you make the selection of the Data, you select the range of the Data that you wish to re-arrange. This includes...
Read More

How to create sparklines in Excel

Sparklines in Excel Imagine you have result sheet for your students over the last 5 years and want to create a chart in Excel, which takes time. In that case, you are thinking if only there were some small mini-charts in a single cell. Well here is the solution. Ever had a worksheet of data...
Read More

AutoSum in Excel with Shortcut

AutoSum in Excel will help you to SUM a Column or the Row which has Numbers. AutoSum in Excel is a Perfect example which shows how Excel loves doing Math. To AutoSum, make a selection of the Cell next to the Number that you wish to SUM. In the Home Tab, go to AutoSum, in...
Read More

OFFSET Function in Excel

OFFSET Function in Excel: Most Useful Built-in-Functions in Excel. It returns a range given to the no. of Rows and Columns. The User gives the Row, Column and Reference to a range and wherever the Row and Columns meet, the Offset Formula in Excel will give the Output based on that. What is an OFFSET...
Read More

Strikethrough Shortcut in Excel & Word

Strikethrough shortcut in Excel & Word helps to delete it. Example sometimes, while creating a document we don’t need a few text we can just delete it. But when we want to show the unwanted text we used Strikethrough text option. This option will let the text remain where it is. But simply it will...
Read More

INDIRECT Function with SUM, MAX, MIN & Independent Cell Value

What is an INDIRECT Function? The INDIRECT Function in Excel helps you to return a reference to a range. Even when you insert Rows or Columns in a Worksheet the reference you created won’t change. This will help you to create a reference from letters and numbers in other cells. How INDIRECT Function Works with an...
Read More

Pivot Table Slicers In Excel

Slicers in Excel are often termed as Visual Filters. With Pivot table Slicers in Excel, you can filter Pivot Tables. Besides, Report Filter can also be used to do the same task. Slicers were first introduced in Pivot Tables in Excel 2010 for Windows. And it came in Excel for Mac in 2016. Slicers in Excel...
Read More

How to Wrap Text in Excel Automatically and Manually

Wrap Text is most known function of excel. There are times when there is difficulty to adjust long texts within an excel cell. When you’ve much text piled up and it should be present in the spreadsheets. Or if you have failed to fit your text in an Excel Cell. Excel Wrap Text option will...
Read More
1 2 3 9