Select Page

## How to apply conditional formatting to Pivot Tables

Conditional Formatting is commonly used to highlight data fields to easily identify outliers, or narrow down the results. However, this feature works a bit differently when dealing with a Pivot Table. Pivot Tables are also dynamic elements, and conditional formatting...

## Function: TEXT

Excel TEXT function helps apply a certain formatting to a numeric value. You can think this function as an alternative to number formatting. In this guide, we’re going to show you how to use the TEXT function and also go over some tips and error handling methods....

## How to use format painter in Excel

The Format Painter is the life saver when you need to copy only the formatting settings from one section to the other in your spreadsheet. In this guide, we’re going to show you how to use format painter in Excel. The best part is, this feature is supported by pretty...

## How to format numbers in Excel with millions separators

Number Formatting feature in Excel allows modifying the appearance of cell values, without changing their actual values. Currency formatting with dollar signs (\$), or highlighting negative values with red are common examples. Another advantage of this feature is the...

## How to format numbers in thousands in Excel

Number Formatting feature in Excel allows modifying the appearance of cell values, without changing their actual values. Currency formatting with dollar signs (\$), or highlighting negative values with red are common examples. Another advantage of this feature is the...

## How to hide formulas in Excel using the Number Formatting feature

Number Formatting feature in Excel mainly allows you to change the appearance of cells without overwriting their contents. Currency formatting or highlighting colors are common examples. But that’s not all! You can also use this feature to hide the value of a...

## How to sum by week number

To sum by week number is a bit different than How to sum by month. Instead of finding start and end dates of date range, we focus on exact week number by using WEEKNUM function. Syntax =SUMIFS( range of values to sum, range of week number helper column, current week)...

## How to generate Excel month names

This article shows you how to generate month list by formulas and how to display Excel month names instead of actual date values. We will use DATE, YEAR and MONTH formulas as well as Number Formatting. Syntax =DATE( YEAR( previous date ), MONTH( previous date )+1, 1)...

## How to change number format in Excel chart

Excel charts are one of the most used and easy to understand data visualization tools. Excel provides many chart types as well as numerous personalization options. One of the cool features is the ability to change number format in Excel chart. Steps Double-click on...