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

Learn Microsoft Excel 2010 Advanced Course

Course Summary

Learn advanced Excel 2010 features and get ready to take your Excel knowledge to the next level.


  • +

    Course Syllabus

    • Chapter 1 - Basic Steps for Charts & Graphs
      • Introduction to Advanced Excel 2010
      • Four Basic Steps When Creating Charts/Graphs
      • Additional Features to Help Create Charts/Graphs
      • Additional Features to Help Create Charts/Graphs Part 2
      • Excel 2010 keyboard shortcuts
      • Course transcripts
      • MP3 audio files
      • 50% off course discount links for other Simon Sez IT courses
    • Chapter 2 - Layout Tab
      • Detailed Formatting for Charts/Graphs
      • Formatting Legends within Charts/Graphs
      • Formatting Axes and Gridlines within Charts/Graphs
    • Chapter 3 - Trends
      • Trends within Charts and Graphs
      • Complex Trends within Charts and Graphs
      • Trends over Time within Charts and Graphs
    • Chapter 4 - Differences
      • Showing Differences Using Bar Charts
      • Showing Differences Using Pie Charts
      • Limitations with Pie Charts & How to Correct
      • Alternative Ways to Show Differences
    • Chapter 5 - Relationships
      • Course Review
      • Using Charts & Graphs to Show Relationships
      • Using Charts & Graphs to Show Relationships Part 2
    • Chapter 6 - Stock
      • Charting & Graphing Financial Information
      • Charting & Graphing Financial Information Part 2
      • Specific Charts for Finance Information
      • Setting Up Live Charts
    • Chapter 7 - Sparklines
      • Using Sparklines for Data Visualization
    • Chapter 8 - Data Bars
      • Using and Formatting Data Bars, Color Scales & Icon Sets
    • Chapter 9 - Pivot Tables
      • Setting Up Pivot Tables/Charts
      • Setting Up Pivot Tables/Charts Part 2
      • Filtering Pivot Tables/Charts
      • New Features for PIvot Tables/Charts
    • Chapter 10 - Graphics
      • Graphics Tools
      • Graphics Tools Part 2
    • Chapter 11 - Exporting
      • Exporting Charts and Graphs
      • Exporting Charts and Graphs Part 2
    • Course Quiz
      • Assessment Test


Course Fee:
USD 97

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