Excel: Working with data

This is an intermediate level Microsoft Excel course that will allow you to work with data for processing and drawing conclusions by grouping data, using pivot tables and charts, the main Excel functions, performing hypothesis analysis and linking data from other spreadsheets. The use of Excel is fundamental for good decision making and is widely used in Business Intelligence and other areas such as research and academia. During the course we will teach you how to benefit from the management and interpretation of data with the use of Excel tools and how you can apply them in real life.

• Create templates and link external data in Excel
• Group data in tables to extract information to help you make decisions; Business Intelligence
• Use dynamic charts and graphs to present and extract information with the help of this Microsoft software program
• Use hypothesis analysis to make better decisions
• Learn Excel data conversion utilities

• To follow this course you must have previously completed the Excel: Fundamentals and Tools course, also in edX or have an equivalent intermediate level.