Let's Tute
Renaming and Deleting an Excel Worksheet
This tutorial teaches how to rename and delete Excel worksheets using different methods such as double-clicking on the sheet name, right-clicking and selecting options, or using the Format and Delete options on the Home tab.
Let's Tute
Introduction to Microsoft Excel User Interface
This video tutorial provides an overview of the Microsoft Excel user interface. It explains the different elements and features, such as the quick access toolbar, ribbon tabs, active cell number, column headings, row numbers, worksheet,...
Curated Video
Excel VBA Programming The Complete Guide - The Object Data Type
A variable supports more than just primitive data types like numbers and strings. It can also be assigned to any object in the Excel Object Model -- a Worksheet, a Workbook, etc. The design allows for code to be tighter and leaner. In...
ACDC Leadership
A quick message for teachers
I made a new video about graphing games that you can play with your students.
Let's Tute
Excel Function Shortcut Keys Tutorial
This is a tutorial on function shortcut keys used in Microsoft Excel, aimed at helping users save time and become more efficient. The video covers a range of shortcuts, from opening the Excel help task pane with F1 to using F12 for the...
Brian McLogan
Factor 68 quadratics when a is not 1 | Skills Practice Worksheet
In this video I work through 68 examples of factoring quadratic expressions when a is not equal to one. The first couple of examples I explain the process of factoring by using the AC method and box method. I then help students learn the...
Curated Video
Excel VBA Programming The Complete Guide - Get Last Row of Data in Worksheet
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. This clip is...
Kids’ Poems and Stories With Michael Rosen
Chapter 16 | You're Thinking About Tomatoes | STORY
Chapter 16 | You're Thinking About Tomatoes | STORY Another witty, zany story that leads the reader through an unorthodox view of British history and the colonial past. A sequel to the very popular ‘You're Thinking About Doughnuts’....
Curated Video
Excel VBA Programming The Complete Guide - The Parent Property on All Objects
Coming full circle, we navigate from a Range object all to the way to the top of the Excel object model (the Application object) by relying on each object's Parent property. The property returns the object enclosing the current one. This...
Curated Video
Excel VBA Programming The Complete Guide - Workbook Events and The Sh Argument
The Workbook event has its own set of event procedures. One common trend in their signatures is the presence of a Sh argument, which represents the sheet on which the event has been triggered. In this lesson, we construct a dynamic macro...
Curated Video
Excel VBA Programming The Complete Guide - Review of Application.EnableEvents
The Application.EnableEvents property is used to enable and disable Excel events (automatic actions that are triggered by user interactions). In this lesson, we discuss the benefits of temporarily disabling this feature in an event...
Curated Video
Excel VBA Programming The Complete Guide - The Visual Basic Editor
In this lesson, we explore the components of the Visual Basic Editor, including the Project Explorer, which lists all open workbooks and worksheets as well as all modules (containers for code). Properties Window, which can be used to get...
Kenhub
Cranial nerves quizzes and labeling exercises
Learn how to identify the 12 cranial nerves with fun labeling worksheets and quizzes.
Curated Video
Excel VBA Programming The Complete Guide - The Worksheet.Visible Property
The Worksheet.Visible property is used to hide and unhide a worksheet. It accepts either a Boolean argument (True or False) or an XlSheetVisibility enumeration. One cool VBA feature is the ability to use the xlSheetVeryHidden option to...
Curated Video
Excel VBA Programming The Complete Guide - Introduction to Events
An event is a regular Excel action --- opening a worksheet, entering a cell value -- that can automatically trigger a VBA procedure. In this lesson, we compare event procedures to regular procedures and setup our VBE environment for...
Let's Tute
Introduction to Pivot Charts and Pivot Tables in Microsoft Excel
In this Microsoft Excel tutorial, we will learn about pivot charts and pivot tables. We will explore the steps to prepare a pivot table, including selecting data, inserting the pivot table, and arranging the fields. We will also...
Curated Video
Excel VBA Programming The Complete Guide - The Workbooks.Count and Worksheets.Count Properties
The Workbooks.Count property returns the count of open workbooks. The Worksheets.Count property returns the count of worksheets in the selected workbook. In this lesson, we play around with these properties in the Immediate Window. This...
Curated Video
Excel VBA Programming The Complete Guide - The OnError Resume Next Keywords
Some errors are not catastrophic to the health of a procedure --- some, in fact, are completely ignorable. In this lesson, we utilize the On Error Resume Next keywords to tell an iteration macro to continue in spite of any errors...
Curated Video
Excel VBA Programming The Complete Guide - Iterating over a Range of Cells with For Each
The For Each construct can also be used to iterate over a range of cells. Each object iterated over will be a single cell, itself a Range object. In this lesson, we iterate over and modify the values in a single column. This clip is from...
Brian McLogan
Simplify 20 Basic Trigonometric Identities | Analytic Trigonometry | Skills Practice Worksheet
Simplify 20 Basic Trigonometric Identities | Analytic Trigonometry | Skills Practice Worksheet
Curated Video
Excel VBA Programming The Complete Guide - The Worksheet.Delete Method
The Worksheet.Delete method removes a worksheet. It is particularly effective to temporarily disable alerts before invoking this method to make the process as smooth and seamless for the user as possible. This clip is from the chapter...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Select Method
In this section of the course, we take a deep dive into the Range, the most popular object in the Excel Object Model. We begin with the Select method, which highlights the range's boundaries on the spreadsheet. This clip is from the...
Brian McLogan
How to find the reference angle | 16 Examples
How to find the reference angle | 16 Examples