How To Use Microsoft Copilot in Excel

Поделиться
HTML-код
  • Опубликовано: 6 июл 2024
  • Unleash the full potential of Microsoft Copilot in Excel! In this video, we'll show you how to make the most of Copilot Pro, the paid edition that takes your Excel experience to new heights. Dive into the world of data analysis, understanding, and visualization with Copilot's innovative features. We'll also reveal some of the limitations you should be aware of. Don't wait any longer - hit that subscribe button and join us on this exciting Excel journey!
    My Amazon Store | www.amazon.com.au/shop/aldoja...
    Timestamps:
    0:00 Intro
    0:38 Two caveats to accessing Copilot in Excel
    1:29 How to convert data into a Table in Excel
    1:51 Moving and adjusting Copilot panel around
    2:07 Using Prompts to get started with Copilot
    3:01 Highlighting data with Copilot in excel
    3:37 Troubleshooting Copilot Issues in Excel
    4:17 Copilot on the web
    4:58 Using more specific prompts
    5:16 Analysing Data and generating formulas with Copilot - MUST WATCH
    7:05 Creating graphs with Copilot
    7:44 Another Troubleshooting issue and solution
    8:55 Troubleshooting solution 3
    9:37 Generating charts with Copilot
    10:22 Asking more complex questions
    11:10 Getting data insights from Copilot and limitations
    #Microsoft #Copilot #Excel
  • НаукаНаука

Комментарии • 22

  • @j.k6580
    @j.k6580 4 месяца назад

    great guide

  • @samsonameh5545
    @samsonameh5545 5 месяцев назад +1

    So interesting.

  • @analyticswithadam
    @analyticswithadam 4 месяца назад +2

    Nice Video Aldo, found it really useful, was pulling my hair out on desktop

  • @tanwedar
    @tanwedar 4 месяца назад

    In your generating charts section you talk about it getting stuck. If you follow the prompt and click "go back to table" it let's you continue using Copilot as normal. 9:05

  • @lopsangdlama
    @lopsangdlama 4 месяца назад

    can't find what if analysis on microsfot 365 online excel

  • @davidlittle9575
    @davidlittle9575 4 месяца назад +2

    Such a missed opportunity for just tables. Formulas and conditional formatting is so needed.

    • @tanwedar
      @tanwedar 4 месяца назад

      You can have it create conditional formatting with fairly complex conditions. However, it is limited to tables of course.

  • @d20207
    @d20207 5 месяцев назад

    HAve you tried with a larger dataset? Theres another youtuber who tried with 5000, 40,000 rows and Copilot just stops working.

    • @A_D624
      @A_D624 5 месяцев назад

      I am pretty sure it can't handle large data sets right now.

    • @ninasazonova2511
      @ninasazonova2511 4 месяца назад

      It is interesting to compare this with Chat GPT 4 Data Analysis feature work with Excel tables downloaded

  • @jimmyglea
    @jimmyglea 4 месяца назад

    How is this faster? lol

  • @martinargimon730
    @martinargimon730 4 месяца назад +2

    SORRY . IS HIGHLY CONFUSING. IS COPILOT FOR FREE IN EXCEL OR NOT?????

  • @RhinoYoung
    @RhinoYoung Месяц назад

    This is hilarious, all these videos of people trying to get clicks on these new AI tools but no one giving their opinion, this Copilot LLM in current state is absolutely unusable and a waste of money. It's wild Microsoft even put this product out.

  • @TWARDOWSKY.
    @TWARDOWSKY. 3 месяца назад +1

    Not for free!!👎🏻

    • @AldoJames
      @AldoJames  3 месяца назад +1

      M365 copilot is a paid subscription

    • @TWARDOWSKY.
      @TWARDOWSKY. 3 месяца назад +1

      👎🏻🙈@@AldoJames