Two Sets of Data in Excel Chart
Usually, when we create a table we use one set of data. But you may find yourself in a situation when it’s not…
Category: examples
Turn on/off the Quick Analysis Feature in Excel
Quick Analysis Tool is normally present in the bottom-right corner of your selection. If you want to turn on/off the Quick Analysis feature,…
Pivot Table Field List Missing in Excel
After you create a pivot table, you can accidentally close the field list. If you click the pivot table it won’t appear. It’s…
Icon Exclamation Mark in Excel
Excel and many other programs use icons to visualize the file extension. If you see an icon with an exclamation mark on it,…
Format Numbers to Thousands and Millions in Excel
If you have a very big number or a very narrow cell, you probably want to format your number in a way that…
Convert XLSX File to CSV in Excel
The CSV (Comma separated file) is a great way to store data. You can open CSV files in a simple editor because they…
Select Data for a Chart in Excel
To create a chart you have to choose at least one column or row. But in practice charts consist of multiple columns or…
Pivot Table Row Labels Side by Side
If you use pivot tables there is a big chance that you want to place data labels side by side in different columns,…
Delete Rows With Specific Text
For this lesson, we are going to use the following example. The data don’t have to be highlighted. I did it so we…
Delete Calculated Field in the Pivot Table
Remove the calculated field from a pivot table.