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...

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....

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...

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...

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...

In this fast-paced tutorial I'll show you how to create visually engaging people graphs in Microsoft 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...

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.

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...

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...

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.

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...

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.

Wilcoxon Rank Sum Test: Theory and Tutorial in 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...

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,...

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...

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...

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...

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...

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...

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...

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...

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...