Get 20% discount

Microsoft Excel 2013 - Learner to Professional

  • Date : 24 February - 10 March 2018
  • Duration : Evening(6:30 PM-9:30 PM)
  • No. of Classes/ Sessions : 4 sessions
  • Class Schedule : Friday and Saturday
  • Total Hours : 12
  • Last Date of Registration : 23 February, 2018
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.

Introduction

Microsoft Excel is most widely used productivity tool in today’s corporate world. Day to daycorporate analysis, reporting, tools and applications are prepared with Excel. Corporate industryrequires highest level of Microsoft Excel proficiency. Various departments like Finance &Accounts, Research & Development, Operations, Credit Management, Compliance, Admin &HR, Procurement, and Sales & Marketing etc. demand good command on Excel. It will be anadvantage for course attendees to learn practical and advanced usages of Excel for their dailyactivities. Excel allows us to accomplish a task in multiple ways which will be shown toattendees with Pros and Cons of the methods.

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:

Various Parts of the XL Window

Ribbon:
Tabs | Minimize the Ribbon | Customize the Ribbon

Range:
Cell, Row, Column | Range Examples | Fill a Range | Move a Range |
Copy/Paste a Range | Insert Row/Column | Hide Row/Column | Custom Lists | Comments

Some Other Relevant Tools:
New Line in a Cell | Quick Access Toolbar | Merge Cell | Wrap Text | Text Alignment | Format Painter | Hide Gridlines | Freeze Panes

Workbook:
Open an Existing Workbook | Close a Workbook | View Multiple Workbooks | Workspace

Worksheets:
Select a Worksheet | Rename a Worksheet | Insert a Worksheet | Move a Worksheet | Delete a Worksheet | Zoom | Split | Freeze Panes | View Multiple Worksheets | Spelling

Find & Select:
Find | Replace | Go To Special | Copy Visible Cells Only

Paste Special:
Skip Blanks | Transpose | Add or Subtract

Paste to .doc:
Embed | Paste Link

Page Setup:
Header & Footer | Page Number | Page Margins | Page Breaks

Format Cell:
Numbers to Text | Leading Zeros | Add Text

Cell References:
Relative Reference | Absolute Reference | Hyperlink | Linking Data

Contents of Training Import Data from Other Source:
From Access | From Web | From Text File

Print:
Print a Worksheet | Print Multiple Copies | Workbook Views | Center on Page


Protect:
Password to Open | Password to Modify | Mark as Final

Sort:
One Column | Multiple Columns | Sort by Color

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

Conditional Formatting:
Highlight Cells Rules | Top/Bottom Rules | Data Bars | Color Scales | Icon Sets | Find Duplicates

Data Validation:
Create Data Validation Rule | Input Message | Error Alert | Prevent Duplicate Entries | Product Codes | Drop-Down List | Dependent Drop-Down List

Tables:
Insert a Table | Sort a Table | Filter a Table | Total Row | Table Styles

Charts:
Create a Chart | Change Chart Type | Switch Row/Column | Chart Title | Legend Position | Data Labels | Column Chart | Line Chart | Sparklines

Pivot Table & Chart:
Pivot Table | Pivot Chart

Date & Time:
Year, Month, Day | Date Function | Current Date & Time | Hour, Min, Sec |
Time Function | DateDif | Weekdays | Last Day of the Month | Day of the Year

Count and Sum Functions:
Count | Countif | Countifs | Sum | Sumif | Sumifs | Count Logical Values | Count Blank/Nonblank Cells

Text Functions:
Join Strings | Partial Strings ( Left , Right , Mid ) | Text to Columns | Lower/Upper CaseLookup

Functions:
VLookup | HLookup | Match | Index | Choose

Round Functions:
Round | Round Up | Round Down | MRound | Even & Odd Logical Functions:
IF Function | AND Function | OR Function

Data Analysis:
Goal Seek | Data Consolidate

Macro:
Turn on Developer Tab | Command Button | Assign a Macro | Record a Macro

Mail Merge
Why Mail Merge | Mail Merge Process | Final Mail Merge

Related Courses

Md. Shahadat Hossain
  • 25 Jan - 27 Feb 2018

100% online job placement and online earning in Digital ...

IT
Samiul Huq
  • 26 - 27 Jan 2018 (2 Days Long)

Participants will experience a first look of the latest ...

IT
Price 20,000 Tk + VAT
Chowdhury Shahreaar Ekram
  • 28 Jan - 22 Feb 2018

IT
Mostofa Monower
  • 3 - 17 Feb 2018 (5 Evenings)

This training program builds upon advanced level knowledge ...

IT

Price: Tk. 6,000+VAT

(15% VAT is applicable in every purchase.)

Contact

9140345, 9117179 , 01811 487982, 01926 673098, 01847 069208

certificate@bdjobs.com

This is an exclusive for them who have experience working with Microsoft Excel and would like to learn more about creating dynamic reports and dashboards.

Resource Person

Syed Saniat Ahmmad

Mr. Syed Saniat Ahmmad has been working in the Department of Credit Administration & Compliance as an Assistant Manager in a leading Investment Bank which is a full-fledged merchant bank and a subsidiary of a leading NBFI for 7 years. Before starting his career at NBIF he had work in a local group as an Officer - Admin & HR 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 Honors & 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, Macros 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 Credit Risk Management (CRM), Credit Management & Debt Collection Strategies, Compliance & Associated Issues, Securities Laws of Bangladesh, Anti Money Laundering (AML), Effective Business Communication, Personal Excellence, 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.