Instructor Led Course Training in Derbyshire, uk

VSTO Visual Studio Tools for Office using Visual Basic Microsoft would 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  more...

VSTO Visual Studio Tools for Office using C# Sharp Visual Studio Tools for Office (abbreviated to VSTO, and affectionately known as VSTO) is the application Microsoft want you to use to program within Microsoft Office. If you want to see what the future holds for VBA, find out on this three-day course! This course uses C# as a programming language.  more...

SSAS 2008 R2 Sql Server Analysis Services Do you have data sitting in your corporate SQL Server database, but not know how to make use of it? If you already know SQL, maybe it s time to learn about multi-dimensional reporting using cubes. Speed up your reports, analyse your KPIs and improve your data-mining with SQL Server Analysis Services. This course concentrates on practical teaching and exercises, to allow you to create and modify  more...

SSRS 2008 R2 Sql Server Reporting Services SQL Server Reporting Services 2008 R2 is THE way to publish reports to your corporate intranet. Not only can you include tables of data, matrices (you may know these as pivot tables), charts, lists and subreports, but SSRS 2008 R2 also includes whizzy new report items like indicators, gauges and sparklines. On this three-day course you will use SQL Server 2008 R2 Business Intelligence Development  more...

Microsoft PowerPoint 2010 Introduction This one-day course shows you how to create presentations in PowerPoint. Learn how to use templates, draw, animate your presentations and add exciting transition effects! To attend this course you must already know how to use Windows. There will be a maximum of 6 people on each course, and each person will have their own computer.  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...

Advanced PowerPoint 2010 If you already know how to create basic presentations, maybe it is time to learn more about what PowerPoint can do. This fun one-day course shows you how to create action buttons in presentations, create custom shows, create slide masters and much more. You must already know how to create presentations in PowerPoint to attend this course.  more...

Introduction to ASP.NET using VB ...course shows you all you need to know to create web sites using ASP. NET 3. 5 (the latest version of the flagship Microsoft web development product ASP. NET). All course examples use Visual Basic 2005, and the editing software used is Visual Studio 2005. If you would rather use Visual C# as a development language, see the relevant course elsewhere on this web site. For a full list of  more...

Introduction to ASP.NET using C# Sharp ...course shows you all you need to know to create web sites using ASP. NET 3. 5 (the latest version of the flagship Microsoft web development product ASP. NET). All course examples use Visual C# 2005 (also known as Visual C Sharp 2005), and the editing software used is Visual Studio 2005. If you would rather use Visual Basic as your development language, see the separate course elsewhere on  more...

Advanced ASP.NET using C# Sharp ...course assumes that you know the basics of ASP. NET, and aims to turn you into a serious developer. The course will show how to create 3-tier applications and how to design and create your own classes. The course will also cover user controls. This course will use Visual Studio 2005 as its editing tool, Visual C# (also known as Visual C Sharp) as its programming language and ASP. NET 3. 5  more...

Advanced SQL If you are comfortable creating queries in SQL, maybe it is time to move on to learn more advanced programming topics? This three day course assumes that you know how to use the main SQL keywords SELECT, FROM, WHERE, GROUP BY and ORDER BY, and shows you how to really progam in SQL Server. Learn how to write stored procedures, create 3 different types of function, use subqueries effectively - and  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...

Microsoft Word 2003 Introduction If you haven't used Microsoft Word before, this one-day introductory course is the perfect place to start. Assuming no knowledge of Word, the course shows you how to create letters and reports in Word, format your text and print your letters.  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...

Access VBA Macros If you have mastered tables, queries, forms and reports in Access, it is maybe time to learn Access programming. This two-day course shows you how to use Access VBA to automate your databases, making your database development easier - and more fun! For a full list of course topics, see our website  more...

Microsoft Access 2010 Basic Querying Have you got a corporate database from which you want to extract information? It might be Access, or it might be Sage or in SQL Server. This one-day course will not show you how to build new databases, but it will show you how to get information out of existing ones. The course explains how databases are constructed, then shows the ins and outs of creating queries and reports. Note that this  more...

Access 2010 Introduction for Developers ...database, or make changes to an existing one? This is the course for you! Beginning with the oh-so-important principles of database design, the course explains step by step how to create a database, create queries, design forms and reports and write the Visual Basic code that you need to link all of this together. Note that it takes a long time to learn Access, so this course should be seen as  more...

Microsoft Word 2003 Advanced So you think you know how to use Microsoft Word properly? This two-day course assumes that you are comfortable with Word, and then gives an expert's view of all that it can do. Learn why outline numbering never does what you want it to, how the NORMAL. DOT template really works, and why master documents are best avoided. Thoroughly recommended!  more...

Advanced PowerPoint 2007 You have probably been using the basics of PowerPoint for some time now to create simple presentations and slide shows, but wonder what more it has to offer. This one-day course takes you further into PowerPoint, showing (for example) how to create your own templates, link presentations and even how to record macros. For a full list of course topics, see our website  more...

Microsoft Project 2007 We can not make you a perfect project manager, but we can show you how to use Microsoft Project effectively. Learn how to juggle tasks and resources, and create that all-important Gantt chart! This course also covers topics such as creating and assigning resources, conflict levelling and splitting tasks. 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...

Visual CSharp 2005 Windows Forms Been dabbling with C++, C, Java or JavaScript? This is the ideal course for you! Learn how to create forms and code in Visual C# 2005 (also known as Visual C Sharp 2005), using Visual Studio 2005 as the development environment. If you would rather use Visual Basic as your development language, see the separate course elsewhere on this web site. For a full list of course topics, see our website  more...

Advanced Visual CSharp 2005 If you have the basics of Visual C# 2005 (also known as Visual C Sharp 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...

SSRS 2005 In the current business environment organisations need to be able to transform data into clear, concise, user-friendly formats. This two-day SQL Server Reporting Services (SSRS) course shows you how to create, execute and manage reports. Using SQL Server 2005 Business Intelligence Studio you will create interactive reports and learn how to deploy and export them in various formats. You will  more...

Writing SQL You may have a fantastic database, but unless you can extract useful information from it, it may as well not exist! This two-day course shows you how to mine your database, from getting a mailing list of people meeting certain criteria through to compiling summary information for the board. Note that the SQL language varies slightly between different database providers; this course teaches the  more...

Access 2007 Introduction for Developers Have you been given the task of designing and developing a database in Microsoft Access? Finding it difficult to know where to start? This three-day course assumes no prior knowledge of Access, and covers all the basics of Access, including how to design your database, creating tables, creating Access queries, and using Access forms, reports and macros. In fact the only thing this course does  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...

Introduction to Word 2003 If you haven't used Microsoft Word before, this one-day introductory course is the perfect place to start. Assuming no knowledge of Word, the course shows you how to create letters and reports in Word, format your text and print your letters. For a full list of course topics, see our website  more...

Introduction to PowerPoint 2003 If your job involves creating presentations or slide shows in Microsoft PowerPoint, we can make your life easier. PowerPoint isn't difficult to use, but we can show you the tips and tricks to make you more productive. For a full list of course topics, see our website  more...

Access 2003 Introduction for Developers Have you been given the task of designing and developing a database in Microsoft Access? Finding it difficult to know where to start? This three-day course assumes no prior knowledge of Access, and covers all the basics of Access, including how to design your database, creating tables, creating Access queries, and using Access forms, reports and macros. In fact the only thing this course does  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 ASP.NET using VB ...course assumes that you know the basics of ASP.NET, and aims to turn you into a serious developer. The course will show how to create 3-tier applications and how to design and create your own classes. The course will also cover user controls. This course will use Visual Studio 2005 as its editing tool, Visual Basic as its programming language and ASP.NET 3.5 (the latest version) for web  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...

Advanced Word 2003 This course is ideal for people who are already familiar with the basics of Word, and want to find out what else it can do. The two-day course shows how you can create advanced tables, number pages, use paragraph styles and templates, run mail merges, create labels and create multipage reports in Word - and more besides! For a full list of course topics, see our website  more...

Advanced PowerPoint 2003 You have probably been using the basics of PowerPoint for some time now to create simple presentations and slide shows, but wonder what more it has to offer. This one-day course takes you further into PowerPoint, showing (for example) how to create your own templates, link presentations and even how to record macros. 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...

Introduction to PowerPoint 2007 If your job involves creating presentations or slide shows in Microsoft PowerPoint, we can make your life easier. PowerPoint is not difficult to use, but we can show you the tips and tricks to make you more productive. For a full list of course topics, see our website  more...

Introduction to Word 2007 If you have not used Microsoft Word before, this one-day introductory course is the perfect place to start. Assuming no knowledge of Word, the course shows you how to create letters and reports in Word, format your text and print your letters. For a full list of course topics, see our website  more...

Microsoft Publisher 2007 If you regularly produce newsletters, advertisements, flyers or any other non-standard documents, it could be time to find out how to make your life easier (Word can only go so far!). This one-day course shows you how to create and print lively and interesting publications using this flagship Microsoft publishing tool. For a full list of course topics, see our website  more...