Pivot Table Value Filter
If you create a pivot table, you will notice that there is a little icon that allows you to filter data in rows,…
Tag: file
Swap Columns, Rows and Cells in Excel
Swapping columns or rows can be very annoying if done accidentally. But it can be a handy feature in Excel. There are really…
Percentage of a Total in Excel
If you want to calculate the percentage difference between the two numbers, also called the percentage of the total, you can use the…
New Line in Excel Cell
If you use Word, you know that you can enter a new line by pressing the Enter key. But when you try this…
Excel Logical Operators: Equal To, Not Equal To, Greater Than, Less Than
When you work in Excel, sometimes you may want to calculate data only if a particular condition is met. You can achieve this…
The Dollar Sign in Excel
The dollar sign ($) in Excel is used to create a locked cell reference. In some cases, locking cells is important, otherwise, you…
Check if a Value Is Between Two Numbers in Excel
You can use the IF function to check if a value is between two values. You can also combine IF and AND functions…
Bullet Points in Excel
It’s easy to add bullet points in Word. It’s a text processor that is designed to work with text and bulleted lists, so…
Convert Excel Data to Word Table
Depending on what exactly you want to copy, there are a few ways you can use to convert an Excel table to a…
Pivot Table Slicers
With PivotTable slicers, you can filter a PivotTable using visual buttons. Slicers also show the current filtering state, by greying out positions that…