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 numbers in cells it is unformatted, it simply consists of string of numbers. You can format number to make it easier to read with consistent…

Continue Reading

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 by adding other commands that you use often. There are different ways to add commands to quick access toolbar. Customise quick access toolbar with dropdown…

Continue Reading

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. When you want to edit the contents of a cell you can use one of the following ways to enter cell- edit mode: Double- click…

Continue Reading

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 button, and it does its thing. An example of a simple button is the Increase Font size button in the Font group of the Home tab.…

Continue Reading

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 compared to menu and toolbar. Excel provides 3 option on display of ribbons. This ribbon selection option is provided on  title bar. Auto hide: this…

Continue Reading

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 indicator- there will be only one active cell at a time in worksheet and that will be shown with dark outline 2.   Column letters -columns…

Continue Reading

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 with .xlsx file extension. Worksheet: Excel file or workbook contains one or more worksheets, and worksheet is made up of rows and columns and individual…

Continue Reading

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 software used in create budgets, tabulate the expenses analyse, survey results and perform just about any type of financial modeling etc.2.   Text manipulation:- Clean up and standardized text…

Continue Reading

Easy MIS report format of performance for small business.

MIS report format of performance for small business: Management information system reporting or MIS reporting is a set of data compiled and presented to management. This information is helpful in analyzing the business situation. This will also help in decision making for different level of management. This MIS report format will help for small business to present the information in a easy manner.   Different department may use different kinds of reports to analyse and decision making. Generally small organisation…

Continue Reading
Close Menu