Learn MATLAB and Octave and start experimenting with matrix manipulations, data visualizations, functions and mathematical computations.

In this course, Excel 2021 Pro, you will take your Excel knowledge to the ultimate level. When youíre finished with this course, you will have the skills needed to create advanced professional spreadsheets (and complete preparation for the Office exams).

In this course, Excel 365 Pro, you will take your Excel knowledge to the ultimate level. When youíre finished with this course, you will have the skills needed to create advanced professional spreadsheets (and complete preparation for the Office exams).

Make sure you’re not reinventing the wheel in your Excel spreadsheets. Logic functions are at the core of automating your work and keeping things up to date. Learn by example how to write and debug the AND, OR, NOT, IF, IFS, and IFERROR functions.

Save time and reduce errors by using the right functions in Excel. Statistics and finance functions can help you make quick work of reports and evaluations. Learn by example how to use the SUMIFS, AVERAGEIFS, COUNTIFS, NPV, FV, and PV functions.

Learn how to use data visualizations like scatterplots, barcharts, histograms, and boxplots for data exploration.

Learn about Excel financial modeling, including cash flow, scenario analysis, time value, and capital budgeting.

Use the very popular ggplot2 visualization library and learn how to fine tune your charts. Special emphasis is put on color palettes, axes and scales, as well as plot themes.

The course will teach you how to organize your data and present it in a compelling narrative format to engage your stakeholders, such that they are able to understand the insights within the data and take action based on your recommendations.

Learn how to create interactive geospatial visualizations that run on all popular browsers. This course will teach you how to use the D3 library to render maps using openly available data, and draw beautiful visualizations on top of them.

The aim of this course is to provide the business professional with the skills and knowledge to enable them to turn raw data into powerful visual reports by way of practical and relatable examples.

This course builds on some of the concepts covered in the earlier Google Sheets course.