Get 10% discount

Data Analysis and Business Intelligence Dashboard in Excel 2007-2013

Introduction

These days almost any job requires data analysis & presentation of results. While anyone can put a list of values in Excel & sum them up, not everyone can do advanced analysis, create charts, make them interactive, summarize data intelligently, present output in an intuitive dashboard or slice & dice data using Excel. Having these vital skills can make you invaluable to your organization & expose you to new opportunities. Not to mention the amount of time, money & effort you can save by efficiently using Excel.

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 Microsoft Excel’s best tools and shortcuts. The course simplifies powerful features including PivotTables, PowerPivot, Sparklines, Goal Seek, Conditional Formatting, Report Automation, Tips and Tricks and many more! Get more things done faster with customized workbooks, the Quick Access Toolbar, and keyboard shortcuts…control and analyze data more effectively…communicate more visually with new charting tools and SmartArt…and plenty more! Just Attend the Course and You’ll master high-powered Microsoft Excel skills at your own pace–and get specific answers and solutions immediately, whenever you need them! For anyone who wants to master Microsoft Excel 2007/2010 fast.

How participants will benefit after the course:
It is widely agreed that close to 50% of Excel users leave 80% of Excel untouched. That is, most users don’t tap into the full potential of Excels built-in utilities. In this course we will explore those uncovered area on such fine manner that attendees can readily imply them in their regular work just after attending the program.

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:

Part 1: Handling Text with Formulas and Built in Tools
• 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

Part 2: Diving into Formulas
• AutoSum Tricks
• Relative Versus Absolute Formulas
• Tables and Table Formulas
• IF Formulas
• VLOOKUP

Part 3: Sorting & Filtering
• Data Preparation
• Sorting by Color
• Sorting by Weekday
• Filter by Selection
• Other ways to Filter

Part 4: Building BI Dashboard using Pivot Tables
• Use a Pivot Table to Summarize Detailed Data
• Your Manager Wants Your Report Changed
• Add or Remove Fields from an Existing Pivot Table
• Summarize Pivot Table Data by Three Fields
• Why Does the Pivot Table Field List Dialog Keep Disappearing?
• Update Data Behind a Pivot Table
• Automate PivotTable using Tables
• Kill Compact View
• Eliminate Blanks in the Outline Format of a Pivot Table
• Suppress Grand Totals in a Pivot Table
• Replace Blanks in a Pivot Table with Zeros
• Specify a Number Format for a Pivot Table Field
• Format Pivot Tables with the Gallery
• Create a Report That Shows Count, Min, Max, Average, Etc
• Limit a Pivot Report to Show Just the Top 12 Customers
• Filtering a Pivot Table
• Add Visual Filters to a Pivot Table with Slicers
• Building Your First Dashboard
• Building Dashboard Using the Data Model in Excel 2013 and PowerPivot to Join multiple Tables
• See Detail Behind One Number in a Pivot Table
• 50 Reports in 5 Seconds

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

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

Part 7: Recording Macros
• Displaying the Developer Tab
• Recording a Simple Macro
• Simplifying the Macro
• Keys to Successful Recording

Part 8: Tips & Tricks
• Removing Duplicates
• Shrink Text
• Transposing Tricks
• Insert Blank Rows
• Hide Data
• Important Sheet
• Data Validation
• Switch Column Trick
• Fill Blank Trick
• Print Small Selection
• Fit to One Page Trick
• Speak Cells

Related Courses

Price 11,000 Tk + VAT
Nusrat Jahan
  • 25 Apr - 28 May 2017

UX design is not just a fascinating field to get into, ...

IT
Price 18,000 Tk + VAT
Muhammad Rabiul
  • 27 Apr - 6 Jun 2017

This course has designed to become familiar with an ...

IT
Samiul Huq
  • 28 - 29 Apr 2017 (2 Days)

The course is separated in three Difficulties level- ...

IT
Abu Shams Mahmood Arif
  • Friday, April 28, 2017

NGOs and Development Organizations requires sound level of ...

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 ideal for data analysts, reporting & MIS professionals, business analysts, managers & dashboard makers.
Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.