Tag Archives | functions

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 […]

Continue Reading 0

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 […]

Continue Reading 0

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 […]

Continue Reading 0