Create Intelligent Excel Spreadsheets Enhanced with AI (GPT)

سرفصل های دوره

Transform Your Excel Spreadsheets with AI: Unlock the Future of MS Excel with Enhanced Automation by ChatGPT

1 - Getting Started with Generative AI in Excel

1 - Understanding the Excel Environment

2 - Integrate Office Addins into Excel

3 - Accessing ChatGPT

3 - Link to ChatGPT.txt

2 - AI Formula Integration in Excel

4 - Applying Generative AI Formulas with ChatGPT

4 - Student-grades-Spreadsheet.xlsx

5 - Microsoft app link for the AIaided Formula Editor.txt

5 - Product-Sales-Example.xlsx

5 - Utilizing the AIAided Formula Editor

6 - Applying Generative AI Formulas to Extract and Reformat Data SheetSavy AI

6 - Microsoft app link for SheetSavy AI.txt

6 - Sample-products-data.xlsx

3 - Enhancing Spreadsheet Efficiency with AI Tools and VBA Integration

7 - Gen-AI-VBA-student-grades.xlsx

7 - Leverage ChatGPT to Generate Spreadsheets using VBA Code in Excel

8 - Importing Existing Excel Data for AI Intervention

8 - Student-grades-with-letter-grades.xlsx

9 - Autofit Columns via Generative AI VBA Code

4 - Dynamic Data Management and Analysis with Functions

10 - Applying the IF Function for Conditional Selection in Excel using AI

10 - Employee-Arrival-Time.xlsx

11 - Find-Name-Lookup.xlsx

11 - Using Lookup Functions with AI to Search for Desired Data

12 - Random-Customer-Data.xlsx

12 - Separate CommaDelimited Data using AI

13 - Analyzing Complex Data Models with AI Rowsi AI

13 - Example-Pre-App-Simple-Financial-Model.xlsx

13 - Microsoft app link for Rowsi AI.txt

5 - Creating Custom Solutions with Macros and Interactive Controls

14 - Creating a Macro for an EMI Calculator with AI using Form Controls

15 - Loan-Report-EMI.xlsx

15 - Using AI to AutoPopulate Data with Interactive Form Controls

6 - Creating Excel Spreadsheet Visuals with AI

16 - Bricks-exportation-example.xlsx

16 - Link to the Bricks application.txt

16 - Using AI Spreadsheet Tools to Create Visuals The Bricks Application

17 - Creating Charts and Graphs for Imported Excel Data

7 - Conclusion

18 - Recap and Key Skills Learned

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy