Get 20% discount

Microsoft Excel for Bankers

  • Date : Friday, December 1, 2017
  • Duration : Day(9.30 AM-5.30 PM)
  • No. of Classes/ Sessions : Day Long
  • Last Date of Registration : 30 November, 2017
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.
  • 20% OFF @ bKash Payment

Introduction

Banking industry requires highest level of Microsoft Excel proficiency. Banking departments like Finance, Accounts, Risk, Credit, Sales, Marketing, Project, Operations, HR, Compliance, Reporting, MIS, Product, Research, Technology etc. demand good command on Excel. It will be an advantage for course attendees to learn practical and advanced usages of Excel for their daily BAU activities.

Methodology

Office Productivity Series - Microsoft Excel is designed for practical applications at works rather than theoretical notes. Participants will go through with examples that they can relate to their office or educational works.

Contents of Training:

DAY 1

BREAKING THE EXCEL FEAR

Keyboard Shortcuts

Sort, Filter and Advanced Filter
Sort numbers and words with single or multiple columns(level)
Text and Number filters with Fuzzy Match, Top 10 and above average items
Date filtering with Days, Weeks, Months, Quarters and Years
Filter by cell Background color or Font color

Charts
Working with Chart Components (Axis, Categories, Series, Legend)
Resizing, Moving and Copying Charts
Formatting and Styling Charts with 2D, 3D and Round effect
Using multiple combination chart types in a single chart
Creating Column, Line, Pie, Bar, Area and Scatter Charts

PivotTable
Arranging Pivot Fields in Report Layouts (Row Label, Column Label, Values)
Grouping and comparing Dates by Month, Year, Quarter and Days
Working with Report Filter options
Subtotalling and Counting data using pivot table
Analyzing Difference, Growth and % of Total with pivot
Working with Subtotal, Row Total and Grand Total options
Generate multiple sub-report pages from master report
Formatting Number, Date and Text
Time saving tips for pivots with large data source

Functions (Math)
Summarize data with SUM and AVERAGE function
Counting total numbers or texts with COUNT-COUNTA function
Finding smallest and largest values with MIN- MAX function
Rounding decimal numbers

Functions (Text and String)
Convert texts to UPPER, LOWER or PROPER case
Join multiple cell values with CONCATENATE - &
Break or extract a portion of text with LEFT-MID-RIGHT function
Finding total number of characters in a text

Functions (Lookup)
Lookup vertically using VLOOKUP

Functions (Date)
Construct a Date from partial Day, Month and Year values
Automatically update and show today's Date
Convert month number into month name
Calculate Addition and Difference between two Dates
Show the Weekday Name of a Date

Techniques
FlashFill to fill out data based on an example or pattern
Powerful Auto Fill Handle techniques for Numbers and Dates
Technique for Running Total or Cumulative Total

Price: Tk. 3,500+VAT

(15% VAT is applicable in every purchase.)

Contact

9140345, 9117179 , 01811410862, 01811 487981

workshop@bdjobs.com

Present and future Bankers
Target Departments
Finance, Sales, Marketing, Credit, Marketing, Accounting, Project, Human Resources, Administration, Operations, Analytics, MIS, Technology etc. departments who use Excel for their BAU activities.
Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.

Resource Person

Abu Shams Mahmood Arif

Associate Director

Mr. Shams has been working in a leading multi-national bank for several years. His extensive work experiences are in Business Analytics & MIS, Process Re-engineering & Automation, Business Research & Development and Project Management.
He has graduated from North South University. After that he completed his MBA. His major accomplishments and contributions are Business Operations Analytics, BOLD (Six Sigma Initiative), CBS (Core Banking System), BEFTN (Bangladesh Electronic Fund Transfer Network). .

He has been a reputed public and corporate trainer for several years on subjects like Management Information System(MIS), Financial Analysis & Modeling, MS Excel, Macros & VBA, MS Access, MS PowerPoint, MS Word and MS Outlook up to advanced level.
For last several years, he has been a reputed public and corporate trainer on subjects like Business Analytics, Financial Analysis & Modeling, MIS, MS Excel, Macros & VBA, MS Access, MS PowerPoint, MS Word and MS Outlook up to advanced level.

Courses from this trainer 117

Office Productivity Series - Microsoft Excel is designed for practical applications at works rather than theoretical notes. Participants will go through with examples that they can relate to their office or educational works.