Most Popular Courses

Courses in the Most Popular category:

Compare courses
    • <<
      <
      >
      Public scheduled prices per delegate +VAT
      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.
    • Public scheduled prices per delegate +VAT
      Duration: 1 Day
      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 prices per delegate +VAT
      Duration: 1 Day
      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.
    • <<
      <
      >
      Public scheduled prices per delegate +VAT
      Duration: 1 Day
      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 prices per delegate +VAT
      Duration: 1 Day
      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 prices per delegate +VAT
      Duration: 1 Day
      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 prices per delegate +VAT
      Duration: 2 Days
      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.
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.
Your Course Portal
Access your course materials online via your own personal training account*.
Sign in to see your resources *Select courses may require printed materials
  • 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.
"Picked up a great deal from this session. Very useful going back to basics and getting to know Excel better. It's been a great confidence booster. I particularly enjoyed learning about conditional formatting, slicers, formula's and generic search functions. I feel I am able to work a lot quicker in my job role "

A.N. Bloom Procurement Services Ltd, Excel Essentials

"Just really useful and enjoyable "

N.W. Riverford Organic Farmers, Excel Level 2

Following this training what are you going to do differently "I am going to spend more time on preparation and practice "

B.J. Greencore Group, Train the Trainer Training Skills for the Workplace

"All aspects were enlightening and I am eager to put my new found knowledge to use "

T.P. , Excel Level 2

Which part of the course did you find particularly valuable "More understanding of setting up spreadsheets setting formulas "

K.L. Sealy UK, Excel Level 2

Any other comments or recommendations "Being able to do this course remotely was a huge advantage "

J.H. NHSBSA, Microsoft Power BI Desktop

"Very useful training for the role out of our project cost control and resource planning initiatives. "

S.H. DeepOcean, Microsoft Project Essentials

Which part of the course did you find particularly valuable "Extremely knowledgeable training and very clear, consistent teaching style of the trainer. Very beneficial and informative training session. "

Y.B. EGGER UK, Excel Analysing and Presenting Data with Dashboards and Pivot Tables

What were the most useful aspects of the course "Learning all aspects of communication and understanding much clearer how everyone has different thought processes "

F.R. Cenergist Ltd, Personal Effectiveness and Communication Skills with Clarity 4D Personality Profile

"Pivot Tables I'm going to have fun with this when I return to work! "

K.T. PX Group, Excel Level 3

"Very enjoyable course "

W.M. Gestamp UK Ltd, Excel Level 1 Essentials

Following this training what are you going to do differently "More confident in Excel "

H.A. Relate, Excel Level 1 Essentials

"Very well presented course and lots of very useful pointers on how to do things. "

G.O. Lighthouse Poole, Excel Level 2

Any other comments or recommendations "Thank you so much, really enjoyed my two days : "

H.S. Department for International Trade, Adobe In Design Level 1

"I did the course remotely from home and found it very useful. "

H.N. Watmos, Microsoft Teams in Office 365 Essentials

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.

 

Most Popular Subcategories:

Excel
10 Courses
View All
Power BI
2 Courses
View All

 

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.
Your Course Portal
Access your course materials online via your own personal training account*.
Sign in to see your resources *Select courses may require printed materials