Sheetsbyolan - Search Videos

How to use XLOOKUP with MULTIPLE conditions in Google Sheets! | Sheets By Olan

0:48

Olan Chancy on Instagram: "Easily find multiple results using a single XLOOKUP formula in Google Sheets!"

15.1K views6 months ago

Instagramsheetsbyolan

0:37

Olan Chancy on Instagram: "Quickly create custom Pivot Table groups in Google Sheets!"

3K views7 months ago

Instagramsheetsbyolan

1:03

Olan Chancy | Table referencing when building formulas can save you hours of time! | Instagram

9.7K views4 months ago

Instagramsheetsbyolan

0:34

Skip the helper column and do custom calculations directly in your Pivot Table in Google Sheets! #learnontiktok #tiktoklearningcampaign #pivottable #googlesheets #googlesheetstips

2.6K views2 months ago

TikToksheetsbyolan

1:23

How to return MULTIPLE results at the same time using a singular XLOOKUP formula in Google Sheets! #xlookup #arrayformula #worksmartnothard #work #googlesheetstutorial #googlesheetstips #learngooglesheets #googlesheets #gsheets #data #excel #spreadsheet #dataanalytics #revops #learnontiktok

192.2K viewsSep 6, 2023

TikToksheetsbyolan

0:19

Olan Chancy on Instagram: "Quickly analyze Pivot Table data using Slicers in Google Sheets!"

8.2K views7 months ago

Instagramsheetsbyolan

0:41

Pivot Tab Date filtering hack in Google Sheets!

486 views2 months ago

TikToksheetsbyolan

21:06

Both the Excel and Google Sheets Automated Task Trackers are designed to be customized. In fact, it’s encouraged since all positions have different needs. In this video I show how to customize the Excel version of the Task Tracker to customize it without breaking the automation! Prebuilt template at Sheetsbyolan.com Full tutorial on YT at sheetsbyolan Bookmark for later if you don’t have time and see below for timestamps! 00:00 - Intro 00:36 - Understanding the Current Flow 01:38 - Add new colum

815 views5 months ago

TikToksheetsbyolan

0:28

Underexplaining my Automated Task Tracker in Excel or Google Sheets! You can find full tutorials on my YT channel or a prebuilt template at Sheetsbyolan.com. #tasktracker #template #templatetutorial #excel #googlesheets | Sheets By Olan

53.2K views3 months ago

FacebookSheets By Olan

1:26

VLookup function that you need to know in Google Sheets! #vlookup #googlesheetstutorial #googlesheetstips #learngooglesheets #googlesheets #gsheets #data #excel #spreadsheet

66.8K viewsJun 30, 2023

TikToksheetsbyolan

0:30

Master Google Sheets: Easy Tips and Tricks

1.3K views10 months ago

TikToksheetsbyolan

Olan Chancy on Instagram: "Easily return multiple results with a single XLOOKUP formula!"

102.4K views7 months ago

Instagramsheetsbyolan

0:39

Olan Chancy on Instagram: "Nested XLOOKUP is a simple way to find the value where a row and a column intersect. If you’re still using index & match, you’re working too hard! #xlookup #indexmatch #googlesheets"

63.2K views3 months ago

Instagramsheetsbyolan

3:29

part 3 of creating the continuous flow task tracker! were back add it with another tutorial. this time for a new version or the task tracker with an automation allowing for a continuous flow which minimizes weekly upkeep and allows for better visualizations. let me know what you think! #tasktracker #productivitytok #highachiever #template #customtemplate #organized #customtracker #work #forgetful #worksmarternotharder #wfh #googlesheetstutorial #googlesheetstips #learngooglesheets #googlesheets

13K viewsFeb 24, 2024

TikToksheetsbyolan

2:59

How to use one of my FAVORITE formulas in Google Sheets… the ARRAYFORMULA #arrayformula #xlookup #namedranges #favoriteformula #worksmartnothard #work #googlesheetstutorial #googlesheetstips #learngooglesheets #googlesheets #gsheets #data #excel #spreadsheet #automate #learnontiktok

50.6K viewsJul 19, 2023

TikToksheetsbyolan

1:31

Quickly find missing numbers in a sequence of 5000 Formulas/features: #sequence #ifstatement #filtering @SheetsbyOlan - find missing values from a list #worksmarternotharder #googlesheetstutorial #googlesheetstips #learngooglesheets #googlesheets #gsheets #data #spreadsheet #LearnOnTikTok

8.1K viewsNov 1, 2023

TikToksheetsbyolan

1:00

Create Row Level Dependent Drop-downs in Google Sheets

2.8K views11 months ago

TikToksheetsbyolan

0:24

Olan Chancy | Underexplaining my Automated Task Tracker in Google Sheets or Excel. Prebuilt templates or full tutorials available! #tasktracker... | Instagram

58K views3 months ago

Instagramsheetsbyolan

0:56

Olan Chancy | It’s super simple to create a search function in Google Sheets. Here’s how! | Instagram

7.4K views6 months ago

Instagramsheetsbyolan

1:55

Creating the tracker Part 1: How I stay organized at work using a custom task tracker in Google Sheets! Rep0sting the original tutorial while I’m traveling since the original tutorial can’t be m0netized. #tasktracker #organized #customtracker #work #forgetful #worksmarternotharder #googlesheetstutorial #googlesheetstips #learngooglesheets #googlesheets #gsheets #data #excel #spreadsheet #LearnOnTikTok @SheetsbyOlan - task tracker overview Formulas/features: #datavalidation #dropdowns #popoutcale

154.7K viewsOct 7, 2023

TikToksheetsbyolan

0:36

How to count unique formulas without losing focus in Google Sheets! #unique #countif #googlesheetstutorial #googlesheetstips #learngooglesheets #googlesheets #gsheets #data #excel #spreadsheet #learnontiktok #uniqueformula #shortattentionspan

19.9K viewsJul 4, 2023

TikToksheetsbyolan

1:30:46

Build Your Own Upgraded Rolling Automated Task Tracker in Google Sheets! (Full Tutorial)

15K viewsApr 22, 2025

YouTubeSheets By Olan

1:01

Essential Google Sheets Count Functions Explained

60.3K viewsJun 26, 2023

TikToksheetsbyolan

How to conditionally format based on a custom formula in Google Sheets! #conditionalformatting #customformula #worksmartnothard #work #googlesheetstutorial #googlesheetstips #learngooglesheets #googlesheets #gsheets #data #excel #spreadsheet #dataanalytics #revops #learnontiktok

5.1K viewsSep 11, 2023

TikToksheetsbyolan

1:38

How to visualize data by summarizing it into a table in Google Sheets! #visualizingdata #tables #worksmartnothard #work #googlesheetstutorial #googlesheetstips #learngooglesheets #googlesheets #gsheets #data #excel #spreadsheet #dataanalytics #revops #learnontiktok Formulas/features used: -CountIFS -Cell anchoring

5K viewsOct 2, 2023

TikToksheetsbyolan

1:05

Replying to @Neverknowbetter Example 1 of how to hide formulas so only results will show in the cell in Google Sheets! #xlookup #worksmartnothard #work #googlesheetstutorial #hiddenformulas #googlesheetstips #learngooglesheets #googlesheets #gsheets #data #excel #spreadsheet #dataanalytics #revops #learnontiktok

11.3K viewsSep 13, 2023

TikToksheetsbyolan

26:20

Efficient Task Tracking System Tutorial

545.8K viewsAug 20, 2024

TikToksheetsbyolan

1:06

Olan Chancy on Instagram: "Quickly add images to your Google Sheet!"

6.2K views5 months ago

Instagramsheetsbyolan

1:57

Part 1 of how to create the custom task tracker in Google Sheets that I use to stay organized at work! #createwithme #tacktracker #organized #customtracker #work #forgetful #worksmarternotharder #googlesheetstutorial #googlesheetstips #learngooglesheets #googlesheets #gsheets #data #excel #spreadsheet #LearnOnTikTok

468.9K viewsJul 6, 2023

TikToksheetsbyolan