Tutorials

One of the major non-relational database services available today is MongoDB. MongoDB allows you to store a wide variety of data. In this tutorial we will learn how to access structured data stored in MongoDB Atlas via its API.

Pivot Tables, by default, calculate the SUM of the values in its columns. In this guide, we will learn how to change the calculated value from SUM to a wide range of functions that are built-in to Google Sheets’ Pivot Table.

Learn how to use the ADDRESS and INDIRECT functions in Google Sheets. This is Part 2 of a two part tutorial for creating mini search bars in Google Sheets

Learn how to use the MATCH function in Google Sheets. This is part 1 of a two-part series for designing a set of mini search bars in Google Sheets.

Learn how add two-tier row labels to pivot tables in Google Sheets.

Learn how to use GETPIVOTDATA, a relatively new function in Google Sheets, to copy data from a Pivot Table to another cell.

Learn how to use the COUNTIF and COUNTIFS functions in Google Sheets.

In this tutorial, we will learn 3 methods for separating date and time from timestamps in google sheets.

on that can be used to filter out duplicates in a column of entries and leave only unique values. In this tutorial, we learn how to use this function, which also serves as Google Sheets’ alternative to the SQL SELECT DISTINCT query.

Imagine that you really want to maximize the spreadsheet formulas in Google Sheets, but the data is from MySQL. Worry not, as here is a way you can do so!

Adding columns and rows in Google Sheets is very easy. You can do it in just a few clicks! In this tutorial, you will learn two methods on how to add columns and rows in Google Sheets.

Learn how to switch the axes on charts in Google Sheets.

Learn how to find the slope of data in Google Sheets using charts and the added trendline.

Learn how to create a Gantt chart in Google Sheets, useful for visualizing schedules and current completion of tasks.

Learn how to add a trendline to charts in Google Sheets, a useful skill for finding patterns in your datasets.

Learn how to create funnel charts in Google Sheets, useful for showing progress in a specific progress

Learn how to create table charts in Google Sheets, useful for creating a dashboard of information.

Learn how to make timeline charts in Google Sheets, useful for data marked by time and dates.

Learn how to create organizational charts in Google Sheets, useful for visualizing relationships.

Learn how to make candlestick charts in Google Sheets, useful for showing the movement of prices

Learn how to create scorecard charts in Google Sheets, useful for summarizing a single metric

Learn how to create gauge charts in Google Sheets, useful for comparing a value to a range of other possible values

Learn how to make radar charts in Google Sheets, useful for comparing two separate entities based on multiple parameters

Learn how to create histogram charts in Google Sheets, useful for representing the distribution of data.

Learn how to create waterfall charts in Google Sheets, useful for showing how an initial value reached its final value.

Learn how to create geospatial charts in Google Sheets, useful for showing data based on location

Learn how to create scatter charts and bubble charts in Google Sheets, useful tools for plotting data as individual points

Learn the similarities and differences between SQL and Google QL

Learn how to use functions in Google Sheets to achieve the same result as SQL Join.

Learn how to use the WEEKDAY and SWITCH functions to find and include the day of the week of any date in a Google Sheet.

Learn how to utilize the LIMIT and OFFSET functions to manage which data is displayed and used in a Google spreadsheet.

Learn how to modify the decimal place of numbers in google sheets to the desired precision. This tool will give you greater control fo both data and display in spreadsheets.

Learn how to use a few basic functions for controlling the case and capitalization of words and letters in Google Sheets in order to improve data processing and analysis.

Learn how to create and use order tracking sheets that will allow you to better communicate with you customers, developing confidence, efficiency, and long-term business success.

Learn to use this useful and valuable function which will give you greater control in altering and exchanging values when working in Google Sheets.

Learn to protect specific sets of cells in Google Sheets. This skill will give you greater control when making calculations, analyzing data, and sharing spreadsheets with other users.

Learn an easy and valuable strategy for mastering Google Sheets which will allow you to convert numerical scores into letter grades or assign any one value to another.

Learn two functions that will allow you to work with and operate on dates and times in SQL queries in Google Sheets.

This simple yet powerful tool will help users of all skill levels to maximize their usage of Google Sheets in efficiently processing and analyzing data.

This simple tool is important for every Google Sheets user in expertly tracking and analyzing data, no matter their skill level.

This tutorial seeks to supply the user with the necessary tools to navigate dates in Google Sheets as they account for specified changes in days, months, and workdays.

Learn a vital tool in the navigation of Google Sheets.

There are many different kinds of area charts. Learn how to navigate the creation of these charts in Google Sheets to better model your data and statistics.

Learn how to keep your documents protected on this widely-used platform. Also, learn how to toggle controls to restrict or loosen access to your spreadsheets.

Learn a vital yet simple aspect of navigating Google Sheets.

Learn a vital yet simple aspect of navigating through Google Sheets.

Learn how to better navigate Google Sheets by customizing it to your own liking.

Learn about two functions of Google Sheets that are vital to your proficiency: SUMIF and SUMIFS.

Learn how to better navigate Google Sheets and the tools it has to offer. Standard deviation, variance, and z-score are all important aspects and tools at your disposal.

Learn how to connect to vital tools for your business. Doing so will greatly aid in many of your business's endeavors.

IMPORTRANGE is an effective data consolidation tool of Google Sheets. Learn how to harness this element and use it to better your work in Google Sheets.

Become acquainted with the information necessary to perform this fundamental skill in Google Sheets. This will allow you to better consolidate and digest data.

Learn the basics of this important function of Google Sheets. This information will help you better navigate through the various facets of the program.

Learn a vital skill that can be applied to one of the most widely-used programs for data extrapolation. This article focuses one just one of the various services Google Sheets has to offer.

Data analysis 101: learn the ins and outs of the mean, median, and mode calculations in Google Sheets. This is a very important skill for a widely-utilized computer program.

A tree map diagram is one way to visualize and comprehend data in a chart more easily. This article goes over how you can both add to and customize tree map charts, while also providing you with a sample sheet to work with yourself.

Learn how to integrate these to Google apps by storing Google Form results in a Google Sheet and generating a Google Form from a Google Sheet. Great for data collection and analysis.

Learn how to use FILTER on Google Sheets with single condition, multiple conditions, LARGE sort conditions, and SMALL sort conditions. Useful for data analysis and Google Sheets mastery.

Learn how to send an email from your Shopify store and domain via Shopify Email. Great for reminders, promotional campaigns, and retargeting abandoned carts.

Step-by-step guide on how to delete a pivot table in both Google Sheets and Excel. We'll provide multiple methods and helpful screenshots!

A beginner's guide to using IMPORTDATA, IMPORTFEED, IMPORTHTML, and IMPORTRANGE to retrieve external data for your Google Sheet.

Learn how to use ARRAYFORMULA to copy entire rows, columns, and arrays; apply functions to entire arrays; and apply formulas to entire arrays! Great for improving data analysis and spreadsheet skills.

Step-by-step guide on how to edit the Home Page of your Shopify Store via the site editor. Learn how to adjust your page elements, including featured collections, and more!

Easy step-by-step tutorial on how to generate a private API key for your Shopify Store. Important for exporting Shopify data to Google Sheets and other business apps.

Learn the workaround to combine multiple sheets into one using the IMPORTRANGE function in Google Sheets! We'll take you through the formula and syntax you need to make it happen and improve your data analysis.

Straightforward step-by-step tutorial on how to set up Google Analytics Events on Webflow elements, like buttons, links, and more! Great for improving website analysis and A/B Testing.

A simple, step-by-step tutorial on how to randomly pick an entry from a list on Google Sheets. Uses the INDEX, RANDBETWEEN, and COUNTA functions in the process.

Learn how to combine two or more criteria in the VLOOKUP function on Google Sheets. Great for data analysis with multiple variables.

Learn how to use ISBLANK function in Google Sheets without getting FALSE results on blank cells. Important for data validation and analysis in your spreadsheet.

Learn how to use Google Sheets SQL’s Pivot Clause clause to summarize large amounts of data by using two categories, one defining the rows and another defining the columns. 

Step-by-step ways to import data from another workbook in Google Sheets. Learn about File>Import, IMPORTRANGE, and QUERY options to get the task done.

Learn how to format pivot tables in Google Sheets with or without its Themes option. We'll take you through the font, fill, number formatting, and more to make your pivot table look presentable for the end user.

Learn how to arrange queried and aggregated data using SQL command 'order by'. Organize in ascending and/or descending order with our tutorial!

Learn how to use Google Sheets SQL’s Group by clause to summarize large amounts of data by category defined in the source sheet, whether it’s summarizing by the date of entry or by the items involved.

Learn how to use SQL Queries for aggregate values in Google Sheets to better analyze your data. This tutorial will include how to use SUM, COUNT, AVG, MAX, and MIN.

Learn how to use SQL queries on Google Sheets to format date and time, currency, and more! We'll take you through steps and examples to get this done.

Step-by-step guide on how to add custom formulas in a pivot table on Google Sheets. We'll take you through how to add it in the source sheet first and in the Pivot Table directly.

Learn how to use the Slicer tool on Google Sheets to filter your data by Value and/or Condition. We'll take you through step-by-step on how to complete this task.

Learn how to use a pivot table for data from multiple sheets in Google Sheets. We'll teach you how to merge sheet data with the QUERY function, allowing you to have all your data in one pivot table.

Guide on how to use SQL labels in Google Sheets to make your QUERY functions more efficient and to add column headers to your data!

Learn how to select multiple columns with the QUERY function in Google Sheets and SQL language to add conditions to the query. Great for breaking up large sets of data!

Learn how to query data from multiple sheets of the same workbook, multiple sheets from a different workbook, and more! Useful for handling several sheets of data.

Learn how to use the Google Sheets QUERY function to search and filter for specific words and phrases within your dataset. Helpful for analyzing text-heavy spreadsheets!

Learn how to create a SQL query based on multiple criteria in Google Sheets. We'll go over some key logical operators like AND, OR, NOT to better enhance your data analysis abilities.

An easy 5-step guide on how to filter charts and tables using the Slicer functions on Google Sheets. Improve your data analysis and visualization by harnessing the power of this function.

A simple guide to finding major metrics to measure Google Ad performance: Total Ad Revenue, CPC, CTR, ROAS. We'll cover how to find these for your entire account and for specific ad campaigns.

Easy guide on how to filter SQL data before importing into Google Sheets. We'll take you through the specific JSON code and alternative methods.

Learn more about the QUERY function and easy ways to query another sheet (within the same workbook or from a different workbook) on Google Sheets. Improve your data analysis in no time with basic SQL knowledge!

Learn how to find the Repeat Customer Rate (or, Returning Customer Rate) on Shopify as well as related metrics like customers over time, one-time customers, and more!

Search items and data by date via the QUERY function in Google Sheets. Find entries for a specific date and within a date range with step-by-step SQL commands.

Average Order Value (AOV), the average amount spent per order, is central to measuring the performance of your Shopify store. Check out this tutorial to learn step-by-step how to find this metric.

Learn how to find conversion funnel metrics, shopping cart abandonment rate, and abandoned carts on Shopify to improve your eCommerce and sales performance.

Learn how to import data from a SQL database to Google Sheets and also have the data update/refresh automatically! We'll take you through the specific script and functions needed to accomplish this task in no time.

Simple 2-step guide on how to sort pivot table rows in Google Sheets. Perfect for enhancing your data analysis and improving your spreadsheet knowledge!

Learn how to summarize your data by data, month, year, or any other relevant time period on Google Sheets by using the Pivot Table function. Follow our step-by-step tutorials to complete the tasks in just a couple of clicks!

Learn how to get started on Shopify by creating your own store and customizing its theme from Shopify's theme library. We'll take you step by step so you can get a good start on your eCommerce shop!

Crucial to eCommerce is having products to sell! We'll take you through how to add new products to your Shopify store in this step-by-step tutorial.

Learn how to locate Gross Profit, Gross Profit Margin, Cost of Good Sold (COGS), and Sales on Shopify in order to monitor your online store's profitability.

Step-by-step tutorials of 7 ways you add/remove rows and columns on Google Sheets, including Insert tab, right-click, PC and Mac keyboard shortcuts, and more!

Step-by-step walkthrough tutorial on how to easily download leads from Facebook Ads via Leads Center, Publishing Tools, Ad Manager, and external API.