[ Pobierz całość w formacie PDF ]
.com - Internet: http://www.cctglobal.com/90 Data Maps1995-2000 - Cheltenham Computer Training© Excel 2000 AdvancedFormatting a Data Map" Use the Microsoft Map toolbar that is displayedautomatically when you create or edit a Data Map© Cheltenham Computer Training 1995-2000 Excel 2000 Advanced - Slide No.54Formatting a Data MapTo reposition " Click on the Select Objects icon.items on the" Drag the required objects to a new position.mapTo reposition a " Click the Grabber icon.map within its" Drag the map around the frame to the position where you wantSAMPLE ONLYframeit and release the mouse button.To center the " Click the Center Map icon.mapNOT TO BETo add labels to " Click the Map Labels icon.a map" Select the features to label." Move the cursor over the map.When the label is visible in theposition you want it, click to place the label.To add text to a " Click the Add Text icon.USED FORmap" Place the cursor where the text is required and click once." Type the text and complete with Enter.To create a " Click the Custom Pin Map icon.custom pinTRAININGTo view whole " Click the Display Entire icon.mapTo redraw a " Click the Redraw Map icon.data mapSAMPLE ONLY NOT TO BE USED FOR TRAINING© Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200Email: sales@cctglobal.com - Internet: http://www.cctglobal.com/Data Maps 91Excel 2000 Advanced ©1995-2000 - Cheltenham Computer TrainingReview Questions© Cheltenham Computer Training 1995-2000 Excel 2000 Advanced - Slide No.55Review Questions - How Would You.1.Place data onto a map?2.Format a Data Map?SAMPLE ONLYNOT TO BEUSED FORTRAININGSAMPLE ONLY NOT TO BE USED FOR TRAINING© Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200Email: sales@cctglobal.com - Internet: http://www.cctglobal.com/Consolidation 93Excel 2000 Advanced ©1995-2000 - Cheltenham Computer TrainingConsolidationLearning Module ObjectivesWhen you have completed this " Consolidate data over several worksheets or worksheetlearning module you will havepagesseen how to:" Consolidate selected rows and columns from severalworksheets or pagesSAMPLE ONLYNOT TO BEUSED FORTRAININGSAMPLE ONLY NOT TO BE USED FOR TRAINING© Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200Email: sales@cctglobal.com - Internet: http://www.cctglobal.com/94 Consolidation1995-2000 - Cheltenham Computer Training© Excel 2000 AdvancedWhat is Consolidation?" This feature allows you to select blocks of datafrom several different worksheets, or differentpages of the same workbook, and combine theirvalues into a single, summary range in aworkbook" This saves time, and is easier than cutting datafrom several worksheets and pasting into one,single worksheet© Cheltenham Computer Training 1995-2000 Excel 2000 Advanced - Slide No.57What is Consolidation?To consolidate " Highlight a cell on a blank worksheet page, or a blank area of a worksheet.data over" Select Consolidate from the Data menu to display the Consolidate dialog box.several" Select the first area you wish to consolidate by clicking on the worksheet andworksheets ordragging to highlight the area required.Do not include row and column text,worksheetonly numeric data.Use the sheet tabs to change between worksheets.pages" The selection will appear in the Reference text box.SAMPLE ONLYNote: Any formulas in the source area will only be used as values, i.e.only valuesin the cells will be used in the consolidation." Click on the Add button when you have highlighted the required range.NOT TO BE" Continue highlighting and adding the remaining areas in the consolidation." From the Function drop-down list, select the function you require.The defaultis Sum which will add the data across the selected range." If you want the summary report to create linking formulas to the source dataautomatically, select the Create links to source data check box.USED FOR" Select OK to complete the consolidation.TRAININGSAMPLE ONLY NOT TO BE USED FOR TRAINING© Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200Email: sales@cctglobal.com - Internet: http://www.cctglobal.com/Consolidation 95Excel 2000 Advanced ©1995-2000 - Cheltenham Computer TrainingConsolidating Rows and Columns" Select Data Consolidate from the menu© Cheltenham Computer Training 1995-2000 Excel 2000 Advanced - Slide No.58Consolidating Rows and ColumnsTo consolidate " Insert the row or column text you want to consolidate from the source ranges inselected rows a blank worksheet page, or on a blank area of the worksheet.Ensure that youand columns type the text exactly as it appears in the source data ranges.from several" Highlight the row or column labels you entered.worksheets or" Select Consolidate from the Data menu to display the Consolidate dialogpagesbox.SAMPLE ONLY" Select the first area you wish to consolidate by clicking on the worksheet anddragging to highlight the area required.Make sure you include row andcolumn text in the source areas, as well as numeric data.Use the sheet tabsto change between worksheets." The selection will appear in the Reference text box.Note: Any formulas inNOT TO BEthe source area will only be used as values, i.e.only values in the cells will beused in the consolidation." Click on the Add button when you have highlighted the required range." Continue highlighting and adding the remaining areas in the consolidation." From the Function drop down list, select the function you require.The defaultUSED FORis Sum which will add the data across the selected range." If you want the summary report to create linking formulas to the source dataautomatically, select the Create links to source data check box." If row text was entered at the first step, select the Top row check box in theUse labels in area.If column text was entered, select the Left column checkbox [ Pobierz caÅ‚ość w formacie PDF ]