- Видео 10
- Просмотров 1 714
SheetReady
Австралия
Добавлен 28 янв 2024
This channel includes videos on planning and personal finance tools available at www.sheetready.com
Essential Formulas and Functions (Google Sheets Basics - Episode 5)
This tutorial shows how to use essential formulas and functions in Google Sheets.
Previous Tutorial:
ruclips.net/video/LCx862OcbbY/видео.html
You can purchase my ready-made spreadsheet templates at www.sheetready.com
Timestamps:
00:00 Introduction
01:00 Addition
01:58 Subtraction
02:36 Multiplication
03:00 Division
03:15 Custom Formulas
04:23 SUM
05:07 AVERAGE
05:25 COUNT & COUNTA
06:41 MAX & MIN
07:26 IF
11:11 AND
12:59 OR
14:58 Functions Button
16:30 Upcoming Intermediate Tutorial
Dat🎵Music🎵
Music track: River by Lukrembo
Music track: Building Dreams by Aylex
Music track: Business by Aylex
Source: freetouse.com/music
Free Music No Copyright (Safe)
Sound Effect by Ribhav Agrawal from Pixabay
Sound Effect from Pixa...
Previous Tutorial:
ruclips.net/video/LCx862OcbbY/видео.html
You can purchase my ready-made spreadsheet templates at www.sheetready.com
Timestamps:
00:00 Introduction
01:00 Addition
01:58 Subtraction
02:36 Multiplication
03:00 Division
03:15 Custom Formulas
04:23 SUM
05:07 AVERAGE
05:25 COUNT & COUNTA
06:41 MAX & MIN
07:26 IF
11:11 AND
12:59 OR
14:58 Functions Button
16:30 Upcoming Intermediate Tutorial
Dat🎵Music🎵
Music track: River by Lukrembo
Music track: Building Dreams by Aylex
Music track: Business by Aylex
Source: freetouse.com/music
Free Music No Copyright (Safe)
Sound Effect by Ribhav Agrawal from Pixabay
Sound Effect from Pixa...
Просмотров: 23
Видео
Use Formatting to Enhance Your Data (Google Sheets Basics - Episode 4)
Просмотров 27614 дней назад
This video tutorial shows how to use formatting to enhance your data in Google Sheets. Previous Tutorial: ruclips.net/video/uqmbraJ1qBA/видео.html Next Tutorial: ruclips.net/video/CYACBk_j-iQ/видео.html You can purchase my ready-made spreadsheet templates at www.sheetready.com Timestamps: 00:00 Data Entry 02:46 Fonts 05:14 Cell Color (Fill) 06:13 Borders 07:33 Merge Cells 08:13 Alignment 09:22 ...
The Sheet Made Simple (Google Sheets Basics - Episode 3)
Просмотров 40921 день назад
This video tutorial, 'The Sheet Made Simple,' introduces users to the basics of how to use the Sheet in Google Sheets. Previous Tutorial: ruclips.net/video/XIVwr1wBPP4/видео.html Next Tutorial: ruclips.net/video/LCx862OcbbY/видео.html You can purchase my ready-made spreadsheet templates at www.sheetready.com Timestamps: 00:00 Introduction 01:25 Cells 04:18 Insert / Delete Rows & Columns 06:42 C...
Understanding the Ribbon (Google Sheets Basics - Episode 2)
Просмотров 3542 месяца назад
This video 'Understanding the Ribbon' provides an overview of the Ribbon in Google Sheets. Previous Tutorial: ruclips.net/video/uHfdVh1o-Ng/видео.html Next Tutorial: ruclips.net/video/uqmbraJ1qBA/видео.html For ready-made spreadsheets check out my spreadsheet store at www.sheetready.com Timestamps: 00:00 Introduction 00:58 Sheets Home 01:57 Collaboration Tools 02:57 The Menu 04:52 Contextual Me...
How to Create a Google Account (Google Sheets Basics - Episode 1)
Просмотров 3732 месяца назад
This video shows how to create a Google Account and your first Google Sheets spreadsheet! This is the first of a series of tutorials on how to use Google Sheets. Next Tutorial: ruclips.net/video/XIVwr1wBPP4/видео.html Create a Google Account here: accounts.google.com/signup For ready-made spreadsheets check out my spreadsheet store at www.sheetready.com Timestamps: 00:00 Intro 00:12 Create a Go...
Who Invented Spreadsheets?
Просмотров 1552 месяца назад
Have you ever wondered who invented spreadsheets? This video explores that question! Please check out my spreadsheet store at sheetready.com and my RUclips tutorials on How to Use Google Sheets. 🎵Music🎵 Music track: Travel by Lukrembo Source: freetouse.com/music No Copyright Music for Video (Free) Sound Effect by floraphonic from Pixabay Various sound effects from Pixabay
How to Use My Financial Forecaster (Google Sheets)
Просмотров 334 месяца назад
This Financial Forecaster projects the annual values of assets and liabilities and considers net cash flow. It also considers the impact of inflation on future values. This spreadsheet can be purchased at sheetready.com Timestamps: 00:00 Introduction 01:00 Set Your Parameters 02:32 Add Assets 07:56 Add Liabilities 10:45 Adding a House 13:25 Charting Your Options 19:24 Downsizing 21:41 Leaving S...
How to Use My Net Worth Tracker (Google Sheets)
Просмотров 396 месяцев назад
This Net Worth Tracker is a Google Sheets spreadsheet designed to capture your net worth journey over time. This tracker can also track assets or liabilities and provides pie-chart snapshots of your selected date. You can purchase this tool and other digital products at sheetready.com Timestamps: 00:00 Introduction 01:18 Categories 01:50 Add tracking data 10:50 Tips and features
How to Use My Gantt Chart (Google Sheets)
Просмотров 317 месяцев назад
This Gantt Chart can track up to 20 individual tasks and is ideal for small to medium projects. It also includes automated tracking of time (today's date) and overall task progress. This digital product can be purchased at sheetready.com Timestamps 00:00 Setup your chart 00:34 Add tasks, days, dates 02:01 Upgrade tasks per cent complete 03:11 Today's date override 03:39 Date format
How to Use My Reusable Year Planner (Google Sheets)
Просмотров 227 месяцев назад
This reusable annual planner is designed to be used year after year! It is designed to be used on screen but can also be printed. Digital products can be purchased from sheetready.com Timestamps: 00:00 Choose your template 01:02 Change the year 01:44 Map out your year 03:05 Print to pdf or paper