Managing Excel Workbooks for Analytics

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 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.