Save For Later

Master Advanced Excel Data & Analytics Skills

Save For Later

Take your Excel data science skills to an advanced level. As data strategies become more pervasive, Excel will become even more popular for non-data scientists doing more work, more often, with data. This learning path extends the Master Excel for Data Science learning path, into VBA coding, data viz, and advanced interfacing between Excel and R.

In this learning path,

  • Master Excel's powerful VBA coding functions for advanced modeling and analytics.
  • Build your expertise in Excel's increasingly powerful data mapping functions.
  • Master the use of Excel with R, the language and data science environment for statistical computing.

OpenCourser is an affiliate partner of LinkedIn Learning and may earn a commission when you buy through our links.

From LinkedIn Learning
Hours 15
Instructors Curt Frye, Chris Dutton, Conrad Carlberg, Oz du Soleil
Language English
Subjects IT & Networking Business Data Science Programming

Similar Courses

Sorted by relevance

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile (33rd - 99th).

AD, Data Science $47k

Associate Data Science Supervisor $55k

Science writer / data analyst $63k

Genomic Data Science Programmer $75k

Volunteer Director of Data Science $78k

Expert Data Science Supervisor $79k

Supervisor 1 Data Science Supervisor $91k

Guest Director of Data Science $101k

Data Science Architect $105k

Head of Data Science $131k

Assistant Director 1 of Data Science $133k

Owner Director of Data Science $149k

Courses in this Learning Path

Listed in the order in which they should be taken

Starts Course Information

On Demand

Excel VBA: Managing Files and Data

Automate complex tasks and get more meaningful insights from data in Excel using Visual Basic for Applications (VBA) code. This course extends the techniques taught...

LinkedIn Learning

Save

On Demand

Excel VBA: Process Modeling (You were viewing this course)

Excel power users: Learn how to use Excel and VBA to create and run simulations on business processes for customer flow, queuing, and manufacturing. Visual Basics for Applications...

LinkedIn Learning

Save

On Demand

Building a Dynamic Heat Map in Excel

You don't need special software to create data visualizations. With some advanced functions, formatting, and filters, you can create these heat maps right in Microsoft Excel. The...

LinkedIn Learning

Save

On Demand

Visualizing Geospatial Data with Power Map in Excel

Take your data analysis skills (and your data visualizations) to the next level with Power Map, Excel's tool for exploring map and time-based data in 3D. This course takes the...

LinkedIn Learning

Save

On Demand

Excel: Using Dynamic Array Functions (Office 365/Microsoft 365)

In September 2018, Microsoft released a new family of functions in Excel called dynamic arrays. With dynamic arrays, a user can write one formula and get many different results....

LinkedIn Learning

Save

On Demand

R for Excel Users

Data scientists who use Excel realize that R is emerging as the new standard for statistical wrangling (especially for larger data sets). This course serves as the perfect bridge...

LinkedIn Learning

Save

On Demand

Logistic Regression in R and Excel

Business decisions are often binary: take on this project or put it off for a year; extend credit to this customer or insist on cash; open a new retail outlet in a particular...

LinkedIn Learning

Save

On Demand

Business Analytics: Data Reduction Techniques Using Excel and R

With businesses having to grapple with increasing amounts of data, the need for data reduction has intensified in recent years. To make sense of an overabundance of information,...

LinkedIn Learning

Save

LinkedIn Learning

From LinkedIn Learning
Hours 15
Instructors Curt Frye, Chris Dutton, Conrad Carlberg, Oz du Soleil
Language English
Subjects IT & Networking Business Data Science Programming

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile (33rd - 99th).

AD, Data Science $47k

Associate Data Science Supervisor $55k

Science writer / data analyst $63k

Genomic Data Science Programmer $75k

Volunteer Director of Data Science $78k

Expert Data Science Supervisor $79k

Supervisor 1 Data Science Supervisor $91k

Guest Director of Data Science $101k

Data Science Architect $105k

Head of Data Science $131k

Assistant Director 1 of Data Science $133k

Owner Director of Data Science $149k

Similar Courses

Sorted by relevance