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 Excel Tip- Formula Friday -How To Create a drop down list for your hyperlinks in Excel

Excel Tip- Formula Friday -How To Create a drop down list for your hyperlinks in Excel

Adding a drop down list to your Excel sheet is a really great and convenient way to allow data entry to your Excel worksheets whilst maintaining good quality consistent data and reducing the amount...

Continue Reading
link to Macro Mondays – A Very Useful Excel Macro To Convert All Cells To Values.

Macro Mondays – A Very Useful Excel Macro To Convert All Cells To Values.

Hello Excellers and Welcome to another #macromonday.  I want to share with you a Macro that will convert all the cells in a your active workbook to values only.  This is the same as using the copy...

Continue Reading
link to Formula Friday – Let’s Use TEXTJOIN To Join Text Strings Without The CONCATENATE Complexity

Formula Friday – Let’s Use TEXTJOIN To Join Text Strings Without The CONCATENATE Complexity

Happy Friday Excellers. Welcome back to another #FormulaFriday #Excel blog post in my Excel series.  I will compare TEXTJOIN and CONCATENATE.  If you have Excel 2016 then you may be...

Continue Reading
link to Update Multiple Pivot Tables. No Drill Down

Update Multiple Pivot Tables. No Drill Down

Hello Excellers. Welcome to another article in my #macromonday series of blog posts. Are you looking for a way to update your pivot tables without having go into each table individually?. If so,...

Continue Reading

IF Statement For Last Day Of The Month.

Hello, Excellers and welcome back to another #FormulaFriday #Excel blog post in my Excel series.  Today I want to answer a question that a subscriber sent to me.  If you want to ask any...

Continue Reading
link to Hiding All Worksheets Except The Active One – Excel Macro

Hiding All Worksheets Except The Active One – Excel Macro

Hello Excellers, welcome back to another #macromonday blog post in my 2019 series of Excel tips. I want to share with you an easy Excel macro which hopefully will save you some time when preparing...

Continue Reading
« PREV Page 1 … Page 5 Page 6 Page 7 Page 8 Page 9 … 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