Using the Excel FILTER Function to Create Dynamic Filters
Using the Excel FILTER Function Learn how to use the new FILTER function in Excel to create dynamic filters. These[…]
Read more
Tag: msexcel
Create Interactive Worksheets in Excel by Using the IF and COUNTIF Functions
Create Interactive Worksheets in Excel Learn how to use the IF function and the COUNTIF function to create interactive, self-grading[…]
Read more
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