GST invoice format in excel

Have you started the preparation for Goods and Service tax (GST)? Yes, in all probability GST will be implemented from 1st April 2017. This is a major change in indirect taxation in India. Early preparation for GST is must to understand the impact of GST with different aspects. Existing system and software will require a major modification. Product costing will change due to READ MORE

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 READ MORE

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 READ MORE

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 READ MORE

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 READ MORE

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

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 READ MORE

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: READ MORE

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, READ MORE

Income tax refund status, Assessment status, Assessee Profile Management in Excel

Income tax refund status, Assessment status, Assessee Profile Management in Excel This is Income Tax Return filing season, professionals file many many Income Tax Returns for their clients. Keeping track of all these income tax returns filed, monitoring assessment status, Income tax refund status etc is a difficult and time consuming task. To make this task easy this Excel utility READ MORE