Entries by Vivekananda Sinha

Shading Alternate Rows in Excel

When you create a table (using Insert➜Tables➜Table), you have the option of formatting the table in such a way that alternate rows are shaded. Shading Alternate Rows can make your spreadsheets easier to read. This tip describes how to use conditional formatting to obtain alternate row shading for any range of data. It’s a dynamic […]

WEEKDAY Function

WEEKDAY Function tells you the day of week from a given date. Syntax of Weekday formula: =WEEKDAY(Date) Example 1: =WEEKDAY(“01-Apr-2014″) = 3 (3 for Tuesday) Example 2: =WEEKDAY(TODAY()) = Current Day of week WEEKDAY function returns the day number of a week as follows: 1 : Sunday 2 : Monday 3 : Tuesday 4 : […]

Insert Random Dates in Excel

To insert a Random Date between 05-Jan-2014 and 30-Jun-2014, use the below formula. You can customize the formula as per your requirement. =RANDBETWEEN(DATE(2014,1,5),DATE(2014,6,30)) Note: After you insert the formula you need to set the number format to Date, otherwise you’ll just see numbers.

Tips for looking great in Photographs

Want to know secret tips and tricks for looking great in every photo? Today we’re on a journey to discovering the secrets to look perfect in photographs. You don’t have to be a famous model or celebrity and you don’t have to be perfectly beautiful to take a perfect picture. There are many experts who […]