Power Spreadsheets

How To Enable Macros In Excel: Step-By-Step Guide To Dealing With 3 Common Scenarios

I've been there… I found a new macro that promised to automate a particularly annoying task, save me a ton of time and make me significantly more efficient in Excel. I tried to run the macro. And then… Something like this happened: Sigh... The first time I saw such a message in Excel, several questions popped immediately in my head: What security settings is this … [Read more...]

Excel VBA Delete Blank Or Empty Rows: 5 Easy-To-Use Macro Examples

You're probably aware of how annoying and time-consuming cleaning up data can be. Data scientists spend a substantial amount of time collecting and preparing data. As you're probably aware, the process of cleaning up data with Excel can be automated to a certain extent using tools such as Text functions or macros. In this tutorial, I focus on a very "dangerous", annoying and … [Read more...]

Excel VBA Tutorial For Beginners: 16 Essential Terms You Must Know To Learn VBA Programming

So you've created your first (or your first few) Excel macro(s), perhaps by following these 7 easy steps to create a macro. By now, your colleagues are already looking at you like you're a wizard. That is a great sign that you're on a good way to learning macros and Visual Basic for Applications (VBA). However… Being able to create a basic macro in Excel is only the beginning … [Read more...]

Excel LEFT, RIGHT, MID, LEN, FIND And SEARCH Functions: Learn How To Use Them With A 9-Step Example

In an ideal world, you wouldn't need to read this tutorial about some of the most important text formulas in Excel. Unfortunately, we are not in ideal world… If you work with Excel, you will need to know or learn how to use the LEFT, RIGHT, MID, LEN, FIND and SEARCH functions. So… fortunately, you have found this tutorial which focuses on some of the most important text … [Read more...]

Excel Macro Tutorial for Beginners: Create Macros In 7 Easy Steps

Do you track what proportion of the time you spend working on Excel goes away in small and relatively unimportant, but repetitive, tasks? If you have (and perhaps even if you haven't), you have probably noticed that routine stuff such as formatting or inserting standard text usually take up a significant amount of time. Even if you have practice in carrying out these … [Read more...]