Microsoft Excel (2003/2007) Level 1
Short course
Inhouse
Description
-
Type
Short course
-
Level
Beginner
-
Methodology
Inhouse
This course provides a good working understanding of spreadsheets.
Reviews
Course programme
Course Content
Level 1
Entering Numbers and Text
- Understanding Spreadsheets
- Auto sum
- Average
- Min
- Max
- If Function
- Absolute References
- Auto Fill Command
- Working with Sheet Tabs
- Grouping Sheets
Page Set Up
- Setting Print Areas
- Inserting Rows and Columns
- Inserting Page Breaks
- Headers and Footers
- Margins
- Print preview command
- Scaling
- Printing
Formatting Data
- Alignment
- Rotating Text
- Merging Cells
- Date Formats
- Custom Formats
- Conditional Formatting
- Defining and Naming Ranges
- Calculation of Named Ranges
Chart Creation
- Creating charts
- Using the Chart Toolbar
- Editing Charts
- Dual Axis
- Updating Charts
Additional information
Microsoft Excel (2003/2007) Level 1