Formulas and Functions with Microsoft Office Excel 2007

4 avg rating
( 12 ratings by Goodreads )
 
9780789736680: Formulas and Functions with Microsoft Office Excel 2007
View all copies of this ISBN edition:
 
 

“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  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


Paul McFedries is well-known as a teacher of Windows and Office, particularly Excel, and is the president of Logophilia Limited, a technical writing company. Paul has been working with spreadsheets for more than 20 years and has been developing Excel solutions since the late 1980s. Now primarily a writer, Paul has written more than 50 books that have sold more than three million copies worldwide. These books include Microsoft Office Access 2007 Forms, Reports, and Queries; Tricks of the Microsoft Office 2007 Gurus (all from Que); and Microsoft Windows Vista Unleashed (Sams).

 

Category  Office Productivity Suite

Covers    Microsoft Office Excel 2007

User Level         Intermediate - Advanced

 

"synopsis" may belong to another edition of this title.

About the Author:

Paul McFedries is the president of Logophilia Limited, a technical writing company. Now primarily a writer, Paul has worked as a programmer, consultant, spreadsheet developer, and website developer. He has written more than 50 books that have sold more than three million copies worldwide. These books include Access 2007 Forms, Reports, and Queries (Que, 2007), Tricks of the Microsoft Office 2007 Gurus (Que, 2007), VBA for the 2007 Microsoft Office System (Que, 2007), and Windows Vista Unleashed (Sams, 2006).

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

McFedries, Paul
Published by Que Publishing
ISBN 10: 0789736683 ISBN 13: 9780789736680
New PAPERBACK Quantity Available: 1
Seller:
Orion Tech
(Grand Prairie, TX, U.S.A.)
Rating
[?]

Book Description Que Publishing. PAPERBACK. Condition: New. 0789736683 . Seller Inventory # Z0789736683ZN

More information about this seller | Contact this seller

Buy New
US$ 30.43
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

2.

McFedries, Paul
Published by Que 3/1/2007 (2007)
ISBN 10: 0789736683 ISBN 13: 9780789736680
New Paperback or Softback Quantity Available: 10
Seller:
BargainBookStores
(Grand Rapids, MI, U.S.A.)
Rating
[?]

Book Description Que 3/1/2007, 2007. Paperback or Softback. Condition: New. Formulas and Functions with Microsoft Office Excel 2007. Book. Seller Inventory # BBS-9780789736680

More information about this seller | Contact this seller

Buy New
US$ 30.44
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

3.

McFedries, Paul
Published by Que Publishing
ISBN 10: 0789736683 ISBN 13: 9780789736680
New PAPERBACK Quantity Available: 15
Seller:
Lakeside Books
(Benton Harbor, MI, U.S.A.)
Rating
[?]

Book Description Que Publishing. PAPERBACK. Condition: New. 0789736683 Brand New Direct from the Publisher! Not overstocks or marked up remainders! Ships in a sturdy cardboard container with tracking!. Seller Inventory # OTF-9780789736680

More information about this seller | Contact this seller

Buy New
US$ 26.66
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

4.

Paul McFedries
Published by Pearson Education (2007)
ISBN 10: 0789736683 ISBN 13: 9780789736680
New Quantity Available: > 20
Print on Demand
Seller:
Pbshop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description Pearson Education, 2007. PAP. Condition: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # IQ-9780789736680

More information about this seller | Contact this seller

Buy New
US$ 28.31
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

5.

Paul McFedries
Published by Que Publishing (2007)
ISBN 10: 0789736683 ISBN 13: 9780789736680
New Paperback Quantity Available: 1
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Que Publishing, 2007. Paperback. Condition: New. 1. Seller Inventory # DADAX0789736683

More information about this seller | Contact this seller

Buy New
US$ 29.85
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

6.

Paul McFedries
Published by Pearson Education (US), United States (2007)
ISBN 10: 0789736683 ISBN 13: 9780789736680
New Paperback Quantity Available: 10
Print on Demand
Seller:
Book Depository International
(London, United Kingdom)
Rating
[?]

Book Description Pearson Education (US), United States, 2007. Paperback. Condition: New. Language: English . Brand New Book ***** Print on Demand *****. 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, Develop your Microsoft Excel expertise instantly with proven techniquesMaster Excel RangesCreate Powerful ArraysTroubleshoot Formula ProblemsValidate Worksheet DataPerform What-If AnalysisModel Your BusinessTrack Trends and Make ForecastsAnalyze DataFind Optimal SolutionsBuild Dynamic Loan Schedules Most Microsoft (R) 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 (R) 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. Introduction1 Getting the Most Out of Ranges2 Using Range Names3 Building Basic Formulas4 Creating Advanced Formulas5 Troubleshooting FormulasII Harnessing the Power of Functions 6 Understanding Functions7 Working with Text Functions8 Working with Logical and Information Functions9 Working with Lookup Functions10 Working with Date and Time Functions11 Working with Math Functions12 Working with Statistical FunctionsIII Building Business Models 13 Analyzing Data with Tables14 Analyzing Data with PivotTables15 Using Excel s Business-Modeling Tools16 Using Regression to Track Trends and Make Forecasts17 Solving Complex Problems with SolverIV Building Financial Formulas 18 Building Loan Formulas19 Building Investment Formulas20 Building Discount FormulasPaul McFedries is well-known as a teacher of Windows and Office, particularly Excel, and is the president of Logophilia Limited, a technical writing company. Paul has been working with spreadsheets for more than 20 years and has been developing Excel solutions since the late 1980s. Now primarily a writer, Paul has written more than 50 books that have sold more than three million copies worldwide. These books include Microsoft Office Access 2007 Forms, Reports, and Queries; Tricks of the Microsoft Office 2007 Gurus (all from Que); and Microsoft Windows Vista Unleashed (Sams). Category Office Productivity SuiteCovers Microsoft Office Excel 2007User Level Intermediate - Advanced. Seller Inventory # APC9780789736680

More information about this seller | Contact this seller

Buy New
US$ 36.80
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

7.

McFedries, Paul
Published by Que Publishing (2007)
ISBN 10: 0789736683 ISBN 13: 9780789736680
New Paperback Quantity Available: 10
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Que Publishing, 2007. Paperback. Condition: New. Seller Inventory # INGM9780789736680

More information about this seller | Contact this seller

Buy New
US$ 32.88
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

8.

Paul McFedries
Published by Pearson Education (US), United States (2007)
ISBN 10: 0789736683 ISBN 13: 9780789736680
New Paperback Quantity Available: 10
Print on Demand
Seller:
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description Pearson Education (US), United States, 2007. Paperback. Condition: New. Language: English . Brand New Book ***** Print on Demand *****. 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, Develop your Microsoft Excel expertise instantly with proven techniquesMaster Excel RangesCreate Powerful ArraysTroubleshoot Formula ProblemsValidate Worksheet DataPerform What-If AnalysisModel Your BusinessTrack Trends and Make ForecastsAnalyze DataFind Optimal SolutionsBuild Dynamic Loan Schedules Most Microsoft (R) 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 (R) 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. Introduction1 Getting the Most Out of Ranges2 Using Range Names3 Building Basic Formulas4 Creating Advanced Formulas5 Troubleshooting FormulasII Harnessing the Power of Functions 6 Understanding Functions7 Working with Text Functions8 Working with Logical and Information Functions9 Working with Lookup Functions10 Working with Date and Time Functions11 Working with Math Functions12 Working with Statistical FunctionsIII Building Business Models 13 Analyzing Data with Tables14 Analyzing Data with PivotTables15 Using Excel s Business-Modeling Tools16 Using Regression to Track Trends and Make Forecasts17 Solving Complex Problems with SolverIV Building Financial Formulas 18 Building Loan Formulas19 Building Investment Formulas20 Building Discount FormulasPaul McFedries is well-known as a teacher of Windows and Office, particularly Excel, and is the president of Logophilia Limited, a technical writing company. Paul has been working with spreadsheets for more than 20 years and has been developing Excel solutions since the late 1980s. Now primarily a writer, Paul has written more than 50 books that have sold more than three million copies worldwide. These books include Microsoft Office Access 2007 Forms, Reports, and Queries; Tricks of the Microsoft Office 2007 Gurus (all from Que); and Microsoft Windows Vista Unleashed (Sams). Category Office Productivity SuiteCovers Microsoft Office Excel 2007User Level Intermediate - Advanced. Seller Inventory # APC9780789736680

More information about this seller | Contact this seller

Buy New
US$ 38.08
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

9.

Paul McFedries
Published by Que Publishing (2007)
ISBN 10: 0789736683 ISBN 13: 9780789736680
New Softcover Quantity Available: 1
Seller:
Irish Booksellers
(Portland, ME, U.S.A.)
Rating
[?]

Book Description Que Publishing, 2007. Condition: New. book. Seller Inventory # M0789736683

More information about this seller | Contact this seller

Buy New
US$ 35.19
Convert currency

Add to Basket

Shipping: US$ 3.27
Within U.S.A.
Destination, rates & speeds

10.

Paul McFedries
Published by Pearson Education (2007)
ISBN 10: 0789736683 ISBN 13: 9780789736680
New Quantity Available: > 20
Print on Demand
Seller:
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description Pearson Education, 2007. PAP. Condition: New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # IQ-9780789736680

More information about this seller | Contact this seller

Buy New
US$ 29.81
Convert currency

Add to Basket

Shipping: US$ 11.52
From United Kingdom to U.S.A.
Destination, rates & speeds

There are more copies of this book

View all search results for this book