In this post we’re going to explore how to find and replace multiple text strings from within another string. Excel …
Category: Excel
Excel’s macro recording tool is a very powerful feature. It allows you to record the actions you perform in Excel …
Data entry isn’t fun, but sometimes it has to be done. Excel has a neat hidden feature made just for …
So you needed to do something in Excel and after a bit of searching online, the solution you found involves …
So you’ve just finished compiling the sales figures for the big boss man and you’re ready to send it off …
In this post we will explore how to create a drop down list with dynamic content. This means the content …
Unlimited Format Painter When you click the format painter you will be able to use it once, but if you …
As most of us know, Excel, being such an amazing tool, gives us the ability to Hide sheets from view. …
If there is one piece of advice, I could give to DAX users, it would be to keep the structure …
Microsoft Excel is a Powerful Tool, Period. And once you are loaded with all the basics of Microsoft Excel, it’s important …