Microsoft Excel 2007 Training
Course Background
Coupled with the 'Word' application in the MS Office suite, Excel has become a popular package for controlling spreadsheet applications. Ranging from the managing of lists and tables to the accounting control package for large corporations, Excel manages and manipulates tabular information.
By using auto-calculations and equation control, totalling can be automated alongside mathematical functions like %, VAT, profit margins & Return On Investment. Add to that the ability to chart results to show trends, input data from almost any text or database source and automate repetitive tasks using Visual Basic style scripts, and the popularity of this package is understandable.
Trainee pre-requisite knowledge
Trainees should be competent at the Windows interface with the concept of files and folders. General mouse operating skills and keyboard familiarity is needed, although fast typing skills are not necessary. Previous spreadsheet experience would prove beneficial but not essential.
After the course attendees will be able to...
- Navigate the Excel 2007 interface
- Use spreadsheet functions and multiple pages
- Enter large amounts of tabulated data
- Perform common calculations on cells and columns
- Integrate charts into worksheets for trend analysis
- Manage and control large accounts Utilise balance, VAT and financial operations
- Format worksheets to make to improve ease of understanding
- Control the design layout of all tables and cells
- Understand printing and reporting capabilities
- Use named cells to make it easier to move around large worksheets
- Set up print layouts
- Manage spreadsheet files on a computer hard disk