Category: examples

When you deal with data in a table, at the top there is usually a header describing columns. No problem here. But when…

Counting cells in Excel is easy, and most users know how to do it. But how about counting data by a group? It’s…

When you create a Pivot Table, Excel automatically chooses a data source for you or uses the source you selected. When the data…

You can use the Data tab on the Ribbon when you manipulate data. Options on this tab allow you to import, transform, sort,…

If you deal with a large amount of data, it’s often a good idea to manage your data efficiently. That’s why grouping is…

In this lesson, I’ll who you how to add the currency symbol (dollar sign to be exact) inside a worksheet. There are a…

The “><“ may seem at first as the not equal sign “<>”. But it’s not the case. Let’s see how this notation works…

The “–” is a double unary operator. It’s used to change the sign of the value twice. If you use them for numbers,…

By default, Excel sorts the Pivot Table column in alphabetical order. However, you can change the order manually in the desired way. This…

When people start creating their spreadsheets, they usually start from cell A1. If you try to print this document, you will notice, that…