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 Conditional Formatting Excel Cell Text When A Formula Changes To A Typed Value- Formula Friday

Conditional Formatting Excel Cell Text When A Formula Changes To A Typed Value- Formula Friday

Hello, Excellers welcome to today's #formulafriday blog post.  Today let's look at using conditional formatting formula to change Excel cell text colour when a formula is replaced with a value.  In...

Continue Reading
link to How To Write A Macro To List All Files In A Folder – Macro Mondays

How To Write A Macro To List All Files In A Folder – Macro Mondays

Hello, Excellers I am excited to share with you some cool VBA Macro fun.  I find this a really useful macro which uses the Excel For Loop to list all files in a folder or directory.  Similarly, we...

Continue Reading
link to Formula Friday- Increase Or Decrease A Number By A Percentage In Excel

Formula Friday- Increase Or Decrease A Number By A Percentage In Excel

Hello, Excellers it is yet another week has gone by which means it's time for Formula Friday Excel tip.   Let's take a look at percentages today and specifically increasing or decreasing a number...

Continue Reading
link to Using TRIMMEAN IN Excel To Ignore Outliers – Formula Friday

Using TRIMMEAN IN Excel To Ignore Outliers – Formula Friday

Hello, Excellers welcome to another  #formulafriday  blog post with yet another an awesome Excel tip. No - one likes to be ignored right?....wrong?...let you decide that one, but I was asked...

Continue Reading
link to An Excel Macro That Will Copy An Entire Worksheet To Another Workbook – Macro Mondays

An Excel Macro That Will Copy An Entire Worksheet To Another Workbook – Macro Mondays

Hi Excellers, welcome back to another instalment of #macromonday.  Let's look at how to save a tonne of time by writing a simple Excel VBA Macro that will copy an entire worksheet from one Excel...

Continue Reading

Identify New Customers With Conditional Formatting Using A Formula – Formula Friday

Hello Excellers and welcome back for aonther#formulafriday.  Today I want to share how to highlight new entries into an Excel list within a specified time period.  So, your boss has asked you send...

Continue Reading
« PREV Page 1 … Page 55 Page 56 Page 57 Page 58 Page 59 … 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