excel manual final changes 2003-2007
TRANSCRIPT
-
8/12/2019 Excel Manual Final Changes 2003-2007
1/22
Microsoft ExcelTrainingDifferences between 2003 and 2007
Goals:Faculty and staff will be exposed to the differences between the Office2003 uite and the Office 2007 uite in regards to the !isual layouts and
functions as they i"pact #ord$ %ower%oint$ Excel and Outloo&'Faculty and staff will be pro!ided the training opportunities that will allowthe" to de"onstrate their "astery of office 2007 with the sa"eunderstanding and proficiency they had under Office 2003'
In previous releases of Microsoft Office applications, people used a
system of menus, toolbars, task panes, and dialog boxes to get their
work done. his system worked well when the applications had a
limited number of commands. !ow that the programs do so muchmore, the menus and toolbars system does not work as well. oo
many program features are too hard for many users to find. "or this
reason, the overriding design goal for the new Office "luentuser
interface is to make it easier for people to find and use the full range
of features these applications provide. In addition, we wanted to
preserve an uncluttered workspace that reduces distraction for users
so they can spend more time and energy focused on their work. #ith
these goals in mind, we developed a results$oriented approach thatmakes it much easier to produce great results using the %&&'
Microsoft Office applications.
(Microoft$ Office uite 2007)
2007
*a"es +' ,ogers%urdue -ni!ersity .alu"et
/132007
-
8/12/2019 Excel Manual Final Changes 2003-2007
2/22
a"e box #indow close button
,ibbon For"ula ar +pplication closebutton
4uic& +ccess Toolbar Maxi"i5e,estore button
Mini"i5e application buttonOffice Title +cti!e cellbutton bar indicator Tab list Mini"i5e window button
tatus heet ,ow .olu"n .ells %age !iew 6oo"
ar tabs nu"bers letters buttons control
heet tab scroll buttons ori5ontal scrollbar 8ertical scrollbar
2
-
8/12/2019 Excel Manual Final Changes 2003-2007
3/22
Excel 2007
The old look of Excel menus and buttons has been replaced with this new Ribbon, with tabs you clickto get to commands. The Ribbon was developed to make Excel simpler to use, and to help youquickly find and work with the commands you need.
Whats changed, and why
3
-
8/12/2019 Excel Manual Final Changes 2003-2007
4/22
Whats on the Ribbon!
The three parts of the Ribbon are tabs, groups, and commands
TabsThere are seven of them across the top. Each represents core tasks you do in Excel.
GroupsEach tab has groups that show related items together.
Commands" command is a button, a box to enter information, or a menu.
The principal commands in Excel are gathered on the first tab, the Hometab.
The following set of ribbons is available with every document that is opened in Excel.
Home:contains formatting and editing icons
9
-
8/12/2019 Excel Manual Final Changes 2003-2007
5/22
Insert:objects into the file, such as pictures, charts, header/footer, and pivot tables
Page Layout:set margins, page orientation, gridlines, and headings
Formulas:functions, formulas, and AutoSum
Data:data from other sources, such as Access, text, or web, validation and sorting tools
:
-
8/12/2019 Excel Manual Final Changes 2003-2007
6/22
Review: spell check, thesaurus, comments, and workbook/sheet protection
View:views of the spreadsheet, zoom, macros, formulas, gridlines, and switch windows
icon to switch between open spreadsheets
Temporarily hide the Ribbon/
-
8/12/2019 Excel Manual Final Changes 2003-2007
7/22
Full Ribbon
inimi!ed Ribbon
#ometimes you $ust want to work on your document, and youd like more space to do that. #o its $ustas easy to hide the Ribbon temporarily as it is to use it.
%eres how& 'ouble(click the active tab. The groups disappear, so that you have more room.
Whenever you want to see all of the commands again, double(click the active tab to bring back thegroups.
icrosoft "ffice #ogo $utton7
-
8/12/2019 Excel Manual Final Changes 2003-2007
8/22
Microsoft Office (utton This button is located at the upper(left corner of the Excel
window and opens the menu shown here.
The ini Toolbar
;
-
8/12/2019 Excel Manual Final Changes 2003-2007
9/22
) The *ini Toolbar automatically pops up when text is highlighted to format.
+ When the text is highlighted, the *ini toolbar appears faded, not shown-
/f the mouse is pointed on the *ini toolbar, it will become solid shown above-, then click
to format text.
0or example, if you dont have a chart in your worksheet, the commands to work with charts arentnecessary.
-
8/12/2019 Excel Manual Final Changes 2003-2007
10/22
/f you have a chart in your worksheet more commands are available, but only when you need them.
Highlight your information
10
-
8/12/2019 Excel Manual Final Changes 2003-2007
11/22
1lick the %nsert Taband the ChartsGroupappear along with a highlighted Table Tools tab becomes visible.
11
-
8/12/2019 Excel Manual Final Changes 2003-2007
12/22
#elect a chart from the Chart Group &'ifferent Types of 1harts for 'ifferent 2eeds'
0or instance 1olum and click, then select +(' 1olumn select and click again
12
-
8/12/2019 Excel Manual Final Changes 2003-2007
13/22
A Chart then appears which represents your selection in the column category above.Then Chart Tools tabsbecome available: Design, Layout, and Format.
13
-
8/12/2019 Excel Manual Final Changes 2003-2007
14/22
The commands on the Ribbon reflect the 3roup you are using at present. /nstead of showing everycommand all the time, Excel +445 shows some commands when you may need them, in response toan action you take.
6ut after you create a chart, the Chart Toolsappear, with three tabs& (esign, #ayout, and Format.7n these tabs, youll find the commands you need to work with the chart. The Ribbon responds toyour action.
8se the (esigntab to change the chart type or to move the chart location.
19
-
8/12/2019 Excel Manual Final Changes 2003-2007
15/22
The #ayouttab to change chart titles or other chart elements.
The Formattab to add fill colors or to change line styles
1:
-
8/12/2019 Excel Manual Final Changes 2003-2007
16/22
When you complete the chart, click outside the chart area. The Chart Toolsgo away. To get themback, click inside the chart. Then the tabs reappear.
if you dont see allthe commands you need at all times. Take the first steps. Then the commands you
need will be at hand.
*ore options, if you need them
1/
-
8/12/2019 Excel Manual Final Changes 2003-2007
17/22
1lick the arrow at the bottom of a group to get more options if you need them.
)1lick the arrow in the Fontgroup.
+The Format Cellsdialog box opens.
When you see this arrow called the (ialog $ox #auncher- in the lower(right corner of a group,there are more options available for the group. 1lick the arrow, and youll see a dialog box or a taskpane.
0or example, on the Hometab, in the Fontgroup, you have all the commands that are used the most
to make font changes& commands to change the font, to change the si9e, and to make the font bold,italic, or underlined.
/f you want more options, such as superscript, click the arrow to the right of Font, and youll get theFormat Cellsdialog box, which has superscript and other options related to fonts.
/f you want more options, such as superscript, click the arrow to the right of Font, and youll get theFormat Cellsdialog box, which has superscript and other options related to fonts.
:ut commands on your own toolbar
/f you often use commands that are not as quickly available as you would like, you can easily addthem to the *uic+ ,ccess Toolbar, which is above the Ribbon when you first start Excel +445. 7nthat toolbar, commands are always visible and near at hand.
17
-
8/12/2019 Excel Manual Final Changes 2003-2007
18/22
-
8/12/2019 Excel Manual Final Changes 2003-2007
19/22
-
8/12/2019 Excel Manual Final Changes 2003-2007
20/22
1sing the new shortcuts
The new shortcuts also have a new name& >ey Tips. ;ou press "=T to make the >ey Tips appear.
;oull see >ey Tips for all Ribbon tabs, all commands on the tabs, the
-
8/12/2019 Excel Manual Final Changes 2003-2007
21/22
" 2EW A/EW
7n the Full Ribbonclick 4iew
7n the 4iewRibbonlook in the /or+boo+ 4iew Group andclick -age #ayout 4iew
21
-
8/12/2019 Excel Manual Final Changes 2003-2007
22/22
-age #ayout view in Excel.
)1olumn %eadings
+Row %eadings
*argin Rules
/f you have worked in :rint =ayout view in *icrosoft 7ffice Word, youll be glad to see Excel with
similar advantages.
/n :age =ayout view there are page margins at the top, sides, and bottom of the worksheet, and a bitof blue space between worksheets. Rulers at the top and side help you ad$ust margins. ;ou can turnthe rulers on and off as you need them click Rulerin the how5Hidegroup on the 4iewtab-.
With this new view, you dont need print preview to make ad$ustments to your worksheet before youprint.
22