In this course, we focus on the specific functions, formulas, and tools that Excel has to help conduct business or data analysis. We take you on a no-nonsense journey to teach you how to use them.
Read more
In this course, we focus on the specific functions, formulas, and tools that Excel has to help conduct business or data analysis. We take you on a no-nonsense journey to teach you how to use them.
In this course, we focus on the specific functions, formulas, and tools that Excel has to help conduct business or data analysis. We take you on a no-nonsense journey to teach you how to use them.
We start by looking at how to take raw data and prepare it for analysis. After that, we look at a number of tools and functions that can be used to conduct analysis such as Pivot Tables, before moving onto how to display data in the most meaningful way using charts, Pivot Charts, Slicers and so much more. Finally, we move onto some more advanced techniques designed to aid forecasting and using existing data to predict future trends.
This course also includes practice exercises so you can immediately put into practice the new data analysis techniques that you learn.
In this course you will learn:
How to merge data from different sources using It's also relevant to those using other, recent versions of Microsoft Excel including Excel
Did you know?
Simon Sez IT teaches all sorts of software, including:
- Microsoft Excel
- Microsoft PowerPoint
- Microsoft Word
- Microsoft Project
- Microsoft Outlook
- QuickBooks
- Photoshop Elements
- Web Development Languages
- And so much more.
Here's a deal for you
UDEAFNULP2024
Good to know
Save this course
Save
Activities
Create a data visualization dashboard
Show steps
Creating a dashboard from scratch will force you to apply the skills you learn in the course in a practical and meaningful way.
Show steps
-
Gather and prepare your data
-
Design your dashboard layout
-
Create your visualizations
-
Publish and share your dashboard
Practice using Pivot Tables
Show steps
Solidify your understanding of Pivot Tables and improve your data analysis skills.
Browse courses on
Pivot Tables
Show steps
-
Create a Pivot Table from scratch
-
Add and remove fields to the Pivot Table
-
Customize the Pivot Table layout
Show all two activities
Create a data visualization dashboard
Show steps
Creating a dashboard from scratch will force you to apply the skills you learn in the course in a practical and meaningful way.
Show steps
- Gather and prepare your data
- Design your dashboard layout
- Create your visualizations
- Publish and share your dashboard
Practice using Pivot Tables
Show steps
Solidify your understanding of Pivot Tables and improve your data analysis skills.
Browse courses on
Pivot Tables
Show steps
- Create a Pivot Table from scratch
- Add and remove fields to the Pivot Table
- Customize the Pivot Table layout
Career center
Quantitative Analyst
Operations Research Analyst
Business Intelligence Analyst
Market Research Analyst
Data Scientist
Marketing Analyst
Data Analyst
Risk Analyst
Product Manager
Business Analyst
Financial Planner
Project Manager
Accountant
Software Engineer
Financial Analyst
Reading list
Save
Save
Share
Similar courses
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
