Managing Excel Workbooks for Analytics

Learn to build an analytics product in Excel, from workbook design principles to methods for recovering and comparing versions.
Course info
Level
Beginner
Updated
Jan 28, 2020
Duration
2h 10m
Table of contents
Description
Course info
Level
Beginner
Updated
Jan 28, 2020
Duration
2h 10m
Description

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.

About the author
About the author

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

Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone. My name is George Mountain and welcome to my course managing Excel Workbooks for analytics. I'm the founder of String Fussed Analytics, where I specialize in building data capacities through education excels. Accessibility makes it great for bowling client facing analytics products To make the most of this media workbook management is key in this course. We're going to cover the foundations of creating and maintaining a cell workbooks that are easy to use and hard to break. Some of the major topics that we will cover include the principles of work with design formula, debugging techniques, client proving your models and managing the distribution of your final product. By the end of this course, you'll be able to create analytics workbooks that are built to last before beginning the course. You should be familiar with Intermediate Excel functions such a summit and you look up from here. You should feel comfortable diving into Excel Analytics of courses on data cleaning and preparation, advanced data analysis and building financial and statistical models in Excel. I hope you'll join me on this journey to learn Excel Workbook Management with the Managing Excel Workbooks for Analytics course at plural site