Microsoft Excel Crash Course training centre in Bangladesh

New
EMI EASY PAY

Microsoft Excel Crash Course

  • Date : Friday, August 30, 2019
  • Duration : Day(10.00 am-5.30 pm)
  • No. of Classes/ Sessions : Day Long
  • Class Schedule : Friday
  • Last Date of Registration : 28 August, 2019
  • Venue : A.K.Arcade (2nd Floor), 771, Sheikh Mujib Road, Choumuhoni Circle, Chattogram
  • 10% off on Bkash Payment (Lunch, Snacks and Handbook included on payment)

Introduction

Microsoft Excel is most widely used productivity tool in today’s corporate world. Day to day corporate analysis, reporting tools and applications are prepared with Excel. Corporate industry requires highest level of Microsoft Excel proficiency. To managing and analyzing a group of related data easier, we can turn a range of cells into an Excel Table. And a Pivot Table gathers all the data in an Excel spreadsheet and presents a summary of this data in a table. Charts and graphs are used to make information clearer and easier to understand. And Dashboard reports allow managers to get high-level overview of the business and help them make quick decisions. It will be an advantage for course attendees to learn practical and advanced usages of this mostly renowned Excel tools for their daily task in multiple ways.

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:

1. Some Basic Tools:

New Line in a Cell
Quick Access Toolbar
Merge Cell
Wrap Text
Text Alignment
Format Painter
Hide Gridlines
Freeze Panes
Spelling Check
View Multiple Workbooks
View Multiple Worksheets

2. Find & Select:

Find
Replace
Copy Visible Cells Only

3. Paste Special:

Skip Blanks
Transpose
Add or Subtract

4. Page Setup:

Header & Footer
Page Number
Date & Time

5. Format Cell:

Numbers to Text
Leading Zeros
Add Text

6. Cell References:

Hyperlink
Linking Data

7. Print:

Print Multiple Copies
Center on Page
Repeat Specific Row

8. Sort:

One Column
Multiple Columns
Sort by Color

9. Data Filter:

Filtering
Number and Text Filters
Date Filters
Advanced Filter
Remove Duplicates
Subtotal

10. Conditional Formatting:

Highlight Cells Rules
Top/Bottom Rules
Find Duplicates

11. Pivot Table & Chart:

Pivot Table
Pivot Chart

12. Count and Sum Functions:

Count
Countif
Countifs
Sum
Sumif
Sumifs
Count Blank/Nonblank Cells

13. Text Functions:

Join Strings
Partial Strings
Text to Columns
Lower/Upper Case

14. Lookup Functions:

VLookup
HLookup

15. Round Functions:

Round
Round Up
Round Down
MRound
Even & Odd

16. Logical Functions:

IF Function
AND Function
OR Function

17. Data Analysis:

Goal Seek
Data Consolidate

18. Mail Merge:

Why Mail Merge
Mail Merge Process
Final Mail Merge

Related Courses

Md. Rabiul Islam
  • 25 Jul - 25 Aug 2019

This Data Science course will cover the whole data life ...

IT
Course at Chattogram
Price 5,000 Tk + VAT
Fakharul Abedin (MCSA
  • 26 - 27 Jul 2019 (2 Days Long)

Hands on Training with Practical using of different tools ...

IT
Ashim Kumar Sikder
  • 27 Jul - 10 Aug 2019

Apex technology focus on developed single application that ...

IT
A. S. M. Shamim Reza
  • 30 Jul - 8 Oct 2019

This training will have Case Study, Hands-on LAB ...

IT
This is an exclusive training for them who have experience working with Microsoft Excel and would like to learn more about this.
Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.

Resource Person

Syed Saniat Ahmmad

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.