Tataiso ea moqapi ho Microsoft Excel
U hloka ho ithuta ho sebelisa Microsoft Excel, spreadsheet e tummeng ka ho fetisisa lefatšeng ka lilemo? Leha ho le joalo, e ka ba ntho e tšosang ha u qala ho kenya lenaneo. Tsela ea ho sebelisa Excel ke li-tutorials tse entsoeng ka moqapi ea hlollang ka kelellong. Litaelo tsena li kenyelletsa mehlala ea mehato ea mehato ea kamoo u ka sebelisang Excel ho etsa sesepa sa motheo; khetha tutorial ho qala!
Excel Screen Elements
Sehlooho sena sa Excel Screen Elements se khetholla likarolo tse ka sehloohong tsa leqephe la lipampiri tsa Excel, tse lebisang tlhokomelo ho:
- Sele e sebetsang le e sebetsang
- Kenya letšoao la lakane
- Mangolo a mebala
- Linomoro tsa mela
- Sebaka sa boemo
- Sebaka sa foromo
- Lebokose la lebitso
- Libaka tsa li-Ribbon le Ribbon
- Tlanya tab
Basic Excel Spreadsheet
Thuto ea Basic Excel Spreadsheet e akaretsa lits'ebeletso tsa ho theha le ho etsa moralo oa spreadsheet ea motheo liphetolelong tsa morao-rao tsa Excel. Litaba tse koahetsoeng li kenyelletsa
- Ho kenya data
- Ho theha liforomo tse bonolo
- Ho hlalosetsa sebaka se bitsoang lebitso
- Ho kopitsa liforomo le sephethephethe
- Ho sebedisa palo le lisebelisoa tsa sele ho ea leqepheng la mosebetsi
- E eketsa ho kenya mohala oa sele
Excel Math
Ithute ho eketsa, ho ntša, ho atisa le ho arola linomoro thutong ena ea Excel Math . Thupelo e boetse e akaretsa ho fetola taelo ea ts'ebetso ka litlhaloso, li-exponents le mesebetsi ea lipalo ea Excel.
Sehlooho se seng le se seng se kenyelletsa mohlala oa mehato le mohato oa hore na o ka etsa joang ho etsa moralo o mong kapa o mong oa lipalo tse 'nè tsa motheo tsa Excel.
Ho eketsa Numere ka Mosebetsi oa SUM
Methati e 'ngoe le e' ngoe litaelo tsa hore na u ka sebelisa mosebetsi oa SUM oa Excel joang . Kaha ho eketsa mela le lipalo tsa melaetsa ke e 'ngoe ea mesebetsi e tloaelehileng ka ho fetisisa Excel, Microsoft e kenyelitse leqhoa lena la mekhoa ho etsa hore mosebetsi o be bonolo. Thupelo e akaretsa:
- SUM mosebetsi oa syntax le litsekisano
- Ho kenya mosebetsi oa SUM
- AutoSUM
- SUM function function dialog box
Tsoela kapa Kopitsa Data
Thutong ena, ithute ho sebelisa linotlolo tsa mekhoa e khutšoanyane ho khaola, ho kopitsa le ho kenya data ho Excel . Tlisa data sebakeng se secha kapa u se kopise ka litsela tse 'maloa. Thupelo e akaretsa:
- Litsela tsa ho kopitsa dintlha
- Lebokose la lipatlisiso le data ea pasting
- Ho sebelisa lits'ebetsane tsa mekhoa ho kopitsa le ho pata
- Ho sebelisa menyetla ea moelelo ho kopitsa dintlha
- U sebelisa mefuta ea dikgetho tabeng ea Lehae ho kopitsa dintlha
- Ho tsamaisa data le lihlooho tsa mekhabiso
- Ho tsamaisa data le menu ea moelelo le ho sebelisa temo ea Lehae
Kenya / Tlosa Liqhobo le Lirola
U hloka ho fetola mokhoa oa data oa hau? Ho e-na le hore feela u tsamaise data, ke hobane'ng ha u sa eketsa, kapa u tlose melamu le mela e le hore u atolose kapa u senye sebaka sa mosebetsi ha ho hlokahala? Ithute mekhoa e metle ea ho eketsa kapa ho tlosa litšiea tse sa tšoaneng kapa tse ngata le mela e sebelisa mekhoa ea sefapano kapa menu ea moelelo.
Pata / Khotsofatsa Li-columns le Litala
O ka pata mela le mela e nang le data ka spreadsheet. Ho etsa joalo ho ka etsa hore ho be bonolo ho tsepamisa maikutlo lintlheng tse ling, tsa bohlokoa tsa leqephe le ho bonolo ho li khutlisetsa ha u hloka ho bona data e patiloeng hape.
Ho kena Letsatsi
Ithute kamoo u ka sebelisang khetho ea keyboard kateng ho potlakela ho kenya letsatsi le nako ea hona joale ho Excel spreadsheet. Haeba u ka rata ho ba le tsamaiso ea letsatsi ho letsatsi la hona joale nako le nako ha leqephe la mosebetsi le buloa, sebelisa mosebetsi oa TODAY ho e -na le hoo.
Ho kenya Ditaba ho Excel
U se ke ua lahleheloa ke litlhahiso tse supileng ka mekhoa e metle ea ho kenyelletsa lintlha kahare ho lipampiri tse akarelletsang:
- Ho rera leqephe la mosebetsi
- Ho beha data
- Ho kenya lihlooho le li-data
- Ho sireletsa liforomo tsa lipampiri
- Ho sebelisa litšupiso tsa sele ka litlhaloso
- Hlophisa lintlha tsa hau
Chate ea Column
E boetse e tsejoa e le bar grafu, lichate tsa likarolo li sebelisoa ho bontša papiso pakeng tsa lintlha tsa data. Mongolo o mong le o mong ka chate o emela phapang e fapaneng ea data ho tloha leqepheng la mosebetsi. Ithute ho li sebelisa ka katleho thutong ena.
Mohala oa Sehlopha
Li-graph tsa line kapa li-chart li sebelisoa ho bontša mekhoa ka nako. Mongolo ka mong ho graph o bontša liphetoho tsa bohlokoa ba boleng bo le bong ba data ho tloha leqepheng la mosebetsi.
Chate ea Pie
Litepesi tsa pie li sebelisetsoa ho bontša liphesente. Sehlopha se le seng sa data se na le morero 'me karolo e' ngoe le e 'ngoe ea pie e emela boleng bo le bong ba data ho tloha leqepheng la mosebetsi.