ExcelDemy.com Blog

0

Importing Data in Excel

If you want to do anything with data, you must at first get that data into your worksheet. Excel can import data from text file and can also retrieve data from websites. Importing from...

0

Excel is a superb tool to analyze data

Data is everywhere. Say we run ExcelDemy.com to make you master in Microsoft Excel. To run this site, we need to know who are visiting this site, from where they are, whether our site...

0

Understanding contextual tabs in Excel Ribbon

When you will work with charts or shapes or these kind of objects then special types of tabs will appear in Excel Ribbon Tab zone. These contextual tabs contain commands related to objects that...

1

Mouse Conventions

Some mouse related terms we shall use in the tutorials of Excel 2013. Mouse Pointer: When we move our mouse, a small graphic figure moves onscreen. The mouse pointer is generally an arrow but...

0

Controlling cell pointer after pressing Enter in Excel

By default, when you press Enter key in your keyboard, active cell will move one cell down. You can change this behavior by changing option. Go to File, then Options, then select Advanced and...

0

Using task panes in Excel

Task pane is another useful user interface in Excel. Some commands in Excel will response automatically with task panes. For example, if you work with a picture, and right click the image and choose...

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

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

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