Learn Step by Step how to create Professional, Interactive Dashboards & Charts using Excel including:

Description

Learn Step by Step how to create Professional, Interactive Dashboards & Charts using Excel including:

1- Learning the Important functions that you need to know for building Dashboards such as VLOOKUP, HLOOKUP, MATCH, INDEX, OFFSET and others

2-Learning how to implement Interactivity tools such as Form Controls, Slicers, and others.

3-Learning Dashboarding techniques.

4- Building a Complete Excel Dashboard.

What you need before taking this course

• The will to learn !

• You need to be using Excel already, written a few formulas such as SUM and COUNT, know how to build a basic pivot table and insert a chart.

A Powerful Skill at Your Fingertips

Excel is a great tool for creating Interactive Dashboards. It is relatively cheap with high availability compared to other more expensive tools, so learning how to build dashboards will be a great addition to your skills, and you can showcase these skills almost anywhere because Excel is installed on millions of computers around the globe!

If you're already an Excel user and want to learn how to create Interactive dashboards using Excel, impress your employer and potentially earn a raise, then this course is for you!

What other students are saying about the course:

Andrew Adolph:

I feel so lucky to have come across udemy and then a course on excel dashboards. I have always loved car dashboards, just displaying the most important info.

Today's dashboard in the business sense is the presentation of key performance indicators (kpi) for decision makers.

I am hooked on this course, and practicing making better dashboards. Adbelrahman is there to answer questions. To beautiful dashboards...

Luke Best:

Thanks Abdelrahman for an excellent course!

I use Excel most days so thought I had a decent grasp on how it all works. How wrong was I! This course has been a real eye-opener into what is actually possible in Excel and techniques covering how to present data.

I found the course material and presentation (videos) very comprehensive with plenty of examples to work through and use as reference for the future when I apply it all to my work.

An Excellent course and would highly recommend.

Michael Diamond:

I was impressed with some of the information presented. I have taken various dashboard courses to find little gold nuggets and i found a bunch in this course. The instructor provided some new twists for creating dynamic ranges, for example. He didn't present the normal formulas that I have seen from different sites but came up with some new approaches which caused my eyes to grow wider. I felt I was gaining a deeper understanding how excel thinks and works. His presentation showed me that he put some thought and effort into the presentation and made an effort to bring me from a Joe to a Pro!

• Excel users who want to up their skills by learning how to create Interactive dashboards using Microsoft Excel.
• Accountants, Business, Financial, or Reporting Analysts, Stock or Forex Traders, Business Owners who want to build dashboards using Excel to monitor their business metrics or KPIs.
• This is NOT for Excel beginners, so you need to have used Excel before, written a few formulas (Such as SUM, COUNT and IF Functions) and know how to create pivot table,Insert charts and use Conditional Formatting.

Course content

• Introduction
  • Introduction
  • Leaving a Review and Providing me with Feedback
  • Data Preparation
  • UnPivoting Data Part 1 - Introduction and setting up Power Query
  • Unpivoting Data Part 2 - Unpivoting the data
• Must Know functions
  • VLOOKUP
  • HLOOKUP Function
  • VLOOKUP and HLOOKUP Exercise
  • THE MATCH Function
  • Match Function Exercise
  • ROW(),ROWS(),COLUMN(),COLUMNS() Functions
  • OFFSET Function- Basics
  • Dynamic Ranges with OFFSET Part 1 - Data Validation
  • Dynamic Ranges with OFFSET (Part 2) - Dynamic Charts
  • Offset Function Exercise
  • Dynamic Ranges with OFFSET Part 3 - Dynamically Expanding Ranges
  • INDEX Function Part 1 - Using it For Lookups
  • INDEX Function Part 2 - Creating Dynamic Ranges with INDEX
  • Index Exercise
  • The power to CHOOSE
  • Cool Application for the CHOOSE Function - Dividing your Dates into Quarters !
  • Choose Function Application Exercise
  • INDIRECT Function | Lookup Values Dynamically from different locations
  • SUMIF & SUMIFS
  • SUMIF & SUMIFS - Exercise
  • COUNTIF,COUNTIFS Functions
  • COUNTIF,COUNTIFS -Exercise
  • GETPIVOTDATA Function
  • GETPIVOTDATA Function - Exercise
  • Ranking Functions in Excel !
• Let's Talk Charts !
  • Performance against a Target Range
  • Performance Against Target Range - Exercise (5th of February 2016)
  • Vertical Bullet Charts
  • Vertical Bullet Charts - Exercise
  • Waterfall Chart
  • Waterfall Chart -Exercise
  • Pareto Chart
  • Pareto Chart - Exercise
  • Gantt Chart
  • Gantt Chart- Exercise
  • Speedometer Chart
  • Speedometer Chart - Exercise
  • Creating Map Charts!
  • Map Charts-Exercise
• Going Interactive!
  • Form Controls-Introduction
  • Form Controls-Buttons
  • The Checkbox
  • The Listbox
  • The Scrollbar
  • The ComboBox
  • Scrollbar Application - Scrolling List
  • Scrollbar Control Application -Scrolling Charts
  • The Spin Button
  • Option Buttons (Part 1) - How to Insert
  • Option Buttons (Part 2) - Formatting
  • Option Buttons (Part 3) - Group Boxes
  • Slicers - User friendly Filters !
  • Pivot Charts
• Dashboarding Techniques
  • Dynamic Date filters (Part 1) - using slicers and Timelines
  • Dynamic Date Filters Part 2 - Using Combo boxes and data validation lists
  • Dynamic Data Validation lists
  • Controlling Pivot Charts with Comboboxes
  • Capturing Slicer Selection in Formulas
  • Ranking Techniques Part 1 -Automatic Ranking of Values
  • Ranking Techniques (Part 2) - Dealing with Rank Ties
  • Ranking Techniques (Part 3) - Using Rank with Dynamic Ranges
  • Ranking Techniques Exercise
  • Rollover Technique (Part 1) -HYPERLINK Function
  • Rollover Technique (Part 2) - The Rollover Technique
  • Choosing different aggregation methods technique-5th of June 2016
• The Adventure Works Sales Dashboard
  • Adventure Works Dashboard (Part 1) - Overview
  • AdventureWorks Dashboard (Part 2)- (Analysis)
  • AdventureWorks Dashboard (Part 3) - Events
• Practice Practice Practice !
  • Dashboard Assignment - Airline Sales Dashboard !
• Bonus Lectures
  • Excel Tables (Part 1)
  • Excel Tables (Part 2)
  • Auto Refreshing Pivot Tables - Nice Trick!