Import Outlook to Excel with Power Query

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 your Outlook data to Excel.

Show Changes in Excel

Excel Show Changes Feature lets you know who changed your data and formulas. You'll see the previous value below the current value. With Version History you can easily revert back to a previous version of your file.

Email from Excel with Attachments

Guess what? You can send bulk personalized emails directly from Excel with attachments. You don't need any VBA or external add-ins. It's really easy to set this up.

Mail Merge from Excel

Mail Merge is what you need if you'd like to create multiple letters, emails or documents with data from Excel. This way you can easily create invoices for your customers or send bulk personalized emails. You'll learn how to quickly get started with Merge Merge and save a ton of time.

PDF Electronic Bookmarks

Electronic bookmarks in a PDF document make it easy for your readers to quickly and easily move around in the document. They don't need to scroll back to the table of the contents to jump to specific section. Learn how to set up electronic bookmarks in your PDF.

Excel Advanced Pivot Tables

These 10 advanced Excel Pivot Table tips are going to help you analyze your data faster. PivotTables are one of Excel's most important tools. Not everyone knows these Pivot Table tricks though. Make sure you do!

Learn Excel Macros

Learn Excel Macros in 10 Minutes If you find yourself repeatedly performing the same steps in the same order in Excel, your brain should immediately declare, “I should automate this with an Excel macro!”. Think of the common, repetitive tasks you perform in

Excel Calculate Ratios

Easily calculate the ratio of two numbers in Excel with Excel formulas. Ratios are a common way to compare amounts. To calculate ratios you need to calculate the highest common factor. You can easily do this with the GCD function.

Power Automate in 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.

Top Excel Features for Accountants

Learn the 10 most important Excel features for accountants. This list is not just for those that work in accounting but also anyone who uses Excel for data analysis. You'll discover new Excel tips and tricks that will make your working life a lot easier.