Course Description

Escape the hell of bad spreadsheets....

Data literacy is an essential skill in today's economy. Analysts commonly spend the majority of their day cleaning data.

No matter your company or industry, you probably use Excel.

Many of the greatest pains in sharing spreadsheets can be fixed with a few pointers.

In this course I walk through my 10 Commandments of Spreadsheet Collaboration -- what not to do with spreadsheets, and what to do when you see problems.

Analyst, Educator and Consultant at georgejmount.com

George Mount

Armed with a liberal arts degree and a master’s from a leading business school, I set out into the world to become an amazing analyst. Over the past few years I have worked on projects ranging from Canadian retailing to neurosurgeon compensation. Through this experience, I’ve noticed patterns of what makes a good analyst. Specifically, I’ve seen the best and worst in Microsoft Excel and data analysis. My online training is meant as a resource for recent grads and others who want to advance their career through Microsoft Excel, data analytics, and business economics.I've been featured on Excel TV, the Smart Data Collective, Brazen Careerist, and other blogs about business analytics and career development.

Course curriculum

  • 1

    The Ten Commandments of Spreadsheet Collaboration

    • Introduction

    • What Do You Gain from this Course?

    • I. Have No Other Formats Before Excel

    • II. Send the Spreadsheet Ready to Print

    • III. Do Not Send the Spreadsheet in Page Break Preview

    • IV. Do Not Send the Spreadsheet with Multiple Worksheets Selected

    • V. Use a Primary Key in Your Workbook

    • VI. Identify Inputs, Calculation, and Outputs

    • VII. Be Explicit About Hidden Data

    • VIII. Use Cell Anchoring

    • IX. Align Column Labels with Data

    • X. Do Not Hardcode Values That May Change

    • Next Steps

    • Resources