Database Functions in Excel

This post is set aside to shed more light on database function use in Microsoft excel. Database is a detailed collection of data in such manner that can easily be read(access), manage, updated, and delete. In other word, a database can refer to as a list of related data in which rows of related information[…]

Shares 0

RAND and RANDBETWEEN functions

RAND() and RANDBETWEEN() functions RAND() is used to generate random decimal number between 0 and 1 with exclusion of 0 and 1. while RANDBETWEEN(bottom_number, top_number) very useful in generate lot of number between specified bound. Hope this post is helpful? For more Insight on Microsoft Excel, kindly buy any of my books “Productivity Boosting Aspects of Microsoft[…]

Shares 0

DATEDIF Function

DATEDIF function comes in handy to calculates the number of days, months, or years between two specific dates. Syntax: DATEDIF(Start_date, end_date, unit) Start_date: this represents the starting, or first, date of the period in question End_date: this indicates the end, or last, date of the period to determine the difference. Unit: indicates the type of[…]

Shares 0