Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Managing Excel Workbooks for Analytics

via Pluralsight

Overview

Coursera Plus Annual Sale:
All Certificates & Courses 50% Off!
Grab it


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

Reviews

Start your review of Managing Excel Workbooks for Analytics

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.