News

Pearson Vue Authorised Test Centre

Training 26 are excited to announce that we a now an authorised Pearson Vue Test Centre (visit www.pearsonvue.co.uk for more information about their services). Pearson Vue schedule and provide computer based exam delivery services for some of the biggest names throughout the world and hence have very stringent quality standards that have to be adhered to. They also have a very vigorous routine for checking the suitability of any third party wishing to be an Authorised Test...

Read more

How to Create Your Own Website!

Course Title:        How to Create Your Own Website! Description: The topics included in this course provide the user with the skills needed to create a website. The course covers how to set up domain and hosting, install and configure CMS and how to design your website. Access to exclusive domain, hosting and theme offers. Who is this for and Pre-requisites: Those interested in learning how to build websites using open-source and freely available...

Read more

Microsoft Excel Power Pivot

Data Analysis Using ‘Get & Transform’ and Microsoft Excel Power Pivot Description: The topics included in this course provide the user with additionaltools for data analysis. The course covers importing data from avariety of sources, analysing quantities of data beyond the normalscope of Excel and speeds up linking data held in different tables Pre-requisites: Delegates must have an advanced knowledge of Microsoft Exceland be comfortable using Pivot Tables Duration: One Day An Introduction to Get and...

Read more

Microsoft Excel VBA (Visual Basic Applications)

  Course Title: Microsoft Excel Visual Basic Applications (VBA) Aims: To illustrate how to use macro programming to speed repetitive tasks when employing Microsoft Excel Pre-requisites: Delegates MUST be familiar with the use and exploitation of Microsoft Excel at an Advanced level Duration: Two Days   What is a Macro Recording macros Running macros Relative referencesAssigning Macros To Objects To the Quick Access Toolbar Editing Macros The Visual Basic Editor The Project Explorer The Code Read more…

By Angela Jones, ago

Microsoft Excel Introduction

         Microsoft Excel Introduction Aims: Introduces the workings and concepts of spreadsheets in Excel including simple formulas and formatting Pre-requisites: Attendance of a Windows Introduction or a good understanding of the Windows Environment Duration: One day   Excel Introduction Spreadsheeting concepts Using the keyboard and mouse The Excel Screen The Excel Ribbon          Working with the Tabs Using the Quick Access Toolbar Excel Basics Creating new workbooks Saving files Opening and closing Read more…

By sysadmin, ago

Microsoft Excel Intermediate

Microsoft Excel Intermediate Aims: Looks deeper into Excel, including analytical and data retrieval formulas Pre-requisites: Must have attended the Microsoft Excel Introduction or have a good working knowledge of the product Duration: One day   Workbooks Concepts of a Workbook Moving around a Workbook Inserting and deleting worksheets Renaming and moving worksheets Linking worksheets with formulas Workbook defaults Linking Understanding the concepts of Linking Using formulas to link sheets Linking files using formulas Using Paste Link to Read more…

By sysadmin, ago

Microsoft Excel Advanced

Microsoft Excel Advanced Aims: Enables users to customise Excel spreadsheets to produce valid and clear reporting of data integrated with macros for faster ways of working Pre-requisites: Must have attended the Microsoft Excel Introduction & Intermediate courses, or have an extensive working knowledge of the product Duration: One day   Text and Conditional Functions Common Text Functions Countif and Countifs Sumif and Sumifs Averageif and Averageifs Combining and Nesting functions Lookup Functions What is a Read more…

By sysadmin, ago

Training26 are moving

We are please to announce that as of the end of June 2018 we will be based at the Leeds Media Centre, 21 Savile Mount, Leeds, still situated on a major bus route and only 1.5 miles from the Leeds Train Station. Parking is available, which is one the main reasons for our move. Leeds has become a hive of activity over recent years and so parking is rapidly becoming more and more difficult to Read more…

By sysadmin, ago