Category: How to Guide
-
How to solve equations in Excel?
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…
-
How to extend beam in STAAD.Pro?
In previous article we saw how to extend beam in ETABS, now let us see how to extend beam in STAAD. Following are the steps to do the same. 1. Select the beam line which you want to extend. 2. Go to geometry → Stretch selected member command. Or select the button shown in the…
-
How to Extend a line in ETABS?
Many a times we need to extend beams to the perpendicular beams some distance away. In ETABS, we have to follow a procedure to do the same. Following are the steps you need to do in order to extend a line. Select the line and the end point of the side you want to extend…
-
How to find the mass of reinforcing bar quickly?
Simple way to find the weight of reinforcing bar: The density of steel is 7850 kg/m³. Now let say you want weight per m. then what will be the formulation? Check this out. 7850(kg/m³) x [pi()/4 x d² ](m²)= mass of the bar per m. (eq. 1) Now resolving this we get 7850 x…
-
How to extract reinforcement percentage from ETABS?
We can see reinforcement percentage requirement of columns and beams in ETABS. Many a times we want to get a summary of concrete design results, we do this by copying the table from display menu and pasting the same in Excel. Some of our smart colleague use Microsoft access for the same. The results summery…
-
How to Change currency format to Indian style in Windows 7?
How to Change currency format to Indian style? Do you see currency as 1,333,452,265 instead of 1,33,34,52,265 ? you can change the currency style to Indian grouping style. Just follow the steps shown below: 1. Go to control panel and open Date, Time, Language and Regional Options. 2. Click on Change the format of numbers,…
-
How to hide error values from a cell in MS Excel?
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,…
-
how to hide 0 values in a spreadsheet?
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…
-
How to add title on every page in MS excel?
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…
-
How to search about medicines using Google?
To see information about most generic and brand name prescription drugs in the U.S., enter the drug name into the search box, and Google will display a summary and description of that medication. You can click through links from the National Institutes of Health to get more information about side effects, how to take the…
-
How to find about disease using Google?
To see information about a common disease or symptom, enter it into the search box and Google will return the beginning of an expert summary. You can click through to read the entire article. Hope you find it useful. Comment if you have doubts or suggestions. Like, tweet and + post if you find it…
-
How to find movie timing using Google?
To find reviews and show times for movies playing near you, type “movies” or the name of a current film into the Google search box. If you’ve already saved your location on a previous search, the top search result will display show times for nearby theatres for the movie you’ve chosen. Hope you find it…
-
How to convert units using Google?
You can use Google to convert between many different units of measurement of height, weight, and volume among many others. Just enter your desired conversion into the search box and Google will do the rest. For example type “12.5 cm in feet” and search. Hope you find it useful. Comment if you have doubts or…
-
How to search synonyms using Google?
If you want to search not only for your search term but also for its synonyms, place the tilde sign (~) immediately in front of your search term. Hope you find it useful. Comment if you have doubts or suggestions. Like, tweet and + post if you find it useful. follow us to get more.
-
How to find the earthquakes in Google?
To see information about recent earthquakes in a specific area type “earthquake” followed by the city and state or U.S. zip code. For recent earthquake activity around the world simply type “earthquake” in the search box. Hope you find it useful. Comment if you have doubts or suggestions. Like, tweet and + post if you…
-
How to publish word file as PDF?
To save or export a file to PDF or XPS, you must first install the Publish as PDF or XPS add-in for the 2007 Microsoft Office system. 1. Go to the Microsoft Save as PDF or XPS Add-in for 2007 Microsoft Office programs and follow the instructions on that page. 2. After you install the…
-
How to combine the contents of multiple cells into one in Excel?
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,…
-
How to repeat an action in Excel?
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…
-
How to take screenshot in Mobile?
Many times we want to save information which is on the screen. Some error message or some imp. notes. At such times screenshot is a good option to save the information as jpg. Here is a way to take screenshots. 1. In android icecream sandwich version → Power button + Volume down key works for…
-
How to do iteration process in excel?
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…
-
How to add line break in a cell in excel?
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…
-
How to get the desired result by adjusting the input in excel?
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 +…
-
How to make a folder without name?
Try typing the name as “ALT+255”, Press Enter. Congrats, you have made a folder with no name. Hope you find it useful. Comment if you have doubts or suggestions. Like, tweet and + post if you find it useful. follow us to get more.
-
How to add “&” in header in excel?
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…