Excel: Creating a graphical business dashboard
edX
16 Courses
The Polytechnic University of Valencia is a public institution in Spain, providing undergraduate, postgraduate, and doctoral programs in fields like engineering, architecture, telecommunications, and information technology. It stands as one of the most substantial universities in Spain.
Overview
This is a short Microsoft Excel course designed for someone who already has an intermediate/low-intermediate level of Excel to refresh and consolidate their knowledge by performing a case study of creating a graphical data dashboard.
Starting from a spreadsheet containing data on the commercial activity of a company, the student will summarize the data in configurable tables in a guided way to end up building a summary data panel that allows the company's managers to have synthetic information of the activity that allows them to make decisions.
Throughout the process, the use of tabular data, search, consolidation and summary functions and, finally, the use of dynamic tables and graphs that allow to present the information in an efficient way are covered.
The course is an ideal tool for those who already know Excel and want to refresh and strengthen their knowledge of data management for use in daily work or to undertake more advanced courses.
