Excel Business Solutions

09/23/2026

This is special...…

This video shows Dr. Evan Matthews explaining how to copy values in...

08/18/2026

What if you need to complete the same action on multiple tabs in your spreadsheet. Can you avoid doing it several times? Yes! Easy!
https://support.microsoft.com/en-us/excel/group-worksheets

03/31/2026

Need a certain value as the result of one of your formulas? Forget the trial and error - use Goal Seek!

If you know the result you want from a formula, use Goal Seek in Excel to find the input value that produces this formula result.

03/03/2026

Need help getting Excel to do what you need? Just call Glenn at 205-887-4632. Consultations are free!

11/25/2025

Useful function of the day: CONCATENATE [or newer versions - CONCAT

In this short tutorial, I show how to combine data from two or more cells together using the CONCATENATE function.Stay up to date with FREE lessons by subscr...

11/12/2025

Ever used conditional formatting? It's fantastic!

How to use conditional formatting in Excel to visually explore, analyze, and identify patterns and trends.

09/23/2025

I wonder if you know just how easy it is to create your own drop-down lists in your excel spreadsheets? Super useful and easy to make. Here's how...

https://support.microsoft.com/en-us/office/create-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce407b

09/09/2025

Probably the biggest time-saver I have ever discovered for Excel use...

In this video, you’ll learn two ways to use the Format Painter in Excel. Visit https://www.gcflearnfree.org/excel-tips/two-ways-to-use-the-format-painter/1/ ...

07/29/2025

See something helpful?

04/01/2025

Very helpful function - SUMIF.

Use it to add up totals in a column of data for each item that meets a certain name or criteria.

How to use the SUMIF function in Excel to add the values in a range that meet criteria that you specify.