Managing Excel 2016 Workbooks for Analytics

Focused View

George Mount

2:10:07

69 View

0. Course Overview

0. Course Overview.mp4

01:21

1. Creating a Workbook

0. Introduction.mp4

02:42

1. Demo Files.mp4

00:43

2. Demo- Input, Process, Output.mp4

01:56

3. Excel Tables and Workbook Management.mp4

01:36

4. Demo- Excel Tables.mp4

04:06

5. Demo- Named References.mp4

05:24

6. Summary.mp4

01:07

2. Managing Workbooks

0. Introduction.mp4

02:20

1. Demo- Organizing Worksheets in a Workbook.mp4

06:20

2. Demo- Viewing Worksheets in a Workbook.mp4

06:39

3. Demo- Grouping Worksheets in a Workbook.mp4

05:15

4. Demo- Summarizing with 3-D References.mp4

03:56

5. Demo- Returning References with INDIRECT().mp4

04:21

6. Demo- Referencing Worksheets from a Different Workbook.mp4

04:39

7. Summary.mp4

01:19

3. Forcing Workbooks to Recalculate

0. Introduction.mp4

02:01

1. Demo- Workbook Calculation Options.mp4

04:23

2. Demo- Tracking Values with the Watch Window.mp4

02:40

3. Demo- Debugging with Formula Audit.mp4

08:08

4. Summary.mp4

00:50

4. Securing and Restricting Workbooks

0. Introduction.mp4

01:07

1. Demo- Data Validation.mp4

07:20

2. Demo- Protecting Ranges and Worksheets.mp4

04:46

3. Demo- Protecting Workbooks.mp4

05:17

4. Demo- Removing Workbook Metadata.mp4

04:07

5. Summary.mp4

01:36

5. Recovering Workbooks and Comparing Workbook Versions

0. Introduction.mp4

01:24

1. Demo- Recovering Workbooks.mp4

05:08

2. Demo- AutoSaving Workbooks.mp4

04:31

3. Demo- Tracking Workbook Changes.mp4

06:35

4. Demo- Workbook Co-authoring.mp4

05:02

5. Demo- Spreadsheet Compare.mp4

06:35

6. Conclusion.mp4

01:59

7. Course Wrap-up and Further Learning.mp4

02:54

Description

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

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Data Analysis

Excel

Excel Analytics

George Mount

Instructor's Courses

Based in Cleveland, Ohio, George is a data analyst and educator specializing in developing content for business analytics. Key platforms in Excel, R and SQL. George's goal is to help analysts manage their data for more creative thinking about their business. George blogs about data analytics and careers at georgejmount.com.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.