Malebela le maqheka a 5 a kaholimo ho Microsoft Excel ho Office 365
Hore na o sebetsa ho accounting, o tlatsa li-invoice, kapa o sebetsa feela lipalo tse ling ka mokhoa o sa reroang, Microsoft Excel ke lenaneo le molemo haholo bakeng sa likhoebo le bareki ka ho tšoana. Leha ho le joalo, ho fapana le mananeo a mang a Office 365, Excel e tsepamisitse maikutlo haholo ho data, e ka tšosang ba bang. Se tšoenyehe, hobane joale re u fa tse ling tsa malebela le maqheka ao re a ratang ka Excel bakeng sa Office 365. Malebela le maqheka ana a ke ke a u bolokela nako feela empa a ka boela a nolofatsa lintho le ho u thusa ho u etsa setsebi sa Excel.
Sebelisa likhutšoane tse ling
Joalo ka mananeo a mang a Office 365, ho na le likhutšoane tse 'maloa tsa keyboard tse ka sebelisoang ho Excel.
Ha o sebetsana le linomoro le li-spreadsheet tse ka bang likholomo le mela e sa feleng, likhutšoane tsena li ka qetella li u bolokela nako le hlooho.
Re bokelletse tse ling tsa tseo re li ratang .
- CTRL + Kenya: ho pheta mongolo. Tobetsa sehlopheng sohle sa lisele ebe u thaepa seo u batlang ho se pheta seleng ea ho qetela, ebe u tobetsa Ctrl + Enter. Seo u se ngotseng se ea seleng e 'ngoe le e 'ngoe.
- Alt + F1: Sebelisa sekhechana sena ho etsa lichate leqepheng le tšoanang le la data ea hau. Ka mokhoa o ts'oanang, ho tobetsa F11 Ho etsa chate leqepheng le arohaneng
- Shift + F3 Sebedisa kgaoletso ena ho kenya tshebetso
- Alt + H + D + C: Sebelisa sekhechana sena ho hlakola kholomo
- Alt + H + B: Sebelisa sekhechana sena ho kenya moeli ho sele
- Ctrl + Shift + $: Sebelisa mokhoa ona oa ho khaoletsa ho sebelisa mokhoa oa chelete
- Ctrl + Shift + %: Sebelisa mokhoa ona oa ho khaoletsa ho sebelisa mokhoa oa liphesente
- Ctrl + Shift + &: Sebelisa tsela e khaoletsang ena ho sebelisa meeli ea kemiso
- F5: Sebelisa sekhechana sena ho ea seleng. Tlanya feela F5 ebe u fomata sele kapa lebitso la sele
Leka mesebetsi ea IFS Boolean ho felisa tlhoko ea liforomo tse behiloeng
IFS ke mosebetsi oa lehae o tsejoang e le "Haeba, sena, joale, le sane". Sena se sebelisoa ke bahlahlobisisi lefatšeng ka bophara, 'me se ka lekola maemo a mangata ho Excel e le hore u se ke ua sebelisa liforomo tse behiloeng.
Sebopeho se ka sebelisoa ka ho kenya =IFS bareng ea foromo, ho latela lipehelo. Ebe IFS e hlahloba ho bona hore na maemo a fihletsoe 'me e tla khutlisetsa boleng bo lumellanang le boemo ba TRUE. Mohlala oa IFS o bontšitsoe ka tlase.
Setšoantšong se latelang, re sebelisa foromo ho theha lintlha ka har'a spreadsheet.
Sebelisa boemo ba boemo ho hlahloba boemo ba data
Ha ho motho ea ratang ho etsa lipalo ka potlako, empa Excel e khona ho u etsetsa data kapele. Haeba u na le leqephe la linomoro, kapa linomoro, boemo ba boemo bo ka sebetsana le linomoro tsa hau habonolo ntle le ho ngola foromo. Sena se kenyelletsa scalar, scalar, min, max, kakaretso. U hloka feela ho totobatsa data ho qala. Maemong a sa tloaelehang, ho ka 'na ha hlokahala hore u e lumelle pele. Haeba ho joalo, tobetsa ka ho le letona bareng ea boemo, 'me u tobetse ho lumella likhetho tsa lipalo-palo tseo u batlang ho li bona.
Leka mekoallo ea data ho bona data ea hau ka pono
Lintlha tse kholo li na le thuso, empa ha ho letho le bonahalang ho feta infographics. Ka karolo ea "Data Bars" ho Excel, o ka eketsa mekoallo litafoleng tsa hau tse teng ntle le ho eketsa graph. U ka etsa sena ka ho khetha data le lisele tseo u batlang ho li graph, ebe u ea Leqephe la lapeng Home, ebe o khetha Conditional Formatting , khetha Libaka tsa Boitsebiso. Joale u ka khetha ho tsoa ho gradient kapa ho tlatsa mebala.
Kopa thuso ho Excel
Haeba u iphumana u lahlehetsoe ke Excel, lenaneo ka boeona le ka thusa. Tobetsa feela lebokoseng le ka holimo moo le reng batla 'Me u tla khona ho batla mosebetsi oo u batlang ho o etsa Excel.
Joale lebokose la ho batla le tla u fa khetho. Ntle le moo, o ka ngola kamehla " Thusa" Bareng ena ea ho batla ho letsetsa le ho fumana lethathamo la lihlooho le mesebetsi e tsebahalang ea Excel. Tse ling tsa lihlooho tse tloaelehileng tse thathamisitsoeng mona ke kamoo mela, mesebetsi, lisele, liforomo, ho fometa, litafole, joalo-joalo.
Na u tla khona ho fumana boemo bo holimo ho Excel?
Ho na le lintho tse ngata tseo u ka li etsang ka Microsoft Excel, 'me ho thata ho e koahela ka poso e le' ngoe feela. Malebela le maqheka a rona a ama feela lintho tsa motheo, empa ho na le tse ling tse ngata tseo re ka li sibollang. Re bolelle maikutlong a ka tlase malebela le maqheka a hau bakeng sa Excel le Office 365.
Mokhoa oa ho lokisa likhoutu tsa phoso tsa Microsoft Excel
