Power Spreadsheets

If you're anything like me, you probably spend a substantial amount of time working in Excel. The results of your efforts are probably beautiful and useful Excel worksheets. From time-to-time, you probably share the results of your work in Excel with others. 2 of the most common ways of achieving this are: Printing your worksheets. Saving your files as PDF. Printing an Excel … [Read more...]

One of the most basic and common operations in Excel is creating a new workbook. You've probably created a countless number of new workbooks yourself. If you're automating some of your Excel work by using Visual Basic for Applications, the ability to create new workbooks can be of immense help. You may want, for example, do any of the following: Create a new workbook … [Read more...]

You're probably aware that the process of cleaning up data can be annoying and time consuming. At the same time, it's important to ensure the accuracy of the data you're using for your analysis. Excel VBA macros can help you automate some data-cleanup activities. At the same time, if you set up your macros properly, they can reduce the risk of mistakes during the process. In … [Read more...]

When working with an Excel workbook, there are a few basic operations that any user needs to know how to carry out. The following are 2 of the most important ones: Opening a workbook. Closing a workbook. These 2 actions are just as important if you're working with Visual Basic for Applications. In this tutorial, I focus on topic #2: How you can easily close an Excel … [Read more...]

When working with Excel, you may find yourself in situations where you may need to hide or unhide certain rows or columns using VBA. Consider, for example, the following situations (mentioned by Excel guru John Walkenbach in the Excel 2016 Bible) where knowing how to quickly and easily hide rows or columns with a macro can help you: You've been working on a particular Excel … [Read more...]