Curated Video
Google Apps Script - Exercise Coding Projects - How Marcos can Be Used to Create an App Script - Explore What an App Script Is
This video explains what an app script is. This clip is from the chapter "How to Do Amazing Things with Google Apps Script - Power Up Your Apps Script Code" of the series "Google Apps Script - Exercise Coding Projects".This section...
Curated Video
Google Sheets Fundamentals - Text-Wrap and Rotation
Wrap and Rotation • Changing Column Width • Text Wrap Options • Text Rotation Options
Curated Video
Quickly Displaying and Hiding Formulas in Excel Spreadsheets
In this video, the instructor demonstrates two quick methods to toggle between displaying formulas and calculated values in a spreadsheet. By utilizing the Formula Auditing section in the ribbon, users can easily switch between viewing...
Curated Video
Generate Random Data in Google Sheets
Sometimes I find it necessary to generate some random data in a spreadsheet, perhaps for testing out an addon or a formula, or when creating a resource for students to use. in this video, I demonstrate a very useful addon for Google...
Curated Video
Generate a Random Date Between Two Dates in Excel
This tutorial demonstrates how to generate random dates between two specified dates using the randbetween function in Excel. By inputting the earliest and latest dates as parameters, viewers can create a dynamic spreadsheet that...
Curated Video
Google Apps Script - Exercise Coding Projects - How to Use App Script for Creating Files on Drive and Tracking Data in Sheets
This video explains how to use Apps Script for creating files on drive and tracking data in sheets. This clip is from the chapter "How to Do Amazing Things with Google Apps Script - Power Up Your Apps Script Code" of the series "Google...
Curated Video
Google Apps Script - Exercise Coding Projects - Introduction to Google Apps Script Power Up Your Apps Script Code
This video explains how to power up your Apps Script code. This clip is from the chapter "How to Do Amazing Things with Google Apps Script - Power Up Your Apps Script Code" of the series "Google Apps Script - Exercise Coding...
Curated Video
Google Apps Script - Exercise Coding Projects - Google Workspace Services Creating a Bound Script that Powers Up Your Workspace
This video explains creating a bound script that powers up your Workspace. This clip is from the chapter "Getting Started with an Introduction to Google Apps Script" of the series "Google Apps Script - Exercise Coding Projects".This...
Curated Video
Google Apps Script - Exercise Coding Projects - Apps Script Introduction
This video introduces you to Apps Script. This clip is from the chapter "Apps Script Fetch and API Connections" of the series "Google Apps Script - Exercise Coding Projects".This section explains Apps Script Fetch and API connections.
Curated Video
Google Apps Script - Exercise Coding Projects - Explore Google Apps Script - Connect the Power of Google Services Together
This video explains the power of Google Services. This clip is from the chapter "Getting Started with Apps Script Projects" of the series "Google Apps Script - Exercise Coding Projects".This section explains Apps Script projects.
Curated Video
Google Apps Script - Exercise Coding Projects - How to Fetch Request a Web URL and Return the Response Data Apps Script UrlFetch
This video explains how to fetch request a web URL and return the response data Apps Script UrlFetch. This clip is from the chapter "Apps Script Fetch and API Connections" of the series "Google Apps Script - Exercise Coding...
Curated Video
Google Sheets Fundamentals - Formatting Text
Text Formatting • Bold, Italic, Underline, Strikethrough • Font/Font Size • Text Alignment • Color
Curated Video
Excel VBA Programming The Complete Guide - The Range.Rows and Range.Columns Properties
In this lesson, we explore the Rows and Columns properties, which are available on both the top-level Application object and a specific Range. The two can be used to target complete rows or columns, within the spreadsheet or within a...
Curated Video
Excel VBA Programming The Complete Guide - Initialize Arrays within a For Loop
Arrays can easily be populated with values from the worksheet using a basic For loop. In this lesson, we perform a popular string cleaning operation --- trimming the leading and trailing whitespace of a string -- on a column of values...
Curated Video
Using COUNTIF Function and Absolute Cell References in Excel
The video explains how to efficiently count the occurrences of specific numbers in a spreadsheet using Excel's COUNTIF function and absolute cell references. By setting up a simple table and formula, you can easily track the frequency of...
Curated Video
Custom Autocorrect Entries in Google Docs
In this video tutorial, Justin demonstrates how to create custom autocorrect entries in Google Docs to save time and increase efficiency while typing. By setting up personalized shortcuts for frequently used words or phrases, users can...
Curated Video
Google Apps Script - Exercise Coding Projects - Selecting Spreadsheet Data with Apps Script
This video explains how to select spreadsheet data with Apps Script. This clip is from the chapter "Getting Started with Apps Script Projects" of the series "Google Apps Script - Exercise Coding Projects".This section explains Apps...
Curated Video
Google Sheets Fundamentals - Emailing Your Work
Emaling Your Work • Emailing the File • Emailing Collaborators
Curated Video
Efficiently Deleting Blank Rows in Excel
If you have multiple blank rows in a spreadsheet it can be very time-consuming to try to delete them either individually, or selecting them and then deleting them. In this quick tutorial I'll show you a very easy way to delete every...
Curated Video
Robotic Process Automation - UiPath RPA Developer Masterclass - Robot #5 Solution Walkthrough
This video demonstrates the solution walkthrough for the preceding case study. This clip is from the chapter "Robot #5 – Form Field Mania (Medium)" of the series "Robotic Process Automation - UiPath RPA Developer Masterclass".This...
Curated Video
Google Sheets Fundamentals - Exporting Your Work
Exporting to a New Format • Excel/ ODF • PDF • HTML for Web Display • CSV
Curated Video
Google Sheets Fundamentals - Sharing Your Work with Others
Sharing with Others • Publish to the Web • Publishing Settings • Sharing Your Work
Curated Video
Google Sheets Fundamentals - Formatting Numbers
Number Formating Options • Decimal Precision • Currency • Decimal/Percentage • Dates • Accounting and Financial Formatting