Make Your Excel Hyperlinks Dynamic – Using The Hyperlink Function – Formula Friday
Hello, Excellers. Time for some hyperlink fun in Excel today. If you have been using Excel for a while you probably have used, or have been sent a spreadsheet with hyperlinks in them. These...
View And Edit The Code That Excel Creates When You Record A Macro – Macro Mondays
Hello, Welcome if you are new to the How To Excel At Excel Blog. Welcome back if you are a regular visitor as I know many of you are. :-). Today let's look at how to view and make alterations or...
How To Write An Excel VLOOKUP Formula With An IF Statement – Formula Friday
Hello Excellers, I am delighted to share another Excel #formulafriday Excel tip with you today. If you have used Excel for some time, you probably know how to use a VLOOKUP formula. If you do not...
Hello Excellers, a warm welcome back to #macromondays. I want to share with you a VBA or macro solution to an Excel process that you probably think already saves you a tonne of time. Do you...
Count How Often A Value Occurs In A Data Set – Using The COUNTIF Formula – Formula Friday
Hello Excellers, today lets look at an Excel question that a twitter follower sent to me. Their question was 'how do I count how many times a certain word was used or appears in data set'?. ...
How To Apply Conditional Formatting To An Excel Pivot Table – Correctly – Excel Tip
This next tip I know causes a bit of frustration with Excel users, based on the number of times I have been asked about it. It is applying conditional formatting to a Pivot Table. The method of...