By

Yoda Learning

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

How to Hide/Unhide Column in Excel

In this blog, you can learn about Hide & Unhide columns in Excel There are Columns in Excel where you perform Data Analysis or Calculations. Ideally, you’ll hide these Columns before showing your sheet to anyone. The Complication comes when you can’t unhide Columns in Excel. Or maybe when you forget how to Unhide Columns...
Read More

Highlight row based on cell value

Imagine that when you are looking at a large list of numerical data, it’s useful to find largest and smallest value. Sometimes you need to find if a value is larger than a specific number. At times, the cell will be another color if the expected value is higher than a specific number. In a...
Read More

Learn how to remove blank cells in Excel

How to remove blank cells in Excel? confused? Data doesn’t always import or paste into Excel as nicely as you want. Sometimes, all the information is there, but extra blanks and spaces are carried along with the data cells. Think that if you work with a large data set in an Excel Workbook or Excel...
Read More

How to Group Numbers, Dates & Text in Pivot table in Excel

Now will talk about the Grouping Data features of the pivot table. This technique of grouping numbers, dates and text are not similar to a grouping of data by using data tab. This is something different. I am assuming that you must be knowing how to create pivot table in excel if you are not aware...
Read More

5 Powerful Tricks to Format cells in Excel

In this article, you will learn 5 Excel tricks on how to format cells in Excel. Applying these
Read More

Insert a Picture into a Cell in Excel

Learn how to insert a Picture into a Cell in Excel? Supposedly, you wish to fit in the logos of the Companies in your Excel Sheet. How are you going to do this? You need to know, how to insert a Picture into a Cell in Excel. To show pictures in the adjacent Cell or...
Read More

What is ISFORMULA Function and FORMULATEXT Function

In our tutorial today, we will be looking at some new functions in Excel 2013, these are ISFORMULA and FORMULATEXT Functions. Let’s take them one after the other. The ISFORMULA Function Gone are the days when it is difficult to identify cells that contain formulas. Some time ago, we have to create a user-defined function...
Read More

How to Use SUBSTITUTE Function

Let’s first grasp what a Substitute Function is and when to use it. Before we figure out how to use the SUBSTITUTE function. What is a Substitute function? A Substitute is a person or a thing acting or serving in place of another. Substitute function replaces/swaps a set of characters with another in a text string. For...
Read More

Quartile Function in Excel

Summary: The Quartile Function in Excel helps to return the quartile of a data set in Excel. Going further in this tutorial, you’ll see how to find Quartile using Excel. You’ll observe that the Quartiles are several times used in sales and also while inspecting the sample data. The Quartile Function in Excel will support you...
Read More

How to use the Excel PERCENTILE function

Excel PERCENTILE Function: Summary  The Percentile Function in Excel will return the k-th percentile of values in a range. This implies that the value below the k% of the data values fall, while using the Percentile Function. This is for a Supplied range of values also for the supplied k. The Percentile Function in Excel...
Read More
1 2 3 4 9