Microsoft Excel: Advanced Data Analysis and Visualisation
Develop your data science skills as you learn how to import, manipulate, analyse, and visualise data in Excel.
Duration
3 weeksWeekly study
5 hours100% online
How it works
Microsoft Excel: Advanced Data Analysis and Visualisation
Learn how to use Excel alongside industry experts
Though millions of people use Excel for their simple daily tasks, it’s also one of the most widely used solutions for analysing and visualising data. That’s because it now includes tools that enable the analysis of more data, with improved visualisations and more sophisticated business logic.
On this three-week course, you’ll get an introduction to the latest versions of these new tools, learning directly from an expert on the Excel Product Team at Microsoft.
Discover how to import data and perform data cleaning
You’ll start by learning how to import data from different sources in Excel to help you prepare for data analysis.
This knowledge will help you perform a variety of tasks including; data cleaning and pre-processing steps, creating data mash-ups, building your business logic in the Excel data model, and presenting the data with interactive visuals.
Explore visualisation and pivot tables
After learning how to prepare the data, you’ll find out how business calculations can be expressed using the DAX calculation engine.
Next, you’ll see how the data can be visualised and shared to the Power BI cloud service. You’ll then see how it can be used in dashboards, queried using plain English sentences, and even consumed on mobile devices.
This will help you understand how pivot tables, pivot charts, and slicers work together.
Hone your data science skills
By the end of this course, you’ll feel confident in using Excel to perform data analysis and visualisations.
Learning from the experts at CloudSwyft and from the Excel Product Team, you’ll develop essential data science skills to help advance your career.
Syllabus
Week 1
Course Introduction
About the Course
This activity introduces you to the course outline and learning outcomes, as well as information on navigating the course on the FutureLearn platform and your CloudSwyft Hands-On Labs.
CloudSwyft Hands-On Labs
In this activity, you'll complete your CloudSwyft Hands-On labs along with exercises to put the concepts from the previous activities into action.
Data Models and DAX in Excel
This activity introduces you to the Excel data model and DAX, which is a powerful language in Excel.
CloudSwyft Hands-On Labs
In this activity, you'll complete your CloudSwyft Hands-On labs along with exercises to put the concepts from the previous activities into action.
Week 2
Importing Data into the Excel Data Model
Importing Data: CSV Files
Welcome back to Week 2. This activity introduces you to importing data into Excel from a CSV file.
CloudSwyft Hands-On Labs
In this activity, you'll complete your CloudSwyft Hands-On labs along with exercises to put the concepts from the previous activities into action.
Importing Data: Databases and Multiple Files
In this activity, we'll introduce you to importing data directly from a database and multiple files.
Importing Data: Excel Reports
This activity introduces you to importing data into Excel from another formatted Excel report.
CloudSwyft Hands-On Lab
In this activity, you will complete your CloudSwyft Hands-On lab along with exercises to put the concepts from the previous activities into action.
Week 3
Data Analysis and Visualisation with Excel and Power BI
The DAX Language
Welcome to the final week of the course. In this activity, you'll learn about creating and formatting measures in Excel.
CloudSwyft Hands-On Labs
In this activity, you'll complete your CloudSwyft Hands-On labs along with exercises to put the concepts from the previous activities into action.
Visualising Data in Excel
This activity introduces you to basic visualisations in Excel. It also explores cube functions as a method for data visualisation.
CloudSwyft Hands-On Labs
In this activity, you'll complete your CloudSwyft Hands-On labs along with exercises to put the concepts from the previous activities into action.
Power BI
This activity introduces you to Power BI, the business analytics service by Microsoft.
Wrapping Up the Course
This activity takes you over the content covered in the course and gives you the opportunity to provide feedback.
When would you like to start?
Start straight away and join a global classroom of learners. If the course hasn’t started yet you’ll see the future date listed below.
Available now
Learning on this course
On every step of the course you can meet other learners, share your ideas and join in with active discussions in the comments.
What will you achieve?
By the end of the course, you‘ll be able to...
- Create a visual representation of data that easily understandable
- Identify which tools to use in Excel in aiding better analysis
- Explore Excel from a data visualization lens
- Interpret data for analysis and visualization
Who is the course for?
This course is designed for anyone interested in learning more about Excel analytics tools – whether you’re a novice user or a seasoned Excel user.
You don’t need any prior knowledge or experience to benefit from this course.
What software or tools do you need?
The upgrade version of this course will include all the required CloudSwyft Hands-On Lab practice environments to be used by students and learners on this course, powered by CloudSwyft. You will need a computer running Windows, Mac OSX or Linux, and a web browser.
Who developed the course?
CloudSwyft Global Systems, Inc.
CloudSwyft has partnered with the top global technology companies to deliver cutting edge digital skills learning across the modern workplace.
Ways to learn | Subscribe & save | Buy this course | Start learning today |
|---|---|---|---|
| Choose the best way to learn for you! | $349.99 for one year Automatically renews | $54/one-off payment | Free |
| Develop skills to further your career | Fulfill your current learning need | Try this course - with limits | |
| Access to this course | tick | tick | Limited to 3 weeks |
| Access to 1,000+ courses | tick | cross | cross |
| Learn at your own pace | tick | tick | cross |
| Discuss your learning in comments | tick | tick | tick |
| Certificate when you're eligible | Digital only | Printed and digital | cross |
Cancel for free anytime |
Ways to learn
Choose the best way to learn for you!
Buy this course
$54/one-off payment
Fulfill your current learning need
- Access to this course
- Learn at your own pace
- Discuss your learning in comments
- Printed and digital certificate when you’re eligible
Subscribe & save
$349.99 for one year
Automatically renews
Develop skills to further your career
- Access to this course
- Access to 1,000+ courses
- Learn at your own pace
- Discuss your learning in comments
- Digital certificate when you're eligible
Cancel for free anytime
Start learning today
Free
Try this course - with limits
- Limited to 3 weeks
Find out more about certificates, Unlimited or buying a course (Upgrades) | |||
Find out more about certificates, Unlimited or buying a course (Upgrades)
Learning on FutureLearn
Your learning, your rules
- Courses are split into weeks, activities, and steps to help you keep track of your learning
- Learn through a mix of bite-sized videos, long- and short-form articles, audio, and practical activities
- Stay motivated by using the Progress page to keep track of your step completion and assessment scores
Join a global classroom
- Experience the power of social learning, and get inspired by an international network of learners
- Share ideas with your peers and course educators on every step of the course
- Join the conversation by reading, @ing, liking, bookmarking, and replying to comments from others
Map your progress
- As you work through the course, use notifications and the Progress page to guide your learning
- Whenever you’re ready, mark each step as complete, you’re in control
- Complete 90% of course steps and all of the assessments to earn your certificate
Want to know more about learning on FutureLearn? Using FutureLearn
Get a taste of this course
Find out what this course is like by previewing some of the course steps before you join:
Do you know someone who'd love this course? Tell them about it...
More courses you might like
Learners who joined this course have also enjoyed these courses.
Browse more in IT & Computer Science
