Qhov wikiHow no qhia koj li cas kom siv cov ntaub ntawv qhia txog tus kheej hauv Microsoft Excel. Txog cov ntaub ntawv sab nraud, qhov wikiHow yuav qhia koj yuav ua li cas nug thiab tsim cov ntawv tshaj tawm los ntawm lwm cov ntaub ntawv sab nraud (MySQL, Postgres, Oracle, thiab lwm yam) los ntawm hauv koj daim ntawv ua haujlwm siv Excel plugins uas txuas koj daim ntawv rau sab nraud cov ntaub ntawv.
Txog cov ntaub ntawv twb tau khaws cia hauv daim ntawv Excel, peb yuav siv macros los tsim cov ntawv tshaj tawm thiab xa tawm lawv hauv ntau hom ntaub ntawv nrog nias ntawm ib tus yuam sij. Hmoov zoo, Excel los nrog cov ntawv sau ua ntu uas txhais tau tias koj yuav tsis tas yuav sau tus lej koj tus kheej.
Cov kauj ruam
Txoj Kev 1 ntawm 2: Rau Cov Ntaub Ntawv Twb Muaj Hauv Excel
Kauj Ruam 1. Yog tias cov ntaub ntawv koj xav tau tshaj tawm twb tau khaws cia, hloov kho, thiab khaws cia hauv Excel, koj tuaj yeem siv cov ntaub ntawv qhia ua haujlwm tau siv lub Macros
Macros yog lub hauv paus ua haujlwm uas tso cai rau koj siv txoj haujlwm nyuaj thiab rov ua dua.
Kauj ruam 2. Qhib Excel
Ob npaug nias (lossis nyem yog tias koj nyob ntawm Mac) Excel app icon, uas zoo ib yam li "X" dawb ntawm keeb kwm ntsuab, tom qab ntawv nyem Phau ntawv ua haujlwm dawb paug ntawm nplooj ntawv qauv.
- Ntawm Mac, koj yuav tsum nyem Cov ntaub ntawv thiab tom qab ntawd nyem Phau Ntawv Npliag Tshiab hauv qhov tshwm sim nco-down ntawv qhia zaub mov.
- Yog tias koj twb muaj daim ntawv tshaj tawm Excel uas koj xav kom siv tau, koj yuav hloov ob npaug rau nyem qhov ntawv qhia kom qhib nws hauv Excel.
Kauj Ruam 3. Nkag mus rau koj cov ntaub ntawv cov ntaub ntawv yog tias tsim nyog
Yog tias koj tsis tau ntxiv cov kab ntawv thiab cov lej uas koj xav kom ua tiav cov txiaj ntsig, ua li ntawd ua ntej mus ntxiv.
Kauj Ruam 4. Pab kom tus tsim tawm tab
Los ntawm lub neej ntawd, lub Tsim tawm tab tsis tshwm nyob rau sab saud ntawm Excel qhov rai. Koj tuaj yeem pab nws los ntawm kev ua cov hauv qab no nyob ntawm koj lub operating system:
- Windows - Nyem Cov ntaub ntawv, nyem Kev xaiv, nyem Customize Ribbon nyob rau sab laug ntawm lub qhov rais, khij lub npov "Developer" nyob rau sab qis-sab xis ntawm lub qhov rais (thawj zaug koj yuav tsum tau nqes mus), thiab nyem OK.
- Mac - Nyem Excel, nyem Nyiam …, nyem Ribbon & Toolbar, khij lub npov "Tus tsim tawm" hauv "Cov Ntawv Tabs", thiab nyem rau Txuag.
Kauj Ruam 5. Nyem rau Tus Tsim Tawm
Cov ntawv no yuav tsum yog tam sim no nyob rau sab saud ntawm Excel qhov rai. Ua li ntawd coj mus rau qhov toolbar nyob rau sab saum toj ntawm Excel qhov rai.
Kauj Ruam 6. Nyem Sau Macro
Nws nyob hauv toolbar. Ib lub qhov rai pop-up yuav tshwm.
Kauj Ruam 7. Sau lub npe rau lub macro
Hauv kab ntawv "Macro name", ntaus lub npe rau koj lub macro. Qhov no yuav pab koj txheeb xyuas cov macro tom qab.
Piv txwv li, yog tias koj tab tom tsim lub macro uas yuav ua daim ntawv tawm ntawm koj cov ntaub ntawv muaj, koj yuav sau nws "Chart1" lossis zoo sib xws
Kauj Ruam 8. Tsim kom muaj qhov tseem ceeb sib xyaw ua ke rau cov macro
Nias lub ⇧ Hloov ua ke nrog rau lwm tus yuam sij (piv txwv li, T tus lej) los tsim cov keyboard luv. Nov yog qhov koj yuav siv los khiav koj lub macro tom qab.
Ntawm Mac, txoj kev sib txuas ua ke luv yuav xaus ua ⌥ Kev Xaiv+⌘ Hais kom ua thiab koj tus yuam sij (piv txwv li, ption Xaiv+⌘ Hais kom+T)
Kauj Ruam 9. Khaws cov macro hauv daim ntawv Excel tam sim no
Nyem rau "Khw Macro" hauv lub thawv nco-down, tom qab ntawd nyem Phau ntawv no los xyuas kom meej tias yuav muaj macro rau txhua tus uas qhib phau ntawv ua haujlwm.
Koj yuav tsum khaws Excel cov ntaub ntawv hauv hom tshwj xeeb rau lub macro kom tau txais kev cawmdim
Kauj ruam 10. Nyem OK
Nws nyob hauv qab ntawm lub qhov rais. Ua li ntawd yuav txuag koj cov teeb tsa macro thiab tso koj rau hauv hom kaw. Txhua kauj ruam uas koj ua txij tam sim no mus txog thaum koj tso tseg qhov kaw cia yuav raug kaw.
Kauj Ruam 11. Ua cov kauj ruam uas koj xav siv lub tshuab kom zoo
Excel yuav taug qab txhua qhov nyem, cov yuam sij, thiab kev xaiv ua hom ntawv koj nkag mus thiab ntxiv lawv rau hauv cov npe macro.
- Piv txwv li, txhawm rau xaiv cov ntaub ntawv thiab tsim daim ntawv qhia tawm ntawm nws, koj yuav hais txog koj cov ntaub ntawv, nyem Ntxig nyob rau sab saum toj ntawm lub qhov rais Excel, nyem rau hom kab ntawv, nyem rau daim duab uas koj xav siv, thiab hloov daim duab raws li xav tau.
- Yog tias koj xav siv lub macro ntxiv cov txiaj ntsig los ntawm cov cell A1 dhau A12, koj yuav nyem qhov khoob ntawm tes, ntaus hauv = SUM (A1: A12), thiab nias ↵ Enter.
Kauj Ruam 12. Nyem Nthuav Tawm Cov Ntaubntawv
Nws nyob hauv Tsim tawm tab toolbar. Qhov no yuav nres koj cov ntaubntawv povthawj siv thiab khaws txhua cov kauj ruam uas koj tau ua thaum teev cia raws li tus kheej.
Kauj Ruam 13. Txuag koj daim ntawv Excel ua cov ntaub ntawv qhib siv macro
Nyem Cov ntaub ntawv, nyem Txuag As, thiab hloov cov ntaub ntawv hom rau xwm ls es tsis txhob xl xws. Tom qab ntawd koj tuaj yeem sau lub npe cov ntaub ntawv, xaiv qhov chaw nyob ntawm cov ntawv, thiab nyem Txuag.
Yog tias koj tsis ua qhov no, lub macro yuav tsis raug cawm ua ib feem ntawm daim ntawv nthuav qhia, txhais tau tias lwm tus neeg ntawm cov khoos phis tawj sib txawv yuav tsis muaj peev xwm siv koj lub macro yog tias koj xa phau ntawv ua haujlwm rau lawv
Kauj Ruam 14. Khiav koj lub macro
Nias qhov tseem ceeb ua ke uas koj tau tsim los ua ib feem ntawm macro kom ua li ntawd. Koj yuav tsum pom koj daim ntawv nthuav qhia siv tau raws li koj cov kauj ruam.
Koj tseem tuaj yeem ua haujlwm macro los ntawm txhaj Macros hauv Tsim tawm tab, xaiv koj lub npe macro, thiab nyem rau Khiav.
Txoj Kev 2 ntawm 2: Rau Cov Ntaub Ntawv Sab Nraud (MySQL, Postgres, Oracle, thiab lwm yam)
Kauj Ruam 1. Rub tawm Kloudio's Excel plugin los ntawm Microsoft AppSource
Qhov no yuav tso cai rau koj los tsim kev sib txuas tsis tu ncua ntawm cov ntaub ntawv sab nraud lossis cov ntaub ntawv thiab koj phau ntawv ua haujlwm. Lub plugin no tseem ua haujlwm nrog Google Sheets.
Kauj Ruam 2. Tsim kev sib txuas ntawm koj daim ntawv ua haujlwm thiab koj cov ntaub ntawv sab nraud los ntawm txhaj rau + khawm ntawm Kloudio portal
Ntaus cov ntsiab lus ntawm koj cov ntaub ntawv (hom ntaub ntawv, ntaub ntawv pov thawj) thiab xaiv ib qho kev nyab xeeb/encryption xaiv yog ua haujlwm nrog tsis pub lwm tus paub lossis tuam txhab cov ntaub ntawv.
Kauj Ruam 3. Thaum koj tau tsim kev sib txuas ntawm koj daim ntawv ua haujlwm thiab koj cov ntaub ntawv khaws cia, koj yuav tuaj yeem nug thiab tsim cov ntawv tshaj tawm los ntawm cov ntaub ntawv sab nraud yam tsis tau tawm hauv Excel
Tsim koj cov ntawv tshaj tawm los ntawm Kloudio lub portal thiab tom qab ntawv xaiv lawv los ntawm cov ntawv qhia zaub mov nco hauv Excel. Tom qab ntawd koj tuaj yeem thov siv cov ntxaij lim dej ntxiv thiab xaiv qhov zaus uas daim ntawv tshaj tawm yuav rov ua dua tshiab (yog li koj tuaj yeem hloov kho koj daim ntawv nthuav qhia hloov tshiab txhua lub lim tiam, ib hnub, lossis ib teev.)
Kauj Ruam 4. Ntxiv rau, koj tseem tuaj yeem muab cov ntaub ntawv tso rau hauv koj daim ntawv ua haujlwm txuas thiab muaj cov ntaub ntawv hloov kho koj cov ntaub ntawv sab nraud
Tsim tus qauv tso tawm los ntawm Kloudio lub portal thiab koj yuav tuaj yeem ua tus kheej lossis cia li xa cov kev hloov pauv hauv koj daim ntawv nthuav tawm rau koj cov ntaub ntawv sab nraud.
Yees duab - Los ntawm kev siv qhov kev pabcuam no, qee cov ntaub ntawv yuav raug muab qhia rau YouTube
Lub tswv yim
- Tsuas yog rub tawm Excel plugins los ntawm Microsoft AppSource, tshwj tsis yog koj ntseeg tus muab kev pabcuam thib peb.
- Macros tuaj yeem siv rau txhua yam los ntawm cov haujlwm yooj yim (piv txwv li, ntxiv qhov tseem ceeb lossis tsim daim duab) rau cov uas nyuaj (piv txwv li, suav koj lub xov tooj ntawm tes qhov tseem ceeb, tsim daim ntawv los ntawm cov txiaj ntsig, sau daim ntawv, thiab luam tawm qhov tshwm sim).
- Thaum qhib daim ntawv nthuav qhia nrog koj cov macro suav nrog, koj yuav tau nyem Pab kom Cov Ntsiab Lus nyob rau hauv lub chij daj rau saum lub qhov rais ua ntej koj tuaj yeem siv lub macro.
Lus ceeb toom
- Macros tuaj yeem siv lub siab phem (piv txwv li, rho tawm cov ntaub ntawv ntawm koj lub computer). Tsis txhob khiav macros los ntawm qhov chaw tsis ntseeg siab.
- Macros yuav ua raws li txhua kauj ruam uas koj ua thaum kaw. Nco ntsoov tias koj tsis yuam kev nkag mus rau qhov tsis raug, qhib qhov program koj tsis xav siv, lossis rho tawm cov ntawv.