SOMEKA BLOG
Combining business know-how into Excel and Google Sheets tips to provide hundreds of interesting articles.
RECENT POSTS
How to use Excel VLOOKUP function
Excel VLOOKUP function looks in the first column of an array and moves across the row. Tips and tricks with examples and video tutorial.
How to use Excel SUMPRODUCT function
Excel SUMPRODUCT function returns the sum of the products of corresponding array components. Other Languages and Syntax Details are as listed.
How to use Excel ROUND function
Excel ROUND function rounds a number to a specified number of digits. Other Languages and Syntax Details are as listed.
How to use Excel COUNTA function
Excel COUNTA function counts how many values are in the list of arguments. Other Languages and Syntax Details are as listed.
How to use Excel LEN function
Excel LEN function returns the number of characters in a text string. Other Languages and Syntax Details are as listed.
How to use Excel DATE function
Excel DATE function returns the serial number of a particular date. Other Languages and Syntax Details are as listed.
How to use Excel MIN function
Excel MIN function returns the minimum value in a list of arguments. Other Languages and Syntax Details are as listed.
How to use Excel MAX function
Excel MAX function returns the maximum value in a list of arguments. Other Languages and Syntax Details are as listed.
How to use Excel AVERAGE function
Excel AVERAGE function returns the average of its arguments. Other Languages and Syntax Details are as listed.