Excel Basics

Understanding contextual tabs in Excel Ribbon

When you will work with charts or shapes or these kinds of objects then special types of tabs will appear in Excel Ribbon Tab zone. These contextual ...

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 ...

Using Task Panes in MS Excel

Task pane is another useful user interface in Excel. Some commands in Excel will respond automatically with task panes. For example, if you work with ...

Working with Dialog Boxes in Excel

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

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 ...

ExcelDemy
Logo