How to build your own Shopify sales report in Google Sheets
The must-have metrics for your Shopify sales reportShopify generates plenty of analytics data to help you measure the performance of your store. It collates the data and presents them to you in the form of Shopify reports. But it is typically easy to get lost in reports if you don’t …
A Guide to XLOOKUP in Excel
Find out how to use XLOOKUP to perform horizontal and vertical lookups in Excel. Also learn how you can run such lookups in Google Sheets.
How MVMT took their Shopify store to $90M in revenue
Story of a brand that grew from nothing to over $90M revenue in just 5 years.
How to Fix Formula Parse Errors in Google Sheets
Learn how to fix #N/A, #DIV, #REF, and #NAME errors.
How to make a Pie Chart in Google Sheets
Summarize your data visually with Pie ChartsPie Chart is a visualization tool that allows you to show the breakdown of different categories in your dataset. It compares parts of your dataset to the whole and shows the proportions in a circular form. It is very useful, especially for data visualization.In …
A Guide to INDEX-MATCH in Google Sheets
Find out how you can perform lookups in Google Sheets using INDEX and MATCH functions.
How to protect Google Sheets
Prevent your critical data in Google Sheets from accidental changes. Google sheets allow you to store data and share them with others so that you can collaborate on your sheets with your peers in real-time. While the sharing option is very convenient, sometimes you might want to protect some of …