Manage Conditional Formatting Rule – Edit, Delete, Reorder and Copy
In the previous article, we learned the implemented fundamentals of Conditional Formatting and how to use color scales. Today, we will learn how to manage… Read Article
Multiple Conditional Formatting Rules
In the previous blog, we learned the basics of conditional formatting. Today we would learn how to apply multiple conditional formatting rules on the same… Read Article
What is Excel Conditional Formatting?
Conditional Formatting is a very fascinating topic in excel. It might seem confusing to some people but is one of the straightforward things to learn.… Read Article
Conditional Formatting using Color Scales
Today, we are going to learn a very interesting topic. Conditional Formatting is used to format the cells based on some condition. Color Scales are… Read Article
How to Count Duration in Hours Between Two Dates?
The Date and time in Excel are stored as decimal numbers. There are times when we need to calculate the total number of hours between… Read Article
How to Convert Time into Decimal Number, Hours, Minutes or Seconds
In this blog, we are going to learn different ways to convert excel time into the corresponding decimal number. We can convert time into hours,… Read Article
How to Round Off Time in Excel – Using MROUND Function
Dealing with time in excel becomes a challenge especially when you do not know the right approach to the same. In this blog, we are… Read Article
How to Create a Pivot Table Timeline in Excel?
We can use slicers with a pivot table to apply filters on the inserted pivot table. A pivot table timeline is also an important tool… Read Article
How to Change the Default Layout of a Pivot Table in Excel
A pivot table is used to get the summarized form of the data. In this blog, we would learn how to change the default layout… Read Article
TAN Function in Excel – A Trigonometric Ratio
In the earlier articles, we learned to find the Sin and Cosine of the angles using the functions in Excel. In this blog, we would… Read Article
COS Function in Excel – Usage with Examples
In the previous blog, we implemented the SIN Function. In this blog, we would now learn another important Mathematical Function, which is the COS Function… Read Article
SIN Function in Excel – Mathematical Function
The SIN Function in Excel is an essential type of Mathematical Function The function is easiest to learn and implement. So let us begin learning… Read Article