Watch
Explore

Google Sheets

Google Sheets Advanced Tips
90 Pins
·
3w
By
Prashanth K V
an image of a computer screen with numbers and symbols in the bottom right hand corner
Google Sheets
Google Docs
Summarize Data and Keep the Last Record in Google Sheets
In Google Sheets, we can summarize data (like sum, average, min, max, count) using the QUERY function, but how do we also keep the last record along with the summary?
a screenshot of an excel spreadsheet with the date and time tab highlighted
Buy Apple
Filter
The Selection
Let It Be
Filter Data with Multi-Select Drop-Downs in Google Sheets
In this tutorial, we’ll explore how to filter data using multi-select drop-downs in two different ways.
an excel spreadsheet with multiple columns and numbers in the bottom left hand corner
Date Headers
Month Numbers
How To Split
Pivot Table
Google Forms
Use Case
Step By Step
Sort QUERY Pivot Headers in Descending Order in Google Sheets
In this tutorial, let’s explore step-by-step how to sort QUERY pivot headers in descending order.
a table with several different types of books on it, including the names and numbers of authors
Highlighting Techniques
Inventory Tracking
Data Structures
George Orwell
The Great Gatsby
Construction Site
Highlight Rows by Issue and Return Status in Google Sheets
Highlighting rows based on issue and return status is a useful feature in Google Sheets for effective inventory tracking. Whether you’re managing a construction site or a library, this approach can help you easily monitor your inventory.
a screenshot of the google spreadsheet with numbers and symbols highlighted in it
Data Table
Data Integrity
Study Planner
Step Guide
Pay Attention
3 D
3-D Referencing Structured Data Tables in Google Sheets
It’s important to note that 3-D referencing is unnecessary when you only have one or two tables.
a screenshot of an excel spreadsheet with multiple numbers and symbols in it
Syntax
Running
Case-Sensitive Running Count in Google Sheets
This tutorial provides a solution for incorporating case sensitivity into the running count of values in Google Sheets.
there was a problem in the text box
Data Validation
Excel Formula
How To Apply
Fix Fractional Percentage Formatting Issues in Google Sheets
Applying data validation is the only effective solution to resolve issues related to fractional percentage formatting in Google Sheets.
a screenshot of an excel spreadsheet with the date and time fields highlighted
Looking Up
To Look
Lookup the Smallest Value in a 2D Array in Google Sheets
We can use a combination of BYROW and SMALL with FILTER or XLOOKUP to look up the smallest value in a 2D array in Google Sheets.
a spreadsheet with multiple rows and numbers in the top row, including one column
Study Planner Template
Timesheet Template
Yearly Calendar Template
Spaced Repetition
Create Name
Study Sessions
Google Sheets: Adaptive Study Planner with Auto-Reschedule
This adaptive study planner template helps you effectively schedule and manage your study sessions for each chapter.
a screenshot of an excel spreadsheet with multiple columns and numbers on it
Fibonacci Sequence
Moving Average
Drop Down List
Multiple Choice
Everything You Need to Know About Multiple Choice Drop-Down Chips in Google Sheets
In this example, I will create a multiple-selection drop-down list in cell A1 using the values in column D.
Related searches
Timesheet template
Data validation
Syntax
Excel formula
Gantt chart
a screenshot of an excel spreadsheet with multiple columns and numbers on it
Fruit Names
To Create
Create Multiple Choice Dependent Drop-Downs in Google Sheets
Tired of limited options in your Google Sheets drop-downs? Learn how to create powerful multiple-choice DEPENDENT drop-downs (drop-down chips) in this easy-to-follow tutorial!
a green background with the words create a dynamic fibonaci se - quence in google sheets
Fibonacci Number
Data Analysis
Save Time
Create a Dynamic Fibonacci Sequence in Google Sheets
Create a dynamic Fibonacci sequence in Google Sheets with this easy-to-follow tutorial! Save time, improve accuracy, and explore the beauty of math with this powerful spreadsheet function. #GoogleSheets #Fibonacci #DataAnalysis #SpreadsheetTips #ProductivityHack
an aerial view of a basketball court and hoop
Google Sheets Tutorial
How To Create A Budget On Google Sheets
Google Sheets Checklist
Name Picker
How To Use Google Sheets
Grade Tracker Google Sheets
How to Generate Random Groups in Google Sheets
Quickly and easily create random groups using Google Sheets. Perfect for parties, classrooms, or team building activities. #GoogleSheets #RandomGroups #Tips #Productivity
an aerial view of a basketball court and hoop
How to Generate Random Groups in Google Sheets
Quickly and easily create random groups using Google Sheets. Perfect for parties, classrooms, or team building activities. #GoogleSheets #RandomGroups #Tips #Productivity
a woman sitting in front of a laptop computer on top of a wooden table next to a plant
5am Club
Graphic Design Course
Job Security
Social Media Optimization
Freelance Business
Design Course
Remote Jobs
Marketing Courses
Social Media Influencer
How to Create a Running Sum with Negative Value Carryover