Видео 19
Просмотров 33 640

Resource Management App for Small Business Makers - Free App

6:05

New Row, No Work! Array_Constrain() - Automatic Formulas in Google Sheets

4:24

Automate Your Formulas for Every Row in your Spreadsheet

4:43

HR Workflow for Employee Changes - Digital Personnel Action Form (PAF) Template in Google AppSheet

11:46

Filter Your Data Automatically Using Another Data Set - Google Sheets

3:40

Exclude Rows From Your Data Using a List - Google Sheets

3:27

Customize your Resource Management App - for Makers and Small Business owners

ruclips.net/channel/UCssQx5aYMvVnN_j1FnNxHIQ
This was built for my wife's small business, Outbound Candle Company
🚩www.outboundcandleco.com/ 🚩
Watch the demo of this app here - ruclips.net/video/cyWPOredu34/видео.html
Link to Free Template for Resource Inventory System - www.appsheet.com//templates/A-way-to-keep-track-of-resources-you-use-to-make-products?appGuidString=ba1aa281-a74b-4bc7-8ff5-db2a4faa2366
If you use this template or appreciate the freebies, please subscribe!
Small Business and Makers who use things to make other things need this free tool. Stop spending money on tools to keep track of your resources that you use to make your products. Use this free template to customize your ow...

Видео

Resource Management App for Small Business Makers - Free App

6:05

Resource Management App for Small Business Makers - Free App

Просмотров 686 месяцев назад

ruclips.net/channel/UCssQx5aYMvVnN_j1FnNxHIQ This was built for my wife's small business, Outbound Candle Company 🚩www.outboundcandleco.com/ 🚩 Link to Free Template for Resource Inventory System - www.appsheet.com//templates/A-way-to-keep-track-of-resources-you-use-to-make-products?appGuidString=ba1aa281-a74b-4bc7-8ff5-db2a4faa2366 If you use this template or appreciate the freebies, please sub...

New Row, No Work! Array_Constrain() - Automatic Formulas in Google Sheets

4:24

New Row, No Work! Array_Constrain() - Automatic Formulas in Google Sheets

Просмотров 1,1 тыс.6 месяцев назад

ruclips.net/channel/UCssQx5aYMvVnN_j1FnNxHIQ Arrayformula() video (ruclips.net/video/AvozCn3pp5Y/видео.html). Why worry about keeping up with your formulas when you enter new data if you can automate it!? Keep your calculations clean and consistent with Arrayformula(), and keep that formula contained to just the rows you need with Array_Constrain(). 0:00 - Intro 0:15 - Where we left off Arrayfo...

Automate Your Formulas for Every Row in your Spreadsheet

4:43

Automate Your Formulas for Every Row in your Spreadsheet

Просмотров 5937 месяцев назад

ruclips.net/channel/UCssQx5aYMvVnN_j1FnNxHIQ Tired of dragging formulas, copy pasting, or a coworker accidentally breaking all your formulas?! New Row, No problem! Learn the super power of ArrayFormula() and you'll be able to write one formula that generates for every row of data. Gone are the days of chasing down broken formulas in spreadsheets. Learn how to constrain your ArrayFormulas dynami...

HR Workflow for Employee Changes - Digital Personnel Action Form (PAF) Template in Google AppSheet

11:46

HR Workflow for Employee Changes - Digital Personnel Action Form (PAF) Template in Google AppSheet

Просмотров 1818 месяцев назад

ruclips.net/channel/UCssQx5aYMvVnN_j1FnNxHIQ Ditch the paper, and forget buying some expense tool. If you're organization working in Google Workspace here is a FREE template to get you started with a better Digital Personnel Action Form (PAF) in AppSheet. Human Resources will never be the same with this tool and workflow. If this has helped you, please Subscribe and Like! Included Features: Pre...

Filter Your Data Automatically Using Another Data Set - Google Sheets

3:40

Filter Your Data Automatically Using Another Data Set - Google Sheets

Просмотров 1,3 тыс.2 года назад

This video will show you how to filter your data by comparing against a list of items. It's like creating an inner join in SQL. Simply list the things you want to include in your table and let the formula do the work! No more hard coding filters to include certain rows. Sample Data Here: docs.google.com/spreadsheets/d/149DDkACw8g-HHgEVbo5viFQweg7A31vEoV0TQ4f4eOg/template/preview 0:00 - Intro 0:...

Exclude Rows From Your Data Using a List - Google Sheets

3:27

Exclude Rows From Your Data Using a List - Google Sheets

Просмотров 4,4 тыс.2 года назад

ruclips.net/channel/UCssQx5aYMvVnN_j1FnNxHIQ This video will show you how to exclude rows of data by comparing against of list of items. It's like creating an left excluding join in SQL. Simply list the things you want to match on that you wish to not include in your table and let the formula do the work! No more hard coding filters to exclude information. Sample Data Here: docs.google.com/spre...

Auto Highlight an Entire Row Based on Values in a Single Column in a Spreadsheet

2:46

Auto Highlight an Entire Row Based on Values in a Single Column in a Spreadsheet

Просмотров 4582 года назад

ruclips.net/channel/UCssQx5aYMvVnN_j1FnNxHIQ Custom conditional formatting can be tricky in sheets. It's all about the right formula. Here is a quick and easy way to use conditional formatting to automatically highlight an entire row (not just a single cell in a column) of your sheet based on the values in a single column. Sample Sheet - docs.google.com/spreadsheets/d/1rXZfkhQtIScQt3uwKLeojYz9D...

Calculating Candle Fragrance Oils with Google Sheets

5:44

Calculating Candle Fragrance Oils with Google Sheets

Просмотров 4752 года назад

ruclips.net/channel/UCssQx5aYMvVnN_j1FnNxHIQ This video breaks down a tool I made for a small candle company to help them be accurate and consistent with their candle making. Don't skip the math! Not sure how much fragrance oil to use in your candles? Use this sheet to always know the correct wax and fragrance oil to use when making scented candles. Get the Sheet here - docs.google.com/spreadsh...

Vlookup on Multiple Fields and Extend it with ArrayFormula - Google Sheets

6:18

Vlookup on Multiple Fields and Extend it with ArrayFormula - Google Sheets

Просмотров 1,8 тыс.3 года назад

Need to match on multiple keys? Want to extend that formula through you data with arrayformula? Can't quite make it work with Filter() or Query(). Learn how here. docs.google.com/spreadsheets/d/1HAipLSk0TKPZ0mtc4wMRPDQ9Vean60JcJnk_Z9WJHgw/edit?usp=sharing

Interactive Conditional Formatting between Sheets - Google Sheets

6:39

Interactive Conditional Formatting between Sheets - Google Sheets

Просмотров 21 тыс.3 года назад

ruclips.net/channel/UCssQx5aYMvVnN_j1FnNxHIQ Solving your problems on the internet - In this video we tackle a problem that had to do with interactive selection on one sheet, that would trigger conditional formatting on a different sheet. Take a copy of the sheet here - docs.google.com/spreadsheets/d/1vbiIATW-b37ICt2XFlXkC5hQ8MBTlLxrgrOoBefJ3zw/edit#gid=1031160638

Scrape data from websites into Google Sheets and Data Studio

12:20

Scrape data from websites into Google Sheets and Data Studio

Просмотров 1,1 тыс.4 года назад

This video highlights the behind the scenes of a project to use Google Sheets to scrape wildfire data from inciweb.nwcg.gov/ and track the data overtime in Google Data Studio. Links to the Sheet and Dashboard for you to make your own copies: Sheet - docs.google.com/spreadsheets/d/1Z0h02V_JIdMjEXZ4oaN0-UKaxYTXLNrBOdpTt6FeOg4 Dashboard - datastudio.google.com/reporting/e0e3059b-d634-4eeb-89fd-d8b...

How to Open Microsoft Office Files in Google Drive

2:25

How to Open Microsoft Office Files in Google Drive

Просмотров 6224 года назад

If you don't have Microsoft Office on your computer, or your company recently switched from Microsoft Office (Word, Excel, Powerpoint) to Google's G Suite (Docs, Sheets, Slides), this video will show you how to continue working with Microsoft Office files in Google Drive.

Real Quick: Organizing Your Data in Sheets

3:04

Real Quick: Organizing Your Data in Sheets

Просмотров 224 года назад

A quick run through on the best way to organize your data when working in open ended non-structured program like spreadsheets. For more details check out the full video here... ruclips.net/video/KiAWV2QCt_8/видео.html