Blog Posts on MS Excel
Following are 4 different methods to find the Sum of first 50 natural numbers using Excel. Formula using SUM and SEQUENCE function The following formula will return the sum of numbers from 1 to 50. =SUM(SEQUENCE(50,1,1,1)) For the sum of first 75 numbers, =SUM(SEQUENCE(75,1,1,1)) Formula using SUMPRODUCT and ROW function Formula that combines SUMPRODUCT and … Read more
Following are 4 different methods to generate random numbers in Excel RAND Function The RAND function in Excel can be used to generate a random number between 0 and 1. The RAND function is a volatile function and will update every when the worksheet is recalculated. RANDBETWEEN Function The RANDBETWEEN function returns a random number … Read more
In this blog post, we will see how to calculate Time difference in Excel. The methods include calculating Time difference with Overnight schedules. Let’s say we have the ‘In Time’ and ‘Out Time’ of an Employee for a week. Following are the different methods to calculate the difference between the In and Out times. Simple … Read more
In this blog post we will go through 3 different formulas to add Hours and Minutes to Time in Excel. Before jumping into the formulas we should know that Excel stores Time as Numbers. In Excel, 1 Day = 1 1 Hour = 1/24 (1 Day/24 hours) 1 Minute = 1/(24×60) (1 Day/24 hours x … Read more
Let’s see how to shuffle the records of a dataset using the RAND, LARGE, ROWS and VLOOKUP functions in Excel. Step 1: Insert a column on the left side of the dataset and generate an array of random numbers in it. The RAND Function in Excel can be used for this purpose. =RAND() Step 2: … Read more
Following are 4 different methods in Excel to find the ‘Day Name’ corresponding to a ‘Date’. 1. TEXT Function to find Day Name from Date The TEXT function in Excel can be used to return the corresponding Day Name, Month or Year from a Date. The following formula will return Tuesday, the Day name corresponding to the … Read more
What is a Linked Picture in Excel? In Excel, a Linked picture is a live image of a cell or a range of cells in a worksheet. In other words, dynamic snapshot of particular data range in a worksheet. When working with many worksheets of a Workbook that are connected with formulas, we can use … Read more
There are instances in which leading zeroes need to be added to a dataset in Excel, such as when maintaining Transactions IDs, Employee IDs, Zip Codes, Social Security Numbers, etc., In this blog post, we will see the different ways in which we can pad numbers with zeros at the beginning. TEXT Function in Excel … Read more
Following are 4 different methods that can be used to Jump to the First or Last sheet of an Excel Workbook. Method 1 Holding the Ctrl key, left-click on the small right arrow present in the bottom left corner of the workbook. You will land on the last worksheet of the active workbook. Similarly, to select the … Read more
In Microsoft Excel, we can set the Transparency level for pictures inserted into it. The following are the two methods to change the transparency of a picture in Excel. Method 1 Select the picture > Go to the Picture Format tab > In the group called Adjust, click on the drop-down menu for Transparency Make a picture transparent in Excel 7 Transparency levels … Read more