About This Course
In today’s technology world, data has been produced increasingly in various fields such as education, healthcare, and business. Actually, data itself is important. However, data is useless and meaningless without processing and analyzing. Therefore, data should be processed and analyzed to become useful and meaningful information that can help organization, e.g., business, to understand consumer behavior, make better decision, and improve productivity and profit, etc. For this issue, Microsoft Excel is one of the most popular tools to help process, analyze, and visualize data. As a result, this course aims to provide the students with in-depth understanding how to do data processing, data analytics, and data visualization by Microsoft Excel for business.
In this course, you will learn about using Excel for financial functions, What-if analysis, break even analysis, marketing data analysis functions, forecasting analysis functions, pivot table, excel charts, marketing media selection, project management, linear programming problem, and transportation problem, etc. After learning this course, you will be able to apply the best practices what you have learnt in the future careers such as Data Engineer, Data Analyst, Business Analyst, Database Specialist, etc.
The main learning outcome of this course is to be able to apply Microsoft Excel for data processing, data analytics, and data visualization in business application.
Learning Hours
3 hours
Requirements
English language and computer skill (intermediate level) will be required since this course will be delivered in English version how to use Microsoft Excel for business application.
Evaluation and Assessment Criteria
Firstly, students need to take a pre-test before learning the course. Then, the assignments will be given for each chapter during the course period. Finally, students need to take a post-test again after finishing the course.