Let's Tute
Customizing Quick Access Toolbar in Excel
This video tutorial teaches how to customize the Quick Access Toolbar in Excel by adding shortcuts for frequently used functions, removing unwanted options, and rearranging the sequence of shortcuts. This customization helps to save time...
Let's Tute
VBA Editor Overview: Tools and Commands
In this video, the teacher provides an overview of the VBA editor tool in Microsoft Excel. They explain the different tools and commands available, such as modules, project windows, and macros. The teacher also demonstrates how to...
Curated Video
Excel: How to Use the Flash Fill Tool for Data Separation
In this tutorial, the speaker demonstrates how to efficiently use the Flash Fill tool in Microsoft Excel to quickly separate data that has been combined in a single cell. By simply typing out the desired format in separate columns and...
Curated Video
Introduction to Array Formulas in Microsoft Excel
This video introduces the concept of array formulas in Microsoft Excel, demonstrating how they can efficiently perform multiple calculations simultaneously on groups of cells. By using array formulas, complex tasks such as counting the...
Curated Video
Naming Cells In Microsoft Excel
In this video tutorial I show you how simple and easy it is to name a cell in a Microsoft Excel spreadsheet, and then refer to that cell by its name elsewhere in the spreadsheet. Referring to cells using descriptions and names makes much...
Curated Video
Organizing Large Spreadsheets with Checkboxes
In this tutorial, Justin demonstrates how to tidy up a large spreadsheet in Microsoft Excel using checkboxes. By hiding or compressing sections with checkboxes, users can easily navigate through the spreadsheet and focus on specific...
Curated Video
Excel: How to Separate First Names and Surnames Using Text to Columns
Learn how to efficiently separate first names and surnames from a list of names in Excel using the Text to Columns feature. By following simple steps, you can split the data into separate columns, eliminating numbers and organizing the...
Curated Video
Rounding Numbers to a Set Decimal Place in Excel
In this video tutorial, learn how to round numbers in a spreadsheet to a set number of decimal places using the ROUND function. The instructor demonstrates how to easily round numbers to two decimal places and ensure consistency across...
Curated Video
Sorting Dates Chronologically in Microsoft Excel
In this tutorial, the teacher demonstrates how to sort a table of people's names and dates of birth chronologically in Microsoft Excel. The instructor explains the process of formatting the date cells, selecting the column to be sorted,...
Curated Video
How To Use the SUMIF Function In Microsoft Excel
In this tutorial, Justin demonstrates how to effectively use the SUMIF function in Microsoft Excel to analyze data sets and calculate specific criteria. He provides three practical examples, including calculating profits and losses,...
Curated Video
Excel Tips: How to Restore Missing Elements in Your Spreadsheet
In this video tutorial, the instructor demonstrates how to bring back essential elements in Excel that may have disappeared, such as the grid lines, formula bar, and ribbon. By accessing the view menu and utilizing simple checkboxes,...
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...
Curated Video
Full Stack Web Development MASTERY Course - Novice to Expert - Basic Fundamentals of MongoDB
This video explains the basic fundamentals of MongoDB. This clip is from the chapter "MongoDB + Mongoose (Zero to Hero)" of the series "Full Stack Web Development Mastery Course - Novice to Expert".This section focuses on MongoDB and...
Curated Video
Creating Dropdown Lists in Excel
This video tutorial demonstrates how to create a dropdown list in a spreadsheet to easily select predefined options, such as student effort levels like excellent, good, fair, poor, and unacceptable. By setting up a list of options and...
Global Health with Greg Martin
How to create an epidemic curve
Epidemic curves are an important component of the public health and global health toolbox. During an outbreak of an infectious disease, public health professionals and epidemiologists create visual representations of the onset of illness...
Curated Video
Creating an Interactive Quiz in Microsoft Excel
In this video tutorial, I will teach you how to create an interactive quiz using data validation and conditional formatting in Microsoft Excel. You will learn how to set up questions, create answer options with dropdown lists, score the...
Catalyst University
Mann-Whitney U Test: Theory and Tutorial in Excel
Mann-Whitney U Test: Theory and Tutorial in Excel
Tarver Academy
GOOGLE SHEETS INTRODUCTION
In This Episode, Tyler Teaches Us About GOOGLE SHEETS INTRODUCTION
Khan Academy
Fitting a Line to Data, Regression, Probability and Statistics
Sal trades his tablet for an Excel spreadsheet in this video, which covers fitting data to a line. Using a word problem about median income, he not only solves the problem but also demonstrates how to use scatter plots and Excel tools in...
GCFGlobal.org
Office: Working with Icons
Discover a great way to add graphics to a digital project by using Microsoft Office's Icons feature. Using a helpful lesson viewers discover a library of professional graphics at their disposal. They learn how to scroll through a wide...
GCFGlobal.org
Excel 2016: Creating More Complex Formulas
Please Excuse My Dear Aunt Sally! The 13th of 27 instructional videos from the Microsoft Excel 2016 set covers the order of operations. First, scholars review how to use the order of operations to solve math equations. Next, they see how...
GCFGlobal.org
Excel 2016: What-if Analysis
When someone wants to know what grade he or she needs on the final exam to pass the class, Excel's What-If Analysis feature helps figure it out. With the 27th and final installment from the Microsoft Excel 2016 video series, scholars...
GCFGlobal.org
Excel 2016: Doing More with PivotTables
How does pivoting add excitement? Learners discover how to make even the most mundane data more exciting with the 26th video from the 27-part Microsoft Excel 2016 series. In addition, they learn how to add filters and slicers to their...
GCFGlobal.org
Excel 2016: Intro to PivotTables
Sometimes too much information can be overwhelming. PivotTables to the rescue! Show scholars how to use PivotTables to summarize and manipulate content with a short, engaging video. Learners also discover how to use the feature to...