Brian McLogan
Remember your Formulas
If you have a test or quiz coming up and are worried you will not remember all of your formulas then use this video to help you remember exactly what you need to know:
Brian McLogan
The Best Distance, Endpoint Midpoint Between Two Points
In this video we are going to cover the how to find the distance, midtpoint given two points as well as the endpoint when given one midpoint and endpoint.
Curated Video
Finding the Area of Irregular Shapes
Mr. Addit demonstrates the use of the grid strategy for finding the area of irregular shapes.
Curated Video
EXCEL DATA: VLOOKUP and HLOOKUP
Learn the art of VLOOKUP and HLOOKUP, the essential tools for data navigation.
Curated Video
EXCEL DATA: SUMIF and COUNTIF
Join Mark to dive into SUMIF and COUNTIF, calculating with conditions like a wizard.
Curated Video
Area, Right Triangle: T-Chart
Find the Area of a Right Triangle Using a T-Chart finds the area of a right triangle by using a T chart to describe both the mathematical operations and the written explanations.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Extract Data from the Middle of a String
In this video, you will learn how to extract data from the middle of a string.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Finding the st Value
In this video, you will learn how to find the closest value.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Finding the Last Occurrence of a Value
In this video, you will learn how to find the last occurrence of a value.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Adding Confidence Levels
In this video, you will learn how to add confidence levels.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Creating a Sales Forecast with Seasonality
In this video, you will learn how to create a sales forecast with seasonality.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 08 - create a formula
In this video, we will focus on Exercise 08 of this section, where we will create a formula to return ‘Month’ and ‘Sales’ from the table based on the selection in the form control.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Scroll Bar - Scroll Through a List
In this video, you will learn how to use the scroll bar.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - List Box - Select from a List of Items
In this video, you will learn how to use the list box.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Spin Button - Move Up and Down a List
In this video, you will learn how to use the spin button.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Option Button - Choose an Option
In this video, you will learn how to use the option button.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Check Box - Check/Uncheck Option
In this video, you will learn how to use check box.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using GETPIVOTDATA - Dependent Data Validation Lists
In this video, you will learn how to use GETPIVOTDATA - dependent data validation lists.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - GETPIVOTDATA
In this video, we will cover GETPIVOTDATA.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Solve Order
In this video, we will cover solve order.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Creating a Calculated Field
In this video, you will learn how to create a calculated field.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 06 - work with the LET function
In this video, we will focus on Exercise 06 of this section, where we will work with the LET function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - The LAMBDA Function
In this video, we will cover the LAMBDA function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - The LET Function
In this video, we will cover the LET function.