Microsoft Excel Functions & Formulas

  • 2h 30m
  • Bernd Held
  • Jones and Bartlett Learning
  • 2007

Equipped with a variety of functions and easy to use, Microsoft Excel is the tool of choice when it comes to crunching numbers, building charts, and analyzing tables. But most users only scratch the surface of the program's functionality, especially the built-in formulas designed to make everyday operations and real-world tasks more efficient. Microsoft Excel Functions & Formulas demonstrates the secrets of Excel functions through the use of practical and useful examples in a quick reference format. Topics include logical, text, date and time, basic statistical, mathematical, financial, database, and reference functions as well as conditional formatting with formulas, array formulas, and user-defined functions.

In this Book

  • Microsoft Excel Functions & Formulas
  • Introduction
  • Formulas in Excel
  • Logical Functions
  • Text Functions
  • Date and Time Functions
  • Basic Statistical Functions
  • Mathematical Functions
  • Basic Financial Functions
  • Database Functions
  • Lookup and Reference Functions
  • Conditional Formatting with Formulas
  • Working with Array Formulas
  • Special Solutions with Formulas
  • User-defined Functions
  • Examples
SHOW MORE
FREE ACCESS

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE