Excel UNICHAR Function – How To Use

The UNICHAR function in Excel returns the Unicode character or symbol associated with the given number. Unicode is a global encoding standard in which each

Excel UNICODE Function – How To Use

The UNICODE function is a type of text function in Excel that returns the code point, also known as Unicode number, against a character, text,

Fill Handle Not Working in Excel (4 Easy Fixes)

You might not even know what the Fill Handle is while it gets so much of the work done for you. Today, we’re not talking

How to Insert an Arrow in a Cell in Excel (6 Easy Ways)

The grand job of Excel is to be an analysis tool that gives a quick visual and graphic indication of data. Arrows also play a

Excel CODE Function – How To Use

The CODE function is an Excel text/string function that returns the numeric code associated with the given character. The returned numeric code corresponds to the

How to Insert Bullet Points in Excel (9 Easy Ways)

Excel is not a word processor but you can still find several ways of getting a bullet point on the worksheet because despite being a

Excel CHAR Function – How To Use

CHAR function, also known as the character function, is one of Excel's text/string functions. It accepts an ASCII value as an input and returns the

Excel MID Function – How To Use

The MID function returns a specific number of characters from the middle of the string after we state the starting position and the number of

Excel RIGHT Function – How To Use

RIGHT function is one of the string manipulation functions of Excel. The RIGHT function returns the stated number of characters from the end of a

How to Copy Conditional Formatting in Excel (3 Easy Ways)

The number of convenience stores everywhere is a true indicator of how much we revel in convenience. Excel agrees with the lot of us and

Excel LEFT Function – How To Use

The LEFT function is one of the many common and widely used text/string functions offered by Microsoft Excel. The LEFT function enables you to extract

Conditional Formatting in Excel (Complete Guide + Examples)

Looking at a wad of numbers or a litany of texts, you cannot immediately interpret the relation between the values. Lowest prices, highest sales, changing

Excel Functions

Excel TEXT Function – How to Use

The TEXT function in Excel converts numeric values to a text string. While you'll mostly be fiddling with numbers on an Excel sheet, you may

Excel WORKDAY Function – How to Use

The WORKDAY function is categorized as a Date and Time function. It helps us add or subtract N working days to a date provided by

Excel WEEKDAY Function – How to Use

The WEEKDAY function is a DATE and TIME function that can be used to find the weekday for a given date. The date is supplied

Excel FILTER Function – How To Use

The FILTER function is an Excel function that lets you fetch or "filter" a data set based on the criteria supplied via an argument. The

Excel OFFSET Function – How to Use

The OFFSET function is one of the most enigmatic Excel functions that may take a while to wrap your head around. But I will ensure

Excel IF Function – How to Use

IF function is undoubtedly one of the most important functions in excel. In general, IF statements give the desired intelligence to a program so that

Formula Errors

#N/A Error In Excel – How To Fix

Sometimes, when you’ve used a bunch of lookup tables on your Excel sheet, you might spot a #N/A error. The #N/A error is typically associated

#NAME? Error In Excel – How To Fix

The #NAME? error is a common Excel error because it’s easy to make mistakes that can cause the #NAME? error. In most cases, you’ll be

#DIV/0! Error In Excel – How To Fix

When you’ve done some computations on your Excel sheet, you sometimes look at the whole thing later and find that one of the cells has

#NUM! Error In Excel – How To Fix

The #NUM! error is a frequent visitor on your worksheet. This can make you want to pull your hair out if you’ve used the output

#REF! Error In Excel – How To Fix

Say you’ve got this worksheet from a couple of months ago ready to work with. You pull it up on your computer and start working.

#NULL! Error In Excel – How To Fix

The #NULL! error is less common than other errors like #VALUE! or #NUM! errors. The error is basically Excel telling you that you’ve supplied an

How To's

How to Insert, View, Move And Remove Page Breaks in Excel

If you feel your data is crowding the page it is to be printed on and dividing the data would help with clarity, you can

How to Lock Cells in Excel – Protecting Excel Worksheets

Whether you are trying to steer clear of accidental overwrites, feeling fickle, or trying to protect some important data; all your reasons are good enough

How to Create, Use, Edit and Delete Named Ranges in Excel

Names are one convenient identity. Imagine how we'd be addressed if we didn't have names? Excel tries to make our lives easier by providing us

How to Find and Fix Circular References in Excel

A circular reference occurs when you end up having a formula in a cell – which in itself uses the cell reference (in which it’s

Excel Flash Fill – How To Use

What is Excel Flash Fill, and more importantly, what is so special about it? Flash Fill is a special tool in Excel that can automatically

How to Insert a Checkbox in Excel (In 5 Easy Steps)

Inserting a checkbox in Excel is an easy task. The checkbox control is available in the Excel developer tools option. Checkbox and other controls like dropdowns can

Calculations

How to Calculate Business Days in Excel (3 Easy Formulas)

Where are you from? Are you a TGIF person or is your Saturday spirit drowning somewhere behind the office walls? The most common understanding of

How to Calculate Years of Service in Excel (3 Easy Ways)

Finding out the years of service of employees may come with their resignation. The intent may be to find out the employment duration or to

How to Calculate Weighted Average in Excel (2 Easy Formulas)

We all know how averages work, right? Means or averages are easily calculable and represent a central value. That's all fine for regular numbers but

How to Calculate Square Root in Excel (4 Easy Ways)

Hello there citizen of Excel town! Here's a brainwave. Have you ever thought about getting Excel to do what you have been doing for a

How to Square a Number in Excel (In 5 Different Ways)

The aim is simple. Squaring a number, a number raised to the power 2, the number multiplied by itself; it's all the same thing, you