by Rajesh Saraogi | Aug 7, 2020 | Formula & Functions, Worksheet Formatting

Microsoft Excel is a versatile and user-friendly application, most of the time, you find more than one solution to resolve a problem In one of my post, I covered trick to convert cardinal number and date to ordinal (ordinal-number-and-ordinal-date-in-excel) with the...
by Rajesh Saraogi | Jul 19, 2020 | Lookup & Reference, Worksheet Formatting

Goals: An excel worksheet is often used to update daily data. Suppose we enter per day sales by each engineer of the company in an excel worksheet. In such cases the number of rows is not fixed and extra rows are required to be added on daily basis. In turn you have...
by Rajesh Saraogi | Jul 5, 2020 | Date & Time, Formula & Functions

Goal: To get difference between two dates with the answer as exact year, month, and days. Simply it means, if we take two dates as 1-Jan-2009 and 2-Feb-2010, the required result (difference) will be 1 year 1 month 1 day. Algorithm: First of all we have to check...
by Rajesh Saraogi | Jun 21, 2020 | Formula & Functions, Sum & Count

Goal: Excel worksheet have number of rows and columns. Intersection of row and column is known as a “cell”. We insert data in these cells only. Every cell has got a row number and a column number. We have to add value of every nth cell in a row or column. In simple...
by Rajesh Saraogi | Jun 14, 2020 | Formula & Functions, Text Functions

Goal: To generate Ordinal Number and Ordinal Date in excel. An Ordinal Number is a number that tells the position of something in a list, such as 1st, 2nd, 3rd, 4th, 5th etc. An Ordinal Date denotes the position of a day in a given month and year; e.g., 8th June, 2020...
by Rajesh Saraogi | Jun 8, 2020 | Formula & Functions, Formula Basics

The real strength of Excel is its calculation power. An excel worksheet without any calculation can also be created in an MS Word (.doc or .docx) file. This post will help to understand excel formulas, from simple calculations to advanced ones, with nested built-in...