How To Use Formulas In Conditional Formatting To Find New Customers From Data

Conditional Formatting is helping us from last 8 to 9 years. A well-designed Data Analysis & Presentation Tool created by Microsoft to enhance user experience. Everyone has a different way to work with Conditional Formatting. But, the good thing is that it is simple to use even it so powerful. In this post, I will use the formulas in conditional formatting to highlight new […]

Check it out now

How To Insert Calculation In Pivot Table With Custom Field & Item

How To Add Calculation In Pivot Table

Using calculation in the pivot table is like a custom calculation which not exists in the source data but works like other fields. In simple words, these are the calculations within the pivot table. Excel gives us two options for calculation in a pivot table, one is calculated field & other is calculated item. In […]

Check it out now

How To Create An Area Chart In Excel

An area chart can help you to present data in a better way. It’s just like a line chart, but in an area chart, the area below the lines is filled with a color. You can use an area chart to make a visual trend comparison of your data and to present a trend line for a time period. In […]

Check it out now
1 22 23 24