Рет қаралды 3,521
We can use AI in our microsoft excel which can help use to populate /fetch information in no time. so today we are going to add a plugin for Microsoft excel which will help you to extract, fill, ask and make table through function.
first function is called as AI.Ask , which will help you to ask or create any function through an example in this video we will create a function which will help us to get first name , middle name and last name from a cell through AI.ask function.
Ai.Fill function will help us to autofill the blank spaces with few suggested example. in this video we are trying to fill Region and Area on the basis of some selected examples.
Ai.Extract - This function will help to you extract required value from a cell. like numbers, name, email address, country, region , area and more.
AI.Table - this function will provide data as per table format. if you have any question which have result in table format this function can help to you achieve that value.
#chatgpt #chatgptexcel #aiexcel
Download link :- docs.google.co...
*********FOLLOW ON*************
Facebook :- / excelworldofknowledge
Twitter - / sohandey3
Instagram :- / gyanontube
Telegram :- t.me/Gyanontube
______________________
POWER BI
Power BI In Excel In hindi :- • Power BI In Excel In h...
How to use Power Bi from beginner to advanced :- • Power Bi in hindi || H...
Power Bi में अपना काम सेव एंड रिकॉर्ड करे :- • Power Bi in Excel in h...
Power bi tutorial for beginners :- • Power bi tutorial for ...
Power BI dashboard :- • Microsoft Power BI In ...
Microsoft power bi in hindi :- • Power Bi tutorial for ...
Microsoft power bi course for free :- • Power Bi for beginners...
Delete unwanted columns in power bi :- • power bi tutorial for ...
Text to column in power bi for beginners :- • Text to column in powe...
Power BI with New Icon in 2020 :- • Power BI with New Icon...
Power Bi Reference option :- • Power Bi Reference opt...
Edit Data in power bi manually :- • Edit Data in power bi ...
power bi tutorial for beginners in hindi :- • power bi tutorial for ...
power bi dax tutorial for beginners :- • power bi dax tutorial ...
Power BI relationships between tables :- • Power BI relationships...
Excel formula
How to use index match formula from Basic to advance :- • index match excel || H...
How to make big formula in excel in hindi :- • combination formula ||...
Xlookup and Filter formula in hindi :- • Xlookup for Free || Ne...
How to reduce excel file size :- • compress excel file ||...
How to use Xlookup in excel :- • How to use Xlookup in ...
xlookup formula in hindi :- • How to use Xlookup in ...
array function in excel :- • Array formula excel ||...
New Xlookup with Search Mode :- • xlookup in excel in hi...
Xmatch formula in excel in hindi :- • Xmatch formula in exce...
how to use filter formula in excel in hindi :- • filter formula in exce...
Excel formulas and functions:- • Top 10 excel formulas ...
How to use excel unique function:- • How to use excel uniqu...
Sort formula in excel :- • Sort formula in excel ...
Pivot Table
pivot table from beginner to advanced :- • how to use pivot table...
Pivot table in hindi :- • Pivot Table In Excel |...
How to use pivot table excel :- • How to use pivot table...
Pivot table in hindi in excel :- • pivot table excel from...
Drill Down in Pivot table excel :- • Drill Down in Pivot ta...
Pivot Graph in excel in hindi :- • 3D Pivot Graph in exce...
how to use pivot table slicer :- • excel slicer || how to...
IF formula in Pivot table :- • advanced pivot tables ...
power pivot in excel :- • power pivot || how to ...
how to link data in power pivot in hindi :- • power pivot in excel |...
how to use power pivot in excel in hindi :- • power pivot in excel |...
Gyan On Tube Excel