ExcelDemy.com Blog

Working with Dialog Boxes in Excel 0

Working with Dialog Boxes in Excel

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

Undo Redo commands in Quick Access Toolbar 0

Undo Redo commands in Quick Access Toolbar

Undo command is located on the Quick Access toolbar. You can use this command to delete your recent actions you have done in Excel worksheet. If you have done an error when you were...

How to customize the Quick Access Toolbar 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...

Using shortcuts menus in Excel 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,...

How to Use the keyboard to work with the ribbon 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...

Dialog Box launcher of Excel Ribbon 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...

Types of commands on the Ribbon 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...

How to choose Spreadsheet Software 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...

What is Spreadsheet in MS Excel 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...

What is Spreadsheet Program 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...

What is Spreadsheet Software 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...

What is Spreadsheet in Excel 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...

What is Ribbon in Excel 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...

How to reference a cell from a different worksheet in Excel 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...

How to use cell references with multiple worksheets in Excel 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...