Transcript Differences Across 2003 to 2007

Mouse Training
Wednesday, 08 July 2015
1
What You Will Learn



New Vocabulary & Terms
New Visual Layout
Differences from Previous Version
2
The New Vocabulary










Ribbon
Office Logo Button
Quick Access Toolbar
Tabs
Contextual Tabs
Groups
Dialog Box Launchers
Commands
Keyboard Shortcuts
Mini Toolbar
3
The Ribbon Bar


The Ribbon is an interface where a set of toolbars
are placed on tabs in a tab bar.
The Ribbon can be collapsed but cannot be
moved from the top to the side of the page
Office Logo
Button
Quick Access Toolbar
Groups
Tabs
4
How are commands organized?
Commands are
organized by how
they’re used.
Frequently used core commands no longer have to
share space with a range of remotely related commands
on a menu or toolbar.
They’re the ones that get used, and so now they’re the
ones most prominently featured.
What is on the ribbon?
How do you get
started?
Begin with the first
tab.
In Word 2007, for example, that’s the Home tab.
It’s got the commands that people use most commonly
when they write documents: font formatting commands
(Font group), paragraph options (Paragraph group),
and text styles (Styles group).
More what is on the Ribbon?
The three parts of the
Ribbon are tabs,
groups, and
commands.
1
Tabs sit across the top of the Ribbon. Each one
represents core tasks you do in a given program.
2
Groups are sets of related commands. They remain on
display and readily available, giving you rich visual aids.
3
Commands are arranged in groups. A command can be
a button, a menu, or a box where you enter information.
Office Button



The Office button
replaces the File menu.
From this button you will
Save, Save As, Print,
Email etc
Note: Clicking twice on
the Office button closes
the application.
You will customise your
application from the
Office button.
8
Office Logo Button
9
Quick Access Toolbar

The Quick Access Toolbar is the small area to the
upper left of the Ribbon. It contains the things that
you use over and over every day: Save, Undo, ...

You can add items to the toolbar via the office
button and selecting options, customize.
10
Customizing the quick access
toolbar
Customizing the quick access
toolbar
Do you often use
commands that aren’t
as quickly available as
you’d like?
You can easily add
them to the Quick
Access Toolbar.
Located above the Ribbon when you first start your
Microsoft Office program, the Quick Access Toolbar
puts commands where they’re always visible and near
at hand.
Customizing the Quick Access
Toolbar Excel
Customizing the Quick Access
Toolbar Word
Customizing the Quick Access
Toolbar PowerPoint
Ribbon Tabs


The tabs on the Ribbon display the commands
that are most relevant for each of the task areas in
the applications
Shown below is an example of a Office application
insert group, on the tab are items you would insert
into the application you are working on.
16
Ribbon Groups

Groups are logical divisions of the tab bar,
grouping font functions together in one place
saving you time looking for functionality.
17
Keyboard Shortcuts


Short Cut Keys – Most of the shortcut keys you
are used to still work.
Office 2007 additionally uses the ALT key. This
displays the letter to access the action you require.
18
Contextual Tabs
Commands you use
most are available on
the Ribbon all the
time.
Others appear only
when you need them,
in response to an
action you take.
For example, the Picture Tools in Word appear on the
Ribbon when you insert a picture, and they go away
when you’re done. The Ribbon responds to your action.
So don’t worry if you don’t see all the commands at all
times. Take the first steps, and what you need will
appear.
19
Outlook Menus

Honourable
exception Outlook
retains menus
Outlook Menu to Ribbon
Dialog box Launchers



Dialog Boxes are
available for many group
items.
An example in Excel
would be CTRL SHIFT F
this launches the Format
Cells
Or click the icon circled to
expand dialog boxes
22
Dialog Box Launcher-Word
Sometimes an arrow,
called the Dialog Box
Launcher, appears in
the lower-right corner
of a group.
This means more
options are available
for the group.
For example, to get to a less commonly used font option
in PowerPoint® 2007:
1
On the Home tab, click the arrow
in the Font group.
2
The Font dialog box opens, with the full selection of font
commands.
Mini Tool Bar

The Mini toolbar will appear in a faded fashion. If
you point to the Mini toolbar, it will become solid,
and you can then click a formatting option.
24
Configurable Status Bar

in Office 2007 you can
customize what information
you want to see in the status
bar from a predefined list.
 In Word, Excel, PowerPoint
(not Outlook) you can right
click on the status bar at the
bottom of the window. You
will receive a menu like the
one Right.
 You can turn the Status bar
on and off by choosing View |
Status Bar.
25
Live Preview Excel
You can see how formatting options such as fonts and Quick Styles
will look, before you commit to them, by using the Live Preview feature
that is included in several programs in the 2007 Microsoft Office
system.
Galleries
Word– Styles
Power Point– Master Slides
Excel– Format as Table
7/8/2015
 Presents simple set of
potential results, rather than a
complex dialog box with
numerous options, Galleries
simplify the process of
producing professional
COSC 1401.41011
looking work.
30
Galleries

Galleries enable you to trial
the layout, or look and feel
of your document very
quickly

Picture shows Cover page
gallery.
31
Smart Art

Smart Art incorporates a gallery of templates and
predefined shapes that can quickly be inserted
and configured in your Microsoft Office
documents.
32
Smart Art Gallery
33
Smart Art Gallery
Shapes

Accessible from the home page

When you access shapes you are given a
contextual menu with all the option to format the
shape.
35
Pictures

Pictures now have many options and effects
including reflections and glow levels. This can be
selected from quick gallery's
36
Charts

Graphs/Charts are much improved and can be
selected from quick gallery's and many other
options can be chosen from subsequently
40000
35000
30000
25000
20000
15000
10000
5000
0
joh 1
joh 2
joh 3
joh 4
joh 5
37
Charting
New File Types



Word
Excel
PowerPoint
.docx
.xlsx
.pptx

The new file formats are based around Extensible
Markup Language XML.
 The idea is to make it easier to move information
between applications
 To see an Office 2007 file with an older version of
Office, you will need to download a patch for your
older version of Office and then save as a ‘97-’03
format.
39
Compatibility Issues




Turn on compatibility Mode
Compatibility checker
When a user creates a file
in the 2007 Office system
and opens it in a previous
version of Office, some of
the graphic content is
converted to images
instead of auto shapes
Excel Size of new work
sheets
40
Excel Enhancements

The Ribbon of course
 Create consistent styles and themes
 Build bigger worksheets
 New conditional formatting features
 Build attractive charts faster
 Smart Art
 Improved filtering of tables
 Improved PivotTables and chart tools
41
Excel Summary
Excel 2003
Excel 2007
Number of rows
Limited to 65,536
Over 1,000,000
Number of Columns
256
16,384
Lists/Tables
List support was introduced with
Excel 2003.
Formula Writing
Conditional Formatting
Lists were renamed to Tables and
additional features added in 2007 to
make them easier to use.
Same formula bar since Excel 97. Resizable formula bar and contextParentheses are colored to assist in based Formula AutoComplete to
formula writing.
help you write the proper formula
syntax the first time.
Limited to 3 tests
Many tests are allowed
Color Palette
Limited colors
Essentially unlimited colors
Interface
Menus and buttons
Nesting ifs
up to 7nesting levels
Ribbons with buttons and text drop
downs
up to 64 nesting levels
42
PowerPoint Enhancements







The Ribbon interface
The Quick Style gallery
SmartArt
New improved text, table and graphics and
shape formatting
Live preview
Smaller file size, better file format
Save as PDF or XPS
43
Word Enhancements





New building blocks for adding preformatted
content to your documents streamlining content
reuse:
A new, results-oriented interface presents tools to
you when you need them.
New high impact charting and diagramming
Instantly apply a new look and feel to your
documents
New quick styles and document themes for
faster formatting
44
Outlook Enhancements





The Ribbon
New To-Do Bar: Single view of tasks,
appointments and flagged email
New Instant Search across all Outlook
categories
Color categories
New task integration with Calendar
45
Outlook To Do Bar
The To-Do Bar shows a Date Navigator), your upcoming
appointments, and a list of your. You can accept/decline
meetings, add new tasks, categorize, rearrange, and
change the dates of your tasks all while responding to
e-mail.
Outlook Categories
Categories apply to messages, calendar
items, notes, contacts and tasks.
Visuals cues to easily and quickly
determine who messages are from or to,
what project categories belong to
Perform quick searches for all messages
assigned a given category
to set up dedicated search folders that
auto-populate with the categories you
specify
Help
The help menu has tons of instructions, videos,
PowerPoint presentations, and more to help you
when you’re stuck!
48
Further Help
If you can’t find the
command you’re
looking for, there’s
help.
For Word 2007, Excel 2007, and PowerPoint 2007,
there’s a visual, interactive reference guide to help you
quickly learn where things are.
http://office.microsoft.com/enus/excel/HA101491511033.aspx
49
Further Help

Excel 2003 to Excel 2007 interactive command reference guide

http://office.microsoft.com/en-us/excel/HA101491511033.aspx

http://www.microsoft.com/downloads/details.aspx?FamilyId=89718ABD-2758-47B3-9F9093788112B985&displaylang=en













Word 2003 to Word 2007 interactive command reference guide
http://www.microsoft.com/downloads/details.aspx?FamilyID=9044790b-4e24-4277-b71466d7b18d0aa1&DisplayLang=en
PowerPoint 2003 to PowerPoint 2007 interactive command reference guide
http://www.microsoft.com/downloads/details.aspx?familyid=BEF41DC3-8E28-4282-82D4CEC2F416CD40&displaylang=en
Outlook 2003 to Outlook 2007 interactive command reference guide
http://www.microsoft.com/downloads/details.aspx?familyid=CC37CC1E-028D-4D30-909396CC6513ECA1&displaylang=en
Access 2003 to Access 2007 interactive command reference guide
http://www.microsoft.com/downloads/en/confirmation.aspx?familyId=b9574c72-657f-438c9de9-f8f70dd2d40d&displayLang=en
50