Materias: “…Microsoft Excel (Computer file)…”

Materias: “…Microsoft Excel (Computer file)…”

Materias: “…Microsoft Excel (Computer file)…”

Materias: “…Microsoft Excel (Computer file)…”

Materias: “…Microsoft Excel (Computer file)…”

Tabla de Contenidos: “…Financial Modeling with Crystal Ball and Excel; Contents; Preface; Acknowledgments; About the Author; CHAPTER 1 Introduction; 1.1 FINANCIAL MODELING; 1.2 RISK ANALYSIS; 1.3 MONTE CARLO SIMULATION; 1.4 RISK MANAGEMENT; 1.5 BENEFITS AND LIMITATIONS OF USING CRYSTAL BALL; 1.5.1 Benefits; 1.5.2 Limitations; CHAPTER 2 Analyzing Crystal Ball Forecasts; 2.1 SIMULATING A 50-50 PORTFOLIO; 2.1.1 Accumulate.xls; 2.1.2 Frequency Chart; 2.1.3 Cumulative Frequency Chart; 2.1.4 Statistics View; 2.1.5 Forecast Window Percentiles View; 2.2 VARYING THE ALLOCATIONS; 2.2.1 Decision Table Tool; 2.2.2 Trend Chart…”

Tabla de Contenidos: “…Analyzing Liquidity Ratios -- Analyzing Activity Ratios -- PART II: FINANCIAL PLANNING AND CONTROL -- 8 Budgeting and Planning Cycle -- Creating Pro Forma Financial Statements -- Using Excel to Manage the Analysis -- Moving from the Pro Forma to the Budget -- 9 Forecasting and Projections -- Making Sure You Have a Useful Baseline -- Moving Average Forecasts -- Forecasting with Excel's Regression Functions -- Forecasting with Excel's Smoothing Functions -- Using the Box-Jenkins ARIMA Approach: When Excel's Built-In Functions Won't Do -- 10 Measuring Quality -- Monitoring Quality Through Statistical Process Control -- Performing Acceptance Sampling -- Using Worksheet Functions for Quality Control -- Sampling Units from a Nonfinite Population -- PART III: INVESTMENT DECISIONS -- 11 Examining a Business Case: Investment -- Developing a Business Case -- Developing the Excel Model -- 12 Examining Decision Criteria for a Business Case -- Understanding Payback Periods -- Understanding Future Value, Present Value, and Net Present Value -- 13 Creating a Sensitivity Analysis for a Business Case -- Reviewing the Business Case -- Managing Scenarios -- Measuring Profit -- Varying the Discount Rate Input -- Using the Goal Seek Tool -- 14 Planning Profits -- Understanding the Effects of Leverage -- Analyzing Operating Leverage -- Analyzing Financial Leverage -- 15 Making Investment Decisions Under Uncertain Conditions -- Using Standard Deviations -- Understanding Confidence Intervals -- Using Regression Analysis in Decision Making -- 16 Fixed Assets -- Determining Original Cost -- Depreciating Assets -- PART IV: SALES AND MARKETING -- 17 Importing Business Data into Excel -- Creating and Using ODBC Queries -- Working with External Data Ranges -- Creating and Using Web Queries -- Using Parameterized Web Queries -- 18 Exporting Business Data from Excel…”

Materias: “…Microsoft Excel (Computer file)…”

“…Data Analysis Fundamentals with Excel…”

Materias: “…Microsoft Excel (Computer file)…”

Tabla de Contenidos: “…-- Reduce the Learning Curve -- Excel VBA Power -- Techie Stuff Needed to Produce Applications -- Does This Book Teach Excel? …”

“…Sie möchten Ihre Aufgaben mit Excel in der Version 2013 schneller und besser erledigen? …”

Materias: “…Microsoft Excel (Computer file)…”

Materias: “…Microsoft Excel (Computer file)…”

“…Both government and private organizations employ PMP certified project managers in an attempt to improve the success rate of projects in all areas of knowledge, by applying a standardized and evolving set of project management principles. PMP Certification: Excel with Ease is a self-study guide and is essential to all PMP aspirants to clear the Certification exam in the rest attempt itself. …”

Materias: “…Microsoft Excel (Computer file)…”

Materias: “…Microsoft Excel (Computer file)…”

Materias: “…Microsoft Excel (Computer file)…”

Materias: “…Microsoft Excel (Computer file)…”