Introduction to Modeling in Excel for Decision Makers

Описание: To learn more, go to: https://learning.ly/products/introduc...

Part 1 demonstrates how to use Excel efficiently. You will begin with the AutoFill, efficient selection of cells with shortcuts and learn to how to use functions and addressing correctly. Part 1 also covers naming of cells and ranges and variety of topic on how to create charts, add data to charts and inserting pictures to charts. The last session of this part is about Sparklines.

Part 2 covers two frequently needed skills: the IF function, text manipulation (text to columns), text functions and the use of the Flash Fill.

Part 3 introduces all the statistical tools you need as a decision maker, analyst or a student – without being a trained statistician. It covers descriptive statistics, frequency distributions and frequency distributions charts. You will also learn how to use the Data Analysis tool-pack add-in, simple regressions and how to fit functions to linear or nonlinear curves.

Part 4 enhances your Excel decision making skills. This is an introduction to the “What IF Analysis”, using conventional and unconventional Excel tools. The techniques will be first applied to a simple financial model. Part 4 continues with the Goal Seek, Data Tables sensitivity analysis and it ends with a business plan case study.

Part 5 demonstrates range and exact match VLOOKUP functions in the first part. The second half covers “going the third dimension”, summing several sheets to a single summary sheet.

Part 6 is about data bases and data-mining. It begins with sorting and filtering data, it covers Subtotals and Grouping data for better analysis of your database. It ends with a comprehensive set of pivot table sessions.