Excel Tutorials - Easy Simple Smart

Multi-row and Multi-column Pivot Table

Posted on September 14, 2019 by Paul

In the previous tutorials for Pivot Tables we looked at the simple Pivot tables with one row and one column, then we added a category to the data-set to create a multi-row pivot table. In...read more

Multi-Level Row Pivot Table

Posted on September 13, 2019 by Paul

If in the previous example we studied how to create a simple pivot table from a simple data-set, in this example we add an additional column to categorize our products in order to create a...read more

What is an Excel Pivot Table

Posted on September 12, 2019 by Paul

Pivot tables are Excel's most powerful feature. A pivot table lets you summarize detailed data automatically. In this tutorial you will learn what is an Excel Pivot table and how to create an Excel pivot...read more

Automatically refresh pivot table

Posted on September 9, 2019 by Paul

You may need to refresh an Excel displayed dashboard or pivot table periodically if your data is coming from an external source (database, web or other). This tutorial will show you how to refresh your...read more

The excel ribbon

Posted on June 27, 2019 by Paul

When first introduced, the ribbon was not liked by many experienced Excel users. Personally I hated the ribbon. Now, I can't even imagine how Excel looked before the ribbon. If you don't know, or don't...read more

Cells and Ranges

Posted on June 27, 2019 by Paul

Cell In Excel, one grid box is called a cell. A cell is named as the intersection of the column and row. In the example below, the Cell is named C4 because it is at...read more

Simple Worksheets Commands

Posted on June 26, 2019 by Paul

As seen in the previous section "What is a worksheet" once we have a brand new worksheet, we can do some commands in regards to that worksheet. To access a list of the quick commands,...read more

What is a worksheet

Posted on June 26, 2019 by Paul

A worksheet is a tab in a workbook. you can have many worksheets in the same workbook. Think of worksheets as pages in your notebook and think of workbook as your notebook By default, a...read more

What is an Excel Workbook

Posted on June 25, 2019 by Paul

A workbook is another word for an Excel file. When you create something in Excel, the file that you save is called a workbook. How to create a workbook To create a new Excel workbook,...read more

Easy Simple Smart

Digital Products

Category: Excel