Advanced Microsoft Excel Certificate Course training centre in Bangladesh

New
EMI EASY PAY

Advanced Microsoft Excel Certificate Course

  • Date : 25 March - 08 April 2019
  • Duration : Evening(6:30 PM-9:30 PM)
  • No. of Classes/ Sessions : 5 sessions
  • Class Schedule : Monday and Wednesday
  • Total Hours : 15
  • Last Date of Registration : 24 March, 2019
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.

Introduction

Microsoft Excel is one of the most widely used tools for organizing, analyzing, modelling, and visualizing data. Proficiency with Microsoft Excel is a highly desired skill-set in today’s complex business environment, one that can position you way ahead of your peers. By this course, you’ll learn how to design sophisticated spreadsheets from scratch and perform complex calculations using advanced Excel features and techniques. It’ll enable you to solve a broad range of real-time business problems and help you propel your career forward.

How Participant will be Benefited

After completing this Advanced Excel course, you’ll find yourself competent using Microsoft Excel. This advanced excel certification course will help you:

 Master Excel Functions and Formulas that save time and increases productivity
 Cut hours of labor by using Pivot tables to analyze data
 Discover new tools to share your work
 Find new and more efficient ways to analyze data
 Tricks to produce professional charts and graphs
 Include diagrams in marketing reports and sales presentations to boost sales and readability
 Find new ways to visualize data
 Reduce workload each month by automating repetitive tasks by using macros
 Import data using Power Pivot
 Many useful tips & tricks

Methodology

Hands on Training with Practical using of different tools with real life example

Contents of Training:

1) Manage Multiple Workbooks
a) Modifying existing templates
b) Merging multiple workbooks
c) Managing versions of a workbook
d) Copying styles from template to template
e) Copying macros from workbook to workbook
f) Linking to external data

2) Prepare a Workbook for Review
a) Setting tracking options
b) Limiting editors
c) Opening workspaces
d) Restricting editing
e) Controlling recalculation
f) Protecting worksheet structure
g) Marking as final
h) Removing workbook metadata
i) Encrypting workbooks with a password

3) Manage Workbook Changes
a) Tracking changes
b) Managing comments
c) Identifying errors
d) Troubleshooting with tracing
e) Displaying all changes
f) Retaining all changes

4) Custom Data Formats
a) Creating custom formats (Number, Time, Date)
b) Creating custom accounting formats
c) Using advanced Fill Series options

5) Advanced Conditional Formatting and Filtering
a) Writing custom conditional formats
b) Using functions to format cells
c) Creating advanced filters
d) Managing conditional formatting rules

6) Custom Styles and Templates
a) Creating custom color formats
b) Creating and modifying cell styles
c) Creating and modifying custom templates
d) Creating form fields

7) Functions in Formulas

a) IF function in conjunction with other functions b) Utilizing AND/OR functions
c) Utilizing nested functions
d) SUMIFS, AVERAGEIFS, and COUNTIFS functions

8) Look up Data with Functions
a) Utilizing the LOOKUP function
b) Utilizing the VLOOKUP function
c) Utilizing the HLOOKUP function
d) Utilizing the TRANSPOSE function
e) Utilizing Index & Match function

9) Advanced Date and Time Functions
a) Utilizing the NOW functions
b) Utilizing the TODAY functions

10) Create Scenarios
a) Utilizing the watch window
b) Consolidating data
c) Enabling iterative calculations
d) Utilizing What If analysis tools including Goal Seek
e) Utilizing the Scenario Manager
f) Using financial functions

11) Advanced Chart Elements
a) Adding trend lines to charts
b) Creating dual axis charts
c) Creating custom chart templates
d) Viewing chart animations

12) Create and Manage PivotTables
a) Creating new PivotTables
b) Modifying field selections and options
c) Creating a slicer
d) Grouping records
e) Utilizing calculated fields
f) Formatting data & update
g) Managing relationships

13) Create and Manage Pivot Charts
a) Creating new Pivot Charts
b) Manipulating options in existing Pivot Charts
c) Applying styles to Pivot Charts
d) Advantage & disadvantages of Pivot Charts

14) Developer & Macro’s
a) Enable Developer Tab
b) Introduce Visual Basic (VB) editor
c) Relative Reference & Macro Security
d) Form Control
e) Active X Control
f) Manipulate Data with Form Control & Active X Control
g) Negatives of using Macro’s
h) Shortcut Keys for Excel

15) Q & A’s Session
a) Question & Answer Session
b) Any other topics requested by the Participants

Related Courses

Habibur Rahman
  • 22 Mar - 13 Jul 2019

Course Module: Module One: HTML-5 Module Two: ...

IT
Samiul Huq
  • 22 - 23 Mar 2019 (2 Days Long)

The course will take you from an Intermediate Level to a ...

IT
Muhammad Rabiul
  • 26 Mar - 14 Apr 2019

This course focuses on motion graphics and animation from a ...

IT
Titas Sarker
  • 27 Mar - 22 Apr 2019

The MikroTik Certified Network Associate (MTCNA) course was ...

IT
This course is aimed at end users who want to develop their skills so they can use advanced techniques to manipulate Excel data. Participants should have attended MS Excel 2013 Beginners course or have equivalent knowledge.

Entry to senior level managers in any industry Engineering/IT Graduates Management/Commerce Graduates Students aspiring for entry-level jobs in any industry

Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.

Resource Person

S.M.Morshed Hemal

Mr. S.M. Morshed Hemal is a dedicated Sales professional with strong interpersonal & analytical skills. He has been working in different industries for the last 8.2 years. He was last working in Philp Morris Bangladesh Limited as a Planning & Information Specialist under sales division. Before that, he was working at Coca-Cola International Beverages Private Limited (IBPL) & Robi Axiata Limited. Presently he is working as Teaching Center Operations Manager at British Council Bangladesh.

He has extensive work experience in Sales Operation, Sales Analysis & Reporting, Sales Management & Sales Automation. Before starting his career he was completed his MBA & BBA degree from American International University-Bangladesh (AIUB) in Accounting & Finance.

In addition, Mr. Hemal does provide professional training on MS Word, MS Excel, MS PowerPoint, MS Outlook, Dashboard Reporting, and Tableau in different corporate industry for last couple of years.

Hands on Training with Practical using of different tools with real life example