Microsoft Excel Intermediate (Discounted Price)
Vantage Training Limited
Duration: 1 Day
£165
(£165 for 1st person booked, 2nd person booked for £105)
Detailed information
| Type: | Training |
|---|---|
| Method: | In a classroom |
| Accreditation: | vtl certification |
| Prepares for: | At the end of this course you will be able to: Understand Spreadsheet Basics Work with Relative v's Absolute Cell Addressing. Work with Multiple Sheets. Create Charts. Use Range Names. Import Data from another Application. Use Logical & Reference Functions. |
| Geared towards: | Who is this course for? This course is designed for existing users of Microsoft Excel. Delegates will acquire further Spreadsheet skills in order to manipulate Microsoft Excel and become more efficient with the product. |
| Requirements: | What do I need to know before attending? Delegates should have attended the Microsoft Excel Introduction course or have the equivalent skills and knowledge to that level. |
| Students per class: | 5 |
Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course program
Revision of the Basics
Revision of the topics from the Introduction Course.
Conditional formatting.
Relative v's Absolute Cell Addressing
Relative cell addressing explained.
Working with absolute cell references.
Working with Multiple Sheets
Renaming, duplicating and moving sheets.
Entering and consolidating data across multiple sheets.
Creating Charts
Creating an Auto Chart.
Using the Chart Wizard to create and edit charts.
Range Names
Understanding the advantages of using range names.
Defining or creating range names.
Using or applying range names.
Importing Data from another Application
Converting a text file into a spreadsheet.
Fixed width and delimited text files.
Using Logical and Reference Functions
Using the IF function for analysis.
Using the VLOOKUP and MATCH functions for reference.
Revision of the topics from the Introduction Course.
Conditional formatting.
Relative v's Absolute Cell Addressing
Relative cell addressing explained.
Working with absolute cell references.
Working with Multiple Sheets
Renaming, duplicating and moving sheets.
Entering and consolidating data across multiple sheets.
Creating Charts
Creating an Auto Chart.
Using the Chart Wizard to create and edit charts.
Range Names
Understanding the advantages of using range names.
Defining or creating range names.
Using or applying range names.
Importing Data from another Application
Converting a text file into a spreadsheet.
Fixed width and delimited text files.
Using Logical and Reference Functions
Using the IF function for analysis.
Using the VLOOKUP and MATCH functions for reference.
Do you need clarification regarding the course program?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course location
Vantage Training Limited
vtl are a specialist software training and application development company providing your total office solution. Our training can be tailored to your needs and our development team can provide you with time saving solutions to simplify and speed up your tasks at work. We formed as a limited company in 1995, have offices in Nottingham and Cheshire and deliver our services nationwide.
Our aim is to help you make the most of your software – whether this is through providing your staff with the skills they need to utilise programs, or through working with you to develop bespoke applications. We don’t see these as two distinct options, but more a continuum that our services can travel along. Because of our customisation, we are able to offer you what ever level of support you need – from standard classroom training, through workshop style sessions that can solve your problems on specific projects, to building applications for you with your design input. We even design and deliver courses on your existing bespoke software packages.
Our aim is to help you make the most of your software – whether this is through providing your staff with the skills they need to utilise programs, or through working with you to develop bespoke applications. We don’t see these as two distinct options, but more a continuum that our services can travel along. Because of our customisation, we are able to offer you what ever level of support you need – from standard classroom training, through workshop style sessions that can solve your problems on specific projects, to building applications for you with your design input. We even design and deliver courses on your existing bespoke software packages.
Search similar to Office Systems
- Courses IT, ICT and Computing
- Courses PC Applications
- Courses Office Systems
- excel training nottingham
- excel courses nottingham
- spreadsheet training nottingham
- spreadsheet courses nottingham
- ICT training nottingham
- IT training nottingham
- computer training nottingham
- software training nottingham
- computer courses nottingham
- micr
- Courses Vantage Training Limited