How to use Microsoft Power Query
Microsoft Excel Tips and Tricks In this step-by-step tutorial, learn how you can use Microsoft Power Query to get and[…]
Read more
Category: excel training
How to Create & Use Excel Macros (Real world example)
Excel VBA Tutorials you’ll learn the basics of Macros and VBA in Excel. Plus you learn all of this in[…]
Read more
Excel VBA basics: Data types, DIM & SET (Learn to use them correctly)
Excel VBA Tutorials It’s best practice to declare your Excel VBA variables before you use them. Declaring variables means that[…]
Read more
Excel VBA: Check If File or Folder Exists (DIR) – Open File or Create Folder
Excel VBA Tutorials Use the DIR function in Excel VBA to check if a file or a folder exist. You[…]
Read more
Excel VBA: Referring to Ranges & Writing to Cells (Range, Cells, Offset, Names)
Excel VBA Tutorials Referencing ranges is a common task in Excel VBA. It’s important to be aware of the different[…]
Read more