Accounting and Bookkeeping Courses

Compare courses
    • 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
    • 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.
      View Full Outline
      Public Scheduled Dates:
      Prices per delegate. All prices exclude VAT
      <
      >
      Private Courses:
      Starting from £645 for up to 8 delegates
    • Overview: This course is split into 3 main areas:

      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.
      View Full Outline
      Public Scheduled Dates:
      Prices per delegate. All prices exclude VAT
      <
      >
      Private Courses:
      Starting 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.
      View Full Outline
      Private Courses:
      Starting from £745 for up to 8 delegates
    • 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.
      View Full Outline
      Public Scheduled Dates:
      Prices per delegate. All prices exclude VAT
      <
      >
      Private Courses:
      Starting 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.
      View Full Outline
      Public Scheduled Dates:
      Prices per delegate. All prices exclude VAT
      <
      >
      Private Courses:
      Starting 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.
      View Full Outline
      Public Scheduled Dates:
      Prices per delegate. All prices exclude VAT
      <
      >
      Private Courses:
      Starting from £645 for up to 8 delegates
    • Overview: This hands on one day course is designed to introduce managers and business owners who do not have a background in finance to the financial reports, concepts and terminology which they are likely to come across in business management.

      It gives an introduction to the background and principles of UK accounting, and examines the most commonly used management reports which will give an understanding of the business from a finance perspective.

      Dummy company data and reports will be used on open group courses, however for a more tailored analysis bespoke training can use your own company reports within the exercises.
      View Full Outline
      Public Scheduled Dates:
      Prices per delegate. All prices exclude VAT
      <
      >
      Please contact us for a quote
    • Overview: We offer Sage training on a private course basis. Private Sage training is tailored to meet your own needs and can be delivered using a backup of your own Sage system, this ensures that the training is relevant to your own organisation.

      Training can be delivered using our tutor-led virtual classroom option or we can come to your site. Please contact us for a quote.

      The Sage workshops follow on from the Level 1 and 2 courses, looking in detail at some specific Sage program areas.
      View Full Outline
      Private Courses:
      Please contact us for a quote
    • Overview: We offer Sage training on a private course basis. Private Sage training is tailored to meet your own needs and can be delivered using a backup of your own Sage system, this ensures that the training is relevant to your own organisation.

      Training can be delivered using our tutor-led virtual classroom option or we can come to your site. Please contact us for a quote.

      This course introduces the Sage Accounting program, and is ideal for those with a small amount of book keeping / financial knowledge, but who are new to Sage. It covers the basics of how Sage works, along with all of the day to day transactions which you are likely to come across when using Sage Accounts programs day to day.
      View Full Outline
      Private Courses:
      Please contact us for a quote
    • Overview: We offer Sage training on a private course basis. Private Sage training is tailored to meet your own needs and can be delivered using a backup of your own Sage system, this ensures that the training is relevant to your own organisation.

      Training can be delivered using our tutor-led virtual classroom option or we can come to your site. Please contact us for a quote.

      This course follows on from the Introduction to Sage Accounts course, to look at some of the more intricate or less common tasks you might need to undertake.
      View Full Outline
      Private Courses:
      Please contact us for a quote
    • Overview: We offer Sage training on a private course basis. Private Sage training is tailored to meet your own needs and can be delivered using a backup of your own Sage system, this ensures that the training is relevant to your own organisation.

      Training can be delivered using our tutor-led virtual classroom option or we can come to your site. Please contact us for a quote.

      This course is aimed at those who need to process Payroll on a Sage 50 system. It will give you all of the information necessary to set up Sage 50 Payroll to suit your business, and to process day to day transactions including:

      making payments, deducting PAYE and NI, processing attachments, student loans and statutory payments. It will also cover calculating how much you need to pay to HMRC each month, and submitting information to HMRC as and when required. This 2 Day course also covers calculating and recording holidays and pensions in detail, as well as further options including timesheet entry, nominal link to Sage Accounts, loans, statement of employment & personnel information.
      View Full Outline
      Private Courses:
      Please contact us for a quote
Ask us a question:
I would like IT Training solutions Ltd to keep me informed with offers and news it believes would interest me*
By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Ask A Question
    I would like IT Training solutions Ltd to keep me informed with offers and news it believes would interest me*
    By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
"A good course "

D.O. Merton Council, SharePoint Overview

Following this training what are you going to do differently "Going to be automating POs into a folder for the planner who can then update once they've been planned. "

J.W. IPL Global, Microsoft Forms Essentials in Office 365

Following this training what are you going to do differently "Use software more efficiently "

P.M. Teesside Gas and Liquids, Microsoft Project Essentials

"I found learning about data relationships and models particularly helpful. More generally, being able to build a report excel dashboard from scratch is going to change the way I work for the better. "

N.B. DCC, Excel Business Intelligence using Excel Power Tools

"Very enjoyable and informative "

P.S. Thermo Fisher Scientific, Train the Trainer Training Skills for the Workplace

Which part of the course did you find particularly valuable "All very valuable, particularly how to use Pivot Tables and LookUps effectively, as well as the introduction to Macros. "

D.S. South Tyneside Homes, Excel Level 3

Which part of the course did you find particularly valuable "The ability to have questions answered during the course. Cost allocation process very useful as most people don't know this is possible "

A.F. DeepOcean 1 UK Ltd, Microsoft Project Essentials

"Informative and easy to understand course "

S.D. Bang Olfsen, Excel Level 1 Essentials

Any other comments or recommendations "Very clear and informative "

R.S. William Smith Group, Excel Level 2

Which part of the course did you find particularly valuable "Picture insertion repositioning with text "

A.P. Teesworks SC, Word Essentials

"Loved the interactive group discussions/activities "

J.H. Alnwick Medical Group, Coaching and Mentoring

Which part of the course did you find particularly valuable "All of it "

D.C. anwen construction, Computers for Beginners and Getting Started with MS Office

"Really helpful training session "

C. V4 Services Ltd, Microsoft Teams in Office 365 Essentials

Which part of the course did you find particularly valuable "How it was very interactive, using the software rather than just watching the trainer is much more useful "

H.S. Durham County Council, Microsoft Power BI Desktop

Following this training what are you going to do differently "Learned how to do speedier shortcuts "

J.R. Sealy UK, Excel Level 2

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.