Category: Excel

Data validation is a tool that reduces errors, it helps in making cells constraint to some particular values only. MS Excel says ” Data validation is an Excel feature that you can use to define restrictions on what data can or should be entered in a cell. You can configure data validation to prevent users from…

Hi friends, Let us learn about Vlookup function of MS Excel. If, you have a big table and you dont want to drag your mouse each and every time you need some value from that table, you can use Lookup or Vlookup or Hlookup.  These are some of the best techniques of data extraction from…

Hi, Add-ins are the custom functions/commands/formulae or macros stored in an external file which can be used in any excel file to increase productivity. In order to use Add-Ins, you should be allowing the add ins. to do that follow this steps. 1. Go to file — options — Trust Center — Open trust center…

Sometimes, a quick tip saves so much time that we feel amazed. This is such one tip to save your hours in the future work. Selecting blank cells and adding value to is a repetitive work, and, if we can make this repetitive work a one time work, the time of all the clicks for…

 Many a times we encounter problems of solving equations within spreadsheet for engineering calculations. Suppose you want to solve n²-3n+1.5674 = 0, and want to find answer of the same in the middle of your engineering sum.  There are two options available in excel for the same. 1.       You can use goal seek. Follow following…

Let’s say your spreadsheet formulas have errors that you anticipate and don’t need to correct, but you want to improve the display of your results. There are several ways to hide error values and error indicators in cells. There are many reasons why formulas can return errors. For example, division by 0 is not allowed,…

option 1:  Perhaps the simplest way to hide all zero values in a sheet is to let the worksheet do it Just remember, this setting works at the sheet level. You must set it for each sheet in the workbook, as follows. Click the File menu and then choose Options (under Help). In Excel 2007, click the…

Many a times we have lots of rows of data. When we want to print the same we need titles to be appeared on every page. There is an option for it in excel. Follow the following procedure: 1. Just go to page layout. 2. Select the option called print title. 3. Select the area…

You can use a formula with the ampersand (&) operator to combine text from multiple cells into one cell. 1. Select the cell in which you want to combine the contents of other cells. 2. To start the formula, type =( 3. Select the first cell that contains the text that you want to combine,…

Many times you want to repeat some actions. You can do repetitive task faster by pressing Ctrl + Y for repeat. Some actions, such as using a function in a cell, cannot be repeated. For example you have filled a cell with a color. And you want all the cells that need value to of…

Solver is the option that you need. To install solver add in do the following. Go to Excel options → Add ins → Manage add ins → go → select solver add in and press ok to install it. If you have installed solver, Go to data → in analysis ribbon solver to open the…

There are two options to add line break. 1.      Wrape text and adjust the width of cell to see the cells in two line. On the Home tab, in the Alignment group, click Wrap Text. 2.      double-click the cell, click the location where you want to break the line in the cell, and then press…

Goal seek is the formula that you need. When you know the result but not the input, this formula helps you find the input. You can find goal seek in data → what if analysis → goal seek.   Hope you find it useful. Comment if you have doubts or suggestions. Like, tweet and +…

Just try to add & in header in excel. If you find a way tell us. If not, then just type as shown below. Use double && instead of one. For example, if you want “something & somewhere” in header, then type “something && somewhere” in header and one & will be seen there. It…

Want to program in visual basic in excel? For that you have to open visual basic in excel. Here is a way. 1.      Open excel 2.      Press Alt+F11. Or go to developer tools → select Visual Basic. 3.      You have opened the visual basic application window. 4.      Type your program in modules. 5.      Save…

Want to take your viewers to some other links in between the presentation? Here is a way. Just select the text from where you want to show external links and files in between presentation.  Right click and select hyperlink option. Or goo to insert menu and select hyperlink.  Select the media or file you want…