Reset your passwordTo start, please enter your username
Reset your passwordIf 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.
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.
Overview:
Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data.
This Excel introductory course will enable delegates to gain a good general understanding of the main features of Microsoft Excel, giving them the ability to produce standard spreadsheets, create formulae and format and print spreadsheets.
Public Scheduled Dates:
Public scheduled prices per delegate. All prices +VAT
<
>
Private Courses:
Private courses start from £645 for up to 8 delegates
Overview:
In Microsoft Office Excel Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target students for this course are students who desire to gain the skills necessary to create spreadsheets from scratch using more advanced functions and formulas, sort and filter data, analyse data and present data in visual and vibrant ways.
Public Scheduled Dates:
Public scheduled prices per delegate. All prices +VAT
<
>
Private Courses:
Private courses start from £645 for up to 8 delegates
Overview:
This course will benefit those who are already up to speed with Microsoft Excel but would now like to automate some common tasks and apply advanced analysis techniques to more complex data sets. This Excel course is aimed at anyone desiring to gain the skills necessary to create macros, audit and analyse worksheet data, create Excel PivotTables and Excel PivotCharts, use lookup tables and import and export data.
Public Scheduled Dates:
Public scheduled prices per delegate. All prices +VAT
<
>
Private Courses:
Private courses start from £645 for up to 8 delegates
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.
Public Scheduled Dates:
Public scheduled prices per delegate. All prices +VAT
Private Courses:
Private courses start from £745 for up to 8 delegates
Overview:
This outline below contains an overview of a wide range of features within Excel that when used together can be used to create interactive visual reports and dashboards. The course will show delegates how these features can be used individually to present data but can also be used in combination to make powerful and insightful reports.
The course content has been pulled from a mix of our Excel courses, some content will be recapped to ensure all delegates are at the same level as they are used in conjunction with each other to effectively present data and build reports.
Public Scheduled Dates:
Public scheduled prices per delegate. All prices +VAT
Private Courses:
Private courses start from £645 for up to 8 delegates
1. Get and Transform (Power Query) 2. Power Pivot - Data Models and DAX calculations 3. Dashboard Creation with Pivot Tables, Charts and Slicers
It is aimed at users who want to analyse data from multiple sources and want to create effective data dashboards. This course will be delivered on Excel 2016 or above and using generic data files that aim to appeal to a wide audience.
Public Scheduled Dates:
Public scheduled prices per delegate. All prices +VAT
Private Courses:
Private courses start from £745 for up to 8 delegates
Overview:
This course is designed to help users get the most from the advanced functions in Excel. Advanced Lookup and Reference functions to help you gather data, Text functions to organise and validate the data, Logical functions to analyse the data. You will use the advanced features of Microsoft Excel to attain a high degree of proficiency as an Excel power user within the area of writing functions.
Private Courses:
Private courses start from £745 for up to 8 delegates
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.
Public Scheduled Dates:
Public scheduled prices per delegate. All prices +VAT
Private Courses:
Private courses start from £1790 for up to 8 delegates
Overview:
This two-day ArcGIS training course is aimed at those who are new to the ArcGIS Desktop software (or to GIS), or those at a novice level. Through a combination of tutor led teaching and hands-on exercises it aims to give users confidence to use the power of GIS and ArcGIS to display, manipulate and analyse information geographically, with the result that they are able to make more informed decisions.
Day 1 covers basic data manipulation and presentation - it will show you how to use and create Map Documents and Layers in ArcMap, and how to make best use of the Catalog. You will also learn different ways of interacting with features on the map, how to define and save symbols for features, and how to present data in a layout.
Day 2 covers basic data analysis, editing and importing - it will show you how to write a query to select specific features; how to bring in data from an external source such as Excel; how to set up an attribute join to visualise such data on the map; how to create shapefiles and geodatabases; how to edit existing map features and create new ones using the edit toolbar.
Overview:
Power Apps is a suite of apps, services, connectors, and a data platform that provides you with an opportunity to build custom apps for your business needs.
This 1-day course explores the basic building blocks and allows you to create your own Apps and understand how to develop your skills to the next level.
Public Scheduled Dates:
Public scheduled prices per delegate. All prices +VAT
Private Courses:
Private courses start from £845 for up to 8 delegates
Overview:
This course is aimed at the user wishing to acquaint themselves with the basic features of Office 365. The course stresses the role of Outlook as an "All in One" messaging, SharePoint for Team collaboration and Lync 2010 for unified communications.
Overview:
This course is aimed at the user wishing to acquaint themselves with the basic features of Office 365. The course covers the role of using the Office Online Applications to create, edit, comment and share documents.
This course can be tailored to meet your organisations requirements.
Each topic area is 90 minutes. Choose 4 x 90 minute modules for a 1 day course, or 2 x 90 minute modules for a half day course
Overview:
Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources.
With Power BI Desktop, you get a report authoring tool that enables you to connect to and query data from different sources using the Query Editor. From the datasets you build with Query Editor you can create Reports and Visualizations or dashboards within Power BI Desktop. Reports can then be published.
This course covers the use of Power BI Desktop to connect to data, create Visualizations, query the data and publish reports.
This course does not cover MS Power BI Pro, Power BI accessed via Office 365 or SharePoint Services.
Public Scheduled Dates:
Public scheduled prices per delegate. All prices +VAT
<
>
Private Courses:
Private courses start from £1690 for up to 8 delegates
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.
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.
Which part of the course did you find particularly valuable
"I enjoyed how adele layed the framework out for me to build my skills for the basics. I can now take another course to grow my skills from this. No bad habits! "
S. Rowen Homes, Excel Essentials
Which part of the course did you find particularly valuable
"Learning how to use the formula to manipulate data "
P.C. NHS Fleet Solutions, Crystal Reports Level 1
"Fantastic. All great! "
A.S. University of Leeds, Excel Level 3
"Confidence has grown and I'm raring to go. I came confused and left armed with information and knowledge "
K.J. Direct Rail Services, Minute Taking
"I was a complete beginner, but able to keep up with all the coursework so have experienced a lot of content. I will be using project going forward to manage my timelines so the overall understanding has helped. "
S.C. Lansinoh, Microsoft Project Essentials
Any other comments or recommendations
"Thanks to Rob for spending the time to patiently take us through the course "
S.C. Lansinoh, Microsoft Project Essentials
Are there any aspects of the course which you feel require improvement
"The course was very informative and ran at a great pace. I'd book more courses with IT Training Solutions "
S. carveti partnership, Excel Level 3
Following this training what are you going to do differently
"Use excel more for stock levels, validation sheets etc "
G.S. Egger UK Ltd, Excel Level 1 Essentials
"All of it was valuable and helpful "
P.S. Thermo Fisher Scientific, Train the Trainer Training Skills for the Workplace
"I learnt a lot more than I thought I would during the course, and Adele was able to explain some functions that I have used before, but didn't fully understand, which will benefit me in applying to more of my work. "
S.R. , Excel Level 3
"This course will change the way we format and present data in the department, saving us time and giving us a much better overview of our workload, budgets, and monthly stats. "
G.B. The Labour Party, Excel Level 3
"It has given me the confidence to start a spreadsheet from scratch again rather than copying and amending other peoples. "
J.R. Yorwaste, Excel Level 3
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
"Very informative "
M.L. Van Leeuwen, Negotiating and Influencing Skills
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.
We provide Excel courses in The north, our Excel 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 Excel 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 Excel in The north, 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.
Excel training courses are available in in the and North, 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.
For those working in finance in the and North, Excel and Sage can be excellent tools to help you keep track and progress in organising and presenting your data. You can contact us on 0191 377 8377 to discuss your training options in the and North, or use our online service to contact us.Why use Excel and Sage for your accounts?
Sage is a dedicated accounts database program, so if you are looking for software specifically dedicated to accounts, and you have a medium - to - large size organisation, Sage may be the way forward for you.
However, if you have a small organisation to manage, Excel may be the way forward for you as it enables you to keep track of your accounts easily, with minimal setup time and costs.
Sage and Excel can also work together when it comes to accounts. Excel can be very useful when analysing your accounts as it can be modelled to manage an aspect of your accounts.
For example, you might export some accounts data from Sage and then use Excel to analyse the data and present it in a visually rich way, such as by the use of graphs.
You can contact us on 0191 377 8377 to discuss your training requirements, we will be happy to help you decide which tool would work best for you in your situation.
Contact us online or call 0191 377 8377(Mon-Fri, 9am-5pm)
This site requires JavaScript - JavaScript is currently disabled on your device, please be aware that certain functionality may not work until you enable JavaScript.