Excel: Importing and analyzing data
edX
15 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
Join our comprehensive data analysis course designed to equip you with advanced data import techniques and strategies for data consolidation and preparation using Microsoft Excel. Learn from real case demonstrations and draw the conclusions you need with confidence.
Explore innovative data modeling and import tools available from Excel 2010 onwards. Discover how to efficiently manage large data volumes across multiple tables and automate your import processes to save time and effort with each update.
Master the art of configuring pivot tables and charts in Excel to maximize versatility and facilitate scenario analysis. Gain practical skills in making your data analysis as effective and adaptable as possible.
These sophisticated data analysis tools and techniques are essential for implementing Business Intelligence solutions across various organizational projects.
Offered by: Universitat Politècnica de València via edX
Categories: Data Analysis Courses, Business Intelligence Courses, Data Visualization Courses, Microsoft Excel Courses, Data Preparation Courses, Data Modeling Courses, Pivot Tables Courses, Pivot Charts Courses