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

Certificate Program in Advanced MS Excel

Course Summary

A Comprehensive Online Program designed for Professionals


  • +

    Course Syllabus

    • Chapter 1: Working with Excel Files
      • Working with Excel Files
      • User Interface-Video
      • BackStage View-Video
      • Help System-Video
    • Chapter 2: Entering Data
      • Entering Data
      • Editing Workbooks 1-Video
      • Editing Workbooks 2-Video
      • Formatting Data-Video
    • Chapter 3: Working With Numbers
      • Working With Numbers
      • Operators Formulas-Video
      • Paste Preview-Video
      • Excel Tables-Video
      • Math Functions 1-Video
      • Financial Functions-Video
      • Math Functions 2-Video
    • Chapter 4: Formatting Data
      • Formatting Data
      • Formatting Options 1-Video
      • Formatting Options 2-Video
    • Chapter 5: Managing Your Data in Excel
      • Managing Your Data in Excel
      • Managing Data 1-Video
      • Managing Data 2-Video
    • Chapter 6: Working with Text and Date
      • Working with Text and Date
      • Text Date Time-Video
    • Chapter 7: Manipulating Data
      • Manipulating Data
      • Relative Absolute Referencing-Video
    • Chapter 8: Working with Charts
      • Working with Charts
      • Charts 1-Video
      • Charts 2-Video
      • Trendlines-Video
    • Chapter 9: Working with PivotTable
      • Working with PivotTable
      • Pivot Tables-Video
      • Pivot Tables Charts-Video
    • Chapter 10: What If Analysis
      • What If Analysis
      • Goal Seek-Video
      • Scenario Manager-Video
    • Chapter 11: Macros
      • Macros
      • Macros-Video
    • Chapter 12: Printing Excel Files
      • Printing Excel Files
      • Printing Worksheets-Video
    • Chapter 13: Managing Excel Files
      • Managing Excel Files
      • File Formats-Video
    • Chapter 14: Grouping and Outlining Data
      • Grouping and Outlining Data
      • Grouping Data-Video
      • Linking Protecting-Video
    • Chapter 15: Shortcut Keys & References
      • Shortcut Keys & References
    • Practice Files
      • Certificate in Advanced MS Excel - Quiz
    • Mentor Class Videos
      • Video-01 - Working with Excel Files, Entering Data, Working with Numbers
      • Video-02 - Managing Data, Working with Text & Date and Manipulating Data
      • Video-02 (contd) - Managing Data, Working with Text & Date and Manipulating Data
      • Video-03 - Manipulating data, Working with charts & Pivot table
      • Video-04 - Working with Pivot table(contd..), What if Analysis & Macros
      • Video-05 - Printing & Managing files, Grouping & Outlining Data and Shortcut Key


Course Fee:
USD 70

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Project & Service 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