examples Archives | Page 32 of 39

Decimal Places in Excel

If you want to add a decimal place in Excel, just follow these steps. This is the simplest way to increase or decrease…

In this lesson, I’ll show you how you can get table values and display them as percentages inside a pie chart. We are…

If you created a PivotTable, you probably noticed that changing values inside a table won’t change it inside the PivotTable. But instead of…

In a PivotTable, you can group different types of values. I’ve written an article about grouping dates in PivotTables, so this one will…

In Excel, you can group and ungroup PivotTable dates in order to make data more readable. You can group dates by seconds, minutes,…

If you like a particular table formatting, but at the same time you want to treat data as a range, you can do…

Sorting PivotTable is useful, especially when you have to deal with large amounts of data. There are a few ways you can sort…

If you work with Excel, you probably tried to hide some rows or columns. It’s especially useful when you don’t need them at…

Sometimes when you want to create a line chart, it doesn’t look the way you want. You want one set of values to…

In a PivotTable, you can create fields that will show you the percentage change of the previous value. This is especially popular in…