Excel Basics

Dialog Box Launcher in Excel: All Types Explained

The Excel ribbon consists of various tabs, each designed for specific functions and tasks. However, Sometimes, there isn’t enough space to show all ...

Ribbon Commands in Excel (Detailed Explanation)

If we try to select a Ribbon command in Excel, a floating box will appear containing small descriptions about the command. Observe the Ribbon ...

What Is Spreadsheet in MS Excel? (Detailed Explanation)

Changing the value in an old-fashioned paper-based worksheet was laborious as it required tedious manual recalculation. Electronic spreadsheets have ...

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 Reference a Cell from a Different Worksheet in Excel

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

How to Use Reference of Worksheets in Excel (5 Examples)

This article will illustrate how to use reference worksheets in MS Excel. In Excel, data are stored in cells in various worksheets. Each worksheet ...

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 cell reference in Excel. Then I will show how you can shift from ...

Relative Cell Reference in Excel (Detailed Analysis)

This article will focus on an in-depth guide about the relative cell reference in Excel. There are two types of references in excel-relative ...

What Is an Active Cell in Excel? (A Complete Guide)

For those of you who have started learning Excel, we have some good news for you. In this article, we’ll discuss all your queries regarding what is ...

What Is the Definition of Cell in Excel

Any Excel worksheet/spreadsheet consists of columns and rows. The intersection of columns and rows is known as cells in Excel. Generally, columns are ...

Understanding Excel Spreadsheets (29 Aspects)

You will do all your work 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 ...

What Is Excel Used For in the Workplace?

Microsoft Excel has been the world standard for many years. Excel is popular as it is versatile. ‘Excel is versatile’ – which means that you can do ...

What is spreadsheet and how it works

A spreadsheet is basically a worksheet which is divided into rows and columns to store data; data from business inventories, income-expense report, ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo