Microsoft ® Office Exceed expectations ® 2007 Preparing.


88 views
Uploaded on:
Category: Business / Finance
Description
Compudyne presents: Microsoft ® Office Exceed expectations ® 2007 Preparing Get up to speed Course substance Outline: A hands-on presentation Lesson 1: What's changed, and why Lesson 2: Get the chance to work in Exceed expectations Lesson 3: another record design
Transcripts
Slide 1

Compudyne presents: Microsoft ® Office Excel ® 2007 Training Get up to speed

Slide 2

Course substance Overview: A hands-on presentation Lesson 1: What’s changed, and why Lesson 2: Get to work in Excel Lesson 3: another document organize The initial two lessons incorporate a rundown of proposed assignments, and all incorporate an arrangement of test inquiries. Get up to speed

Slide 3

Overview: A hands-on presentation Excel 2007 has another look! It’s got the natural worksheets you’re acclimated to, yet with a few changes. Remarkably, the old look of menus and catches at the highest point of the window has been supplanted with the Ribbon . This course demonstrates to you proper methodologies to utilize the Ribbon and highlights alternate changes in Excel that will assist you with improving worksheets, quicker. Get up to speed

Slide 4

Lesson 1 What’s changed, and why

Slide 5

What’s changed, and why Yes, there’s a great deal of progress in Excel 2007. It’s most detectable at the highest point of the window. In any case, it’s great change. The orders you need are currently all the more unmistakably noticeable and all the more promptly accessible in one control focus called the Ribbon . Get up to speed

Slide 6

What’s on the Ribbon? The three sections of the Ribbon are tabs, gatherings, and summons. Tabs: Tabs speak to center undertakings you do in Excel. There are seven tabs over the highest point of the Excel window. Gatherings: Groups are sets of related orders, showed on tabs. Summons: An order is a catch, a menu, or a case where you enter data. Get up to speed

Slide 7

What’s on the Ribbon? How would you begin on the Ribbon? Start toward the starting. The main summons in Excel are accumulated on the first tab, the Home tab. Get up to speed

Slide 8

What’s on the Ribbon? Gatherings pull together every one of the charges you’re prone to requirement for a specific kind of undertaking. All through your undertaking, gatherings stay in plain view and promptly accessible; orders are no more covered up in menus. Rather, crucial charges are unmistakable over your work space. Get up to speed

Slide 9

More summons, however just when you require them The charges on the Ribbon are the ones you utilize the most. Rather than demonstrating each charge constantly, Excel 2007 demonstrates a few summons just when you may require them, in light of a move you make. So don’t stress in the event that you don’t see every one of the charges you require at all times. Make the first strides, and the summons you need will be nearby. Get up to speed

Slide 10

More choices, in the event that you require them Sometimes a bolt, called the Dialog Box Launcher , shows up in the lower-right corner of a gathering. This implies more alternatives are accessible for the gathering. Click the Dialog Box Launcher , and you’ll see a dialog box or undertaking sheet. The photo demonstrates an illustration: On the Home tab, tap the bolt in the Font bunch. The Format Cells dialog box opens, with superscript and different alternatives identified with textual styles. Get up to speed

Slide 11

Put summons all alone toolbar Do you frequently utilize orders that aren’t as fast accessible as you’d prefer? You can without much of a stretch add them to the Quick Access Toolbar . Movement: Right-snap, and snap Play . Play the liveliness to see the procedure of adding a catch to the toolbar and after that expelling a catch from the toolbar. Get up to speed

Slide 12

Put charges all alone toolbar Do you frequently utilize summons that aren’t as fast accessible as you’d prefer? You can undoubtedly add them to the Quick Access Toolbar . The Quick Access Toolbar is over the Ribbon when you first begin Excel 2007. There, summons are constantly obvious and close within reach. Get up to speed

Slide 13

What about most loved console easy routes? In the event that you depend on the console more than the mouse, you’ll need to realize that the Ribbon outline accompanies new easy routes. This change brings two major favorable circumstances over past variants of Excel: There are alternate ways for each and every catch on the Ribbon. Alternate ways regularly oblige less keys. Get up to speed

Slide 14

What about most loved console alternate ways? The new alternate ways additionally have another name: Key Tips . You press ALT to make Key Tips show up. For instance, here’s how to utilize Key Tips to focus content: Press ALT to make the Key Tips show up. Press H to choose the Home tab. Press A, then C to focus the chose content. Get up to speed

Slide 15

What about most loved console alternate routes? Shouldn\'t something be said about the old console alternate routes? Console easy routes of old that start with CTRL are still in place, and you can utilize them the same way you generally have. For instance, the easy route CTRL+C still duplicates something to the clipboard, and the alternate way CTRL+V still glues something from the clipboard. Get up to speed

Slide 16

another view Not just the Ribbon is new in Excel 2007. Page Layout perspective is new, as well. On the off chance that you’ve worked in Print Layout view in Microsoft Office Word, you’ll be happy to see Excel with comparable favorable circumstances. Get up to speed

Slide 17

another perspective To see the new view, snap Page Layout View on the View toolbar . Here’s what you’ll find in the worksheet: Column headings. Column headings. Edge rulers. Get up to speed

Slide 18

another perspective In Page Layout view there are page edges at the top, sides, and base of the worksheet, and a touch of blue space between worksheets. Rulers at the top and side assist you with changing edges. Different advantages of the new view: You don’t need to utilize Print Preview to discover issues before you print. It’s simpler than at any other time in recent memory to include headers and footers. You can see diverse worksheets in distinctive perspectives. Get up to speed

Slide 19

Working with distinctive screen resolutions Everything portrayed so far applies if your screen is set to high determination and the Excel window is boosted. If not, things look changed. At the point when and what do things look like changed? At low determination. In the event that your screen is set to a low determination, for instance to 800 by 600 pixels, a couple bunches on the Ribbon will show the gathering name just, not the charges in the gathering. Get up to speed

Slide 20

Working with diverse screen resolutions Everything depicted so far applies if your screen is set to high determination and the Excel window is expanded. If not, things look changed. At the point when and what do things look like changed? At the point when the Excel window isn’t amplified. A few gatherings will show just the gathering name. With Tablet PCs. On those with littler screens, the Ribbon acclimates to indicate littler variants of tabs and gatherings. Get up to speed

Slide 21

Suggestions for practice Enter content. Change section width. Change archive sees. Appear or shroud white space. Add a catch to the Quick Access Toolbar. Online practice (obliges Excel 2007) Get up to speed

Slide 22

Lesson 2 Get to work in Excel

Slide 23

Get to work in Excel The first lesson assisted you with getting focused to the new look of Excel 2007. Presently it’s time to get the opportunity to work. Say you’ve got a half hour before your next meeting to make a few amendments to a worksheet that you made in a past variant of Excel. Could you do the essential things you have to do in Excel 2007, in only 30 minutes? This lesson will demonstrat to you how. Get up to speed

Slide 24

Open your record First things first. You need to open a current exercise manual made in a before adaptation of Excel. Do the accompanying: Click the Microsoft Office Button . Snap Open , and select the exercise manual you need. Likewise take note of that you can snap Excel Options , at the menu\'s base, to set system alternatives. Get up to speed

Slide 25

Insert a segment Now you need to add a section to your worksheet to distinguish item classes. You need it to go between two existing segments of information. Liveliness: Right-snap, and snap Play . View the activity to see the procedure of embeddings a section into the worksheet. Get up to speed

Slide 26

Insert a section Now you need to add a segment to your worksheet to distinguish item classifications. It ought to go between two existing sections of information, Quantity and Supplier . Your worksheet contains lines of items requested from different suppliers, and you need to add the new section to distinguish the different items as dairy, grains, produce, etc. Get up to speed

Slide 27

Insert a section Follow this strategy to include the segment between the Quantity segment and the Supplier segment: Click in the Supplier segment. At that point on the Home tab, in the Cells gathering, tap the bolt on Insert . On the menu that shows up, snap Insert Sheet Columns . Another clear segment is embedded, and you enter the new information in the section. On the off chance that you have to conform the segment width to fit the information, in the Cells gathering, tap the bolt on Format . In the rundown that shows up, snap AutoFit Column Width . Get up to speed

Slide 28

Format and alter information You design and alter information by utilizing charges as a part of gatherings on the Home tab. For instance, the segment titles will emerge better on the off chance that they are in striking sort. To make it in this way, select the column with the titles and afterward on the Home tab, in the Font gathering, snap Bold . Get up to speed

Slide 29

Format and alter information While the titles are still chosen, you choose to change their shading and their size, to make them emerge significantly more. In the Font gathering, tap the bolt on Font Color . You’ll see numerous a larger number of hues to look over than some time recently. You can likewise perceive how the title will look in changed hues by indicating at any shading and holding up a minute. Get up to speed

Slide 30

Format and alter information You can utilize the Font gathering to deal with other arranging and altering alternatives, as well. To build the text dimension, snap Increase Font Size . While the titles are still chosen, you choose to focus them in the cells. In the Alignment gathering, snap Center . At last, you observe th

Recommended
View more...