Excel Tips

• Why You Need to Learn Excel

MS Excel is no doubt, the most widely used spreadsheet program in the World. Excel usage is a long journey which starts with your school years and continues during your professional career. That’s why everybody is taking online courses to learn Excel nowadays. Excel is not a basic spreadsheet anymore. You can create tools, calculators […]

• What Every Experienced Excel User Should Know

They say Excel users fall into two groups: Those who draw tables in Excel, and those who surprise their colleagues with amazing charts of data analysis functions. If you are the latter type, here are some tips that you absolutely must know. VLOOKUP Got data scattered across different workbooks and sheets? VLOOKUP will help you […]

• Summing Based on Multiple Criteria

In the last post I showed you how to use SUMIF, which let’s you subtotal based on a specific single criterion. You can also subtotal based on multiple criteria with a very similar, but much more powerful function called SUMIFS. SUMIFS SUMIFS is structurally similar to SUMIF, but you put your sum range in the […]

• Summing Based on a Specific Criterion

If you read my last two posts on COUNTIF and COUNTIFS, you might wonder if, instead of just counting, you could add something based on specific criteria. Well, you can, with SUMIF! SUMIF With SUMIF, you can quickly create subtotals based on a single criterion. For instance, say you have bunch of spending data for […]

• Counting Based on Multiple Criteria

Last week we talked about the COUNTIF formula and how you could use it to count rows based on a single criterion. But what if you wanted to count rows based on multiple criteria? If you haven’t guessed already, the answer is with COUNTIFS! COUNTIFS COUNTIFS is a function that counts data based on multiple […]

• Counting Based on a Specific Criterion

Do you know there is a really fast and easy way to count rows that meet specific criteria? For instance, if you have over a hundred rows of spending data, like the hypothetical data below, how can you quickly find out how many times you bought something in the month of October? The answer is, […]