8 AMAZING BENEFITS OF USING EXCEL TABLE

2 years ago
150

This video showcases the useful features of Table in MS Excel. After watching this, you’ll find out that Table does not only organize and structure your data. It also helps to expedite your work in many ways.
With just two clicks of the keyboard shortcut, you’ll have a formatted table for your data.

As soon as you have the table, you can do the following:
• Easily filter the information that you want to display.
• Quickly add or remove rows or columns with the use of the resize handle that comes along with the table.
• Automatically add a formatted column when you type a text right beside the table and a formatted row when you type a text right below the table.
• Quickly transfer the whole table.
• Create a formula in one cell and automatically fill the other cells in the column with the same formula.
• Display a drop-down list of various commonly used formulas or calculations by creating one formula right below the table. With the drop-down list, you can easily do other calculations.
• Swiftly hide or show the row containing the total.
• Easily change the format or choose other formatting options.

So, this one excel function can offer you several ways to expedite you work and at the same time help you create a high-level report.

Watch and try it!

Loading comments...