Qhov wikiHow no qhia koj yuav siv Power Query li cas hauv Excel 2016 ntawm Windows thiab Mac computer. Power Query yog Excel muaj nuj nqi uas tso cai rau koj xa cov ntaub ntawv los ntawm ntau qhov chaw (Excel cov ntxhuav, cov ntaub ntawv CSV, cov ntaub ntawv hauv online, thiab lwm yam), thiab yooj yim rov teeb tsa cov ntaub ntawv mus rau hauv lub rooj pivot hauv daim ntawv nthuav tawm. Microsoft tso tawm Power Query thiab Power Pivot ua Excel Ntxiv-ons hauv 2010 tab sis cov yam ntxwv tam sim no yog tus qauv hauv Excel 2016 raws li "Tau thiab Hloov" ua haujlwm.
Cov kauj ruam
Kauj Ruam 1. Qhib Excel
Nws yog lub cim app uas zoo ib yam rau daim ntawv nthuav qhia ntsuab nrog dawb "X" ntawm lub hau.
Kauj Ruam 2. Qhib ib daim ntawv tshiab
Txhawm rau qhib daim ntawv tshiab, ib qho nyem "Tshiab" nyob rau sab ntsuab ntawm lub vijtsam qhib-lossis yog tias koj muaj daim ntawv uas twb muaj lawm qhib-nyem "Cov Ntaub Ntawv" thiab tom qab ntawd nyem "Tshiab."
Kauj Ruam 3. Nyem rau Cov Ntaub Ntawv tab
Nws nyob hauv cov ntawv qhia zaub mov saum toj ntawm Excel 2016.
Kauj Ruam 4. Nyem Tau Cov Ntaub Ntawv
Nws nyob ib sab ntawm lub cim uas zoo li lub rooj nyob rau pem hauv ntej ntawm lub roj teeb hauv lub thawv "Tau thiab Hloov". Qhov no qhia txog cov ntawv qhia zaub mov nco nrog ntau hom khoom siv uas koj tuaj yeem nqa cov ntaub ntawv los ntawm.
Ntawm Mac, nyem ib qho "Los ntawm HTML", "Los ntawm Cov Ntawv", lossis nyem "Cov Lus Nug Tshiab Database."
Kauj Ruam 5. Xaiv cov ntaub ntawv
"Cov Lus Nug Tshiab" cov ntawv qhia zaub mov muaj ntau yam ntawm cov ntawv qhia zaub mov uas tso cai rau koj ntshuam cov ntaub ntawv los ntawm ntau hom ntaub ntawv. Qhov no qhib qhov browser ntawv qhia zaub mov kom qhib cov ntaub ntawv. Nyem ib daim ntawv los xaiv nws, thiab tom qab ntawd nyem "Ntshuam". Qhov chaw hom menus suav nrog:
-
Los ntawm Cov Ntaub Ntawv:
Cov ntawv qhia zaub mov no tso cai rau koj xa cov ntaub ntawv los ntawm lwm daim ntawv Excel, daim ntawv CSV, ntawv XML, JSON, thiab ntau dua.
-
Los ntawm Database:
Cov ntawv qhia zaub mov no tso cai rau koj xa cov ntaub ntawv los ntawm cov ntaub ntawv xws li MySQL lossis Oracle.
-
Los ntawm Kev Pabcuam Online:
Cov ntawv qhia zaub mov no tso cai rau koj xa cov ntaub ntawv los ntawm cov peev txheej online, xws li SharePoint, Microsoft Exchange, Salesforce, thiab Facebook.
-
Los ntawm Lwm Qhov Chaw:
Cov ntawv qhia zaub mov no tso cai rau koj xa cov ntaub ntawv los ntawm lwm qhov chaw, xws li lub vev xaib, Active Directory, OData, Hadoop files, ODBC, OLEDB, thiab tsis muaj lus nug.
Kauj Ruam 6. Xaiv cov ntaub ntawv koj xav tau ntshuam
Thaum koj ntshuam cov ntaub ntawv los ntawm cov ntaub ntawv sab nraud lossis lub hauv paus, lub qhov rais qhib uas tso cai rau koj xaiv cov ntaub ntawv tshwj xeeb los ntawm koj qhov chaw. Nyem cov ntaub ntawv yam koj xav thauj hauv lub sidebar rau sab xis. Tom qab ntawv nyem "Load" nyob rau sab xis-sab tes xis ntawm lub qhov rais. Qhov no thauj cov ntaub ntawv thiab tsim kev sib txuas rau cov ntaub ntawv.
Kauj Ruam 7. Muab ob npaug nias lo lus nug los kho nws
Txhua cov lus nug tau teev nyob hauv qab "Workbook Queries" sidebar rau sab xis. Ob-nias qhov lus nug qhib cov lus nug editor.
Yog tias lub sidebar "Workbook Queries" tsis qhia tawm ntawm lub vijtsam, nyem rau "Data" tab thiab tom qab ntawd nyem "Cov Lus Nug & Kev Sib Txuas" hauv ntu "Tau thiab Hloov". Ntawm Mac, nyem rau "Txuas" khawm kom teev cov kev sib txuas tam sim no
Kauj Ruam 8. Kho kom raug thiab hloov pauv koj cov ntaub ntawv
Tus kws kho lus nug muaj ntau yam cuab yeej koj tuaj yeem siv los kho thiab hloov pauv koj cov ntaub ntawv. Koj tuaj yeem ntxiv lossis tshem kab thiab kab, sib tshuam lossis ntxiv cov lus nug, thiab hloov cov ntaub ntawv hauv ntau txoj hauv kev.
Yog tias koj tab tom koom ua ke ob qhov lus nug ua ke, nyem "Sib Koom Cov Lus Nug". Tom qab ntawd koj yuav tsum xaiv thaj chaw cov ntaub ntawv sib xws uas ob nqe lus nug yuav muab ua ke ua ke los ntawm. Tom qab ntawv siv "Koom Tes Zoo" cov ntawv qhia zaub mov nco tseg kom xaiv cov ntaub ntawv twg yuav suav nrog tom qab lawv sib koom ua ke
Kauj Ruam 9. Hauv Query Editor, nyem Kaw thiab Load
Nws yog lub pob uas muaj lub cim ntawm lub disk ntshav nyob rau ntawm xub ntiag ntawm ib daim ntawv. Nws nyob rau sab laug-sab laug hauv qab "Tsev" tab. Qhov no xa tawm cov ntaub ntawv los ntawm cov lus nug editor rau hauv daim ntawv Excel.
