Search Results

With this trick you can easily combine and repeat blocks of values together in Excel. You don’t need copy pasting or complicated formulas. Just a tiny bit of Power Query. This keeps your solution dynamic too.

It’s super easy to setup an automation in Power Automate to get notified when someone submits their answers in a Microsoft Form. You can also add a condition, so you get an email or mobile notification only when a specific answer is submitted.

Learn to combine Office Scripts with Power Automate so you can run your macros without opening your files. You’ll learn how to create a script, how to loop through each sheet in the script and how to setup Power Automate to apply the script to every file in a folder.

Learn how to easily export your Outlook emails into Excel. No VBA or Add-ins are necessary. I’ll show you how to create a connection to any Outlook folder (or your full inbox) so you can easily import Outlook data to Excel.

Learn to combine Microsoft Excel with Power Automate and get more done! We’ll look at two practical examples: Record your working hours in Excel by clicking a button on your phone – AND – Post on LinkedIn from the comfort of your Excel file.

In this post I share 5 PowerPoint tips and tricks you wished you knew sooner (At least I did!). These apply for PowerPoint business presentations as well as for students and teachers.

How do you create professional looking PowerPoint slides? It comes down to small things. Most of which we don’t notice when we watch presentations we love. I’ve broken it down into 5 tips which you can apply to your PowerPoint slides.

Do you know these 5 PowerPoint hacks? With these you can get your PowerPoint presentation done a lot faster. Not only that, but your presentation will also look more professional.

Working with time in Excel – for example calculating hours worked or summing or subtracting time can get tricky with Excel formulas. Let me show you how Power Query can easily do these for you.

Can you easily combine & clean data from multiple Excel sheets into a single table or Pivot Table? You can easily get this done in Excel with Get & Transform (aka Power Query). Check out the full post.

Go from raw data to a filled map chart in Excel. Power Query will help summarize the data and make the whole process dynamic. Use Excel filled maps to create an impressive visualization for your reports.

What can Excel Power Query do for you? It can help you in more ways than you think. Not only can you import big data from different locations, but you can also replace complex formulas with a few clicks.