# Excel

Microsoft Excel is one of the most popular software across computer users. It’s used by everyone and we can store different types of data in Excel spreadsheets.

The power of excel is unleashed when we use its formulas, graphing tools, pivot tables, and macros using Visual Basic.

Here at QuickExcel, we provide tips and tricks to use Excel with ease and become an advanced user.

## How to Find Quartiles in Excel?

Let’s learn how we can find quartiles in Excel. A quartile is a statistical term that is used to describe the division of a dataset into four equal intervals. Each quartile has 25% of the total number of data points in a dataset. The four equal intervals are divided by three points namely – lower …

## How to calculate Z-Score in Excel?

Z-score in Excel is a statistical measurement that describes the relationship between a value and the mean of a set of values. The standard deviations from the mean are used to calculate the Z-score. When a Z-point score is 0, the score of the data point is the same as the mean. A data point …

## [Step-by-Step] How to Make a Calendar in Excel?

In this tutorial, we will learn to create a calendar in Excel. There are multiple ways to insert calendars in an Excel sheet. We will look at the different ways to insert or create calendars in Excel. Steps to create a calendar in Excel Let’s get started with this step-by-step guide to creating a calendar …

## How to superscript and subscript in Excel?

In this article, we’ll learn how to superscript and subscript in Excel. These are common in technical expressions and will certainly come in handy when dealing with data. Superscripts and subscripts are easy to apply in Excel only if you know how to approach the settings and shortcuts properly. Also read: [Step-by-Step] How to Round …

## How to Alphabetize in Excel?

In this tutorial, we’ll learn how to alphabetize in Excel. Alphabetizing in Excel means sorting a column or a list in alphabetical order. This alphabetical order can either be from A-Z or from Z-A. Contrary to the meaning, the alphabetize method is also used for alphabetizing numerical data. Also read: The Ultimate Guide to Sorting …

## The Ultimate Guide to Using Sum Functions in Excel

This tutorial is all about summing data in Excel. Well, it obviously sounds a no-brainer to some of you but, Excel has always got something new to mine out of it. This article is a detailed guide on summing data in different ways using SUM functions like SUM, SUMIF, SUMIFS, SUMPRODUCT, and AutoSum in order …

## [Step-by-Step] How to Round Numbers in Excel?

In this tutorial, we will learn to round numbers in multiple ways in Microsoft Excel. We can round numbers either via the Home tab or by using different formulas like the ROUND, ROUNDUP, and ROUNDDOWN functions in Excel. Also read: How to Stop Excel from Rounding? Steps to round numbers in Excel To directly round …

## [Easy Step-by-Step] How to Record Macros in Excel?

In this tutorial, we will learn to record macros in Excel. Macros are used to record data in order to carry them forward to a new sheet or file. They can help you save a huge amount of time by enabling you to create a data structure or an entire database only once. Don’t worry …

## How to Edit Axis in Excel – The Ultimate Guide

In this tutorial, we will learn to edit axis in Excel. We will learn in detail on adding and removing axes, axis titles, secondary axis, and swapping x and y axes and will also learn to customize an axis in a chart, step-by-step. You may also want to read: How to Edit Legends in Excel? …

## Count Functions in Excel – The Complete Guide

This tutorial is all about counting different values/contents in a cell in Microsoft Excel. we will learn in-depth about different count functions in Excel such as COUNT, COUNTA, COUNTBLANK, COUNTIF, and COUNTIFS. Steps to Use the Count Functions in Excel Let’s get started with this simple and easy guide to using the count functions to …