Power Spreadsheets

Custom Excel Ribbon In 7 Easy Steps: The Introductory Tutorial

[Some of the links in this Excel Tutorial are affiliate links, which means that if you choose to make a purchase, I will earn a commission. This commission comes at no additional cost to you.] The Excel Ribbon is the main component of Excel's user interface. If you do a quick online search, you'll notice that there are several forum threads where people ask for advice … [Read more...]

Excel VBA Copy Paste: The Complete Tutorial For Copying And Pasting Cells With Macros (And 8 Examples)

Copy and paste are 2 of the most common Excel operations. Copying and pasting a cell range (usually containing data) is an essential skill you'll need when working with Excel VBA. You've probably copied and pasted many cell ranges manually. The process itself is quite easy. Well... You can also copy and paste cells and ranges of cells when working with Visual Basic for … [Read more...]

Excel VBA Save As PDF: Step-By-Step Guide And 10 Code Examples To Export Excel To PDF

Power Spreadsheets focuses on Microsoft Excel. However, I've written several tutorials (such as here and here) that have to do with PDF and, more particularly, with the topic of converting PDF files to Excel. The reason why I write about PDF is relatively straightforward: PDF is one of the most widely used file formats. This particular Excel tutorial also focuses on the topic … [Read more...]

VBA Loops Explained: Complete Tutorial On 6 Essential Excel VBA Loops

If you've been working enough time with Visual Basic for Applications, you're probably aware that 2 of its most powerful structures are: Decision-making structures, such as the If... Then... Else statement. Loops. These 2 structures allow you to create powerful, flexible, sophisticated macros. Excel VBA loops are, however, not an easy concept to understand. My main … [Read more...]

Convert PDF To Excel: 3 Easy Methods You Can Use Right Now

[If you're looking for a step-by-step explanation of how to extract data PDF to Excel using VBA, please refer to this post. In there, I explain how you can use VBA to implement the 3 PDF to Excel conversion methods I discuss below, and provide macro code examples.] Most recent versions of Microsoft Office have several features that allow you to, among others, import data … [Read more...]