In the dynamic world of Excel, tracking real-time information is often crucial. The Excel NOW and TODAY functions are your trusty companions for creating real-time timestamps that update automatically. These functions are indispensable when you need to keep records of …
Lesson#237: Excel NOW and TODAY Functions: Real-Time Timestamps Simplified Read more »
Hello readers! In this post, we shall learn about the 25 most useful Excel Functions everyone needs to know. Newcomers who start to learn Microsoft Excel gets easily confused with hundreds of excel formulas and functions. So today we shall …
Lesson#155: 25 most useful Excel Functions everyone needs to know Read more »
Previously I had discussed how to make an analog clock with piechart in excel. I am sharing the post link below. Lesson#61: Making a semi-analog clock with a pie chart Now I will add some simple VBA to make the …
Lesson#81: Making an automatic analog clock in excel with a pie chart Read more »
We will learn how to make an automatically refreshing bar clock in excel. 1. First I made three merged cells by putting these formulas =HOUR(NOW()) =MINUTE(NOW()) =SECOND(NOW()) 2. Select those cells one by one and click on Conditional Formatting>Data …
Lesson#80: Make an automatically refreshing bar clock in Excel Read more »
Let me show you how to make a spreadsheet that changes its color every second automatically. to make this you have to follow some steps where I will apply a little VBA to make it really automatic. 1. Click the …
Lesson#79: Automatic changing Excel sheet color every second Read more »
Now I will show how to make a spreadsheet that changes its color every minute automatically. to make this you have to follow some steps. 1. Click the upper left corner of the sheet to select all of the spreadsheets. …
Lesson#78: Change the color of the whole sheet every minute in Excel Read more »
OK friends! How is everyone? Now in this post, we will learn an unusual trick to make a semi-analog clock with Pie Chart. Let’s see. First I have made a 3X3 table for the hour, minute, and second of the …
Lesson#61: Making a semi analog clock with pie chart Read more »
Lesson#16 will introduce you to some more new function TODAY, NOW, HOUR, MINUTE, SECOND, YEARFRAC. Function TODAY returns the current date formatted as a date. Function NOW returns the current date and time formatted as date and time. HOUR(serial_number) returns the hour as a …
Lesson#16: Know about function TODAY, NOW, HOUR, MINUTE, SECOND, YEARFRAC Read more »
