Microsoft Excel Training Starter to Expert Level training centre in Bangladesh

New
EMI EASY PAY

Microsoft Excel Training Starter to Expert Level

  • Date : 19 - 20 April 2019
  • Duration : Day(9.30am-5.30pm)
  • No. of Classes/ Sessions : 2 Days Long
  • Last Date of Registration : 18 April, 2019
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.
  • 10% OFF at bKash or Online Payment (Certificate, Handbook and Lunch Included)

Introduction

Participants will experience a first look of the latest version of Microsoft Excel and get to play with the latest cool features.Get the most out of Microsoft Excel faster and easier than ever and be the Excel Guru of your work place. In this Course, maximize your productivity with the latest version of Microsoft Excel’s best tools and shortcuts. The course simplifies powerful features including the latest released feature along with PivotTables, PowerPivot, Sparklines, Goal Seek, Conditional Formatting, Report Automation, Subtotals, Tips and Tricks and many more!

Methodology

Interactive

Contents of Training:

1 Handling Text with Formulas and Built in Tools
• Drag the Fill Handler
• Joining Text
• Breaking Apart Text

2 Sorting & Filtering
• Data Preparation
• Sorting
• Filtering

3 Formulas Begins
• AutoSum Tricks
• Relative Versus Absolute Formulas
• Defining Names
• Tables and Table Formulas
• Goal Seek

4 Advance Formulas
• IF Formulas
• Sumifs
• VLOOKUP
• Date and Time

5 Charting and SmartArt
• Creating and Formatting a Chart
• Adding or Removing Chart Data
• Pie Chart Tricks
• Sparkline

6 Visual Impact
• Color Scales, Icon Sets, Data Bars
• Paired Bar Charts with Negative Data Bars
• Other Conditional Formatting Options

7 Pivot Tables
• Creating a Pivot Table
• Updating a Pivot Table
• Pivot Table Formatting
• Pivot Calculations
• Filtering Row Fields
• Top 10 Report
• Filtering a Pivot Table with Slicers
• Pivot Chart
• Slicers on Multiple Pivot Tables
• Building a Dashboards

8 Tips n Tricks
• Hyper Link
• Removing Duplicates
• Shrink Text
• Transposing Tricks
• Data Validation
• Switch Column Trick
• Insert Blank Rows
• Fit to One Page Trick
• Speak Cells
Bonus Segments for Demo if Time Permits

9 Business Intelligence Intro
• Introduction to PowerPivot
• Introduction to PowerQuery
• Introduction to PowerBI

10 Solver

Related Courses

S.M.Morshed Hemal
  • 25 Mar - 8 Apr 2019

Microsoft Excel is one of the most widely used tools for ...

IT
Titas Sarker
  • 27 Mar - 22 Apr 2019

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

IT
Md. Rabiul Islam
  • 27 Mar - 29 Apr 2019

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

IT
Md. Rabiul Islam
  • 28 Mar - 25 Apr 2019

Data Science is one of the lucrative job of the 21st ...

IT
This course is very useful for anyone who works in Excel. The target audiences are the Managers, Executives, Teachers, Developers, Students, and Researchers.
Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.

Resource Person

Md. Feroz Kibria

Soft Skills Trainer Specialist, Human Resources

Md. Feroz Kibria has been involved in training, coaching and consulting for more than 10 years with the intention of dramatically increasing profit, productivity and the performance of people.

After completing his MBA & BBA in HR & Accounting, Feroz joined the corporate world and gaining experience in Human Resources Management and training in diversified industries e.g. Telecommunications, Networking Accessories, Customer Services, Engineering and Automobiles.

He also completed a certificate course on “People Management Skills for Professionals (PMSP)” from IBA, University of Dhaka under MDP (Management Development Program).

Through the experience from the local and multinational businesses operating in Bangladesh, Feroz has gained a versatile knowledge for the requirement of core development areas to build the strongest career.

Today, Feroz trains a wide range of Soft Skills like Microsoft Office Programs (Excel, PowerPoint, Access, Publisher, Visio, Word, Outlook and others), Time Management, Strategic Compensation & Benefits, Financial Modeling, Leadership & Team Building, Corporate Etiquettes, etc.

Feroz is passionate in inspiring lives and transforming people. Because of the dedication, he is well known for his energetic and power-packed training sessions.

His quest for continuous Human & Talent Development promises highly energizing and power-packed training style. He helps clients transferring knowledge into ready-to-use skills.



Interactive