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 does the location and timezone affect Google Sheets document
Unlike other desktop-based spreadsheets, Google Sheets is a cloud-based application that is ubiquitous. It is location and device independent. All we need is a browser and an Internet connection. With such a grand proposition of being able to serve people all over the...
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