Curated Video
Repeat Top Row Headings When Printing Excel Spreadsheet
In this Excel tutorial, Justin demonstrates how to lock the top row of a spreadsheet for printing, ensuring that important headings remain visible on every printed page. By utilizing the "Print Titles" feature in the page layout tab,...
Curated Video
Excel VBA Programming The Complete Guide - R1C1 Notation, Part I
R1C1 notation is a different way of thinking about cells in Excel. Instead of using a letter for the column and a row for the number, R1C1 relies on numbers for both. In this lesson, we enable R1C1 notation in our Excel interface and...
Curated Video
Correctly
In this video, the speaker addresses a common issue where dates in Excel are not sorting correctly by year. By demonstrating a step-by-step solution, viewers learn how to ensure Excel recognizes the dates as dates, thus enabling proper...
Curated Video
Calculate the Difference Between Two Dates in Excel
This video tutorial demonstrates how to calculate someone's age from their date of birth in Microsoft Excel using the Date DIF formula and the NOW function. By inputting the individual's date of birth and the current date, the formula...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Print Titles
This video aims to explain Print Titles. This clip is from the chapter "Excel 2019 Beginner: Page Setup and Print Options" of the series "The Complete Excel Guide: Beginners to Advanced".This section aims to explore page setup and print...
Curated Video
Google Apps Script - Exercise Coding Projects - Introduction to Google Workspace Services: Docs, Calendar, Drive, Forms, Gmail, and Sheets
This video introduces you to Google Workspace services such as Docs, Calendar, Drive, Forms, Gmail, and Sheets. This clip is from the chapter "Google Workspace Services: Docs, Calendar, Drive, Forms, Gmail, and Sheets Slides" of the...
Curated Video
Excel VBA Programming The Complete Guide - The Range.End Property
In this lesson, we write values to the four corners of the spreadsheet using the Range.End property and discuss the predefined constants (enumerations) passed in as arguments. This clip is from the chapter "Range References" of the...
Curated Video
Excel VBA Programming The Complete Guide - Exit For and Review of Exit Sub
The Exit For keywords prematurely terminate a For loop. The Exit Sub keywords prematurely terminate a procedure. In this lesson, we practice implementing these concepts. This clip is from the chapter "Iteration" of the series "Excel VBA...
Curated Video
Linux Administration Bootcamp: Go from Beginner to Advanced - Graphical Editors
This video introduces you to the graphical editors. This clip is from the chapter "Linux Fundamentals" of the series "Linux Administration Bootcamp: Go from Beginner to Advanced".This section provides an introduction to the fundamentals...
Curated Video
Google Apps Script - Exercise Coding Projects - How to Add Conditional Rules Format with Google Apps Script Code
This video explains how to add conditional rules format with Google Apps Script code. This clip is from the chapter "Google Workspace Services: Docs, Calendar, Drive, Forms, Gmail, and Sheets Slides" of the series "Google Apps Script -...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Count and Range.CountLarge Properties
In this lesson, we use the Range.Count and Range.CountLarge properties to find out the number of cells in a given range. The returned value counts all cells, not just those with values. This clip is from the chapter "Range References" of...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Creating Basic Formulas
Learn how to create basic formulas. This clip is from the chapter "Excel 2019 Beginner: Creating Workbooks" of the series "The Complete Excel Guide: Beginners to Advanced".This section aims to teach you how to create a workbook in Excel.
Curated Video
Naming Cells In Microsoft Excel
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...
Curated Video
How to Hide and Unhide Columns in a Spreadsheet
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...
Curated Video
Organizing Large Spreadsheets with Checkboxes
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...
Curated Video
Rounding Numbers to a Set Decimal Place in Excel
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...
Curated Video
Google Apps Script - Exercise Coding Projects - Google Apps Script Automation with Triggers
This video explains Google Apps Script automation with triggers. 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
Sorting Dates Chronologically in Microsoft Excel
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,...
Curated Video
Google Apps Script - Exercise Coding Projects - Introduction to Creating a Web App URL for Webform Submission
This video introduces you to creating a web app URL for webform submission. This clip is from the chapter "JavaScript and Google Apps Script Web App" of the series "Google Apps Script - Exercise Coding Projects".This section explains...
Curated Video
Google Apps Script - Exercise Coding Projects - Introduction to Google Apps Script
This video introduces you to the Google Apps Script. 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 introduces you to...
Curated Video
Excel VBA Programming The Complete Guide - The Application.ScreenUpdating Property
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 this...
Curated Video
How To Use the SUMIF Function In Microsoft Excel
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,...
Curated Video
Excel Tips: How to Restore Missing Elements in Your Spreadsheet
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,...
Curated Video
How to Calculate Weighted Averages in Excel
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...