Udemy

Excel + ChatGPT : The Complete AI- Powered Excel Course-2026

立即報名
  • 137 名學生
  • 更新於 3/2026
4.3
(19 個評分)
CTgoodjobs 嚴選優質課程,為職場人士提升競爭力。透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期
全年招生
課程級別
學習模式
教學語言
英語
授課導師
Manoj Kumar
評分
4.3
(19 個評分)

課程簡介

Excel + ChatGPT : The Complete AI- Powered Excel Course-2026

Be an Expert in MS Excel with CHAT GPT - 2025

Welcome to most updated MS Excel learning sessions. Which includes all controls along with real-time scenarios. Discussed all formulas along with examples.


This training sessions covers below the details -

  1. Fundamentals on MS Excel

  2. Field by Field discussion on all control which we have under TABS

  3. Clipboard, Font management, Alignment, Number setup,

  4. Conditional formatting

  5. Format as table

  6. Cell style

  7. Insert, delete & format the cell, rows & columns

  8. SUM, Fill, clear the data in MS Excel

  9. Add in and how to convert excel to PDF

  10. Pivot Tables

  11. Advanced Pivot Tables

  12. Recommended PIVOT tables & tables

  13. How to insert PICTURES, SHAPES, ICON & 3D MODELS

  14. How to insert MAP in excel

  15. Text Function

  16. Sparklines

  17. How to add hyperlinks in MS Excel

  18. Filter the data

  19. Advanced filter

  20. Timeline

  21. Insert comments, delete comments & Edit comments

  22. Insert notes, delete notes & Edit notes

  23. Text functionalities

  24. How to insert symbols

  25. Drawing tools

  26. Ink to Shape

  27. Ink to Math

  28. Ink replay

  29. Theme effects

  30. Page setup for printout

  31. How to increase height, weight & scale setup

  32. Sheet option

  33. Text alignment

  34. Arrangement in MS Excel

  35. Formulas

  36. How to transform the data in MS Excel from text/CSV. INTERNET, XML, JSON & PDF

  37. Proofing

  38. Check accessibility

  39. How to translate the data in different languages

  40. Insert comments, display comments

  41. Insert notes, display notes

  42. How to protect the excel sheet with password

  43. Hide link

  44. Sheet view

  45. How to break up the preview

  46. Page layout setting for printout

  47. Customer view for printout

  48. How to hide & display gridlines, formula bar & Headings

  49. ZOOM

  50. How to freeze panes

  51. How to switch the windows

  52. MACRO recording

  53. Use relative reference

  54. Data entry from basic to advance level

  55. VLOOKUP

  56. HLOOKUP

  57. XLOOKUP

  58. CHAT GPT

  59. Dashboard


課程章節

  • 32 個章節
  • 192 堂課
  • 第 1 章 How this MS Excel course will help us to become an Expert in MS EXCEL?
  • 第 2 章 How to open excel sheet?
  • 第 3 章 HOME Tab Group - Functionality of each and every field comes under HOME Tab
  • 第 4 章 INSERT Tab -Insert PIVOT table
  • 第 5 章 INSERT Tab - Pivot Table Options & Settings
  • 第 6 章 INSERT Tab - Show value as in PIVOT TABLE
  • 第 7 章 INSERT Tab - Calculated as, Filter & filter report pages, Slicer & Timeline
  • 第 8 章 Insert tab - Insert PICTURE, SHAPES, ICON 3D Models, SmartArt and Screen shots
  • 第 9 章 INSERT Tab - PIVOT CHART
  • 第 10 章 INSERT Tab - Insert Sparklines & Filters
  • 第 11 章 INSERT Tab - Insert Hyperlink in MS Excel
  • 第 12 章 Insert comments, Insert Texts & Insert Symbols
  • 第 13 章 Insert Texts
  • 第 14 章 Draw in MS Excel
  • 第 15 章 Page Layout set up in MS Excel
  • 第 16 章 Scale to Fit (Width, Height & Scale)
  • 第 17 章 All Formulas in MS Excel
  • 第 18 章 DATA Tab - Get & Transform Data, Queries & Connections, Sort & Filters
  • 第 19 章 Sort & Filter
  • 第 20 章 Data Tools in MS Excel
  • 第 21 章 Consolidate the data in MS Excel
  • 第 22 章 DATA Tab - Data Model
  • 第 23 章 What-If Analysis (Scenario Manager, Goal Seek & Data Table)
  • 第 24 章 Review TAB in MS Excel
  • 第 25 章 VIEW tab in MS Excel (All controls with real-time example)
  • 第 26 章 How to RECORD MACRO in MS Excel?
  • 第 27 章 50 Shortcuts in MS Excel
  • 第 28 章 Become an EXPERT in MS Excel DATA ENTRY.
  • 第 29 章 VLOOKUP - Very Basic level to Advanced level
  • 第 30 章 HLOOKUP - Very Basic level to Advanced level
  • 第 31 章 XLOOKUP - Basic example on XLookup
  • 第 32 章 AI Chat GPT for Excel in Details

課程內容

  • Master in Microsoft excel spreadsheets works, We can do data entry in smart way, We must be expert on Microsoft Excel formula, Data analysis, Charts and graphs on Microsoft Excel, Sorting data, Find and replace, VLOOK UP, HLOOKUP, XLOOKUP, Microsoft Excel shortcuts and best practices to increase the productivity, Conditional formatting on data entry, DATA ENTRY, CHAT GPT


評價

  • D
    Datta Dhakne
    5.0

    Deep Understood, Very Nice, Excellent.

  • D
    Dipshikha Sharma
    5.0

    Superb. Nice explanation.

  • N
    Naresh Saha
    5.0

    Best trainer for MS Excel which I found on Udemy. Just awesome.

  • B
    Bhawna Sharma
    5.0

    Best course for beginner to advance level. Each and every session explained in detail with appropriate example. I will recommend this course.

立即關注瀏覽更多

本網站使用Cookies來改善您的瀏覽體驗,請確定您同意及接受我們的私隱政策使用條款才繼續瀏覽。

我已閱讀及同意