Excel formulas / John Hales and Krista Jensen.

Format:

Book

Author/Creator:

Hales, John, author.

Jensen, Krista, author.

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Physical Description:

1 online resource (6 pages)

Edition:

1st ed.

Place of Publication:

USA : BarCharts Publishing, Inc., [2013]

Summary:

This book is a comprehensive guide to using Microsoft Excel's built-in functions and formulas. It covers basic mathematical operations, the order of operations, and advanced features such as the Formulas tab, Insert Function, Function Library, and Defined Names. The guide aims to assist users in effectively utilizing Excel for various tasks, including mathematical calculations, data management, and formula auditing. It is intended for readers seeking to improve their Excel skills, whether they are beginners or more experienced users. The content is structured to provide clear explanations and examples, enabling users to perform calculations and manage data efficiently. Generated by AI.

Contents:

Excel Formulas

Introduction

Basic Mathematical Operations

Order of Operations

The Formulas Tab

Insert Function

To insert a function:

Function Library

Defined Names

Formula Auditing

Calculation

Solutions

Referencing Cells

Standard Cell Referencing

Defining &amp

Referencing Named Cells

To name a cell:

To name a range of cells:

To use named cells in a formula (method 1):

To use named cells in a formula (method 2):

Using Relative Addressing

Standard Column &amp

Row Addresses

To copy or move a data selection:

Named Cells

Using Absolute References

To use cell addresses:

To use named cells:

Referencing Cells in Different Worksheets

To reference a cell on a different worksheet using a cell address:

To reference a named cell on a different worksheet:

Selecting &amp

Using Functions

To select &amp

use a function from a function category:

To use a function by typing its name into a cell:

Function Categories

Financial

Logical

Text

Date &amp

Time

To format dates in Excel:

To find the serial number for a date:

To view a serial number as date:

Adding Dates Incrementally

To change a date by increments:

Computing Elapsed Time

To compute elapsed time:

To perform a mathematical calculation on a time:

Lookup &amp

Reference

Math &amp

Trig

Statistical

Standard Deviation

Information

Compatibility

To check function compatibility:

Error Solving

To perform error checking:

To evaluate error warnings:

To evaluate a formula:.

Notes:

Description based on publisher supplied metadata and other sources.

Part of the metadata in this record was created by AI, based on the text of the resource.

ISBN:

9781423221951

1423221958

OCLC:

1241449243