Excel Business Solutions

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.

02/05/2025

Something I've needed a lot lately so I thought I would share...

08/14/2024

Handy...

04/16/2024

OBVIOUSLY, I love Excel. But the reality is that sometimes you actually need a relational database. Here's a really good one that I've been working with lately.

Anyone else have a good experience with Airtable?

Airtable is one of my favorite foundational tools that I use for a variety of projects, both for work and personally.In this video I explain how you can take...