Excel Intermediate (2003/2007 & 2010)
|
Summary
|
|
|||||||||||
Excel Intermediate (2003/2007 & 2010)
Excel Intermediate (2003/2007 & 2010) - 2 day course
This two day course is aimed at existing users of Excel who wish to improve their understanding of the package and produce powerful well presented spreadsheet models. This is also suitable for existing users of Excel who have recently upgraded to 2007. The course follows on from the New User course and is full of shortcuts and tips.
This course can also be delivered In House, at your location & tailored to your liking.
Interested in this Excel Intermediate (2003/2007 & 2010) course? Contact SquareOne Computer Training to learn more here
If you want to find out more about Excel Intermediate (2003/2007 & 2010), you can make an information request below and the school will contact you with further information.
Suitability and application
This Excel Intermediate (2003/2007 & 2010) course is suitable for those people who are already users, and are at an intermediate level of Excel, and those who would like to further their understanding of the package and create powerful and well presented spreadsheets with Excel.
Excel Intermediate (2003/2007 & 2010) course content
This Excel Intermediate (2003/2007 & 2010) course is designed to cover the following areas:
Overview of New User Course
- List of Shortcuts and Tips from New User Course
- Overview of Percentages
- Absolute Cell Referencing recap using F4
Range Names
- Create Range Names
- Navigate using Range Names
- Print Range Name Areas
- Create Formulae using Range Names
3D Spreadsheets
- Setting up worksheets
- Grouping worksheets
- Calculating multiple sheets
- Linking data from other spreadsheets
- Copying worksheets quickly and tips on copying to new spreadsheet
Advanced Functions
-
Advanced Functions such as IF, IF(AND, IF(OR, Countif, VLookup, ISERROR, Data Calculations
Conditional Formatting
- Apply shading and formats to cells by setting up conditions.
- Creating Conditions using Formulae
Data Validation
- Setting up the restriction on how cells are input as dates, numbers, or time
- Setting up cells entries as a list
- Limit the characters of cell entries
- Create Error Messages
Pivot Tables
- Create Pivot Tables
- Group Data in Pivot Tables
- Show Pages
Database Functions
- Working with the AutoFilter feature
- Advanced Filters
- Data Form
- Sub Totals
Scenario Manager
- Creating and saving Scenarios
- Editing Scenarios
- Comparing and running Scenario Reports
Advanced Charting
- Producing Charts using a Function Key
- Changing the Chart Type
- Formatting Charts
- Adding Titles
- Customising the Chart
- Drawing on Charts
Expenses
The cost of this Excel Intermediate (2003/2007 & 2010) course is £260 + VAT per delegate.
In House training option - delivered nationwide in the UK
This course can also be delivered In House - and can be tailored to meet the particular requirements of your organisation. We will be happy to use any of your examples for delegates to ensure that the course is as interesting and relevant as possible.
Price for a one day closed course at your offices for up to 8 people from £500 + VAT
SquareOne Computer Training
SquareOne Computer Training
For more than 20 years, SquareOne Computer Training has specialised in the provision of "Quality Training, Consultancy and Floorwalking" services to business users on a local and national basis.
We tailor our training to suit the needs of our clients, but in general it breaks down into seven different areas:
- Classroom Training
- Show and Tell Sessions
- Customised Upgrade Workshops
- Consultancy
- Lunch and Learn Sessions
- Training to Combat RSI
- Large Scale Corporate Rollout Projects
SquareOne Computer Training can cater for group training or simple one-to-one sessions (as required). To ensure that "quality of service" is maintained at all times, we operate a policy of no more than eight delegates per session to guarantee that each individual's needs are fully met. Our customers are our business partners and we are proud of their growth and to know that training is a large contributor to this.
Our Computer training courses are in the following areas:
- CAD and Programming
- Computer Skills
- ECDL, ECDL Advanced & ECDL CAD
- Graphics and Web Design
- Microsoft Office and Accounts
- Microsoft SharePoint
- Personal Development
Our training locations - Open Courses or In House training
Our training facilities at Egerton House, Liverpool caters for up to eight delegates per session, creating an open and relaxed atmosphere, conducive to comfortable learning. We have 3 training / conference rooms, each with overhead projectors and whiteboards.
We also run our courses as in house training, where a SquareOne trainer goes to the clients site to do a course, anywhere in the United Kingdom - please contact us here to learn more.
Please contact us here to learn more about our Computer Training courses
Show all courses with
SquareOne Computer Training
Request information - obligation free
Contact information for SquareOne Computer Training
Phone no: +44 (0)151 650 6907 
To request information from Excel Intermediate (2003/2007 & 2010), please fill out the following details:
IT Rollout Project to World Leading Gas & Oil Company
Find out how SquareOne won the prestigious contract to support one of the world’s largest oil and gas companies.
And read about how SquareOne will deliver training to roll-out notebooks to its employees and introduce Microsoft Office 2010 to all users = 5,000 users in the UK and Ireland and a further 1,500 users in North Europe...
