EXCEL
Cac thao tac co ban vs EXCEL
1) File -> More -> Options -> Quick Access Toolbour -> Open ->Add >> -> OK
2) -> Bun -> Boi den A2:A15 -> giu Control sang C2:C15
3) An chuot trai vao Column D-> Chuot phai -> Insert (Truoc cai j boi den cai day)
4) Boi den B7 ->G7:Mg12->An chuot phai-> Cut -> An chuot phai B6-> Insert Cut Cells
5) Boi den G11:G12-> An chuot phai->Delete->Shift cells up
TAB FILE
1)File-> Info ->Show all properties ->Status-> Need to review
2)File-> Info-> Inspect Workbook->Inspect-> Document … Information->Remove All->Close
3)File-> Info-> Inspect Workbook->Check Compability->Copy to new sheet
4)File-> Info-> Inspect Workbook->Check Accessbility-> Missing Alt Text -> Chart 2(Besam)
-> Add a de -> Nhap j cung duoc ->
TAB HOME
1)Boi den dong 1,2 ->Home-> ->Cookies -> Bam cai choi
2) Boi den B4->G9 ->An chuot phai->Copy
3)Boi den-> ->Horizontal-> left(Indent) -
>Indent(1)
4)Boi den G1,I2-> chon Orientation->Chon Angel…wise
5)
6) Boi den M2:P2->
7) Boi den dong Cost xong an giu Control->Boi den Price,Margin-> ->
Number->Currency->Demical places -> 2->Symbol->Euro
8) Boi den Total Profit->Nhom Styles-> Conditional Formating->Highlight Cells Rudes->
Greater Than ->800 with Green Fill…Text
9) Boi den B3:E3 ->Conditional Formating-> Icon Sets -> 3 la co
10) Boi den Sales-> Conditional Formating->Clear Rules-> Clear Rule From Selected Cells
11) Boi den A1:E1->Cell Styles->Accent 6
12) Boi den dong 20->Format (Cells) ->Row Height->Go 65->Boi den ca cot B->G (Boi B,G) -
>Format ->Column with ->go 12
13) Boi den I2:J20 ->Editing ->Clear(Editing) ->Clear Format or Clear Content
14) De chuot bat ki o dau -> Nhom(Editing)->Find…->Replace -> Find
what:Choco,Replace:Chocolate ->Option>> ->Within ->Workbook-> Replace All
POWERPOINT
TAB HOME
1)Nhan chuot O Tren section 1 sau do an chuot phai
add section sau do doi ten thanh Introduction,may cai khac cung tuong tu nhu vay
2)Y chang cau 1
3) roi an vo roi an vo Slides from outline
4)Y nhu cau 3 den doan new slide nhung an vo Reuse Slides ko thay file thi tu dong an Browse
roi chon Harmony roi chon va nho bo tich
5)An vo slide 8 va an chuot phai ,chon Duplicate Side va an va di chuyen trai slide 9 xuong
Life Areas
6)An giu Ctrl sau do an tu 8 toi 10 ,an chuot phai chonj delete slide
7)An vo o hinh vuong sau do chon vao vao change shape sau
do di chuyen vao hinh bat ki sao cho ra ten
8)An vao slide so 7 sau do chon sau do chon Two content
9)Boi den danh sach liet ke roi chon theo de bai
10) Boi den danh sach liet ke chon dong cuoi roi chon Picture vao from a file chon
Logo..
11) boi den Sound sau do an giu ctrl roi boi boi den Sight roi chon chon Dark Red ,
roi boi den 2 chu do chon
12) boi den vao Text k phai Title sau do chon va chon more..
13) Boi den het danh sach va chon Basic Process
TAB DESIGN
1)
Roi chon vao Slice
2)vao slide 5 an roi chon luot xuong an vao day
chon Water..
3) Vao slide 4 chon chon roi chon
4) vao dong cuoi chon
vao Ensure Fit
TAB FILE
1)File -> Info-> ->
2) -) dong dau tien-> Yes -> -
> Remove All
3) File -> Print-> ->
an vo High Quality
4)
5)
6)Save as-> Browse->
7)Nhu cau 6
8)File-> Export->
Chon blank …
9)File-> Infor-> chon Ecrypt
