Microsoft Excel Intermediate
Vantage Training Limited
Duration: 1 Day
£305
(approximate price, please contact for quote)
Detailed information
| Duration: | 1 Day |
|---|---|
| Price: | £305 (approximate price, please contact for quote) |
| Type: | Training |
| Method: | In a classroom |
| Accreditation: | vtl Certificate |
| Prepares for: | At the end of this course you will be able to: Use Excel to structure and analyse your data. Extend the functionality of your spreadsheets by using more complex calculations. Use Conditional Formatting on your worksheets. Understand and apply Data Validation to control input. Create Excel charts and control their formatting. Manipulate database style lists of data with simple Pivot Tables and database functions. |
| Geared towards: | With a little experience of Microsoft Excel or similar software, this course gives you a fast-paced introduction to the power of Excel's core features, giving you the knowledge to design and produce more efficient, better presented spreadsheets. |
| Requirements: | It is assumed only that you have a skill level equivalent to that gained through attending the Excel Introductory 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
Re-capping the Basics
The Excel Screen, the Ribbon and other toolbars.
Basic formula entry and editing.
Standard Formatting
Formatting cells, Format painting, Autofill, copy and paste.
Themes and Styles.
Adding & Deleting Rows & Columns.
Taking Formulae Further
Absolute Cell References.
The IF() Function.
Lookup Functions.
Introducing Text Functions.
Taking Formatting Further
Conditional Formatting.
Extended Formats and Formulas.
Data Validation.
Using Comments.
Useful Tools and Features
Ranges of cells and using range names.
Smart Tags.
Checking Spelling, Find and Replace.
Charts & Graphs
Sparklines
Creating and editing chart.
Saving a chart template.
Printing
Using Page Set-up and Print Preview.
Printing charts separately.
Using page breaks.
Using automatic page numbering, headers and footers.
Database Functionality
Recapping the basics of sorting and filtering data.
Creating Excel Tables.
Introducing Pivot Tables and Pivot Charts.
Additional Topics
Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.
The Excel Screen, the Ribbon and other toolbars.
Basic formula entry and editing.
Standard Formatting
Formatting cells, Format painting, Autofill, copy and paste.
Themes and Styles.
Adding & Deleting Rows & Columns.
Taking Formulae Further
Absolute Cell References.
The IF() Function.
Lookup Functions.
Introducing Text Functions.
Taking Formatting Further
Conditional Formatting.
Extended Formats and Formulas.
Data Validation.
Using Comments.
Useful Tools and Features
Ranges of cells and using range names.
Smart Tags.
Checking Spelling, Find and Replace.
Charts & Graphs
Sparklines
Creating and editing chart.
Saving a chart template.
Printing
Using Page Set-up and Print Preview.
Printing charts separately.
Using page breaks.
Using automatic page numbering, headers and footers.
Database Functionality
Recapping the basics of sorting and filtering data.
Creating Excel Tables.
Introducing Pivot Tables and Pivot Charts.
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.
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
