Description

Transform the way you work with Excel in “Excel with AI: The Complete Copilot Essentials for Business Success.” This comprehensive 15-hour course is your ultimate guide to mastering Microsoft Copilot and leveraging its AI capabilities to supercharge your business tasks. Designed for professionals seeking to enhance their productivity and data visualization skills, this course covers everything from the basics of Copilot integration to advanced prompt engineering techniques.
What You’ll Learn:

• Mastering Copilot and Microsoft Integration: Get hands-on experience with Copilot in Excel, learning how to seamlessly integrate AI-driven tools to automate and streamline your daily tasks.

• Data Visualization with Excel: Unlock the full potential of Excel’s data visualization features, using Copilot to generate insightful charts, graphs, and reports that drive better business decisions.

• Advanced Prompt Engineering: Learn the art of crafting precise prompts that guide Copilot to perform complex tasks, enabling you to create, analyze, and present data with AI-enhanced accuracy.

By the end of this course, you’ll have the skills and knowledge to harness the power of Microsoft Copilot and Excel, transforming your approach to data management and business intelligence. Whether you’re a beginner or an experienced professional, this course will equip you with the tools to excel in the AI-powered future of business.

• 1. Introduction
  • 00 About Mammoth Interactive

    1:11

• 2. Starting with Copilot: Your Essential Guide to AI-Powered Coding
  • 01.00 Course Overview | CoPilot Excel

    1:52

  • 01.01 Overview | CoPilot Excel

    2:03

  • 01.02 Microsoft's Approach to AI | CoPilot Excel

    3:42

  • 01.03 Microsoft's AI-Enhanced Productivity Tools | CoPilot Excel

    3:27

  • 01.04 Copilot for Microsoft 365 | CoPilot Excel

    5:20

  • 01.05 Data Considerations | CoPilot Excel

    2:14

  • 01.06 Copilot Interaction for Microsoft 365 | CoPilot Excel

    4:19

  • 01.07 Recap | CoPilot Excel

    1:37

• 3. Excel with Copilot: Supercharge Your Spreadsheets with AI
  • 02.01 Overview | CoPilot Excel

    1:49

  • 02.02 Accessing Copilot in Excel | CoPilot Excel

    3:07

  • 02.03 Insight Identification | CoPilot Excel

    15:50

  • 02.04 Managing Data with Copilot | CoPilot Excel

    9:37

  • 02.05 Generating Formulas | CoPilot Excel

    11:06

• 4. Microsoft Copilot: A Comprehensive Guide to AI-Powered Productivity
  • 01.00 Course Overview | Microsoft Copilot

    1:48

  • 01.01 Overview | Microsoft Copilot

    1:01

  • 01.02 Understanding Copilot | Microsoft Copilot

    3:52

  • 01.03 Accessing Microsoft Copilot | Microsoft Copilot

    2:39

  • 01.04 What to Keep in mind | Microsoft Copilot

    2:53

  • 01.05 Recap | Microsoft Copilot

    0:51

• 5. Diving in to Copilot
  • 02.01 Overview | Microsoft Copilot

    1:08

  • 02.02 The Interface | Microsoft Copilot

    19:18

  • 02.03 Understanding Copilot Prompts | Microsoft Copilot

    1:28

  • 02.04 Interaction with Copilot | Microsoft Copilot

    5:39

  • 02.05 Recap | Microsoft Copilot

    1:11

• 6. Mastering Copilot Prompt Engineering: Crafting Precision AI Commands
  • 03.01 Overview | Microsoft Copilot

    1:23

  • 03.02 Copilot- Answers & Create | Microsoft Copilot

    36:56

  • 03.03 Image Prompting | Microsoft Copilot

    13:24

  • 03.04 Prompting Advance Tasks | Microsoft Copilot

    21:10

  • 03.05 Recap | Microsoft Copilot

    1:42

• 7. Handle missing data with Python and ChatGPT
  • 01 Algorithms To Handle Missing Data | Excel Data Manip

    5:14

  • 02 Generate Excel Data With Missing Data In Python And Chatgpt | Excel Data Manip

    3:22

  • 03 Fill In Missing Excel Data With Python Imputation And Chatgpt | Excel Data Manip

    3:51

  • 04 Delete Missing Excel Data With Python And Chatgpt | Excel Data Manip

    5:04

  • 05 Fill In Missing Data With Knn Imputation | Excel Data Manip

    5:24

• 8. Categorical data manipulation with Python and ChatGPT
  • 01 What Is Data Encoding | Excel Data Manip

    5:37

  • 02 Perform Excel Data Encoding With Python And Chatgpt | Excel Data Manip

    7:19

  • 03 Choose Data Encoding Technique | Excel Data Manip

    3:01

• 9. Statistics for data science with Python and ChatGPT
  • 01 What Is Statistics For Data Science | Excel Data Manip

    3:31

  • 02 Levels Of Data Measurement | Excel Data Manip

    3:58

  • 03 Generate Different Types Of Data With Chatgpt | Excel Data Manip

    10:02

• 10. How to measure data
  • 01 Measures Of Central Tendency In Data | Excel Data Manip

    5:00

  • 02 Measures Of Variability In Data | Excel Data Manip

    4:09

  • 03 What Is Skewness In Data Science | Excel Data Manip

    3:39

  • 04 Generate Skewed Datasets With Chatgpt | Excel Data Manip

    7:45

  • 05 What Are Covariance And Correlation Data Measurements | Excel Data Manip

    2:38

  • 06 Measure Covariance And Correlation Of Dataset With Chatgpt | Excel Data Manip

    6:50

• 11. Measuring Sales Performance with KPIs and Excel
  • 01 01 Course Requirement| Sales Analytics Excel

    1:34

• 12. Measuring Performance with KPIs in Excel and ChatGPT
  • 02.01.Project Preview | Sales Analytics Excel

    0:58

  • 02.02. Sales Key Perfomance Indicators (Kpis) | Sales Analytics Excel

    10:16

  • 02.03.Measuring Salesperson Performance Using Kpis | Sales Analytics Excel

    5:49

  • 02.04.Marketing And Financial Kpis | Sales Analytics Excel

    6:50

  • 02.05.Customer-Related Kpis | Sales Analytics Excel

    10:20

• 13. KPI Case Study in Excel with ChatGPT
  • 03.01.Project Preview | Sales Analytics Excel

    0:38

  • 03.02.Case Study Involving Kpis | Sales Analytics Excel

    3:09

  • 03.03. Joining Data Tables In Excel | Sales Analytics Excel

    7:29

  • 03.04.Cleaning Data Using Filters In Excel | Sales Analytics Excel

    5:20

  • 03.05.Determining Lead Conversion Time | Sales Analytics Excel

    7:18

• 14. Analyzing Sales Data
  • 04.01. Project Preview | Sales Analytics Excel

    1:20

  • 04.02. Aggregating Data By Regions, Categories, And Time Dimension | Sales Analytics Excel

    6:25

  • 04.03.Evaluating Salesperson Performance | Sales Analytics Excel

    13:59

• 15. Visualizing Sales Data
  • 05.01. Project Preview | Sales Analytics Excel

    1:18

  • 05.02.Creating Charts To Visualize Sales Data | Sales Analytics Excel

    8:08

  • 05.04.Charting Category-Wise Average Order Value | Sales Analytics Excel

    5:48

  • 05.05.Analyzing Lead Generation Trends | Sales Analytics Excel

    7:54

  • 05.06.Analyzing Salesperson Performance | Sales Analytics Excel

    6:26

  • 05.07.Building A Sales Dashboard | Sales Analytics Excel

    6:22

  • 05.08. Additional Charts For Sales Modeling | Sales Analytics Excel

    8:33

• 16. Sales Modeling and Prospecting
  • 06.01.Project Preview | Sales Analytics Excel

    1:33

  • 06.02.Building The Whale Model | Sales Analytics Excel

    6:47

  • 06.03.Lead Segmentation Using Decision Trees | Sales Analytics Excel

    6:53

  • 06.04.Excel Preparation For Analysis | Sales Analytics Excel

    6:52

  • 06.05.Case Study On Lead Segmentation | Sales Analytics Excel

    5:06

  • 06.06.Building A Model In Excel | Sales Analytics Excel

    9:38

  • 06.07.Interpreting Results From Tree Nodes | Sales Analytics Excel

    5:25

  • 06.08.Interpreting Results Based On Classification Criteria | Sales Analytics Excel

    5:23

  • 06.09.Drawing Inferences From Model Results | Sales Analytics Excel

    5:30

  • 06.10.Making Predictions Using The Trained Model | Sales Analytics Excel

    3:19

  • 06.11.Advanced Customization Options For Models | Sales Analytics Excel

    4:37

• 17. Maximizing Customer Value
  • 07.01.Project Preview | Sales Analytics Excel

    1:05

  • 07.02.Market Basket Analysis For Cross-Selling Opportunities | Sales Analytics Excel

    6:27

  • 07.03.Predicting Values Using The Trained Model | Sales Analytics Excel

    11:02

• 18. Sales Forecasting
  • 08.01.Project Preview | Sales Analytics Excel

    3:11

  • 08.02.Modeling Trends And Seasonality | Sales Analytics Excel

    10:03

  • 08.03.Additive And Multiplicative Time Series Models | Sales Analytics Excel

    9:30

  • 08.04.Linear Regression Model For Sales Forecasting | Sales Analytics Excel

    7:44

  • 08.05.Preprocessing Data For Regression | Sales Analytics Excel

    12:14

  • 08.06.Building A Linear Regression Model | Sales Analytics Excel

    8:28

  • 08.07.Predicting Values Using The Trained Model | Sales Analytics Excel

    8:26

  • 08.08.Using Xlstat For Forecasting | Sales Analytics Excel

    7:57

• 19. Customer Lifetime Increase
  • 09.01.Project Preview | Sales Analytics Excel

    1:52

  • 09.02.Building A Logistic Regression Model For Churn Prediction | Sales Analytics Excel

    12:17

  • 09.03.Predicting Churn Probability Using The Trained Model | Sales Analytics Excel

    11:05

  • 09.04.Evaluating Model Accuracy Using A Confusion Matrix | Sales Analytics Excel

    12:28

• 20. Excel Mastery & Business Strategies with ChatGPT: Advanced Techniques for Modern Professionals
  • 01 01 Course Requirement | Adv GPT Excel

    2:31

• 21. Automate Excel with ChatGPT
  • 02 01 Project Preview | Adv GPT Excel

    1:36

  • 02.02A Set Up Excel Spreadsheet With Gpt Add-In | Adv GPT Excel

    8:37

  • 02.02B Excel With Chatgpt | Adv GPT Excel

    4:51

  • 02.03 Write Excel Formulas With Chatgpt | Adv GPT Excel

    9:39

  • 02.04 Use Chatgpt Formulas In Excel | Adv GPT Excel

    16:19

• 22. Build Investment Dashboard with ChatGPT and Excel
  • 03 01 Project Preview | Adv GPT Excel

    1:27

  • 03.02A Set Up Dashboard | Adv GPT Excel

    7:51

  • 03.02B Set Up Data | Adv GPT Excel

    7:11

  • 03.03A Use Chatgpt And Excel To Build An Investment Dashboard | Adv GPT Excel

    11:37

  • 03.03B Generate More Formulas For Excel | Adv GPT Excel

    11:35

  • 03.03C Placing Data On Dashboard | Adv GPT Excel

    10:31

• 23. Sales Automation with ChatGPT and Excel
  • 04 01 Project Preview | Adv GPT Excel

    2:10

  • 04.02A Project Setup - Product Worksheet | Adv GPT Excel

    12:00

  • 04.02B Setup Sales And Summary Sheet | Adv GPT Excel

    9:23

  • 04.03A Build Advanced Chatgpt Excel Project | Adv GPT Excel

    13:01

  • 04.03B Automating Product Name And Price Data | Adv GPT Excel

    13:11

  • 04.03C Completing Sales Sheet Automation With Chatgpt | Adv GPT Excel

    9:32

  • 04.03D Building Sales Overview Dashboard | Adv GPT Excel

    8:37

  • 04.03E Refining The Pos System | Adv GPT Excel

    11:15

• 24. Automate Business Writing with ChatGPT
  • 05 01 Project Preview | Adv GPT Excel

    2:19

  • 05.02 Meeting Agendas And Minutes | Adv GPT Excel

    10:26

  • 05.03 Write A Business Proposal | Adv GPT Excel

    11:18

  • 05.04 Build A Business Report | Adv GPT Excel

    11:12

  • 05.05 Build A Business Plan | Adv GPT Excel

    10:35

  • 05.06 Build A Business Performance Appraisal | Adv GPT Excel

    10:39

  • 05.07 Build A Business Presentation | Adv GPT Excel

    12:40

  • 05.08 Summarize Business Documents | Adv GPT Excel

    11:45

  • 05.09 Write Job Descriptions | Adv GPT Excel

    8:33

  • 05.10 Build White Papers | Adv GPT Excel

    9:38

  • 05.11 Build Employee Handbooks | Adv GPT Excel

    8:44

  • 05.12 Build Business Manuals | Adv GPT Excel

    9:24

• 25. Automate Social Media Business with ChatGPT
  • 06 01 Project Preview | Adv GPT Excel

    1:17

  • 06.02 Set Up Project | Adv GPT Excel

    8:06

  • 06.03A Advanced Chatgpt 4 Business Project | Adv GPT Excel

    10:11

  • 06.03C Finishing Touches | Adv GPT Excel

    12:27