Formulas and Functions Microsoft Excel 2010
Book Details :
Size30.0 MB

Formulas and Functions Microsoft Excel 2010

Formulas and Functions Microsoft Excel 2010 by Paul McFedries | PDF Free Download

Main Contents of Microsoft Excel Formulas and Functions 

Part 1. Mastering Excel Ranges and Formulas

  • Chapter 1. Getting the Most Out of Ranges 
  • Chapter 2. Using Range Names 
  • Chapter 3. Building Basic Formulas 
  • Chapter 4. Creating Advanced Formulas 
  • Chapter 5. Troubleshooting Formulas 

Part 2. Harnessing the Power of Functions

  • Chapter 6. Using Functions 
  • Chapter 7. Working with Text Functions 
  • Chapter 8. Working with Logical and Information Functions 
  • Chapter 9. Working with Lookup Functions 
  • Chapter 10. Working with Date and Time Functions 
  • Chapter 11. Working with Math Functions 
  • Chapter 12. Working with Statistical Functions 

Part 3. Building Business Models

  • Chapter 13. Analyzing Data with Tables 
  • Chapter 14. Analyzing Data with PivotTables 
  • Chapter 15. Using Excel’s Business-Modeling Tools 
  • Chapter 16. Using Regression to Track Trends and Make Forecasts 
  • Chapter 17. Solving Complex Problems with Solver 

Part 4. Building Financial Formulas

  • Chapter 18. Building Loan Formulas 
  • Chapter 19. Building Investment Formulas 
  • Chapter 20. Building Discount Formulas

About the Author

Paul McFedries is an Excel expert and full-time technical writer. Paul has been authoring computer books since 1991 and has more than 60 books to his credit, which combined have sold more than 3 million copies worldwide.

His titles include the Que Publishing books Tricks of the Microsoft Office 2007 Gurus , VBA for the 2007 Microsoft Office System , Networking with Microsoft Windows Vista , and Tweak It and Freak It:

A Killer Guide to Making Windows Run Your Way , as well as the Sams Publishing book Windows 7 Unleashed . Paul is also the proprietor of Word Spy ( ), a website devoted to lexpionage , the sleuthing of new words and phrases that have entered the English language.

Please drop by Paul’s personal website at or follow Paul on Twitter at paulmcf .

Introduction to Microsoft Excel Formulas and Functions eBook

The old 80/20 rule for software—that 80% of a program’s users use only 20% of a program’s features—doesn’t apply to Microsoft Excel.

Instead, this program probably operates under what could be called the 95/5 rule: Ninety-five percent of Excel users use a mere 5% of the program’s power.

On the other hand, most people know that they could be getting more out of Excel if they could only get a leg up on building formulas and using functions.

Unfortunately, this side of Excel appears complex and intimidating to the uninitiated, shrouded as it is in the mysteries of mathematics, finance, and impenetrable spreadsheet jargon.

If this sounds like the situation you find yourself in, and if you’re a businessperson who needs to use Excel as an everyday part of your job, you’ve come to the right book.

Get Also: Excel 2019 All in One For Dummies by Greg Harvey

In Formulas and Functions with Microsoft Excel 2010 , I demystify the building of worksheet formulas and present the most useful of Excel’s many functions in an accessible, jargon-free way.

This book not only takes you through Excel’s intermediate and advanced formula-building features, but it also tells you why these features are useful to you and shows you how to use them in everyday situations and real-world models.

This book does all this with no-nonsense, step-by-step tutorials and lots of practical, useful examples aimed directly at business users.

Even if you’ve never been able to get Excel to do much beyond storing data and adding a couple of numbers, you’ll find this book to your liking.

I show you how to build useful, powerful formulas from the ground up, so no experience with Excel formulas and functions is necessary.

Download Formulas and Functions Microsoft Excel 2010 in PDF Format For Free