CGI presents: Microsoft Â® Office Excel Â® 2003 Training Great Excel highlightsSlide 2
Course substance Overview: Five extraordinary elements Lesson 1: Freeze! Lesson 2: Compare one next to the other Lesson 3: Sum it up, and that\'s just the beginning (Continued on next slide.) Great Excel highlightsSlide 3
Course substance, contâd. Lesson 4: Type less, get more Lesson 5: Call thoughtfulness regarding the great or the awful Each lesson incorporates a rundown of proposed errands and an arrangement of test inquiries. Incredible Excel highlightsSlide 4
Overview: Five awesome elements Isn\'t it extraordinary when something is simpler than you suspected? Like keeping titles in perspective when looking down a worksheet, or selecting so as to include numbers just them? In this course youâll find out around five extraordinary Microsoft Â® Office Excel Â® 2003 components that will help you to work speedier and simpler. Extraordinary Excel highlightsSlide 5
Course objectives Freeze the upper and left sheets to keep section or line titles in perspective while you look through information. Think about two exercise manuals in the meantime by utilizing the new Compare Side by Side component in Microsoft Office Excel 2003. Include numbers just by selecting them. Utilize the fill handle as opposed to writing to finish tedious arrangement of numbers, dates, or content. Roll out designing improvements consequently when qualities are at one point by utilizing restrictive organizing. Incredible Excel highlightsSlide 6
Lesson 1 Freeze!Slide 7
Freeze! Envision looking down the Excel worksheet in the photo. As you look over, the segment titles vanish. At that point you ponder, do the numbers in segment G allude to Units in Stock or Units on Order ? Segment titles vanish after looking over. Extraordinary Excel highlightsSlide 8
Freeze! See the picture at left. Section titles in line 1. Section titles vanish subsequent to looking down maybe a couple columns. Segment titles vanish after looking over. Incredible Excel highlightsSlide 9
Divide and vanquish To keep titles in sight: Divide or split the worksheet by solidifying the titles in their own sheet. The title sheet is then secured as you look through whatever remains of the worksheet. Stop titles in their own sheet. Extraordinary Excel highlightsSlide 10
Divide and overcome You can see the outcome in the photo. The titles, isolated from the worksheet information by a flat line, are still obvious over the highest point of column 10. Snap Freeze Panes on the Window menu. Section titles are separated from whatever remains of the worksheet by a level line. Stop titles in their own particular sheet. Awesome Excel highlightsSlide 11
Freeze here It\'s not simply segment titles that you can solidify set up. You can likewise stop line titles, or you can solidify both in the meantime to keep both section and column titles. Try not to choose titles to stop sheets Great Excel highlightsSlide 12
Freeze here To stop: Column titles, select the first line underneath the titles. Line titles, select the first section to one side (for instance, to keep supplier names in sight as you look over the worksheet). Both section and line titles , click the cell that is both just underneath the segment titles and just to one side of the line titles. Try not to choose titles to stop sheets Great Excel highlightsSlide 13
Suggestions for practice Freeze and unfreeze segment titles. Stop and unfreeze line titles. Solidify both section and line titles in the meantime. Keep titles in sight when you print. Online practice (obliges Excel 2003) Great Excel highlightsSlide 14
Test 1, question 1 The Freeze Panes order is on the Format menu. (Pick one answer.) True. False. Extraordinary Excel highlightsSlide 15
Test 1, question 1: Answer False. Select what you need to stop, and after that snap Freeze Panes on the Window menu. Incredible Excel highlightsSlide 16
Test 1, question 2 To stop section titles, you would choose: (Pick one reply.) The column underneath the titles. The second cell in the first column underneath the titles. The primary segment. Incredible Excel highlightsSlide 17
Test 1, question 2: Answer The line underneath the titles. To stop titles, select the column beneath, not the genuine titles. Incredible Excel highlightsSlide 18
Test 1, question 3 To solidify both section and line titles, you would choose: (Pick one reply.) The second segment. The third section. The cell that is underneath the segment titles and to one side of the line titles. Awesome Excel highlightsSlide 19
Test 1, question 3: Answer The cell that is beneath the section titles and to one side of the column titles. Extraordinary Excel highlightsSlide 20
Lesson 2 Compare one next to the otherSlide 21
Compare one next to the other Have you ever needed to think about the substance in two unique exercise manuals in the meantime? This lesson demonstrates to you proper methodologies to utilize the new Compare Side by Side element to look at spending plans for two offices in two exercise manuals. Contrasting two exercise manuals Great Excel highlightsSlide 22
See both exercise manuals in the meantime Imagine that you have two exercise manuals. One is the financial backing for the Sales office and the other is the monetary allowance for the Marketing office. You\'d like to contrast both exercise manuals with see the distinctions in anticipated costs between the two offices. Look at two exercise manuals in the meantime. Extraordinary Excel highlightsSlide 23
See both exercise manuals in the meantime In the photo on the left, the Window menu demonstrates that both exercise manuals are as of now open. Since Marketing is in view, the second\'s name worksheet, Sales , is recorded after the Side by Side order. To see both exercise manuals in the meantime, you snap Compare Side by Side with Sales . Think about two exercise manuals in the meantime. Incredible Excel highlightsSlide 24
Scroll through exercise manuals in the meantime Worksheets from both exercise manuals will open, with one at the highest point of the window and the other in the window\'s base. The truth is out, in Excel âside by sideâ implies one on top of the other, however you can change the introduction from one on top of the other to one by the other in the event that you need. Activity: Right-snap, and snap Play . Awesome Excel highlightsSlide 25
Scroll through exercise manuals in the meantime Worksheets from both exercise manuals will open, with one at the highest point of the window and the other in the window\'s base. Truth is stranger than fiction, in Excel âside by sideâ implies one on top of the other, yet you can change the introduction from one on top of the other to one by the other in the event that you need. Incredible Excel highlightsSlide 26
Scroll through exercise manuals in the meantime As you look through the first worksheet, the second worksheet parchments right along, keeping pace with you and making it simple to think about the contrasts between the two division spending plans. Incredible Excel highlightsSlide 27
Suggestions for practice Compare two exercise manuals in the meantime. Change one next to the other introduction. Close the one next to the other perspective. Online practice (obliges Excel 2003) Great Excel highlightsSlide 28
Test 2, question 1 Where is the Compare Side by Side order found? (Pick one answer.) On the Window menu. On the Data menu. On the View menu. Incredible Excel highlightsSlide 29
Test 2, question 1: Answer On the Window menu. You can see two exercise manuals plainly now. Incredible Excel highlightsSlide 30
Test 2, question 2 What does next to each other mean in Excel? (Pick one answer.) One alongside the other. Accepting the cold hard facts together. One on top of the other. Incredible Excel highlightsSlide 31
Test 2, question 2: Answer One on top of the other. That is the way Excel sees it. Awesome Excel highlightsSlide 32
Test 2, question 3 You can explore just from the top worksheet. (Pick one answer.) True. False. Incredible Excel highlightsSlide 33
Test 2, question 3: Answer False. You can explore from either the top or base worksheet. Click in the worksheet you need to explore into enact the parchment bars in that sheet. Extraordinary Excel highlightsSlide 34
Lesson 3 Sum it up, and that\'s only the tip of the icebergSlide 35
Sum it up, and all the more Quick: What\'s the aggregate of the chose numbers in the photo? Regardless of the possibility that you\'re quick at doing math in your mind, Excel can likely get the answer before you do. What\'s the aggregate of the chose numbers? Incredible Excel highlightsSlide 36
And the aggregate is All you need to do is...wait, the aggregate is now in the status bar at the window\'s base: Sum=$235.35 . As you select the numbers, Excel naturally includes them up and shows the aggregate in the status bar. Incredible Excel highlightsSlide 37
And the aggregate is See the picture at left. Chosen numbers. Complete in the status bar at the window\'s base. Awesome Excel highlightsSlide 38
Want more? Need a normal? Select the numbers, and right-tap the status bar. Snap Average on the alternate way menu, which gives you the number juggling mean. The answer in the status bar changes from a total to Average=$39.23 . Awesome Excel highlightsSlide 39
Suggestions for practice Select numbers and see the total. Include numbers that are not back to back. Accomplish more than total. Online practice (obliges Excel 2003) Great Excel highlightsSlide 40
Test 3, question 1 How would you choose numbers to include that are scattered in distinctive lines or sections? (Pick one answer.) Press and hold down CTRL while you select every number. Press and hold down SHIFT while you select every number. Press and hold down CTRL+SHIFT while you select every number. Incredible Excel highlightsSlide 41
Test 3, question 1: Answer Press and hold down CTRL while you select every number. Extraordinary Excel highlightsSlide 42
Test 3, question 2 How would you change the outcome from Sum to Average? (Pick one answer.) Click Validation on the Data menu. Right-tap the status bar. Click Formula Auditing on the Tools menu. Awesome Excel highlightsSlide 43
Test 3, question 2: Answer Right-tap the status bar. Extraordinary Excel highlightsSlide 44
Test 3, question 3 If you don\'t see the aggregate in the status bar, click Status Bar on the _____ menu to turn the component on. (Pick one answer
Microsoft Office 2003 Outlined Basic, Premium Version Presenting Microsoft Office 2003 Destinati ...
Exceed expectations Lesson 1 Exceed expectations Nuts and bolts Microsoft Office 2007: Early on ...
Compudyne presents: Microsoft ® Office Exceed expectations ® 2007 Preparing Get up to speed Co ...
Microsoft Exceed expectations 2002 Instructional exercise 1 – Utilizing Exceed expectations To ...
Proposition On Advancement Of Microsoft Exceed expectations 2000 By Chan Wing Tai Prelude To The ...
Exceed expectations Instructional exercise 1 Beginning with Exceed expectations. Targets. Compre ...
Microsoft Office Exceed expectations 2003. Instructional exercise 10 – Utilizing Solver For Co ...
Microsoft exceed expectations is one of the projects incorporated into the Microsoft Office Pack ...
Click on begin, programs Microsoft Excel. Click on open new report. Another exercise manual will ...
Visual SourceSafe ???. ?????? (Code Librarian) MOD ?? Office ????. ??????. ?????? (COM Add ... ? ...
Mix Tutorial 1 Integrating Word and Excel. Targets. Find out about article connecting and instal ...
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition ... Microsoft Office 2007- ...
What to Know. What is ExcelWhat is a SpreadsheetThe Excel WindowToolbars (Shortcut Bars)The
. . . . . . Review of the accessible Excel Format optionsExcel Report BurstingExcel Compound Rep ...
Solving Equations with Excel Solver for Microsoft Excel 2000. A Simple Problem. grades, gr ...
Excel 2010 Training. Microsoft Excel is a popular spreadsheet program that is part of the Mic ...
New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 5. 2. Recognize the com ...
New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 2. 2. Utilize Excel\'s ...