Let's Tute
Building a Basic Dashboard with Countifs and Sumifs in Microsoft Excel
In this Microsoft Excel tutorial, you will learn how to build a basic dashboard using Countifs and sumifs with multiple conditions. The tutorial covers data validation, selecting criteria ranges, and freezing cells to update data and...
Let's Tute
Microsoft Excel Tutorial: Understanding Mixed Reference
This is a tutorial on mixed reference in Microsoft Excel, which is a combination of absolute and relative references. The video explains how to lock specific rows or columns in a formula using the F4 key and provides examples of...
Let's Tute
Absolute Reference
In this video we will learn what is Absolute Reference and two types that is Cell Locked and Range Locked
Curated Video
Complete Modern C++ - Primitive Types and Variables
This video introduces primitive types in C++. • Std::visit versus match • Overload set • Match implementation This clip is from the chapter "Basic Language Facilities" of the series "Complete Modern C++".In this section, we will see...
Curated Video
C++ Standard Template Library in Practice - Replacing and Transforming - equals
The listener is new to algorithms and does not know about the transform algorithms. • Introduce the listener to the std::transform algorithm • Show how it works and explain the different versions available • Reinforce the lesson with a...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Font Property
The Range.Font property reveals a Font object complete with its own properties and methods. In this lesson, we explore several ways we can modify a font with VBA -- its name, its size, its bolding, and more! This clip is from the chapter...
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...
Brian McLogan
How to evaluate for the composition of two trigonometric functions
👉 Learn how to evaluate an expression with the composition of a function and a function inverse. Just like every other mathematical operation, when given a composition of a trigonometric function and an inverse trigonometric function,...
Brian McLogan
Learning How to Graph and Find the Change in Period of Tangent
👉 Learn how to graph a tangent function. To graph a tangent function, we first determine the period (the distance/time for a complete oscillation), the phase shift (the horizontal shift from the parent function), the vertical shift (the...
Brian McLogan
Evaluating Inverse Trigonometric Functions
👉 Learn how to evaluate the inverse of reciprocal trigonometric functions. Recall that the reciprocal trigonometric functions are given by the ratio of 1 and the corresponding trigonometric function. When an angle is unknown but the...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Mouse Features
Let's explore the mouse features available in Excel. This clip is from the chapter "Excel 2019: Introduction" of the series "The Complete Excel Guide: Beginners to Advanced".The upcoming 21 sections for Microsoft Excel 2019 are perfect...
Brian McLogan
What are the domain and range of our most basic parent functions
Learn how to determine the domain and range of a function given the graph of the function. Since the domain of a function is the set of all x-values we will want to identify how far left the graph goes as well as how far right to...
Brian McLogan
How to find the inverse of a rational function
👉 Learn how to find the inverse of a linear function. A linear function is a function whose highest exponent in the variable(s) is 1. The inverse of a function is a function that reverses the "effect" of the original function. One...
Brian McLogan
How do we know when we have a vertical shift for a exponential function
👉 Learn all about graphing exponential functions. An exponential function is a function whose value increases rapidly. To graph an exponential function, it is usually useful to first graph the parent function (without transformations)....
Curated Video
Box and Whisker Plots: Understanding and Creating Them
In this video, students will learn about box and whisker plots, a visual way to display data distribution using five values: minimum, maximum, median, lower quartile, and upper quartile. The video explains how to interpret and create box...
Science360
NSF Science Now: Episode 22
In this week's episode we discover hidden dangers in crib mattresses. We learn about a new stretchable antenna for wearable health monitoring devices. We study the dynamics of deep Earth and finally we explore Antarctic ice sheets from...
Curated Video
Learning CSS (Video 3)
As a modern day web designer, it is very critical for you to prepare for the CSS3 world we live in. A major challenge that designers face in their day-to-day life is making their designs stand out from the rest and ensuring they work on...
IDG TECHtalk
How to use string type | Smart Go
Learn about the details of the string type in Go -- how data are stored in them, how they can be represented as bytes or characters, and how the "rune" type in Go is used with strings.
Curated Video
CISSP®- Laws and Regulations
This video focuses on the laws and regulations. This clip is from the chapter "Certified Information Systems Security Professional CISSP Domain 1 - Security and Risk Management" of the series "CISSP® Certification Domain 1: Security and...
Curated Video
C++ Standard Template Library in Practice - Swapping
The listener is new to algorithms and does not know about the swapping algorithms. • Introduce the listener to the std::swap algorithm • Show how it works and explain the different versions available • Reinforce the lesson with a code...
Brian McLogan
Evaluating Inverse Trigonometric Functions
👉 Learn how to evaluate the inverse of reciprocal trigonometric functions. Recall that the reciprocal trigonometric functions are given by the ratio of 1 and the corresponding trigonometric function. When an angle is unknown but the...
Brian McLogan
Evaluating Inverse Trigonometric Functions
👉 Learn how to evaluate the inverse of reciprocal trigonometric functions. Recall that the reciprocal trigonometric functions are given by the ratio of 1 and the corresponding trigonometric function. When an angle is unknown but the...
Brian McLogan
Completing the square to identify the max,min, vertex and axis of symmetry
We will learn how to graph a quadratic in vertex form and graph a quadratic in standard form by completing the square and rewriting the equation in vertex form. When the quadratic is in vertex form we learn how to identify the axis of...
Brian McLogan
How to graph an exponential function using a table
👉 Learn how to graph exponential functions. An exponential function is a function that increases rapidly as the value of x increases. To graph an exponential function, it is usually very useful to make the table of values of the...