Linkedin Learning
Linkedin Learning Logo

Excel: Analytics Tips 

  • Offered byLinkedin Learning

Excel: Analytics Tips
 at 
Linkedin Learning 
Overview

Deepen your Excel knowledge by picking up powerful and effective analytics techniques used by Excel pros

Duration

2 hours

Mode of learning

Online

Difficulty level

Intermediate

Credential

Certificate

Excel: Analytics Tips
 at 
Linkedin Learning 
Highlights

  • Earn a certificate of completion from LinkedIn Learning
Details Icon

Excel: Analytics Tips
 at 
Linkedin Learning 
Course details

More about this course
  • In this course, instructor Chris Dutton shows how to leverage intermediate to advanced Excel analytics functionality using crystal clear demos, real-world case studies, and bite-sized lessons
  • Each video is self-contained and focuses on a key tool or feature that you can add to your Excel tool kit
  • Learn how to conduct outlier detection, perform Monte Carlo simulations, and use CUBE functions
  • Plus, explore forecasting, using the Goal Seek feature, and leveraging Solver to tackle complex optimization models in Excel

Excel: Analytics Tips
 at 
Linkedin Learning 
Curriculum

Introduction

About the Pro Tip series

Analytics tips

Analytics Tips

Quick Analysis toolset

Scenario Manager

Optimization with Goal Seek

Basic forecasting

Outlier detection

Automated data tables

Power Query tools

Data modeling 101

CUBE functions

Monte Carlo simulation

Advanced optimization with Solver

Analysis ToolPak (preview)

Conclusion

Conclusion: Analytics tips

Faculty Icon

Excel: Analytics Tips
 at 
Linkedin Learning 
Faculty details

Chris Dutton
Maven Analytics is the first purpose-built, online platform for data analysts to learn new skills, showcase their work, and connect with peers and employers.

Other courses offered by Linkedin Learning

– / –
1 hours
Intermediate
899
1 hours
Intermediate
– / –
1 hours
Advanced
1.85 K
1 hours
Intermediate
View Other 504 CoursesRight Arrow Icon

Excel: Analytics Tips
 at 
Linkedin Learning 
Students Ratings & Reviews

5/5
Verified Icon2 Ratings
S
Shekhar Jadhav
Excel: Analytics Tips
Offered by Linkedin Learning
5
Learning Experience: The content was interesting, experience was smooth, career hellping to improve productivity
Faculty: The faculty was calm and taught all the topics with calrity and simple words easy to understand Curriculum was apt and as per expectation.. interesting to learn
Course Support: Increased productivity
Reviewed on 12 Mar 2023Read More
Thumbs Up IconThumbs Down Icon
M
Mehdi Ali
Excel: Analytics Tips
Offered by Linkedin Learning
5
Learning Experience: Learning experience was good
Faculty: Instructors taught well Curriculum was relevant and comprehensive
Course Support: No career support provided
Reviewed on 4 Jun 2022Read More
Thumbs Up IconThumbs Down Icon
View All 2 ReviewsRight Arrow Icon
qna

Excel: Analytics Tips
 at 
Linkedin Learning 

Student Forum

chatAnything you would want to ask experts?
Write here...