Tabla de Contenidos: “…-- Loading the Solver add-in -- Optimizing a result with Solver -- Adding constraints to Solver -- Save a Solver solution as a scenario -- Chapter 3 Introducing Excel Tables -- What Is a Table and Why Should I Care? …”

Tabla de Contenidos: “…Measuring variance -- Analyzing deviations -- Looking for normal distribution -- Skewing from the norm -- Comparing data sets -- Analyzing Data with Percentiles and Bins -- QUARTILE.INC and QUARTILE.EXC -- PERCENTILE.INC and PERCENTILE.EXC -- RANK -- PERCENTRANK -- FREQUENCY -- MIN and MAX -- LARGE and SMALL -- Going for the Count -- COUNT and COUNTA -- COUNTIF -- Chapter 10 Using Significance Tests -- Testing to the T -- Comparing Results with an Estimate -- Chapter 11 Rolling the Dice on Predictions and Probability -- Modeling -- Linear model -- Exponential model -- Getting It Straight: Using SLOPE and INTERCEPT to Describe Linear Data -- What's Ahead: Using FORECAST, TREND, and GROWTH to Make Predictions -- FORECAST -- TREND -- GROWTH -- Using NORM.DIST and POISSON.DIST to Determine Probabilities -- NORM.DIST -- POISSON.DIST -- Part 4 Dancing with Data -- Chapter 12 Dressing Up for Date Functions -- Understanding How Excel Handles Dates -- Formatting Dates -- Making a Date with DATE -- Breaking a Date with DAY, MONTH, and YEAR -- Isolating the day -- Isolating the month -- Isolating the year -- Converting a Date from Text -- Finding Out What TODAY Is -- Counting the days until your birthday -- Counting your age in days -- Determining the Day of the Week -- Working with Workdays -- Determining workdays in a range of dates -- Workdays in the future -- Calculating Time Between Two Dates with the DATEDIF Function -- Chapter 13 Keeping Well-Timed Functions -- Understanding How Excel Handles Time -- Formatting Time -- Keeping TIME -- Converting Text to Time with TIMEVALUE -- Deconstructing Time with HOUR, MINUTE, and SECOND -- Isolating the hour -- Isolating the minute -- Isolating the second -- Finding the Time NOW -- Calculating Elapsed Time Over Days -- Chapter 14 Using Lookup, Logical, and Reference Functions -- Testing on One Condition…”

Tabla de Contenidos: “…-- Inserting a bunch of text -- Automating a task you perform frequently -- Automating repetitive operations -- Creating a custom command -- Creating a custom button -- Developing new worksheet functions -- Creating custom add-ins for Excel -- Advantages and Disadvantages of VBA -- VBA advantages -- VBA disadvantages -- VBA in a Nutshell -- Excel Compatibility -- Chapter 2 Jumping Right In -- First Things First -- What You'll Be Doing -- Taking the First Steps -- Recording the Macro -- Testing the Macro -- Examining the Macro -- Modifying the Macro -- Saving Workbooks That Contain Macros -- Understanding Macro Security -- Revealing More about the NameAndTime Macro -- Part 2 How VBA Works with Excel -- Chapter 3 Working in the Visual Basic Editor -- What Is the Visual Basic Editor? …”

“…Você usa o Excel para fazer listas simples, mas se perde quando tenta usar as funções? …”

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

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

Tabla de Contenidos: “…Intro -- Title Page -- Copyright Page -- Table of Contents -- Introduction -- About this Book -- Obligatory Typographical Conventions Section -- Check Your Security Settings -- Foolish Assumptions -- Icons Used in This Book -- Beyond the Book -- Where to Go from Here -- Part I Getting Started with Excel VBA Programming -- Chapter 1 What Is VBA? -- Okay, So What Is VBA? …”

Tabla de Contenidos: “…section 1. 12 principles of manufacturing excellence -- section 2. Leading manufacturing excellence…”

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

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

“…Jeff Havens’s Professional Excellence fills that gap,bringing together crucial knowledge anyone can use to excel. …”

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

“…Turn jumbles of numbers into graphics, insights, and answers with Excel With Microsoft Excel, you can, well, excel at data analysis. …”

“…Find out what Excel is capable of with this step-by-step guide to VBA Short of changing the tires on your car, Microsoft Excel can do pretty much anything. …”

Tabla de Contenidos: “…-- Linking To External Files -- Building Error Checks -- Summary -- Notes -- Chapter 5 Using Excel In Financial Modelling -- Formulas And Functions In Excel -- Excel Versions -- Handy Excel Shortcuts -- Basic Excel Functions -- Logical Functions -- Nesting: Combining Simple Functions To Create Complex Formulas -- Cell Referencing Best Practices -- Named Ranges -- Summary -- Chapter 6 Functions For Financial Modelling -- Aggregation Functions -- Lookup Formulas -- Nesting Index And Match -- Offset Function -- Regression Analysis -- Choose Function -- Working With Dates -- Financial Project Evaluation Functions -- Loan Calculations -- Summary -- Chapter 7 Tools For Model Display -- Basic Formatting…”

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

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

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