Change Date Format in Excel
There are many different date formats you can use to display a particular date. You can use short or long formats. Excel can…
Category: examples
Convert a Pivot Table to a Table
Pivot tables are useful to summarize data and quickly change the structure of the table. In this lesson, I’ll show you how you…
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…
Combine Cells in Excel
When you work with Excel, you probably have to deal with data separated into multiple rows. For example name, city, age, etc. But…
Freeze Rows or Columns in Excel
When you have a lot of columns or records inside a sheet, it can be difficult to compare one or more columns or…
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…
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…
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…
Display Date on the Horizontal Axis in Excel
In Excel, if you create a table, dates or times will be displayed on the X-axis. But there are situations where the data…
Power Query Merge Table Columns
In Power Query, you can merge multiple columns into a single one. This is what we are going to do in this lesson….