Yoda Learning

### 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 match names in Excel where spelling differ or vary

How to use Fuzzy Lookup in Excel to match names Think: Sometimes, we need to find a match in-between tables. In such cases we find the data using functions, like vLookup. This works when entries in both columns in the tables are completely identical. Sometimes that may not be the case. There may be spelling...

### Turn ON or Turn OFF scroll lock in Excel

Turn ON/ Turn OFF Scroll Lock in Excel Imagine your report is due in an hour. You are working along in Excel, everything is going well, but suddenly you notice that you can no longer move around properly in your spreadsheet. You press the arrow keys, but instead of the cursor moving to another cell,...

### 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 two lists in Excel

In the tutorial, we will learn: How to compare two columns in Excel. We use various ways to compare two cells using functions in Excel. Some of these ways are: Comparing two Columns row-by-row. Comparing many columns for row matches or differences. Highlight matches or differences between two columns. Highlight row matches and differences. Compare...

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

### Find Duplicate Values

An Excel sheet is a great way of packing lots of data into a dense area. But, these documents will become unmanageable and unwieldy when they’re in use for a long period of time. This example teaches you how to find duplicates in Excel. Go here to remove duplicates. In this tutorial, we will figure out...

### Special Character Letter | Reference chart of Symbols

Special Character Letter, 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 which you required on the right side of the...

### How to Split Cells In Excel

Merging and splitting cells in Microsoft Excel is very similar. Below are the steps required for merging and splitting cells in each of these programs. Merge cells Note: This document only covers how to merge cells in excel, not how to merge value of more than one cell. Open Excel Highlight two or more adjacent...

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

### Difference between Excel Search and Find Function

The Find and Search functions seem to be identical by nature of their name. But they can be distinguished, by nature of their use for using Microsoft Excel problems. Below are the basic definition and difference between these two. Let’s start with their basic definitions and their syntax: Find function is used to query a...

### How to create Icons in PowerPoint

Think sometimes you need an icon to be pasted or used somewhere that is not available in your system. In such cases, it is better to Create your own Icon using PowerPoint tools. It is much easier than it seems. Imagine the number of possibilities that you can unlock by using this tool to create...

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

### How to password protect an Excel file?

When you share one Excel spreadsheet with multiple users, you may don’t want the spreadsheet to be modified arbitrarily by unauthorized persons. If you wish to restrict access to an Excel workbook or if you wish to deny editing privileges to other users, consider adding a password to the workbook as a security measure. Excel...

### How to Lock Formulas in Excel?

How to Lock Formulas in Excel? Confused? Here is the blog to know how to lock formulas. Imagine Your boss wants you to protect a workbook, but she also wants to be able to change a few cells after you are done. So, before you password protected the workbook (or a worksheet), you unlocked some...

### How to Create Formulas in Excel?

One of the most powerful features in Excel is the ability to calculate numerical information using formulas. Just like a calculator, Excel can add, subtract, multiply, and divide. This tutorial explains how to write formulas in Excel, beginning with very simple ones. We will learn how to create a formula in Excel using three ways, Constants, Cell references and...
1 2 3 4 5 9