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
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…
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…
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…
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…
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…
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…