Applying Builtin Themes in Google Sheets

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...

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...

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...

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...

This video explains how to select spreadsheet data with Apps Script.
<
br/>
This clip is from the chapter "Getting Started with Apps Script Projects" of the series "Google Apps Script - Exercise Coding Projects".This section...

Emaling Your Work • Emailing the File • Emailing Collaborators

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...

This video demonstrates the solution walkthrough for the preceding case study.
<
br/>
This clip is from the chapter "Robot #5 – Form Field Mania (Medium)" of the series "Robotic Process Automation - UiPath RPA Developer...

Exporting to a New Format • Excel/ ODF • PDF • HTML for Web Display • CSV

Sharing with Others • Publish to the Web • Publishing Settings • Sharing Your Work

Number Formating Options • Decimal Precision • Currency • Decimal/Percentage • Dates • Accounting and Financial Formatting

Doing the Math • Creating a formula to calculate the result • Using a function to calculate the result • Copying and pasting a formula • Selecting precision for the result

Hit the ground running and start working with Google Sheets Data-- • Setup • Move the active cell selector • Enter Data in to a cell • Working With Sheets

In this lesson, we wire up the final Command Button on our UserForm to capture the user's input and populate it on the spreadsheet.
r/>
This clip is from the chapter "User Forms" of the series "Excel VBA Programming–The...

This video tutorial demonstrates how to create a dropdown list in a spreadsheet to easily select predefined options, such as student effort levels like excellent, good, fair, poor, and unacceptable. By setting up a list of options and...

This video explains how to create a PDF email from sheet data and send the email using sheet data.
<
br/>
This clip is from the chapter "How to Do Amazing Things with Google Apps Script - Power Up Your Apps Script Code" of the...

Data Validation • Data List • Numerical Validation • Text Validation • Date Validation

Fitlering • Creating a Filter by Value • Creating a Filter by Condition

Sorting • Doing a Sort • Reverse Sorting • Sorting a Specific Range

This video discusses the pressures placed on businesses to increase the amount of digital technology involved in the production process. Specifically, enterprise resource planning (ERP) is explored as a central digital system that draws...

This video explains creating new docs and populating with sheet data.
<
br/>
This clip is from the chapter "Getting Started with Apps Script Projects" of the series "Google Apps Script - Exercise Coding Projects".This section...

In This Episode, Tyler Teaches Us About How to Copy and Paste a Chart to Docs from Google Sheets

This is how you include air resistance in projectile motion. It requires the Drag Force and Numerical Modeling (or the Euler Method). It is also very helpful to use a spreadsheet to do the calculations. I prove a statement from a...