What is a Pivot table?

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
The TEXT function in Excel

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
The Excel Checkbox form control

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
A brief about line graphs

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
Creating hyperlinks in Excel

Creating hyperlinks in Excel

The hyperlinks are useful for linking the other sheets or files and external URLs in cells of Excel. There is a number of ways for creating the Excel hyperlinks. Let us look at these ways one by one with examples.

Demos and Full Guide
Counting Characters in Excel

Counting Characters in Excel

For counting the number of characters in single or multiple cells, you may use the Excel LEN function. In the LEN function, you may provide a text string, cell or use LEN with SUM function for counting characters.

Demos and Full Guide