I am pleased to share that my course, “Managing Excel Workbooks for Analytics,” is now available at Pluralsight.
Course 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.
This course, clocking in at just over two hours, is an introduction to the workbook management process with an eye toward building client-facing analytics workbooks and models.
This is done in five modules of video-based content, with access to all exercise files, slides and transcripts.
Here is an overview of the learning content:
Creating a Workbook
In this module you will learn best practices for designing an Excel workbook, and how to tell a story with your model’s design. You’ll learn the importance of using the Table object and named ranges in building an extensible Excel model.
Managing Workbooks
With your workbook up and running, learn how to copy, delete and move worksheets, along with the various advantages and disadvantages of storing and managing data across multiple worksheets and workbooks.
Forcing Workbooks to Recalculate
Learn how to stop your workbook in its tracks to debug errors and trace the relationships between formulas in your workbook.
Securing and Restricting Workbooks
You’ve put a lot of time into making this workbook a well-oiled analytics machine! Now learn how to client-proof your file by adding features like range, worksheet and workbook protection.
Recovering Workbooks and Comparing Workbook Versions
Congratulations on deploying your well-designed workbook. Now learn how to keep the ship afloat with features like AutoRecover and Spreadsheet Compare.
Serious content from a serious platform
I’m no stranger to technical instruction content development, so I know top-shelf when I see it. Pluralsight has it — they go the distance to deliver the best learner experience.
I myself upped my own data instructional chops immensely by building the course. The data chops awaiting you are even greater, with countless courses available on Excel and other topics on analytics.
Take a look for yourself by getting started with a FREE 10-day trial below. (OK, I guess the courseload isn’t “countless…” but over 5,000 is pretty close.)
Start a 10-day free trial at Pluralsight – Over 5,000 Courses Available
See you in class.
Please note I am an affiliate of Pluralsight and may receive a portion of the revenue generated by the above links
Leave a Reply