Khan, Arshad

Business Intelligence and Data Analysis in the Age of AI

Campesato, Oswald

Beginning Python 3 with Claude 3

A Prompt-based Exploration of LLMs

Large Language Models for Developers

Zherlitsyn, Dmytro

Financial Data Analysis Using Python

Fortino, Andres

Case Studies in Excel, R, and ChatGPT

Data Analysis for Business Decisions

Goralski, Walter

Understanding AI, IoT, 6G and The Infrastructure Revolution

Beginning Python 3 with Grok 2

Herman, Erik

Using Analytics and Case Studies

Data Science for Decision Makers

Erik, Herman L.

Theory, Applications and Ethics

AI Revealed

CAMPESATO, OSWALD

CSS3 and SVG with Meta AI

Microsoft Excel Functions and Formulas with Excel 2019/Office 365

Frontmatter

CONTENTS

Acknowledgments

Introduction

Chapter 1 : Formulas in Excel

Chapter 2 : Logical Functions

Chapter 3 : Text Functions

Chapter 4 : Date and Time Functions

Chapter 5 : Basic Statistical Functions

Chapter 6 : Mathematical Functions

Chapter 7 : Basic Financial Functions

Chapter 8 : Database Functions

Chapter 9 : Lookup and Reference Functions

Chapter 10 : Conditional Formatting with Formulas

Chapter 11 : Working with Array Formulas

Chapter 12 : Special Solutions with Formulas

Chapter 13 : User-Defined Functions

Chapter 14 : Examples

Chapter 15 : Other Features

Appendix : Excel Interface Guide

Index

CompanionFiles.zip

Held, Bernd

Moriarty, Brian

Richardson, Theodor

In this completely updated edition covering Excel 2019, previous versions, and Office 365, Microsoft Excel Functions & Formulas 5/E demonstrates the secrets of Excel through the use of practical and useful examples in a quick reference format. Easy to use and equipped with a variety of functions, Microsoft Excel is the tool of choice when it comes to crunching numbers, building charts, and analyzing tables. The book’s extensive examples and added video tutorials make it an excellent resource for all Excel users who want to understand, create, and apply formulas.

In this completely updated edition covering Excel 2019, previous versions, and Office 365, Microsoft Excel Functions & Formulas 5/E demonstrates the...

Microsoft Excel Functions and Formulas with Excel...

Format

Microsoft Excel Functions and Formulas with Excel 2019/Office 365

Bernd Held

Brian Moriarty

Theodor Richardson

People Also Read