Excel 2007 Manual

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...

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...

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: Your IT department sends you a file with unit price and quantity sold. You need to calculate total revenue. You usually add a n...

Challenge: The NETWORKDAYS and WORKDAY functions can take a list of company holidays as the third argument. If you store the list of holi...