Microsoft ® Office Exceed expectations ® 2003 Preparing.


93 views
Uploaded on:
Category: Home / Real Estate
Description
CGI presents: Microsoft ® Office Exceed expectations ® 2003 Preparing Incredible Exceed expectations highlights Course substance Outline: Five extraordinary components Lesson 1: Stop! Lesson 2: Analyze one next to the other Lesson 3: Total it up, and that's just the beginning (Proceeded next slide.) Course substance, cont'd. Lesson 4: Sort less, get more
Transcripts
Slide 1

CGI presents: Microsoft ® Office Excel ® 2003 Training Great Excel highlights

Slide 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 highlights

Slide 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 highlights

Slide 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 highlights

Slide 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 highlights

Slide 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 highlights

Slide 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 highlights

Slide 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 highlights

Slide 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 highlights

Slide 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 highlights

Slide 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 highlights

Slide 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 highlights

Slide 14

Test 1, question 1 The Freeze Panes order is on the Format menu. (Pick one answer.) True. False. Extraordinary Excel highlights

Slide 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 highlights

Slide 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 highlights

Slide 17

Test 1, question 2: Answer The line underneath the titles. To stop titles, select the column beneath, not the genuine titles. Incredible Excel highlights

Slide 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 highlights

Slide 19

Test 1, question 3: Answer The cell that is beneath the section titles and to one side of the column titles. Extraordinary Excel highlights

Slide 20

Lesson 2 Compare one next to the other

Slide 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 highlights

Slide 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 highlights

Slide 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 highlights

Slide 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 highlights

Slide 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 highlights

Slide 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 highlights

Slide 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 highlights

Slide 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 highlights

Slide 29

Test 2, question 1: Answer On the Window menu. You can see two exercise manuals plainly now. Incredible Excel highlights

Slide 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 highlights

Slide 31

Test 2, question 2: Answer One on top of the other. That is the way Excel sees it. Awesome Excel highlights

Slide 32

Test 2, question 3 You can explore just from the top worksheet. (Pick one answer.) True. False. Incredible Excel highlights

Slide 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 highlights

Slide 34

Lesson 3 Sum it up, and that\'s only the tip of the iceberg

Slide 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 highlights

Slide 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 highlights

Slide 37

And the aggregate is See the picture at left. Chosen numbers. Complete in the status bar at the window\'s base. Awesome Excel highlights

Slide 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 highlights

Slide 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 highlights

Slide 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 highlights

Slide 41

Test 3, question 1: Answer Press and hold down CTRL while you select every number. Extraordinary Excel highlights

Slide 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 highlights

Slide 43

Test 3, question 2: Answer Right-tap the status bar. Extraordinary Excel highlights

Slide 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

Recommended
View more...