Advanced Excel Table training centre in Bangladesh

New
Online Payment is Now Smarter, Easier, Safer

Advanced Excel Table

  • Date : Saturday, December 7, 2019
  • Duration : Day(2:00 PM-6:00 PM)
  • No. of Classes/ Sessions : Half Day
  • Class Schedule : Saturday
  • Total Hours : 4
  • Last Date of Registration : 5 December, 2019
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.

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

Course at Chattogram
Price 2,000 Tk + VAT
Mohammad Mofidul Alam
  • Friday, December 6, 2019

An NLP Approach in Communication.

Next Stage/ Career
Price 1,500 Tk + VAT
Half Day Course
Mahfujul Huq
  • Saturday, December 7, 2019

A Four hour Advanced Learning workshop on Real Estate Sales ...

Next Stage/ Career
Price 1,500 Tk + VAT
Half Day Course
Mohammed Sobhan Chowdhury
  • Saturday, December 7, 2019

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

Next Stage/ Career
Md. Jamal Uddin Jamy
  • Saturday, December 7, 2019

Business communication is a phrase that refers to ...

Next Stage/ Career
Fresh Graduates and Job seekers

Resource Person

Syed Saniat Ahmmad

Investment Banker

Mr. Syed Saniat Ahmmad has been working in the Department of Credit Administration & Compliance in a leading Investment Bank which is a full-fledged Merchant Bank and a subsidiary of a leading NBFI for 9 years. Before starting his career at NBFI he had work in a local group as an Admin & HR Officer for about 3 years. His extensive work experience are in Credit Administration, Compliance, Operations, Administration, HR, Customer Services etc.

Before starting his career he has completed his Honour's & Master’s degree in Management and MBA in Finance from East-West University.

In addition, Mr. Saniat does provide professional training on Capital Market Compliance, Financial Modeling, Dashboard Reporting, MS Word, MS Excel, MS PowerPoint, MS Outlook etc in corporate industry for increasing professionals required skills up to advanced level.

Last but not the least Mr. Saniat has gained adequate knowledge & skills by attending many trainings and workshops on Organizational Leadership Skills, Personal Excellence, Credit Risk Management (CRM), Credit Management & Debt Collection Strategies, Compliance & Associated Issues, Securities Laws of Bangladesh, Anti Money Laundering, Effective Business Communication, Management Information System (MIS) etc.

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.