Resources

The PMT Function is one of the Financial Functions available in Google Sheet. The PMT Function in google sheet returns the fixed periodic payment for an investment or loan.    This is an advanced finance function, based on a constant interval of payment like a month, constant interest rate and a constant cash flow. The PMT  function […]

  ISPMT Function is coming under the head  Financial  Functions used in the Google sheet. This google sheet function is also similar to the ISPMT finance function in MS Excel.   The ISPMT function returns the interest payment for an investment for a given rate and a constant payment schedule. Syntax of ISPMT Function ISPMT(rate, period,

An array is a table containing values. An array formula used to perform multiple calculations on “n” number of data or items in an array. Google sheet array formula also performing multiple calculations in rows and columns.    Usage of array formula helps us to ensure accuracy and safety of data in our operations. Hence

  Google Finance is a website launched by Google in 2006. It contains stock information, news, trends and quotes for people. Google sheet is a web-based spreadsheet offered by Google. GoogleFinance Function is a google sheet finance function which fetches current or historic (as required by the user) stock information from Google finance website to

Create a Pivot Table in Google Sheet A pivot table is a table summarizing the data or information from other source tables without changing the data in the source table.  Normally people are used to creating the pivot table in excel.  But Google sheet also support the formulation and use of pivot table with the amazing user

Google Sheets – An Online spreadsheet An online spreadsheet is an interactive application to store and use the data. Google sheet is a part of an online office suite offered by Google in Google Drive. Google Sheet is also a web-based spreadsheet so that it is available to update at any time wherever we are.

As some of our readers asked us to explain the steps of setting up a Data Entry Form in excel. As told by one among them, he is working in a textile business as an Inward Stock keeper cum Accountant. He always gets a lot of materials inwards. As the first entry, they are recorded in an excel sheet

We can manually copy and paste data from a website to an excel sheet. This process is doing by simple entering each data into single cells separately. But it may be a time-consuming process. It will also make us unhappy if the nature of the data is continually changing one. Learn Excel, Tableau, and SQL to

Pivot Table for Data Analysis We know that a  lot of tools are available for data analysis. But Pivot Table in Excel provides the best and easy method of data analysis.   A pivot table is a powerful tool of excel to summarise and present a meaningful report of complex data in a table. Introduction of pivot

Cash flow statement is a statement showing all cash inflows and how the organization applied these cash during a particular period of time. It is a tool for finance managers for decision making. The cash flow statement is prepared by comparing the financial statement of two different periods. It will help the finance managers’ to