Ho eketsa melaetsa e lumellanang le sele ho Excel ho u fa monyetla oa ho sebelisa mekhoa e fapaneng ea ho etsa mefuta, e kang 'mala, ha lintlha tse seleng eo li finyella maemo ao u a behileng.
Ho sebelisa mekhoa e metle ka mokhoa o bonolo ho na le likhetho tsa pele tse behiloeng tse koahelang maemo a tloaelehileng a sebelisoang, tse kang:
- Matsatsi
- Duplicate data
- Litekanyetso tse ka hodimo kapa tse ka tlaase ho tekanyo ea karolelano lisele tse ngata
Tabeng ea matsatsi, lits'ebetso tsa pele ho etsa li nolofalletsa ho hlahloba lintlha tsa hau bakeng sa matsatsi a haufi le letsatsi la hona joale, joalo ka maobane, hosasane, beke e fetileng kapa khoeling e latelang.
Haeba o batla ho hlahloba matsatsi a oelang ka ntle ho likhetho tse thathamisitsoeng ho tsona, leha ho le joalo, u ka khona ho etsa mekhoa e nepahetseng ka mokhoa oa ho kenya mekhoa ea hau ka ho eketsa foromo ea hau ka letsatsi kapa tse ling tsa mesebetsi ea letsatsi ea Excel.
01 ea 06
Ho hlahloba Matsatsi a 30, 60 le a 90 Matsatsi a fetileng
Ho etsa melaetsa e fapaneng ka mekhoa e sebelisoang ho etsoa ka ho beha molao o mocha oo Excel e o latelang ha o hlahloba data ka seleng.
Mohlala oa mohato ka mohato mona o beha melao e mecha e mecha ea ho etsa mekhoa e tla hlahloba ho bona hore na matsatsi a kenngoa lisele tse ngata tse khethiloeng li feta matsatsi a 30, matsatsi a 60 a fetileng, kapa matsatsi a 90 a fetileng.
Mekhoa e sebelisitsoeng ho melao ena e tlosa palo e itseng ea matsatsi ho tloha letsatsing la hona joale ho lisele tse C1 ho C4.
Letsatsi la morao tjena le baloa ho sebelisoa mosebetsi oa kajeno .
Bakeng sa thupelo ena eo u lokelang ho e sebetsa u tlameha ho kenya matsatsi a fellang ka mekhahlelo e thathamisitsoeng ka holimo.
Tlhokomeliso : Excel e sebetsa ka mokhoa o lumellanang ka tatellano, ho ea holimo ho ea tlase, hore melao e thathamisitsoe lebokoseng la boits'oaro la Molaetsa oa Melao-motheo ea Molaetsa oa Boipheliso joalokaha ho bonngoe setšoantšong se ka holimo.
Le hoja melao e mengata e ka sebetsa lisele tse ling, molao oa pele o sebetsanang le boemo o sebelisoa liseleng.
02 ea 06
Ho hlahloba Matsatsi a 30 Matsatsi a fetileng
- Totobatsa lisele tsa C1 ho C4 ho li khetha. Ena ke lethathamo leo re tla sebelisa melao ea mekhoa e nepahetseng
- Tlanya tab ea Home ea menu ea lithane .
- Tobetsa Setšoantšo sa Phatlalatso ea Phatlalatso ho bula menu ea ho theoha.
- Khetha khetho e Ncha . Sena se bula sa lebokose la New Formatting Rule dialog box.
- Tobetsa ho Sebelisa Foromo ho tseba hore na lisele li tla etsa mofuta ofe .
- Kenya mokhoa o latelang ka lebokose le ka tlaase ho maemo a Mofuta oo ho oona boleng ba 'nete e leng kgetho e ka tlaase halofo ea lebokoseng la lebokose la bobeli:
= KAJENO () - C1> 30
Tlhahlobo ena e hlahloba ho bona hore na matsatsi a liseleng tsa C1 ho ea ho C4 a feta matsatsi a fetang 30 - Tobetsa tokomane ea Fomati ho bula lebokose la bobeli la boitsebiso.
- Tobetsa Tlatsa tab ho bona mebala ea mebala e tlala.
- Khetha mmala o tletseng mokokotlo-ho bapisa mohlala ho thupelo ena, khetha botala bo bobebe.
- Tobetsa tab ea Font bakeng sa ho bona khetho ea mofuta oa feshene
- Tlas'a karolo ea 'mala, beha' mala oa mebala ho tšoeu ho tšoantša thuto ena.
- Tobetsa OK ka makhetlo a mabeli ho koala lebokose la lebokose le ho khutlela mosebetsing.
- Mobala o ka morao oa lisele tsa C1 ho C4 o tla fetela ho 'mala o tlala o khethiloeng, le hoja ho se na data liseleng.
03 ea 06
Ho eketsa Molao bakeng sa Matsatsi Matsatsi a fetang 60 a fetileng
Ho sebelisa Melao ea Melao ea Khetho
Ho e-na le ho pheta mehato eohle e ka holimo ho kenya melao e 'meli e latelang, re tla sebelisa khetho ea Melao ea Melao e tla re lumella ho eketsa melao e meng hang-hang.
- Totobatsa lisele tsa C1 ho C4, ha ho hlokahala.
- Tobetsa Tobeng ea Lehae ea menu ea lithane.
- Tobetsa ho setšoantšo sa Phatlalatso ea Phatlalatso ho bula menyetla ea ho theoha.
- Khetholla Melao ea Melao ea ho khetha Melao-motheo ea Boitsebiso ba Melao-motheo ea Molaetsa oa Boitsebiso.
- Tobetsa Ntho e Ncha ea Rule ka holimo e ka holimo le letšehali la lebokose la lebokose
- Tobetsa ho Sebelisa Foromo ho tseba hore na lisele li tla etsa mofuta ofe ho tsoa lethathamong le ka holimo ho lebokose la lebokose.
- Kenya mokhoa o latelang ka lebokose le ka tlaase ho maemo a Mofuta oo ho oona boleng ba 'nete e leng kgetho e ka tlaase halofo ea lebokoseng la lebokose la bobeli :
= KAJENO () - C1> 60Letomane lena le hlahloba ho bona hore na matsatsi a liseleng tsa C1 ho C4 a feta matsatsi a 60 a fetileng.
- Tobetsa tokomane ea Fomati ho bula lebokose la bobeli la boitsebiso.
- Tobetsa Tlatsa tab ho bona mebala ea mebala e tlala.
- Khetha 'mala o tletseng mokokotlo; ho lumellana le mohlala thutong ena, khetha mosehla.
- Tobetsa OK ka makhetlo a mabeli ho koala lebokose la lebokose le ho khutlela Molaong oa Melao-motheo ea Molaetsa oa dialog box.
04 ea 06
Ho eketsa Molao bakeng sa Matsatsi Matsatsi a fetang 90 a fetileng
- Pheta mehato ea 5 ho ea ho 7 holimo ho eketsa molao o mocha.
- Bakeng sa tšebeliso ea lebese:
= KAJENO () - C1> 90 - Khetha 'mala o tletseng mokokotlo; ho bapisa mohlala ho thuto ena, khetha orange.
- Beha mobala oa melaetsa ho tšoeu ho tšoantša thuto ena.
- Tobetsa OK ka makhetlo a mabeli ho koala lebokose la lebokose le ho khutlela Molaong oa Melao-motheo ea Molaetsa oa dialog box
- Tobetsa OK hape ho koala lebokose la lebokose le ho khutlela mosebetsing .
- Mobala o ka morao oa lisele tsa C1 ho C4 o tla fetela ho 'mala oa ho qetela o tlatsitsoeng.
05 ea 06
Ho hlahloba Melao ea ho Etsa Melao ea Boipheliso
Joalokaha ho ka bonoa setšoantšong sa tutorial, re ka hlahloba melao e felletseng ea ho etsa litšebelisong tsa lisele tsa C1 ho ea ho C4 ka ho kenya matsatsi a latelang:
- Nako ea morao-sele e lokela ho fetoloa ho ea ka mokhoa o mosoeu o fokolang ka mongolo o motšo, kaha ha ho melao ea mekhoa e nepahetseng e sebetsang.
- Matsatsi a 40 pele letsatsi la hona joale-sele e lokela ho fetoha ho ea ka botala bo botala bo nang le litemana tse tšoeu.
(Tlhokomeliso: Haeba u na le bothata ba ho bala letsatsi le joalo, joalokaha ho bonoa setšoantšong se ka holimo, foromo = TODAY () - 40 e tla kenya letsatsi matsatsi a 40 pele ho letsatsi la hona joale.) - Matsatsi a 70 pele ho letsatsi la hona joale-sele e lokela ho fetoha ho ea mosehla le litlhaku tse tšoeu.
- Matsatsi a 100 pele ho letsatsi la hona joale-sele e lokela ho fetela ho setso se khubelu se nang le mongolo o mosoeu.
06 ea 06
Melao e meng ea melaetsa ea mefuta e meng
Haeba leqephe la hau la mosebetsi le se le ntse le bonts'a letsatsi la hona joale-'me boholo ba lipampiri bo etsa-mokhoa o mong oa ba ka holimo o ka sebelisa selefouno ea seleng moo letsatsi la hona joale le bontsitsoeng ho e-na le ho sebelisa mosebetsi oa TODAY.
Ka mohlala, haeba letsatsi le hlahisoa ka seleng ea B4, mokhoa ona o kene ka molao e le hore ho behoe matsatsi a fetang matsatsi a 30 a fetileng hobane e ka ba:
= $ B $ 4> 30
Lipontšo tsa dollar ($) tse potolohileng selefouno ea cell B4 li thibela hore reference ea sele e se ke ea fetoha haeba molao oa tsamaiso o nepahetseng o kopitsoa lisele tse ling lefapheng la mosebetsi.
Lipontšo tsa dollar li bopa se tsejoang e le sefahleho se feletseng sa sele .
Haeba lipontšo tsa dollar li sa lumelloe 'me molao oa boipelaetso o lumellane o kopitsoe, sele kapa sebaka seo ho eang ho sona se ka' na sa bontša #REF! molaetsa oa phoso.