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

With Excel 2021 / Microsoft 365

Microsoft Excel Functions and Formulas

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 Dynamic Array Formulas

Chapter 12: Special Solutions with Formulas

Chapter 13: User-Defined Functions

Chapter 14: Examples

Chapter 15: Other Features

Chapter 16: Data Analytics Using Excel

Chapter 17: Shortcut Keys

Appendix: Excel Interface Guide

Index

CompanionFiles.zip

Moriarty, Brian

Held, Bernd

Richardson, Theodor

In this completely updated edition covering Excel 2021, Microsoft 365, and previous versions, Microsoft Excel Functions & Formulas Sixth Edition demonstrates the secrets of Excel through the use of practical and useful examples in a quick reference format. New chapters have been added on data analytics and shortcut keys. The book’s extensive examples and additional video tutorials make it an excellent resource for all Excel users who want to understand, create, and apply formulas. Experienced users will also find it to be an excellent reference for the program’s advanced formulas and functions.

In this completely updated edition covering Excel 2021, Microsoft 365, and previous versions, Microsoft Excel Functions & Formulas Sixth Edition...

Format

Microsoft Excel Functions and Formulas

With Excel 2021 / Microsoft 365

Brian Moriarty

Bernd Held

Theodor Richardson

People Also Read