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

Mastering Microsoft Excel - Charts In Detail

Course Summary

Learn how to create dynamic and interactive charts in Excel. Turn your data into professional looking charts and graphs


  • +

    Course Syllabus

    • Welcome
      • Important - Download These First - Working Files
      • 0101 A Chart Can Explain Things Better Than Numbers
      • 0103 The Included Working Files
    • Chart Basics
      • 0201 Deciding On The Data To Be Used In A Chart
      • 0202 Creating Charts Quickly
      • 0203 Use Sparklines To Create Inline Charts
      • 0204 Chart Areas Plot Chart Legends
      • 0205 Filtering An Existing Chart
      • 0206 The Right Chart Type Matters
      • 0207 The Chart Sub Ribbons And Properties Box
    • The Design Tab
      • 0301 Moving Charts And Switching Rows And Columns
      • 0302 Changing The Default Chart Type
      • 0303 Chart Layouts Styles And Colors
      • 0304 Adding And Removing Chart Elements
      • 0305 Dealing With Hidden Or Empty Cells
      • 0306 Dynamic Titles
      • 0307 Trend Lines Used To Help Analyze Data
    • The Format Tab
      • 0401 Adding And Manipulating Shapes
      • 0402 Add WordArt And Use Of WordArt Styles
      • 0403 Adding Static And Dynamic Text Boxes
      • 0404 Using Pictures Or Textures As Chart Element Backgrounds
      • 0405 Altering Axis Formatting And Plotting
      • 0406 Managing Data Labels
    • Special Chart Types
      • 0501 Multiple Chart Types In The Same Chart
      • 0502 Multiple Pie Charts In The Same Sheet
      • 0503 Pie Of A Pie
      • 0504 Charting Stock Movements
      • 0505 Radar Charts In Action
      • 0506 Scatter Charts Explained
    • Chart Data
      • 0601 Changing A Charts Date Source
      • 0602 Creating Charts From Multiple Data Sources
      • 0603 What Happens When I Copy Sheets With Charts?
    • Printing And Sharing Charts
      • 0701 How To Print Charts
      • 0702 Chart Templates
      • 0703 Copying And Linking Charts To Other Office Applications
    • The End
      • 0801 Charts In Summary


Course Fee:
USD 24

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

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

Related Posts:

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