Category: Advanced Excel

VLOOKUP. You’ve heard about it – but what does it do? Vlookup searches a list for a value in the left most column and retrieves the corresponding value from other columns in that row. As an Excel user, what does that mean for you? Let’s say your organization receives donor…

Working with time in Excel can be a problem.  Have you ever calculated how long a person was at work, and then wanted to multiply that time by an hourly wage?  It isn’t difficult to fail miserably! But, if you know the trick, Excel time formulas are easy. First, start…

Here are some techniques for calculating percentages. For these examples, we have a simple sheet of travel expenses and you are after the percentage results of prices going up or down for the total and for the individual months. Percent increase Let’s say you anticipate more travel the following year…