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 ...
READ MORE +Latest Posts
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 ...
READ MORE +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 ...
READ MORE +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 be able to know how to show, hide, & ...
READ MORE +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 ...
READ MORE +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 ...
READ MORE +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 type of reference to another type. Before ...
READ MORE +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, ...
READ MORE +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 of these queries answered in this article. The ...
READ MORE +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 to XFD and rows range from number 1 to 1,048,576. ...
READ MORE +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 consists of columns and rows. Columns are labeled from A ...
READ MORE +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 window. By default, Excel workbooks use a .xlsx file ...
READ MORE +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 and up-to-date features. Online Storage of Excel ...
READ MORE +What is Excel Used for in the Workplace?
Excel has been the world standard for many years. Excel is popular as it is versatile. ‘Excel is versatile’– means that you can do many things with Excel. In this short blog post, we are going to ...
READ MORE +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, and debit-credit calculations. Today's business ...
READ MORE +About ExcelDemy.com
ExcelDemy is a place where you can learn Excel, Data Analysis, and other Office related programs. We provide tips, how to guide and also provide Excel solutions to your business problems.
ExcelDemy.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program. I earn a small commission if you buy any products using my affiliate links to Amazon.