Instructor Led Excel Training in United Kingdom - Training Resources
Excel Training Provider? - Tell us about your Training!
Please select the location nearest to you:
Derbyshire
Greater London
County Antrim
West Sussex
East Sussex
West Midlands
Uk
Bristol
Surrey
England
Lancashire
Greater Manchester
United Kingdom
Upcoming Excel Training Classes
From Wise Owl Business Solutions Ltd
Excel 2007 Visual Basic
Not only our best-selling course, but also one of our favourites. This two-day course takes you through Visual Basic for Applications in Excel from recording macros through to advanced form design. On the way you will learn how to write object-oriented programs and how to create loops and implement error-handling. Microsoft Excel macros are fun - let us show you why!
For a full list of course
more...
Excel 2007 Visual Basic
Not only our best-selling course, but also one of our favourites. This two-day course takes you through Visual Basic for Applications in Excel from recording macros through to advanced form design. On the way you will learn how to write object-oriented programs and how to create loops and implement error-handling. Microsoft Excel macros are fun - let us show you why!
For a full list of course
more...
Excel 2007 Business Modelling
This course is aimed fairly and squarely at people who work in Finance and business modelling. Developed in-house by an expert in business modelling, this course shows you how to create robust business models which are easy to build and (above all) easy to test. The course makes extensive use of Excel range names.
For a full list of course topics, see our website
more...
Advanced Excel 2007
If you have been using Microsoft Excel for a while now, maybe it is time to move on a bit. This two-day course shows how you can use Excel to manage a database, create advanced charts, use some of the advanced functions in Excel and much more besides! Why not spend two days finding out just what Excel can do?
For a full list of course topics, see our website
more...
Advanced Visual Basic for Applications 2007
If you already know how to program in Access, Excel or Word VBA, maybe it is time to learn about some of the more advanced features of the language. Ever wondered what a class module is? Curious about FileSystemObjects? Now is the time to find out what these things mean!
For a full list of course topics, see our website
more...
Basic Querying in Access 2003
Does your computer system generate large amounts of data, which you find is just too cumbersome to analyse? This course assumes no knowledge of Access, and shows how to use Access queries to manipulate data (whether this is held in Access, Excel or some other format). Database design, tables, forms and reports are also normally briefly covered.
For a full list of course topics, see our
more...
Excel 2003 Visual Basic
Not only our best-selling course, but also one of our favourites. This two-day course takes you through Visual Basic for Applications in Excel from recording macros through to advanced form design. On the way you will learn how to write object-oriented programs and how to create loops and implement error-handling. Microsoft Excel macros are fun - let us show you why!
For a full list of course
more...
Advanced Excel 2003
If you have been using Microsoft Excel for a while now, maybe it is time to move on a bit. This two-day course shows how you can use Excel to manage a database, create advanced charts, use some of the advanced functions in Excel and much more besides! Why not spend two days finding out just what Excel can do?
For a full list of course topics, see our website
more...
Advanced Visual Basic for Applications
If you already know how to program in Access, Excel or Word VBA, maybe it is time to learn about some of the more advanced features of the language. Ever wondered what a class module is? Curious about FileSystemObjects? Now is the time to find out what these things mean!
For a full list of course topics, see our website
more...
Introduction to Excel 2003
If you have not used Microsoft Excel spreadsheets before, this one-day introductory course is the perfect point to start. Assuming no knowledge of Excel, the course shows you how to enter data and formulae, format your work to look attractive, print your work and create Excel charts.
For a full list of course topics, see our website
more...
Office 2007 upgrade
This course is suitable for 2 types of people: existing users of Office 2000, Office 2002/XP or Office 2003 who have just been upgraded to Office 2007, and want to learn how it works and what new features it contains as quickly as possible, and those considering upgrading and wondering whether it is worth it. The course shows the main new features of the excellent Office 2007, including new
more...
Basic Querying in Access 2007
Does your computer system generate large amounts of data, which you find is just too cumbersome to analyse? This course assumes no knowledge of Access, and shows how to use Access queries to manipulate data (whether this is held in Access, Excel or some other format). Database design, tables, forms and reports are also normally briefly covered.
For a full list of course topics, see our
more...
Excel 2007 Upgrade
Rather than spend a month finding out gradually about all the features and foibles of this major upgrade, why not do it all in a day? Learn how lists have metamorphosed into tables, what structured references are, how the new page layout view can help you, what new conditional formatting features there are, how charts have evolve and much more!
For a full list of course topics, see our website
more...
Excel 2003 Business Modelling
This course is aimed fairly and squarely at people who work in Finance and business modelling. Developed in-house by an expert in business modelling, this course shows you how to create robust business models which are easy to build and (above all) easy to test. The course makes extensive use of Excel range names.
For a full list of course topics, see our website
more...
Visual Basic 2005 Windows Forms
Been dabbling with VBA in Access, writing macros in Excel or building systems using Visual Basic 6? This is the ideal course for you! Learn how to create forms and code in Visual Basic 2005, using Visual Studio 2005 as the development environment.
For a full list of course topics, see our website
more...
Advanced Visual Basic 2005
If you have the basics of Visual Basic 2005, now is the time to do some serious development! Learn how to create your own classes, build a 3-tier application and much more.
For a full list of course topics, see our website
more...
Introduction to Excel 2007
If you have not used Microsoft Excel spreadsheets before, this one-day introductory course is the perfect point to start. Assuming no knowledge of Excel, the course shows you how to enter data and formulae, format your work to look attractive, print your work and create Excel charts.
For a full list of course topics, see our website
more...
Microsoft Excel Introduction



If you haven't used Microsoft Excel spreadsheets before, this one-day introductory course is the perfect point to start. Assuming no knowledge of Excel, the course shows you how to enter data and formulae , format your work to look attractive, print your work and create Excel charts .
more...
Microsoft Excel Advanced



If you've been using Microsoft Excel for a while now, maybe it's time to move on a bit. This two-day course shows how you can use Excel to manage a database , create advanced charts , use some of the advanced functions in Excel and much more besides! Invest two days of your time to make yourself permanently more efficient in Excel, by finding out just what it can do.
more...
Business Modelling in Excel



This course is aimed fairly and squarely at people who work in Finance and business modelling . It can often be difficult to find a course in Excel which is taught by experts for experts, so you should feel proud of having unearthed this one. The one day intensive course covers everything Microsoft Excel can do to make your life easier, and comes with a guarantee that you will learn something.
more...
Microsoft Excel Visual Basic



Not only our best-selling course, but also one of our favourites. This two-day course takes you through Visual Basic for Applications in Excel from recording macros through to advanced form design. On the way you will learn how to write object-oriented programs and how to create loops and implement error-handling. Microsoft Excel macros are fun - let us show you why!
more...
Advanced Visual Basic for Applications



If you already know how to program in Access, Excel or Word VBA, maybe it is time to learn about some of the more advanced features of the language. Ever wondered what a class module is? Curious about FileSystemObjects? Now is the time to find out what these things mean!
more...
Basic Querying in Access


Does your computer system generate large amounts of data, which you find is just too cumbersome to analyse? This course assumes no knowledge of Access, and shows how to use Access queries to manipulate data (whether this is held in Access, Excel or some other format). Database design, tables, forms and reports are also normally briefly covered.
more...
From Pitman Training Centre London
Executive PA Seminar

A massively popular seminar so book early!
This programme will equip you with all the soft skills you'll need to develop to enjoy a successful career as a PA, including organisation, assertiveness, time management and many others.
You'll gain a detailed understanding of the demands, motives and problems of the company executive. Expand and improve directly on your contribution to the management
more...
From Mullan Training
Database Design & Development



DATABASE DEVELOPMENT
Mullan Training specialise in design & development of databases - we use the technology best suited to the Client (including Access, VB/ VBA, FoxPro, FileMaker, SQL Server, etc).
We sit down with the client and identify their needs, develop a prototype based on the initial specification, then refine the system as necessary.
Please contact us if you would like to
more...
Advanced Powerpoint


...our workspace and interrelate your presentation with both Excel and Word files.
Create custom shows, hyperlinks to internal slides/ websites/ external files, etc
Delegates that have their on presentations they want to work on are encouraged to bring then to the course to work on as part of the tutorial.
LOCATIONS
Courses can be delivered at our offices in Belfast city centre (opposite the
more...
Advanced MS Excel (1 & 2 Days)


...Excel Intermediate / Advanced course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features.
PREREQUISITES
A working knowledge of Excel or our Introduction to MS Excel course.
BENEFITS
At the end of this course you will have a complete understanding of the higher functions of Excel.
You will be able to:
-
more...
Introduction to MS Excel - 1 Day


...Excel Introduction course is suitable for complete beginners to Microsoft Excel.
Prerequisites
A working knowledge of Windows is required, or our Introduction to MS Windows course. No experience of MS Excel is required.
Benefits
At the end of this course you will have a good working knowledge of Excel basics. You will feel more confident using Excel and be able to create a spreadsheet from
more...
Adobe Acrobat



...ing styles
Source files will include Word, PowerPoint & Excel
Tools
Use of tools within Adobe (Link, Movie, Sound, Page Action, etc)
Use bookmarks as navigation tools
Use bookmarks to present magnified views or take readers instantly to related topics.
Create Form Fields
Create a new form from a Word document and create one from scratch within Acrobat
Create form fields in the
more...
Introduction To Sage Line 50



...Quick Ratio
Exporting
Export Data to MS Word, MS Excel, MS Outlook
Month/Year End
Run Month End Procedures
Run year End Procedures
Line 50
Stock Control/Movements
Invoice/Quotes/Pro-forma/Credit Note
Production
Discount Structures
Bill of Materials
Sales Order Processing
Purchase Order Processing
LOCATIONS
Courses can be delivered at our offices
more...
VB Excel


... 2 day course is suitable for Advanced users of Microsoft Excel responsible for very large and variable amounts of data, or teams, who want to learn how to program features and functions to improve the accessibility and usability of their data.
PREREQUISITES
A high proficiency of Microsoft Excel is essential, or completion of our 2 day Adavnced MS Excel course.
BENEFITS
At the end of the
more...
From silicon beach training
VBA For Excel Training


This VBA for Excel training course is designed to give a good working knowledge of Visual Basic for Applications a concentrating on Microsoft Excel. During this VBA for Excel Training Course students will learn to create and edit macros, and gain an understanding of VBA code.
The Visual Basic for Applications content of the training course can be applied to other Microsoft Applications.
more...
Microsoft Excel Training


Microsoft Excel is a very powerful spreadsheet application designed to save you time and make creating spreadsheets and other documents easy. This excel training course shows you the applications capabilities, before work through exercises to create simple worksheets.
This introductory Excel training course will provide you with a working understanding of the basic features of MS Excel.
more...
Microsoft Excel Advanced Training


Microsoft Excel is a very powerful spreadsheet application designed to save you time and make easy work of calculating, displaying and sharing data.
This advanced excel training course will introduce you to some of excels more powerful features.
This one-day Excel Training course shows how you can use Excel to manage a database, create advanced charts, use some of the advanced functions of
more...
From Harlequin Solutions.
Acrobat 8.0 Professional for Print Production



Knowledge of the chosen operating system (Mac OS X or Windows) and the source application from which PDF files will be created (e.g. QuarkXPress, Adobe InDesign etc). ICC profile and colour knowledge would also useful but not essential.
Graphic Designers and Pre Press Professionals and anyone who needs to know the technical requirements for creating PDFs for High End Commercial Litho and Digital
more...
Acrobat 8.0 Professional for Business Users



Office users, marketing personnel, IT staff, or anyone who needs to create PDFs from Microsoft Office Applications for archiving, emailing and electronic distribution who already have some knowledge of Acrobat or attendance on our intro course.
Attendees will be able to create and configure PDF settings for Microsoft Word, Powerpoint and Excel from within Office.
more...
From The Office Training Company
Microsoft Excel 2003 - Introduction
Identify basic worksheet and workbook concepts and terms
Enter & edit data
Modify the worksheet
Use functions to calculate and return values
Format cells to enhance the appearance of your worksheet
Use drawing features and other enhancements
Change the page set-up to define how the printed worksheet appears
This course is suitable for absolute beginners and
more...
From Act Training
Excel Level 3
Advanced level one day hands-on instructor led course on Microsoft Excel. Topics include: Customizing the Work Area; Advanced Formula Construction; Using Pivot Tables; Working with Multiple Worksheets; Consolidating and Analysing Data; Using Protection and Display Options; Introduction to Macros; Working with Interactive Excel Web Documents.
The prerequisite for this course is Excel Level 1 &
more...
Excel Level 2
Intermediate level one day hands-on instructor led course on Microsoft Excel. Topics include: Creating Embedded Charts, Creating Chart Sheets, Modifying Charts, Formatting a Chart, Using Graphic Objects to enhance worksheets and charts, Sorting Data, Filtering Data (including setting multiple condition criteria).
The prerequisite for this course is Excel Level 1 or equivalent knowledge.
more...
Excel Level 1
Beginners level one day instructor led course on Microsoft Excel. Topics include: Excel basics, Entering data and navigating in a worksheet, Modifying a workbook, Moving and copying data, Formatting a worksheet, Printing a worksheet, Introduction to the workbook environment, Creating Excel web pages.
The only prerequisite for this course is having a basic knowledge of Windows.
more...
From IT's Easy Software Training
Microsoft Excel - Advanced
Courses take three forms; Workshop, Corporate and one to one.
Workshops are one day tutor led sessions where delegates are taught a set syllabus (see courses section). IT's Easy Training has put together a comprehensive library of business examples which are used throughout the training to ensure maximum learning. Corporate sessions can and sometimes follow the same format but usually
more...
Microsoft Excel - Intermediate
Courses take three forms; Workshop, Corporate and one to one.
Workshops are one day tutor led sessions where delegates are taught a set syllabus (see courses section). IT's Easy Training has put together a comprehensive library of business examples which are used throughout the training to ensure maximum learning. Corporate sessions can and sometimes follow the same format but usually
more...
Microsoft Excel - Introduction
Tutor led covering basic topics such as:
a The Default Screen
a Worksheets/ Workbooks
a Navigating a Workbook
a Entering Data
a Selecting Cells
a Editing Data
a Formatting Cells
a AutoSum/ Average/ Max/ Min
a Basic Sums
a Mathematical Precedence
a Copying Data
a Using the Auto Fill Feature
a Saving a Workbook
a Using the Borders Feature
a Charting
a
more...
From Computer Training Solutions UK
Excel training courses (1 day) Introduction in Bristol, Bracknell or Solihull

...Excel training courses in Bristol, Bracknell and Solihull at our three training centres, and many more at client sites. We can also deliver online training on a 1 2 1 tailored basis. Call 0800 019 6882 or visit http://www.computertrainingsolutions.co.uk for more information.
Objectives
After completing this course you will know how to:
Create a spreadsheet
Format a spreadsheet
Edit data
more...
From London Financial Studies
Exotic Risk for Senior Managers


Course Outline
New market conditions have changed forever the way in which managers need to think about complex risk. In this course we look at lessons from the recent financial crisis and how to avoid explosions of risk from illiquid and complex products during times of financial stress. Lessons learned call for a re-assessment of tools available for the management of exotic risk. More than
more...
Property Derivatives


Course Outline
Terminology, procedures, models and applications related to the latest real-estate derivatives will be covered in this course. The first day is dedicated to forwards and futures and to the introduction of a new type of modelling based on mean-reverting models with nonlinear trend. Day two covers total return swaps and options pricing and risk calculations based on value-at-risk
more...
Volatility Trading and Managing Risk


Course Outline
The course starts by providing an understanding of how to estimate volatility and the consequences of the various ways of describing volatile asset prices. This leads into sessions on the application of a range of standard volatility derivatives such as VIX futures and options and volatility swaps. The final part of the programme covers the treatment of volatility in the more
more...
Maths Refresher


Course Outline
Mathematics is at the heart of financial techniques, but many finance texts and courses assume a lot of prior knowledge. This programme aims to bridge the gap between mathematical theory and financial practice by providing a practical and visual approach to the most useful theories and methods. Calculations will be fully explained, and Excel spreadsheets will be used as a
more...
Using Inflation Derivatives in Today s Market


...e intensive exercises include simulations using Microsoft Excel or other industry standard software. Participants will be able to take away worked examples including a number of Excel functions and macros.
Who the Course is for
Traders, risk managers, fund managers, project finance and structured finance practitioners, accountants, auditors, consultants and anyone interested in the use
more...
Asset Backed Securities Assessment and Management of Risk


Course Outline
This intensive and participative 2-day programme covers the key elements of asset-backed securities and in particular mortgage backed securities. Terminology, procedures, models and applications of ABS concepts will be included along with the latest products used for hedging the risks and for developing new markets. The first day will cover the risk factors, prepayment models
more...
Risk Management and Modelling


Course Outline
This course develops a set of tools essential for the accurate management of the wide range of risks encountered in capital markets. Techniques are applied cumulatively in a sequence of workshops that include Value at Risk and its limitations, practical uses of Monte Carlo simulations and the Merton and Gaussian approaches for estimation of probabilities.
Who The Course is For
more...
Equity Derivatives Valuation and Management


Course Outline
Equity derivatives have been growing in importance over a number of years and are now well established in the financial marketplace. This seminar is for anyone who wishes to be able to price, use, manage or evaluate equity derivatives and exotic equity options. More than half of the seminar is devoted to practical small group sessions.
Who The Course is For
Anyone who wishes
more...
Interest Rate Derivatives 2 Second Generation Techniques


...de fully worked scenario spreadsheets containing relevant Excel functions and macros for participants to take away.
Who The Course is For
This course is designed for anyone who wishes to be able to price, use and manage second-generation interest rate derivatives:
* Quantitative Analysts
* Risk Managers
* Financial Engineers
* Traders and Structurers
* Researchers and others who
more...
Convertible Bonds and Securities


...egies. Exercises and pricing models are implemented using Excel functions and macros and participants will be able to take away all worked examples.
Who The Course is For
* Traders
* Credit and equity risk managers
* IT
* Middle office
* Quantitative researchers
* Hedge funds
* Portfolio managers
* Structured products desk
Prior Knowledge
* Numerate background (basic)
more...
Counterparty Risk and Collateral Management


...les and additional exercises and models implemented using Excel functions and macros.
Who The Course is For
* Credit traders and credit officers
* Risk managers and credit risk practitioners
* Structurers and salespeople
* IT
* Middle office
* Senior management
* Quantitative researchers
* Product control
* Portfolio managers
* Operations / Collateral management
Prior
more...
Numerical Techniques 1 Monte Carlo Simulation


Course Outline
Over the past two decades increased changes in the complexity of financial products and increasing computational capacity has meant that Monte Carlo methods have become the mainstay of any financial engineer's toolkit. This course illustrates how Monte Carlo can be used in modern finance for both pricing and risk management purposes. The course uses a combination of theoretical
more...
From NobleProg - IT training courses
Powerpoint 2007 Advanced Training Course





At the end of this course you will have a good knowledge in working with Microsoft PowerPoint. You will be able to use templates to build custom presentations and introduce much more stimulating graphical and animated content. You will be guided on how to use the advanced delivery options, customise your workspace and interrelate your presentation with both Excel and Word files.
more...
Excel 2007 Advanced Training Course




By the end of this course you will have a complete understanding of the higher functions of Excel. You will be able to perform very advanced calculations and functions, manipulate data using pivot tables and 'advanced' analysis, record macros and integrate with other office applications.
more...
Analysing Financial Data in Excel Training Course




Financial or market analysts, managers, accountants
Course Objectives
Facilitate and automate all kind of fincial analysis with Microsoft Excel
more...
Excel Advanced with VBA Training Course




The course is designed for anyone who is intereste in using advanced excel with VBA
more...
Excel VBA Introduction Training Course




This course has been created for anyone who works with Excel and wants to automate most of their tasks.
The course covers procedural programming in VBA. Students will learn which objects are available in Excel and how to use them. They will also learn how to write their own worksheet functions, debug programs and write complete applications using VBA forms.
more...
Excel Advanced Training Course




This course is designed of you who want to use excel to its full potential at a more advanced level
more...
Excel For Statistical Data Analysis Training Course





Audience
Analysts, researchers, scientists, graduates and students and anyone who is intrested in learning how to facilitate statistical analysis in Microsoft Excel.
Course Objectives
This course will help improving your familiarity with Excel and statistics and as a result increase the effectiveness and efficiency of your work or research.
This course describes how to use the Analysis ToolPak
more...
Excel VBA Advanced




This course has been created for VBA developers who want to learn advanced topics and use VBA macros in the most efficient way. The course deals with object oriented programming, advanced VBA functionality and integration with external libraries and data sources.
more...
From Financial Training Associates Ltd
PROJECT FINANCE MODELLING MASTERCLASS FOUR DAYS
PROJECT FINANCE MODELLING MASTERCLASS - FOUR DAYS
Course provider
This course is provided by financial modelling training company Financial Training Associates Ltd. Financial Training Associates supplies experienced finance course trainers to clients who wish to provide financial markets training for small groups of their employees. See financialtrainingassociates. com for company contact
more...
FINANCNIAL MODELLING TRAINING - FORECASTING FINANCIALS IN AN EXCEL MODEL - THREE DAYS
...EXCEL MODEL - THREE DAYS
Course provider
A financial training course from financialtrainingassociates. com.
Course purpose
a This course is designed for people who would like an opportunity to practise and improve their ability to model cash flows in Excel.
a The course is conducted in a work shop format, with the emphasis on a learning by doinga .
a During the
more...
ANALYSING AND MODELLING MERGERS LEVERAGED ACQUISITIONS - TWO DAYS

...to different parties.
Much of the course work involves Excel modelling and analysis, equipping participants with the tools to analyse leveraged acquisitions:
o Building up from partially-complete models
o Working with integrated financial statements
o Developing the acquisition structure and modelling instruments
o Running scenarios, iterating and optimising.
a This course is run in
more...
LEVERAGED FINANCE MODEL BUILDING WORKSHOP - THREE DAYS

...improve their ability to model leveraged businesses using Excel. The course is conducted in a work shop format, with the emphasis on a learning by doinga .
a On this course delegates imagine working with a business that is contemplating taking on extra debt as part of an acquisition. Participants start with a blank spreadsheet and create a detailed cash flow model from scratch, just
more...
From Aspect Training
Excel Financial Modelling
...Excel users who want to take their spreadsheets to a new level. You will learn how to create robust and professional models utilizing Excel functionality that most Excel users do not know how to use.
It builds the foundation for building strong financial models. It will cover practical application of excel's features used to solve real world cases where people work with finance. People who
more...
From Financial Training Associates Ltd
INTRODUCTION TO MODELLING LEVERAGED FINANCE TWO DAYS

INTRODUCTION TO MODELLING LEVERAGED FINANCE a TWO DAYS
Course provider
A financial training course from Financial Training Associates Ltd
Introduction
a This course gives participants a detailed insight into leveraged acquisitions as well as the world of private equity
a It improves participantsa understanding of the attractions and risks of levered structures, whether used by
more...
From Aspect Training
Microsoft Word Intermediate
Microsoft Word is the world's number one word processing application. Word documents are so ubiquitous that they are almost an IT standard in themselves. But Microsoft Word is a whole lot more than a simple word processor. It is a communication tool that allows you to share information in attractive and presentable formats. You can create comments and revisions in the proofing stage of document
more...
Excel Intermediate
...chnology into their daily tasks may wonder what Microsoft Excel training could possibly do for them. However, the tricks and tools taught in Aspecta s Excel Intermediate course reveal capabilities about Excel that most people never imagined. The greatest thing about learning the ins and outs of this powerful program on Aspecta s Excel Intermediate course is that you don't have to know a thing
more...
Excel Introduction
Over the years, the king of all spreadsheet programs has grown from a fairly simple calculator into an application with the ability to perform highly complex operations. The problem for most is figuring out where to start and how each of the functions can be used. Books are great reference tools if you already know what you're looking for, but Aspect Traininga s Excel training courses are where
more...
Excel Advanced
...es, and import and export data. After Aspecta s Advanced Excel training you're likely to walk away with countless ideas for streamlining your daily activities and enhancing the usefulness of your data. On this course , you'll scratch the surface of one of Excel's most ingenious capabilities that has the potential torevolutionize the way you conduct your tasks - the Excel web query.
Aspect
more...
Microsoft Excel VBA
...Excel applications to the next level by harnessing the power of the VBA language. Aspecta s Excel VBA course will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applications for other users. From introductory concepts to advanced developer topics, it guides you through every aspect of Excel VBA.
Aspecta s Excel VBA
more...
From Microcomputing Solutions ltd
Exploring Excel 2007
... Office.
Pre Requisites: Experience of using Microsoft Excel would be a benefit
Duration: 1 day
The topics covered are as follows:
1 The New User Interface
a The Ribbon
a Context Tabs
a Dialog Box Launchers
a Quick Access Toolbar
a View Selector/ Zoom
a Keyboard Shortcuts
2 The Office Button
a Creating/ Saving Documents
a New File Formats
a
more...
VBA Programming in Excel Visual Basics
...le to make use of the more powerful features of Microsoft Excel through VBA code.
Pre Requisites: Delegates should be proficient in the use of Microsoft Excel including commands, functions and simple Macros
Duration: 2 days
The topics covered are as follows:
1 Introduction to Macros
a What is a Macro?
a Recording a Macro
a Running a Macro
2 The VBA Editor
a The
more...
Microsoft Access Developer Advanced
...
a Setting Control Properties
a Importing Microsoft Excel data
a Creating a Main Form/ Sub Form
4 Creating a Menu System
a Designing a Menu Form
a Writing a Macro for the Menu
a Returning to the Menu
a The Startup dialog box
5 Database Utilities
a Compact and Repair
a Database Splitter
a Linked Table Manager
a Converting a Database
6 Security
a What
more...
Exploring Microsoft Excel 2007
... Office.
Pre Requisites: Experience of using Microsoft Excel would be a benefit
Duration: 1 day
The topics covered are as follows:
1 The New User Interface
a The Ribbon
a Context Tabs
a Dialog Box Launchers
a Quick Access Toolbar
a View Selector/ Zoom
a Keyboard Shortcuts
2 The Office Button
a Creating/ Saving Documents
a New File Formats
a
more...
Advanced Microsoft Excel
...introduce some of the more advanced features of Microsoft Excel.
Pre Requisites: Attendees should have a good working knowledge of Microsoft Excel and be comfortable with arithmetic.
Duration: 2 days
The topics covered are as follows:
1 Data Functions
a Text Functions
a Logical Functions
a HLOOKUP/ VLOOKUP
a Error Functions
2 Handling Worksheets
a
more...
Advanced Microsoft Project
Objectives: This course gives an in depth understanding of the features found in Microsoft Project.
Pre Requisites: An understanding of the basic features of Microsoft Project is recommended.
Duration: 1 day
The topics covered are as follows:
1 All about Calendars
a Base Calendars
a Resource Calendars
a Task Calendars
a How they interact
2 All about Fields
a
more...
Intermediate Microsoft Excel
...
Pre Requisites: A basic level understanding of Microsoft Excel is recommended.
Duration: 1 day
The topics covered are as follows:
1 More about Calculations
a Absolute References
a Using Functions
a Examples of Functions
2 More Features
a Using Comments
a Splitting and Freezing
a Using Zoom
a The Paste Special Command
3 More about Printing
a
more...
Introduction to Microsoft Excel
...he topics covered are as follows:
1 Introduction to Excel
a Starting the Program
a Tour of the Screen
a Menus and Toolbars
a Personalising your system
a Entering Text & Numbers
2 Excel Basics
a Spreadsheet Concepts
a Moving around a Workbook
a Selecting Cells
a Entering Text & Numbers
a Entering Pre-Defined Lists
a Defining a Custom List
a Summing
more...
From New Horizons - London
Microsoft Office Courses


The Microsoft Office System contributes to your success by building connections between your people, information and business processes. Microsoft Office has evolved from a suite of personal productivity products to a more comprehensive and integrated system.
New Horizons Office training keeps you up-to-date on all the latest features and products within the new Microsoft Office System with
more...
From 2e2
Microsoft Excel Fundamentals
Objectives: By the end of this course you will be able to produce a formatted worksheet, confidently create basic dynamic formulae and create a visual representation of the data, using the provided manual if required.
Prerequisites: This course requires that you have a good working knowledge of Microsoft Windows and you should also be able to use a mouse and keyboard.
more...
Microsoft Excel Intermediate
...nd. Change the View, General, and Calculation settings of Excel; and customise toolbars and menus. Add borders and shading; apply special formats; create, apply, and modify styles; and change the orientation of cells. Sort lists by columns; and filter lists based on complex criteria. Format data points; create combination charts and trend lines; and add and format graphic elements. Embed and
more...
Microsoft Excel Advanced
Objectives: After completing this course, you will know how to: Use names to assign descriptive labels to cells; use financial functions to calculate values based on conditions. Use data tables to view the effects of multiple input values on a formula. Use the Subtotal command, the Subtotal function and database functions to summarise list data; and use data forms and validation to facilitate data
more...
From Ambar Hamid Training
Secret Yellow Seminar - The World's Best Internet Marketing Event - Live in London on 2nd December 2006

...Excel Centre, London on Saturday, 2nd December 2006 with the world's top Internet Marketers from the Far East who are now making their Millions.
You will discover multi million Pounds secrets from,
Ewen Chia - The Worlds No 1 Affilliate Marketer who recently made USD$1.497 Million in 48 hours and also made another USD$1 Million through affiliate marketing
Jo Han Mok - The No.1 bestselling
more...
From Solveway
Microsoft Excel 2000
...Excel 2000: Foundation
Course number: 074 200
Software version number: Excel 2000
Course length: 1 day
Overview: Students will learn basic worksheets skills and how to work with data in worksheets.
Prerequisites: Windows: Introduction, or equivalent knowledge.
Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
more...
From Fintuition
Valuation Techniques for Hedge Funds
This two-day course teaches the skills and tools required to value companies, including quantitative methods of investment analysis, sources of risk and return, specials situations and strategic analysis. Financial modelling techniques using Excel will be explained, with ample exercises and opportunities to apply these skills in practice.
more...
From Ability Software Consultants
OpenOffice.org
OpenOffice 1.1 is a multi-platform office productivity suite compatible with all major file formats, including the Microsoft Office applications Word, Excel and PowerPoint. It can be downloaded and installed completely FREE of all charges.
more...
