|
Master the Art of Microsoft Excel with ChatGPT and Artificial Intelligence
(2:00)
|
Preview
|
|
|
Join The Community
|
|
|
|
ChatGPT Prompts used in MS Excel with AI program
(5 pages)
|
|
|
SECTION 1: Welcome to MS Excel!
|
|
|
|
Excel Essentials: Creating New Workbooks
3:00
|
Preview
|
|
|
Understanding Cells: Addressing and Explanation
3:00
|
|
|
|
Navigating Excel: Formula Bar, Name Box, and Range
5:00
|
|
|
|
Data Management Techniques: Enter, Copy, Move, Replace, and Erase
9:00
|
|
|
|
Exploring Excel's Ribbon: Navigation and Functionality
4:00
|
|
|
|
Efficient Data Entry and Formatting: Tips and Techniques
13:00
|
|
|
|
Data Analysis Basics: Sum, Max, Min, Count, and Average
|
|
|
|
Window Management: View, Arrange, Freeze, and Split
7:00
|
|
|
|
Advanced Pasting Techniques: Paste Special
9:00
|
|
|
|
Counting and Summing Techniques: COUNT, COUNTIF, SUMIF Functions
7:00
|
|
|
|
Cell References Explained: Relative, Absolute, and Mixed
9:00
|
|
|
|
Data Filtering Techniques
8:00
|
|
|
|
Mastering VLOOKUP
6:00
|
|
|
|
Advanced Lookup Techniques: INDEX, MATCH, and VLOOKUP
6:00
|
|
|
|
Understanding Approximate Match in VLOOKUP
5:00
|
|
|
|
Duplicate Data Management: How to Remove Duplicates
4:00
|
|
|
|
Pivot table mastery: know everything about pivot table
11:00
|
|
|
SECTION 2: Start Using ChatGPT for Excel Like a Pro
|
|
|
|
Easy Steps to Get ChatGPT: Start Now
3:00
|
|
|
|
What's the Difference? ChatGPT 3.5 vs 4 Explained
2:00
|
|
|
|
Quick Start: Using ChatGPT the Easy Way
6:00
|
|
|
SECTION 3: Easy Excel Tricks with ChatGPT
|
|
|
|
Adding and Deciding: Simple Ways to Use Sum and If with ChatGPT
8:00
|
|
|
|
Sorting Dates and Text: Learn LEFT, RIGHT, and More with ChatGPT
8:00
|
|
|
|
Finding Stuff Easily: How to Use VLOOKUP with ChatGPT
7:00
|
|
|
|
Counting and Adding Made Easy: Get to Know SUMIF and COUNTIF with ChatGPT
13:00
|
|
|
|
Playing Around: Practise Excel with ChatGPT
6:00
|
|
|
|
Getting a Bit Tricky: Start Tackling Harder Excel Tips with ChatGPT - Part 1
8:00
|
|
|
|
Even Trickier: Keep Going with Tough Excel Tricks with ChatGPT - Part 2
6:00
|
|
|
SECTION 4: Advancing with ChatGPT in Excel
|
|
|
|
ChatGPT with Excel Intro
5:00
|
|
|
|
Mastering Prompts in ChatGPT with Excel
7:00
|
|
|
|
Simplifying ChatGPT in Excel Without Prompt Engineering
7:00
|
|
|
|
Using ChatGPT Prompts for Excel: Formulas, Functions, Conditional Formatting
9:00
|
|
|
|
Powering Through Excel with ChatGPT Power Query
11:00
|
|
|
SECTION 5: Unlock Excel's AI Secrets
|
|
|
|
Dive into the World of Excel AI Tools
|
|
|
|
Transform Data Instantly with Flash Fill Magic
6:00
|
|
|
|
Let Excel Do the Math: Formulas Made Effortless
5:00
|
|
|
|
Power Query Wizardry: Columns Crafted from Your Examples
9:00
|
|
|
|
Discover Insights Faster: Analyze Data Like a Pro
15:00
|
|
|
SECTION 6: Excel Formulas Made Easy with ChatGPT
|
|
|
|
Simplify Your Work: Asking ChatGPT for Excel Formulas
4:00
|
|
|
|
Enhance Your Tables: Integrating ChatGPT with Excel
3:00
|
|
|
|
Level Up: Advanced Techniques, Error Fixes, and Adding Comments with ChatGPT
5:00
|
|
|
SECTION 7: Mastering Advanced Formulas with ChatGPT in Excel
|
|
|
|
Crafting Lookup Formulas Seamlessly with ChatGPT
8:00
|
|
|
|
Turning Images into Formulas: ChatGPT's Excel Magic
7:00
|
|
|
|
Collaborating with ChatGPT for Advanced Excel Formulas
5:00
|
|
|
|
Explaining Complex Formulas using ChatGPT
4:00
|
|
|
|
Understanding Excel Formulas Through File Uploads with ChatGPT
3:00
|
|
|
|
Debugging and Perfecting Excel Formulas with ChatGPT
9:00
|
|
|
|
Excel Formula Debugging with Your ChatGPT Assistant
9:00
|
|
|
|
Enhancing Your Excel Formulas with ChatGPT Insights
7:00
|
|
|
SECTION 8: Streamlining Data Cleaning and Transformation with ChatGPT
|
|
|
|
Revolutionising Data Cleaning and Transformation with ChatGPT
2:00
|
|
|
|
Simplify PDF Data Transformation: ChatGPT's Guide to Data Import
8:00
|
|
|
|
Transform Your Data: Excel File Uploads Made Easy with ChatGPT
5:00
|
|
|
|
PDF to CSV: Let ChatGPT Take Care of the Cleaning and Conversion
4:00
|
|
|
|
ChatGPT's Guide to Tackling Complex Excel File Transformations
5:00
|
|
|
SECTION 9: Enhancing Data Analysis with ChatGPT
|
|
|
|
Kickstarting Your Journey in Data Analysis with ChatGPT
|
|
|
|
Streamlining List Comparisons with ChatGPT's Assistance
3:00
|
|
|
|
Unlocking Data Insights Seamlessly with ChatGPT
6:00
|
|
|
|
Beyond Excel: Creating Advanced Visuals with ChatGPT's Insight
5:00
|
|
|
|
Elevating Customer Feedback: Sentiment Analysis with ChatGPT
6:00
|
|
|
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
7:00
|
|
|
|
Making Excel VBA Events Work Smarter with ChatGPT
|
|
|
|
Levelling Up: Crafting Complex VBA with ChatGPT
4:00
|
|
|
|
Simplifying VBA Code: ChatGPT Makes Understanding Easy
4:00
|
|
|
|
Enhancing Macros: Adding Comments with ChatGPT's Insight
3:00
|
|
|
|
Perfecting Your Macro: Let ChatGPT Refine Your Excel Code
5:00
|
|
|
|
Debug and Fix Excel VBA Code with ChatGPT
5:00
|
|