< Excel with AI: The Complete Copilot Essentials for Business Success

130 casts | 15:02:55 for the total course

created by Mammoth Interactive INC

  • 1. Introduction
  • 2. Starting with Copilot: Your Essential Guide to AI-Powered Coding

    • 01.00 Course Overview | CoPilot Excel

    • 01.01 Overview | CoPilot Excel

    • 01.02 Microsoft's Approach to AI | CoPilot Excel

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

    • 01.04 Copilot for Microsoft 365 | CoPilot Excel

    • 01.05 Data Considerations | CoPilot Excel

    • 01.06 Copilot Interaction for Microsoft 365 | CoPilot Excel

    • 01.07 Recap | CoPilot Excel

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

    • 02.02 Accessing Copilot in Excel | CoPilot Excel

    • 02.03 Insight Identification | CoPilot Excel

    • 02.04 Managing Data with Copilot | CoPilot Excel

    • 02.05 Generating Formulas | CoPilot Excel

  • 4. Microsoft Copilot: A Comprehensive Guide to AI-Powered Productivity

    • 01.00 Course Overview | Microsoft Copilot

    • 01.01 Overview | Microsoft Copilot

    • 01.02 Understanding Copilot | Microsoft Copilot

    • 01.03 Accessing Microsoft Copilot | Microsoft Copilot

    • 01.04 What to Keep in mind | Microsoft Copilot

    • 01.05 Recap | Microsoft Copilot

  • 5. Diving in to Copilot

    • 02.01 Overview | Microsoft Copilot

    • 02.02 The Interface | Microsoft Copilot

    • 02.03 Understanding Copilot Prompts | Microsoft Copilot

    • 02.04 Interaction with Copilot | Microsoft Copilot

    • 02.05 Recap | Microsoft Copilot

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

    • 03.02 Copilot- Answers & Create | Microsoft Copilot

    • 03.03 Image Prompting | Microsoft Copilot

    • 03.04 Prompting Advance Tasks | Microsoft Copilot

    • 03.05 Recap | Microsoft Copilot

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

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

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

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

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

  • 8. Categorical data manipulation with Python and ChatGPT

    • 01 What Is Data Encoding | Excel Data Manip

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

    • 03 Choose Data Encoding Technique | Excel Data Manip

  • 9. Statistics for data science with Python and ChatGPT

    • 01 What Is Statistics For Data Science | Excel Data Manip

    • 02 Levels Of Data Measurement | Excel Data Manip

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

  • 10. How to measure data

    • 01 Measures Of Central Tendency In Data | Excel Data Manip

    • 02 Measures Of Variability In Data | Excel Data Manip

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

    • 04 Generate Skewed Datasets With Chatgpt | Excel Data Manip

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

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

  • 11. Measuring Sales Performance with KPIs and Excel
  • 12. Measuring Performance with KPIs in Excel and ChatGPT

    • 02.01.Project Preview | Sales Analytics Excel

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

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

    • 02.04.Marketing And Financial Kpis | Sales Analytics Excel

    • 02.05.Customer-Related Kpis | Sales Analytics Excel

  • 13. KPI Case Study in Excel with ChatGPT

    • 03.01.Project Preview | Sales Analytics Excel

    • 03.02.Case Study Involving Kpis | Sales Analytics Excel

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

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

    • 03.05.Determining Lead Conversion Time | Sales Analytics Excel

  • 14. Analyzing Sales Data
  • 15. Visualizing Sales Data

    • 05.01. Project Preview | Sales Analytics Excel

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

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

    • 05.05.Analyzing Lead Generation Trends | Sales Analytics Excel

    • 05.06.Analyzing Salesperson Performance | Sales Analytics Excel

    • 05.07.Building A Sales Dashboard | Sales Analytics Excel

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

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

    • 06.02.Building The Whale Model | Sales Analytics Excel

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

    • 06.04.Excel Preparation For Analysis | Sales Analytics Excel

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

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

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

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

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

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

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

  • 17. Maximizing Customer Value

    • 07.01.Project Preview | Sales Analytics Excel

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

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

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

    • 08.02.Modeling Trends And Seasonality | Sales Analytics Excel

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

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

    • 08.05.Preprocessing Data For Regression | Sales Analytics Excel

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

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

    • 08.08.Using Xlstat For Forecasting | Sales Analytics Excel

  • 19. Customer Lifetime Increase

    • 09.01.Project Preview | Sales Analytics Excel

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

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

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

  • 20. Excel Mastery & Business Strategies with ChatGPT: Advanced Techniques for Modern Professionals
  • 21. Automate Excel with ChatGPT

    • 02 01 Project Preview | Adv GPT Excel

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

    • 02.02B Excel With Chatgpt | Adv GPT Excel

    • 02.03 Write Excel Formulas With Chatgpt | Adv GPT Excel

    • 02.04 Use Chatgpt Formulas In Excel | Adv GPT Excel

  • 22. Build Investment Dashboard with ChatGPT and Excel

    • 03 01 Project Preview | Adv GPT Excel

    • 03.02A Set Up Dashboard | Adv GPT Excel

    • 03.02B Set Up Data | Adv GPT Excel

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

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

    • 03.03C Placing Data On Dashboard | Adv GPT Excel

  • 23. Sales Automation with ChatGPT and Excel

    • 04 01 Project Preview | Adv GPT Excel

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

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

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

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

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

    • 04.03D Building Sales Overview Dashboard | Adv GPT Excel

    • 04.03E Refining The Pos System | Adv GPT Excel

  • 24. Automate Business Writing with ChatGPT

    • 05 01 Project Preview | Adv GPT Excel

    • 05.02 Meeting Agendas And Minutes | Adv GPT Excel

    • 05.03 Write A Business Proposal | Adv GPT Excel

    • 05.04 Build A Business Report | Adv GPT Excel

    • 05.05 Build A Business Plan | Adv GPT Excel

    • 05.06 Build A Business Performance Appraisal | Adv GPT Excel

    • 05.07 Build A Business Presentation | Adv GPT Excel

    • 05.08 Summarize Business Documents | Adv GPT Excel

    • 05.09 Write Job Descriptions | Adv GPT Excel

    • 05.10 Build White Papers | Adv GPT Excel

    • 05.11 Build Employee Handbooks | Adv GPT Excel

    • 05.12 Build Business Manuals | Adv GPT Excel

  • 25. Automate Social Media Business with ChatGPT

    • 06 01 Project Preview | Adv GPT Excel

    • 06.02 Set Up Project | Adv GPT Excel

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

    • 06.03C Finishing Touches | Adv GPT Excel

00 About Mammoth Interactive

Sign in to perform actions on this cast!
@mammoth 11 Followers
7 Views 0 Likes 0 Comments

Comment
Leave a comment (supports markdown format)