- Видео 13
- Просмотров 63 947
The First Pancake
Канада
Добавлен 10 окт 2021
Google Suite tutorials to take your projects to the next level.
Our channel is called "The First Pancake" because anything worth doing well is worth doing badly first. That first pancake is always a bit wonky, but the next few are awesome. It's the same with learning new tech: things may not go so well the first time you try a Google Sheets formula, but with practice, you can produce amazing results!
Our channel is called "The First Pancake" because anything worth doing well is worth doing badly first. That first pancake is always a bit wonky, but the next few are awesome. It's the same with learning new tech: things may not go so well the first time you try a Google Sheets formula, but with practice, you can produce amazing results!
Google Sheets: Conditional Multi Drop Down Lists
Today we are creating a multiple drop down list where the values in the second drop down are dependent on the value selected in the first dropdown.
Have you ever been building a spreadsheet and filling out data with a few related sets and you wished there was an easier way? You're in luck -- there is! I was inspired by two other RUclipsrs:
@LeilaGharani in this video: ruclips.net/video/7mo4COng7Sg/видео.html
@KevinStratvert in this video: ruclips.net/video/vh2jdOQ5VLs/видео.html
I saw what they did and wanted to take it up another notch.
00:00 - intro
00:39 - formulas in this video
00:57 - XLOOKUP
01:31 - SORT
01:58 - ARRAYFORMULA
02:24 - TRANSPOSE
02:54 - let's build!
07:29 - the extra extra
15:46 ...
Have you ever been building a spreadsheet and filling out data with a few related sets and you wished there was an easier way? You're in luck -- there is! I was inspired by two other RUclipsrs:
@LeilaGharani in this video: ruclips.net/video/7mo4COng7Sg/видео.html
@KevinStratvert in this video: ruclips.net/video/vh2jdOQ5VLs/видео.html
I saw what they did and wanted to take it up another notch.
00:00 - intro
00:39 - formulas in this video
00:57 - XLOOKUP
01:31 - SORT
01:58 - ARRAYFORMULA
02:24 - TRANSPOSE
02:54 - let's build!
07:29 - the extra extra
15:46 ...
Просмотров: 26 256
Видео
Google Sheets: Use Index and Match Together for Advanced Lookups
Просмотров 332Год назад
A few weeks ago we did a video on VLOOKUP. Now we are taking it to a new level with INDEX and MATCH. 🔥 While they may look like they do the same, INDEX and MATCH together brings a whole new dimension to your lookups allowing you to return entire rows or columns, or to return values to the left of the search key. This is a game changer when building a great spreadsheet. Learn how to combine form...
Google Sheets: how to use COUNT, COUNTA, and COUNTIF
Просмотров 3,4 тыс.Год назад
In this tutorial, we'll explore three powerful formulas in Google Sheets that can help you work with data more efficiently: COUNT, COUNTA, and COUNTIF. With these formulas, you can quickly count the number of cells in a range that contain numeric data, count the number of non-empty cells in a range, or count the number of cells that meet specific criteria. Whether you're analyzing survey result...
Google Sheets: VLOOKUP tutorial
Просмотров 99Год назад
VLOOKUP is a staple in Google Sheets and is used time and time again. In this video, I take you step-by-step through the VLOOKUP function. After a short description of what the function does and how to use it, we see real-world examples of how it can be used. All music is from Epidemic Sound
How to Add Colour to Drop-Down List Chips in Google Sheets
Просмотров 1,6 тыс.Год назад
Set the colours of your status drop-down lists so you can easily track where you are at with each company. Learn Google Sheets while you find your dream job. In this video, we cover: 00:00 - intro - some suggestions for your to-do list 01:09 - how to change your drop-down list options' chip colours 02:43 - some job interview tips Keep your chin up. We believe in you. 🔗 Get a copy of the finishe...
How to Format Currency and Sum a Range of Cells in Google Sheets
Просмотров 12 тыс.Год назад
Format currency and figure out how much you should be asking for when you land that dream job. Learn Google Sheets while you search for your dream job. In this video, we cover: 00:00 - intro - things to consider regarding your expected salary range 00:41 - review of how to add data validation rule for dates 01:03 - how to format currency 01:30 - use SUM to calculate the total of a range of cell...
How to Calculate the Months or Years Between Two Dates in Google Sheets
Просмотров 3,4 тыс.Год назад
Continue building your job search tracker and learn how to calculate the length of time between two dates. Keep learning Google Sheets while you search for your dream job. In this video, we cover: 00:00 - intro to the job durations tab 00:43 - how to format a date 01:48 - how to calculate the number of months between two dates using DATEDIF 02:23 - how to calculate the number of years between t...
Drop Down Lists, Format Dates, and Calculate Days Between Dates in Google Sheets
Просмотров 3,5 тыс.Год назад
Continue building your Job Search Tracker. Create your own workflows with status drop-downs, date formats, and colour coding. Learn Google Sheets while you search for your dream job. In this video, we cover: 00:00 - intro 01:09 - how to create a drop-down list using named ranges 03:18 - date validation and formatting 05:17 - how to calculate the last contact date Time time, we calculate the las...
Build a Job Search Tracker using Google Sheets - Intro
Просмотров 12 тыс.Год назад
Layoffs have been rampant. We've been there and it is terrible. If you are in search of a job, this Job Search Tracker will keep you organized so you don't lose your head in the process. You can learn Google Sheets while you get ready for the interviews. Keep your chin up! 🔗 Get a copy of the finished template: templates.thefirstpancake.ca/l/job-search-tracker
Google Sheets: The Magic Dropdown Tutorial
Просмотров 796Год назад
Don't you hate when you are using a dropdown to rank options and you put this same option twice? You end up going back to redo all of it. With this Magic Dropdown tutorial that will never happen again. Find out how to remove options from the list after you have used them. Make your life and your rankings easier, more efficient, and impress your boss! We cover FILTER, NOT, and COUNTIF in this tu...
Getting Started With Google Sheets: Data Filtering and Slicers
Просмотров 100Год назад
We dive into Google Sheets data filters and data slicers in this helpful tutorial. You will get a handle on the basics of how to filter and slice your data for better visibility and organization. We cover the dos and don'ts for each filter type to avoid overwriting when collaborating on a spreadsheet.
Get Started With Google Sheets: Essential Tutorial
Просмотров 173Год назад
Learn the basics of Google Sheets with this helpful tutorial! Get up to speed on creating spreadsheets, entering data, formatting cells, and more. Credits: Fake Data browser extension: fakedata.pro/ Battleship boardgame image credit: www.huffpost.com/entry/board-games-best-worst_n_5596251
Welcome to The First Pancake
Просмотров 203Год назад
Master Google Suite of apps and get super powers in your career. Always remember - Anything worth doing well, is worth doing badly first.