Advanced Excel 365

Advanced Excel 365

Including ChatGPT Tips

Ritu Arora
Paperback
July 2024
9781501522512
More details
  • Publisher
    Mercury Learning and Information
  • Published
    26th July
  • ISBN 9781501522512
  • Language English
  • Pages 300 pp.
  • Size 7" x 9"
$54.99
Add to Cart
Lib E-Book

Library E-Books

We are signed up with aggregators who resell networkable e-book editions of our titles to academic libraries. These editions, priced at par with simultaneous hardcover editions of our titles, are not available direct from Stylus.

These aggregators offer a variety of plans to libraries, such as simultaneous access by multiple library patrons, and access to portions of titles at a fraction of list price under what is commonly referred to as a "patron-driven demand" model.

August 2024
9781501519079
More details
  • Publisher
    Mercury Learning and Information
  • Published
    12th August
  • ISBN 9781501519079
  • Language English
  • Pages 300 pp.
  • Size 7" x 9"
$165.00
E-Book

E-books are now distributed via VitalSource

VitalSource offer a more seamless way to access the ebook, and add some great new features including text-to-voice. You own your ebook for life, it is simply hosted on the vendor website, working much like Kindle and Nook. Click here to see more detailed information on this process.

August 2024
9781501519086
More details
  • Publisher
    Mercury Learning and Information
  • Published
    12th August
  • ISBN 9781501519086
  • Language English
  • Pages 300 pp.
  • Size 7" x 9"
$54.99
Add to Cart

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 is ideal for beginners and experienced users, including data analysts, financial professionals, and anyone seeking to enhance their Excel skills with VBA and AI integration.

FEATURES:

  • Master array formulas, e.g., VLOOKUP, INDEX MATCH, and other essential functions
  • Automate repetitive tasks and enhance productivity with powerful macros
  • Features step-by-step tutorials, clear instructions and practical examples for mastering Excel, VBA, and ChatGPT
  • Includes best practices for integrating AI and automation into your workflows

1: Overview of Excel 2021
2: Cell References and Range
3: Working with Formulas and Functions
4: Data Validation
5: Protection
6: Sorting a Database
7: Filtering a Database
8: Subtotals and Data Consolidation
9: Pivot Tables
10: Conditional Formatting
11: What-if Analysis
12: Working with Multiple Worksheets, Workbooks, and Applications
13: Working with Charts
14: Creating and Recording Macros in VBA
15: Assigning Buttons to Macros
16: Functions and Subroutines in VBA
17: Conditional Statements in VBA
18: Variables and Data Types in VBA
19: Looping Structures in VBA
20: Arrays and Collections in VBA
21: Debugging and Error Handling in VBA
22: User Forms and User Input in VBS
23: Advanced VBA Techniques and Best Practices
24: Building Custom Add-ins with VBA
25: ChatGPT with Excel
Index

Ritu Arora

Ritu Arora is a highly skilled and experienced Microsoft Certified Trainer, specializing in Power BI, Excel, PowerPoint, G Suite, and ChatGPT. She has successfully trained over 70,000 individuals at companies like Nestle, Citibank, Adidas, and Hero Honda.

Excel 365; VBA; ChatGPT; Data Analysis; Automation; Formulas; Functions; Macros; AI Integration; Data Processing