Instructor Led Excel Training in Derbyshire, uk

VSTO Visual Studio Tools for Office using Visual Basic ...uld much rather that everyone stopped writing code within Excel, Word and Outlook using VBA, and switched to using Visto (VSTO, or to give it its full name, Microsoft Visual Tools for Office) instead. This three-day course allows you to do just that! VSTO - Visual Basic training course (3 days) You will find the course easier if you have already done some programming in VBA, however basic.  more...

Microsoft Excel 2010 Introduction New to Excel 2010? This is the perfect place to start. This one-day course shows you all the basics of Excel: creating formulae, formatting your worksheets, printing your work, creating charts and (if time allows, which it usually does) sorting and filtering tables of data. This course is suitable for those who are new to Excel.  more...

Excel VBA Macros 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  more...

Advanced VBA 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...

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?  more...

Microsoft Excel 2003 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...

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...

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 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 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...

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 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...

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...

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...