Skip to content

How To Excel At Excel

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

Posts by Barbara

Macro Mondays – Create A Excel Macro To Protect All Worksheets In An Excel Workbook (VBA)

Do you have an Excel workbook with multiple sheets that you want to protect from being edited or deleted? You can create a macro to protect worksheets with vba in your workbook with just a few...

Continue Reading
link to Formula Friday – Excel Tip – The EXACT Formula

Formula Friday – Excel Tip – The EXACT Formula

Hello Excellers, welcome back to another #Excel #FormulaFriday blog post. In Excel, some formulas are quite complex, while others are simple. This blog post will focus on the EXACT formula in...

Continue Reading
link to Macro Mondays – Top 4 Reasons to Use Macros In Your Excel Reports and Dashboards

Macro Mondays – Top 4 Reasons to Use Macros In Your Excel Reports and Dashboards

Hello Excellers.  Time for some more Excel Macro fun on a Monday.  Do you use macros in your Excel reports and dashboards? If not, you should! Macros can save you a lot of time and hassle when...

Continue Reading
link to Macro Mondays – How To Protect Your Excel VBA Code

Macro Mondays – How To Protect Your Excel VBA Code

Hello, Excellers. Welcome back to another #MacroMonday Excel tips blog post in my #Excel series. Are you an Excel user who creates macros and VBA code? If so, it's essential to...

Continue Reading
link to How To Check Cells Have The Same Excel Formula.

How To Check Cells Have The Same Excel Formula.

Hello Excellers, and welcome back to another #FormulaFriday #Excel formula tip in my Excel Series. Today, I want to show you how to use the FORMULATEXT function to check if your cells contain the...

Continue Reading
link to Macro Mondays – Delete Excel Rows That Do Not Contain Specified String

Macro Mondays – Delete Excel Rows That Do Not Contain Specified String

Time for some more Macro Fun on #macromondays.  Do you have a worksheet with data that needs cleaning? Maybe there are some rows that you don't need. Perhaps you want to delete all...

Continue Reading
« PREV Page 1 … Page 9 Page 10 Page 11 Page 12 Page 13 … 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