10 Commandments of Spreadsheet Collaboration

Escape the Hell of Bad Spreadsheets | taught by George Mount

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.

George Mount
George Mount
PhD student, Excel enthusiast

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

The Ten Commandments of Spreadsheet Collaboration
36:52
Introduction FREE
What Do You Gain from this Course? FREE
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 FREE
VIII. Use Cell Anchoring
IX. Align Column Labels with Data
X. Do Not Hardcode Values That May Change
Next Steps
Resources
Show Content