Microsoft Excel Advanced
Vantage Training Limited
Duration: 1 Day
£305
(approximate price, please contact for quote)
Detailed information
| Type: | Training |
|---|---|
| Method: | In a classroom |
| Accreditation: | vtl Cerificate |
| Prepares for: | At the end of this course you will be able to: Use more Excel functions. Utilise Excel's database functions. Control and enhance Excel graphs. Create simple macros. Customise your Excel environment. |
| Geared towards: | With basic skills and some experience of Microsoft Excel, the topics covered on this course will enable you to further enhance your spreadsheets and to use some of the more advanced features to streamline your work |
| Requirements: | It is assumed only that you have a skill level equivalent to that gained through attending the Excel Intermediate Course. |
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
Advanced Spreadsheets
Working with range names.
Working with and consolidating multiple sheets.
Further use of Excel functions such as conditional IF and Lookup.
Working with Text
Text Functions and Text Import.
Graphs and Charts
Different graph styles, creating, enhancing and editing graph.
Printing independently or as part of the spreadsheet.
Database Functions
Creating Excel databases.
Accessing data by sorting and filtering data.
Producing summary statistics.
Cross tabulation using Pivot tables.
Specific database functions.
Introducing Macros
Recording commands in macros to simplify routines.
Editing macros and assigning to objects.
Object Linking & Embedding
Embedded Objects and Linking Objects.
Security Features
Protecting Files.
Protecting Cells.
Protecting Worksheets.
Protecting Workbooks.
Templates
Creating & editing templates.
XLSTART Directory.
Understanding AutoTemplates.
What-If Analysis
Goal Seek and Solver.
Scenarios.
Data tables.
Additional Topics
Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.
Working with range names.
Working with and consolidating multiple sheets.
Further use of Excel functions such as conditional IF and Lookup.
Working with Text
Text Functions and Text Import.
Graphs and Charts
Different graph styles, creating, enhancing and editing graph.
Printing independently or as part of the spreadsheet.
Database Functions
Creating Excel databases.
Accessing data by sorting and filtering data.
Producing summary statistics.
Cross tabulation using Pivot tables.
Specific database functions.
Introducing Macros
Recording commands in macros to simplify routines.
Editing macros and assigning to objects.
Object Linking & Embedding
Embedded Objects and Linking Objects.
Security Features
Protecting Files.
Protecting Cells.
Protecting Worksheets.
Protecting Workbooks.
Templates
Creating & editing templates.
XLSTART Directory.
Understanding AutoTemplates.
What-If Analysis
Goal Seek and Solver.
Scenarios.
Data tables.
Additional Topics
Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.
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
- IT Training
- Access Training Nottingham
- IT Training Nottingham
- ICT Training Nottingham
- Software Training Nottingham
- Computer Training Nottingham
- Access Database
- Database Design
- Database Training Nottingham
- Courses Vantage Training Limited
