Wiley Master VISUALLY Excel 2007
Contents
1. Poe Sass at Hiat PTR Page Leak Pe ee Pala Heals vo ara eja vja a E mm m F eeni 44 Pet oy P e ee ee eDpomand la Tick la hintaan Krakar D ii He guston z erleg i F F F Date Amon oacellype Opencdly Uranch Customer 2 1AGGDOF 2365 Ilene Disc Faea Piosik Es sti ty a Tadeo 2355 Intemet Susloce Beie Phony Zatim ZAIT 23 E5 hlamit Tulonie Sowie Phorm Maw g IAAF 2105 hema Suslo a Sania Phen a TAU TAS renct Turlove soe ere HRN T AE AAR bleed fast at Fani Caen THW JO TANAN ayi iemet Yone ewet Wiway msi q IELE i o 5G hieme Tite Za Fac Waley Saisin J paLa zda ilemet kuslore cence Cra valy 21A 4 iaar 2365 hiem i Ciclo e Benice Eisi aliy tana 2 TANA ES E5 Internet tusara Iewe Phony Zatim 3 22a EES hieme Tuslove Bevke Phorm Insig INUA 25 hena Lusione Beavica Pbnen Zisti sae SA 8 ieme Curlove ence Phocns Snsd AE 2785 hiamh Suelo at Faecal sini On MH mce sce rrah ore Horat feat Page Lata re fata Aeaa io i fa aval eja e a E mn geen SE sever z F Pee g B E H a aA elprasi la Fact la dh nwe nt Kuraher gt Ee JG Ezt lle i 4 Cc T E E 1 Dak moum Acelype Cpenediy Branch Cosomer al Tenor EES hiami Ibin Sac Phot Znaim 3 INUA 515G hlama Lusine Savia Phen Sistim EO ANAN APD iemet Vuzo ve dewe Phen vew x AE AAR bleed Suelo at Fani Pinen Fsindimy u TUL Tayi menet Yuzoni Giwer Lra valy E iaar 2985 hiem Sushi e Berie Phoen Twi 3 TANA 2355 Ilene Suslove F2. projections as you want in the worksheet by increasing and decreasing the numbers used in the chart as you change the numbers in the worksheet Excel instantly updates the chart Excel s charts let you simultaneously view the sales trends in a picture representation on screen and the numbers in the worksheet making your sales forecasting more efficient B u l G Month Sales Figures for 2007 Qn Then h Jeccarr Fetroarp bisrh Aprl Diy f q maer FF 135 1 133 5 janua 143 TES 173 LEE E iarr 1F5 183 a 19 E ee G y 3 Taag hh Haan 6 Months Sales for 2007 E F E E f f og a y ul Lomi eg a ad Dd cd td ad ad i kaala c baad D e BA a wil Sheet l shack aet Start and Close Excel ou can start the Excel program using the Windows Start menu When you open the Start menu a search field appears at the bottom and the All Programs choice appears immediately above the search field Once you select All Programs Windows displays folders that contain the programs installed on your computer The shortcut to start Excel appears in the Microsoft Office folder After you select Excel from the Microsoft Office folder several times it will appear on the Start menu in the list of recently opened files You can select Microsoft an ISTE Start Excel a Click Start The Start menu appears Click All Programs All Programs changes to Back Click Microsoft Office The list of installed Micro
3. workbook named Book that contains three worksheets Title Bar Displays the name of the workbook and the name of the program Office Button Opens a menu containing commands related to file operations such as Save By default contains buttons that enable you to save undo your last action and redo you last action You can also add and Print buttons to this toolbar see Chapter 30 for details Q J Ca O Ecol Pelicroncet Exce O a Harms Tuet Face L mgyk Pandas Dara Seedei Hew w Fr D F f z a F Reade Fa Scroll Bars Enable you to view more rows and columns of the worksheet IE Ea IF Status Bar Displays Excel s current mode such as Ready or Edit and identifies any special keys you press such as CAPS LOCK The Status Bar also contains View buttons that you can use to switch views and a Zoom control to help you zoom in or zoom out See Chapter 8 for more information on views and zooming Quick Access Toolbar r Ribbon Contains most Excel commands organized on tabs See the section Understanding the Ribbon for details Formula Bar Made up of three parts the Formula Bar contains the Name box buttons that pertain to entering data and the contents of the currently selected cell Worksheet Area The place where you enter information into Excel divided into rows and columns Worksheet Tabs Tabs that identify the worksheet
4. you find seven groups Clipboard Font Alignment Number Styles Cells and Editing In the lower left corner of some groups you see a dialog box launcher icon E that you can click to see additional options that you can set for the group rE I e wz ale cm i i af a By default the Ribbon contains seven tabs as vs ee a abet E described in the following table Tabs on the Ribbon Tab Purpose Home This tab helps you format and edit a worksheet Insert This tab helps you add elements such as tables charts Pivotlables hyperlinks headers and footers Page Layout orientation and page breaks This tab helps you set up a worksheet for printing by setting elements such as margins page size and This tab helps you import and query data outline a worksheet sort and filter information validate and This tab helps you proof a worksheet for spelling errors and also contains other proofing tools From this tab you can add comments to a worksheet protect and share a workbook and track changes that others Formulas This tab helps you add formulas and functions to a worksheet Data consolidate data and perform Whatlf analysis Review make to the workbook View This tab helps you view your worksheet in a variety of ways You can show or hide worksheet elements such as gridlines column letters and row numbers You can also zoom in or out In addition to these seven tabs Excel displays contextual tabs which are tabs
5. Getting Started with Excel Ds fal W I Gookl wicrorot Excel Font Ts Hignment Number Excel reverses the effect of undoing 3 am aa Pape Lawouk Sormulay Cata Review aus ee by adding back your last action In 2 lt es this example Excel reapplies italics me Bea A SMa a sw gt ee Clipboard Font a Sbgnment Ts Himber Can I redo more than one action at a time w Yes The Redo feature Can undo more than one action at a time w Yes Click F beside to Why is the Redo button unavailable when the Undo button is available display the list of actions you can undo Click the oldest action you want to undo and Excel undoes all of the actions from the oldest one you select to the latest showing you the worksheet at the point in time before you took any of those actions works the same way as the Undo feature To be able to redo more than one action at a time you must undo multiple actions before you redo Then click beside to display a list of actions you can redo Click the oldest action and Excel redoes all of the actions from the oldest to the latest wW Excel keeps track of all actions you take in all open workbooks and makes those actions available to undo until you close Excel The button will not be available unless there are actions to redo and actions to redo do not become available until you undo an action If you then cli
6. Pri Open a workbook a ss m y ie ae a SE aaa tees emer Lot ti wa jag H Ji a MIH PM lek Boas dl err a Excel displays the first worksheet in the workbook or the last sheet you viewed before saving the workbook 2 Click a worksheet tab Excel displays that worksheet a ice Eau a e w ele aari z 4 ar ma y ie Sea Sl P a tere ee To display additional worksheet tabs you LE RET ENE can click these controls TEEEEFIE i 5 i al Hy g a lil EJ ba A 7 astika Manage the Status Bar ou can add elements to or remove elements from the Status Bar to display many different types of information When you open a blank workbook the Status Bar displays the cell mode the macro recording state the View shortcuts the zoom factor and the zoom slider The Status Bar is actually set to display a wide variety of information if conditions are right to display the information For example if you press the Scroll Lock key on the keyboard Excel displays the state of the Scroll Lock key on the Status Bar SERRE ap Right click the Status Bar Excel displays the Customize Status Bar menu Each item with a check mark D beside it will appear on the Status Bar under appropriate conditions 2 Click an item that does not contain v e Excel can now include that item on the Status Bar If appropriate conditions exist the item appears immediately on the S
7. Susbomer Semice East Walley Existing 4 TVAAD 52 95 Ty Customer Serice Wrest Yale Existing 25 TAAI 53 9 Ty Customer Eerine Pheer Havs jah TARAI ao Ts Custamer Sevina Pheer Cuistirey LaF Taine S19 Ts Custimer Sevina Fast allay Fuistrey A TANAJ 53 Ts Diet Sales East allay Exishny ee eee 53 56 Ty Customer Seriza Phoen Exiahry a0 TAA 3 55 Ty Tuatomer Seriza Phoen Hew iei qaal S389 lv SUShOWer tarita Wes alay Esiabry Fj 124 IL 5 06 Ty Susloner Leica Cash Walley Exishhy hod H Destennbeer 9 2 Press F5 me The Go To dialog box appears O Type a cell address Click OK Excel moves the cell pointer to the address you typed What happens if I click the Where does Excel place Special button in the Go the cell pointer when To dialog box move a screen at a time w Excel displays the Go To Ww The cell pointer remains in What happens when I press the Page Down key Ww Excel displays the next page of rows For example Special dialog box where you Can set special conditions for Excel to use to go to a particular cell For example if you select the Comments option Excel selects all cells that contain comments If you select the Formulas option Excel selects all cells that contain formulas the same relative position on the screen when you press the Page Up or Page Down keys For example if D10 is the active cell while viewing rows 1 to 27 and you press the Page Down key then Excel disp
8. remove some characters If you undo the action Excel reinserts those characters The Redo feature works like the Undo feature but in reverse After you undo an action you can redo it If you undo several actions in a row you can redo all of them in the order you undid them For example if you undo typing and then the effects of resizing a column when you use the Redo feature Excel first restores the effects of resizing the column If you then immediately use the Redo feature again Excel restores the typing On HA Bookl Microsoft Excel JE Home Insert Page Layout Foemulas Dats Reelt DESA A feaa eja eja a eel E aen Wy Paste g iB ee Se EE BS fe S Clipboard l Foal la Higimenk la umbe la 1 EMoarnths Sale Figures Tor 2007 Bookl Microsoft Excel Page Layout Formulas Data Raulu lew Ee ji ee Ganera ate ii E I E Clipboard l Font a 4lignimertt la Mumber la E Mornhs sales Figures for 1007 A D E D F G re mee Months Dies Figures for 2007 1 1 3 d 5 G T li 3 10 1a 12 13 4 Excel reverses the last action example Excel removes the text Click the Redo button g 3 Hone Jngert Page Lamut Forreulas Dyt Fenjae ere In this example Excel removes italics S i Callan j ie z General Paste a ms ee es ee ead z If you click Undo again in this ril ste a Ll Clipboard
9. the Undo button Check Spelling No more manually proofreading your work When you use Excel s AutoCorrect feature Excel corrects commonly made mistakes as you type and you can add your own personal set of common typos to the list In addition before you print you can run a spell check to search for misspellings If you are a poor typist this feature enables you to concentrate on calculating your numbers while Excel catches spelling errors Make Formatting Changes Excel easily enables you to align data in cells center column headings across columns adjust column width and display numbers with dollar Getting Started with Excel A signs commas and decimal points You can experiment with the settings until the worksheet appears the way that you want it then you can print it You can boldface italicize and underline data and change fonts and font sizes Excel also lets you shade cells add borders and apply styles to improve the appearance of a worksheet Preview Before Printing You can preview your worksheet to see how it will look when you print it You also can add headers and footers and adjust page breaks before you print Chart Numeric Data Numbers form the foundation of charts Manually creating charts is time consuming and takes some artistic skill In Excel creating charts is quick and easy You can track the sales trends of several products with a chart You also can make as many what if
10. What You Can Do in Excel icrosoft Excel is one of the world s most popular spreadsheet programs You could create worksheets on ledger paper and use a calculator or draw charts on graph paper but Excel makes these tasks and others related to managing numeric information easier You can use the program to create worksheets databases and charts Without a doubt you could perform the following functions manually but you can use Excel to make them easier Lay Out a Worksheet When you sit down to develop a worksheet with a pencil and ledger paper you do not always have all the information to complete the design and layout of the worksheet Ideas may occur to you after you sketch the layout of your worksheet After you are finished jotting down the column headings and the row headings you might think of another column or row that you did not include If you are working with pencil and paper restructuring the layout of a worksheet can be tedious and time consuming With Excel you can easily insert columns and rows and move information from one location to another Calculate Numbers Think about the tasks involved in managing your checkbook register You subtract the amount of each check written and add the deposits to the running balance You then use your bank statement to balance your checkbook and it is not at all uncommon to find math errors in your checkbook So you must then recalculate the numbers in your checkb
11. ck to redo the action you undid then e becomes unavailable because there are no more actions to redo 15 Move Around in a Worksheet ou can use arrow keys to move around a worksheet moving the cell pointer up down left or right one cell at a time If you hold down an arrow key Excel moves the cell pointer repeatedly in the direction designated by the arrow key You can also move one screen at a time using the Page Up and Page Down keys To quickly move to the first or last cell in a range you can take advantage of the End key You use the End O Click a cell Excel displays the cell pointer in that cell 2 Press the right arrow key on the keyboard Excel moves the cell pointer one column to the right You can press any arrow key to move the cell pointer one cell in that direction You can press and hold an arrow key to repeatedly move the cell pointer in that direction Press the End key The Status Bar displays End Mode 16 key in combination with the arrow keys to move the cell pointer to the top or bottom cell in a column or the left or right cell in a row When you use the End key Excel displays End Mode on the Status Bar to alert you that the cell pointer will move to the first or last cell in the direction of the arrow key you use When you know the address of the cell in which you want to work you can move directly to that cell using the Go To dialog box
12. eee Wier waly Tnm a Ie n 23 5 hieme Ibid Sues Esai alay Znaim 1 INUA 205 hlena Dusona Savica Fegi Valey Zistinj O O TANAN TAPS menet Yudeve Gewe List valty Mew 2 iano SIRE blamed eh wt Fardin Men Fsinlimy J CARLY ayi emet vuze ne ence Pharm sir IAAF F985 hiema Miane Ferie Phoen Zsisirey 5 aici 2355 Inlemet fuslove Bewe Phou Zain 3 TAD 2385 hiom i Iulai Beite Phonk EX ati fey Fe EDE I T S965 Parkmja Dusona Berica Wezi waley Zimin JO ANAN PA S Package Tuclove Seve Ext Waly Sesar 1 AE ans Te Suelo a Face Maen Fsisdiny al TANAN EERIE Verlag gence irei Valty sirg A 1 ASU Fa8h TY usuce Fanin Phoen Soindiny zd A ed ory Vurlovge Gewer Cra aly Mer z3 TANA Ea Ciclo e Benice Eiai aliy EX sti ty TOO eg esiTy Susloce Beie Weert vale Iyen 25 TAMA edt Tv Talos Savie Prog Maw x ee p anh Ty Lusine Sariin Maen Ssisiimy Er TANAN E LEA ry Yone ewe Listalty msi a AE ais TY Tite THH Fal Waley Fsisdimy 23 ANA edhe py Tuone sence Phocnc Ensim z1 iano z365 Ty Cielo a Tenite Phoen TEA A TAA eggs Ty Suslove Beie Weel vale Toei TE ILAT z365 TY Tuilove Sewvice Ear valiy Sristi Renta nd reie i Getting Started with Excel Cin Pe e s table sds Micasa Excel Press the up arrow key a Hone Insert Page Layout Formulss Disks Fesi wea ods Arial ju A a E e l ee Excel moves the cell pointer to the Da ee re see f h Parte y ee E j e Ga e a fi
13. gaile Getting Started with Excel 7 AE I Soha Fezot Pare hg crc Mth de Lables tbe fue woud f o T k i H a Monsen a is es ls Ean Does Excel prompt me to save before closing the program Ww If you have not made any changes to the workbook Excel closes without prompting you to take any further action However if you have made changes to an open workbook Excel prompts you to save the workbook After you respond to the prompt Excel closes regardless of whether you save the workbook Can I click the X in the upper right corner to close Excel w Yes but if you have more than one workbook open Excel closes only the active workbook instead of the program You must click the X in the upper right corner of each open workbook When you click the X while viewing the last open workbook both the workbook and the program close Before Excel closes any workbook you have changed Excel prompts you to save the workbook What happens if I pin Excel to the Start menu wW Excel always appears on the left side of the Start menu above the list of recently opened files Right click the Excel icon and click Pin to Start Menu How do I create a desktop shortcut wy To create a desktop shortcut for Excel right click the Excel icon click Send To and then click Desktop Create Shortcut Understanding the Excel Screen ach time you open Excel you see a new
14. ith either dashes or slashes Press Enter Pash r ipod E miast Gaclmets pects 7 Total sales The date you typed appears right aligned in the cell you selected in Step 1 The cell pointer moves down one row 4 Repeat Steps 1 to 3 to enter other numbers Getting Started with Excel DE ij alitint jii ay 3 a J B z y i A me om ce a Menth Sales Figure tor 2007 n Trausanssi J Criterec on ovlorith Sales Figure tor 2007 J ji n Togusanzsi January February Marci p i a hay June Total Sales a Bock Microsatt Excel Tsert Page Layout Poetriias Dati aeua Wey Genera I S B a Humbs how Tondo Foermat Cel Formatting 7 as Table Shes Shyer gt Awe amp F ay T P Font llgrmert une Total Sales Liz 156 LES January 127 143 165 February Marci April 135 145 LES 173 leo 203 hey 139 146 130 195 135 100 Can I edit or delete the information that I type in a cell w Yes You can edit the information either as you type it or after you type it by pressing the F2 key on your keyboard to switch to Edit mode To edit as you type just press F2 To edit after you type click the cell to select it and then press F2 To change an entry completely enter new information as described in this section To delete all of the information in a cell select the cel
15. l and press Delete To delete both information and cell formatting see Chapter 3 Why does my label in cell A1 appear truncated while my label in cell B1 seems to occupy both cells B1 and C1 Ww The information in both cells exceeds their column widths When an empty cell such as Cl appears beside a cell containing an over large entry such as B1 information seems to occupy both cells However Excel actually stores all of the information in cell B1 look at the Formula Bar as you select cell B1 and then cell C1 The information in B1 is also hiding part of the over large entry in A1 To view all of an over large entry on the worksheet widen the column See Chapter 6 for details 13 Undo and Redo ou can use the Undo feature in Excel to recover from editing mistakes that might otherwise force you to re enter data The Undo feature in Excel is cumulative meaning that Excel keeps track of all of the actions you take until you close the program When you use the Undo feature Excel begins by reversing the effects of the last action you took If you undo four times Excel reverses the effects of the last four actions you took in the order you took them For example suppose that you Undo and Redo a Perform an action In this example text is typed 2 Perform another action In this example italics are added Note See Chapter 3 for details on adding italics Click the Undo button 9 14 edit a text label and
16. lays D37 as the active cell However the cell pointer does not move if you Click in the horizontal scroll bar if you are viewing rows 1 to 27 on one screen and you press the Page Down key then Excel displays rows 28 to 54 Is there an easy way to move one screen to the right or left w Yes You can click a blank area in the horizontal scroll bar that runs across the bottom of the screen 18 Move Around in a Workbook ou can move between the worksheets in a workbook using the tabs and controls at the bottom of the Excel screen By default a workbook contains at least three worksheets and you How can I make ee worksheet tabs can switch between them If your workbook contains CLEANS CISC ME more than three worksheets it is possible that the tabs W Resize the horizontal scroll bar by moving for all worksheets will not be visible at all times You the mouse pointer over the left edge of can use the controls to the left of the worksheet tabs the horizontal scroll bar When the resizing to scroll through hidden worksheets The first and last mouse pointer appears click and drag to the right Excel makes more space available for worksheet tabs and less for the horizontal scroll bar controls scroll all of the worksheet tabs to display the first and last worksheets respectively The middle controls scroll to display the next worksheet tab in the direction of the control s arrow ta badan Sean me
17. lbar appears above the Context menu The Mini Toolbar does not appear when you work with pictures charts Clip Art or SmartArt The buttons that appear on the Mini Toolbar do not change you always see the same set of buttons However the commands that appear on the Context menu also called a shortcut menu change depending on the cells or object with which you are working That is Excel displays only those commands on the Context menu that are relevant to the cells or object you select this is how the Context menu got its name ri a 4 Sales Papoa H ft l Fama rist Pace Lrezutk Fomu ea Esta Bes eu de a n E ae j i Arial m a a m Gi cesar g has a Sayin e or A yer he m q2 Eg lfe bendbone Fumat cell z F lt Furma as Inbbe shu Liptsuand wh p Ayni a kunas a ERDEI i A in A Ei re D E fe H l I E E ii E i T Tz 12 1 15 IE 17 aam Mt felts Papuri Miccuvull Ezel ail _ Fone Fit Faze Lapouk Fomu Ceta Fra eee var s j I y m j Arial iin A a z ce Cucom E Hi y Tp E ae ipin lu z Baldr te E a EE ji e 21 4 Lenders unasl cull F l 4 A ll Ea l iii Formal as hbls bi i 6 Month Sales Figures for 2007 Sal rj jy Be oe OF PER AU h 13 14b b E Badge rns 7 failpars 1F5 1F5 A cocy L otal Sales ii i Broke 1 Fort iz Dudi 1 Clear lanrencs te Fiker I it il T L besert cogent ir Sp format c
18. often as required to maintain the list You can sort data on the worksheet alphabetically and numerically in ascending or descending order For example you can sort sales records in chronological order by dates You can also use the AutoFilter feature to quickly find information that meets a specific criterion or to find the top or bottom ten values in the list without sorting View Data When working with a large worksheet on ledger paper such as a financial statement you might have to use a ruler to compare figures on a far portion of the worksheet You might even find yourself folding the ledger paper to bring the columns you want to compare close together In Excel you can split the worksheet into two or four panes to view distant figures side by side That way you can easily see the effects of asking what happens when I change this value to project changes You can also temporarily hide intermediary columns so that distant figures appear right next to each other as you work Make Editing Changes To correct a mistake on ledger paper you have to use an eraser or you have to reconstruct the entire worksheet With Excel you can overwrite data in any cell in your worksheet You can also delete data quickly in one cell or a group of cells And when you accidentally make mistakes that overwrite original data while using Excel you do not have to retype or reconstruct information Instead you can just restore the data using
19. ols Fics Prom Ur ani lok T Fave o Pargi Po Lapedni Esl 11 Enter Information ou can quickly and easily type text and numbers into your worksheet Most people use Excel primarily to accomplish math related tasks and supplying text labels for the numbers you enter provides meaning to those tasks Although you can type information into a worksheet in any order some people find it easier to type labels first because it helps them identify the correct place for corresponding numbers You enter text using your keyboard and you can enter numbers using either the number keys above the letters on your keyboard or the number pad to the LE Enter Text Click a cell to select it Note See Chapter 4 for details on selecting cells 2 Type text As you type the information appears both in the cell and in the Formula Bar Click k The cell pointer remains in the cell you selected in Step 1 and the text you typed appears left aligned A Repeat Steps 1 to 3 to enter other text labels 12 right of the letters on your keyboard To use the numbers on the number pad you can press the Num Lock key By default when you enter text into a cell Excel left aligns it in the cell and assigns it a General format When you enter a number into a cell Excel right aligns it in the cell and assigns it a General format Excel also recognizes some dates that you type as a result it right aligns
20. on which you are currently working You can switch worksheets by clicking a worksheet tab Workbook A workbook is a file in which you store your data Think of a workbook as a three ring binder Each workbook contains at least one worksheet and a new workbook contains three worksheets named Sheet1 Sheet2 and Sheet3 People use worksheets to organize manage and consolidate data You can have as many worksheets in a workbook as the memory on your computer permits Worksheet A worksheet is a grid of columns and rows Each Excel workbook contains 1 048 576 rows and 16 384 columns Each column is labeled using a letter of the alphabet the column following column Z is column AA followed by AB and so on The last column in any worksheet is column XFD Each row is labeled using a number starting with row 1 and ending with row 1 048 576 Cell A cell is the intersection of a row and a column Each cell in a worksheet has a unique name called a cell address A cell address is the designation formed by combining the column and row names in column row order For example the cell at the intersection of column A and row 8 is called cell A8 and A8 is its cell address Cell Pointer qa The cell pointer appears as you move the mouse over cells in the worksheet You use the cell pointer to select cells in the worksheet Currently Selected Cell You click a cell to select it Excel identifies the currently selected cell also called
21. ook register and jot down the new answers If you set up an Excel workbook for the same tasks you can use formulas that subtract checks and add deposits You enter the formulas only once and simply supply the amounts of your checks and deposits much as you record them in your checkbook register When you change the numbers in the workbook Excel uses the formulas to recalculate the information in your workbook and instantly gives you the new answers in most cases without the associated math errors v L E December Tigrisin Drect Sales Phocnics Cinlimer Senate Phoen Cuslomer Senie Phoen Diad Saia Phoeni Euk Culmea Semice Essi Yale Cidona Sewe Phiri Bew Cusione Semia We Valley Diac Sales Erd Waley Exbiny Calme Semia Fej Waley mL Customer Senice Erd alley Nisd Fred ea Pinni CIOTCE ee POA Cialumer Fence Manic Unect soles Phoctice Cislimer Sanaa Pfaenic Customer Semeer Fest valley 9 Exetine Minime Saik Feat valley i Orat Sales Phoen A Tinim Saee Wat valley Exiting Oirart Sales Exe Draci Silica Drar Sams Existing Cislomin Semice West Valley Teese Penis Me Phocnice we Fei Valley Feiing Sales Era Valley Earring Organize Sort and Filter Lists You can create tables to organize your data in lists For example you can create inventory lists employee lists customer lists student grade lists and sales records In Excel you can add delete sort search and display records in the list as
22. rst cell in the column containing MA nn m a T information f TAA PANNON m 1 Daia Amount Aeclypa Openadiy Ea EF 1 IL 33445 nernel Jacl Sales Phoervs Exiabry You can use the End key with any d Jaraa 32 56 Iiernel Susloner Ferite Phoen Exishrig 1 4 222107 42 5 lnlerrel Susboner Ferite Plideris Hews arrow key to move to the fi rst or last 5 222107 32 95 Inlertel Susboner Service Fliveris Exislrg as 1222107 32 95 Inlernel Tusboner Service Fal Welle Exislire cell In the row or column containing 7 1222 0F 37 95 Infernel Suslomer Semire Fhoeris Mews i a 122I 32 95 Infernel Susbomer Service Wes waley Existing l nfo rm at on 3 122010 92 95 Internet Direct Boles East Valley Existing iO tata 72 95 Internet Customer Eerine Cast Waley Existing 117 THAAI J295 Infernal Dustomer ering Cast alay Haws iaj TAZA 1395 Imena Dustomer Sevina Phen Fuishrey You can press Ctrl Home to move to mal Ten 3595 merna Dustomer Seriza Phoe Exishry iaj TT 35 95 Internal Customer Seriza Phoen Exiahrg cell Al s 5 TAAI 33 95 Internal Dustoner Seriza Phoen Esiahre Lib Tt IL 3385 nernel Usher Servite Ahders E iabry if 1 IL a0 Pacage SUSloner Serica Wies Valley Exisbrg ia T2207 2 06 Pscdage Susloner Ferite Sash waley Exishrg ig 1221 92 55 Ty Suslomer Ferite Plidervs Exishng 20 1222007 52 05 Ty Tusboner Service Wes valey Exislirig Fi 1222107 57 05 Ty Tusbamer Service Fhueris Existing 22 1222107 52 05 Ty Suslomer Service Fash valley Hew 23 1222107 52 05 Ty
23. soft Office programs appears Click Microsoft Office Excel 2007 Office Excel 2007 from that list to open the program If you use Excel regularly you may want to pin Excel to the Start menu or create a desktop shortcut for it so that you can open it more quickly You can close Excel using a command on the Office menu or you can use the Close button in the upper right corner of the Excel window Excel behaves differently depending on the method you choose to close the program the number of workbooks you have open and whether you have made changes to any of the open workbooks l J3E5 Microsc Otice Laced 007 he i Backep and Reslure Canter ri f Hicosch tice deces Hii K Aube Chula up TU Ee Hicrascth OFice Pree Scone IT The main window for Excel appears The cell pointer lt p appears as you move the mouse over cells in the worksheet You use the cell pointer to select cells Note See Chapter 4 for details on selecting cells Close Excel Click the Microsoft Office button 2 Click Exit Excel Excel closes all open workbooks iy s hima hat Puce Faruk Ferrada Tach Era id e E fal bei qu jo l a E Lii Pasia J men n Fad alal Ta EES Fi fal Sipari T Font 3 agent 5 al i Se a AY I 3 Aj h 4 E TP a in 1 E 14 15 in Le l9 20 1 15 34 fn IR Hira gerlo Fe eena C t rrangandia a Fiia tariak EE ALe Aa Sapam ot ira
24. tatus Bar Click anywhere on the worksheet to hide the Status Bar menu Getting Started with Excel The cell mode that appears by default in all workbooks switches between four states Ready mode is a general state and the state that appears when no other state is appropriate Enter mode appears as soon as you start typing in a cell and Excel returns to Ready mode after you press Enter to store the information in the cell When you edit any cell entry Edit mode appears on the Status Bar Point mode appears on the Status Bar when you point to cells that you want to include while setting up a formula 19
25. that appear because you are performing a particular task For example when you select a chart in a workbook Excel adds the Chart Tools tab behind the View tab The Chart Tools tab contains three tabs of its own Design Layout and Format As soon as you select something other than the chart in the workbook the Chart Tools tab and its three sub tabs disappear Fr Hm m To use the commands on the Ribbon you simply click a button If you prefer to use a keyboard you can press the Alt key Excel displays keyboard characters that you can press to select tools on the Quick Access Toolbar and tabs on the Ribbon If you press a key to display a tab on the Ribbon Excel then displays all the keyboard characters you can press to select a particular command on the Ribbon Getting Started with Excel Work with the Mini Toolbar and Context Menu ou can use the Mini Toolbar and the Context menu to help you quickly format text without switching to the Home tab The Mini Toolbar and the Context menu contain a combination of the most commonly used commands available in the Clipboard Font Alignment and Number groups on the Home tab The Mini Toolbar and the Context menu always appear together when you work with shapes text boxes WordArt or cells containing text or numbers ap Select a cell or range of cells Note See Chapter 4 for details on selecting cells 2 Right click the selection The Mini Too
26. the active cell by surrounding it with a bold black box containing a small black square in the Getting Started with Excel Learn Excel Terminology hen you learn anything new you need to learn its terminology Presented below are a series of terms you need to know as you work with Excel lower right corner That small black square is called the Fill handle you can read more about the Fill handle in Chapter 10 Range The term range refers to a group of cells A range can be any rectangular set of cells To identify a range you use a combination of two cell addresses the address of the cell in the upper left corner of the range and the address of the cell in the lower right corner of the range A colon separates the two cell addresses For example the range A2 C4 includes the cells A2 A3 A4 B2 B3 B4 C2 C3 and C4 Formula Bar The Formula Bar is made up of three parts At the left edge of the Formula Bar the Name box displays the location of the currently selected cell The Cell Contents area appears on the right side of the Formula Bar and displays the information stored in the currently selected cell If a cell contains a formula the formula appears in the Cell Contents area while the formula s result appears in the active cell If the active cell contains a very long entry you can use at the right edge of the Cell Contents area to expand the size of the Cell Contents area vertically Be
27. them in cells and formats them as dates Information in a selected cell appears both in the cell and in the Formula Bar For more information on formats see Chapter 3 En ied ify i Book Wlicroraf t Exce Home Ingert Page Layout Formulas Data Review View B a calibri ii i A A 2 j General a F ae he reste g BU Ae ES Se S i e a Humber 1 E Month Sales Figure for 2007 2 In Thousands Book Microsaf Excel Fenit Views Page Layout Formule Data jii E allil z General J al i Paste F Bl U gt NIEA Clipboard M T Alignment Ta Humber a i B C 1 6 Morth Sales Figure for 2007 2 In Thousands 3 5 6 a g iu laa Iz Enter N um be rs Og fe gt Hock PMicrosott Excel Hore Insert Page Layout Fomuias Data Ree Wies fi alin ae A p m ee SS enera Zz l Select a cell and type a number a rd re E ay Paste F E I bel ee A E i i g aea a g conditional Fomat Cel 3 Pormetting as Table Siyer T ipod E Font G Allgnmert Hemis Shes 2 Press Enter The number you typed appears right aligned in the cell you selected in Step 1 The cell pointer moves down one row Repeat Steps 1 and 2 to enter other numbers Enter Dates Horu wa D Select a cell 2 Type a date in mm dd yy format separating the parts of the date w
28. tween the Name box and the Cell Contents area buttons appear that help you enter information Before you start typing in a cell only the Function Wizard button appears as described in Part Ill you can use this button to help you enter Excel functions Once you start typing two more buttons appear click to accept the entry as it appears in the Cell Contents area or click x to reject any typing and return the cell s contents to the way they appeared before you began typing Understanding the Ribbon o accomplish tasks in Excel you use commands that appear on the Ribbon New to Excel 2007 the Ribbon fundamentally changes the way you work in Excel compared to earlier versions of Excel You no longer open menus to find commands buttons for commands appear on the Ribbon By default the Ribbon contains the commands most commonly used to complete an Excel task Do not worry if you do not find a particular command on the Ribbon it is still available and if you use it often you can add it to the Quick Access Toolbar which appears at the top of the Ribbon See Chapter 30 for details on customizing the Quick Access Toolbar On the Ribbon in addition to the Office Button and the Quick Access Toolbar you find tabs which take the place of menus in Excel 2007 Each tab contains a collection of buttons that you use to perform a particular action On each tab commands are grouped together For example on the Home tab
Download Pdf Manuals
Related Search