✖

Reset your password To start, please enter your username

Reset your password If an account exists using the username you entered, you will receive an email with a reset code, please use this to reset your password.

Please check your spam folder or call us on 0191 377 8377 if you have trouble finding your reset code.

✖

We use cookies to offer you a better experience and to analyse how visitors use our site, for more information please click here . Thank you.

Cookies are small text files that are stored on your computer, phone, tablet or other web enabled device when you visit a website.
We use the following cookies linked to analytics:
_ga, __gat_gtag_UA_845645_1 and _gid

Our cookies do not store private data or data that can identify you personally.

To view full cookie information please click here

Accept All

Functional Only

Menu

Menu
Please enter some text to search

X

Contact
Click to enquire online or call on 0191 377 8377
Contact Online
Sign in

All Courses All Services Public Course Schedule Compare Courses

Courses

After Course & About

Course Info

Public Scheduled Course Dates Training Venue Information Course Types & Bespoke Training Course FAQs Course Feedback T&Cs

After Course

Evaluate Your Course Trainer Login

About Us

Join Our Team

0191 377 8377

All Microsoft Management Adobe AutoDesk Personal
Development Technical IT Sage Entrepreneurship Graphic
Design Web
Development Environment
Health and Safety

Visual Training Courses in Otley

Skip to: Courses Reviews About Your Course Why Us?

Show my favourites

Compare courses

Filter activated
Remove filter
Showing favourite courses only
Remove filter
Go to favourites

- Access Advanced Database Design
  
  Duration: 2 Days
  
  Overview: This Microsoft Access course is for delegates who have sound skills in the use of MS Access and are now ready to expand their knowledge into some of the more specialised and advanced features of the software. This course will provide delegates with the skills needed to create complex queries, create macros to automate tasks, enhance forms and reports and use the Access programming language Visual Basic for Applications (VBA), enabling delegates to really take control of their databases.
  
  View Full Outline
  
  Public Scheduled Dates:
  Prices per delegate. All prices exclude VAT
  
  <
  
  >
  
  Private Courses:
  Starting from £1690 for up to 8 delegates
- Excel Advanced Macros
  
  Duration: 1 Day
  
  Overview: This course is designed to introduce you to the Macro environment of Excel, it will provide you with the confidence to record macros in Excel and then be able to gain a better understanding of the code and make changes to it.
  
  We even teach you some commands that cannot be recorded, such as how to show a message to the person who runs the macro.
  
  It will not turn you into a fully-fledged programmer, but you will feel more confident in the Visual Basic Editor, and thus be able to explore more aspects of programming in Excel.
  
  For example, if you record a macro before the course and you make a mistake in the recording, you invariably have to start the recording again. After this course you will be able to step through the code, decide what you wish to keep and what you wish to get rid of, then record an extra part and add it to the code you kept thus running all the code at once.
  
  Important Note : An Excel Macro is created from lines of code of Visual Basic for Applications. These lines of code are stored in a collection called a 'Macro' or a 'Procedure'. It all depends on which angle you are coming from. If you're a programmer, you call these lines of code a Procedure; if you are an advanced user of Excel you call these lines of code a Macro.
  
  View Full Outline
  
  Public Scheduled Dates:
  Prices per delegate. All prices exclude VAT
  
  <
  
  >
  
  Private Courses:
  Starting from £745 for up to 8 delegates
- VBA Essentials using Access
  
  Duration: 3 Days
  
  Overview: This course is aimed at those who would like to develop their skills and knowledge of VBA programming in Access application development.
  
  View Full Outline
  
  Private Courses:
  Please contact us for a quote
- VBA Essentials using Excel
  
  Duration: 2 Days
  
  Overview: This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to modify Excel to be better suited to their environment, by creating their own functions and procedures.
  
  View Full Outline
  
  Public Scheduled Dates:
  Prices per delegate. All prices exclude VAT
  
  <
  
  >
  
  Private Courses:
  Starting from £1790 for up to 8 delegates
- VBA using Word
  
  Duration: 2 Days
  
  Overview: This course is designed to help experienced Word users automate common tasks and create end user systems. The user does not have to be a programmer to benefit from this course but any programming experience will be of value
  
  View Full Outline
  
  Private Courses:
  Please contact us for a quote
- You don't seem to have any favourites stored yet. To add a favourite, please click on the heart next to any course in the course lists or in the right menu on a course page.
  
  Please note if you delete your cookies, your favourites will disappear.
  
  We are here to help you find the right training for you, please click here to contact us online or give us a call on 0191 377 8377

Course Title	Duration
You don't seem to have any favourites stored yet. To add a favourite, please click on the heart next to any course in the course lists or in the right menu on a course page. Please note if you delete your cookies, your favourites will disappear. We are here to help you find the right training for you, please click here to contact us online or give us a call on 0191 377 8377
Access Advanced Database Design This course can be attended online or at a training venue Compare 0/4 Compare	2 Days	Course Dates	View Course

Excel Advanced Macros This course can be attended online or at a training venue Compare 0/4 Compare	1 Day	Course Dates	View Course

VBA Essentials using Access This course can be attended online or at a training venue Compare 0/4 Compare	3 Days	Obtain a quote for a private event		View Course

VBA Essentials using Excel This course can be attended online or at a training venue Compare 0/4 Compare	2 Days	Course Dates	View Course

VBA using Word This course can be attended online or at a training venue Compare 0/4 Compare	2 Days	Obtain a quote for a private event		View Course

No results found on this page, searching our other courses

Ask us a question:

Call us on
0191 377 8377
to discuss your requirements.
Mon-Fri 9am-5pm.
Ask A Question
Name*

Email*

I would like IT Training solutions Ltd to keep me informed with offers and news it believes would interest me*

Yes

No

By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.

"I found all the information useful and was able to follow all instructions given to me. "

E.M. Newcastle GP Services, Sage Accounts Level 1

"Excellent training course! "

F.W. Nissan, Microsoft Project Essentials

"Very good and useful course. "

J.O. Northumbria University, Adobe InDesign Level 1

"I enjoyed it. "

J.C. Lincolnshire Housing Partnership, Document Storage in Microsoft Office 365

Following this training what are you going to do differently "We will use this to create internal KPIs dashboards "

R.D. EGGER UK Ltd, Excel Analysing and Presenting Data with Dashboards and Pivot Tables

"Excellent course well presented. "

N.C. Cembre Ltd, Excel Level 1 Essentials

"Would recommend to others in performance reporting posts "

L.F. Durham County Council, Microsoft Power BI Desktop

Following this training what are you going to do differently "A lot! Wish I could get back all the time I spent struggling with formats and sorting much clearer now and I feel confident it will be so much easier and quicker going forward. Thankyou! "

B.B. Riverford, Excel Essentials

Any other comments or recommendations "I feel as though I have learnt lots of new functions that will assist me in doing my job "

T.W. Nicholsons Sealing Technologies, Excel Level 2

Following this training what are you going to do differently "Use the new skills I have learned today "

A.P. Teesworks SC, Word Essentials

Any other comments or recommendations "Very good, useful course. "

K.G. South Tyneside Council, Excel Level 3

Following this training what are you going to do differently "A definite will be using the insert function tool using keyboard shortcuts regular till become 2nd nature hopefully ?? "

S.T. UPM Raflatac, Excel Level 2

"Excellent trainer with huge knowledge and friendly attitude. Fab course! "

E.S. Nissan, Excel Level 3

"Trainer was excellent, very enthusiastic and knowledgeable. "

A.M. Nissan, Excel Level 2

"This has been a very useful course. "

S.F. Nissan, VBA Essentials using Excel

Virtual Training: What is it? Watch the video:

Welcome to IT Training Solutions!Expert trainers, courses delivered online or in person, small class sizes, flexible content, course materials included and available via your personal training account or in printed form.

Join The Team!

Visual Reviews

"I found all the information useful and was able to follow all instructions given to me."

E.M. Newcastle GP Services, Sage Accounts Level 1

"Excellent training course!"

F.W. Nissan, Microsoft Project Essentials

"Very good and useful course."

J.O. Northumbria University, Adobe InDesign Level 1

"I enjoyed it."

J.C. Lincolnshire Housing Partnership, Document Storage in Microsoft Office 365

Following this training what are you going to do differently "We will use this to create internal KPIs dashboards"

R.D. EGGER UK Ltd, Excel Analysing and Presenting Data with Dashboards and Pivot Tables

"Excellent course well presented."

N.C. Cembre Ltd, Excel Level 1 Essentials

"Would recommend to others in performance reporting posts"

L.F. Durham County Council, Microsoft Power BI Desktop

B.B. Riverford, Excel Essentials

Any other comments or recommendations "I feel as though I have learnt lots of new functions that will assist me in doing my job"

T.W. Nicholsons Sealing Technologies, Excel Level 2

Following this training what are you going to do differently "Use the new skills I have learned today"

A.P. Teesworks SC, Word Essentials

Any other comments or recommendations "Very good, useful course."

K.G. South Tyneside Council, Excel Level 3

Following this training what are you going to do differently "A definite will be using the insert function tool using keyboard shortcuts regular till become 2nd nature hopefully ??"

S.T. UPM Raflatac, Excel Level 2

"Excellent trainer with huge knowledge and friendly attitude. Fab course!"

E.S. Nissan, Excel Level 3

"Trainer was excellent, very enthusiastic and knowledgeable."

A.M. Nissan, Excel Level 2

"This has been a very useful course."

S.F. Nissan, VBA Essentials using Excel

Why IT Training Solutions?

Friendly, knowledgeable trainers
Adaptable, flexible training solutions: we work along with you to find training which fits your requirements
Small class sizes
Choice of training locations
100% trainer led
Over 30 years experience training

Your Course Portal

Access your course materials online via your own personal training account*.

More information on Visual in Otley

We provide Visual courses in Otley, our Visual Courses can be available as scheduled or private courses, meaning that you can benefit from training that fits your exact requirements. If you are unsure which Visual Courses would suit you, or if you would like help deciding, please give us a call on 0191 377 8377 or contact us online, we will be happy to help.

Private Courses

Private Courses the ultimate in flexible training. You choose the timescale, you choose the location, you choose the delegate(s) and you choose the content.

Public Scheduled Courses

Scheduled Courses easy to book - we set the date, location and outline, so all you need to do is let us know which course you would like to attend.

If a public scheduled course is not available for Visual in Otley, we can provide private, or onsite, courses for you in your location. One way or another, contact us to let us know how we can help or to book your courses.

Visual training courses are available in in Otley, you can call us on 0191 377 8377 to discuss your training options, we will be happy to help you find the right training solutions for you.

Contact us online or call
0191 377 8377 (Mon-Fri, 9am-5pm)

Click here to contact us online

.JavaScriptEnabledForm { display: none !important; visibility: hidden !important; } .JavaScriptDisabledForm { display: block !important; visibility: visible !important; }

Contact Information:

0191 377 8377 ^{Monday-Friday, 9am-5pm}
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU

Flexible content
Virtual courses
Classroom training
Small class sizes
Course materials included
Lunch and refreshments at our training venues
Expert trainers
Questions encouraged

This site requires JavaScript - JavaScript is currently disabled on your device, please be aware that certain functionality may not work until you enable JavaScript.

Visual Training Courses in Otley

More information on Visual in Otley

Private Courses

Public Scheduled Courses

Contact us online or call 0191 377 8377 (Mon-Fri, 9am-5pm)

Contact us online or call
0191 377 8377 (Mon-Fri, 9am-5pm)