All About MS Excel Tips and Tricks

Flash Fill in Excel is a smart tool that can be used for any custom formatting job you want Excel to do for you. It simply requires an example of a pattern to imitate what has been done and applies that pattern to the available data in Excel. Also read: How to highlight a cell […]

An easy and step-by-step guide to highlight a cell in excel. Why do we need to highlight cells? Highlighting means changing the style of a cell or a group of cells to differentiate between the various types of data in the respective Excel worksheet. It also helps in bringing a piece of particular information into

Calculating subtotals in Excel is an easy task. You can find out totals and even subtotals in a tabular database for better calculations and understanding. Steps to Calculate Subtotal in Excel Let’s get started with this step-by-step tutorial on inserting subtotals in Excel. Prepare a Table of Data You need to prepare a tabular database

You need to wrap text in Excel to better handle non-numerical data in tabular databases. Wrapping text allows you to display more information in the limited screen space. The wrap text tool is a perfect alternative to these options while handling extra-long text in Excel. Wrap text in Excel using the Home Tab First, let

Today, we’ll learn to find the median and mode in Excel. In statistics, the median is the value that separates the upper and lower halves of a data sample or population or simply the middle number in a sorted list of numbers. Excel has an inbuilt function MEDIAN to find the median value of a dataset.

Histograms are a means to represent your data visually for better interpretation by the viewers. In Microsoft Excel, you can create histograms for your tabular data without any hassle. Also read: How to create pie charts in Excel? Steps to create a histogram in Excel Let’s get started with this step-by-step guide to creating histograms

Let’s learn how to create a pie chart in Excel. Visual representation of data is of crucial importance in data analysis, handling and representation. Microsoft Excel allows you to visually represent your data via pie charts and many other data charts. Recommended read: How to shade alternate rows in Excel? Steps to create a pie

In Microsoft Excel, it is possible to calculate the age of a person with the help of a set of formulas. Let’s get started with this step-by-step guide to calculate age in Excel. Recommended read: How to calculate the square root in Excel? Steps to calculate age in Excel with the DATEDIF() function Age calculation

Microsoft Excel has got some extremely dope features that enable you to execute a huge variety of tasks in it. You can even create a form in Excel directly without having to manually transfer data from a physical register onto Excel. Steps to create a form in Excel Let’s gets started with this detailed step-by-step

It is never easy to get rid of spelling and grammatical mistakes in any kind of literary work. You are very likely to make spelling mistakes due to a lack of attention or knowledge.   In Microsoft Excel, you can fix all spelling errors by conducting a spell check on your worksheet. This is a simple