Excel has many functions that can be used for calculations easier. Two important engineering functions are CONVERT and DELTA. Engineering Functions – CONVERT This function can be used for changing the units of scientific values and entries in a sheet. Vidya has the following sheet forwarded from a friend at US. She wants to make …
CONVERT and DELTA: Important Engineering Functions in MS Excel Read More »
As mathematical operations are a primary use of Excel sheet, one can use the trigonometric functions to compute these easily. The following sheet was created by Rahul to find the cos and sine values of the angle. He can use the values using COS and SIN functions. Trigonometric Functions – COS In trigonometry, COS is …
COS and SIN Functions: Important Trigonometric Functions in MS Excel Read More »
At times, when one is working with multiple data tables in Excel, one may have to compare these in order to reach a fruitful result. In simple terms, checking and restoring the relationships between various data tables can be termed as Data Reconciliation. Helen has the following tables in her sheet. One of the …
Data Reconciliation in MS Excel – Free Excel Tutorials Read More »
An Excel user can insert data into his or her sheet from external sources as well. Mariam is the head of a team of students for an NGO. Now, she has to compile the details collected by all of them. How can she do this easily? She can do this by importing data from external …
Importing Data from External Sources – Free Excel Tutorials Read More »
The Function Library of Excel has formulas that can come useful for any professional In this module we will look at two important financial functions necessary for a Financial Analyst. Financial Functions – PMT This function can be used to calculate the periodic loan payment that a person has to make. For example, Ridhi has …
PMT and RATE: Important Financial Functions in MS Excel Read More »