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

Price 1,200 Tk + VAT
Mohammed Sobhan Chowdhury
  • Saturday, February 16, 2019

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

Next Stage/ Career
Price 3,000 Tk + VAT
Mohammad Mofidul Alam
  • Saturday, February 16, 2019

An NLP Approach in Communication.

Next Stage/ Career
Ridwanul Karim Chowdhury
  • 19 - 28 Feb 2019 (4 sessions)

Conflict is unwanted events, but frequently observable fact ...

Next Stage/ Career
Mohammad Asad Bin Yousuf
  • Friday, February 22, 2019

The objectives of the training are to provide the ...

Next Stage/ Career
Fresh Graduates and Job seekers