Managing Excel Workbooks for Analytics
Offered By: Pluralsight
Course Description
Overview
Learn to build an analytics product in Excel, from workbook design principles to methods for recovering and comparing versions.
Excel’s accessibility makes it great for building client-facing analytics products. To make the most of this medium, workbook management is key. In this course, Managing Excel 2016 Workbooks for Analytics, you will gain the ability to create and maintain workbooks that are easy to use and hard to break. First, you will learn the principles of workbook design. Next, you will discover how to debug and audit cell formulas. Finally, you will explore how to secure, restrict and maintain a workbook. When you are finished with this course, you will have the skills and knowledge of workbook management needed to build analytics products in Excel.
Excel’s accessibility makes it great for building client-facing analytics products. To make the most of this medium, workbook management is key. In this course, Managing Excel 2016 Workbooks for Analytics, you will gain the ability to create and maintain workbooks that are easy to use and hard to break. First, you will learn the principles of workbook design. Next, you will discover how to debug and audit cell formulas. Finally, you will explore how to secure, restrict and maintain a workbook. When you are finished with this course, you will have the skills and knowledge of workbook management needed to build analytics products in Excel.
Syllabus
- Course Overview 1min
- Creating a Workbook 17mins
- Managing Workbooks 34mins
- Forcing Workbooks to Recalculate 18mins
- Securing and Restricting Workbooks 24mins
- Recovering Workbooks and Comparing Workbook Versions 34mins
Taught by
George Mount
Related Courses
Introduction to Computational Finance and Financial EconometricsUniversity of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard