Formulas and functions with Microsoft Office Excel 2007

Format:

Book

Author/Creator:

McFedries, Paul, Author.

Series:

Business solutions

Business solutions Formulas and functions with Microsoft Office Excel 2007

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Business--Computer programs.

Business.

Electronic spreadsheets.

Physical Description:

1 online resource (552 pages)

Edition:

1st edition

Place of Publication:

[Place of publication not identified] Que 2007

Language Note:

English

System Details:

text file

Summary:

“If you’ve never quite grasped formulas and functions, Paul McFedries will radically expand your understanding and use of Excel. And if you’re already an expert and you’re moving up to Excel 2007, this book will quickly show you features you’ve only dreamed of until now...” —Thomas ‘Duffbert’ Duff, Duffbert’s Random Musings, http://www.twduff.com 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 Most Microsoft® Excel users learn only a small percentage of the program’s features. They know they could get more out of Excel if they could just get a leg up on building formulas and using functions. Unfortunately, this side of Excel appears complex and intimidating to the uninitiated—shrouded in the mysteries of mathematics, finance, and impenetrable spreadsheet jargon. Sound familiar? If you’re a businessperson who needs to use Excel as an everyday part of your job, then you’ve come to the right book. Formulas and Functions with Microsoft® Office Excel 2007 demystifies worksheet formulas and presents the most useful Excel functions in an accessible, jargon-free way. This book not only takes you through Excel’s intermediate and advanced formula-building features, it also tells you why these features are useful to you and shows you how to use them in everyday situations. Throughout the book you’ll find no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users. • Focuses like a laser on the four technologies that you must master to get the most out of Excel: ranges, formulas, functions, and data analysis tools. • Shuns spreadsheet theory in favor of practical know-how that you can put to use right away. • Provides numerous real-world examples and techniques to help you learn and understand the importance of each section. 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 ...

Contents:

Introductio

Mastering Excel ranges and formulas

Getting the most out of ranges

Using range names

Building basic formulas

Creating advanced formulas

Troubleshooting formulas

Harnessing the power of functions

Understanding functions

Working with text functions

Working with logical and information functions

Working with lookup functions

Working with date and time functions

Working with math functions

Working with statistical functions

Building business models

Analyzing data with tables

Analyzing data with PivotTables

Using Excel's business-modeling tools

Using regression to track trends and make forecasts

Solving complex problems with Solver

Building financial formulas

Building loan formulas

Building investment formulas

Building discount formulas

Index.

Notes:

Bibliographic Level Mode of Issuance: Monograph

ISBN:

9786612649196

9781282649194

1282649191

9780768674590

076867459X

OCLC:

123904741