Excel Basics

How to Customize the Quick Access Toolbar in Excel

The Quick Access Toolbar is a customizable toolbar. Quick Access toolbar contains commands from different tabs. You can place the Quick Access ...

Dialog Box launcher of Excel Ribbon

Some groups may have more commands that they are showing in the Ribbon. For example, the Page Setup group of commands in the PAGE LAYOUT ribbon has ...

Types of commands on the Ribbon

If you take your mouse pointer over a Ribbon command, a pop-up box will be visible that contains the command’s name and a brief description of the ...

What is Spreadsheet in MS Excel

A spreadsheet in MS Excel is basically a worksheet that is divided into rows and columns to store data related to business inventories, income, and ...

What is Spreadsheet Software

Spreadsheet software is a computer program (e.g. Excel, Lotus) that has efficient and accurate methods to work with numbers. You can perform very ...

How to Show, Hide, & Customize Excel Ribbon

In this tutorial, you are introduced to Excel’s Ribbon feature. Excel ribbon makes your work faster and smoother. After reading this article you will ...

How to reference a cell from a different worksheet in Excel

Before understanding this topic, you have to understand cell reference in a formula. Say I have a formula like this ‘=B3*C3+D3’. In this formula ...

How to use cell references with multiple worksheets in Excel

Before understanding this topic, you have to understand cell reference in a formula. Say I have a formula like this ‘=B3*C3+D3’. In this formula ...

What is and How to Do Absolute Cell Reference in Excel?

In this article, I will discuss what is an absolute reference and how to do absolute reference in Excel? Then I will show how you can shift from one ...

Relative cell references in Excel

Before understanding relative cell references, you have to understand cell references in a formula. Say I have a formula like this ‘=B3*C3+D3’. In ...

What is an Active Cell in Excel?

What is an active cell in Excel? How to make a cell active in Excel? Can more than one cell work as an active cell at the same time? You will get all ...

What is cell in Excel definition

Every Excel worksheet/spreadsheet consists of columns and rows. The intersection of columns and rows make cells in Excel. Columns are labeled from A ...

Keyboard Shortcuts for Moving around Excel Spreadsheets

We shall discuss here the various ways and keyboard shortcuts to move the cells in an Excel Spreadsheet. Every Excel worksheet/spreadsheet ...

Understanding Excel spreadsheets

You will do all your works in a workbook file. You can add as many worksheets as you need in a workbook file. Each worksheet appears in its own ...

Excel 2013 New Features

The new version of an application comes with new features. Microsoft Excel 2013 (part of Microsoft Office 2013 suite) also has come with some unique ...

ExcelDemy
Logo