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

Including ChatGPT Tips

Advanced Excel 365

Frontmatter

Contents

Preface

Acknowledgments

About the Author

Chapter 1: Overview of Excel 2021

Chapter 2: Cell References and Range

Chapter 3: Working with Formulas and Functions

Chapter 4: Data Validation

Chapter 5: Protection

Chapter 6: Sorting a Database

Chapter 7: Filtering a Database

Chapter 8: Subtotals and Data Consolidation

Chapter 9: Pivot Tables

Chapter 10: Conditional Formatting

Chapter 11: What-if Analysis

Chapter 12: Working with Multiple Worksheets, Workbooks, and Applications

Chapter 13: Working with Charts

Chapter 14: Creating and Recording Macros in VBA

Chapter 15: Assigning Buttons to Macros

Chapter 16: Functions and Subroutines in VBA

Chapter 17: Conditional Statements in VBA

Chapter 18: Variables and Data Types in VBA

Chapter 19: Looping Structures in VBA

Chapter 20: Arrays and Collections in VBA

Chapter 21: Debugging and Error Handling in VBA

Chapter 22: User Forms and User Input in VBS

Chapter 23: Advanced VBA Techniques and Best Practices

Chapter 24: Building Custom Add-ins with VBA

Chapter 25: ChatGPT with Excel

Index

CompanionFiles.zip

Arora, Ritu

This book provides practical knowledge, hands-on examples, and step-by-step instructions to master the capabilities of Excel, harness VBA for customization, and integrate ChatGPT for intelligent conversations. The book provides a thorough overview of Excel including navigating the interface, mastering array formulas and essential functions, completing repetitive tasks, exploring macros, and using ChatGPT for content generation and advanced data analysis.

This book provides practical knowledge, hands-on examples, and step-by-step instructions to master the capabilities of Excel, harness VBA for customization,...

Format

Advanced Excel 365

Including ChatGPT Tips

Ritu Arora

Polecane publikacje