eShare.CC

EBook Description

Develop your Microsoft Excel expertise instantly with proven techniques

• Master Excel Ranges
• Create Powerful Arrays
• Troubleshoot Formula Problems
• Validate Worksheet Data
• Perform What-If Analysis
• Model Your Business
• Track Trends and Make
• Forecasts
• Analyze Data
• Find Optimal Solutions
• Build Dynamic Loan
• Schedules

Introduction

• 1 Getting the Most Out of Ranges
• 2 Using Range Names
• 3 Building Basic Formulas
• 4 Creating Advanced Formulas
• 5 Troubleshooting Formulas
• II Harnessing the Power of Functions
• 6 Understanding Functions
• 7 Working with Text Functions
• 8 Working with Logical and Information Functions
• 9 Working with Lookup Functions
• 10 Working with Date and Time Functions
• 11 Working with Math Functions
• 12 Working with Statistical Functions
• III Building Business Models
• 13 Analyzing Data with Tables
• 14 Analyzing Data with PivotTables
• 15 Using Excel’s Business-Modeling Tools
• 16 Using Regression to Track Trends and Make Forecasts
• 17 Solving Complex Problems with Solver
• IV Building Financial Formulas
• 18 Building Loan Formulas
• 19 Building Investment Formulas
• 20 Building Discount Formulas

EBook Details

• Paperback: 552 pages
• Publisher: Que; 1 edition (March 24, 2007)
• Language: English
• ISBN-10: 0789736683
• ISBN-13: 978-0789736680
• File Size: 14.7 MB

EBook Download

Mirror 1 | Mirror 2