Scribd Logo
Upload

Welcome to Scribd!

  • 31 views

    Data Visualisation With Excel Dashboards

    Uploaded by

    farah aqeel
    This one-day course aims to teach participants how to create effective dashboards in Microsoft Excel to present data visually. The course covers dashboard fundamentals, design considerations, customizing chart elements, advanced chart types including box plots and gauges, reporting with pivot tables and pivot charts, conditional formatting, and obtaining data with functions. Participants will learn through mini lectures and hands-on activities. The target audience is working adults and no certification or assessment is provided upon completion.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Data Visualisation With Excel Dashboards

    Uploaded by

    farah aqeel
    31 views2 pages
    This one-day course aims to teach participants how to create effective dashboards in Microsoft Excel to present data visually. The course covers dashboard fundamentals, design considerations, customizing chart elements, advanced chart types including box plots and gauges, reporting with pivot tables and pivot charts, conditional formatting, and obtaining data with functions. Participants will learn through mini lectures and hands-on activities. The target audience is working adults and no certification or assessment is provided upon completion.

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This one-day course aims to teach participants how to create effective dashboards in Microsoft Excel to present data visually. The course covers dashboard fundamentals, design considerations, customizing chart elements, advanced chart types including box plots and gauges, reporting with pivot tables and pivot charts, conditional formatting, and obtaining data with functions. Participants will learn through mini lectures and hands-on activities. The target audience is working adults and no certification or assessment is provided upon completion.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    31 views2 pages

    Data Visualisation With Excel Dashboards

    Uploaded by

    farah aqeel
    This one-day course aims to teach participants how to create effective dashboards in Microsoft Excel to present data visually. The course covers dashboard fundamentals, design considerations, customizing chart elements, advanced chart types including box plots and gauges, reporting with pivot tables and pivot charts, conditional formatting, and obtaining data with functions. Participants will learn through mini lectures and hands-on activities. The target audience is working adults and no certification or assessment is provided upon completion.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    Data Visualisation with Excel Dashboards

    Course Type : Non-Funded

    Course Objective

    This course aims to equip learners with the necessary skills and knowledge to create insightful and impressive
    management reports using the various tools in Microsoft Excel

    Course Outline

    Dashboard Fundamentals
    • What is a dashboard
    • Key characteristics of a dashboard

    Planning Considerations
    • Define information needs
    • Acquire and arrange data

    Dashboard Design Consideration


    • Dashboard Dos and Don’ts
    • Selecting appropriate tools
    • Determine chart elements and colour selection

    Customising Chart Elements


    • Format axia
    • Display/format data labels

    Advanced Chart Types


    • Box & whisker chart
    • Gauge or Speedometer chart
    • Histogram

    Reporting with Pivot Table and Pivot Chart


    • Insert and populate a PivotTable and PivotChart
    • Using Slicer
    • Update PivotTable data

    Conditional Formatting
    • Create, edit, delete rules
    • Use data bars, color scales and Icon Sets

    Advanced Excel Tools


    • Using range names
    • Create Drop-down list with data validation

    Obtain Data with Excel Functions


    • Use Lookup and reference functions
    • Use INDEX and MATCH functions
    • Database functions

    Create Excel Chart


    • Column/Bar charts
    • Line charts
    • Pie charts
    • Combination chart
    • Sparkline

    Methodology

    Mini lectures and practical activities

    Target Audience

    working adult

    Trainer

    To be assigned by SNEF :
    Contact us at 6827 6927 or trg@snef.org.sg to find out more.

    FAQ

    Course Fee Subsidy? Absentee Payroll Funding? Any Assessment(s)?


    No No No

    Any Certification? Refreshments Provided? Lunch Provided?


    E-Certificate from SNEF Yes No

    Complimentary Parking?
    No

    Course details
    Timing : 09:00 AM - 06:00 PM
    Format: On-site
    Location: 150 Orchard Road
    06-14,Orchard Plaza Type Full Fee (inclusive 8% GST)
    Singapore 238841
    Duration: 1 day Course Fee $ 345.60

    Course Runs: 04 Oct 2023 - 04 Oct 2023,


    03 Nov 2023 - 03 Nov 2023,
    01 Dec 2023 - 01 Dec 2023

    Register by visiting www.snef.org.sg > Training > Programmes & Courses >

    ENQUIRIES :
    Training Officer's Name : Christopher Oh
    Training Officer's Email : christopher_oh@snef.org.sg
    Training Officer's DID : +65 68276919
    Training Email : trg@snef.org.sg
    Training Hotline : +65 68276927

    You might also like