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

Prof. Islam Md. Hashanat
  • 25 Oct - 13 Nov 2018

Methods of instruction will include lecturing, simulation, ...

Next Stage/ Career
Price 5,000 Tk + VAT
Md. Osman Farhan Al Harun
  • 25 Oct - 6 Nov 2018

“English for Managers“ training program has ...

Next Stage/ Career
Price 5,000 Tk + VAT
Md. Nurun-Nabi
  • 26 - 27 Oct 2018

Participants will get a clear idea about how to learn ...

Next Stage/ Career
Price 1,200 Tk + VAT
M. Hifzur Rahman
  • Saturday, October 27, 2018

This course would focus on improving leadership techniques ...

Next Stage/ Career
Fresh Graduates and Job seekers