 Microsoft Excel 2003 training
The Intoweb Microsoft Excel training course teaches you about how to use the intuitive interface, capable calculation and graphing tools of Excel. As a spreadsheet program Excel 2003 is one of the most popular microcomputer applications to date.
|
Pre-Requisites
Basic Computer Literacy.
Course Details: An Intoweb lecturer oversees this comprehensive course. All Microsoft training is based on the "learning by doing" principle so the course covers all aspects of the Microsoft Powerpoint 2003 programme without overburdening the learner with excessive theory. The course is a beginner to intermediate course, and touches some advanced features . The course is both NQF level 2 and level 3 aligned. Intoweb is ISETT SETA accredited.
Cost: R2000 per person excl VAT
(includes interactive training and support system CD)
 Course Duration: 2 days
If you are interested in taking this course please contact:
(Please specify the course in your email enquiry)
COURSE OUTLINE
- Opening Microsoft Excel
- The Workbook environment
- Modifying the toolbar settings
- Workbook Properties
- Page Setup
- Managing the Task pane
- Understanding the Open dialog box
- Working with multiple worksheets
- Renaming worksheets
- Insert and delete worksheets
- Moving and copying worksheets
- Adjusting column width and row height
- Hiding and showing rows and columns
- Inserting columns and rows
- Deleting rows and columns
- Merging cells
- Entering and correcting data
- Changing the font and size of text
- Change the color of text
- Bold, underline and italicize text
- Other underlining options
- Other font options
- Aligning text in a cell
- Inserting symbols
- Undo and Redo
- Cut, copy and paste
- Using the clipboard
- Using the Paste Special function
- Pasting a hyperlink
- Moving data
- The AutoFill feature
- The AutoFormat feature
- AutoCorrect options and settings
- Checking spelling in a worksheet
- Find and Replace text in a workbook
- Inserting Hyperlinks
- External Hyperlinks
- Entering Numbers
- Formatting number styles
- Dates and Times
- Labels and Values
- Conditional Formatting
- Inserting Comments
- Working with multiple comments
- Adding borders to cells
- Filling cells
- Applying a color background
- Insert a picture background
- Page Break view
- Previewing your work for printing
- Printing your workbook
- Printing one worksheet
- Saving a file for the first time
- Closing your workbook
- Opening a new workbook
- Opening an existing workbook
- Sorting Data
- Multi-level sorting
- Filtering Data
- Recording Macros
- Linking cells in different workbooks
- Modifying linked workbooks
- Using Workspaces
- Creating Graphics
- Moving and sizing graphics
- Grouping Graphics
- Adding text to graphics
- Using AutoShapes
- Enhance objects
- Format Painter
- Inserting pictures using Clip Art
- Insert a picture from a file
- Using WordArt
- Enhance WordArt
- Using formulas to calculate values
- Error Messages in a spreadsheet
- The Error #####
- The #VALUE! Error
- The error #DIV/0!
- The #NAME? Error
- The error #N/A
- The error #REF!
- The #NUM! error
- The error #NULL!
- Using the Subtotal function
- The Outline function
- Outline symbols
- Absolute cell referencing
- The IF Function
- The PMT function
- The RATE function
- Auditing features
- The VLOOKUP function
- The HLOOKUP function
- Creating Pivot Tables
- Adding and deleting fields in Pivot tables
- Grouping and summarizing data in a pivot table
- Interactive Pivot Tables
- Creating a chart
- Formatting your chart area
- Modifying chart data
- Diagrams
- Creating Lists
- Protecting your worksheet
- Freeze Panes
- Comparing workbooks side by side
- Creating a Template
- Speech
- Speech Options
- Voice Training
- Dictation and Voice commands
- Handwriting
- E-mail your workbook
- The Research Function
- Excel Help
- Exit Excel
Click here to contact us:
(Please specify the course in your email enquiry)
|
