Creating your Spreadsheet with MS Excel 2007 is just quite simple. Whether you are already a power user or just a beginner starting using of Excel spreadsheet for your office task, you can find out what you need in hundreds of practical examples, popular techniques, and friendly tips in this comprehensive resource. You could master the new Office's Ribbon user interface, the smart way to create formulas. You could also know how to make the enhancement of your worksheet with graphic charts and smart art tools, how to summarize and consolidate your data with specific commands, how to analyze your data using pivot tables, or how to seek a properly best answer for problems using analysis solver . . . and much more. If you want to really understand what and how an Excel spreadsheet can serve you, this book is the right place for you to practice.

Easy MS Excel 2007

By Thong Ong

AuthorHouse

Copyright © 2009 Thong Ong
All right reserved.
ISBN: 978-1-4389-9224-2

Chapter One

Computer for EveryBody TIN HOC CHO MOI NGU''I

Gi'i thieu:

VE MICROSOFT EXCEL 2007

Thu'a cc ban,

Microsoft Excel l phan mem chuyn dng cho bang tnh dien tu' (Worksheet). Ban cung dong y rang d l mot phan mem hau nhu' khng th' thieu tai van phng lm viec cua mnh. T' phin ban thuo' so' khai l Excel 4.0, hng Microsoft d lin tuc nng cap thnh cc phin ban Excel 5.0, Excel 7.0, Excel 97, Excel 2000, Excel XP, v gan dy Excel 2003. Tat ca cc phin ban nay deu c mot giao dien hao hao giong nhau, nn ngu'i su' dung de dng tiep thu phin ban m'i du'a trn kinh nghiem phin ban tru''c.

The nhu'ng v'i phin ban Microsoft Office Excel 2007 (Excel Version 12), bang mot giao dien rat la lam, c the gy nh'c dau cho ngu'oi da t'ng su' dung Excel ! Chnh ban thn chng ti cung ho ang hon v ngan ngo' khi tiep can lan dau v'i Excel 2007, do vay chng ti thay can phai viet lai tap gio trnh nay, nhu' mot cch gip ban doc nhanh chng lm chu du'o'c Excel, neu my cua ban da ci bo Microsoft Office 2007.

Tru''ng hop ban dang ci bo Office XP hoac Office 2003, chng ti khuyn ban c' de vay m dng, v cc bo Office nay, theo chng ti, l rat thn thien v hau nhu' da dat den dinh cua su' hoan hao.

1. BO CHU'O'NG TRNH EXCEL 2007 :

De dng du'o'c Microsoft Excel 2007, ban phai c mot my vi tnh v'i cau hnh tu'o'ng doi manh, v'i he giao dien Windows XP hoac Windows Vista, c ci dat Microsoft Excel 2007 (trong bo Office 2007) dng cch. Ngu''i su' dung di nhin da quen thao tc trn giao dien Windows. Neu c nhu cau hien thi van ban tieng Viet, can ci dat thm bo go de go tieng Viet, v du phan mem VietKey.

2. KHO'I DONG EXCEL 2007 :

(1) Mo my, he Windows (cc Version Windows XP hoac Vista) du'o'c nap.

(2) Kch hoat Excel bang cch:

Thng thuong, ban goi Excel qua con duo'ng chnh ngach bang cach nhan Start, chon All Programs, chon Microsoft Office, roi chon Excel 2007 theo hnh du''i tri.

Neu Excel v'a du'oc su' dung tru''c d, th khi goi Start, trong Start Menu thu''ng c san bieu tu'o'ng Excel trong do nhu' hinh trn phai, ban nhap vo de kch hoat.

* Viec Excel nam trong nhnh no cua Start Menu th phai ty vo thu'c te cua he Windows trn my m ban dang dng.

Hoac neu da c tao mot Shortcut cho Excel 2007 trn mn hnh Desktop nhu' hnh sau thi bn nhap dup vo bieu tu'o'ng nay hoac nhap chon n roi Enter.

* Ve cch lm the no de tao Shortcut trn Desktop cho mot 'ng dung, xin xem cc ti lieu Giao dien do hoa Windows.

* Neu ban chu'a tien xem cc ti lieu Windows, hay nhan nt Start, chon All Programs, chon Microsoft Office, r den Microsoft Excel, roi nhan nt phai chuot (right click) de goi Menu di dong, trong d chon Send To -> Desktop nhu' hnh sau.

3. MN HNH EXCEL 2007 KHI V'A KHO'I DONG :

Sau khi du'o'c nap, mn hnh Excel 2007 c dng dap gan nhu' trn, l cua bo Excel 2007, du''i mi tru''ng Windows Vista, du'o'c dng de soan sch nay, thu'c te c the khc di cht, nhu'ng khng anh hu'o'ng nhieu den viec lap v xu' ly bang tnh cua ban.

Bang tnh Excel du'o'c to ch'c nhu' mot quyen tap (workbook) gom nhieu trang (goi l worksheet), ngam dinh c 3 sheets (c the thm b't). Moi Sheet gom nhieu hang (Row) dnh so 1, 2, 3 ..., moi hng c nhieu cot (Column) ky hieu A, B, C ... Khu vu'c giao nhau giu'a hng v cot to thnh mot goi l Cell. Trong Cell c the ch'a tri so, van ban, hoac tri cng th'c.

V'i mn hnh trn dy:

1. Dng trn cng goi l Title Bar (thanh tiu d) d d c tn ti liu (Book1) v tn ca 'ng dung (Microsoft Excel), bn tri c bieu tu'o'ng Office Button hnh trn, m khi nhap chuot vo d se by ra Menu (hnh sau) v'i cc linh nhu' New, Open, Save, Save As, Print ... den Close, neu nhap vo nt Exit Excel, ban dng cc bang tnh dang xu' ly dong th'i ket thc Excel.

2. Bn tri Title bar l thanh Quick access toolbar, ch'a cc cng cu thu''ng su' dung nhu' Save, Undo ... Ban c the gan thm hoac bo bt cc bieu tu'o'ng ty thch. Bn phai Title bar l cc nt Minimize (thu nh), Maximize (phng l'n) v Close (dng).

3. Dng th' hai l mot Ribbon (dai ru bang) gom nhieu Tab (t' Home den View), Ribbon du'o'c thiet ke nham gip ngu''i su' dung nhanh chng tm cc linh can thiet de hon thnh cng viec. Trong moi Tab, cc linh du'o'c ket thnh t'ng nhm goi l cc Group. V du trong Tab Home c cc Group Clipboard, Font v.v ... Ribbon c tnh thun gian cnh cup cnh xo, khi cu'a so Excel no' rong th cc Group by ra du cc linh con, neu thu hep cu'a so th cc Group co cum lai, nhap vo m'i xo ra.

De do roi mat, mot so Tab c th du'o'c Excel giau b't di, chi by ra trong tnh huong thch ho'p. V du Tab Format ca Picture Tools hoac Tab Format cua Drawing Tools chi xuat hien khi doi tu'o'ng lin he l Picture hay AutoShape dang du'o'c chon.

Neu ban chon mot Ribbon Tab bat ky (v du Tab Home) roi nhan nt phai chuot de mo Menu di dong, xong chon Minimize the Ribbon th phan Ribbon du'o'c thu gon lai chi cn tn cc Tab m thi, cc Group deu bi che nhu'o'ng cho cho bang tnh.

Khi dng Ribbon dang du'o'c thu gon, ban thao tc tu'o'ng tu' se bung ra nhu' cu.

Thao tc nhap dp vo mot Tab bat ky cua Ribbon (hoac bam Ctrl-F1) cung thu gon Ribbon neu dang hien cc Group, v ngu'o'c lai, by ra cc Group neu dang thu gon. Viec thu gon dai Ribbon khng anh hu'o'ng den viec xu' ly bang tnh, v'i Ribbon dang thu gon, ban c the nhap vo mot Tab no d, cc Group trong Tab s hien ra, ban su' dung ty y, sau d Ribbon tu' dong thu lai. Khng thay cch no de xa bo hoac thay Ribbon bang cc Menu v Toolbar nhu' trong Excel cua cc phin ban tru'o'c.

Ghi ch : Ribbon du'o'c to ch'c theo he thong gom 3 cap :

1. Tabs: Cc go Tab giang ngang pha trn. Moi Tab ch'a bieu tu'o'ng cc linh lin quan den mot linh vu'c thao tc.

2. Groups: Trong Tab c nhieu Group (nhm), mot Group tap ho'p cc cng viec lin he v'i nhau. Trong Group c nhieu Commands (linh), v du Group Font cua Tab Home ch'a bieu tu'o'ng dng vo muc dch trnh by nhu' dng khung, chon Font chu', co' chu', mu chu', dng chu' ... Tu'o'ng tu', Group Alignment th gom cc bieu tu'o'ng canh bin, ch'a le v.v.... Neu gc du'o'i phai cua mot Group co bieu tu'o'ng Dialog Box Launcher [??] th khi nhap ch uot vo d se mo hop thoai tu'o'ng 'ng, v du hop thoai Format Cells - Font de dinh dang Font chu, hop thoai Format Cell - Alignment de dinh dang doan v.v....

3. Commands: Mot Command c the du'o'c bieu hien du'o'i dang mot nt (button), neu c thm nt [down arrow] bn canh th dng mo' hop thoai de chon, hoac mo menu tiep theo.

Khi nhap bieu tu'o'ng Office Button (hnh trn), Excel se by ra Menu v'i cc linh t' New den Close nhu' trn.

Nt Excel Options dng quy dinh cc ty chon khi su' dung Excel v cch thao tc khi nhap so lieu. Excel 2007 thu'o'ng dinh san kh nhieu ch'c nang dieu chinh tu' dong, tuy kh thng minh nhu'ng di khi lm ban bu'c mnh v qu lm linh. Nt Excel Options se gip ban chi dinh cc ty chon theo y mnh.

Nt Exit Excel th dng cc bang tnh hien hnh dong th'i ket thc Excel.

4. Thanh doc bn phai khu vu'c bang tnh goi la Vertical Scroll bar (thanh tru'o't doc) dng de tru'o't ln hoac xuong theo chieu doc bang cch nhap vo mui tn ln hay mui tn xuong cua thanh nay, hoac r khoi vung trong thanh tru'o't. Thanh ngang pha du''i khu vu'c bang tnh l Horizontal Scroll bar (thanh tru'o't ngang) dng tru'o't qua hay lai theo chieu ngang.

5. Bn tri gan thanh tru'o't...