What is this book about? Visual Basic for Applications (VBA) is a programming language developed and owned by Microsoft to automate routine computing tasks in MS Office applications. This book ...

Creating bold text directly within Excel formulas isn’t natively supported. However, you can achieve a similar effect using a combination of formatting and VBA (Visual Basic for Applications). Here’s ...

This is the code you'll need to add a personal formula in Excel VBA to calculate distances in KM between two differents pairs of latitude, longitude coordinates(as in -XX,XXXXXX;-XX,XXXXXX / ...

Microsoft Excel allows you to control the program display in various ways, including complete personalisation of the top ribbon. If you're finding the large top ribbon to be troublesome, we'll show ...

Excel formulas are powerful, but they have their limits. I used to rely on complex nested formulas that take forever to build and are difficult to troubleshoot, but I have started leaning more heavily ...

In Excel 2016, Power Query is no longer an Excel add-in but a native feature of Excel, and what’s more, you can now use VBA to create and manage Power Query queries. I’ve found two sources of ...

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.