Sheetgo Blog

Your go-to resource for all things spreadsheet related

How to use the DISC formula in Google Sheets

With the DISC formula in Google Sheets, we can calculate a security's discount rate based on its price. This is one of the myriads of Financial formulas that Google Sheets is ported with. Syntax DISC(settlement, maturity, price, redemption, [day_count_convention])...

read more

How to use the DURATION formula in Google Sheets

Do you need to calculate the number of compounding periods that an investment required to reach a target value? The DURATION formula in Google Sheets can help us with that. It considers the present value of an investment as well as the rate of appreciation to arrive...

read more

How to use the NOMINAL formula in Google Sheets

With the NOMINAL formula in Google Sheets, we can calculate the annual nominal interest rate. We just need to have the effective interest rate per annum and the number of compounding periods per year. Nominal interest rate usually refers to the interest rate before...

read more

How to use the XIRR formula in Google Sheets

Do you have a series of irregularly spaced cash flows of an investment? And you want to calculate the internal rate of return or annualized yield for that investment without the hassles of using complicated math? To our rescue, we have XIRR formula in Google...

read more

How to use the NPV formula in Google Sheets

At some point in time, we get curious as to what is the today's value of an investment we are committing to. The NPV formula in Google Sheets helps us with just that. All we need to have with us is a series of periodic investments and the discount rate for input...

read more

Visualize Google sheets data with Visible

What is Visible? Ever wanted to visualize Google sheets data, creating dashboard views and generate appealing reports? Visible is a SaaS company that allows you to create dashboards views and graphs from multiple sources. Google sheets are one of the data sources you...

read more

GDRP Compliance in Spreadsheets

Europe's General Data Protection Regulation (GDPR) is a new law governing data protection and privacy for citizens of the European Union. Its aim is to give individuals control over their data and simplify existing regulations. GDPR becomes enforceable on May 25th...

read more

Getting Structured Data for Reporting

Your company has decided to standardize spreadsheets and reporting on Google Sheets. That’s great, but first you need to get the data you want to report on. If that data resides on the web, then you can get it with data extraction. Data extraction is sometimes...

read more

How to color Google Sheets tabs?

Google Sheets primarily helps us handle information. In fact, a lot of it. Besides providing us with tools that helps us reorganize, manipulate, analyze and summarize metrics. Because this cloud based application lets us store huge data, the concept of worksheets...

read more

How to extend the Google Sheets functionalities?

We know how resourceful Google sheets can be in our day to day lives. It boosts our productivity and makes the activity of storing, sharing the information a breeze. It is already a comprehensive application with myriad of standard spreadsheet related tools and...

read more

How do I create macros in Google Sheets?

We most commonly use Google Sheets to store data and share it with others. Among other things it also lets us manipulate the data, analyze it and accordingly establish trends etc. For a regular user, the tasks can get repetitive and time-consuming, and not forget...

read more