Skip to content

How To Excel At Excel

Search
  • Blog
  • Formula Friday
  • Macro Mondays
  • Formulas
  • Excel Tips& Tricks
  • Excel Charting

Posts by Barbara

link to A Super Quick Way To Unprotect Multiple Excel Worksheets

A Super Quick Way To Unprotect Multiple Excel Worksheets

Hello Excellers, welcome back to another #Excel tip in my 2021 series. Today I will show you how to unprotect multiple Excel worksheets quickly. Have you created an Excel workbook with...

Continue Reading

Extract Numbers From A String In Excel

Hello Excellers, welcome back to another #MacroMonday blog post in my 2021 series. Today I will show you how to create your very own Excel Function. This Excel function will allow you to extract...

Continue Reading
link to Find The First And Last Occurrence Of A Value With MINIFS and MAXIFS Functions.

Find The First And Last Occurrence Of A Value With MINIFS and MAXIFS Functions.

Hello, Excellers. Today's blog post will show you how to find the first and last occurrence of a value. I recently used this method to query the first and last dates that a product appeared in my...

Continue Reading
link to How To Create A Waffle Chart In Excel.

How To Create A Waffle Chart In Excel.

Hello, Excellers. Welcome to another blog post in my Excel series. Today I will show you how to create a fun Excel Waffle Chart. Unfortunately, Excel does not have a Waffle chart in the charting...

Continue Reading
link to Use The Status Bar To Find The Maximum Value In Your Excel Data Set WITHOUT a Formula.

Use The Status Bar To Find The Maximum Value In Your Excel Data Set WITHOUT a Formula.

So, Hello Excellers, and welcome back to another #formulafriday blog post. Today is a little different as this blog post centers in the Excel status bar. That is correct, We will not be...

Continue Reading
link to A Function To Generate A Random String Set In Excel.

A Function To Generate A Random String Set In Excel.

Hello Excellers, welcome back to another blog post in my #Excel #MacroMonday series. Today let's write our own Excel macro function that will generate a random string of characters. This random...

Continue Reading
« PREV Page 1 … Page 19 Page 20 Page 21 Page 22 Page 23 … Page 119 NEXT »

About the Author

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

© 2025 Copyright How To Excel At Excel