Wiley Excel Data Analysis
Contents
1. a Sampie Filed Microsoft Ewe o m 2 Sign up for a SkyDrive account File Hore Insert Page Layout Formulas Dats Review Views Developer Acrobat 2s o m i ae to Windows Liv Open the file you want to upload f soe SA a Sa sca AEE aE RE tna Sign in with Windows Live IO Hotmail iessenger box LIVE Click Save amp Send E ee Recent fl i O Click Save to Web z Fle Types ae sn Charg File Type Click Sign In ah gt EE ANE Creste PDF S Document A Tah Add Ins bj Options Exit The Connecting to docs live net dialog box appears Type your e mail address Type your password Click OK RS O Save amp Send fel Save As 1a E ins le Click a folder TR To The Save to Windows Live pane appears File Prifert Page Layout Hame Formulas fel Save Sample Filexisx Microsoft Excel Review Data View Developer Acrobat Save to Windows Live Save to Web to access this document from any oe orto share t with other o e Click Save As ee sewe EN Windows Li B New Info Bo 9 FA Save bo Share oink Recent New File Types Print lal Change File Type Personal Folders Excel Data Analysis Just me i Shared Folders z Public Everyone public Save amp Send Create POF SEES Document lal F Addins b Options EJ ert The Connect to doc live net dialog box appears Type2. perieis UNID FILE TAB QUICK ACCESS TABS RIBBON Click the File tab to open TOOLBAR Click a tab to view Ribbon Click the buttons in the Save print prepare send Place commands you use options Ribbon to execute Excel publish and close files often on the Quick Access commands Toolbar Minimize the amp id 9 e miie Deckt Picrosott Excel P Ribbon H wom gle Click the chevron to Hide 10 Be Sondeionel Permet 5 au Prd amp aa ia a a E the Ribbon so that only a e Sa eS mre tabs show J K L Q CELL Enter data into cells SHEETS Enter data into each Sheet of a workbook INSERT SHEET Click this button to insert a new sheet eo S B S lw 4 e e u e e NAME BOX DROP DOWN LIST FORMULA BAR EXPAND FORMULA BAR Displays the name of the Displays a list of defined Use the formula bar to active cell range names enter and edit data Click the chevron to make the formula bar larger Explore the Ribbon ou use commands to tell a program what you Within a tab related commands are organized into want it to do In Excel you use the Ribbon to groups For example on the Home tab commands issue commands The Ribbon consists of several relating to cutting copying and pasting are in the tabs Tabs group related commands together The most Clipboard group Commands related changing the size frequently used commands are on the Home tab the color or sty
3. active cell and Excel surrounds it with a black border Once in a cell you can use the arrow keys on your keyboard to move up down left and right You can enter text numbers dates and formulas into cells Alphabetic characters and numerical data you do not use in mathematical calculations are text Excel considers any sequence of characters that contains a letter text By default Excel considers all numerical data numbers If you wish to enter numerical data as text precede your entry with an apostrophe As you type the data you enter into a cell appears on the formula bar You can click Enter the check mark on the formula bar or you can press the Enter key to enter your data into a cell Enter Text Click ina cell Type the text Press Enter Excel enters the text and then moves down to the next cell Alternatively you can click Enter f the check mark on the formula bar Enter Numbers Click ina cell Type the number Press Enter Excel enters the number and then moves down to the next cell Alternatively you can click f on the formula bar B EH I r Fara Maraba Uirwrcuk fered ee am ibm at galyet Ferme Cra Fade YA darckal a ows Fenm x E E E ge n sa dg erdha obi We i ente Ttk ois Le mad cA pii pests Fi C la a a Swe e fes Cenas kro ge ee A ee oe ee Oe Lt EEEL a brd Fajiser 3 Him rida amp amp re ie eed eed SES SS
4. page to exit the file In the Microsoft Excel Web App you can view a workbook that has objects in it that you cannot view such as comments However if you want to edit the file you must make a copy of the file and edit the copy To make a copy of the file click File Click Save a Copy Excel displays a message stating the unsupported features will not be saved Click Yes Enter a new filename and then click Save Excel saves the file A Aah coe orksheets divide information into rows and columns of data People often use worksheets to calculate financial statistical or engineering data Microsoft Excel is an electronic worksheet You can use it to enter display manipulate analyze and print the information you organize into rows and columns Each Excel worksheet has more than 1 million rows and more than 16 000 columns Excel labels each row in numerical order starting with 1 Excel labels each column in alphabetical order starting with A When Excel reaches the letter Z it begins ordering with AA AB AC and so on You refer to the intersection of a row and column as a cell The intersection of a row and column also forms the cell name For example you refer to the first row in column A as cell A1 and the seventh row in column C as cell C7 When using Excel you enter your data into worksheet cells Enter Data To move to a cell move your mouse pointer to the cell and then click in it The cell becomes the
5. your e mail address Type your password Click OK The Save As dialog box appears Click Save Excel saves your file to your SkyDrive account Save s gt OO File name Sarnple Filextax Save as type Enoed Workbook iake Authors Denise Tags Ade a tag Title Add a title Subject Specify the subject Manager Specify the manager Company Hewlett Packard Categories Add a category Commens Add comments E Save Thumbnail You can sign in to SkyDrive from Excel Click the File tab A menu appears Click Share The Share Pane appears In the Share Pane click Save to SkyDrive The Save to SkyDrive pane appears Next to Go To click SkyDrive You are taken to http skydrive live com You can log in to SkyDrive If you are already logged in you can access your SkyDrive files From Excel you can create new SkyDrive folders Log in to SkyDrive from Excel In the SkyDrive pane click New Folder Excel takes you to the Create a Folder page Enter the folder name in the Name field In the Share With field select how you want to share the file Click Next The Application creates the folder and provides you with an opportunity to upload files Click Browse Locate and click the file you want to upload Click Open You can upload up to five files at one time Click Upload SkyDrive uploads the files To add additional files click Add Files J Jaidey e e peyies suey Create a File Us
6. E A A ar e BEI o at puet remem Cra Ride vors areal s o 2 ie cee cee B co eae z ddr Part Ceria i Sort ic ita kero a 5 A E ee a a peta a ara SERN Lae g ita Shaan a R a Him x ma al a PEO aT a ae ee aa Select Noncontiguous Cells Click the corner of the first block of cells Drag the mouse to highlight the desired cells Press Ctrl Repeat Steps 1 and 2 to select the next block of cells 60 OO Repeat Steps 3 and 4 to select additional cell ranges Select Columns or Rows Click the label for the first column or row you want to select 2 Drag to the last column or row you want to select Excel selects the columns or rows el fa Sede Seb neat Fare 3 krm mat galr Perel Co Fide Yaw darckal a ows F Pa m r J Benem E aF j uber 1 J a me E Bo comm H z3 E Fi 4 ae k rooe a a Ae Stein er fey o y g iedh Conn ra ea E a 18 J F Fivwhrg ai kk 2am iraa A pz Seer roafhant a Fent z ziji a miwn shiwi one ore He i Fa a al a a ail alt E sl 1 J Jaidey e e 7 3 a L x et H e pi o lo 11 je i V 13 ct ua o 15 z if amp aT sim1 TEE CU LED CIE EEIE Fae cee Wiren Earl c as ad ie Lowe H E a aan aw ray Corde a ini Pi k rD grl ar A all G ao A 1 F a ace Coro Call ne FaracHing wi ekk Belo iraa A pez Seer smin one i You can easily select all cells with formulas comments conditi
7. Excel document while you are staying in a hotel you can update it With the Microsoft Excel Web App you can use the hotel s community computer to make the changes even if it does not have Excel on it You can use the Web App in any supported browser Internet Explorer Firefox or Safari The Microsoft Excel Web App is part of Windows Live a collection of free services offered by Microsoft that include e mail photo sharing personal Web pages and more The Web based application is included in SkyDrive You can use SkyDrive to store files online and share them Upload a File to Excel s Web Based Application with others To sign up for TRUSS or to sign in to your SkyDrive account go to http skydrive live com Signing up for a SkyDrive account is easy Just click the Sign Up button and the Web site will prompt you through the process If you have a Hotmail Xbox LIVE or any other type of Windows Live account you already have a SkyDrive account You can use the Save to SkyDrive option in the Share section of BackOffice to save documents to SkyDrive The Save to SkyDrive option lets you save any open file to a SkyDrive folder By default you have two SkyDrive folders Public and My Documents Documents you save to the Public folder are available to everyone Documents you save to the My Documents folder are available only to you You can also access an Excel file from a Share Point server that is running Web Apps
8. Introducing Data 2a Analysis with Excel po Bua n Way Gz his book is about using Microsoft Excel to analyze your data Microsoft Excel is an electronic worksheet you can use to perform mathematical financial and statistical calculations create charts analyze your data with a PivotTable maintain lists and much more Excel can help you locate data find trends in your data and present your data to others Each Excel file is a workbook Each workbook can have multiple worksheets Worksheets are made up of rows and columns of cells you can use to enter information The most powerful feature in Excel is its ability to calculate When you enter a formula into Excel Excel can automatically calculate the result and when you make changes to your worksheet Excel can automatically recalculate Introducing Data Analysis with Excel You can also use Excel to create charts A chart is a graphical representation of your data When using Excel you can choose from several types of charts including Column Line Pie Bar Area and Scatter Charts can make your data easier to read easier to understand and easier to compare A PivotTable is an interactive table you can use to analyze data A PivotTable gives you an easy way to summarize and view large amounts of data Using a PivotTable you can rotate rows and columns of data so you can see different views of your data easily You can use Excel to create PivotTables Exc
9. SS a Se aa eae Sewn 1 EWployee Name 2 Salary Employes Hire Date 2 Jahn Smith a ow 8 Benim xX TE fFodac H T9 Ttk aac La A fier Serd nave Feng a ber E A f enas dog Bs ie ee ee e ee aanw a i na E amp z il dee ee E aS H tee hiner a Hin Enter Numbers as Text Click ina cell Type an apostrophe followed by the number Click Y on the formula bar Excel enters the number as text Alternatively press Enter If you receive an error click the Error button and then click Ignore Error Enter Dates Click ina cell Type the date Click a on the formula bar Excel enters the date Alternatively press Enter JHI Sr Fiia eaba ranak A F BIJ e at paet OD Se sorna 5 Ciir e 5r Emha Ey A is Rehm Er H Sree a ta oe a us Yas se Ei odi H TA 7 relie FambHing ai bk Selo m boom afe Piers feed a hon rajina a Himi 4 ye HA PE 3 Bld gt le Fates Tarkabal Wir nrcu Faced F Ermm Ikem Imat galr Perel Cra Fide vi darckal a ows Q cee cle E oe S90 7 A ey Dade Fart T r J r z z ai 3 Cerdiace one fall abe Tits ce i F EAR trli lt o os ua Fimkiing ai kk Aa iraa A pz teei caaan a Ford z sajium z Hiwi x ihi THA rana int i B SAEN Fe SS el ees TE ae a When you enter numbers as text an Error button may appear Excel is checking to see if you entered the number as text by mist
10. ake You should click the button and then click Ignore Error When you press Enter after typing an entry into a cell by default Excel moves down one cell If you want Excel to move to the cell to the right press the right arrow key or the Tab key If you want Excel to move up press the up arrow key If you want Excel to move to the left press Shift Tab or the left arrow key By default when you press the Enter key after typing an entry Excel moves down one cell You can change the default location to which Excel moves Click the File tab A menu appears Click Options The Excel Options dialog box appears Click Advanced Make sure the After Pressing Enter Move Selection check box is selected and then choose Right Up or Left in the Direction field to cause Excel to move right up or left when you press Enter Click OK J Jaideyp e e pezieis suey Select Cells efore you can execute an Excel command you must select the cells to which you want the command to apply For example if you want to bold several cells you start the process by selecting the cells The most common way to select cells is to click and drag Excel highlights the selected cells The range of cells you select does not have to be contiguous You can hold down the Ctrl key as you click and drag to select multiple ranges of cells If you select multiple ranges of cells Excel highlights each selected range If you do not hold down the C
11. e working Using the Mini Toolbar and Context Menu Right click The Mini toolbar and context menu appear Click a button or menu option to select a command Excel executes the command inthis example Excel applies a fill When you select within a cell or other object the Mini toolbar appears automatically To prevent it from appearing click the File tab and then click Options The Excel Options dialog box appears Click General The General Options for Working with Excel pane appears Deselect Show Mini Toolbar on Selection changes to L Click OK You cannot easily prevent the Mini toolbar from appearing when you right click EHIS Liag the bira Tonlar eal Cerne blami ikr Mbit Furr Su Ermm Ikem Iran Fag iyat amaie Duin nan Ww Anat Bo 8 ies 1G x uber te xy a E tare Hii mg ie T aT an kir Parte Er Te r Da 7 E 7 eo ot Cinbo Poot Ca eet Tik F a ds w mja Ea od narating caTugie Shdess bees Os peere seei a anne agren d RUTE m WER Ka bene By i A ipartar C an MEIE E Y NR Prsa 2 Quarter 1 Oui a Product 1 184 305 169 279 189 869 154 687 U a Product 2 183 929 180 350 141 615 154 434 i A n Product 3 134 707 169 785 181 375 152 320 e Product 4 157 119 138 726 169 986 104 956 FN 7 Product 5 138 946 120 340 194 525 174 138 coun u Product 6 135 883 157 200 136 642 140 075 Besa A 934299 935710 1 004 012 881810 7 13 BB renl
12. el provides a way for you to create and maintain lists A list is a series of rows and columns Each column has a label for example name address telephone number Each row under a column has information pertaining to the column label You can sort filter and analyze your lists in Excel Open a New Workbook Click the File tab A menu appears Click New Double click Blank workbook Excel opens a new workbook Ered krima Fir Seu lkm Trur Fag ipat t Coie Gnas View Tava cpa cbai au bai biptarcplie Fr Tp EY h a aA e Cael nent Ferra Drude we ES a a b hae Ell 7 Ew riri n0 D BIJ e rur mgit erae Daa as er oa 2 FR cas ie ey g BF ams ms aeri a Paria a Er Te e E i ho n ia ar ine eat ane z ar Aa m g i wie E Bo id enat A e an Muran T we Pe Fr Fite Ta HTE ant roam al 7 ee eee OTE SS ES a ea Ki Ss e Rs eee ee l e e le le le le z H Hra ola aes E a FT fy A Tour the KA A iy on Bre itt aee an ADUS ws hen you open an Excel workbook Excel It may not be exactly the same because Excel renders presents the Excel window You use the windows based on the size of your screen the window to create Excel documents Your resolution to which your screen is set and the other window should be similar to the one in the illustration screen display options I Jaidey e e View of the Excel Window
13. eres 11 a Israi ik i ee E ax Wariat d 15 16 if FH Sdeealt flea ai Ti 7 rs Ej H gt Iig tir Mind Toni arad Corr even sky BAtcrvewe t Fore ao oth Ce wia as Ce Bog 8 yk ai els cr llan 7 imie Ir e i n e ee 5 ue Ze E gt Feats a A at 4 narating sa Tugie Sheds Peter Os pier Select Tai a wr z N a e TA DA Fna al i E O R E S E i a Product 1 184 305 163 279 185 569 154 687 a Product 2 183 929 180 250 141 615 154 434 Product 3 134 707 169 785 181 375 152 320 e Product 4 157 113 138 726 169 98 104 956 7 Product 5 138 946 120 340 194 525 174 138 u Product 6 135 883 157 200 176 642 141 075 Tl 934 299 935 710 1 004 012 881 810 ial 1 12 13 aa 1s 16 17 4 E H mirall wal ed Be les mee elate e e pezieis suey Select Options on the Status Bar he status bar appears at the bottom of the Excel window It displays the status of several options For example the Zoom button appears on the status bar It displays the current zoom level You can click the Zoom button to open the Zoom dialog box and manually set the zoom level The Zoom slider also appears in the status bar You can drag it to the right to zoom in thereby making the contents of your worksheet larger or drag it to the left to zoom out thereby making the contents of your worksheet smaller When you right click the status bar you can select which options appear on it Several options such as t
14. ew options appear Click an option to select it Excel opens the option s pane Ooi cy E e ee a EN J Jaidey e e To save an Excel document click the Save button lH on the Quick Access Toolbar or click the File tab and then click Save You can also click Save As to save a document under another name payieis suey To open a document click the File tab and then click Open The Open dialog box appears Locate and click the document you want to open and then click the Open button TJI ld I re Near cveuliay Farkdage Weak Erret Fare wf Do Th tema mus agalyeuk femsa Cra Rede vr arc a Bo 8 i f H F Rehim Er Cerah 7 i ea H H z z s am omn E i Mae 3 a UG FPivwhirg ai kk 2A Pirena gt be z x ee IHA iy ai ober 0 A Z ie Teras Pop BP a A a E e LE Li a Him ofz a m z a u ehl je z e e 17 E WHA arjr Near aseuliny Farkdagr Wraak Wirion Ferl lkrn at aga ryck Termii Cra Fee TEA Daskor Fee Infornalion aboul Understanding Hacks Lage View Cbs BPT facie a ne AD Aaa ba Te ak agi ee baer 21 ink Parmimiona PT OT aT epar cany ad cag re par ache ig BI Thae meni fimi cards hese AHAA Fee Malas Upload a File to Excel s Web based Application ith the Microsoft Excel Web App you can create and edit an Excel workbook even if you are on a computer that does not have Excel installed For example if your office e mails you an
15. he Zoom slider Zoom button and Macro Recorder appear by default Select Options on the Status Bar You can automate the tasks you perform in Excel by recording a macro By default the Macro Recorder button H appears on the status bar Click the Macro Recorder button to begin recording a macro The Record Macro dialog box appears Fill in the fields and then perform the steps you want to automate When you are finished performing the steps click the Macro Recorder button again See Chapter 14 for detailed information Right click the status bar A list of options appears Selected options have a check mark Deselected options do not have a check mark Click options to select or deselect them O changes to or changes _ Selected options appear on the status bar Some options only appear when appropriate EHI o gt r LivalerctoumBieg the Sans Taraba o Bin Fred ar D th oe rur mgp erae Daa os e Aat aora yf F w a 7 ae merir ET aS g 2 e a ae E E ia Ed wke H iT h SR CMe et aldni me Bei nlad e Eunan Termi E PO rare STEL T Ti iit F miT m THF bem al i E EE a FESS el a a a a 1 ncaa aE 7 Quarter 1 Quarter y ri amr 3 Producti 5 184 305 5 165 2 Jonata m iSi biaraber h ima ar a Product 2 183 939 LOH pees N rel s Product 3 134 707 LBS 7N antag x 6 Product 4 157 115 138 7 Halek E 7 wad ie Ho 7 Product 5 138 945 120 3477 parcer cal u Product 6 135 883 157 2 0 Gra
16. ing Excel s Web based Application ou can create Excel files with Excel s Web based application For example if the computer you are using does not have Excel you can sign in to SkyDrive and create an Excel worksheet The look a feel of the Excel Web based application is the same as the desktop application To issue commands you use the Ribbon For the most part the commands work exactly as they do in the desktop application Therefore as you are learning Excel you are also learning the Web based application You will find however that the commands available to you are limited and are not as sophisticated as they are in the desktop application If you upload a file to SkyDrive you can view most features For example you can upload and view a PivotTable and the sort and filter buttons are available to Create a File Using Excel s Web Based Application Sign in to SkyDrive Click the folder where you want to store the file You move to the folder Click New A menu appears Click Microsoft Excel workbook you However you cannot create a PivotTable in the Web based application You can view a chart but you cannot create a chart If you edit the data a chart is based on the chart will update You cannot view comments shapes and a few other objects when using the Web based application If a workbook has any objects that you cannot view the Web based application will warn you when you a
17. l farey Tann of Las The New Microsoft Excel workbook page appears Type a name Click Create The Microsoft Excel Web App opens Create your document Click a path location Exit the file You do not need to save the file Click here to sign out bin ice dima Ot RRA tear eraaurastesseatasea stydrsbeccermececaroticm bod Ilaaha Py gt A eee E Westra Qe lattice Sieted ates bach wands bh bor Yea bgo beokoda Jose bhip e T w r A hipa oi NER ro ioe pdre saam a bad Dela Anchen ratei ska patom TI T H voozs E Weetintes Ge hrpe o te harie L IaJdeyy e e Cerherty Swer Reradsome Hapel Abasa Code cfiwided Ancor Feedbeat peyieis suey Gj Aae tea ky ide rper aba Min E fel ee o os a H ram Paie cy E a g g D S A Ogie rari F A i Sales F a Product 1 Product 2 Product 3 Biret f oe a a You can view a workbook in SkyDrive Sign in to Sky Drive Click the folder where you saved the file Click the file and then click View The file opens in the Web based application If you want to edit the file click Edit The file opens in the Microsoft Excel Web App and you can edit the file You can edit a workbook in SkyDrive Sign in to Sky Drive Click the folder where you saved the file Click the File Click Edit The file opens in the Microsoft Excel Web App You can edit the file Click a path location at the top of the
18. le of a font are in the Font group Some commands you use to insert objects into a worksheet are groups have a launcher When you click the launcher a on the Insert tab the commands you use to layout your menu or dialog box appears You can use the menu or document are on the Page Layout tab and so on dialog box to access additional commands Ribbon Commands The Ribbon contains commands i GR ss organized in three components tabs aaa cea groups and commands Tabs appear Bam a E b a Fp T A across the top of the Ribbon and 7s hee SPA enw Marie Hea cayF MLSRSeae contain groups of related commands Groups organize related commands with each group name appearing below the group on the Ribbon Note some groups have a Dialog Box Groups Dialog Box Launcher Launcher button in the lower right corner Commands appear within Tabs appear across the top Commands are This button appears in the each group of the Ribbon and contain arranged into groups lower right corner of many groups of related commands with the group groups on the Ribbon The File tab provides access names shown at the Clicking this button opens a to the Backstage view in all bottom of the tab dialog box menu or task Office programs In pane that provides more Backstage view you can options open save and print worksheets Contextual Tabs Tabs Galleries Some tabs only appear when needed These tabs are called Galleries provide you with a list
19. of choices As you hover contextual tabs For example the tabs that you use to edit over each gallery choice Excel provides you with a live a chart only appear when you are modifying a chart preview of how your document will appear if you choose that option For example in Excel you can apply a style to Chart Tools a table When you hover over a style in the Table Styles ee l gallery Excel provides you with a live preview of how the Design Layout style will appear if you choose it CE ee Mb ih a Ea m imn wee s Ti TIRE HHHPH TIR F HE jit Mon A a0 ree Selves corr See menes fers u La Tyler Region 4 Mio eer EHE WANN EE Sere mO LIM a z1 xcel makes some commands readily available via the Mini toolbar and the context menu When you right click in Excel the Mini toolbar and a context menu appear Most often the Mini toolbar appears first and the context menu appears under it What appears on the Mini toolbar and context menu depends upon what you are working on at the time you right click For example if you right click while you have a range of cells selected options related to modifying cells appear If you right click while you are modifying a chart options related to modifying a chart appear In general you can use the Mini toolbar to perform popular formatting commands You can use the context menu to perform popular commands related to the object on which you ar
20. onal formatting constants or data validation Click the Home tab Click Find amp Select in the Editing group A menu appears Click the option you want Excel selects all the cells that contain the option you selected For example if you chose Formulas Excel selects all the cells that contain formulas You can also use the arrow keys to select cells Click in any cell hold down the Shift key and then use the left right up and down arrow keys to expand your selection You can press Ctrl Shift an arrow key to select everything from the active cell to the next blank cell that is to the right to the left above or below the active cell You can press Ctrl Shift to select a block of cells You will find this option particularly useful with large tables For a list of keyboard shortcuts see the Appendix
21. s vak F Fad hair Ei E 334 893 9357 i Here Seades Hr Earring i fe Savage Bode 11 lz Espira i2 F imr 7 F Drin i3 Maurie Ceurt lE Hirman aw i6 fe Ua ead Sh it dhe ikari a ir Iu jE 11FH Spell whit E J peN i EH 5 r Livalerctorabeg the Sias Draba irai Freed e O th e rur mgit erae Daa as e Aast sorg X l 4 A aiem Lr ee Cuber le moe E Er Guns Hi mp H Diekie J Ww ith ENE A P EA E pe EE A E AE A a bel E on c Gi a S peter ET E ERa OPTEL TLI wt iin F Pirtti Ts THR bem tH A wen E SSS eS Se a ee eed TE EE a z Quarter 1 Product 1 5 184 305 a Product 2 183 939 Product 3 134 707 6 Product 4 157 115 7 Product 5 138 945 ou Product 6 135 583 a 934 899 935710 1 004 012 881 810 10 11 Take a Look at Backstage View he File tab is located in the upper left corner of the Excel window When you click the tab you are moved to an area Microsoft calls Backstage view You can use this area to do such things as open a file save a file print a file review a file or set Excel options In short to create and edit your document you use the Ribbon to work with your document you use Backstage view The commands you need to open a new or existing document to set document properties or to share a file by printing e mailing or faxing are all located in Backstage view Take a Look at Backstage View Click the File tab The Backstage vi
22. trl key Excel deselects the first range of cells when you begin to select a new range of cells You can select a single cell or the entire worksheet To select a single cell click in the cell To select every cell in a worksheet click the Select All button or press Ctrl A To select an entire row or an entire column simply click the row or column identifier For example to select all the cells in column C click the C identifier for the column To select multiple columns click the first column and then continue holding down the mouse button as you drag to the other columns you want to select To select entire rows Click the row identifiers on the left side of the rows You can quickly select a large range of cells by clicking in the first cell you want to select holding down the Shift key and then clicking in the last cell you want to select Select the Entire Worksheet Click the Select All button Alternatively press Ctrl A Select Contiguous Cells Click the first cell Drag to the last cell Alternatively click the first cell hold down the Shift key and then click the last cell Ej ed I le een Sakae a S i ru if lkr Tape leuk Termii Cr Fade YA darckal s ow 8 i e Di E Ar a F Cenas HE F x a WA ad Parie k roe oa Cerdana fants fall Iti F t H fool 234 reg a ee Pe a ae fina a bend ig wr x Hiner Syw saa al 1 me EH Siell Srel et ro ija 1 E Ej H 8 amp r E
23. ttempt to view the workbook You can view a workbook that has objects you cannot view in it but you cannot edit it If you need to edit the workbook use the File menu to make a copy of the file and then edit the copy All the functions that are available to you in Excel are available to you in the Web based application bis adr gen Papen Eoorate Lera Hele T x a ies brape ech Erkka asa tive Inve Ty 4 p OL PUTT a yepi IL Kety A Geto Stetes o Later med rar x H FEFE Aene Takih Wre ap Aree r eerie Lis worn wr in Gold pte r e E nidars repair iskier Ane tiea A fuie Recent folders Merari ute rT Related paras j 4 2 E Princis ah PIRTIES Tem Pata Sahir aie Satins Sau Tein keg Subd fads fave lea wee oll aur history Wines jakom Whats new with your nehenrk Feppie n yar neant wari cnir aretha rew m Sv Tiree ehy irki Sods a alall in ay een Lm aww warch ie bao of La Hec Alege wWedkoul cumal anual Feudbeat bie aor bape leoiata lama jd E 3 s a pL heo thktar eco Himan poton Uaa hiaat Gat reo Stetes o Later madd rar TE OFRER elire Talat ow A rhni iee EEs kata Muhri Wia bras liar kieti hats bee Crewe sle view tam Rancesh Perel arr dhesk SO SCR Preci pr poradi bimish Wane goon kimoscH Ceekbcte ishehcwe Shout vith Wed res Pacucl dene Sud ul Cunda Asau Teee DA Vima
Download Pdf Manuals
Related Search