office 2003 to office 2007 transition. what’s new? improved gui bigger spreadsheets 1,048,576...
TRANSCRIPT
MICROSOFT EXCEL 2007Office 2003 to Office 2007 Transition
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
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
Home
Insert
Page Layout
Formulas
Data
Review
View
Chart Tools: Design
Chart Tools: Layout
Chart Tools: Format
Picture Tools: Format
Drawing Tools: Format
PivotTable Tools: Options
PivotTable Tools: Design
Table Tools: Design
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
Add-Ins
Only visible if applications are added that enhance application, for example, Adobe Acrobat
Formula Bar and Scroll Bar (top)
Expand / collapse
formula bar
Scroll bar – up one line
Name box
Formula Bar
CancelEnterInsert
Function
Split screen
Status Bar (left)
Select SheetXNew Sheet
Mode Macro RecordingShortcut to
Macros
Sheet:First
PreviousNextLast
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
Task Panes
Notes
Excel rocks.