Featured resource
2026 Tech Forecast
2026 Tech Forecast

Stay ahead of what’s next in tech with predictions from 1,500+ business leaders, insiders, and Pluralsight Authors.

Get these insights
  • Course

Managing Excel 2016 Workbooks for Analytics

Learn to build an analytics product in Excel, from workbook design principles to methods for recovering and comparing versions.

Beginner
2h 10m
(8)

Created by George Mount

Last Updated Nov 01, 2023

Course Thumbnail
  • Course

Managing Excel 2016 Workbooks for Analytics

Learn to build an analytics product in Excel, from workbook design principles to methods for recovering and comparing versions.

Beginner
2h 10m
(8)

Created by George Mount

Last Updated Nov 01, 2023

Get started today

Access this course and other top-rated tech content with one of our business plans.

Try this course for free

Access this course and other top-rated tech content with one of our individual plans.

This course is included in the libraries shown below:

  • Data
What you'll learn

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.

Managing Excel 2016 Workbooks for Analytics
Beginner
2h 10m
(8)
Table of contents

About the author
George Mount - Pluralsight course - Managing Excel 2016 Workbooks for Analytics
George Mount
1 courses 0.0 author rating 0 ratings

George is a data analyst and educator specializing in developing content for business analytics, particularly Excel and R.

Get started with Pluralsight