Home /
Training Courses /
Microsoft Excel XP Fundamentals
Microsoft Excel XP Fundamentals
Training Description
The skills and knowledge acquired in Microsoft Excel XP Fundamentals are sufficient to be able to use and operate the software at an efficient level.The Course Suits
Microsoft Excel XP Fundamentals is designed for users who are keen to extend their understanding and knowledge of the software. Microsoft Excel XP Fundamentals assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.Training Benefits
At the completion of Microsoft Excel XP Fundamentals you should be able to:
- start Microsoft Excel, navigate workbooks, and exit correctly
- create, modify, save, and close a simple workbook
- print data in a workbook
- copy and fill data in a workbook
- adjust the sizing of columns and rows in a workbook
- enter a range of data types and formulas
- move the contents of cells within and between workbooks
- create formulas that perform calculations in a workbook
- create and work with functions in a workbook
- understand and use absolute referencing in a workbook
- edit data in a workbook
- use the fill technique to enter data into cells
- format cells in a workbook
- create a variety of charts (graphs) in Excel
- use hyperlinks to provide navigational tools in a workbook
Course Timetable
The course focuses on practical work within the product giving delegates ample opportunity to use their PC skills through a series of graded exercisesTopics covered include:Excel XP Orientation
Starting Excel XP
The Excel XP Screen
Understanding The Workbook
Moving The Cell Pointer
Moving About The Workbook
Using Go To
Menus And Toolbars
Using Menus And Toolbars
Using Context Sensitive Menus
Exiting Excel XP
A Simple Workbook
Creating A New Workbook
Entering Data In A Workbook
Saving A New Workbook
Opening A Saved Workbook
Creating An Input Range
Saving Your Work
Essential Formatting
Column Best Fit
Closing A Workbook
Printing
Print Preview
Simple Printing
Previewing Large Worksheets
Page Orientation
Scaling To Fit
Printing To Multiple Pages
Creating Page Headers And Footers
Formatting Headers And Footers
Printing Formulas
Scale To A Specific Number Of Pages
Specifying Number Of Copies
Printing An Entire Workbook
Specifying Paper Size
Understanding Paper Sizes
Copying And Filling
Understanding Copying In Excel
Using Fill For Quick Copying
Copying From One Cell To Another
Copying From One Cell To Multiple Cells
Copying From Many Cells To Many Cells
Copying Relative Formulas
Copying To A Non-Contiguous Range
Copying Between Worksheets
Copying Between Open Workbooks
Adjusting A Worksheet
Inserting Cells
Deleting Cells
Inserting Columns
Inserting Rows
Deleting Rows And Columns
Resizing Columns
Resizing Rows
Hiding Gridlines
Simple Data Entry
Typing Text
Typing Numbers
Typing Dates
Typing Simple Formulas
Moving Cell Contents
Moving A Cell To Another Location
Moving A Range To Another Location
Moving A Cell To Another Worksheet
Moving A Range To Another Worksheet
Moving A Cell To Another Workbook
Moving A Range To Another Workbook
Formulas
Understanding Formulas
Formulas That Add
The Sum Function
Formulas That Subtract
Formulas That Multiply And Divide
Referential Formulas
What If Formulas
More Complex Formulas
Formula Error Checking
Common Error Messages
Viewing Formulas
Working With Functions
Functions
Typing A Sum Function
Summing Non-Contiguous Ranges
Calculating An Average
The Maximum Function
The Minimum Function
Absolute Referencing
Absolute And Relative Referencing
Problems With Relative Formulas
Tracing Precedents
Creating Absolute References
Creating Mixed References
Circular References
Tracing Dependent Cells
Editing Data
Overwriting Cell Contents
Editing Long Cell Entries
Editing Formulas
Editing Functions
Using Undo
Using Redo
Filling Series
Filling A Series
Filling A Growth Series
Filling A Series Backwards
Filling Using Options
Creating A Custom Series
Modifying And Deleting Custom Series
Formatting Cells
Using The Font Tools
Using The Alignment Tools
Using The Number Tools
The Format Cells Dialog Box
Formatting Fonts Using The Menu
Superscript, Subscript And Strikethrough
Changing Horizontal Alignment
Centring Across A Selection
Wrapping Text
Changing Text Orientation
Changing Vertical Alignment
Formatting Dates
Formatting Numbers
Formatting Currency
Creating Custom Formats
Borders And Shading
Clearing Cell Formats
Charting
Using The Chart Wizard
Choosing The Chart Type
Changing The Chart Type
Modifying A Chart
Printing A Chart
Creating A Pie Chart
Creating A Bar Chart
Moving A Chart
Deleting A Chart
Creating A Column Chart
Creating A Line Chart
Moving A Chart To Another Workbook
Copying A Chart Within A Worksheet
Copying A Chart To Another Workbook
Resizing A Chart
Hyperlinks
Hyperlinking Within A Workbook
Using A Hyperlink
Hyperlinking To A Range
Hyperlinking Between Applications
© PTP/X4M1
Please Choose from the list below:
Microsoft Excel XP Fundamentals training course available to book:
Related Items:
There's no related items for that course.
Quick Training Search
To perform a free text search for courses enter your chosen keyword/s below:
Special offers
Click here to find training related special offers in your area special offers
Open course schedule
One day open course schedule for the next month more info
U-Choose
Can't find the right date?
Can't find the right venue?
With U-Choose you can build the training package of your specification more info
Download our brochure
To download our brochure please click
here
To download our 2009 Open Schedule click
here
Special Offers Subscription
Subscribe to receive our special offers.