technifyed

Universitat Politècnica de València via edX

Excel: Importing and analyzing data

Overview

Learn advanced techniques and strategies to import, consolidate and visualize data from any source with Excel.

What you'll learn

  • How to do data preprocessing with advanced text editors to eliminate import problems
  • How to use the Powerquery data import tools in Excel included in the latest versions to automate the data ingestion process.
  • How to use various functions and strategies to group and consolidate data in a way that gives us the information we need for business intelligence purposes
  • How to use the Powerpivot functions and the data model included in the new versions of Excel to easily work with data from multiple tables with millions of rec…
  • How to use slicers and other advanced pivot table and pivot chart functions in Excel

Skills you'll practise

Data ModelingData Analysis ToolsMicrosoft ExcelData Import/ExportData AnalysisPivot Tables And ChartsBusiness Intelligence

Advantages and disadvantages

Advantages

  • University courses you can audit for free, with lectures, readings and practice quizzes.
  • A verified certificate from the university if you pay for it.
  • Self-paced: start any time.

Disadvantages

  • Graded assignments and the certificate need the paid track.
  • Audit access can expire a few weeks after the course ends.
  • Learning is free, but the certificate costs money.
  • Some parts (graded work, certificate) are paid.

Some points apply to every course of this kind; see how we rank.

Free to audit

  • Free: Choose "Audit this course" when you enrol: lectures, readings and practice are free.
  • Paid: Graded assignments and the verified certificate (Certificate $69). Audit access may end after the course closes.

Before you start

High intermediate level Excel skills

Taught by

  • Jaime BusquetsHead of the Information Systems and Communication Service
  • Ignacio DespujolSenior IT Analyst / Profesor de Ingeniería aeroportuaria

Universitat Politècnica de València is in Tier 3: good universities, respected companies, nonprofits and well-known teachers of our institution ranking (70/100).

Similar courses

Compare these

Massachusetts Institute of Technology · YouTube

MIT 15.S12 Blockchain and Money, Fall 2018

Instructor: Prof. Gary Gensler View the complete course: https://ocw.mit.edu/15-S12F18 This course is for students wishing to explore blockchain technology’s potential use - by entrepreneurs & incumbents - to change the world of money and finance. License: Creative Commons BY-NC-SA More information…

Free video23 videos, 29 hours

Massachusetts Institute of Technology · YouTube

MIT 6.006 Introduction to Algorithms, Fall 2011

This course provides an introduction to mathematical modeling of computational problems. It covers the common algorithms, algorithmic paradigms, and data structures used to solve these problems. The course emphasizes the relationship between algorithms and programming, and introduces basic performa…

Free video47 videos, 42 hours

Harvard University · YouTube

CS50's Introduction to Programming with Python (CS50P) 2022

This is CS50P, CS50's Introduction to Programming with Python. Register for free at https://cs50.edx.org/python. Slides and source code at https://cs50.harvard.edu/python. Playlist at https://www.youtube.com/playlist?list=PLhQjrBD2T3817j24-GogXmWqO5Q5vYy0V. An introduction to programming using a la…

Free video11 videos, 16 hours

Harvard University · YouTube

CS50x 2023 Lectures

This is CS50, Harvard University's introduction to the intellectual enterprises of computer science and the art of programming, for concentrators and non-concentrators alike, with or without prior programming experience. (Two thirds of CS50 students have never taken CS before.) This course teaches…

Free video12 videos, 26 hours

Massachusetts Institute of Technology · YouTube

MIT 6.100L Introduction to CS and Programming using Python, Fall 2022

Instructor: Ana Bell View the complete course: https://ocw.mit.edu/courses/6-100l-introduction-to-cs-and-programming-using-python-fall-2022/ *Note: Lectures 6, 10 have been updated! This subject is aimed at students with little to no programming experience. It aims to provide students with an under…

Free video26 videos, 28 hours

Massachusetts Institute of Technology · YouTube

MIT 18.650 Statistics for Applications, Fall 2016

MIT 18.650 Statistics for Applications, Fall 2016 View the complete course: http://ocw.mit.edu/18-650F16 Instructor: Philippe Rigollet This course offers an in-depth the theoretical foundations for statistical methods that are useful in many applications. The goal is to understand the role of mathe…

Free video22 videos, 28 hours

Enter your email and the official page opens. Phone is optional.