Course Category:
This course provides advanced knowledge on using Microsoft Excel for Office 365. You will first learn the fundamentals of how to work with various types of visual representation. This includes pictures and SmartArt as well as 3D maps for mapping your data.You will then learn more about analyzing your data with PivotTables and PivotCharts, and finally you will learn about some advanced formulas and functions in Excel.
The primary subject matter of this course:
Pretest
More functions of Excel
- Inserting pictures
- Data exchange with other Office applications
- Excel files on Web storage locations
- Chapter test
PivotTable and PivotChart
- Creating and modifying a PivotTable
- Creating and editing a PivotChart
- Pivot: Analysis and settings
- Chapter test
Advanced formulas and functions
- References
- New functions
- Chapter test
Final Test
- 16 Questions
Office 365 E-Learning Course Features:
- structured video tutorials
- audio narration with closed-captioning
- practice interactive exercises
- tips and printable PDF's
- pretest with personalized learning path
- chapter tests
- comprehensive final test with certificate
- SCORM package delivery for LMS hosting
- accessible online
- Tin Can/xAPI compatible
- available in different languages
Excel Advanced - Office 365 Course Includes:
Sections: 8
Number of Nuggets: 45
Learning Time: 145 Minutes
