ExcelDemy.com Blog

0

How to customize the Quick Access Toolbar

The Quick Access Toolbar is a customizable toolbar. Quick Access toolbar contains commands from different tabs. You can place the Quick Access Toolbar above the Ribbon or below the Ribbon. You can add your...

0

Using shortcuts menus in Excel

In addition to the Ribbon, Excel uses many shortcut menus. You can access shortcut menus by just right clicking anything within Excel. You will find that shortcut menus don’t contain all time relevant command,...

0

How to Use the keyboard to work with the ribbon

You may think that the Ribbon is completely mouse-centric as the commands don’t display the traditional underlined letter to indicate the Alt+keystrokes. But the Ribbon is very keyboard friendly. Just press the Alt key...

0

Dialog Box launcher of Excel Ribbon

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

0

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 about the command. Observe the Ribbon commands closely. You...

0

How to choose Spreadsheet Software

What is Spreadsheet Software A spreadsheet software is a computer program (e.g. Excel, Lotus) that has efficient and accurate methods to work with numbers. You can perform very simple to ultra-complex scientific calculations with...

0

What is Spreadsheet in MS Excel

A spreadsheet in MS Excel is basically a worksheet which is divided into rows and columns to store data related to business inventories, income and expenses, debits and credits. Today’s business world uses electronic...

0

What is Spreadsheet Program

A spreadsheet program is a computer software (e.g. Excel, Lotus) that has efficient and accurate methods to work with numbers. You can perform very simple to ultra-complex scientific calculations with spreadsheet program. To make...

0

What is Spreadsheet Software

A spreadsheet software is a computer program (e.g. Excel, Lotus) that has efficient and accurate methods to work with numbers. You can perform very simple to ultra-complex scientific calculations with spreadsheet software. To make...

0

What is Spreadsheet in Excel

A spreadsheet in Excel is basically a worksheet which is divided into rows and columns to store data related to business inventories, income and expenses, debits and credits. Today’s business world uses electronic spreadsheets...

0

What is Ribbon in Excel

In this tutorial, you are introduced to Excel’s Ribbon feature. Following Excel’s ribbon topics are covered in this tutorial- → Understanding basic components of Excel Ribbon → Familiarizing yourself with the Excel Ribbon tabs...

0

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 there are three cell references, they are B3, C3 and...

0

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 there are three cell references, they are B3, C3 and...

0

Absolute cell references in Excel

Before understanding absolute cell references, you have to understand cell reference in a formula. Say I have a formula like this ‘=B3*C3+D3’. In this formula there are three cell references, they are B3, C3,...

0

Relative cell references in Excel

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