Popular Posts
-
Challenge: You want to build a formula to return the first non-blank cell in a row. Perhaps columns B:K reflect data at various points in t... -
Challenge: Calculate how many workdays fall between two dates. Excel's NETWORKDAYS function does this if you happen to work the five da... -
Challenge: In Figure 7, someone set up a worksheet with dollars in rows 2, 4, 6, 8, and so on and percentages in rows 3, 5, 7, 9, and so o... -
Challenge: While IFand other functions that expect logical tests can easily convert TRUE and FALSE values to 1s and 0s, the SUMPRODUCT ... -
Challenge: You want to become a guru at Excel formulas. To master conditional computing formulas, you need to understand Boolean logic fac... -
You’ve used Excel for quite a while, but you probably never thought of it as an object. The more you work with VBA, the more you view Excel... -
Before you can call yourself an Excel programmer, you must go through the initiation rites. That means you need to make a small change so E... -
Challenge: The NETWORKDAYS and WORKDAY functions can take a list of company holidays as the third argument. If you store the list of holi... -
Taking the First Steps This tutorial describes the steps you take prior to recording the macro. In other words, you need to make a few pre... -
Macro security is a key feature in Excel. The reason is that VBA is a powerful language — so powerful that even a simple macro can do serio...