week number

4 WAYS TO SUM DATA BY WEEK NUMBER

Crispo Mwangi | 8-Feb-18 | Leave a Comment

Every organization requires weekly summaries to monitor peak and off-peak periods. This is mostly so when you are in the production section. Excel has a beautiful but overlooked function (WEEKNUM) that returns an integer representing the week in the year (1 to 53). For anyone not familiar with WEEKNUM function, it contains 2 arguments; Serial_number ( […]

VLOOKUP IS DEAD

VLOOKUP IS DEAD–OR IS IT?

Crispo Mwangi | 20-Jan-18 | 1 Comment

In the year 1882, a German philosopher, Friedrich Nietzsche made a claim that has revolutionalized Philosophical and Theological discussions since then. His Claim–God is Dead. There has been a similar discussion in the Excel world, not about God, but about VLOOKUP. Of all the over 450 functions in Excel, VLOOKUP is one of the most popular […]

Excel tables

7 EXCEL TABLES BEST KEPT SECRETS

Crispo Mwangi | 29-Dec-17 | 2 Comments

When was the last time you used excel tables? If you have never or not recently used excel tables, it could be because you have not realized how powerful they are in data analysis. By reading below 7 excel table’s secrets, your answer to above question will always be recent. Simple to create —Ctrl + […]

LOOKUP NUMBERS

7+ WAYS TO LOOKUP NUMBER VALUES

Crispo Mwangi | 5-Oct-17 | 2 Comments

The ability to lookup number values in excel is a must have for all data analysts. Some Excel users just know the basic VLOOKUP function but there are 7 more functions to lookup values. The more lookup function you know the better you become in retrieving numbers like sales for a certain month, a balance for a […]