Summary: Let’s learn how to use the SUMIFS and DSUM functions in Excel. These functions both help us to add numbers in a table that meet specified criteria. We’ll see why DSUM is easier to use [...]

Summary: In this article we’ll learn how to create Cascading dropdowns in Excel. Excel dropdown lists are very useful especially when we want to create data entry forms. Excel functions used in [...]

Summary: Learn how to create your own Personal Macro Workbook. It acts like your personal code vault where you keep frequently used macros. Any macros in the Personal Macro Workbook can be called [...]

Summary: Few Excel users know about Worksheet Code Names… in this article you will learn how they differ from plain old Worksheet Names and why you should start using Code Names where possible in [...]

Summary: Learn the difference between using Range() and Cells() when referring to ranges with Excel VBA. With the help of sample code you’ll understand when to use Range() and when to use [...]

Summary: Learn four different ways to find the last cell, row or column in a worksheet using Excel VBA.  The method to choose depends on your data layout, and if the sheet contains blank cells. [...]