MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

# Microsoft Excel Charts Master Class

### Course Summary

Learn Excel Charts in an easy and comfortable way and present your data in an actionable form for profit and success

• +

### Course Syllabus

• Welcome
• Welcome To Excel Charts!
• Tips On How To Learn Excel Charts
• Chart Anatomy
• Fundamental Concepts Of Excel Charts
• Elements Of Excel Charts
• Charts Based On Non Contiguous Ranges
• Chart Title
• Data Labels
• Axis Titles
• Data Table
• Error Bars
• Excel Column Charts
• Clustered Columns
• Stacked Columns Charts
• 100% Stacked Columns Charts
• 3D Column Charts
• Excel Line Charts
• Line And Line With Markers Charts
• The Other Line Charts
• Excel Pie Charts
• Pie Chart
• 3D Pie Chart
• Pie Of Pie Chart
• Bar Of Pie Chart
• Problem Of Pie Charts
• Doughnut Charts
• Excel Bar Charts
• Bar Charts
• Excel Area Charts
• Area Charts
• X Y Scatter Charts In Excel
• X Y Scatter Charts Introduction
• X Y Scatter With Lines
• X Y Scatter Without Correlation
• X Y Scatter With Negative Correlation
• Bubble Charts In Excel
• Geometry
• Excel Stock Charts
• Stock Charts
• Excel Surface Charts
• Surface Charts In Excel
• Excel Radar Charts
• Excel Combination Charts
• Combination Charts Introduction
• Off-Scale Data Series
• Pareto Chart - Introduction
• Creating Pareto Charts From Grouped Data
• Pareto Chart From Raw Data - Using Pivot Tables
• Disconnected Charts
• Disconnecting A Chart From Data
• Working With Data Series
• Contiguous Range - The Easiest Situation
• Non-Contiguous Selection Approach
• Copy-Paste Approach
• Select Data Command - Pack Your Own Parachute
• Interactive Charts - Using Excel Tables
• Interactive Charts Using An Excel Table
• Interactive Charts - Using Named Formulas
• Excel Named Ranges and Named Formulas - Review
• COUNTA and OFFSET Functions In Excel
• Interactive Charts Using Named Formulas
• Sparklines
• Creating Excel Sparklines
• Excel Sparklines In Merged Cells
• Sparklines With Date Axis Type
• The "Edit Data" Command
• Sparklines - Formatting Options
• Sparklines - Axis Options
• Sparklines - Clearing And Grouping
• Using Conditional Formatting As A Chart Engine - extra material
• Conditional Formatting To Create A Chart Effect
• Next Steps
• Next Steps

Course Fee:
USD 89

Self-Study

### Course Status:

Active

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts:

## Data Analysis

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software