## Purpose of Excel SUBTOTAL function

The SUBTOTAL function in Excel is used to return the subtotal in terms of sum, average, count, max, min etc. for the specified list, named range or database.

Demos and Full Guide

## The Weekdays in Excel

There are a few ways of getting the Weekday in Excel. if you require the number of day in a Week for the given date then may use then WEEKDAY function. If you require short day name then use the TEXT function

Demos and Full Guide

## The INDIRECT function in Excel

The INDIRECT function is used when you require changing the reference to a cell in a formula while you do not want to change the formula itself.

Demos and Full Guide

## How to Count in Excel?

if you require the count of cells that contain numbers only, use the Excel COUNT function.
To get the count of all cells with numbers, text, dates etc except the blank cells, use the COUNTA function. Similarly, for returning the count of cells based on certain criteriause the COUNTIFS function. To get the count of blank or empty cells, use the COUNTBLANK function.

Demos and Full Guide

## Change the date format in Excel

If you require displaying the date like this 2-Feb-2010 or August 1, 2015 etc. while entering dates you may change the settings in Excel easily.

Demos and Full Guide

## What is a Pivot table?

The Pivot table enables creating another table based on above table and can summarize data for analysis like averages, sum, or other useful reports. With the Microsoft Excel pivot table feature, this is the matter of few clicks

Demos and Full Guide

## How to subtract in Excel?

There is no Excel SUBTRACTION function. Instead, you may accomplish the task of subtracting numbers or a cell’s value from the other by using the minus arithmetic operator (-).

Demos and Full Guide

## What is SUMPRODUCT function in Excel?

The SUMPRODUCT function is used to multiply corresponding arrays or ranges and returns the sum. The SUMPRODUCT function is versatile.

Demos and Full Guide

## Doing Multiplication in Excel

You may simply use the ‘*’ operator e.g. 10*5, A2 * B2 or use the multiple operators in various functions. The PRODUCT function can also be used for multiplication of numbers and ranges.

Demos and Full Guide

## The TEXT function in Excel

The Excel TEXT function can be used to convert numbers and dates into text. This is particularly useful for scenarios where you require displaying the numbers or dates with text strings. For example:

Demos and Full Guide

## How to combine data from two or more cells in Excel

There are a numbers of ways in Excel to combine data for two or more cells in Excel. The technique and functions for merging data are:
Using CONCATENATE function
By using ‘&’ (ampersand sign)
TEXTJOIN function for merging ranges (Excel 2016, Excel online)

Demos and Full Guide

## The Excel Checkbox form control

In this tutorial, I am going to show you how to create checkbox (also called tick box) in the Excel sheet. This is followed by a few examples of using it for different tables, so you can see checkboxes in action.

Demos and Full Guide

## How to Concatenate in Excel (Strings and cells)?

The CONCAENATION function combines two or more text string (as constant literals) or from different cells and returns a single combined string. You may also use ‘&’ ampersand sign for concatenating string/cells in Excel.

Demos and Full Guide

## A brief about line graphs

The line graph (also called line chart) is used to display the data graphically that change over the period of time.
The markers or data points in line chart are connected by the straight lines. Generally, the line charts are used for visualizing the trends over the intervals like year on year, or month on month etc.

Demos and Full Guide