MyDigiBundles · AI Guides

Practical AI Guides for Smarter Work

Clear, step-by-step tutorials on using AI, Excel and workflow automation in the work you already do. No hype, just methods you can test on your own files and tasks.

Read the Featured Guide Explore the Excel AI Vault

Illustrative example

  1. Describe the task

    “Add up 2025 sales for the West region.”

  2. Let AI draft the formula

    =SUMIFS(Sales[Amount],Sales[Region],"West",Sales[Year],2025)

  3. Check it against your data

    Test on a few rows you can verify by hand before you rely on it.

About the guides

Practical AI, built around real work

AI is most useful when it is pointed at a specific job: a formula that will not behave, a report that takes too long, a routine task that repeats every week. These guides start from the task, show the method, and explain how to check the result.

MyDigiBundles AI Guides are practical tutorials for working professionals, including analysts, finance and IT teams, and anyone learning to use AI at work. They are written for people who use Excel and everyday tools, not for developers.

  • Practical AIPrompts and methods you can try on your own tasks, with notes on where AI needs human checking.
  • Excel productivityFormulas, data cleaning and analysis explained step by step.
  • Workflow automationTurning repeated reporting and admin steps into simple, repeatable workflows.

Featured guide

Start with Excel formulas and AI

Practical AI Guides · 9–11 min read

How to Use AI for Excel Formulas: 7 Practical Examples

Learn how to generate, understand, and troubleshoot Excel formulas with AI through seven practical examples and reusable prompts.

By Vishwanath Srinivasan | MyDigiBundles

Read the Guide

Inside the guide

  1. Conditional totals with SUMIF
  2. Multiple conditions with SUMIFS
  3. Lookups with XLOOKUP, and an older-version alternative
  4. Handling errors with IFERROR, and its limits
  5. Working days with NETWORKDAYS
  6. Categorising values with nested IF
  7. Troubleshooting a formula that is not working

Guide categories

Choose your learning path

Three focus areas. Start with the featured Excel guide above; more tutorials will be added over time.

  • Start here

    Excel & Productivity

    Use AI to write, explain and check Excel formulas, tidy messy data and prepare clearer reports.

    • Formulas and functions
    • Data cleaning and analysis
    • Reporting and summaries
    Read the Excel formulas guide
  • More tutorials coming

    AI Workflows

    Build repeatable ways of working with AI, from better prompts to routine reporting and admin steps.

    • Prompting that gets useful answers
    • Reusable templates and routines
    • Reviewing and fixing AI output
    See the AI Productivity System
  • More tutorials coming

    Practical AI Tools

    Choose AI tools for everyday work, try them on real tasks, and check the results before you rely on them.

    • Choosing and comparing tools
    • Trying tools on real tasks
    • Checking results with care
    Browse the AI Tools Hub

Featured resource

Excel AI Vault

The Excel AI Vault is our Excel-focused AI prompt toolkit. Learn the method in the featured guide, then explore the Vault for more Excel-focused AI prompts.

  • Excel-focused AI prompts
  • Pairs with the practical formula guide above
  • Works alongside the Excel Formula Generator
Explore the Excel AI Vault Excel Formula Generator

Make Technology Meaningful

Technology matters when it helps real people do real work with less effort. These guides turn AI, Excel and automation into skills you can apply to your own work.

Explore the AI Tools Hub