Showing posts with label Basic Excel Functions. Show all posts
Showing posts with label Basic Excel Functions. Show all posts
Tuesday, September 5, 2017

Quickly create a dynamic drop down list in Excel

›
I have a request from friend to create a dynamic drop down list in excel and I would like to share with my blog reader... Part  1:  - Op...
Friday, October 7, 2016

Create User Define Function and Macro as an Add-in

›
We work lot in excel and manage our work with functions and macros. I am here creating the process that will save your time and effort to ...
Thursday, March 10, 2016

Count the number of spaces of text string in Excel

›
Simple to calculate the number of spaces of text string in EXCEL with following formula: =LEN(A1) - LEN(Substiture(A1," ",&quo...
Friday, January 23, 2015

Essential keyboard shortcuts for MS-EXCEL

›
Keyboard shortcuts are the best way to navigate cells or enter formulas more quickly. Control-Down/Up Arrow = Moves to the top or bottom...
Tuesday, August 5, 2014

Add a number of months to a date in Excel

›
Many of my friends have query about how to add / Subtract month in excel, Simple way of doing as below =Date( Year ( Start_Date ) + add_...
Thursday, December 30, 2010

Random Function

›
Returns an evenly distributed random real number greater than or equal to 0 and less than 1. A new random real number is returned every time...
Thursday, June 24, 2010

=IF() Function

›
How the IF() function works: Syntex : "=IF(Condition,TRUE,FALSE)" The Excel IF() checks to see if a certain condition is true o...