CHARTS AND DASHBOARDS WITH MICOROSFT EXCEL. (DATA VISUALIZATION)

 

(Course Delivery:15-18 Hours, Online)

This course is designed for the professionals who use Microsoft Excel to create reports. Data Visualization with Chart can help quickly understand the Data and Analyse it. The course begins with basics of Data Visualization, Selection of appropriate Charts and Creating a Dynamic report with Charts & some useful Excel formulas.

PART-1         ABOUT MICROSOFT EXCEL

• Understand what EXCEL is and EXCEL’s journey so far.
• What is EXCEL used for, different scenarios.
• Office 365 Excel for Desktop Vs Excel Online.
• ‘Modern Excel’ architecture intro.

PART-2         DATA VISULAIZATIONANDYOUR TOOLBOX FOR DASHBOARDS.

• Data Visualization and Dashboard basics.
• Understanding what this course cover?
• Understanding your audience and user requirement.
• Discussion about your tools box:
  1. Assembling and preparing data for Dashboard reporting.
  2. Understanding the need to learn some Excel formulas & functions to make your Dashboard ‘dynamic & interactive’.
  3. Everything about Excel Charts.
  4. Do you really need to know Macros or VBA to create and distribute Dashboards?

PART -3        ASSEMBLING AND ORGANIZING YOUR DATA FOR CHARTS.

• Best practices for organizing your data.
• Bring everything together with lookup functions VLOOKUP, HLOOKUP and XLOOKUP.
• Introduction to Power Query & Combining, Merging data with Power Query.
• Determine the visualization and create a summary report for the chart ‘Source’.

PART -4        EXCEL CHARTS

• Chart Elements, Layouts, Styles and Options.
• Chart Formatting.
• Select your chart type. Secondary Axis, Create a Chart Template.
  • Bar & Column Chart
  • Pareto Chart and Histogram.
  • Line Charts and Trend Line.
  • Area Chart,
  • Pie Chart, Donut Chart
  • Scatter Plots and Bubble Charts.
  • Box and Whisker Charts.
  • Tree Maps and Sun Bursts.
  • Waterfall and Funnel Chart.
  • Radar Charts.
  • Stock Charts.
  • Geo-Spatial Maps.
  • Other Visualization ways –
    • Sparkline, Heatmaps and
    • Infographics with shapes.

PART – 5       DASHBOARDS

• What is a DASHBOARD report?
• Dynamic and Interactive reports.
• Key Performance Indicators or KPIs.
• Formulas: INDEX, MATCH, OFFSET AND COUNTA
• Project:  Creating Dynamic Dashboard using formulas and drop-down list.

PART -6        END OF THE COURSE SUMMARY AND CONCLUSION.