fbpx

Category

Tutorials

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

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

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

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

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

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

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

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

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

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

How To Make Table of Contents (TOC) in Word

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

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

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

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

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...
Read More
1 12 13 14 15 16