arrow_back
Master the Art of Microsoft Excel with ChatGPT and Artificial Intelligence
Join The Community
ChatGPT Prompts used in MS Excel with AI program
Day 1: Getting started with MS Excel with Anshad (Recorded Video)
Rename multiple files in a folder
Day 2: Getting Started with MS Excel with Anshad (Recorded Video)
1. IntroNamedRanges & Tables
2. Text and date function
Day 3: Mastering Data Summarization & Pivot Tables in Excel (Recorded Video)
Day 4: Data Validation, Forms, and Macro-Based Form Creation in Excel (Recorded Video)
Day 7: Excel logic and conditional functions (Recorded Video)
Day 6: Excel Lookup Functions (recorded video)
Day 9: Introduction to Excel power Query Part 1 (Recorded Video)
Day 10: Introduction to Excel power Query Part 2 (Recorded Video)
Day 11: New AI spreadsheet : Brickapp.com
Day 12: Data Analysis with ChatGPT
Day 13: Array fromula, FILTER,SORT, UNIQUE functions
Day 14: Excel with AI Master Class: Working with Multiple Sheet and Workbooks
SECTION 1: Welcome to MS Excel!
Excel Essentials: Creating New Workbooks
Understanding Cells: Addressing and Explanation
Navigating Excel: Formula Bar, Name Box, and Range
Data Management Techniques: Enter, Copy, Move, Replace, and Erase
Exploring Excel's Ribbon: Navigation and Functionality
Efficient Data Entry and Formatting: Tips and Techniques
Day 8- Excel : Conditional Formatting (Recorded Video)
Data Analysis Basics: Sum, Max, Min, Count, and Average
Window Management: View, Arrange, Freeze, and Split
Advanced Pasting Techniques: Paste Special
Counting and Summing Techniques: COUNT, COUNTIF, SUMIF Functions
Cell References Explained: Relative, Absolute, and Mixed
Data Filtering Techniques
Mastering VLOOKUP
Advanced Lookup Techniques: INDEX, MATCH, and VLOOKUP
Understanding Approximate Match in VLOOKUP
Duplicate Data Management: How to Remove Duplicates
Pivot table mastery: know everything about pivot table
Day 15 (Recorded Video)
Day 16 (Recorded Video)
Day 17 (Recorded Video)
Day 18 (Recorded Video)
Day 19 (Recorded Video)
SECTION 2: Start Using ChatGPT for Excel Like a Pro
Easy Steps to Get ChatGPT: Start Now
What's the Difference? ChatGPT 3.5 vs 4 Explained
Quick Start: Using ChatGPT the Easy Way
SECTION 3: Easy Excel Tricks with ChatGPT
Adding and Deciding: Simple Ways to Use Sum and If with ChatGPT
Sorting Dates and Text: Learn LEFT, RIGHT, and More with ChatGPT
Finding Stuff Easily: How to Use VLOOKUP with ChatGPT
Counting and Adding Made Easy: Get to Know SUMIF and COUNTIF with ChatGPT
Playing Around: Practise Excel with ChatGPT
Getting a Bit Tricky: Start Tackling Harder Excel Tips with ChatGPT - Part 1
Even Trickier: Keep Going with Tough Excel Tricks with ChatGPT - Part 2
SECTION 4: Advancing with ChatGPT in Excel
ChatGPT with Excel Intro
Mastering Prompts in ChatGPT with Excel
Simplifying ChatGPT in Excel Without Prompt Engineering
Using ChatGPT Prompts for Excel: Formulas, Functions, Conditional Formatting
Powering Through Excel with ChatGPT Power Query
SECTION 5: Unlock Excel's AI Secrets
Dive into the World of Excel AI Tools
Transform Data Instantly with Flash Fill Magic
Let Excel Do the Math: Formulas Made Effortless
Power Query Wizardry: Columns Crafted from Your Examples
Discover Insights Faster: Analyze Data Like a Pro
SECTION 6: Excel Formulas Made Easy with ChatGPT
Simplify Your Work: Asking ChatGPT for Excel Formulas
Enhance Your Tables: Integrating ChatGPT with Excel
Level Up: Advanced Techniques, Error Fixes, and Adding Comments with ChatGPT
SECTION 7: Mastering Advanced Formulas with ChatGPT in Excel
Crafting Lookup Formulas Seamlessly with ChatGPT
Turning Images into Formulas: ChatGPT's Excel Magic
Collaborating with ChatGPT for Advanced Excel Formulas
Explaining Complex Formulas using ChatGPT
Understanding Excel Formulas Through File Uploads with ChatGPT
Debugging and Perfecting Excel Formulas with ChatGPT
Excel Formula Debugging with Your ChatGPT Assistant
Enhancing Your Excel Formulas with ChatGPT Insights
SECTION 8: Streamlining Data Cleaning and Transformation with ChatGPT
Revolutionising Data Cleaning and Transformation with ChatGPT
Simplify PDF Data Transformation: ChatGPT's Guide to Data Import
Transform Your Data: Excel File Uploads Made Easy with ChatGPT
PDF to CSV: Let ChatGPT Take Care of the Cleaning and Conversion
ChatGPT's Guide to Tackling Complex Excel File Transformations
SECTION 9: Enhancing Data Analysis with ChatGPT
Kickstarting Your Journey in Data Analysis with ChatGPT
Streamlining List Comparisons with ChatGPT's Assistance
Unlocking Data Insights Seamlessly with ChatGPT
Beyond Excel: Creating Advanced Visuals with ChatGPT's Insight
Elevating Customer Feedback: Sentiment Analysis with ChatGPT
SECTION 10: Excel Automation Unleashed with Macros and ChatGPT
Uniting ChatGPT and Excel Macros: The Ultimate Intro
Building Your First Excel Macros with ChatGPT's Help
Making Excel VBA Events Work Smarter with ChatGPT
Levelling Up: Crafting Complex VBA with ChatGPT
Simplifying VBA Code: ChatGPT Makes Understanding Easy
Enhancing Macros: Adding Comments with ChatGPT's Insight
Perfecting Your Macro: Let ChatGPT Refine Your Excel Code
Debug and Fix Excel VBA Code with ChatGPT
Day 5: Excel Macros & Automation Unlocking Efficiency with ChatGPT (Recorded Video)
6.1 macro data cleaning
6.2 Macro - Weekly time sheet
6.3 Macro - form creation
Day 17: Basics Of Power Bi