Excel Dashboard and Interactive Reports (SBL KHAS)

Excel Dashboard

Microsoft Excel 2010/2013/2016 Dashboard and Interactive Reports (SBL KHAS)

CREATE POWERFUL DASHBOARD & ANALYSIS

About Excel Dashboard

An Excel Dashboard can be an amazing tool when it comes to tracking KPIs, comparing data points, and getting data-backed views that can help management make decisions also. An Excel dashboard is one pager (mostly, but not always necessary) that helps managers and business leaders in tracking key KPIs or metrics and take a decision based on it. It contains charts/tables/views that are backed by data. Excel dashboards and executive reports are powerful, fairly easy to design and a great way to improve your Excel and data visualization skills. Because of its flexibility, you can virtually design any dashboard in Excel exactly the way you, or the users, imagined. And, best of all, you may want to implement it yourself or consider it a prototype and ask IT to implement it.

OUTLINE

MODULE 1: EXCEL DASHBOARD

  • Intro To Excel Dashboards
  • Using The Proper Visualizations
  • Dashboard Creation Process

MODULE 2: DATA VISUALISATION TOOLS

  • Selecting the right chart
  • Chart Making Process
  • Formatting Tricks

MODULE 3: CREATING INTERACTIVE REPORTS

  • An Alternative To The VLOOKUP Function
  • Calculating Standard Deviation
  • Showing Data Dispersion With Error Bars
  • Variance Analysis Dashboard
  • Returning A Value-Based On User Input
  • Incorporating Controls
  • Incorporating Hyperlinks

MODULE 4 : ANALYSING DATA WITH PIVOT REPORTS

  • Creating a Pivot Report
  • Creating A Dynamic Range For Data¬†Expansion
  • Incorporating Visual Analysis
  • Adding Interactive Elements
  • Slicing & Dicing Data
  • Querying Pivot Reports

MODULE 5: AUTOMATING DASHBOARDS WITH FUNCTIONS

  • Offset Function
  • CountA Function
  • Structuring Your Data
  • Linked Textbox
  • Named Ranges & Formulas

MODULE 6: AUTOMATING DASHBOARDS WITH VBA

  • Basics of VBA & Macros
  • Incorporating macros in Dashboards
No announcements at this moment.

Be the first to add a review.

Please, login to leave a review
Add to Wishlist
Duration: 2 Days
Level: Intermediate

Archive

Working hours

Monday9:30 am - 6.00 pm
Tuesday9:30 am - 6.00 pm
Wednesday9:30 am - 6.00 pm
Thursday9:30 am - 6.00 pm
Friday9:30 am - 5.00 pm
SaturdayClosed
SundayClosed