This learner has completed ID verification. Find out more.
Certificate of Achievement
has completed the following course:
How to Use Microsoft Excel for Data Analysis
CloudSwyft Global Systems, Inc. and Microsoft
In this course, learners have learned how to perform data analysis using Excel’s most popular features, how to create pivot tables from a range with rows and columns in Excel, summarize data in flexible ways, enabling quick exploration of data, and producing valuable insights.
2 weeks, 5 hours per week
Dann Angelo De Guzman
Founder & CEO
CloudSwyft Global Systems, Inc.
Transcript
Learning outcomes
- Demonstrate how to create flexible data aggregations using pivot tables
- Apply how to represent data visually using pivot charts
- Explain how to create aggregate reports using formula based techniques
- Calculate margins and other common ratios using calculation on pivot table
Syllabus
- Reporting in Excel
- Excel tables and basic pivot tables
- Creating dashboards
- Profitability analysis and finding anomalies using pivot tables
- Comparing data year-over-year in pivot tables
- Reporting hierarchical data
- Multi-table pivot tables using the data model.
Issued on 9th May 2021
The person named on this certificate has completed the activities in the transcript above. For more information about Certificates of Achievement and the effort required to become eligible, visit futurelearn.com/proof-of-learning/certificate-of-achievement.
This certificate represents proof of learning. It is not a formal qualification, degree, or part of a degree.