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
• 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

Self-Study

### Course Status:

Active

1 - 4 hours / week

This course is listed under Development & Implementations and Project & Service Management Community

Related Posts: