Excel Level 4 Dashboards

Start Date 13/02/2024, 09:30 AM
End Date 14/02/2024, 12:30 PM
Where? Online

Imagine training logo for ECMS Courses

-

Imagine Training joins ECMS for a two part course in Microsoft Excel Level 4 Dashboards, split between 2 half days. The first part of the course will be delivered on Tuesday 13th February 2024 at 09:30am - 12:30pm and the second part on Wednesday 14th February 2024 at 09:30am - 12:30pm. 

With 10 years experience of successfully delivering online training, Imagine Training could help you learn essential skills for business. Trainers use the internet to deliver our training courses, direct to your desktop. Electronic training manuals help you retain what you learn and you can interact with us in the session and ask questions, watching the screen on your desk instead of the projector screen in your training room.

This TWO HALF DAY course is specifically designed for office users, managers, accountants and data analysts. Delegates on this course should have existing advanced knowledge of Excel, and we will turn you into an Excel expert.

Pre-requisites: Delegates should have completed up to and including Excel Level 3 skills, (Advanced formulas) or equivalent experience, to ensure you can participate in this training.

These skills are not difficult to learn but you need a firm foundation in the basics so you can get the most from this course.

  • The differences between Dashboards & Reports Questions before you start
    Dashboard design principles
    Golden Rules
    Formatting numbers effectively
    Custom Number formats
    Useful Formulas for Dashboards
    Data tables
    Charts
    Sparklines
    Charts that show trending
    Side-by-side comparison charts
    Secondary axis
    Conditional Formatting
    Using Symbols to enhance Reporting
    Camera Tool
    People graphs

 

  • Pivot Tables
    Creating
    Sorting
    Filtering
    Re-arranging
    PivotCharts
    Issues with file size
    Pivot Table reports
    Interactivity with slicers
    Dynamically rearranging pivot table data
    Grouping & bucketing data
    Showing performance against target
    Macros
    Useful macros for dashboards
    Navigation buttons
    Form Controls
    Time slicers
    Protecting your dashboards
    10 Questions before distributing your dashboard

Course / Webinar & Seminar delivery is supported by the ECMS.  By booking onto the short course you are agreeing to share your data with ECMS and with the Training Provider.  The ECMS will collect limited and specified personal information to enable it to deliver business support services, to comply with its funding obligations and to better understand its community so that it can meet the needs of clients with a view to continually improving services.  For further information please view the ECMS Privacy Notice (Please request a copy from ecmsenquiries@wlv.ac.uk)