Tanthauzo, Zochita ndi Zitsanzo za Ntchito mu Excel

Ntchito ndi ndondomeko yoyenerera ku Excel ndi Google Mapepala omwe cholinga chake ndi kuwerengera mwapadera mu selo yomwe ili.

Ntchito Syntax ndi Arguments

Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa .

Monga machitidwe onse, ntchito zimayambira ndi chizindikiro chofanana ( = ) chotsatira ndi dzina la ntchito ndi zifukwa zake:

• Dzina la ntchito limamuuza Excel zomwe ziwerengero zichita;
• Zokambirana zili mkati mwa mababu kapena mabotolo ozungulira ndikuuza ntchito zomwe deta yogwiritsira ntchito muzowerengerazo.

Mwachitsanzo, imodzi mwa ntchito zogwiritsidwa ntchito kwambiri mu Excel ndi Google Sheets ndi ntchito SUM :

= SUM (D1: D6)

Mu chitsanzo ichi,

• dzina limatchula Excel kuti liwonjezere pamodzi data mu maselo osankhidwa;
• kukangana (D1: D6) ntchito kumaphatikizapo zomwe zili mu selo lonse D1 mpaka D6.

Kumeta Zochita mu Mafomu

Kuwathandiza kwa ntchito za Excel zomwe zakhala zikugwiritsidwa ntchito zingathe kupitsidwanso ndi kutsegula chimodzi kapena zambiri ntchito mkati mwa ntchito ina mu fomu. Zotsatira za nesting ntchito ndilola kuti mawerengedwe angapo achitike mu selo limodzi lamasamba.

Kuti tichite izi, ntchito yachisala imakhala ngati imodzi mwa zifukwa za ntchito yaikulu kapena yapamwamba.

Mwachitsanzo, mu njira yotsatirayi, ntchito ya SUM yakhazikika mkati mwa ntchito ya ROUND .

Izi zikukwaniritsidwa pogwiritsa ntchito ntchito SUM monga ndondomeko ya ntchito ya ROUND .

& # 61; ROUND (SUM (D1: D6), 2)

Poganizira ntchito zowongoka, Excel imapanga zakuya, kapena mkati, ntchito yoyamba ndikuyendetsa kunja. Zotsatira zake, ndondomeko pamwambayi tsopano:

1. pezani chiwerengero cha zikhalidwe mu maselo D1 mpaka D6;
2. Zotsatira za zotsatirazi ndi malo awiri osungira.

Kuchokera mu Excel 2007, mpaka ma 64 masitepe a ntchito zonyamulidwa amaloledwa. M'zinenero zisanayambe izi, ndondomeko zisanu ndi ziŵiri za ntchito zakuda zinaloledwa.

Pulogalamu Yophatikizapo Kupanga Ntchito Zopangira Machitidwe

Pali magulu awiri a ntchito mu Excel ndi Google Mapepala:

• Ntchito zolemba zolemba
• Ntchito Zopangidwira kapena Zolemba za Mtumiki

Ntchito Zopangira Ntchito ndizochokera kuzinthu zomwe zikuchitika, monga SUM ndi ROUND zomwe takambirana pamwambapa.

Ntchito zamtunduwu, kumbali inayo zimagwiritsidwa ntchito, kapena kutanthauzidwa , ndi wogwiritsa ntchito.

Mu Excel, ntchito zamakhalidwe zinalembedwa m'chinenero chokonzekera: Visual Basic kwa Applications kapena VBA mwachidule. Ntchitoyi imapangidwa pogwiritsa ntchito Visual Basic mkonzi yomwe ili pa tebulo lokonzekera la Ribbon .

Machitidwe a chizolowezi cha Google Masamba amalembedwa mu Apps Script - mawonekedwe a JavaScript - ndipo amapangidwa pogwiritsa ntchito script editor yomwe ili pansi pa Zida .

Ntchito zamtunduwu nthawi zambiri, koma osati nthawi zonse, kulandira mawonekedwe ena a deta ndikubwezera zotsatira mu selo yomwe ili.

M'munsimu muli chitsanzo cha wogwiritsa ntchito wotanthawuza ntchito yomwe imawerengera wogula kuchotsera zolembedwa mu VBA code. Wogwiritsa ntchito oyambirira akugwira ntchito, kapena UDF imafalitsidwa pa webusaiti ya Microsoft:

Ntchito Yopereka (kuchuluka, mtengo)
Ngati kuchuluka> = 100 Ndiye
Phindu = mtengo * * 0.1
Zina
Phindu = 0
Kutha Ngati
Chiwongoladzanja = Kuchita.Kuonjezera (Wopatsa, 2)
Kutsiriza Ntchito

Zolepheretsa

Mu Excel, ntchito zosankhidwa zomwe zimagwiritsidwa ntchito zimangobweretsanso zikhulupiliro ku maselo omwe ali. Pochita zimenezi, sangathe kuchita malamulo omwe angasinthe chilengedwe cha Excel - monga kusinthira zomwe zili mkati kapena kupangidwe kwa selo.

Zomwe amadziŵa Microsoft zimasonyeza zochepa zotsatirazi zomwe zimagwiritsidwa ntchito ntchito:

• Kuika, kuchotsa, kapena kupangika maselo muzenera;
• Kusintha mtengo wa deta mu selo ina;
• Kusuntha, kukonzanso, kuchotsa, kapena kuwonjezera mapepala ku bukhu la ntchito ;
• Kusintha malo omwe mungasankhe - monga mawerengedwe owonetsera kapena mawonedwe;
• Kuika katundu kapena kuchita njira zambiri.

Ntchito Zowonongeka ndi Ma Macros mu Excel

Pamene ma Sheets a Google sakuwathandizira pakali pano, mu Excel, macro ndi zolemba zambiri zomwe zimapangitsa ntchito zobwerezabwerezabwereza zomwe zimagwiritsidwa ntchito - monga kupanga ma deta kapena zolemba ndi kusunga - mwa kutsanzira zolemba kapena zochita za mouse.

Ngakhale onse awiri akugwiritsa ntchito chinenero cha Microsoft VBA, amasiyana mosiyana:

1. UDF amachita mawerengedwe pamene macros amachita zochita. Monga tafotokozera pamwambapa, UDF sangachite ntchito zomwe zimakhudza chilengedwe pomwe ma macros akhoza.
2. Muwindo la Visual Basic editor, awiriwa akhoza kusiyanitsidwa chifukwa:
   • UDF imayamba ndi ndondomeko ya Ntchito ndipo imatha ndi Ntchito Yomaliza ;
   • Macros ayambira ndi ndondomeko ya Sub ndi kutha ndi End Sub .