Excel training package consisting of
BVG train yourself Excel 2003/XP/2000(2cds)
rrp £19.99
AND
Focus teaching you Excel XP/2000 rrp £9.99
Training pack (focus and BVG pack) ONLY £19.50(BVG
Pack Only) ONLY £13.50
Why choose BVG CD-ROM Computer Training? Youll like what BVG CD-ROM training
offers. For one reason - the lessons are interesting! Packed with audio
and video clips the helpful presenter takes you through the course topic-by-topic.
The program allows you to move forward, or backward to review a particular
section, or simply jump to a specific topic that you need help with.
Youll learn in a simulated software environment - there is no need to
have the specific software you are learning about loaded on your computer.
Plus you can practice with 100% interactivity in the real software environment
using the sample files from the course. When you are ready to check your
progress, you can rest assured youve learned what matters for productivity
because the knowledge reviews focus on key concepts for performance in
the real world.
Excel training
Beginners
About workbooks and worksheets
Using the Excel window
Naming a worksheet
Coloring sheet tabs
Adding and deleting worksheets
Using the Task Pane
Selecting parts of a worksheet
Entering/deleting data
Selecting ranges
Using Go To
Inserting/Deleting rows, columns and cells
Starting, saving and closing workbooks
Entering formulas
Rules for writing formulas
Using AutoFill
Making absolute cell references
Editing cell content
Formatting a worksheet
Merging cells
Wrapping text
Using the Format Painter
Using the Office Clipboard
Inserting clip art
Using Find & Replace
Changing Page Setup
Printing a worksheet
and much more...
Excel training - Advanced
A review of calculation operators
Creating a formula
Tracing an error
Edit cell content
Make an absolute cell reference
Use the IF function
Financial Calculations
Calculate a loan payment
Tricks to calculating payments
Finding the present value
Calculate interest rates
Use the PMT function to obtain a savings goal
Calculate annuity payments
Password protection
Protect a workbook then remove the protection
Sort data
Filter data
Use AutoFilter
Create a PivotTable
Filter PivotTable data
Format the PivotTable
PivotChart reports
Filter a PivotChart
Save a worksheet as a web page
and much more...
System Requirements: Windows 95 or newer, 16 Mb RAM or greater, CD-ROM
Drive 4x or greater, Pentium PC or higher, 16 bit Sound Card, 5 Mb available
HD space, 256 Colour VGA monitor or greater.
|
Just
Games
Key
stage 123
