Introduction to Spreadsheets and Models

The simple spreadsheet is one of the most powerful data analysis tools that exists, and it’s available to almost anyone. Major corporations and small businesses alike use spreadsheet models to determine where key measures of their success are now, and where they are likely to be in the future. But in order to get the most out of a spreadsheet, you have the know-how to use it. This course is designed to give you an introduction to basic spreadsheet tools and formulas so that you can begin harness the power of spreadsheets to map the data you have now and to predict the data you may have in the future. Through short, easy-to-follow demonstrations, you’ll learn how to use Excel or Sheets so that you can begin to build models and decision trees in future courses in this Specialization. Basic familiarity with, and access to, Excel or Sheets is required.

None

Syllabus

Syllabus - What you will learn from this course
Week 1
Spreadsheets: A Tool for Thinking with Numbers
Week 2
From Spreadsheet to Model
Week 3
Addressing Uncertainty and Probability in Models
Week 4
Simulation and Optimization

FAQ

When will I have access to the lectures and assignments?

Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:

What will I get if I subscribe to this Specialization?

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Reviews

This course has made me understand cost accounting, has provided a fresh perspective on how to solve some of the challenges i had with management accounting and as a bonus, made me love maths again :)

The course structure is easy to understand and follow. The content may be too easy for those with Excel proficiency. Assignments that require students to use Excel can deepening the learning.

Course was generally very good...however, apologies if I've missed it, but doesn't appear to be a way to get a transcript of the lectures. Not ideal for taking learnings into practice.

Don Huesman did a great job of discussing and demonstrating the uses of Excel in cash flow analysis and other useful ways to manipulate spreadsheets to tell a story with data