Advanced Excel Table training centre in Bangladesh

New
Get 10% discount

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 5,000 Tk + VAT
Md. Nurun-Nabi
  • 31 Aug - 1 Sep 2018

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

Next Stage/ Career
Price 1,200 Tk + VAT
Mohammad Mofidul Alam
  • Saturday, September 1, 2018

Gives you insights of why people fail in interview

Next Stage/ Career
Md. Jamal Uddin Jamy
  • 1 - 21 Sep 2018 (6 Sessions)

The workshop is designed to teach non native students and ...

Next Stage/ Career
Price 3,000 Tk + VAT
Mohammad Mofidul Alam
  • Saturday, September 1, 2018

An NLP Approach in Communication.

Next Stage/ Career
Fresh Graduates and Job seekers