Tutorials

How to Alphabetize Multiple Columns in Excel with TOCOL, TOROW, SORT, and SORTBY

If you’ve combined data from several columns or rows and you need it in one clean alphabetical list, this walkthrough is for you. We’re...

Excel Checkboxes Made Easy: Automatically Move Rows Between Worksheets

Adding checkboxes in Microsoft Excel opens up new ways to organize data and automate your workflow. With a few simple steps, you can use...

EXCEL TIMESHEET with Calculations for Lunch Breaks – EASY

Are you struggling with time tracking? Do you need an easy way to calculate employee hours, especially those tricky lunch breaks? This guide will...

Import Website Data into Excel: Easily Format with Power Query

Tired of copy-pasting website data into Excel? We’ve all been there, scrubbing through pages and manually entering information, only to realize it takes forever....

Percent of Total in Excel – 3 SIMPLE METHODS (PLUS PIVOT TABLES)

Ever wondered how much each piece of your data contributes to the whole? Calculating a percent of total is a quick way to figure...

How to Use Focus Cell in Microsoft Excel

If you've ever lost track of your active cell in Excel while working with massive spreadsheets, you're definitely not alone. Microsoft just rolled out...

How to Create a Dynamic Data Entry Form in Excel

Data entry in Excel can be tedious, especially when you're manually entering rows of information. Fortunately, there's a way to streamline that process, creating...

How to Join or Split Data in Microsoft Excel

If you've ever struggled with joining or combining data into a single cell or splitting it across multiple cells in Microsoft Excel, you're in...

How to Find Unknown Goal Data in Excel with Goal Seek

Have you ever needed to figure out the missing numbers in a spreadsheet? Whether you’re trying to hit a sales target, balance student grades,...