by Crispo Mwangi | Feb 8, 2018 | Advanced Excel, Beginner, Excel Beginner, TEMPLATES
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)....
by Crispo Mwangi | Jan 20, 2018 | Advanced Excel, Excel Beginner, Tutorials
In the year 1882, a German philosopher, Friedrich Nietzsche made a claim that has revolutionized 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...
by Crispo Mwangi | Dec 29, 2017 | Excel Beginner, Tutorials
When was the last time you used excel tables? Do you know how powerful excel tables are? 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,...
by Crispo Mwangi | Oct 5, 2017 | Excel Beginner, Tutorials
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...
by Crispo Mwangi | Aug 12, 2017 | Advanced Excel
When was the last time you comprehensively looked at the HLOOKUP function and its alternative? To look up data horizontally, many excel users tend to use HLOOKUP but it has its limitations. So what are the alternatives? In this article,...