Business Intelligence with MS Excel

  • Date : 03 - 04 February 2017
  • Duration : Day(9.30 am-5.30 pm)
  • No. of Classes/ Sessions : 2 Days Long
  • Last Date of Registration : 2 February, 2017
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.

Introduction

Data is exploding exponentially and now the world requires analyst to analyze them. Business Intelligence (BI) is the method for analyzing this data and presenting actionable information to help corporate executives, business managers and other end users to make informed business decisions.

Business Intelligence is the new buzz word. MNC and different companies are hiring professionals who understand data and BI.

Microsoft Excel is the most commonly used BI Tool in the market. In this Course, you will receive a healthy understandings of the Business Intelligence Concept and of course be a master in MS Excel. The course will also maximize your skill set with Microsoft Excel. The course simplifies powerful features like PivotTables, Charts, Formulae, PowerPivot, Sparkline, Conditional Formatting and many more!

The course is separated in three Difficulties level- Beginner, Intermediate and Advance. As the course progresses you will be introduces with Powerful Technics that will take you from Novice to Professional.How participants will benefit after the courseThis course will walk you through the world of business intelligence. You will learn BI Terminologies, Concepts and start building your own self service business intelligence platform using Microsoft excel immediately after the course completion. You be explored to many uncovered area of MS Excel that will help you to become more productive from day one.

Methodology

This will be an instructor led program delivered through hands on labs with real life example. Audience will taste a new level of experience by attending the course.

Contents of Training:

BEGINNERS EXCEL

Part 1: Introduction

• What is Business Intelligence (BI)?
• How excel is used as a Business Intelligence Tool?
• Understanding the BI Terminologies

Part 2: Understanding and Preparing the Data
• Data Preparation
• Sorting by Color
• Other ways to Filter
• Understanding Tables

Part 3: Text Handling Trick for Business Intelligence
• Drag the Fill Handle
• Create Your Own Series
• Joining Text
• Rapid Formula Copy
• Convert to Proper Case
• Formulas to Values
• Breaking Apart Text
• Parsing Fixed Width

INTERMEDIATE EXCEL

Part 4: Essential Formulas for Business Intelligence

• AutoSum Tricks
• Relative Versus Absolute Formulas
• IF Formulas
• Sumifs
• VLOOKUP
• Month()
• Text()
• Year()
• Day()
• Choose()

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

Part 6: Visual Impact
• Color Scales, Icon Sets, Data Bars
• Icons for Only a Subset
• Paired Bar Charts with Negative Data Bars

ADVANCE EXCEL

Part 7: Business Intelligence with Pivot Tables

• Creating a Pivot Table
• Changing a Pivot Table
• Pivot Formatting
• Drill Down
• Pivot Calculations
• Summarizing Dates
• Pivot Sorting
• Top 10 Report
• Filtering a Pivot Table with Slicers
• Slicers on Two Pivot Tables
• Connecting Slicers with multiple tables

Getting to know about Power BI Features of Excel
• Introducing Dashboards, Scorecards and KPIs
• PowerPivot: Extend the capacity of excel with PowerPivot
• PowerView: Explore amazing data visualization technique using these amazing new features
• PowerQuery: Finally!!! ETL is now available in Excel. We will explore the wonderful data merging tool

Part 8: Tips and Tricks
• Navigate Fast through Range workbooks and Worksheets
• Removing Duplicates
• Shrink Text
• Transposing Tricks
• Hide Data
• Important Sheet
• Data Validation
• Fill up in the sideways
• Switch Column Trick
• Fill Blank Trick
• Formula to Value
• F4 trick
• Format Part of Cell
• Copying Sheets
• Insert Blank Rows
• Pick from List
• Print Small Selection
• Fit to One Page Trick
• Speak Cells

Related Courses

Enamul Haque Sujon
  • 19 Jan - 21 Feb 2017

Tally is a most powerful, yet very simple and easy, ...

IT
Price 3,000 Tk + VAT
Mohammad Asad Bin Yousuf
  • Friday, January 20, 2017

This training is designed to take trainees from starter to ...

IT
Muhammad Arif-ur-Rahman
  • 20 - 21 Jan 2017 (2 Days)

Advanced Microsoft Excel 2007 & 2010 course to develop ...

IT
Price 3,000 Tk + VAT
Moshiur Rahman
  • Friday, January 27, 2017

Advertising on Facebook is easy for you and your customers. ...

IT

Contact

9140345, 9117179

workshop@bdjobs.com

Bdjobs.com Ltd.

19 th floor (East), BDBL Building (Old BSRS)
12 Karwan Bazaar
Dhaka - 1215

This course is very useful for anyone who works in Excel. The target audiences are the Managers, Executives, Teachers, Developers, Students, and Researchers.

Resource Person

Samiul Huq

He is the team lead of the Routing Team [A combine team from Marketing, Billing and Core Network] at NovoTel Limited. He is also Supervising the technical team of Revenue Assurance Department- taking care of technical related issues in the whole RA Value Chain including designing, preparing and .....

This will be an instructor led program delivered through hands on labs with real life example. Audience will taste a new level of experience by attending the course.


"this training will help me a lot to work more efficient in my regular job" Md. Shifal Alam.
"Trainer was excellent, Motivating, Helpful" Md. Mohsin Pathan
"It is really good hope it will enhance efficiency" Sheikh Rakbah.
"Excellent. hope to attend more training program like this" Noel Manna dey, Finance Manager, The Leprosy Mission International in Bangladesh
"I like the this training program. It is fruitful enough" Tasmia Noor
"Excellent" Mohibul Islam, Executive-Finance & Accounts, Rahimafrooz Superstores Ltd.
"This workshop is very much helpful for any excel related working environment" Azarul Islam,Senior Officer, National Bank of Pakistan
"It was an excellent training, very helpful & effective for me" tahmina haque
"It was an excellent training, very helpful and effective for me" Tahmina Haque
"IT was very relevant and effective"
"The workshop is effective and related with my work. I hope it will increase my capacity" Wahida Sharmin, Finance Executive, Novo Nordisk Pharma Private Limited.
"The workshop was excellent. It will increase the efficiency" Ashok Kumar Das, Head of Research, The Bangladesh Rating Agency Limited (BDRAL)