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 any...Read More

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

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...Read More

Summary: The Quartile Function 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 while...Read More

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

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...Read More

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 the...Read More

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...Read More

What if you’re working on a Temperature Data? Here, you must learn how to use the degree symbol in the Excel data to show the numbers in Celsius and Fahrenheit. For this, one of the most important things is to use the degree symbol in data to show numbers in Celsius and Fahrenheit. So, what...Read More

Freezing rows and columns in Microsoft excel is one of the most used and useful tool while working on large data and while working with dashboard. To freeze header row, freeze multiple rows, unfreeze panes, freeze multiple columns, etc. we need to go through the following tutorial. HOW TO FREEZE ROW IN MICROSOFT EXCEL? You...Read More

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 left features...Read More

In case, if you plan to use the Histogram tool, you need to keep in mind and you have to make sure that the Analysis Tool Pak Add-in is installed on your system. Analysis of the Toolpak Installation for using the Histogram: If you’re planning to use the Histogram tool, then there are certain things...Read More

Before we learn how to use flash fill in Excel, there are some questions we need to address first. These questions are: What exactly is Flash fill? Why should we use it? And what can it do for you? What is Flash Fill? Let’s say there is a pattern evident in the cells. Flash fill...Read More

In our study today, we will be learning how to TRACK CHANGES in Microsoft (MS) Word. What is track changes 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...Read More

Undo, Redo shortcut keys for MAC & Windows and other foremost needed Functions: Easy and Essential keyboard shortcut functions of Excel you’ve been looking for. There is a list of essential Excel Shortcuts which will help you get in your Comfort Zone. If you spend a lot of time in Excel then you must know about...Read More

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...Read More

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 differences or some minor differences in the entries. Because of...Read More

In today’s tutorial, we will be looking at how to make a Table of Contents (TOC). A Table of Contents that can be updated at any time. With MS Word Heading Styles, this can be done. To achieve this, the document is first formatted using MS Word Heading Styles. In this heading style, Heading 1...Read More

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,...Read More

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...Read More