A Four hour Advanced Learning workshop on Advanced Excel Table
This Advanced Excel Table training class to managing and analyzing a group of related data easier, and also you can turn a range of cells into a Microsoft Office Excel table (previously known as an Excel list). A table typically contains related data in a series of worksheet rows and columns that have been formatted as a table. By using the table features, you can then manage the data in the table rows and columns independently from the data in other rows and columns on the worksheet.
Practical examples, exercises & case studies with Q&A discussion sessions. The course is designed for practical Excel applications at participants“ works rather than theoretical notes. Presentation slides will be provided after course usage. Participants will go through with relevant examples that they can relate to their daily office works.
Contents of Training:
* What is an Excel Table?
* Benefits of Excel Table
* Preparing Data
* Creating an Excel Table
* Choosing Formatting Style
* Naming an Excel Table
* Rename an Excel Table
* Sorting & Filtering Data
* Remove the Filter Arrows
* Show/Hide Header Rows in a Table
* Show/Hide Totals in a Table
* Subtotal Function in Total Row
* Auto Expansion of Table Areas
* Refer to Table Column in Different Formulas
* Insert Slicer
* Convert Table Back to a Range