Category: examples

Filters in Excel are used to reduce the amount of data displayed inside a worksheet. Depending on whether you filter text, numbers or…

When you work with Excel, you probably have to deal with data separated into multiple rows. For example name, city, age, etc. But…

When you have a lot of column or records inside a sheet, it can be difficult to compare one or more column or…

Remove a table without formatting In this lesson, I’ll show you how you can remove a table. If you haven’t applied any formatting…

The Powershell Excel module is a way you can interact with Excel files. There is more than one Excel module you can choose…

After you create a pivot table with the date field, the date format is fixed. Even if you right-click the cell and choose…

In Excel, if you create a table, dates or times will be displayed on the X-axis. But there are situations where the data…

In Power Query, you can merge multiple columns into a single one. This is what we are going to do in this lesson….

Excel contains over one million rows – 1,048,576 to be exact. If your file is larger than that and you will try to…

A millisecond is a one-thousandth of a second. Normally when you work with Excel, you need Dates and Time with hours and minutes,…