Filter
Add to wishlist

The Facilitator Excellence Handbook (Pfeiffer Essential Resources for Training and HR Professionals) eBook

$11.00

  • Delivery: Can be download immediately after purchasing. For new customer, we need process for verification from 30 mins to 24 hours.
  • Version: PDF/EPUB. If you need another version, please Contact us
  • Quality: Full page, full content, high quality images, searchable text and you can print it.
  • Compatible Devices: Can be read on any devices (Kindle, NOOK, Android/IOS devices, Windows, MAC,..).
  • e-Book Features: Purchase and read your book immediately, access your eTextbook anytime and anywhere, unlimited download and share with friends.
  • Note: If you do not receive the download link within 15 minutes of your purchase, please Contact us. Thank you!
  • 5% off all orders over $25 with code:: 5OFF2024
  • 10% off all orders over $50 with code: 10OFF2024
SKU: 9780787979805 Categories: ,

“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

В