Microsoft Excel 2003 Level 2 Training Course
Microsoft Excel 2003 Level 2 Training Course Summary
Training Course Price : £249
Training Course Length : 1 Day
Microsoft Excel 2003 Level 2 Training Course continues in a logical format from where the level 1 training finished. Level 1 Microsoft® Office Excel 2003 took you through the basics of creating, editing, formatting, and printing basic spreadsheets. Level 2 Excel training helps you to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In the Excel level 2 training course, you will make your spreadsheets more efficient and present them in a more professional manner utilising a variety of tools such as templates, charts, graphics, and formulas.
This excel training course goes into some depth in the process to be able to apply visual elements and advanced formulas to a worksheet to display data in various formats.
Students who manage to complete the training successfully will have gained the necessary knowledge to :
- Create and apply templates.
- Create and modify charts.
- Work with graphic objects.
- Calculate with advanced formulas.
- Sort and filter data.
- Use Excel with the Web.
Price: £249
Entry Level for Participants wanting to attend Microsoft Excel 2003 Level 2 Training Course
Attendee's should have all the basic knowledge of using Excel covered in Microsoft Excel Training Course Level 1 - see the course description here. Alternatively, experience of using excel to a basic level will be sufficient to allow you to participate in this training course successfully.
It would also be extrememly beneficial to all students if they have some knowledge of browsing the internet.
Who is this Microsoft Excel 2003 Level 2 Training Course aimed at?
This excel training course is primarily aimed at people who want to build on their basic knowledge of Microsoft Excel and learn additional skills such as creating templates, sorting and filtering data, importing and exporting data, analyze data, and work with Excel on the Web. The course is also perfect preparation for those who wish to take the Microsoft Office Specialist exam in Excel or Module 2 and who already know the basics of Excel,such as how to create, edit, format, and print basic worksheets.
Training Course Overview/Content:
Templates
- Creating a workbook from an Excel template
- Create a template
- Working with comments
- Create a hyperlink
- Create a workbook from a user-defined template
Creating and modifying charts
- Create a chart
- Format chart items
- Change the chart type
- Create a diagram
Working with graphic objects
- Insert graphics
- Create autoshapes
- Format graphic objects
- Group, move, copy and resize objects
Sorting and Filtering Data
- Sort data
- Add subtotals to a worksheet
- Filter lists
- Create and apply custom filters
- Advanced filters
- Database functions
- Subtotals
Importing and Exporting Data
- Import data from the web
- Import data from an external source
- Export data
- Save a worksheet as a web page
- Publish a worksheet to the web
Working with Advanced Formulas
- Named ranges
- Calculate across worksheets
- Calculate with date and time functions
- Calculate with financial functions
- Calculate with statistical functions
- Lookups
For more general information on Microsoft Excel, check out the Wikipedia Microsoft Excel information page.
