Curated Video
The Complete Excel Guide: Beginners to Advanced - Using Names in Formulas
The aim of this video is to explore how to use names in formulas. This clip is from the chapter "Excel 2019 Beginners: Working with Names" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll learn how...
Brian McLogan
Pre-Calculus - Evaluating the Double Angle for Cosine Using a Triangle
👉 Learn how to evaluate the double angle of sine. The value of the sine of double a given angle can be obtained given the value of the sine of the angle. The value of the sine of double a given angle is obtained using the formula sin(2u)...
Curated Video
Excel VBA Programming The Complete Guide - R1C1 Notation, Part II
In this lesson, we continue to expand on the R1C1 concepts introduced in the past lesson by applying them to several real-life examples. This clip is from the chapter "Range References" of the series "Excel VBA Programming–The Complete...
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
The Complete Excel Guide: Beginners to Advanced - Absolute Values
Let's understand what are absolute values. This clip is from the chapter "Excel 2019 Beginners: Formulas and Functions" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll explore formulas and functions.
Curated Video
The Complete Excel Guide: Beginners to Advanced - Working with Links
The aim of this video is to explore how to work with links. This clip is from the chapter "Excel 2019 Beginners: Linking Files" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, you'll learn how to link files.
Brian McLogan
How to evaluate the half angle of sine
👉 Learn how to evaluate the Sine of an angle using the half-angle formula. The half-angle formula for Sine is helpful when you need to determine the exact value of function given an angle but cannot use a calculator or the angle is not...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Relative References
Learn about the relative references. 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
The Complete Excel Guide: Beginners to Advanced - Managing Names
The aim of this video is to explore how to manage names. This clip is from the chapter "Excel 2019 Beginners: Working with Names" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll learn how to work...
Curated Video
The Complete Excel Guide: Beginners to Advanced - PivotTables
The aim of this video is to explore PivotTables. This clip is from the chapter "Excel 2019 Beginners: PivotTables" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we’ll understand and explore PivotTables.
Math Fortress
Algebra I: Translating Sentences into Equations (Level 2 of 2)
This video goes over 9 examples, covering the proper way to translate sentences into equations that require the use of formulas.
Virtually Passed
Radius of Gyration summary
The radius of Gyration is a fast and simple way to calculate the moment of inertia of complex shapes. The radius of gyration is usually provided in most Engineering catalogs
Curated Video
The Complete Excel Guide: Beginners to Advanced - Creating Formulas Between Files
The aim of this video is to explore how to create formulas between files. This clip is from the chapter "Excel 2019 Beginners: Linking Files" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, you'll learn...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Module 8 - Practice Exercise
Let's do a practice exercise. This clip is from the chapter "Excel 2019 Beginners: Formulas and Functions" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll explore formulas and functions.
Curated Video
The Complete Excel Guide: Beginners to Advanced - Working with Ranges
Learn how to work with ranges. 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
The Complete Excel Guide: Beginners to Advanced - Formula Auditing
The aim of this video is to explore formula auditing. This clip is from the chapter "Excel 2019 Beginners: Advanced Formula Creation" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll explore and...
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...
Brian McLogan
Master Solving a trigonometric equation using the sum and difference formulas
Master Solving a trigonometric equation using the sum and difference formulas
Brian McLogan
Sum and Difference Formulas | Full Lesson
In this video we will work through what the sum and difference formulas are, and how to apply them to help use evalutate trigonometric expressions, verify trigonometric identities and solve trigonometric equations.
Curated Video
Quickly Displaying and Hiding Formulas in Excel Spreadsheets
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...
Curated Video
Generate Random Data in Google Sheets
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...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Create Formulas Using Functions: Part 2
Let's continue to learn how to create formulas using functions. This clip is from the chapter "Excel 2019 Beginners: Formulas and Functions" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll explore...
Curated Video
Circles and Circumference
This video lesson will review key vocabulary terms about circles and finding circumference of circles and semicircles. Students will learn how to describe a circle in terms of radius and diameter, understand the concept of pi, and find...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Create Formulas Using Functions: Part 1
Learn how to create formulas using functions. This clip is from the chapter "Excel 2019 Beginners: Formulas and Functions" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll explore formulas and...