Microsoft Excel Formulas & Functions For Dummies, 5ed

Ken Bluttman
  • ISBN: 9789390466733

Description

There are more than 400 built-in functions in Excel X, from AGGREGATE to Z.TEST. The question is which ones will make my work easier? How and why should I use a particular function in my formulas? Excel Formulas and Functions For Dummies, 5th Edition is a thorough but easy-to-read coverage of powerful Excel functions. This book gives detailed step-by-step instruction on Excel's 150 most useful functions. The use of each function will be illustrated by helpful, real-world examples showing how a function is used within a formula. Another 85 specialized functions will be described in abbreviated form.

About the Author

Ken Bluttman (Katonah, NY) has been working as a software developer for 25 years. He specializes in VB/VBA based applications, often with an emphasis on Microsoft Office. Ken has written articles on various computing topics including Office/VBA development, XML, SQL Server, and InfoPath, and several books

Table of Contents

Introduction

About This Book  

Foolish Assumptions  

How to Use This Book  

Icons Used in This Book  

Where to Go from Here  

Part 1: Getting Started with Formulas and Functions

Chapter 1: Tapping Into Formula and Function Fundamentals

  • Working with Excel Fundamentals  
  • Understanding workbooks and worksheets
  • Introducing the Formulas Tab
  • Working with rows, column, cells, ranges
Contact Us