Microsoft Excel - Learner to Professional training centre in Bangladesh

New

Microsoft Excel - Learner to Professional

  • Date : 27 October - 10 November 2021
  • Duration : Evening(7:00 PM-10:00 PM)
  • No. of Classes/ Sessions : 5 Sessions
  • Class Schedule : Monday & Wednesday
  • Total Hours : 15
  • Last Date of Registration : 26 October, 2021 ( within 5pm )
  • Venue : Online Virtual
  • (10% Off on Bkash or Online payment)

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
Learner Level

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
* Name Manager

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
* Date & Time
* Page Margins
* Page Breaks

Proficient Level

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

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

Import Data from Other Source:
* From Web
* From Text File

Print:
* Print a Worksheet
* Print Multiple Copies
* Center on Page
* Repeat Specific Row

Protect File:
* Password to Open
* Password to Modify
* Mark as Final

Sort:
* One Column
* Multiple Columns
* Sort by Color

Data 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

Professional Level

Redistricted Data Entry:
* Create Data Validation Rule
* Input Message
* Error Alert
* Prevent Duplicate Entries
* Drop-Down List
* Dependent Drop-Down List

Tables:
* About an Excel Table
* Benefits of Excel Table
* Preparing Data
* Creating an Excel Table
* Choosing Formatting Style
* Sort & Filter Data
* Show/Hide Total Row
* Insert Slicer
* Convert Table Back to a Range

Charts & Graphs:
* About Charts
* Benefits of Charts
* Sort Data Before Charting Chart
* Creating a Chart
* Change Chart Type
* Switch Row/Column
* Chart Title
* Legend Position
* Data Labels
* Display/Hide Gridlines
* Remove Noise
* Don`t Make People Head Tilt
* Column Chart
* Bar Chart
* Line Chart
* Pie Chart
* Area Chart
* Combination 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 Case

Lookup 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

Price 3,000 Tk + VAT
Engr. Mohammad Hasibul Haque
  • 4 - 16 Nov 2021 (4 Sessions)

he goal of the course is to increase knowledge and ...

IT
Price 3,000 Tk + VAT
Enamul Haque Sujon
  • Thursday, November 4, 2021

After completing this course on can work as Independent ...

IT
Md. Feroz Kibria
  • 19 - 20 Nov 2021 (2 Sessions)

Having good spreadsheet skills therefore gives you the ...

IT
Syed Saniat Ahmmad
  • 15 - 27 Dec 2021 (4 Sessions)

Practical examples, exercises & case studies with ...

IT
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

Industrial & Financial Consultant

Mr. Syed Saniat Ahmmad has been working at his own consultancy firm Strategic & Financial Consultancy Services (SFCS) as a Managing Director; providing various services e.g. Project Feasibility Study, Prepare Project Profile, Industrial & Corporate Advisory, Financial Advisory & Advocacy, Strategic Marketing Planning, Organization Restructuring, Management Restructuring, Prepare Business Loan Proposal etc.

Before starting his business career he obtained more than 13 years of working experience in different business organizations like LankaBangla, Sigma Capital, Northern Group etc. His extensive work experience are in Credit Administration, Compliance, Operations, Administration, HR, Customer Services etc. Moreover, he is a renowned Industrial & Financial Consultant in the arena of Industrial & Financial sector.

Before starting his career he has completed his Honor’s & Master’s degree in Management and MBA in Finance & Banking.

In addition, Mr. Saniat does provide professional training in different Training Institute, Corporate Houses and Bank & NBFI’s to strengthen the Interpersonal Skill, Management Skill, Business Skill, Financial Data Analysis, Financial Modeling etc for increasing professionals required skills up to the 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.



social link fb social link fb social link fb