Excel formulas : advanced / authors, John Hales & Krista Jensen.

Format:

Book

Author/Creator:

Hales, John (John R.), author.

Jensen, Krista Lynne, author.

Language:

English

Subjects (All):

Electronic spreadsheets.

Business--Data processing.

Business.

Physical Description:

1 online resource (6 pages) : illustrations

Edition:

1st ed.

Place of Publication:

[Place of publication not identified] : BarCharts, Inc., [2014]

Summary:

This comprehensive guide serves as an advanced reference for mastering Excel functions, building upon foundational knowledge of Excel formulas. It focuses on financial, logical, and text functions, providing practical applications such as balancing checkbooks, creating amortization charts, and utilizing nested IF, OR, and AND functions to analyze data. The guide also demonstrates techniques for managing Excel add-ins, modifying data sets, and streamlining processes like combining or separating text strings. Designed for users familiar with Excel basics, it offers step-by-step instructions and real-world examples to enhance data analysis and reporting skills. The guide is not version-dependent but uses Excel 2013 terminology for consistency. Generated by AI.

Contents:

Introduction

Financial Functions

To create running totals

Creating an Amortization Chart

Logical Functions

IF Function

OR and AND Functions

Combining Logical Functions

Text

Extracting First Names

Extracting Last Names

Extracting Middle Names

CONCATENATE Function

Lookup &amp

Reference

INDEX Function

MATCH Function

Combining INDEX and MATCH Functions

Math

Statistical

To use COUNT functions

T-Tests

Database Functions

Referencing Cells in Different Workbooks.

Notes:

Description based on print version record.

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

Description based on publisher supplied metadata and other sources.

ISBN:

1-4232-2332-2

OCLC:

990758645