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.
1.1 Objectives and a Little Spreadsheet History
Habilidades que você aprenderá
Monte Carlo Method, Microsoft Excel, Linear Programming (LP), Solver
Avaliações
BH
Sep 12, 2017
So many tools that I knew existed and have tried to use the How-To's to learn how they work and until the Prof takes you through them one-at-a-time, they never make sense. Great Stuff!
DA
Feb 07, 2017
A particularly useful course. It built on my existing Excel knowledge and "expertise". I really enjoyed it, as all the skills learned in this course can be applied in the real world.
This module was designed to introduce you to the history of spreadsheets, their basic capabilities, and how they can be used to create models. You'll learn the different types of data used in spreadsheets, spreadsheet notations for mathematical operations, common built-in formulas and functions, conditional expressions, relative and absolute references, and how to identify and correct circular references. By the end of this module, you'll understand the context of spreadsheets, be able to navigate a spreadsheet, use built-in formulas and functions in spreadsheets, create your own simple formulas, and identify and correct common errors so you can put spreadsheets to work for you.
Ministrado por
Don Huesman
Managing Director, Wharton Online
Explore nosso catálogo
Registre-se gratuitamente e obtenha recomendações, atualizações e ofertas personalizadas.
