- Course Introduction
- Course Resources
- Elements of charts
- The Easy way of creating charts
- Bar and column charts
- Formating charts
- Line Charts
- Area Charts
- Pie and Doughnut Charts
- Scatter plot or XY chart
- Excel Basics Tutorial
- Bonus Lecture
What are the chart types I will learn in this course?
Excel offers the following major chart types. All of these are covered in this course
XY (Scatter) Chart
And many other creative ones :)
How are charts useful in Excel?
A chart is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers, and they make showing comparisons and trends much easier.
What are the benefits of using charts in Excel?
Excel charts allow spreadsheet administrators to create visualizations of data sets. By highlighting a set of data within an Excel spreadsheet and feeding it into the charting tool, users can easily create various types of charts in which the data is displayed in a graphical way.
This course will answer all the questions that would pop up while you set to visualize your data using Excel charts such as:
How do you make Excel charts look better?
How do you format a chart in Excel?
What are the different elements of charts?
How do I make those awesome infographics that I see in fancy magazines and TV reports?
How do I create a comparison chart in Excel?
What is the best chart to use for comparison?
And many more...
How is this course different from other resources available online?
Most courses only cover only teach how to draw different types of charts in Excel. The main point is missed. The main point of creating a chart is that you want to convey a message or tell a story using the chart. In this course, once you have learnt all the charting tools, you will also learn how you should create a chart. How you can highlight your message and avoid clutter in the chart, so that when your audience looks at the chart, the message is clearly conveyed to them.
The course is created on the basis of three pillars of learning:
Review (Self feedback)
We have created a set of concise and comprehensive videos to teach you all the Excel related skills you will need in your professional career.
With each lecture, we have provide a practice sheet to complement the learning in the lecture video. These sheets are carefully designed to further clarify the concepts and help you with implementing the concepts on practical problems faced on-the-job.
Check if you have learnt the concepts by comparing your solutions provided by us. Ask questions in the discussion board if you face any difficulty.
Part of WSQ - Advanced certificate in Workplace Safety in Health
Learn the riff in 4 ways, the tune, the harmonies (both at once on the same harmonica) and how to improvise on this tune
Start-Tech Academy is a technology-based Analytics Education Company and aims at Bringing Together the analytics companies and interested Learners.
Our top quality training content along with internships and project opportunities helps students in launching their Analytics journey.
Founded by Abhishek Bansal and Pukhraj Parikh.
Working as a Project manager in an Analytics consulting firm, Pukhraj has multiple years of experience working on analytics tools and software. He is competent in MS office suites, Cloud computing, SQL, Tableau, SAS, Google analytics and Python.
Abhishek worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.