IF function and nested if furmula in excel

How to use IF FUNCTION AND NESTED IF ..? In excel we can do logical test with if function, IF function will check the given condition, based on the output of the condition it can give two different results. If the given condition is YES, it will give one output and if it is NO then it will give another output. In this post we will learn how to use if function and also nested if formula. =IF(LOGICAL TEST,    …

Continue Reading

Excel vba pdf : Macro to create bulk pdf in Excel.

Excel vba pdf  - VB Code: How to write Macro to create bulk pdf in Excel ? Excel vba pdf : Excel VBA programming is a powerful tool to automate the task. We can automate the repetitive task and save lot of time in work. In this post you can learn how to automate salary slip creation in pdf format. You can create salary slip in pdf for many employees with one click by VBA programming.   To create this, first…

Continue Reading

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 change in tax credits. Cash flow management becomes crucial due to duty structures. Compliance requirement will change. Re arrangement  of supply chain  may be…

Continue Reading

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
Close Menu
×

Cart