Search Results

What’s the difference between Excel VBA macros and Office Scripts? Do you need to switch from VBA to Office Scripts? Find out in this detailed article. I show examples of what you can achieve with VBA and the current status of Office Scripts and explain what each is for.

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.

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.

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 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.

Learn how to set up electronic bookmarks in your PDF. Electronic bookmarks 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.

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!

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!”. You will see that VBA doesn’t have to be scary and that you can easily generate VBA code by recording your actions.

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.

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.

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.

Outlook Search feature has improved! If you use it correctly you can find exactly what you’re looking for. You can even search for words inside attachments! Read the full article to learn how to use Outlook Search correctly.