How to filter a table in Excel

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

Posted On

Remove a table in Excel

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…

Posted On

Excel Powershell

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

Posted On

Pivot table format date

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

Posted On

Open large CSV in Excel

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

Posted On

Milliseconds in Excel

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

Posted On