Category

Tutorials

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

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

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

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

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

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

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

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

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

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

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

How to count text in Excel?

Imagine your team members have entered all their project hours in a worksheet and you need to count it. In other words, you also need to count the cells that have data. To complicate matters, the data may not be numeric. Some of your team members may have entered placeholder values such as “TBD”. So...
Read More
1 2 3 4 5 9