Office
<<  Exploring Microsoft Office Word 2007 Microsoft Office Word 2007 Training  >>
Overview: A hands-on introduction
Overview: A hands-on introduction
What’s changed, and why
What’s changed, and why
What’s on the Ribbon
What’s on the Ribbon
More commands, but only when you need them
More commands, but only when you need them
More options, if you need them
More options, if you need them
More options, if you need them
More options, if you need them
Put commands on your own toolbar
Put commands on your own toolbar
What about favorite keyboard shortcuts
What about favorite keyboard shortcuts
A new view
A new view
A new view
A new view
Working with different screen resolutions
Working with different screen resolutions
Get to work in Excel
Get to work in Excel
Open your file
Open your file
Open your file
Open your file
Insert a column
Insert a column
Format and edit data
Format and edit data
Format and edit data
Format and edit data
Format and edit data
Format and edit data
Format and edit data
Format and edit data
Format and edit data
Format and edit data
Enter a formula
Enter a formula
Enter a formula
Enter a formula
Add headers and footers
Add headers and footers
Print
Print
The New Workbook window
The New Workbook window
A new file format
A new file format
Working with files from earlier versions
Working with files from earlier versions
Benefits of the new format
Benefits of the new format
New file formats, new options when you save
New file formats, new options when you save
Картинки из презентации «Microsoft Office Excel 2007 Training» к уроку информатики на тему «Office»

Автор: vista. Чтобы познакомиться с картинкой полного размера, нажмите на её эскиз. Чтобы можно было использовать все картинки для урока информатики, скачайте бесплатно презентацию «Microsoft Office Excel 2007 Training.ppt» со всеми картинками в zip-архиве размером 950 КБ.

Microsoft Office Excel 2007 Training

содержание презентации «Microsoft Office Excel 2007 Training.ppt»
Сл Текст Сл Текст
1Microsoft® Office Excel® 2007 32group, click the arrow on Format. In the
Training. Get up to speed. NYIT presents: list that appears, click AutoFit Column
2Course contents. Overview: A hands-on Width. Get up to speed.
introduction Lesson 1: What’s changed, and 33Format and edit data. You format and
why Lesson 2: Get to work in Excel Lesson edit data by using commands in groups on
3: A new file format. The first two the Home tab. For example, the column
lessons include a list of suggested tasks, titles will stand out better if they are
and all include a set of test questions. in bold type. To make it so, select the
Get up to speed. row with the titles and then on the Home
3Overview: A hands-on introduction. tab, in the Font group, click Bold. Get up
Excel 2007 has a new look! It’s got the to speed.
familiar worksheets you’re accustomed to, 34Format and edit data. While the titles
but with some changes. Notably, the old are still selected, you decide to change
look of menus and buttons at the top of their color and their size, to make them
the window has been replaced with the stand out even more. In the Font group,
Ribbon. This course shows you how to use click the arrow on Font Color. You’ll see
the Ribbon and highlights the other many more colors to choose from than
changes in Excel that will help you make before. You can also see how the title
better worksheets, faster. Get up to will look in different colors by pointing
speed. at any color and waiting a moment. Get up
4Course goals. Get a handle on the new to speed.
look of Excel. Find everyday commands on 35Format and edit data. You can use the
the Ribbon: Cut, Copy, Paste, Insert Sheet Font group to take care of other
Rows, Insert Sheet Columns, and Sum. Save formatting and editing options, too. To
workbooks in the new Excel file formats. increase the font size, click Increase
Get up to speed. Font Size . While the titles are still
5Lesson 1. What’s changed, and why. selected, you decide to center them in the
6What’s changed, and why. Yes, there’s cells. In the Alignment group, click
a lot of change in Excel 2007. It’s most Center . Finally, you find that you need
noticeable at the top of the window. But to enter one more order for Louisiana
it’s good change. The commands you need Fiery Hot Pepper Sauce. Select that
are now more clearly visible and more product name, and in the Clipboard group,
readily available in one control center click Copy . Then click in the bottom row,
called the Ribbon. Get up to speed. and in the Clipboard group again, click
7What’s on the Ribbon? The three parts Paste . Get up to speed.
of the Ribbon are tabs, groups, and 36Enter a formula. Before handing off
commands. Tabs: Tabs represent core tasks your report, you want to add up the
you do in Excel. There are seven tabs numbers in the Quantity column. It’s easy:
across the top of the Excel window. Use the Sum button . Place the cursor in
Groups: Groups are sets of related the last cell in the Quantity column, and
commands, displayed on tabs. Commands: A then click the Sum button on the Home tab.
command is a button, a menu, or a box (It’s in the Editing group.) Press ENTER
where you enter information. Get up to to see the formula result. Get up to
speed. speed.
8What’s on the Ribbon? How do you get 37Add headers and footers. As a
started on the Ribbon? Begin at the finishing touch, you decide to add headers
beginning. The principal commands in Excel and footers to the worksheet. This will
are gathered on the first tab, the Home help make clear to everyone what the data
tab. Get up to speed. is about. Here’s what to do: Switch to
9What’s on the Ribbon? Groups pull Page Layout view. You can click the View
together all the commands you’re likely to tab, and then click Page Layout View in
need for a particular type of task. the Workbook Views group. Or click the
Throughout your task, groups remain on middle button on the View toolbar at the
display and readily available; commands bottom of the window. Get up to speed.
are no longer hidden in menus. Instead, 38Add headers and footers. As a
vital commands are visible above your work finishing touch, you decide to add headers
space. Get up to speed. and footers to the worksheet. This will
10More commands, but only when you need help make clear to everyone what the data
them. The commands on the Ribbon are the is about. Here’s what to do: Click in the
ones you use the most. Instead of showing area at the top of the page that says
every command all the time, Excel 2007 Click to add header. As soon as you do,
shows some commands only when you may need the Header & Footer Tools and the
them, in response to an action you take. Design tab appear at the top of the
So don’t worry if you don’t see all the Ribbon. Get up to speed.
commands you need at all times. Take the 39Print. It’s time to print the report.
first steps, and the commands you need In Page Layout view, you can make
will be at hand. Get up to speed. adjustments and see the changes on the
11More options, if you need them. screen before you print. Here’s how to use
Sometimes an arrow, called the Dialog Box Page Layout view: Click the Page Layout
Launcher, appears in the lower-right tab. In the Page Setup group, click
corner of a group. This means more options Orientation and then select Portrait or
are available for the group. Click the Landscape. In Page Layout view, you’ll see
Dialog Box Launcher , and you’ll see a the orientation change, and how your data
dialog box or task pane. The picture shows will look each way. Get up to speed.
an example: On the Home tab, click the 40Print. It’s time to print the report.
arrow in the Font group. The Format Cells In Page Layout view, you can make
dialog box opens, with superscript and adjustments and see the changes on the
other options related to fonts. Get up to screen before you print. Here’s how to use
speed. Page Layout view: Still in the Page Setup
12Put commands on your own toolbar. Do group, click Size to choose paper size.
you often use commands that aren’t as You’ll see the results of your choices as
quickly available as you’d like? You can you make them. (What you see is what you
easily add them to the Quick Access print.). Get up to speed.
Toolbar. Play the animation to see the 41The New Workbook window. The New
process of adding a button to the toolbar Workbook window offers the perfect place
and then removing a button from the to start in Excel. When you click the
toolbar. Get up to speed. Animation: Microsoft Office Button and then click
Right-click, and click Play. New, the New Workbook window opens. At the
13Put commands on your own toolbar. Do top of the window, you can select either a
you often use commands that aren’t as new blank workbook or a template. Get up
quickly available as you’d like? You can to speed.
easily add them to the Quick Access 42Suggestions for practice. Insert a
Toolbar. The Quick Access Toolbar is above column. Use AutoSum. Add a header and a
the Ribbon when you first start Excel footer. Add a few finishing touches.
2007. There, commands are always visible Explore print options. Online practice
and near at hand. Get up to speed. (requires Excel 2007). Get up to speed.
14What about favorite keyboard 43Test 2, question 1. To insert a new
shortcuts? If you rely on the keyboard column, you use the commands in the Cells
more than the mouse, you’ll want to know group on the Home tab. (Pick one answer.).
that the Ribbon design comes with new True. False. Get up to speed.
shortcuts. This change brings two big 44Test 2, question 1: Answer. True. Then
advantages over previous versions of click the arrow next to Insert, and then
Excel: There are shortcuts for every click Insert Sheet Columns. Get up to
single button on the Ribbon. Shortcuts speed.
often require fewer keys. Get up to speed. 45Test 2, question 2. Where is the
15What about favorite keyboard button that you click to find commands to
shortcuts? The new shortcuts also have a open and close your files? (Pick one
new name: Key Tips. You press ALT to make answer.). On the first tab. In the
Key Tips appear. For example, here’s how upper-left corner of the window.
to use Key Tips to center text: Press ALT Underneath the Ribbon. Get up to speed.
to make the Key Tips appear. Press H to 46Test 2, question 2: Answer. In the
select the Home tab. Press A, then C to upper-left corner of the window. Click the
center the selected text. Get up to speed. big round Microsoft Office Button in the
16What about favorite keyboard upper-left corner. Get up to speed.
shortcuts? What about the old keyboard 47Test 2, question 3. In Page Layout
shortcuts? Keyboard shortcuts of old that view, you want to add a header to your
begin with CTRL are still intact, and you worksheet, but you don’t see the commands
can use them the same way you always have. you need. To get the commands, you need to
For example, the shortcut CTRL+C still click in the area that says “Click to add
copies something to the clipboard, and the header.” (Pick one answer.). True. False.
shortcut CTRL+V still pastes something Get up to speed.
from the clipboard. Get up to speed. 48Test 2, question 3: Answer. True. As
17A new view. Not only the Ribbon is new soon as you do, the Header & Footer
in Excel 2007. Page Layout view is new, Tools and the Design tab appear on the
too. If you’ve worked in Print Layout view Ribbon. These have all the commands to
in Microsoft Office Word, you’ll be glad work with headers and footers. Get up to
to see Excel with similar advantages. Get speed.
up to speed. 49Lesson 3. A new file format.
18A new view. To see the new view, click 50A new file format. Excel has a new
Page Layout View on the View toolbar . file format. But you can still open and
Here’s what you’ll see in the worksheet: edit older workbooks and share files with
Column headings. Row headings. Margin people who don’t have Excel 2007. The new
rulers. Get up to speed. file format brings increased security for
19A new view. In Page Layout view there your files, reduced risk of file
are page margins at the top, sides, and corruption, reduced file size, and new
bottom of the worksheet, and a bit of blue features. Get up to speed.
space between worksheets. Rulers at the 51Working with files from earlier
top and side help you adjust margins. versions. In Excel 2007, you can open
Other benefits of the new view: You don’t files created in Excel 95 through Excel
need to use Print Preview to find problems 2003. But what if you’re the first person
before you print. It’s easier than ever to in your office to have Excel 2007? What if
add headers and footers. You can see you need to need to share files with
different worksheets in different views. departments that don’t have Excel 2007
Get up to speed. yet? Don’t panic. You can all share
20Working with different screen workbooks with each other. Get up to
resolutions. Everything described so far speed.
applies if your screen is set to high 52Working with files from earlier
resolution and the Excel window is versions. Here’s how: Old files stay old
maximized. If not, things look different. unless you choose otherwise. Excel will
When and how do things look different? At save an older file in its original format
low resolution. If your screen is set to a unless you specify otherwise. For example,
low resolution, for example to 800 by 600 if it started in Excel 2003, Excel 2007
pixels, a few groups on the Ribbon will saves it in 2003 format by default. Newer
display the group name only, not the features warn you if you save a file as
commands in the group. Get up to speed. older. When you save a file in a previous
21Working with different screen version’s format, and the 2007 features
resolutions. Everything described so far you used are not compatible with the
applies if your screen is set to high previous version, a Compatibility Checker
resolution and the Excel window is tells you so. Get up to speed.
maximized. If not, things look different. 53Working with files from earlier
When and how do things look different? versions. Here’s how: You can always copy
When the Excel window isn’t maximized. newer files in newer format first. Just
Some groups will display only the group tell Excel you want an Excel Workbook
name. With Tablet PCs. On those with (*.xlsx). That copy of the file will
smaller screens, the Ribbon adjusts to contain all the Excel 2007 features. You
show smaller versions of tabs and groups. can share documents between versions by
Get up to speed. using a converter. Colleagues with Excel
22Suggestions for practice. Enter text. 2000 through 2003 can open 2007 files by
Adjust column width. Change document downloading and using a converter. Get up
views. Show or hide white space. Add a to speed.
button to the Quick Access Toolbar. Online 54Benefits of the new format. The new
practice (requires Excel 2007). Get up to file format means improvements to Excel.
speed. Here are its chief benefits: New features
23Test 1, question 1. You can customize Safer files Less risk of file corruption.
Excel 2007 by adding commands to the Quick Get up to speed.
Access Toolbar. (Pick one answer.). True. 55Benefits of the new format. The new
False. Get up to speed. file format means improvements to Excel.
24Test 1, question 1: Answer. True. You Here are its chief benefits: Reduced file
can add the commands you want to be at size. More useful data. Get up to speed.
your fingertips to the Quick Access 56New file formats, new options when you
Toolbar. Get up to speed. save. When you save a file in Excel 2007,
25Test 1, question 2. Some commands you can choose from several file types.
appear only when you need them. (Pick one Excel Workbook (*.xlsx). Use when there
answer.). True. False. Get up to speed. are no macros or VBA code. Excel
26Test 1, question 2: Answer. True. Take Macro-Enabled Workbook (*.xlsm). Use when
the first step or two, and a new tab will there are macros or VBA code. Excel
appear, with all the commands you need. Template (*.xltx). Use when you need a
For example, insert a chart, or a header template. Get up to speed.
and footer, and you’ll see more commands. 57New file formats, new options when you
Get up to speed. save. When you save a file in Excel 2007,
27Lesson 2. Get to work in Excel. you can choose from several file types.
28Get to work in Excel. The first lesson Excel Macro-Enabled Template (*.xltm). Use
helped you get oriented to the new look of when you need a template and the workbook
Excel 2007. Now it’s time to get to work. contains macros or VBA. Excel Binary
Say you’ve got a half hour before your Workbook (*.xlsb). Use with an especially
next meeting to make some revisions to a large workbook. Get up to speed.
worksheet that you created in a previous 58New file formats, new options when you
version of Excel. Can you do the basic save. When you save a file in Excel 2007,
things you need to do in Excel 2007, in you can choose from several file types.
just 30 minutes? This lesson will show you Excel 97-Excel 2003 Workbook (*.xls). Use
how. Get up to speed. when you need to share with someone
29Open your file. First things first. working in a previous version of Excel.
You want to open an existing workbook Microsoft Excel 5.0/95 Workbook (*.xls).
created in an earlier version of Excel. Do Use when you need to share with someone
the following: Click the Microsoft Office using Microsoft Excel 5.0. Get up to
Button . Click Open, and select the speed.
workbook you want. Also note that you can 59Test 3, question 1. If you save a file
click Excel Options, at the bottom of the that was created in a previous version of
menu, to set program options. Get up to Excel as an Excel 2007 file, the file can
speed. use all the new Excel features. (Pick one
30Insert a column. Now you want to add a answer.). True. False. Get up to speed.
column to your worksheet to identify 60Test 3, question 1: Answer. True. Get
product categories. You want it to go up to speed.
between two existing columns of data. View 61Test 3, question 2. Why was the Excel
the animation to see the process of 2007 file format changed to XML? (Pick one
inserting a column into the worksheet. Get answer.). New features could be added to
up to speed. Animation: Right-click, and Excel. Files are safer. Less risk of file
click Play. corruption. Reduced file size. All of the
31Insert a column. Now you want to add a above. Get up to speed.
column to your worksheet to identify 62Test 3, question 2: Answer. All of the
product categories. It should go between above. Get up to speed.
two existing columns of data, Quantity and 63Test 3, question 3. Someone sends you
Supplier. Your worksheet contains rows of an Excel 2003 file, which you open in
products ordered from various suppliers, Excel 2007. When you’re finished working
and you want to add the new column to with it in 2007, the file will
identify the various products as dairy, automatically be saved as Excel 2007,
grains, produce, and so on. Get up to unless you change the option. (Pick one
speed. answer.). True. False. Get up to speed.
32Insert a column. Follow this procedure 64Test 3, question 3: Answer. False. If
to add the column between the Quantity it started in Excel 2003, Excel 2007 saves
column and the Supplier column: Click in it in the 2003 format unless you say
the Supplier column. Then on the Home tab, otherwise. Get up to speed.
in the Cells group, click the arrow on 65Quick Reference Card. For a summary of
Insert. On the menu that appears, click the tasks covered in this course, view the
Insert Sheet Columns. A new blank column Quick Reference Card. Get up to speed.
is inserted, and you enter the new data in 66USING THIS TEMPLATE. See the notes
the column. If you need to adjust the pane or view the full notes page (View
column width to fit the data, in the Cells tab) for detailed help on this template.
Microsoft Office Excel 2007 Training.ppt
http://900igr.net/kartinka/informatika/microsoft-office-excel-2007-training-220470.html
cсылка на страницу

Microsoft Office Excel 2007 Training

другие презентации на тему «Microsoft Office Excel 2007 Training»

«MS Excel» - Перспектива. Задачи: Изучение и использование MS Excel как средство обучения в основной школе. Широкий спектр возможностей и универсальность MS Excel. Использование табличного процессора MS Excel на уроках в основной школе. Изучить возможности табличного процессора EXCEL. Изучить опыт использования табличного процессора MS Excel на уроках в основной школе.

«MS Office 2010» - Что происходит в случае нарушения правил: Необходимо продать РКС вместе с ПК (или коробочную версию). Не устанавливать Office 2010 Starter, только образ с коммерческими версиями. Consumers expect communication & sharing services on new PCs. Как: приобрести через OEM.MICROSOFT.COM. MS advantage program для DOEM партнеров.

«Excel 2007» - Using Advanced Filtering. Objectives. Highlighting Duplicate Records with a Custom Format. Using Lookup Tables and Functions. Using Database Functions to Summarize Data. Excel Tutorial 7 Using Advanced Functions, Conditional Formatting, and Filtering. New Perspectives on Microsoft Office Excel 2007.

«Microsoft Office Word» - Основные возможности Microsoft Word. Текстовый редактор (Text editor). Во время работы Допустимое минимальное расстояние от глаз до экрана дисплея – 50см. Web-страницы. Техника безопасности. Адреса, встречи, связь. Оформление текста. Создание типовых документов на основе шаблонов. Знакомство с Word 2000.

«Microsoft Excel» - Exploring Microsoft Excel 2002 Chapter 1. By Robert T. Grauer Maryann Barber. Summary (1 of 2). Exploring Microsoft Excel. Insert command can be used to add individual rows, columns, or cells. Excel XP. Change exam weights. Cell Referencing. Getting around the Worksheet. Hands-On Exercise 3. Objectives (2 of 2).

«Microsoft Office 2007» - What it means. Want to know more? ECM needs tops the list of MOSS adoption drivers . . . “Which of the following best describes your organization’s timeline for implementing or upgrading to Microsoft Office SharePoint Server?”. Aggressive adoption of MOSS 2007 by enterprises changes the ECM landscape by introducing content services for the masses.

Office

25 презентаций о Office
Урок

Информатика

130 тем
Картинки
900igr.net > Презентации по информатике > Office > Microsoft Office Excel 2007 Training