Excel 2007 Introduction
Short course
In London and Birmingham
Description
-
Type
Short course
-
Level
Beginner
-
Location
-
Duration
1 Day
This course is designed to provide a new Excel user with a good understanding of the basic concepts of spreadsheet design, commands, data manipulation, using calculations and formatting techniques, as well as creating charts.
Facilities
Location
Start date
Start date
Start date
Reviews
Course programme
Course content
- Introduction to Excel.
- The Ribbon.
- Command Tabs.
- Contextual Command Tabs.
- Quick Access Toolbar.
- Status bar and Mini toolbar.
- Using Help.
- Smart Tags & Task Panes.
- Document Management.
- Creating and saving workbooks.
- Opening and closing workbooks.
- Managing workbooks.
- Setting Up / Editing Worksheets.
- Entering, editing and erasing cell contents.
- Copying and moving cell contents.
- Undo and redo.
- Building Formulas.
- Basic calculations and priorities.
- Inserting functions.
- Using AutoSum.
- AutoCalc.
- Calculating across Worksheets.
- Formatting.
- Changing column widths / row heights.
- Changing values and date display.
- Changing cell alignment.
- Applying borders, fonts and colour.
- Live Preview.
- Format Painter.
- Adding Cell Comments.
- Printing.
- Previewing worksheets.
- Changing the margins and orientation.
- Setting the print area and print titles.
- Page breaks, Page Break Preview and Page Layout view.
- Headers and footers.
Excel 2007 Introduction