Skip to content

How To Excel At Excel

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

Posts by Barbara

Macro To List All Excel Worksheets In A Workbook.

Welcome to another simple #Excel macro in my #MacroMonday blog series. Today I want to show you how to write a simple Excel macro that will list all Excel worksheets in a...

Continue Reading
link to Easy Macro. Trim Excel Worksheet Names.

Easy Macro. Trim Excel Worksheet Names.

Hello Excellers, welcome to another #MacroMonday #Exceltip in my 2021 Excel series to use . Today's Excel Macro tip is a really simple but very effective time saver to trim extra spaces in Excel. I...

Continue Reading
link to Formula Friday- Generate Unique User Names In Excel Using The COUNTIF Function

Formula Friday- Generate Unique User Names In Excel Using The COUNTIF Function

Happy Friday, Excellers. Today let's look at how to generate a unique username in Excel using the COUNTIF function, even when you have duplicates! Welcome back for another #FormulaFriday in...

Continue Reading
link to Macro Mondays – How To Assign Or Change A Macro Shortcut Key

Macro Mondays – How To Assign Or Change A Macro Shortcut Key

Hello Excellers, time for some back to basics today with Excel Macros.  Let's take a look at assigning or changing a shortcut key with a Macro. Yes, welcome back to another #MacroMonday blog...

Continue Reading
link to Month To Year Calculator In Excel.

Month To Year Calculator In Excel.

Hello Excellers, Welcome to another blog post in my #FormulaFriday #ExcelTips series. Today I will show you how to create a Month to Year calculator in Excel. I have a sample file below to work...

Continue Reading
link to How To Use Flash Fill In Excel To Split Cells.

How To Use Flash Fill In Excel To Split Cells.

Hello Excellers, welcome back to another #Exceltip blog post in my 2021 series. Today I will show you how to use flash fill to split your cells into separate columns. Yes, that is correct....

Continue Reading
« PREV Page 1 … Page 18 Page 19 Page 20 Page 21 Page 22 … 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