Exploring Microsoft Excel 2007
Excel
Training
Provided by Microcomputing Solutions ltd
Objectives: This is one of a series of courses designed to show the features of Microsofta s latest range of Office Products.
In addition to showcasing the new features, an important part of the day will allow existing users of the product to explore the radically different user interface.
The aim is to ensure that attendees can find the new location of all the facilities they have used in earlier versions of Microsoft Office.
Pre Requisites: Experience of using Microsoft Excel would be a benefit
Duration: 1 day
The topics covered are as follows:
1 The New User Interface
a The Ribbon
a Context Tabs
a Dialog Box Launchers
a Quick Access Toolbar
a View Selector/ Zoom
a Keyboard Shortcuts
2 The Office Button
a Creating/ Saving Documents
a New File Formats
a Version Compatibility
a Excel Options
3 The Home Tab
a Cut, Copy and Paste
a Font and Alignment
a Number and Styles
a Cells / Editing
4 The Insert Tab
a Tables and Illustrations
a Charts
a Links
a Text objects
5 The Page Layout Tab
a Themes and Page Setup
a Scale to Fit
a Sheet Options
a Arranging Graphic Objects
6 The Formulas Tab
a Function Library
a Defined Names
a Formula Auditing
a Calculation Options
7 The Data Tab
a Get External Data
a Connections (Links)
a Sort & Filter
a Data Tools and Outline
8 The Review Tab
a Proofing (Spelling & Grammar)
a Comments
a Tracking Changes
9 The View Tab
a Workbook Views
a Show/ Hide
a Zoom and Window
a Macros
|
|
||||||||||
Exploring Microsoft Excel 2007
Objectives: This is one of a series of courses designed to show the features of Microsoft s latest range of Office Products.
In addition to showcasing the new features, an important part of the day will allow existing users of the product to explore the radically different user interface.
The aim is to ensure that attendees can find the new location of all the facilities they have used in earlier versions of Microsoft Office.
Pre Requisites: Experience of using Microsoft Excel would be a benefit
Duration: 1 day
The topics covered are as follows:
1 The New User Interface
The Ribbon
Context Tabs
Dialog Box Launchers
Quick Access Toolbar
View Selector/ Zoom
Keyboard Shortcuts
2 The Office Button
Creating/ Saving Documents
New File Formats
Version Compatibility
Excel Options
3 The Home Tab
Cut, Copy and Paste
Font and Alignment
Number and Styles
Cells / Editing
4 The Insert Tab
Tables and Illustrations
Charts
Links
Text objects
5 The Page Layout Tab
Themes and Page Setup
Scale to Fit
Sheet Options
Arranging Graphic Objects
6 The Formulas Tab
Function Library
Defined Names
Formula Auditing
Calculation Options
7 The Data Tab
Get External Data
Connections (Links)
Sort & Filter
Data Tools and Outline
8 The Review Tab
Proofing (Spelling & Grammar)
Comments
Tracking Changes
9 The View Tab
Workbook Views
Show/ Hide
Zoom and Window
Macros
In addition to showcasing the new features, an important part of the day will allow existing users of the product to explore the radically different user interface.
The aim is to ensure that attendees can find the new location of all the facilities they have used in earlier versions of Microsoft Office.
Pre Requisites: Experience of using Microsoft Excel would be a benefit
Duration: 1 day
The topics covered are as follows:
1 The New User Interface
The Ribbon
Context Tabs
Dialog Box Launchers
Quick Access Toolbar
View Selector/ Zoom
Keyboard Shortcuts
2 The Office Button
Creating/ Saving Documents
New File Formats
Version Compatibility
Excel Options
3 The Home Tab
Cut, Copy and Paste
Font and Alignment
Number and Styles
Cells / Editing
4 The Insert Tab
Tables and Illustrations
Charts
Links
Text objects
5 The Page Layout Tab
Themes and Page Setup
Scale to Fit
Sheet Options
Arranging Graphic Objects
6 The Formulas Tab
Function Library
Defined Names
Formula Auditing
Calculation Options
7 The Data Tab
Get External Data
Connections (Links)
Sort & Filter
Data Tools and Outline
8 The Review Tab
Proofing (Spelling & Grammar)
Comments
Tracking Changes
9 The View Tab
Workbook Views
Show/ Hide
Zoom and Window
Macros
About The Training Provider: Microcomputing Solutions ltd
Microcomputing Solutions ltd - microcomputing has been providing comprehensive IT solutions to businesses throughout the North East since 1981.
microcomputing provides a comprehensive IT solution for businesses including computer software training, technical support for SMEs and hardware and software solutions focusing on maximum efficiency, at a reduced cost for your business.
Our policy of providing a local personal...
