office 2003 to office 2007 transition. what’s new? improved gui bigger spreadsheets 1,048,576...

26
MICROSOFT EXCEL 2007 Office 2003 to Office 2007 Transition

Upload: merry-webb

Post on 02-Jan-2016

216 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

MICROSOFT EXCEL 2007Office 2003 to Office 2007 Transition

Page 2: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi
Page 3: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

What’s New?

Improved GUI Bigger spreadsheets

1,048,576 rows x 16,384 columns Improved memory and multi processor

usage Themes and styles consistent with other

Office applications Improved conditional formatting Easier formula writing Improved sorting and filtering

Page 4: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

What’s New?

Improved color schemes across all formatting including charts

All Office applications now use the Excel charting

Improved PivotTables XML storage to improve file size and

recoverability Improved printing Save to PDF (with download) and XPS More templates

Page 5: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

Home

Page 6: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

Insert

Page 7: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

Page Layout

Page 8: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

Formulas

Page 9: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

Data

Page 10: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

Review

Page 11: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

View

Page 12: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

Chart Tools: Design

Page 13: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

Chart Tools: Layout

Page 14: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

Chart Tools: Format

Page 15: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

Picture Tools: Format

Page 16: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

Drawing Tools: Format

Page 17: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

PivotTable Tools: Options

Page 18: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

PivotTable Tools: Design

Page 19: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

Table Tools: Design

Page 20: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

Developer

Needed to run macros, design forms, protect documents and do extensive work with templates

Activate via Office button, Excel Options, Popular, Show Developer tab in the Ribbon

Page 21: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

Add-Ins

Only visible if applications are added that enhance application, for example, Adobe Acrobat

Page 22: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

Formula Bar and Scroll Bar (top)

Expand / collapse

formula bar

Scroll bar – up one line

Name box

Formula Bar

CancelEnterInsert

Function

Split screen

Page 23: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

Status Bar (left)

Select SheetXNew Sheet

Mode Macro RecordingShortcut to

Macros

Sheet:First

PreviousNextLast

Page 24: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

Status Bar (right)

Zoom buttons and slider

Window corner for resizing

Zoom %Shortcut to

Zoom

Views:Normal

Page LayoutPage Break

Preview

Split windowResize

scroll bar

Page 25: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

Task Panes

Page 26: Office 2003 to Office 2007 Transition. What’s New?  Improved GUI  Bigger spreadsheets  1,048,576 rows x 16,384 columns  Improved memory and multi

Notes

Excel rocks.