Excel Module 2 - Gathering and Presenting Data
|
Summary
|
|
|||||||||||||
Excel Module 2 - Gathering and Presenting Data
Excel Module 2 - Gathering and Presenting Data - 1 day course in Crawley
This Excel Module 2 - Gathering and Presenting Data Course is designed for existing users of Excel who have attended Module 1 – Essentials or have equivalent knowledge. You should be confident in creating and manipulating Excel spreadsheets and creating calculations before attending. This course will equip you with techniques for managing data more effectively.
Versions available: 2003, 2007, 2010
By the end of the course delegates will be able to:
- Transfer and link information between worksheets and workbooks
- Create and format graphs
- Automate repetitive tasks with macros
- Add conditional formatting to cells
- Create and use spreadsheets with validation and protection
Interested in learning more about this Excel Module 2 - Gathering and Presenting Data Course? Contact Thales Training here.
If you want to find out more about Excel Module 2 - Gathering and Presenting Data, you can make an information request below and the school will contact you with further information.
Suitability and application
This 1-day Excel Module 2 - Gathering and Presenting Data Course is tailored to individuals who need more experience manageing data with Microsoft Excel.
Pre-requisites: You should be competent in using a PC for general business use and some prior experience using Microsoft Excel.
Excel Module 2 - Gathering and Presenting Data Course Content
This Excel Module 2 - Gathering and Presenting Data Course is designed to cover the following areas:
Formulas review
- Building formulas
- Ordering calculations
- Absolute cell references
- Using functions
Managing multiple worksheets
- Moving, copying, inserting and deleting worksheets
- Selecting multiple worksheets
- Changing tab colour (2003 and 2007 only)
Transferring and linking data
- Linking within a workbook
- Linking between workbooks
Creating and amending graphs
- Using the chart wizard
- Changing the type of graph
- Adding, removing and repositioning legends
- Customising the graph
Customising and automating the Excel environment
- Recording and running macros
- Assigning macros to quick keys
- Assigning macros to toolbar buttons (2000, XP and 2003)
- Assigning macros to the quick access toolbar (2007 only)
- Assigning macros to objects
Conditional formatting
- Changing the cell format depending on set criteria
- Databars, Top/Bottom Rules, Colour Scales and Icon Sets (2007 only)
Setting up data validation
- Setting number and date validation
- Setting drop down list validation
- Setting custom validation
- Using the audition facility
Protecting information
- Protecting worksheets
- Selectively protecting (XP, 2003 and 2007 only)
- Protecting workbooks
Expenses
The cost of this Excel Module 2 - Gathering and Presenting Data Course is £185.00 + VAT.
Lunch and refreshments: As part of your time with us you will enjoy delicious hot and cold food and refreshments daily from our restaurant.
Reference material: As part of your training you will be provided with a participant manual for you to use during your training. You can then take it away with you to use as a practical reference tool back at the office.
In House training: Should you want to hold a bespoke course at a different venue, please contact us here.
Thales Training
Thales Training - Business Training Courses & Bespoke Training Services
Thales Training & Consultancy, part of the international Thales Group, is an established training services organisation who works in partnership with our customers to develop individual, organisational and commercial advantage. Since 1998 we have been providing innovative training and managed services. Each year we continue to see our business grow delivering training and development solutions to over 10,000 participants internationally.
What we do
Thales Training & Consultancy delivers over 100 training courses in the areas of Management and People Development, IT and Computing, Technology, Project and Risk Management and Systems Engineering. All our courses are highly practical, include examples of best practice and can equip you with the skills and confidence you need to succeed in the workplace.
- Short Training Courses
- Outsourced Training Managed Service /Training Supply Management services
- Management and People Development Training
- IT / Computer Training
- Training Design and Consultancy
- Coaching Consultancy
- Health and Safety Training
- Bespoke Learning and Development Solutions
Courses designed by our trainers
All our courses are exclusively designed and regularly updated by our team of business experienced and expert trainers. This means when you attend one of our training courses you always benefit from the latest thinking and developments.
Our learning environment
All our training courses are held at our state of the art training centre in Crawley. The training centre provides a learning environment that is relaxed, offers great food, easy access, free parking and an exceptional customer service. All of which leads to time out of the office that we believe you’ll want to do again.
Show all courses with
Thales Training
Request information - obligation free
Contact information for Thales Training
Thales Training
RH10 9XN Crawley
Phone no: +44 (0)800 028 3045 
www.thales-trainingconsultancy.com
Contact Thales Training
Reviews by course attendees
Show all reviews
To request information from Excel Module 2 - Gathering and Presenting Data, please fill out the following details:
| Average rating | Quantity | Rec. | ||
| 5.0 | 1 | 100 % |
