Home

Wiley Master VISUALLY Excel 2010

1. 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 as well as 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 y
2. E gS niemal Dimri Salis bran Fy sling 13 zang 20 75 piemel Cushome Barca Chua s Es sling 14 zzz 6 85 Ty Cuslome Gerce Phoens Ex sling Wo eee 0 05 lF Pene Cirect Sab Phacns Crsling IK alee TT E55 niemal Cualimar Har rh Shaan Fy sling 17 meae i La S605 Ta lkage Cyshome Saria Wal volley Es sling 168 sft 10 25 E5 Package Cusliome Sence Zasl Waley Ex sling 13 taiii 5 5 T Cirect Saks Fhoens Er sling Al lee TL begs i Cusine Har ce Essl Walley E sling 21 1e z205 niemal Cii Sala BOCHE Ex aling 22 ziza 10 52 55 Ty Cyslomet Sern ce Essl valey Neve 2I diili E g3 MIF Paene CustomerSence Cost Waley Er aling a Terere SID 2 83 namel Cusine Har Ch wisal Walley Ex sling Pira 10 BE 55 Tackags Cii Sales hia Hen w grali 55 5 Ty Cuslome Ser EE Fhuen s Ex sling SF Taishi ee 05 Thy Tuome Semer Eas Waley Er sling H Terere JIL bb bs Aackage Ciri tales asl walay Ex sling 7 erna z755 nlemal Cu ima Tar th PFiar t Fy sling h h k a zarj EB ES Ty Cie Saks Phuens Herve 2 Press t e ri g t arrow ey Si lafef2 10 26 55 nieme Customer Semeer Wisal Walley Er sling To Jari 58g Ty Customer Gerce Easl walay Ex aling MR Sheek erase Sects a IE a PE Excel moves the active cell one column to the right ce 0o m Dube Quen Aruni Tages Opened Ey Baamnh Customer z Taia BLES MIF Paene Cirect Saks harnun Er sling You can press any arrow 3 Terere TI 26 83 namel Customer Semee Pboens Ex sling 4
3. These commands help you share Excel workbooks Clicking buttons in the Save amp Send column changes the information that appears here Repeat step 2 until you find the command you want to use This example shows the results of clicking Recent which by default displays the last 20 workbooks opened fel ar Fonai Workin bed we Ae r IA Sale pide Geen a by Coc omocbihtl Boos Sof Chose el tilisi e dA kh Dale ints Eo mro Gey amsa ph i Biy Fan ane skipe Pora TE Phe zij kh Dusen HAN Eros d pawnazla bankirg shs a Wy Docent Eons B B pamiii barking ak a kiy Pitre brane Bone i Ass twa slre tel kh Dl nes sba Bou ae Carms ty tne 2 Orions PL Ky ve reeset the Hep Soe iz Chacgs Tare ngedse a et el hy Coz manb lusk the Sapo SAAce T ising msi TBA ki Doista thes Hep oMi ij Seale pit fete Dds edari ue oe nt Getting Started with Excel chapter 1 Recent Plico kf Bacal AC Use iE bsine MaeveRDocumentiyey Bers Is there a way to return to working in Excel without making any selections in Backstage view w Yes You can click File again or you can press Esc Either action returns you to the workbook that was open when you clicked File to display Backstage view And although you might be tempted to click Exit resist the temptation because clicking Exit closes Excel completely What happens if I click the check box at the bottom of the list of Recent Workbo
4. Pe JE Be Re ETTE os ee Can I redo more than one action at a time w Yes The Redo feature Can undo more than one action at a time Why is the Redo button unavailable when the Undo w Yes Click the drop down button is available arrow beside the Undo button to display the list of actions you can undo Click the oldest action you want to undo and Excel undoes all 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 W Excel keeps track of all Undo feature To be able to redo more than one action at a time you must undo multiple actions before you redo them Then click beside the Redo button to display a list of actions you can redo Click the oldest action and Excel redoes all the actions from the oldest to the latest actions you take in all open workbooks and makes those actions available to undo until you close Excel The Redo button 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 click to redo the action you undid then becomes unavailable because there are no more actions to redo 17 Move Around in a Worksheet ou can use arrow keys to move around a active cell to the top or bottom cell in a column or the worksheet moving the activ
5. letters on your keyboard or the number pad to the right of the letters on your keyboard To use the numbers on the number pad you must 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 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 on formats see Chapter 3 Enter Information Enter Text p Click a cell Note See Chapter 4 for more on selecting cells 2 Type text As you type the A information appears both i in the cell and in the i Formula Bar click H Note If you press Enter Excel stores the information but moves the active cell down one cell The active cell continues to be the cell you selected in step 1 and the text you typed appears left aligned 1 1 I E 1 15 als IF IE IE D Repeat steps 1 to 3 to enter other text labels 14 0 L erik Soles Figaros ter 2010 2 tbe Taupa ht L S Werth Siles Figaros ter 2010 2 the Pusan ht i lI L I E L PA i um Enter Numbers Select a cell and then type a number 2 Press Enter The number you typed appears right aligned in the cel
6. seven tabs Excel displays contextual tabs which are tabs 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 subtabs disappear To use the commands on the Ribbon you simply click a button If you prefer to 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 tab a pl use a keyboard you can press the Alt key CE a Excel displays keyboard characters that Pert r I ithim Fert E g 10 er Getting Started with Excel chapter T 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 always appear together when you right click on cells that contain text or numbers shapes text boxes WordArt pictures charts Clip Art or SmartArt In most cases the Mini toolbar and the Context menu contain a combination of the most commonly used commands available in the Clipboard Font Alig
7. 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 taskbar w A button for Excel always appears on the Windows taskbar To pin Excel to the taskbar complete steps 1 to 3 right click on Microsoft Excel 2010 and then click Pin to Start Menu How do I create a desktop shortcut w To create a desktop shortcut for Excel complete steps 1 to 3 right click on Microsoft Excel 2010 click Send To and then click Desktop Create Shortcut Understanding the Excel Screen ach time you open Excel you see a new workbook named Book1 that contains three worksheets Title Bar Worksheet Tabs status bar also contains View Displays the name of the These identify the worksheet on buttons that you can use to workbook and the name of which you are currently working switch views and
8. 010 93 95 Package Customer Semice West Walley Zyisiing e 6 122010 94 95 Package ustorner Semice East Walley Existing In the row or col umn 14 TAAN AS Be Pt Dine Sales Phi rin Sensing ae a0 122010 aa OE TH Customer Serica West Walley Existing containing information g 71 122010 15 595 Intemet Diraci Salas Phioanix Existing 32 1342010 53 95 TH Customar Semica Eas Walley Mawr 23 1822010 13 95 VOIP Phone Customer Senice Eset Walley Existing You can press a4 182a 39 95 Intemet Customer Semice West Walley Existing 25 TAM g4 45 Package Died Sales Phoernin Mine Ctrlt Home to move 6 1222010 BS BE TY Customer Semice _ Pheanis Existing 3o 1232010 55 95 Ty Customar Senica East Valley Existing to cell A1 E 1222010 95 55 Package Direct Seles Eset Valley Existing 29 1222010 33 95 Intemet Customer Semice Phoenis Existing su TA U Ed WE Tw Direct Sales Primer Mery O Press F5 Ei 12010 33 95 Inteme t Cuslomer Service West Walley Zrisiing J2 1222010 oo Be TY Customer Serica East Valley Existing HARE H Cheeta Sheet Sheet Tg The Go To dialog box opens Type a cell address Click OK Excel moves the active cell to the cell address you typed Where does Excel place the active cell when I move a screen at a time Ww The active cell remains in the same relative position What happens if I click the Special button in the Go To dialog box w Excel opens the Go To Special dialog box where When I
9. EE ami Diiomner Jemie Esa sake Exiting a t Oh L 9695 Paka Customer Seroce Pho Ney EJ e EA tamai Customer SRE Weal alk 4 Exaning 1 F Eer ih W Ine ml Dirar Fides Faxi alley Fein l ZETI EA amai Customer Siet Eri A Eakin 7 a ade 7895 Pakan Cinler Service Faul alley Hs I OEN WA ey Unect sales Fionu Ezrin eee ta S liane Ciglumer Aasi Miani Feiling 250 IL A l CLR OTE SEE Parni CARNE eer ta B S36 lise Nimid Fides Pinn Ezilme AAL TA eem CUSTOM et SEEE PERE Exin 3 ere Bh u 36 96 Packay Ciplomer Senate Wes le Euigting 3 aeii TA Package Cuslomer MEE a Exming q etre Bh 6 TY Oct Sales EXigting 1 cere Oe TA TH Cuslomer Seme We vale Exmine 2 SGI 36 56 ami Draci Adia Piar Exam 3 ae W Ty Drart Sales Emsi Valey Mey Er i E 36 56 mami Draci Saia Eiai Waliy Exams E Fia T EA Celme Sewe Wezi Valley Exeing 36 Ty Cinlomit Semice Phort HEN Ee EEr th W Inen Oia Siue Phenix Exiting oo Ty Cioni semice Eni valley Exit eee ih AR hisni Nimi Side Faxi vale Fexine payee l Pe 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 happ
10. F2 To change an entry completely enter new information column widths When an empty cell such as Cl appears beside a cell containing an overly large entry such as B1 information seems to occupy both cells However Excel as described in this section To delete all the actually stores all the information in cell B1 information in a cell select the cell and then look at the Formula Bar as you select cell B1 press Delete To delete both information and then cell C1 See Chapter 5 for more and cell formatting see Chapter 3 15 16 Undo and Redo ou can use the Undo feature in Excel to The Redo feature works like the Undo feature but in recover from editing mistakes that might reverse After you undo an action you can redo it If otherwise force you to re enter data The you undo several actions in a row you can redo all of Undo feature in Excel is cumulative meaning that them in the order you undid them For example if Excel keeps track of all the actions you take until you you undo typing and then the effects of resizing a close the program When you use the Undo feature column when you use the Redo feature Excel first Excel begins by reversing the effects of the last action restores the effects of resizing the column If you you took If you undo four times Excel reverses the immediately use the Redo feature again Excel restores effects of the last four actions you took in the order the typing you took
11. Yzarn E g5 niemal Cintas Sars oa brian Hens 1 fe lazai cg g5 Pakana Cime Saks Phua s Es aling key to move the active cell E Tasli BES YF Paene Customer Serce zal waley Kaling f Tarere HTU 22 83 namel Customs sen ce 1 X Hew one cell in that direction RISEN BRAS Parkana irae Hales ey By sling E ain 25 55 nlemel Ciee Saks Zal Valley Es sling 10 zro e605 Ty Cuslome Semer Easl Valley Ex sling 1 Taizai 20 03 Sockage Cuslomer Gence Coal valley Heva You can press and hold an re eenn SES mamal mma Siaka o Ekaan Fraiing 13 meae i Ln 20 75 niemal usluma Sar ce Chua s Es sling arrow key to re peated ly 14 zrli o6 05 Ty Cusiome Semere Phoens Ex sling io taitin 0 05 lF Pene Cirect Saks Fiaen u Ce sling IK ihe A 75 55 niemal Clistaitas Gare ta brian Fy sling move the active cell In 17 zNa PRES akaga uglima Sarca Vesel Valley Ex aling s s 168 sft 10 25 g5 Ssckage Customer Sence Easl Waley Ex sling that direction TAA EES Ty Cinect Saks Shacn Er sling Al ie A 66 95 Cualamar Gare ta Essl Walley Ev sling 2 Ezenn 2 niemal Cirat aka Fian Es aling Pr 22 5 Ty Cyslome Ser TE Zal Waley E Press End s 23 aiii BLES JF Pocne CustomerSence Coat Waley Er sling pis Terere MIL 25 43 nlamet Customers Sar ca Essl Walley Ex sling Th t t b d Pai rga BE 95 markaga Cimi Sales haar Herve e S a us ar ISp ays 5 afefz10 66 05 Ty Cuslome Ser ce Phuens Ex sling Iro aid EES Ty Cuz Si Eas Waley Er sling E d M d 4H weet ke us sockage Grami Saka
12. a Zoom control the program You can switch worksheets by to help you zoom in or zoom out clicking a worksheet tab See Chapter 8 for more on views Quick Access Toolbar and zooming By default this contains Status Bar buttons that enable you to This displays Excel s current Scroll Bars save undo your last action mode such as Ready or Edit and These enable you to view more and redo your last action identifies any special keys you rows and columns You can also add buttons press such as Caps Lock The to this toolbar see Chapter 30 for more A bd RELE Deckd feticnonott Exce 2 H Z Ribbon Contains most Excel commands organized on tabs See the section Understanding the Ribbon for more Formula Bar Composed of three parts the Formula Bar contains 0O the Name box buttons lt 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 Learn Excel Terminology resented next is a series of terms you need to know as you work with Excel 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 workshe
13. ate last modified products Backstage view replaces the menu that appeared in Excel 2007 when you clicked the Office button The Office button is also gone from Excel 2010 and other Office 2010 programs the File tab appears in place of the Office button in Excel 2010 and all Office 2010 programs For more on opening saving and closing workbooks see Chapter 2 See Chapter 8 for more on printing and Chapter 29 for more on sharing workbooks From Backstage view you can also print and distribute documents however before sharing you might want to remove sensitive information Finally from Backstage view you can set Excel program behavior options A list of actions commands appears down the left side of Backstage view For example from Backstage view you Can open save and close Excel files You Work with Backstage View Click File D pnan _ n Setar Cal bi L A gg E zmn p i 4 a 3 a7 ete T imdad ne LA A Praline mi bidee Shes Beau D be A gt EFS EE in wl Ererat kF In Backstage view commonly used file management commands appear here B The title of the open Pee akboul Boek workbook appears here gels Buttons that represent other actions you can take appear here 2 Click Info Information about the workbook on screen appears here Click an option in the left column This example shows the results of clicking Save amp Send
14. e cell up down left or right cell in a row When you press the End key left or right one cell at a time If you hold Excel displays End Mode on the status bar to alert you down an arrow key Excel moves the active cell that the active cell will move to the first or last cell in repeatedly in the direction designated by the arrow the direction of the arrow key you use key You can also move one screen at a time by using the Page Up and Page Down keys When you know the address of the cell in which you want to work you can move directly to that cell by To quickly move to the first or last cell in a range you using the Go To dialog box can take advantage of the End key You use the End key in combination with the arrow keys to move the Move Around in a Worksheet i Ea i tr E F G H J le al CI ick a cel Dale smumL Avorn Type Opened By Beanch Custurreet 2 late L BLES VOIF Pacne Cirect Saks Phoecna Er sling 3 Taieri 22 85 nlamet Customer Sermce Prac Ex sling 4 Ie WA E g5 nlemeat Tislima Aare rA bran Hans Excel makes the cell you eeno 65 95 akane Cimer Sales Chuan Es sting E png GES lF P ene Eval Waley Er sling cl icked th e active cel i T ennd 26 93 nlemet Custome perce Fhaena Hee aj TA TE BRS Sarkage Citar Aa Hal alley Fy sling a ain 25 55 piemel Cime Salis Fasl waley Es aling 10 zri J10 o6 85 Ty Cusiome Bence Exsl Waley Ex sling i1 ete 86 05 Package CustomerBence Cast waley Hea 17 Tae TE
15. ens when change this value to project changes You can also temporarily hide intermediary columns so 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 quickly delete data in one cell or in 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 by using the Undo button Check Spelling You no longer have to manually proofread 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 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 Getting Started with Excel chapter T with dollar signs commas and decimal points You can experiment with the settings until the worksheet appears the way that you want it and then you can print it Y
16. ets in a workbook as your computer s memory 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 with 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 with 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 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 cell A8 and A8 is its cell address 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 Getting Started with Excel chapter 1 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 composed 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 disp
17. f installed Microsoft Office programs appears Click Microsoft Excel 2010 The main window for Excel opens The cell pointer 4P appears as you move the mouse over cells in the worksheet You use the cell pointer to select cells Note See Chapter 4 for more on Selecting cells Close Excel a Click the File tab Backstage view appears Click Exit Excel closes all open workbooks E ll r Fami A rat Pere J th ff ils Tar Fig Lipar Parais Dab Fahir YEA ry i F Suy L E cain hea yy o E onu jh e Sorry ae Er p i y 3 4 ab a oinera Diro fab F mije F 6 a e 4 i r a rr SS Poraathing sun Tibhar stan r 11 an ri apenall ra COFEE 5 hae L x L e e r in a 1 K I tA L d 3 o ajajalle e ulale E slaze la EE niell Cre dl 5 Hugs Im Pap Less Fava Bet ial Eason Ala rdsca ie ey fae Pesce p yarari X raha z ge ER 2 aoe a7 J E x CF joan 2 Bosak ch pe of pT e 3 Fu FE GF Fs nee Pia Jb x glass ier Par Yr EO Ea Th FE BBE Tb r TX ID RO ee Fy AE ORR Te ay pf i ini Ae 9S AE OS AD OS EO SS Getting Started with Excel te Ts rs 3 T ee ood pt g 1 fer Fin 4 7 3 T kk J E iF D 6 amp w chapter 1 M Does Excel prompt me to save before closing the program v If you have not made any changes to the workbook Excel closes without prompting
18. l you selected in step 1 e The active cell moves down one row Repeat steps 1 and 2 to enter other numbers Enter Dates Select a cell 2 Type a date in mm dd yyyy or mm dd yyyy format either dashes or slashes will work Press Enter The date you typed appears right aligned in the cell you selected in step 1 The active cell moves down one row 4 Repeat steps 1 to 3 to enter other numbers Getting Started with Excel chapter 1 SP me eae i E F a 4 i j z L tel x 5 1 S Month Sales Figures for 2010 Sa Thana January eblvuary kiaii a bday Juri lal Sa es 5 aage b Sadaats fatal Sales 4 A Sheetd Erec Feet al D E F T z F ho E SE 7 A 1 2month Sales Figures for 2010 q 9 F 2 ila Trorsands a January eblvuary kiaii Apri day luie lal Sa es f 4 Widgcks 127 135 Lit 123 14 152 A agers 144 lia Ts 1m 155 14h b Sadak 165 ing 202 10 100 i03 fatal Sales 44 A Sheet Breet o eE tal E i i Can I edit or delete the information that Why does my label in cell Al appear type in a cell truncated but my label in cell B1 seems to W Yes You can edit the information either as OCcupy both cells B1 and C1 you type it or after you type it by pressing wv The information in both cells exceeds their F2 to switch to Edit mode To edit as you type just press F2 To edit after you type click the cell and then press
19. lays the information stored in the currently selected cell If a cell contains a formula the formula appears in the Cell Contents area and the formula s result appears in the active cell If the active cell contains a very long entry you can use y at the right edge of the Cell Contents area to expand the size of the area vertically Between 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 IIl 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 to the way it appeared before you began typing Understanding the Ribbon o accomplish tasks in Excel you use commands that appear on the Ribbon You no longer open menus to find commands buttons for commands appear on the Ribbon 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 Ribbon or the Quick Access Toolbar which appears by default above the Ribbon See Chapter 28 for more on customizing the Ribbon and the Quick Access Toolbar On the Ribbon you find tabs which take the place of menus in Excel 2010 Each tab contains a collection of buttons that you use to perform a
20. nment and Number groups on the Home tab You will notice though that the commands on the Mini toolbar change when you select pictures charts Clip Art or SmartArt to reflect the commands you need when working with these types of objects The commands that appear on the Context menu also called a shortcut menu also change depending on the content of the cells or the type of object with which you are working That is Excel displays only those commands on the menu that are relevant to the information in the cells or the type of object you select this is how the menu got its name Work with the Mini Toolbar and Context Menu Select a cell or range of cells Note See Chapter 4 for more on selecting cells Right click on the selection The Mini toolbar and Context menu appear with the Mini toolbar above the Context menu daniary Fabri 1s isa 1275 125 13 133 6 Month Salejem u at g a Bl Int oy wehbe Ara F 7 February lar 1 en yE 1 Parks Zpedal riet Beate ar loners Fikar hort Wa Feet Copmen i P Eonrat Cell Hr Pen Ge upe dine aah Dette Wym a sper ink 11 12 Work with Backstage View ou can use Backstage view to manage files also can display information about the workbook and program options Backstage view is new on screen in Excel when you open Backstage view to Excel 2010 as well as other Office 2010 such as file size and the d
21. ograms 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 programs You can select Start and Close Excel Start Excel Microsoft Office Excel 2010 from that list to open the program If you use Excel regularly you may want to pin Excel to the Start menu or Windows taskbar or create a shortcut for it so you can open it more quickly You can close Excel by using a command in Backstage view or you can use the Close button in the upper right corner of the Excel window Excel s behavior when you close the program depends 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 Wi I Micrsoft Word ziii F WA ier eesti D Click the Start button lex haii Fa Microsoft Excel 201E ey HyperSeap 6 a Microsoft Dar P oirt Workspace H Pii The Start menu opens 2 Click All Programs P Command 4rorapt s uk Soken Reshore All Programs changes to do Accessories Back D Administratie Tonls di ESET D Games Click Microsoft Office Ji Hypersrap 6 d Flaintsnance d blicrosoFt OFice The list o
22. oks wW If you click the Quickly access this number of Recent Workbooks check box Excel displays just above Info in the left column the names of the last four files you opened You can change the number from 4 to any number between 1 and 20 As you increase the number you also increase the space required to view the list and Excel adds scroll bars to the middle and left sides of the screen When I click Recent Recent Places appears on the far right side of the screen What information is here w The Recent Places list displays locations from which you recently opened Excel files When you click a Recent Place Excel displays the dialog box you use to open workbooks and automatically navigates to the location you clicked What is Recover Unsaved Workbooks w Excel saves copies of workbooks you do not save and you can open these workbooks For more see Chapter 2 13 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 they help users identify the correct place for corresponding numbers You enter text by using your keyboard and you can enter numbers by using either the number keys above the
23. open Excel I see Sheet1 Sheet2 and Sheet3 at the bottom of the screen What are these w Every workbook can contain multiple worksheets represented by tabs at the bottom of the screen The default names for each worksheet are Sheet followed by a sequential number To view the content of a particular sheet click that sheet s tab You can add and delete worksheets change their names and move or copy them see Chapter 6 for more 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 displays D37 as the active cell However the active cell does not move if you click in the horizontal scroll bar you can set special conditions for Excel to use to go to a particular cell For example you can opt to select all cells that contain formulas 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 19
24. ou can boldface italicize and underline data as well as 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 can also 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 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 R D E F E H Jaman Pebrusaiflaccoh apr May June 150 155 12E LBs 155 L amp 1753 15 kPa ii i ri 6 Month Sales Figures for 2010 s we 4 a Midgets 31 m f eGakata at ten F eSocdoete zi za 5 F 23 F af ma are R 5 Fa a oa Start and Close Excel ou can start the Excel program by using the Windows Start menu When you open the Start menu the Windows search field appears at the bottom and the All Pr
25. our checkbook register and jot down the new answers If you set up an Excel workbook to do 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 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 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 Ajg ex a F T F ni Cable Company Sales December ip penik y eie Bh AE ama EEEE Phacni i Exiting 1 a fal N 32 25 emal Cuime Semice Phos Exige 5 RELIC 36 36 Package Cia orn et Serwic amp sane Haw a eer Oe 30 55 nemal Orect Sales Ex mine RELIC
26. particular action On each tab buttons with related functions appear in groups For example on the Home tab 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 button that you can click to see additional options that you can set for the group By default the Ribbon contains seven tabs described in the following table Tabs on the Ribbon Tab Purpose Home This tab helps you format and edit a worksheet Insert Page Layout and page breaks This tab helps you add elements such as tables charts PivotTables hyperlinks headers and footers This tab helps you set up a worksheet for printing by setting elements such as margins page size and orientation 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 make to the workbook Formulas This tab helps you add formulas and functions to a worksheet Data consolidate data and perform What analysis Review 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
27. sal alls Eating Nn O e e mi izen SESS niemal Cishotier Sars oa hia Fy sling E Foroen i Ln EEES Ty Cieri Sales Fhuens Herve Ho Tazi TEES niemei Customer Semeer ocd rliy Er sling 1 8 Too teszi eek TY Customer Serce Eas walay Ex sling 2 E A ae ea O S RRE z Te FE Mimi Ecd wade D e EAF chapter 1 Getting Started with Excel al A E c m F Ls H J K Press the u p arrow key 1 Date Amoun Account Type Opened By Customer a TAAU 13 95 WOP Phare Dieci sales z islirig 7 E 122010 3295 Inteme t Cuslomer Serice Existing Excel moves the active q 1222070 15 95 Intemet Customar Serica Ma e e 5 1222010 92 55 Package Direct Sales Existing cell to the fi rst cell In 4 222010 19 55 VOIP Phone Customer Semice Zyisiing ee 33 95 Intemet Cuslorner Service ene the col umn contal ning 4 TAAN g4 45 Package Dineet Sale i Z islirig e e Ea 122010 35 95 Intemet Diract Sales East Valley Existing info rm ation 10 1232010 33 95 TY Customer Serica East Valley Existing 11 1010 93 95 Package Customer Serica East Walley Law 2 122010 33 95 Intemet Direct Sales FPhesnis Existing You can press End with 13 Afi 34 95 Intemet Cuslirer semite Proens HIS k 14 1282010 AS oe TH Cuslormer Service Phpenin Erisiing any arrow key to move G5 1222010 1996 VOIP Phora Diraci Salas Pheanis Existing e 16 12232010 35 95 Intenvet Customar Serica Pheanis Existing to the fi rst or last cell 17 122
28. them For example suppose you edit a text label and remove some characters If you undo the action Excel reinserts those characters Undo and Redo 32323570 I ap Perform an action O CEEA In this example text is a typed 2 Perform another action EE E A tus dune Inis t Baga armut Forme Laka Hire ews han a mo BU ar In this example italics are boum moge Seo E jem TEL FART added ETRE AA See A E E A EAE EE EEN T E lietos a For a SQ gniment T Merb tele re Le Sdtng l 7 i Bidorehs sales gara for 2010 Note See Chapter 3 for more pra DT z D E r G H i i M k ira i tiana nper Purea for pni on using italics Click the Undo button a Excel reverses the last action In this example Excel removes italics If you click Undo again in this example Excel removes the text 4 Click the Redo button chapter 1 Getting Started with Excel Inere Trees Sage laut 9 Fonvula Dora Redas Waw talhen u r E a wawal 7 7 Ine mos G A dee dur BBB eS H te ee ede Fon eal a vi 3 Foret as Tabik fyi F j girsek L oldurth ala3 Hyeres for 20 o E F G e Excel reverses the effect of undoing an action by adding back your last one In this example Excel reapplies italics chee eee ele ee le ee ny m ay ue ie op jae a Z ilgi he hi Aguece for 010 1 I ae ed ccd cd boa dl ead el af mg ag fs ue ee mie l L SI Pa

Wiley Master VISUALLY Excel 2010

Contents

Download Pdf Manuals

Related Search

Related Contents