# Category: Basic

## How to Use the Excel DAYS Function with a Practical Example

Excel has a variety of date and time functions that are very useful when working with calculations involving dates and times. The DAYS function, not to be confused with the DAY function, returns the...

## How to Insert or Delete Rows and Columns from Excel Table

In this post, we shall learn how you can add new rows or columns in a table and how you can delete existing rows or columns from a table. You can add a new...

## Date & Time in Excel – How to Enter Them in Worksheet Cells Effectively?

Date System in Excel An Excel date is simply a serial number. The earliest date that Excel can understand is January 1, 1900. This date has the serial number of 1. January 2, 1900,...

## How to Add or Remove Cell Borders in Excel

In the last edition of our posts, you read about aligning contents in the cells in all directions possible. Today we will be focusing on cell borders in the worksheet. They are quite handy...

## Viewing and Scrolling Multiple Excel Workbooks at the Same Time

Sometimes we work with more than one Excel workbook at a time. In this short article, I will show how you can view and scroll multiple Excel workbooks at the same time. At any...

## What is the Order & Precedence of Operations in Excel?

Understanding the order and precedence of operations in mathematical formulas or in an Excel Formula is very important. Excel has total 17 operators that you can use them to build complex Excel formulas. Here...

## Exponential Notation in Excel & How to Turn Off Auto Scientific Notation!

This article will at first introduce you with the scientific number system and number precision definition. Then you will know about the highest and lowest number limitations in Excel. At the end of the article,...

## Best Online Excel Training for Basic & Advanced Users with Certification

“Note: Are you a basic Excel user? Or an advanced level user? And searching for the best online Excel courses? And don’t want to spend the top dollars on the training? You’re at the...

## What is and how to use paste special command in Excel

We are all familiar with Cut/Copy and Paste commands. They’ve been around since the early days of word processing, and they are universal across almost every Windows application. By pressing “Ctrl-V” or clicking “Paste”,...

## Monitor Cells with Excel Watch Window!

Sometimes we have a great deal of data in the workbook. Everything is important but most important are the last row of the data containing, say, the daily sum of sales, or percentage of...

## How to copy formula in Excel

While you are working with Excel, you will have to copy formula frequently from one cell to other cells. Here is how you will do this: Select cell B4 and enter this formula “=RAND()”....

## How to use Flash Fill in Excel 2013

Flash Fill is one of most important features newly added in Excel 2013. Flash Fill technique can recognize pattern in a text and you can separate part of a text in a new column...

## Understanding contextual tabs in Excel Ribbon

When you will work with charts or shapes or these kind of objects then special types of tabs will appear in Excel Ribbon Tab zone. These contextual tabs contain commands related to objects that...

## Mouse Conventions

Some mouse related terms we shall use in the tutorials of Excel 2013. Mouse Pointer: When we move our mouse, a small graphic figure moves onscreen. The mouse pointer is generally an arrow but...

## Creating and Copying formula using relative references in Excel

In our following example, we want to calculate Menu Cost(see the heading in the example) multiplying every menu’s price and quantity. We shall not create formula for every cell, we shall create formula for...