Advanced Excel Table training centre in Bangladesh

New
EMI EASY PAY

Advanced Excel Table

Introduction

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.

Methodology

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

Related Courses

M. Hifzur Rahman
  • Saturday, December 15, 2018

Learning from the course

Learning from the course ...

Next Stage/ Career
Price 1,200 Tk + VAT
Mohammed Sobhan Chowdhury
  • Saturday, December 15, 2018

This workshop has been designed for the Students, Fresh ...

Next Stage/ Career
Mohammad Salauddin
  • Friday, December 21, 2018

The definition of leadership varies in respect of different ...

Next Stage/ Career
Md. Jamal Uddin Jamy
  • 21 Dec 2018 - 5 Jan 2019 (6 Sessions)

Interactive lecture, PowerPoint presentation, question and ...

Next Stage/ Career
Fresh Graduates and Job seekers