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

Excel Charts for Professionals

Course Summary

This course covers basic charts and more interesting charts ican be made better by minor tweaks in the basic charts


  • +

    Course Syllabus

    • Introduction
      • Introduction
      • Charting Process
      • Selecting the Right Chart
    • Level 1: Basic Charts
      • Level 1: Unsolved Data Template used in videos
      • Level 1: Solved Data Template used in videos
      • Column Chart - Single Columns
      • Column Chart - Multiple Columns
      • 3 D Column Chart
      • Stacked Column Chart - With Absolute Values
      • Stacked Column Chart - 100%
      • Bar Chart - Single Bars
      • Bar Chart - Multiple Bars
      • 3 D Bar Chart
      • Shifting Row to Columns and Vive Versa
      • Stacked Bar Chart - With Absolute Values
      • Stacked Bar Chart - 100%
      • Stacked Volume or Area Chart
      • Histograms
      • Line Chart
      • Scatter Chart
      • Pie Chart
      • 3 D Pie Chart
      • Bubble chart
      • Candle Chart
      • Radar Chart/ Spider Chart
    • Level 2: Charts with Minor Tweaks in Excel
      • Introduction to the Section
      • Level 2: Unsolved Data Template used in videos
      • Level 2: Solved Data Template used in videos
      • Charts with two Y axis
      • Combining multiple types of charts
      • Pie of Pie Chart
      • Spark Lines
      • Spark Lines - Columns
      • Spark Lines - Win-Loss
      • In Cell Chart
    • Level 3: Excel Charts with Background Calculations
      • Introduction to the Section
      • Level 3: Unsolved Data Template used in videos
      • Level 3: Solved Data Template used in videos
      • Indexed Line Charts
      • Dynamic Data Selection for charts
      • Water Fall Chart
      • Conditional Formatting Data Series-1
      • Conditional Formatting Data Series-2
    • Essential Formatting Elements
      • Introduction to the Section
      • Editing Color & Borders of Bar and Column Chart
      • Editing Color and Thickness of Line Chart
      • Editing X Axis
      • Editing Y Axis
      • Editing Axis Titles
      • Editing Grid Lines
      • Editing the Chart Heading
      • Editing the Legends
      • Editing Data Labels
      • Choosing Chart Designs
      • Choosing Chart Layouts
      • Inserting Texts & Symbols in Chart
    • Conclusion
      • Concluding Remarks and Contact Details


Course Fee:
USD 18

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

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
Hidden Image Url

Back to Top