Excel
Analytics Tips
Deepen your Excel knowledge by picking up powerful and effective analytics techniques used by Excel pros. 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. Note: Chris uses Microsoft Office 365 ProPlus for PC throughout the course, so some tips may not apply to all versions of Excel.
Contents:
- Introduction
- 1. Analytics Tips
- Conclusion
Get a Reminder
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Knowledge Management Support $44k
Knowledge Technician $50k
SharePoint Knowledge Engineers $55k
Knowledge Management Architect $64k
Excel Reporting Developer $68k
Knowledge Strategist $73k
Communications & Knowledge Analyst $76k
Excel/Access DTS Developers $78k
Excel VBA Developer $82k
Tutor - Accounting/ Excel /ESL $87k
Knowledge Base Leader $87k
Knowledge Broker $102k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course