PowerPoint Merge Shapes Feature This post will highlight one of the most useful, yet underutilized tools in PowerPoint when it comes to bringing your slides to the next level. The Merge Shapes Tool We are often advised not to get too fancy
Debits and Credits MADE EASY with ADEx LER If you want to learn accounting, the concept of debits and credits is one of the most important to understand. But, many struggle with it and for me, it was the same in the
Excel's XLOOKUP 5 Examples By now, you may have read about Excel’s new super lookup function called XLOOKUP. XLOOKUP has the promise of becoming the only lookup function you’ll ever need for virtually any lookup problem you encounter. This will be a
Left Lookup in Excel with XLOOKUP (made easy) When users learn to perform a lookup in Excel, it doesn’t take long before a situation arises that causes the user to ask… “How do I perform a lookup to the LEFT?” Because most
Accounting Basics Explained Through a Story In this post, I'll give you an introduction to accounting by telling you a story. It's a story about Claudio, and how he runs his business in Italy. Before we start, let's just get clear on
Excel's Advanced Filter Little Known Trick This post will focus on an Excel feature that is unknown to most users, even Excel pros. The feature lies in the way we use the Advanced Filter tool. If you’re not familiar with the Advanced
Excel's Amazing Flash Fill Excel’s Flash Fill (introduced in Excel 2013) is one of the greatest time-saving features when it comes to fixing data. Flash Fill allows you to “fix” common data format issues like splitting text, merging text, date extraction, text
Send Email from Excel with a Hyperlink This post is about creating an email with an Excel formula. “But I already know how to do that; it’s called Insert – Hyperlink”. Don’t click away so fast. We will put our typical XelPlus
Get ALL External Links with THIS Simple Excel Trick (as NEVER seen before!) A terrific feature of Excel is the ability to pull data from external sources, like other Excel files. But with any benefit, there comes a cost. In this case,
Good Spreadsheet Design Principles There are “Dos” and “Don’ts” when creating Excel spreadsheets. These can be categorized into two main areas: Workbook Structure Visual Design of Excel Worksheets Putting into practice and making a habit of as many of the following principles