by Crispo Mwangi | Jul 6, 2016 | BASIC EXCEL
Are you a developer working  with microsoft technologies and looking for a unique identifiers for  components/applications/files ? Or are you a database developer or administrator looking for primary keys tables? Well! in this article I will show you how to create...
by Crispo Mwangi | Jun 25, 2016 | BASIC EXCEL, INTERMEDIATE EXCEL
The chance of winning a lottery is usually infinitesimal but the magnitude of the rewards tends to over shadow it. This is why millions of people play or fantasize about winning the lottery daily. Since most Lottery use pseudo-random numbers to pick a winner, I will...
by Crispo Mwangi | Jun 7, 2016 | BASIC EXCEL, INTERMEDIATE EXCEL
In Over 450 functions in Excel, MOD function is one of the highly overlooked. Generally, MOD function returns the remainder of two numbers after division. Functions like IF, SUM, COUNT, AVERAGE are well known by all excel users. Yet there are some functions...
by Crispo Mwangi | Jun 5, 2016 | BASIC EXCEL, INTERMEDIATE EXCEL
Have you ever looked for an Excel function that is extremely powerful, flexible and has multiple uses? The ONE function that will solve most of your daily array of problems? The ONE function that will open doors to advanced Excel skills? Well! This is it—SUMPRODUCT....
Recent Comments