Category: examples

You can perform similar operations on dates and numbers because dates in Excel are nothing more than numbers in a date format. You…

When you work with Excel, you can switch between sheets by just clicking them. But when you have many of them, that you…

When you are working with data inside Excel worksheet, sometimes you need to delete the particular type of data. If you have a…

There are a few ways you can remove characters from cells in Excel. You can do it from the ribbon, using the formula,…

Deleting a value inside a cell is easy, just click a cell and press delete. But how you can delete a cell that…

Usually, we create Pivot Tables from tables, but you can also create a Pivot Table from the data inside another Pivot Table. In…

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,…