Simple Software Tutorials

Learn what you need to know quickly and simply.

Excel Tutorials

Whether you’re just getting started with Excel or looking to streamline a specific task, these tutorials are designed to help you work more efficiently without unnecessary complexity.

Browse step-by-step tutorials covering formulas, functions, data cleanup, formatting, PivotTables, dropdown lists, lookups, printing, automation, and more. Each tutorial focuses on solving a practical problem with clear explanations, companion articles, and downloadable resources when available.

Use the search box or browse the topics below to find the tutorial you need.

Newest Tutorials

How to Use XLOOKUP for Multi Criteria Searches in Excel

Learn how to look up data based on criteria in multiple columns using XLOOKUP. For this example, I’m working with a spreadsheet of Portlandia TV series data and I want to add the title of the episode to the list of characters based on season and episode numbers which are stored on another sheet in…

How to Create a Searchable Drop-down List in Excel

Learn how to easily create a searchable drop-down list in Excel so users can enter a term in a search box that filters the results shown in the drop-down list. Choose to allow partial matches, or require exact or case-sensitive exact matches to suit your needs.

Excel Basics & Setup

These are tutorials that help users understand Excel basics, interface options, and foundational spreadsheet skills.

Formulas & Functions

These focus on formulas, functions, and using Excel to perform calculations or manipulate information.

Working with Data

Clean, organize, sort, and transform your data more efficiently.

Analysis & Reporting

These tutorials help users analyze information, highlight patterns, and create useful insights.

Printing & Sharing

These tutorials help users prepare spreadsheets for printing, exporting, and sharing with others.

Security & Workbook Management

These tutorials focus on protecting, controlling, and managing workbook content.

Real-World Projects

Learn Excel by solving practical business problems.

All Excel Tutorials

Microsoft

Two Ways to Divide Fractions in Excel

In this video, I show you two simple ways to divide fractions in Microsoft Excel. The problem is 7/8 divided by 5/4. In the first method, I simply type =(7/8)/(5/4) then press enter to get a solution of 0.7 or 7/10. In the second method, I format the cells I’m going to enter the data…

Microsoft Excel

How to Get Credit Card Numbers to Display Properly in Excel

You may have noticed that when entering more than 15 digits, Excel changes all digits past 15 to zeros. This prevents longer numbers like credit card numbers from displaying correctly, but there’s an easy fix: formatting the cell. Right click in the cell you want to enter the credit card number and select Format Cells.…

Microsoft Excel

How to Transpose Rows & Columns in Excel

Transposing Excel data from rows to columns or vice versa is simple using Excel’s transpose paste feature. Simply copy the data you want to transpose, click where you want to paste the data, then select the transpose option under paste. Don’t forget to subscribe to my channel for more tutorials! Thanks for tuning in!

Microsoft Excel

How to Optimize Printability Using Page Layout in Excel

Before sending a spreadsheet to someone, it’s a best practice to ensure the spreadsheet is optimized to print its best. This is easy to do using Excel’s Page Layout tab. First, you’ll want to look at the print preview to see how the data displays on the page. You may need to change the orientation…

Microsoft Excel

How to Generate Random Numbers in Excel Using the Rand Function

In this video, I show you two ways to generate random numbers in Excel, whether you want numbers between 0 and 1 or a range of your selecting. Please note these are volatile Excel functions, meaning they will automatically recalculate every time Excel recalculates, so you will see the numbers change as you manipulate data…