Welcome to the Course

Welcome to the Data Analysis and Visualisation Using Excel course.

Every day millions of people use Excel for their daily tasks, whether it’s for number crunching, reporting, calculations – you name it. In this course, you’ll learn how to use Excel to perform data analysis and visualisations. You’ll learn how to bring data from other sources into Excel, perform data cleaning and pre-processing steps, create data mash-ups, build your business logic in the Excel data model, and present the data with interactive visualisations.

Whilst having an understanding of Excel analytic tools and experience working with data from databases will be helpful, we’re sure that everyone can follow this course. If you’re a novice user, ask questions in the discussions throughout the course. If you’re a more advanced learner or a seasoned Excel user, why not help your fellow learners?

Course Content

In this course, we’ll cover the following topics:

• Data Analysis in Excel
• Data Models and DAX in Excel
• Importing Data into Excel
• Visualising Data in Excel
• Power BI

Who is the Course For?

We welcome all learners! While you may find the understanding of Excel analytics tools such as Excel tables, pivot tables and pivot charts, and working with data from databases challenging, we’re sure that everyone can follow this course. If you’re a novice user, visit the discussion forum. If you’re a more advanced learner or a seasoned Excel user, stick around the discussion forum and perhaps help your fellow learners!

Course Schedule

This course is in a self-paced format. You can listen to the lectures and attempt the labs at your pace. You should aim to complete this course in 15 hours or 5 hours a week for 3 weeks.

Course Subscription

Your CloudSwyft Online Hands-On Lab session for this FutureLearn ExpertTrack course is free to use for 2 hours for your first 7 days with us on this learning journey.

Subscribe now (if you haven’t already) for this ExpertTrack and you’ll get an additional 12 Lab hour credits for this course for 1 month, along with your certificate of completion. You will get 12 hours more for another month of subscription thereafter.

Next up, you’ll learn about the FutureLearn platform and how to navigate the course, and you’ll be able to introduce yourself to your fellow learners. We hope you’ll have an enriching and engaging learning experience!