Yoda Learning

### 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...

### 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...

### 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...

### 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...

### 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...

### 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...

### Insert or Type degree symbol in Excel with Autocorrect Feature

How to use the Autocorrect Feature to Insert or Type degree symbol in Excel?  Well, this one is Enthralling and my all-time favorite. Using autocorrect Feature in Excel to type degree symbol. This enables you in assigning a Code to the Degree Symbol. Well, let’s consider ABEFIJ. If ever you’ll insert or type ABEFIJ in...

### Insert Symbol Dialog Box to Insert or Type degree symbol in Excel

How to use the Insert Symbol Dialog Box to Insert or Type degree symbol in Excel? Another vital step which can be used to get the degree symbol in a cell in Excel is to use the Insert Symbol Dialog Box.   Let’s consider the following steps to insert the degree symbol in Excel with...

### CHAR Formula to Insert or Type degree symbol in Excel

How to use the CHAR Formula to Insert or Type degree symbol in Excel? You can even call this one as learning, how to type degree symbol on a laptop without the number pad. By using =CHAR(176) to obtain the Degree symbol in a cell in Excel. For doing this, you must: Input or Enter...

### Reference Styles | How to Use R1C1 Reference Styles

Every Excel Spreadsheet contains rows and columns. Most of the time, columns are known and represented by letters (A, B, C), and rows are known by numbers (1, 2, 3). While you’re in Excel, this is often called the A1 reference vogue. However, some are in favor to use a unique methodology where the columns are known by numbers. “This is termed as the R1C1 reference style.” Considering the case below, the image on the...

### Track Changes in Word

In our study today, we will be learning how to TRACK CHANGES in Word. What is track changes in Word and why it is important? Most of the time, after typing a word document, we go over it to edit, format or proofread it. We some of the time send this document to other experts...

### How To Remove Blank Rows – The COUNTBLANK Function

How To Remove Blank Rows – The COUNTBLANK Function BEFORE – AFTER Before diving into the topic of the day, let’s understand some of the basic terms we will come across. Blanks are empty spaces. In the excel worksheets, they are cells that no parameter had been entered into. What are Blank Rows? Blank Rows...

### How to use TEXTJOIN, IFS, SWITCH, MAXIFS and MINIFS Functions?

I am pleased to introduce you to some of the New Excel Functions in Excel 2016. These functions are ‘wow!!’. The functions I will be introducing in this tutorial are TEXTJOIN, IFS, SWITCH, MAXIFS and MINIFS. Let’s take them one after the other. The TEXTJOIN Function As the name implies, this function is used to...

### How to Count Blank Cells in Excel

Before we proceed into the topic of the day, let’s understand the terms: Blank cells and Non-blank cells. Blank cells are empty cells in an Excel spreadsheet. They contain no parameter or data. Non-blank cells, on the other hand, contain parameters. They are not empty. Having blank cells in a spreadsheet is not inevitable. Sometimes,...

### How to Compare Documents

Spotting the differences in two similar documents is not easy. It is not only taking, it is also tiring and time taking. we have to go through both documents line after line. Otherwise, have the review document underlined, italic, bold font to help spot differences. Comparing documents much easier with MS Word! MS Word...

### Chrome and Excel Shortcuts

Chrome and Excel Shortcuts 1. #YodaHacks – 7 Killer Chrome Tricks: Ready to exercise your killer Chrome skills? Learn how to open your last link, pin your tab, toggle between tabs and more! a. Unable to connect to the Internet? Play the dinosaur game. b. Ctrl + W: closes the window c. Ctrl + Shift...

### Extract values from cell using LEFT, RIGHT, MID

Imagine that you wanted to create a new column on a spreadsheet. But part of the information is already in another column? For example: You wanted to distribute the first, middle and last names from a cell into three separate cells. Do you bristle when you see someone wasting precious time for this? Case study...

### Conditional Formatting with Formulas

Let’s begin by defining the term Conditional Formatting? Conditional formatting is also expressed as conditional automatic formatting. It is triggered under certain defined conditions by the user. Say we use conditional formatting to make characters bold and italic at the start of each line. And it worked. Then, conditional formatting is an effective way to...
1 8 9 10 11 12 13