Catalyst University
NO BS: Construct a Box-and-Whisker Plot in Excel
NO BS: Construct a Box-and-Whisker Plot in Excel
Curated Video
How to Format Numbers in Excel with Color-Coding and Arrows
This tutorial demonstrates how to format numbers in Microsoft Excel without using conditional formatting. It shows how to display positive numbers in black with an up arrow and negative numbers in red with a down arrow. By utilizing the...
Curated Video
Changing Text Case in Microsoft Excel
In this tutorial, the speaker demonstrates how to easily change text from uppercase to lowercase, title case, or sentence case in Microsoft Excel using simple formulas. By following the step-by-step instructions, users can efficiently...
Tarver Academy
How to Convert Google Sheets to Excel or PDF
In This Episode, Tyler Teaches Us About How to Convert Google Sheets to Excel or PDF
Curated Video
How to Use Percentages in Microsoft Excel
Many people seem to struggle with formatting percentages in Microsoft Excel, with 100% seemingly equivalent to 1000% or more! In this tutorial I'll explain what's really going on, how to use the percentage tool correctly, demonstrate why...
Curated Video
How to Insert a Diagonal Line in a Cell in Microsoft Excel
In this quick tutorial I'll show you how to add a diagonal line or border to a cell in Microsoft Excel and how to format that line by changing width and color.
Curated Video
How to Create Bullet Lists in Microsoft Excel
Microsoft Excel doesn't provide any option to create a bullet list or format cells to appear as a bullet list, but there is a way to do it. In this video, I show you how to format cells so that you can create a bullet list with items in...
Let's Tute
Introduction to Invoking Macros and Using VBA for Font and Alignment in Microsoft Excel
In this video, the teacher explains how to use macros in Microsoft Excel to customize font styles, alignments, and sizes. They demonstrate step-by-step coding and debugging processes to ensure the desired changes are applied correctly....
Curated Video
Creating a Live Currency Converter in Excel
In this tutorial, Justin demonstrates how to create a live currency converter in Microsoft Excel by importing real-time currency conversion data from a website. By following his step-by-step guide, you can set up your own converter to...
Global Health with Greg Martin
Finding and Using Data in Global Health
This is the first in a series of videos on how to find and use data in global health. In this video Dr Greg Martin shows you how to download data on HIV, TB and ART and how to use the vLookup function in Excel to extract the data that...
Curated Video
Creating a Painting by Numbers Tool in Microsoft Excel
In this video tutorial, learn how to create a painting by numbers tool in Microsoft Excel using conditional formatting. By assigning colors to specific numbers and applying conditional formatting rules, you can transform a grid of...
Curated Video
Creating a People Graph in Microsoft Excel
In this fast-paced tutorial I'll show you how to create visually engaging people graphs in Microsoft Excel.
Curated Video
How to Add Text and Formulas in a Single Cell in Excel
This tutorial demonstrates how to combine text and formulas within a single cell in a spreadsheet using the "&" symbol. By following simple steps, users can create cells that display both text and calculations, allowing for dynamic and...
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.
Curated Video
Removing Unwanted Spaces in Excel
This video tutorial demonstrates two effective methods for removing unwanted spaces in Microsoft Excel data. The first method involves using the find and replace tool (Ctrl+H) to quickly eliminate extra spaces, while the second method...
Curated Video
Excel: How to Freeze Headings and Navigate Data Efficiently
In this tutorial, you will learn how to freeze headings or rows and columns in a table to keep them visible while scrolling through data. You can easily freeze the top row or the first column using the "freeze panes" option in the view...
Curated Video
How to Insert Multiple Columns or Rows in Microsoft Excel
You may well already know that you can insert a single new row or column in Microsoft Excel by right-clicking the row or column header and choosing 'Insert'. But what if you need to insert several new rows or columns at once? In this...
Curated Video
How to Print The Gridlines in Microsoft Excel
Normally, when you print a sheet from Microsoft Excel, the gridlines are hidden. In this tutorial, I show you how easy it is to not only have the gridlines printed, but also the row and column headers if you want.
Curated Video
Five Ways to Fix #VALUE Errors in Microsoft Excel
In this tutorial I'll show you five different reasons why you may get #VALUE! error messages in Microsoft Excel and how to fix each of them properly.
Catalyst University
Wilcoxon Rank Sum Test: Theory and Tutorial in Excel
Wilcoxon Rank Sum Test: Theory and Tutorial in Excel
Curated Video
Utilizing Sparklines in Microsoft Excel
This video demonstrates how to use spark lines in Microsoft Excel to visually represent data trends efficiently. Spark lines are miniature graphs embedded within cells, providing a quick and clear overview of patterns in student scores...
Curated Video
Repeat Top Row Headings When Printing Excel Spreadsheet
In this Excel tutorial, Justin demonstrates how to lock the top row of a spreadsheet for printing, ensuring that important headings remain visible on every printed page. By utilizing the "Print Titles" feature in the page layout tab,...
Curated Video
Correctly
In this video, the speaker addresses a common issue where dates in Excel are not sorting correctly by year. By demonstrating a step-by-step solution, viewers learn how to ensure Excel recognizes the dates as dates, thus enabling proper...
Curated Video
Calculate the Difference Between Two Dates in Excel
This video tutorial demonstrates how to calculate someone's age from their date of birth in Microsoft Excel using the Date DIF formula and the NOW function. By inputting the individual's date of birth and the current date, the formula...