In this post we’re going to explore how to find and replace multiple text strings from within another string. Excel …
Author: excel
WARNING!!! This Post Is Full Of POWER. Power Query is a great tool for importing and transforming data in Excel. But …
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 a previous post we explored how to import all the files in a folder using power query. But what …
Power query is a great tool built by Microsoft that will help you work with data in Excel. This tool …
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 …