Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Practical Excel data analysis skills – Excel 2010, 2013,2016

Excel 2010, 2013, 2016: Hands-on Excel data analysis skills for business analyst, small business owner, startup founder
3.8
3.8/5
(47 reviews)
1,399 students
Created by

7.0

CourseMarks Score®

5.8

Freshness

6.8

Feedback

7.9

Content

Platform: Udemy
Video: 5h 2m
Language: English
Next start: On Demand

Table of contents

Description

If you want to be a great manager, a competent business analyst, a successful start-up founder, this course will help you gain real Excel skills and confidently put it to work right away after few hours. This course will also be perfect for a developer who wants to get to high level Excel skills in a short time. This course covers all must-have Excel skills to work effectively with Excel. The information in this course is prepared from more than 10 years of my professional and teaching experience using problem-solving approach to help you learn how to “think” in Excel and start doing simple analysis in Excel right away.
If you have never work with Excel before, you might wonder whether learning Excel even necessary. I can assure you that the skills you learn in this course will come handy in your work and life at some point. This course will help you understand the power of Excel in a simple, concise way.
In today’s world, data is everywhere. However, they often exist in charts or reports for departmental tracking purpose, not for your tasks. Therefore, the ability to handle data in an efficient way to identify, isolate and trouble shoot problem in data will determine your success at work. 
Have you ever want to dig deeper into the data but suddenly realize that you don’t know the necessary tools? Do you want to be able to effortlessly draw insights from data using Excel? Do you feel powerless because you have to rely on other people to take the data for you? Do you feel frustrated because the data or information given to you is not enough to draw any concrete conclusion? Do you want to improve your productivity at work using Excel? Do you want to take control of your job and be confident in whatever environment you are in by a thorough data analysis. Then you are in the right course.
Welcome to the most practical Excel course on Udemy! GAIN control of any situation with effective data analysis!
 You will be confident in using Excel on your own to process data for your analysis. In just a few hours you will go from beginner to advanced Excel level in data analysis. The course will provide you with all the essential Excel skills to build on.
This course takes the problem-solving approach to introduce to you all the essential features of Excel to handle data. It is designed for the busy professionals and students who want to get the most Excel skills and knowledge out of their valuable time. Learn the essential Excel skills from an Excel expert, who had applied the skills on the job. You will get to the important Excel tools and functions quickly, with adequate explanation and useful examples.  
Everyone is busy. This practical Excel course will be the course you finish. It takes you from completely beginner level, with explanation about how to save an Excel file, to advanced Excel data analysis functions such as PIVOT TABLE, PIVOT CHART, Excel VLOOKUP, Excel INDEX and MATCH function in 2 hours. Each lesson is accompanied with an exercise to ensure you have enough Excel practice. And the quiz help you solidify your skills to think in Excel. Your time is valuable, and Excel should be made easy for you to learn in a short time. 
At the end of the course, you will be able to use Excel to answer 15 analysis questions and more on a data set with thousands of rows. You will also learn how to create interactive dashboard for yourself. You will no longer feel intimidated by a large Excel spreadsheet without knowing where to start working. You will learn to think analytical and put your thinking to work with Excel essential skills. Real Excel skills that you can build upon.
The beauty of working with Excel is not how many Excel functions you have learned. But how many Excel functions you remember and able to use at any moment. Learn the most important Excel functions and show your Excel skills off to your colleagues and bosses right away. 
The instruction in this course is for Excel 2016, it also works for Excel 2010 and 2013. 
You will learn Excel skills by solving 15+ business analysis problems from an online retailer company such as:
– Summarize data by region
– Looking for the best/worst location and product
–  Analyze sale pattern
– Analyze revenue from different sale channels
– Calculate employee hours / bonus based on pay structure
– Create weekly updated interactive dashboard in Excel to track KPIs
– Share Excel dashboards with your colleagues
and many more.
This course will change you and the skills you learn will benefit you for many years. Join the course to build your Excel skills today!

You will learn

✓ Go from ZERO to MASTER essential tools and functions in Excel
✓ Do powerful calculations in a short time by being able to combine multiple Excel functions together
✓ Make critical decisions on any set of data using Excel Vlookup, Index & Match,Excel data filter, sumif, countif functions
✓ Learn when to use Excel Pivot Tables and Excel Pivot Charts
✓ Create interactive dashboard in Excel and share it with your colleagues
✓ Do data prediction using linear regression
✓ Practice your skills on multiple exercises to put your skills to work and get 1-on-1 feedback from your instructor

Requirements

• You should have a PC or Mac with Excel 2016 or 2010 or 2013 readily installed
• You should understand high school level algebra

This course is for

• Business analyst or data analyst
• Small business owners, start-up entrepreneurs, operation managers
• Engineers who need to handle lots of data
• This course is not for those who want to learn Excel VBA or PowerPivot
PhD in Chemical Engineering, Data analytics expert
Hi, my name is Anh Nguyen. I have 10 years of experience as a researcher, engineer and data analyst working with data in different industries: chemical, petroleum, e-commerce, technology start-ups in different EU and US companies. My main interest is to develop data-driven models to improve production and business efficiency. 
I have been asked to provide training courses on data-related topics for my colleagues, and I realized that many people could be benefited from those topics as well. Therefore, I create Udemy courses to share my knowledge with you and hope that you will find it useful.
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 5h 2m
Language: English
Next start: On Demand

Students are also interested in