Category: Excel Basics

Accessing ribbon by using your keyboard

At first glance you may think that the accessing Ribbon is completely Mouse- centric. After all, the commands don’t display the traditional underlined letter to indicate the Alt +keystrokes.  But in fact, the Ribbon is very keyboard friendly. The trick is to press the alt key to display the pop-up key tips. Each Ribbon control

All about number formatting in excel

Number formatting in excel. The appearance of numbers in the cells can be changed by changing the formatting of numbers. There are many number formatting options available in excel. In the following sections you see how to use many number formatting in excel to quickly improve the appearance of your worksheets. When you enter the

How to customise quick access toolbar…?

If you use some of the excel commands very frequently and if you find it difficult to call from the ribbon, you can add this command to quick access toolbar with the help of customise quick access toolbar. Default quick access toolbar will contains 3 tools save, undo and redo. You can customise the quick access toolbar

Editing cell contents in excel

Editing cell contents in excel There are different ways to edit data in a cell. Edit the cell’s contents. Delete the cell’s contents. Replace the cell’s contents with something else. Editing the contents of a cell If you want to make any change in the existing data in a cell, you can edit cell data.

Types of commands on the Ribbon

When you move your mouse pointer over a ribbon command, you will see a pop-up box that contains the command’s name, as well as a brief description. For the most part, the commands in the Ribbon work just as you would expect them to. Below are the different style of commands on the Ribbon: Simple buttons: Click the

Ribbon tabs in excel

Microsoft has introduced Ribbon interface from Office 2007 and later version. This interface will replace the traditional menu and toolbar with a collection of icons at the top of the screen. This Ribbon icons grouped based on the functions under different tabs. Users find that the Ribbon tabs in excel is easier to use as

What you need to know in excel screen ?

If you are using the excel for the first time or if you are not so familiar with excel software. Following are the parts of the excel screen that you need to know in excel screen to use the exciting features of excel. What you need to know in excel screen ? 1.   Active cell

Workbooks, Worksheets in excel

Workbooks: In this post you can understand what is Workbooks and Worksheets in excel. The Work you do in excel is performed and saved in a file, such excel file is called as workbook. You can open as many excel files you need, and each one appears in different window. Excel workbooks/ files are saved

8 Best Uses of Excel software

Excel is a spread sheet software developed by Microsoft, used for numerical calculations data analysis. This is a widely used user friendly software which helps in storing the data, numerical calculation, graphs and charts, dashboard reporting etc.  Below are the top 8 best Uses of Excel spread sheet software:- 1.   Numerical calculations:- This type of

Excel shortcuts to speed up your work.

Click here to download this in Excel Function Key Open [Ctrl] + [O] Exit [Alt] + [F4] Move to the beginning of the worksheet [Ctrl] + [Home] Move to next sheet [Ctrl] + [Page Down] Move to previous sheet [Ctrl] + [Page Up] Convert to a percentage [Ctrl] + [Shift] + [%] Apply outline to active