Autocrat is a ROBOT that does your work for you. You heard me right. It's like Rosie from the Jetsons. If you don't take a few minutes to learn this, you're literally working HARDER not SMARTER, so come on y'all, who wants to do this?...

Microsoft Excel doesn't provide any option to create a bullet list or format cells to appear as a bullet list, but there is a way to do it. In this video, I show you how to format cells so that you can create a bullet list with items in...

This video explains what a database table is.<br/<br/>>

This clip is from the chapter "Manipulating Tables and Data" of the series "Microsoft SQL Server Development for Everyone".This section explains how to manipulate tables and data.

In this fast-paced tutorial I'll show you how to create visually engaging people graphs in Microsoft Excel.

In this Microsoft Excel tutorial, you will learn how to collect data using Google Forms. The tutorial provides step-by-step instructions on creating a Google form, sending it to participants, and automatically collecting the responses in...

In this eighth episode of Do More with R, learn how to animate data over time with R and the gganimate and ggplot2 packages. Leave a comment and let us know what tips you’d like to see in a future Do More With R video.

In this tutorial, you will learn to use the latest version of Autocrat (as of December 2016) to create certificates (or anything else you'd like). Autocrat is really like having a robot do your work, so trust me on this, it's VERY much...

This video tutorial demonstrates two effective methods for removing unwanted spaces in Microsoft Excel data. The first method involves using the find and replace tool (Ctrl+H) to quickly eliminate extra spaces, while the second method...

Normally, when you print a sheet from Microsoft Excel, the gridlines are hidden. In this tutorial, I show you how easy it is to not only have the gridlines printed, but also the row and column headers if you want.

In this tutorial, Justin demonstrates how to easily format dates in Microsoft Excel using custom date formats. He shows how to display dates in various ways, such as showing only the day, month, year, or full date as a sentence. By using...

In This Episode, Tyler Teaches Us About How to Respond in Google Forms

Daily reports will often have a fluctuating number of rows. In this lesson, we introduce a convenient strategy to identify the last row of data in a sheet --- starting at the bottom of the spreadsheet and navigating upwards.
r/> ...

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

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

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

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

This video aims to explain Print Titles.
r/>
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...

This video introduces you to Google Workspace services such as Docs, Calendar, Drive, Forms, Gmail, and Sheets.
<
br/>
This clip is from the chapter "Google Workspace Services: Docs, Calendar, Drive, Forms, Gmail, and Sheets Slides"...

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.
r/>
This clip is from the chapter "Range...

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.
r/>
This clip is from the chapter "Iteration" of the...

This video introduces you to the graphical editors.
r/>
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...

This video explains how to add conditional rules format with Google Apps Script code.
<
br/>
This clip is from the chapter "Google Workspace Services: Docs, Calendar, Drive, Forms, Gmail, and Sheets Slides" of the series "Google...

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.
r/>
This clip is from the chapter "Range...

Learn how to create basic formulas.
r/>
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...