In this video tutorial I show you how simple and easy it is to name a cell in a Microsoft Excel spreadsheet, and then refer to that cell by its name elsewhere in the spreadsheet. Referring to cells using descriptions and names makes much...

This video tutorial demonstrates how to hide and unhide columns in a spreadsheet efficiently. It explains the process of hiding columns to declutter the view without deleting important data, and then provides clear steps on how to easily...

In this video tutorial, learn how to round numbers in a spreadsheet to a set number of decimal places using the ROUND function. The instructor demonstrates how to easily round numbers to two decimal places and ensure consistency across...

In this tutorial, Justin demonstrates how to tidy up a large spreadsheet in Microsoft Excel using checkboxes. By hiding or compressing sections with checkboxes, users can easily navigate through the spreadsheet and focus on specific...

This video explains Google Apps Script automation with triggers.
<
br/>
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...

In this tutorial, the teacher demonstrates how to sort a table of people's names and dates of birth chronologically in Microsoft Excel. The instructor explains the process of formatting the date cells, selecting the column to be sorted,...

This video introduces you to creating a web app URL for webform submission.
<
br/>
This clip is from the chapter "JavaScript and Google Apps Script Web App" of the series "Google Apps Script - Exercise Coding Projects".This section...

This video introduces you to the Google Apps Script.
<
br/>
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 section...

The Application.ScreenUpdating property can be set to False to disable updates to the Excel interface. One way to optimize the speed of a macro is to turn the property off at the beginning of execution and reenable it at the end. In...

In this tutorial, Justin demonstrates how to effectively use the SUMIF function in Microsoft Excel to analyze data sets and calculate specific criteria. He provides three practical examples, including calculating profits and losses,...

In this video tutorial, the instructor demonstrates how to bring back essential elements in Excel that may have disappeared, such as the grid lines, formula bar, and ribbon. By accessing the view menu and utilizing simple checkboxes,...

In this video, I explain clearly how to calculate weighted averages in Microsoft Excel, such as when calculating students' grades where exams and coursework may be weighted differently. I show clearly step by step how such weighted...

This video explains what an app script is.
<
br/>
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...

Wrap and Rotation • Changing Column Width • Text Wrap Options • Text Rotation Options

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

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

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

This video introduces you to Apps Script.
<
br/>
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...

This video explains the power of Google Services.
<
br/>
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...

This video explains how to use Apps Script for creating files on drive and tracking data in sheets.
<
br/>
This clip is from the chapter "How to Do Amazing Things with Google Apps Script - Power Up Your Apps Script Code" of the...

This video explains how to power up your Apps Script code.
<
br/>
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...

This video explains creating a bound script that powers up your Workspace.
<
br/>
This clip is from the chapter "Getting Started with an Introduction to Google Apps Script" of the series "Google Apps Script - Exercise Coding...

This video explains how to fetch request a web URL and return the response data Apps Script UrlFetch.
<
br/>
This clip is from the chapter "Apps Script Fetch and API Connections" of the series "Google Apps Script - Exercise Coding...

Text Formatting • Bold, Italic, Underline, Strikethrough • Font/Font Size • Text Alignment • Color