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…
Tag: file
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…
Excel Profit Margin Formula
Understanding the profit margin Profit margin is a ratio between a company’s revenue and income. Let me explain it in the following example….
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…
VBA Read a Text File
In this lesson, I’ll show you two methods you can use to read files. The first one will read a file line by…
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,…
Get the First x Characters in Excel
Whether you want to display the first x characters from the identification card or a zip code there are a few ways you…