Data Visualisation with

Microsoft Excel & PowerPoint

Transform Data into Insights through Compelling Visual Stories

  • Do you battle with too much raw data trying to make sense of key insights?
  • Are you having difficulties highlighting patterns, trends and takeaways?
  • Do you end up with overwhelming reports, and slides over filled with info?
  • Are you struggling to summarize data into dashboards?
  • Do you have challenges designing impactful charts to demonstrate findings?

If so, then the Data Visualisation with Microsoft Excel and PowerPoint course will help you.

MORE DETAILSDOWNLOAD BROCHUREPUBLIC WORKSHOPS

AT A GLANCE

Audience

This course is designed for people who present technical or financial information using a combination of MS Excel and MS PowerPoint.
Ideally, students should have attended the Excel Level 1 Foundation course.

Format ​

  • 1 day, instructor-led web-based virtual classroom sessions

What’s Included

  • Comprehensive Learning Guide and Resource Manual
  • Subscription to our monthly LearningLink e-newsletter

Take a Systematic Approach to Data Visualisation

Receive practical hands-on skills instruction to help you absorb proven techniques for a total data visualisation approach.

Reduce stress around presenting and persuade audiences.

This course will help you:

  • Enhance data visualisation skills to communicate insights from data using Excel and PowerPoint.
  • Improve presentation skills to persuade and engage audiences.
  • Optimise Excel analysis to interactively analyse, summarise and highlight valuable insights in Excel.
  • Systematically assess communication to meet audience needs and perspectives.
  • Boost confidence presenting data by acquiring strategies to prepare thoroughly to answer audience questions and reduce stress when presenting.
FULL OUTLINEMake an enquiry

What you will learn

Enhance data visualisation skills

Learn to create effective charts, graphs, tables, dashboards, and other visuals to communicate insights from data using Excel and PowerPoint.

Improve presentation skills

Master techniques for designing visually-appealing slides with graphics, animations and transitions in PowerPoint to persuade and engage audiences.

Optimise Excel analysis

Utilize tools like PivotTables, PivotCharts, conditional formatting, filtering and Sparklines to interactively analyse, summarize and highlight valuable insights in Excel.

Boost confidence presenting data

Acquire strategies to prepare thoroughly to answer audience questions and reduce stress when presenting by using Presenter View and linking slides.

Detailed Synopsis

The course is aimed at Intermediate users of Excel and PowerPoint who want to take a systematic approach to Data Visualisation and help identify areas for further study and practice. It covers a wide range of tools and techniques such as quick features in Excel, charts, conditional formatting, pivot table/charts and dashboards.

MS EXCEL

Selecting & Enhancing charts

  • Selecting the appropriate chart
  • Optimising the axis
  • Displaying a secondary axis
  • How to create smart looking charts
  • Using Effective Titles

Useful Short-cuts

  • Flash Fill
  • Quick Analysis
  • Copy and Paste
  • Using Sparklines

Using conditional formatting

  • Highlight-Cell rules
  • Top/Bottom rules
  • Data Bars
  • Colour Scales
  • Icon Sets
  • Manually adding your rules

Tables and Pivot Tables

  • Designing and formatting tables
  • Filtering Data
  • Using Slicers
  • Pivot Tables
  • Pivot Charts

MS EXCEL cont.

Dashboards

  • Guidelines for Dashboard Design
  • Using KPIs
  • Extracting the key data
  • Signpost to further development

MS POWERPOINT

Preparation

  • What questions does your data answer?
  • Be clear on the Presentation Perspective
  • Using Kiplings W1H to anticipate and prepare for questions
  • How data is understood in organisations and potential pitfalls

Graphics

  • Work on selecting the right visuals
  • Be skilled in using all of PowerPoints Communication Tools
  • Apply the principles of good design to your slides
  • Insert and format graphics
  • Using SmartArt and shapes

Animations and Transitions

  • Use appropriate animations to enhance presentations
  • How to get the best out of the animation pane
  • Use appealing transitions to create momentum and interest

Presenting the Data

  • How to take the stress out of presenting
  • Persuading the audience
  • The benefits and drawbacks of using Presenter View
  • Creating a Notes Page
  • Linking to Excel
  • Slidedocs and their uses
DOWNLOAD BROCHUREMake an enquiry

This technical training course is made available to you through our strategic partnership with “Professional Training Solutions Limited”. Thanks to this partnership we can deliver top-notch technical training for both beginners and experts.

Our technical training programs are tailored to help you keep up with the dynamic business environment through state-of-the-art training and continuous support. With our training, you can rest assured that your business is current and efficient.

Enquire about a course

Upcoming Public Courses

If you want to sample our courses, you can join the public ones with one or two colleagues from your organisation. These public courses are available to book now.  However, we recommend that the best way to learn is with courses that are tailored for you and your co-workers, because learning in groups is proven to be more effective. For large groups or teams, we recommend that you contact us to arrange a course that suits your needs and availability.

Public Courses available in September 2024–August 2025

  • September 19, 2024 (1 event)

    –
    September 19, 2024


    Who Should Attend:
    This course is for Excel users who want to unlock the benefits of AI through ChatGPT and Copilot integration to elevate their Excel skills and output. No prior experience in AI is required, as the course will cover foundational concepts.
    Format:
    • One full-day, instructor-led online training sessions
    Tools Provided:
    • Comprehensive Learning Guide and Resource Manual
    • Subscription to our monthly LearningLink e-newsletter
    For more details
    For more details of the course, please click here.
    To enrol on this course or to find out more
    Contact us today

  • October 17, 2024 (1 event)

    –
    October 17, 2024


    Who Should Attend:
    This course is for Excel users who want to unlock the benefits of AI through ChatGPT and Copilot integration to elevate their Excel skills and output. No prior experience in AI is required, as the course will cover foundational concepts.
    Format:
    • One full-day, instructor-led online training sessions
    Tools Provided:
    • Comprehensive Learning Guide and Resource Manual
    • Subscription to our monthly LearningLink e-newsletter
    For more details
    For more details of the course, please click here.
    To enrol on this course or to find out more
    Contact us today

  • November 6, 2024 (1 event)

    –
    November 6, 2024


    Who Should Attend:
    This course is designed for people who present technical or financial information using a combination of MS Excel and MS PowerPoint.
    Ideally, students should have attended an Excel Level 1 Foundation course.
    Format:
    • One full-day, instructor-led online training sessions
    Tools Provided:
    • Comprehensive Learning Guide and Resource Manual
    • Subscription to our monthly LearningLink e-newsletter
    For more details
    For more details of the course, please click here.
    To enrol on this course or to find out more
    Contact us today

  • November 14, 2024 (1 event)

    –
    November 14, 2024


    Who Should Attend:
    This course is for Excel users who want to unlock the benefits of AI through ChatGPT and Copilot integration to elevate their Excel skills and output. No prior experience in AI is required, as the course will cover foundational concepts.
    Format:
    • One full-day, instructor-led online training sessions
    Tools Provided:
    • Comprehensive Learning Guide and Resource Manual
    • Subscription to our monthly LearningLink e-newsletter
    For more details
    For more details of the course, please click here.
    To enrol on this course or to find out more
    Contact us today

  • December 3, 2024 (1 event)

    –
    December 3, 2024


    Who Should Attend:
    This course is for Excel users who want to unlock the benefits of AI through ChatGPT and Copilot integration to elevate their Excel skills and output. No prior experience in AI is required, as the course will cover foundational concepts.
    Format:
    • One full-day, instructor-led online training sessions
    Tools Provided:
    • Comprehensive Learning Guide and Resource Manual
    • Subscription to our monthly LearningLink e-newsletter
    For more details
    For more details of the course, please click here.
    To enrol on this course or to find out more
    Contact us today

  • December 17, 2024 (1 event)

    –
    December 17, 2024


    Who Should Attend:
    This course is for Excel users who want to unlock the benefits of AI through ChatGPT and Copilot integration to elevate their Excel skills and output. No prior experience in AI is required, as the course will cover foundational concepts.
    Format:
    • One full-day, instructor-led online training sessions
    Tools Provided:
    • Comprehensive Learning Guide and Resource Manual
    • Subscription to our monthly LearningLink e-newsletter
    For more details
    For more details of the course, please click here.
    To enrol on this course or to find out more
    Contact us today

  • December 18, 2024 (1 event)

    –
    December 18, 2024


    Who Should Attend:
    This course is designed for people who present technical or financial information using a combination of MS Excel and MS PowerPoint.
    Ideally, students should have attended an Excel Level 1 Foundation course.
    Format:
    • One full-day, instructor-led online training sessions
    Tools Provided:
    • Comprehensive Learning Guide and Resource Manual
    • Subscription to our monthly LearningLink e-newsletter
    For more details
    For more details of the course, please click here.
    To enrol on this course or to find out more
    Contact us today