In an age now driven by "big data", we need to cut through the noise and present key information in a way that can be quickly consumed and acted upon making data visualization an increasingly important skill. Visualizations need to not only present data in an easy to understand and attractive way, but they must also provide context for the data, tell a story, achieving that fine balance between form and function. Excel has many rivals in this space, but it is still an excellent choice, particularly if it's where your data resides. It offers a wealth of tools for creating visualizations other than charts and the chart options available are constantly increasing and improving, so the newer versions now include waterfall charts, sunburst diagrams and even map charts. But what sets Excel apart is its flexibility, it gives us total creative control over our designs so if needed we could produce our own animated custom chart to tell the right story for our data.
À propos de ce cours
We expect that you have some background with Excel. You can move around the interface and create basic formulas.
Compétences que vous acquerrez
We expect that you have some background with Excel. You can move around the interface and create basic formulas.
Offert par

Université Macquarie
Macquarie is ranked among the top one per cent of universities in the world, and with a 5-star QS rating, we are recognised for producing graduates who are among the most sought-after professionals in the world. Since our foundation 54 years ago, we have aspired to be a different type of university: one focused on fostering collaboration between students, academics, industry and society.
Programme du cours : ce que vous apprendrez dans ce cours
Welcome and critical information
Data Visualizations using Conditional Formatting, Sparklines and Number Formats
This week we will explore a host of data visualisation tools that do not include charts. We will learn about conditional formatting, including custom conditional formatting using formulas, drop down lists, and macros. We will then move on to learning about sparklines, shapes, and custom number formats.
Mastering charting techniques
This week we will explore a range of options to visualise your data using charts. We will look at standard charts such as line charts, pie charts, and scatter charts – to help you visualise your data. We will also look at charts to add to your standard toolkit such as area charts, donut charts, and bubble charts – which will add that wow factor to your work.
Specialized charts
This week we will explore a range of innovative and creative charts – many of which are new to Excel. These charts include: hierarchy charts, waterfall charts, funnel charts, and geospatial charts. We will also look at customising and creating our charts when we look at population charts and gauge charts – giving you ideas to be innovative and creative.
Create an Interactive Dashboard Using Pivot Charts and Slicers
This week we take a turn into data analytics by exploring Pivot Tables. We will look at how to summarise data with Pivot Tables, as well as how to customise, group, sort, and filter pivot data. We will then look at performing calculations in Pivot Tables. Finally we explore Pivot Charts which help us visualise the data in our Pivot Tables.
Avis
Meilleurs avis pour DATA VISUALIZATION IN EXCEL
Excellent presentation, examples, and organization. Appreciate videos, transcripts, forum and creative corner ways to interact with other students around the globe.
Excellent! Learnt a lot skills in a well organized and paced course.
Foire Aux Questions
Quand aurai-je accès aux vidéos de cours et aux devoirs ?
À quoi ai-je droit si j'achète le Certificat ?
Is financial aid available?
What versions of Excel can I use?
D'autres questions ? Visitez le Centre d'Aide pour les Etudiants.