Excel Charts & Graphs and SmartArt Graphics for Beginners

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

Teaching 11 Courses on Excel and Data Analysis!

OVER 25,000 visitors visit my blog ExcelDemy dot com every month!!

OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!!

Course Updated: Nov 01. 2016

Excel is probably the most commonly used software in the world for creating charts. And charts are the main tools to visualize the insights from some numbers. Welcome to this Excel Charts and Graphical Objects learning course.

Let’s discuss now what you will learn from this course.

Basics of Excel Charts: At first you will learn the basics of Excel charts: how to create them quickly and how to choose the right chart type for your data.

Advanced Chart Techniques: Then you will work with the advanced tools within different task panes to work with excel charts.

Build some useful Excel charts: Then I will show you how to build some useful excel charts like: Combo Chart, Picture Chart, Thermometer Chart, Gauge Chart, Comparative Chart and finally the Gantt chart.

Graphical Objects: Then we shall work with Graphical objects. Graphical objects have many uses when you will present your data for an audience.

Here is not the end of the course. Time to time, I shall add more lectures to the course that will teach you how to face real life data visualization using Excel Charts and Graphical Objects.

By the completion of this training course, you will be fully versed in creating and using Excel charts. So, if you are interested to learn Charts and Graphical objects in Excel, then this course is for you. Thanks for reading. Enjoy the course!

Who this course is for:

  • This course is meant for intermediate level Excel users who are familiar with the general concepts of Excel features.
  • Learn how to use Graphic Arts objects in Excel. Learn how to create some real life charting with this course. Requirements Microsoft Office Software Installed. Description Teaching 11 Courses on Excel and Data Analysis! OVER 25,000 visitors visit my blog ExcelDemy dot com every month!! OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!! Course Updated: Nov 01. 2016 Excel is probably the most commonly used software in the world for creating charts. And charts are the main tools to visualize the insights from some numbers. Welcome to this Excel Charts and Graphical Objects learning course. Let’s discuss now what you will learn from this course. Basics of Excel Charts: At first you will learn the basics of Excel charts: how to create them quickly and how to choose the right chart type for your data. Advanced Chart Techniques: Then you will work with the advanced tools within different task panes to work with excel charts. Build some useful Excel charts: Then I will show you how to build some useful excel charts like: Combo Chart, Picture Chart, Thermometer Chart, Gauge Chart, Comparative Chart and finally the Gantt chart. Graphical Objects: Then we shall work with Graphical objects. Graphical objects have many uses when you will present your data for an audience. Here is not the end of the course. Time to time, I shall add more lectures to the course that will teach you how to face real life data visualization using Excel Charts and Graphical Objects. By the completion of this training course, you will be fully versed in creating and using Excel charts. So, if you are interested to learn Charts and Graphical objects in Excel, then this course is for you. Thanks for reading. Enjoy the course! Who this course is for: This course is meant for intermediate level Excel users who are familiar with the general concepts of Excel features. Show more Show less Course content 6 sections • 40 lectures • 3h 49m total length Expand all sections Welcome to the Course! 5 lectures • 13min Welcome to the course Preview 01:37 Download Working Files, Ongoing Support & How to Instantly Contact Me 00:49 List of sites where you can practice Excel problems 00:46 How to Best View This Course 06:58 How to Review this Course and Obtain Your Certificate of Completion 02:40 Getting Started with Excel Charts 9 lectures • 1hr 6min 0201 How to Make a Graph or Chart in Excel from Scratch 07:06 0202 Make a Graph in Excel 2013 Using the Recommended Charts Tool 04:54 0203 Creating and Customizing an Excel Chart in More than One Way 09:35 0204 Creating a Combination Chart in Excel & Introducing with Chart Elements 06:18 0205 Using Chart Elements, Chart Styles and Chart Filters - Excel 2013 New Tools 08:20 0206 Resizing, Moving, Copying, Deleting, and Printing Charts in Excel 06:36 0207 Chart Types: Column Charts, Bar Charts, and Line Charts 08:13 0208 Pie Chart in Details Preview 06:51 0209 Chart Types: XY(Scatter) Chart, Area Charts, and Radar Charts 08:28 Advanced Chart Techniques 11 lectures • 1hr 3min 0301 Chart Elements: The Ways to Select Chart Elements 05:02 0302 The Tools That You Can Use to Format The Chart Elements 05:36 0303 Fill & Line: Modifying or Formatting Using Fill & Line Tools 10:06 0304 Effects: Modifying and Filtering Using Different Types of Effects 08:58 0305 Size & Properties: Modifying and Formatting Using Sizes and Properties 05:49 0306 Another Tools to Format: Series Options, Table Options and Marker Options 03:16 0308 Value and Category Axis Options: A Deeper Analysis Preview 08:56 0310 Handling Missing Data in Excel Charts 02:13 0311 Adding Error Bars and Trend Lines to a Chart 06:53 0312 Chart Templates: How to Create and Use 02:21 0313 Format Data Series Options: Series Overlap and Gap Width 04:04 Build Some Charts that are Useful while Making Excel Dashboard 6 lectures • 34min 0401 Creating Combination Charts: Deeper Analysis 04:28 0402 How to Create Picture Charts Preview 04:48 0403 Thermometer Chart: How to Create Thermometer Chart in Excel 08:08 0404 Gauge Chart: How to Create a Gauge Chart in Excel 06:32 0406 Comparative Histogram: How to Create a Comparative Histogram 04:21 0407 Gantt Chart: How to Create a Gantt Chart in Excel 05:29 Graphics Objects - Using Pictures and Drawings in Excel 8 lectures • 52min 0502 Formatting Images in Excel 09:42 0503 Removing Background from an Image 05:34 0506 Working with SmartArt Objects 08:34 0507 The Stacking Order - Stacking Objects in a Worksheet 05:44 0508 Aligning, Spacing and Grouping Multiple Objects Together 06:05 0509 Using Mathematical Formulas with Graphical Objects Preview 04:46 0510 Working with WordArt 03:47 0511 Working with Equation Editor 07:48 Learn More: A Special Offer! 1 lecture • 2min Bonus Lecture: A Special Offer for You! 01:47 Instructor Kawser Ahmed Founder ExcelDemy.com | Data Analyst 4.4 Instructor Rating 9,450 Reviews 148,246 Students 10 Courses Love to see you here. I am Kawser Ahmed, father of two beautiful angels (Marissa and Arissa), a full-time data analysis blogger (using Excel & other tools), corporate Excel trainer, & entrepreneur. I love to make courses in the combination of both theory and practice. Monthly 100,000 Excel users visit my Excel blog ExcelDemy (follow the website link in the profile). I love to learn and teach (teaching from my eighteen)! Visit my blog. You will find plenty of useful posts, articles, video tutorials, and important Excel resources. What I love most is: add some value to people around me, believe me. Here are some of my working areas: 1. Corporate Budgeting, Planning & Forecasting 2. Mission-critical financial processes 3. Month-end close processes 4. Big Data Analysis using Excel 5. Company Reports (Sales, Marketing, Administrative) 6. Large Projects using Excel VBA 7. Dashboard Design using Excel 8. And Basic Accounting I am always around you to help and support. Just contact me. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781603bfedf5464',m:'8ee32d025aaae68bc1bd67f3938b245fed1976a5-1627845126-1800-ATiFxtE0Nvgr3leUTU6tDw1pZIkgXaKiYWF5cZV+h90Be6HRq4Knawcd2KXkOs9b8MAjaQ7vXKy5ZHz2AMcuXOTGwrIQ10w/8Cmjo3Nnj8oVvmtp1XneE2atpVoYhOmI0Ud/kB0NVyVZ9/DWH2+8CLYzgvGYgwGm/NiD9Q+GRuOuOReqs2QvR1ILGdMJFuFtLEFHBqSABjIeZIcgHUCG6ZI=',s:[0xa2e2a4f759,0x0071b39b63],}})();
  • Learn how to create some real life charting with this course. Requirements Microsoft Office Software Installed. Description Teaching 11 Courses on Excel and Data Analysis! OVER 25,000 visitors visit my blog ExcelDemy dot com every month!! OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!! Course Updated: Nov 01. 2016 Excel is probably the most commonly used software in the world for creating charts. And charts are the main tools to visualize the insights from some numbers. Welcome to this Excel Charts and Graphical Objects learning course. Let’s discuss now what you will learn from this course. Basics of Excel Charts: At first you will learn the basics of Excel charts: how to create them quickly and how to choose the right chart type for your data. Advanced Chart Techniques: Then you will work with the advanced tools within different task panes to work with excel charts. Build some useful Excel charts: Then I will show you how to build some useful excel charts like: Combo Chart, Picture Chart, Thermometer Chart, Gauge Chart, Comparative Chart and finally the Gantt chart. Graphical Objects: Then we shall work with Graphical objects. Graphical objects have many uses when you will present your data for an audience. Here is not the end of the course. Time to time, I shall add more lectures to the course that will teach you how to face real life data visualization using Excel Charts and Graphical Objects. By the completion of this training course, you will be fully versed in creating and using Excel charts. So, if you are interested to learn Charts and Graphical objects in Excel, then this course is for you. Thanks for reading. Enjoy the course! Who this course is for: This course is meant for intermediate level Excel users who are familiar with the general concepts of Excel features. Show more Show less Course content 6 sections • 40 lectures • 3h 49m total length Expand all sections Welcome to the Course! 5 lectures • 13min Welcome to the course Preview 01:37 Download Working Files, Ongoing Support & How to Instantly Contact Me 00:49 List of sites where you can practice Excel problems 00:46 How to Best View This Course 06:58 How to Review this Course and Obtain Your Certificate of Completion 02:40 Getting Started with Excel Charts 9 lectures • 1hr 6min 0201 How to Make a Graph or Chart in Excel from Scratch 07:06 0202 Make a Graph in Excel 2013 Using the Recommended Charts Tool 04:54 0203 Creating and Customizing an Excel Chart in More than One Way 09:35 0204 Creating a Combination Chart in Excel & Introducing with Chart Elements 06:18 0205 Using Chart Elements, Chart Styles and Chart Filters - Excel 2013 New Tools 08:20 0206 Resizing, Moving, Copying, Deleting, and Printing Charts in Excel 06:36 0207 Chart Types: Column Charts, Bar Charts, and Line Charts 08:13 0208 Pie Chart in Details Preview 06:51 0209 Chart Types: XY(Scatter) Chart, Area Charts, and Radar Charts 08:28 Advanced Chart Techniques 11 lectures • 1hr 3min 0301 Chart Elements: The Ways to Select Chart Elements 05:02 0302 The Tools That You Can Use to Format The Chart Elements 05:36 0303 Fill & Line: Modifying or Formatting Using Fill & Line Tools 10:06 0304 Effects: Modifying and Filtering Using Different Types of Effects 08:58 0305 Size & Properties: Modifying and Formatting Using Sizes and Properties 05:49 0306 Another Tools to Format: Series Options, Table Options and Marker Options 03:16 0308 Value and Category Axis Options: A Deeper Analysis Preview 08:56 0310 Handling Missing Data in Excel Charts 02:13 0311 Adding Error Bars and Trend Lines to a Chart 06:53 0312 Chart Templates: How to Create and Use 02:21 0313 Format Data Series Options: Series Overlap and Gap Width 04:04 Build Some Charts that are Useful while Making Excel Dashboard 6 lectures • 34min 0401 Creating Combination Charts: Deeper Analysis 04:28 0402 How to Create Picture Charts Preview 04:48 0403 Thermometer Chart: How to Create Thermometer Chart in Excel 08:08 0404 Gauge Chart: How to Create a Gauge Chart in Excel 06:32 0406 Comparative Histogram: How to Create a Comparative Histogram 04:21 0407 Gantt Chart: How to Create a Gantt Chart in Excel 05:29 Graphics Objects - Using Pictures and Drawings in Excel 8 lectures • 52min 0502 Formatting Images in Excel 09:42 0503 Removing Background from an Image 05:34 0506 Working with SmartArt Objects 08:34 0507 The Stacking Order - Stacking Objects in a Worksheet 05:44 0508 Aligning, Spacing and Grouping Multiple Objects Together 06:05 0509 Using Mathematical Formulas with Graphical Objects Preview 04:46 0510 Working with WordArt 03:47 0511 Working with Equation Editor 07:48 Learn More: A Special Offer! 1 lecture • 2min Bonus Lecture: A Special Offer for You! 01:47 Instructor Kawser Ahmed Founder ExcelDemy.com | Data Analyst 4.4 Instructor Rating 9,450 Reviews 148,246 Students 10 Courses Love to see you here. I am Kawser Ahmed, father of two beautiful angels (Marissa and Arissa), a full-time data analysis blogger (using Excel & other tools), corporate Excel trainer, & entrepreneur. I love to make courses in the combination of both theory and practice. Monthly 100,000 Excel users visit my Excel blog ExcelDemy (follow the website link in the profile). I love to learn and teach (teaching from my eighteen)! Visit my blog. You will find plenty of useful posts, articles, video tutorials, and important Excel resources. What I love most is: add some value to people around me, believe me. Here are some of my working areas: 1. Corporate Budgeting, Planning & Forecasting 2. Mission-critical financial processes 3. Month-end close processes 4. Big Data Analysis using Excel 5. Company Reports (Sales, Marketing, Administrative) 6. Large Projects using Excel VBA 7. Dashboard Design using Excel 8. And Basic Accounting I am always around you to help and support. Just contact me. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781603bfedf5464',m:'8ee32d025aaae68bc1bd67f3938b245fed1976a5-1627845126-1800-ATiFxtE0Nvgr3leUTU6tDw1pZIkgXaKiYWF5cZV+h90Be6HRq4Knawcd2KXkOs9b8MAjaQ7vXKy5ZHz2AMcuXOTGwrIQ10w/8Cmjo3Nnj8oVvmtp1XneE2atpVoYhOmI0Ud/kB0NVyVZ9/DWH2+8CLYzgvGYgwGm/NiD9Q+GRuOuOReqs2QvR1ILGdMJFuFtLEFHBqSABjIeZIcgHUCG6ZI=',s:[0xa2e2a4f759,0x0071b39b63],}})();