Formulas and Functions with Microsoft Office Excel 2007 and over one million other books are available for Amazon Kindle. Learn more

Sorry, this item is not available in
Image not available for
Color:
Image not available

To view this video download Flash Player

 


or
Sign in to turn on 1-Click ordering
More Buying Choices
Have one to sell? Sell yours here
Start reading Formulas and Functions with Microsoft Office Excel 2007 on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Formulas and Functions with Microsoft Office Excel 2007 [Paperback]

Paul McFedries
4.5 out of 5 stars  See all reviews (8 customer reviews)

List Price: $39.99
Price: $32.79 & FREE Shipping on orders over $35. Details
You Save: $7.20 (18%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 5 left in stock (more on the way).
Ships from and sold by Amazon.com. Gift-wrap available.
Want it Tuesday, July 15? Choose One-Day Shipping at checkout. Details
Free Two-Day Shipping for College Students with Amazon Student

Formats

Amazon Price New from Used from
Kindle Edition $19.19  
Paperback $32.79  
Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Book Description

March 24, 2007 0789736683 978-0789736680 1

“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

 


Frequently Bought Together

Formulas and Functions with Microsoft Office Excel 2007 + Learn Excel 2007 Expert Skills with The Smart Method: Courseware Tutorial teaching Advanced Techniques
Price for both: $53.13

Buy the selected items together


Editorial Reviews

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).


Product Details

  • Paperback: 552 pages
  • Publisher: Que Publishing; 1 edition (March 24, 2007)
  • Language: English
  • ISBN-10: 0789736683
  • ISBN-13: 978-0789736680
  • Product Dimensions: 8.7 x 6.7 x 1.2 inches
  • Shipping Weight: 1.8 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (8 customer reviews)
  • Amazon Best Sellers Rank: #957,339 in Books (See Top 100 in Books)

More About the Author

Paul McFedries runs Logophilia Limited, a technical writing company, and has been writing computer books for more than 17 years. He is the author or coauthor of more than 60 books that have sold more than 3 million copies worldwide. Paul is also the proprietor of Wordspy.com, a website that tracks new words and phrases as they enter the language.

Customer Reviews

4.5 out of 5 stars
(8)
4.5 out of 5 stars
Share your thoughts with other customers
Most Helpful Customer Reviews
17 of 18 people found the following review helpful
4.0 out of 5 stars Good Review of Formulas and Functions December 2, 2007
Format:Paperback
This book does a nice job on reviewing formulas and functions. It covers a lot of functions that other books gloss over or don't mention such as arrays, rounding, date/time functions etc.It spends a lot of time on logic and lookup functions. Best of all, it uses good business examples that help explain how to use the function. My big gripe with the book is that at times it skips details and just assumes the reader knows how to do something or understands why you would want to do something. Personally, I think the 2003 version explained details a little bit better however I still think that this is one of the better books out there for people wanting to use formulas and functions in a business environment. If you are looking for a book on solver and what-if however there are a lot better books out there.
Was this review helpful to you?
3 of 3 people found the following review helpful
3.0 out of 5 stars good, but was hoping for more... October 6, 2011
Format:Paperback|Verified Purchase
really was hoping to find a wealth of great information and formulas and how to's and real world implications etc etc etc....but it wasn't exactly what i was looking for or what i expected. AND it doesn't even include some of the coolest features and capabilities that i've discovered about excel. this is a good book if you're LITERALLY just looking for a bland, straightforward look at formulas and functions sans any insight into how powerful and cool excel really is!
p.s. NO, i'm not a math teacher! LOL
Comment | 
Was this review helpful to you?
5 of 6 people found the following review helpful
5.0 out of 5 stars great book November 14, 2009
Format:Paperback|Verified Purchase
I learned a ton with this book and totally changed the way I do my job. It clearly explains a ton of formula and methods to speed you up. The index in the back it very helpful too.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Great Book May 2, 2014
Format:Paperback|Verified Purchase
This book is great for folks are just need a refresher in writing formulas and using the functions. shipped on time
Comment | 
Was this review helpful to you?



What Other Items Do Customers Buy After Viewing This Item?


Forums

There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
Topic:
First post:
Prompts for sign-in
 



Look for Similar Items by Category