Excel Club Courses

Introduction to Excel Charts for Data Visualisation

0

Build charts and dashboards to visualise your data efficientlyAs the amount of data we use grows, gone are the days when you would stare at tables of endless data. Instead, we now use visualisations and charts to tell the story within the data.On this four-week course from The Excel Club, you will learn to work with Excel charts and visualisations, when to use each one and how to make it look great.Explore the basics of Excel chartsYou’ll start this course by looking at the fundamentals of charting in Excel, from inserting charts to working with the different elements of charts such as axes, labels, and gridlines.Once you have the basics, you’ll begin to explore the most common excel charts, including line charts, bar and column charts, and histograms. With each type of chart, you’ll delve into when you might use them and how best to optimise them for data visualisation.Discover less common charts for data visualisationWith so many different charts to choose from, most people will stick with the more well-known ones, but there are so many options that can portray your data more effectively.Week three of the course will take you through the charts that you don’t see as often. Whether it’s bubble charts, waterfall charts, or treemaps, you’ll cover how to create each type of chart as well as the limitations they may have in trying to showcase your message.Learn how to visualise data without chartsThe final week will guide you through visualisations that aren’t charts. You’ll discover how to work with boxplots, sparklines, and slicers and timelines, each with their own pros and cons.To wrap up this course, you’ll learn how to create a basic Excel dashboard in 20 minutes, from design and development to organising the data efficiently.This course has been designed for anyone looking to learn the basics of Excel charting and visualisation. These skills will help in any industry and role that works with data, helping you to present it effectively.To take part in this course you will need a version of Excel.You can sign up for a 30 day trial directly with Microsoft get Excel 365

How to Use Pivot Tables to Analyse Data in Excel

0

Create better dashboards to showcase your data insightsPivot tables allow you to quickly analyse and summarise large sets of data with ease. Using pivot tables and Excel visualisations, this data can be used to create interactive, informative dashboards.On this three-week course from The Excel Club, you will discover the basics of pivot tables and how to use them to create better dashboards that allow you to track trends and reveal important insights.Learn the fundamentals of pivot tablesYou’ll start this course by learning the basics of pivot tables, what they are, and how to insert them. There are many different ways that you can use pivot tables and you’ll explore different tools such as adding calculations, working with dates, and adding filters into your pivot Tables.During your first week, you’ll look at some practical examples in which you’re presented with data and, using pivot tables, you’ll need to effectively analyse it under specific parameters. This will help to cement your new knowledge of pivot tables.Explore pivot charts and GETPIVOTDATA in ExcelOnce you have the basics, you’ll move onto learning some advanced techniques for formatting pivot tables, as well as some tricks you can use on them.Building on your charting skills from the previous courses, you’ll explore pivot charts, a visualisation of a pivot table, and how to use them to easily showcase the data from your pivot tables.Discover how to set up and format pivot table dashboardsPivot table dashboards are a great way to present and provide unique perspectives on large volumes of data.This course will take you through the different steps needed to create a pivot dashboard in 20 minutes from start to finish. You’ll cover everything from creating the pivot tables and setting up charts, to slicers and timelines, and formatting your dashboard.This course is designed for anyone interesting in improving their Excel pivot table and charting skills.It will be especially useful for those working with data and wanting to analyse and present it in a clear and effective dashboard.To take part in this course you will need a version of Excel.You can sign up for a 30 day trial directly with Microsoft get Excel 365

Data Visualisation in Excel: Charting, Dashboards, and Pivot Tables

0

Master Excel charting and dashboard creationFrom Excel charts to effective dashboards, develop the skills to aid business decisions, track KPIs, and reveal data insights.

Design and Create Custom Dashboards in Excel

0

Develop Excel dashboards to present data effectivelyDashboards can be used at every level of an organization to provide value, track progress and KPIs, and reveal insights. Organisations are working with more data every day and the skills to create dashboards in Excel are in high demand.On this six-week course from The Excel Club, you will learn how to build dashboards from scratch before putting this knowledge into practice by creating three informative and visually stunning interactive Excel Dashboards.Get started with designing your custom dashboardThis practical course will guide you through Excel dashboard design and creation from start to finish.You’ll begin by discussing the three types of dashboard before covering the basics of creating them. You’ll also learn the top tips for creating a dashboard as well as the most common mistakes to avoid to ensure your dashboards work effectively.Learn how to automate your interactive dashboardAs you progress through this course, you’ll move through each step of the dashboard creation process, helping you to make your dashboards dynamic.Once you’ve learnt the step-by-step process, you’ll learn how to automate charts with named ranges, linking the data, using the offset function, and then linking charts to names. You’ll also focus on the INDEX function to use on subsets of data.Use VLookup and form controls to easily change your chartsBefore working on your own dashboards, this course will take you through how to change charts using different tools. You’ll explore setting up data validation and changing the charts with VLookup, as well as how to add form controls and implement them to change charts.In the final week of this course, you’ll create three different dashboards, each with their own data and objectives to help you put your new skills into practice.This course has been designed for anyone looking to enhance their Excel charting skills and learn advanced techniques to visualise data.With advanced Excel skills being in high demand, this course will help in any role or industry that handles and presents data.To take part in this course you will need a version of Excel.You can sign up for a 30 day trial directly with Microsoft get Excel 365

Excel Skills to Make an Impression

0

Discover Microsoft Excel skills to take your career to the next levelMicrosoft Excel is a mainstay of professional roles around the world. From administration, to finance, to data analysis, and beyond, wherever there are numbers, you are likely to find Excel.This course from The Excel Club is designed to help you take your Excel skills to the next level. Many users never get beyond the program’s most basic functionality, often feeling intimidated.The course is designed to provide a gentle introduction to intermediate and advanced Excel skills. You will go from creating simple lists to carrying out complex Excel data analysis in no time.The Excel skills you learn are sure to get you noticed, by both your current and prospective future employers.Learn how to use Excel pivot tables, IF statements, and moreOn this course, you will begin to explore some intermediate and advanced Excel functionality.Some of the Excel skills covered include using Excel IF statements and comparative operators, simple and complex lookups, pivot tables for data analysis and exploration, calculations using Excel’s new dynamic arrays, and more.With these advanced Excel skills, you will be able to approach complex tasks with confidence. You will be empowered to advance your career, either in your current role or in a new one.This course would be suitable for anyone seeking to advance their career by learning more advanced Excel skills.This includes those working or seeking to work in data analysis, advanced administration, or finance roles, among others.In this course we use Excel 365. You can download a free 30 day trial directly from Microsoft.