How to remove spaces in Power Query

Power Query Remove Excess Spaces

In a previous post, we looked at various methods to remove additional spaces in Excel. One of the methods involved creating a custom function in Power Query. As this is a more advanced method, I wanted to go a bit deeper and describe the method to remove spaces in Power Query. Table of Contents Excel … Read more

How to email or save Excel images with Power Automate

Images from Excel - Power Automate

It is common in many businesses to send regular email summaries or reports to senior executives. Typical scenarios include daily sales reports or cash-flow positions. These emails often contain images displaying the key information. With the current cloud technologies, we now have an easy way to automate this. So, in this post, we look at … Read more

How to run Power Automate from Excel with Office Scripts or VBA

Run Power Automate From Excel

For a long time, I’ve been asking Microsoft for the ability to run a Power Automate flow from an Office Script. Office Scripts are restricted to operate only on objects within the workbook. Therefore, we can’t currently run a script that changes another workbook, or undertakes other activities outside of Excel. This significantly reduces the … Read more

Application.CutCopyMode = False (How to use it)

Application.CutCopyMode = False

If you use copy and paste while recording a Macro, we will see the code which refers to Application.CutCopyMode = False. You may wonder why it’s there? What does it do? In this post, we answer all your question about Application.CutCopyMode. Table of Contents Application.CutCopyMode = False in recorded macros What is Application.CutCopyMode = False for? … Read more

How to install or uninstall Excel Add-ins (Windows & Mac)

How to install or uninstall Excel Add-ins

An Excel Add-in is a mini-software application that provides Excel with enhanced functionality and automation features. Whilst they can be created by third-party suppliers, even Microsoft themselves develop add-ins to provide additional functionality. Add-ins can take a number of forms: COM Add-ins and Office Download Store Add-ins will have their own installation processes. Excel Add-ins, however, have … Read more