YoVDO

Managing Excel Workbooks for Analytics

Offered By: Pluralsight

Tags

Microsoft Excel Courses

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.

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 Econometrics
University 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