Training Course:Intermediate Excel 2003School/Trainer:Northamptonshire Chamber of Commerce
Northampton, United Kingdom
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Excel is a multi-functional tool that can aid in a number of business functions. It is useful for creating databases of customers and suppliers or can be used for financial reporting. The intermediate course takes you purely beyond understanding the basics of Excel to teaching some of the tools and techniques that will really add value to your systems
Benefits for your organisation
The user will be able to understand some of the principles behind Excel’s functions and features to increase the effectiveness when using this sophisticated program. This course builds on the knowledge of the introduction to Excel course by showing the user how to get more out of the programme.
Who is this course for
Anyone who is familiar with the basic features of Excel will benefit from attending this course. This course places great emphasis upon the importance of understanding how the programme works rather than simply learning how to perform a range of functions. It is therefore important that participants are at the appropriate level to ensure a good learning experience.
Topics covered
Revision of formulas and basic functions
Using the If function
Understanding and using AutoCalculate
Absolute and relative cell referencing
Using LookUp tables
Designing and managing lists
Sorting, filtering and subtotalling lists
Producing data forms
Outlining worksheets
Conditional formatting
Linking worksheets and workbooks
Tips and tricks
By the end of this course you will be able to
Confidentially enter basic formulas and functions
Use the inbuilt ‘If function�to resolve ‘either/or�situations
Understand and use Excels quick AutoCalculate
Get round problems that occur when they copy formulas from one place or another
Use LookUp tables to find the answers to complex queries
Design and manage long lists of data
Sort, filter and sub total lists
Produce data forms for simple database entry
Outline worksheets so that they can collapse or expand the list of data they are viewing
Automatically draw attention to data the meets specific criteria
Link worksheets and workbooks for greater productivity
Practice using our hints and tips for fun and efficiency
...''
Elements of this syllabus are subject to change.
Please go to the school's official website for training price and schedule:
http://www.northants-chamber.co.uk/
Phone:(01604) 490490
School Address:
Opus House, Anglia Way, Moulton Park, Northampton United Kingdom NN3 6JA
Jobs & Resumes: Northampton
Houses & Roommates: Northampton
Search other schools for Intermediate Excel 2003 training resources.
Other training courses offered by Northamptonshire Chamber of Commerce:
Effective Networking
Developing Assertiveness Skills
The Art of Persuasive Writing
Successful Supervisory Management
Export Documentation
Employment Legislation
Powerful Presentations
Essential Customer Service
Dealing with Difficult Customers
write persuasive sales quotations, proposals & tenders
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback. |
|
| 
