The course will enable the delegates to produce and edit effective macros using the Visual Basic Editor. Suitable for: Intermediate/Advanced users of Excle who wish to automate procedures on their spreadsheets
Suitable for: Groups of 1 - 4 people with specific business issues that they need to address. People needing to get more from the software they already have. People looking to integrate the various MS Office applications.
Our Get Into IT Excel is an intermediate level course providing people with a clear understanding of the power Excel in everyday use, learn new skills on Excel realise potential of this everyday technology at their finger tips. Suitable for: This course will benefit those individuals who have access to Microsoft Office packages
To be able to quickly and confidently work with simple spreadsheet. Suitable for: Aimed at those who are new to Excel or those who have been using it for some time but are self-taught
Suitable for: Users with a basic understanding of Excel 2000 who want to consolidate and expand on their knowledge of the basic features in a short space of time.
This course introduces the skills necessary for using multiple worksheets and using Excel as a database. It includes tasks to create a database, sort data, and work with the data form. Students will also learn how to use AutoFilter, advanced filters, and database function formulas. This course also covers the charting features of Excel and students...
By the end of the course delegates will be able to produce a functional and professional spreadsheet that is fully automated to provide data analysis. Suitable for: Those with basic excel skills
To learn Excel to Microsoft Office Expert Level The flexibility and value of a self-study course designed to enable you to work at your own pace. A personalised workbook to use as a reference guide on completion of the course. The opportunity to gain the widely recognised Pitman Training certificate. The opportunity to gain an OCR CLAiT Advanced...
To enable the user to feel comfortable with more complex Excel requirments and to give them the confidence to expand existing skills to introduce more efficient methods of working. Suitable for: Those who have attended Foundation training or have good basic Excel skills
To give users an extended knowledge of the features and functions within Excel and realise the advantages of using a powerful electronic spreadsheet. Delegates will learn how to create and modify spreadsheets, enhancing them with charts and graphics and using more advanced formulae. Suitable for: This course is suitable for users with a basic...
To give users an extended knowledge of Excel's advanced features and functions. Delegates will learn how to manage, automate and customise workbooks. Suitable for: This course is suitable for existing users of Excel who want to gain further in-depth knowledge in a short space of time.
To give users an introduction to Excel and enable them to realise the advantages of using a powerful electronic spreadsheet. Delegates will learn how to create and modify spreadsheets, whilst also learning key essentials such as basic calculations and formatting work sheets. Suitable for: This is suitable for anyone who wants a basic knowledge of...
You will learn: Advanced worksheet formatting and Excel shortcuts. Using named ranges in formulae. Formula Auditing - tracking changes. 'What if' forecasting using one and two variable data tables and scenarios. Formula building. LOOKUP functions. Automatic Outline. Restricting input using protection and data validation. Using the form tools. Goal...
To gain knowledge and skills on microsoft excel. Suitable for: Anyone
Suitable for: Specially designed for people with basic computer skills who have no knowledge of Excel.
To give the client a full and comprehensive insight as to what Excel can do and to develop existing skills. Suitable for: Those with a good working knowledge of Excel who wish to expand their knowledge to learn potentially beneficial features
To introduce users to spreadsheets. At the end of the course delegates will be. capable of basic formulae and formatting techniques in Excel. Suitable for: Delegates who have familiarity with and experience of working in the Windows. environment and using Windows Explorer.
You will receive the latest news by e-mail