Excel: Importing and analyzing data

Overview

In this data analysis and interpretation course we will introduce you to advanced data import techniques and various strategies to consolidate and prepare the data once imported so that you can draw the conclusions you need (based on our experience in the use of Microsoft Excel and demonstrated with real cases).

Syllabus

• Introduction to Data Import in Excel
Overview of Data Import Options
Familiarization with Excel's Data Interface
• Advanced Data Import Techniques
Importing Data from Different Sources (CSV, Text, SQL, etc.)
Using Power Query for Data Import
Automating Data Imports with Macros and VBA
• Data Consolidation Strategies
Techniques for Combining Multiple Datasets
Using PivotTables for Data Aggregation
Merging and Appending Data in Power Query
• Data Preparation and Cleaning
Detecting and Handling Missing Data
Data Transformation Techniques
Utilizing Excel Functions for Data Preparation (e.g., TEXT, CONCATENATE, etc.)
• Data Analysis Tools in Excel
Introduction to Statistical Functions in Excel
Performing Descriptive Statistics
Data Visualization with Charts and Graphs
• Case Studies and Real-World Applications
Step-by-Step Analysis of Real Case Scenarios
Applying Learned Techniques to Draw Conclusions
• Conclusion and Best Practices
Recap of Key Techniques and Tools
Tips for Efficient Data Management in Excel

---

Taught by

Jaime Busquets and Ignacio Despujol

---

Subjects

Business