PowerPivot Training Courses in London

We are pleased to announce that we’re now delivering PowerPivot training onsite across London. The course syllabus comprises the following:

  • Introduction to PowerPivot
    • Overview of the PowerPivot window
    • Working with the PowerPivot tab and field list
  • Entering PowerPivot Data
    • Overview of supported data types
    • How to import data into PowerPivot
    • Adding data with Excel Linked Tables
  • Analysing Data
    • Filtering and sorting
    • Creating relational tables
  • Performing Calculations in PowerPivot
    • The Data Analysis Expressions (DAX) language
    • Using formulas in calculated columns
    • Formula Aggregations
  • Creating PowerPivot Tables & Charts
    • Setting up PivotTable & PivotCharts
    • Creating Reporting Services Reports
    • Working with Measures
    • Using Slicers to filter data
    • Working with relationships in PivotTables

This course can be delivered at your offices anywhere in London and surrounding Boroughs. Delegates will require a sound knowledge of Excel get the best from this PowerPivot training and will have preferably attended an Advanced course. Our usual daily training rates apply, please see the Onsite Training page for full details.

Microsoft SharePoint Training Courses in London

SharePoint Training Courses at your Offices in London from £55 Per Person

Microsoft SharePoint offers organisations a number of key benefits:

Increased visibility and access to information

All information within the system is readily accessible by navigation or search.  The ability to move from local or network drives to a structured and searchable online repository is one of the major benefits of SharePoint.

Reduced email traffic

Groups of people working in a common environment no longer need to send emails to each other in order to distribute documents or share knowledge.  SharePoint provides tools to manage workflow, including document approval, and features such as wikis and discussions to facilitate the sharing of knowledge.

Document Change control

Using ‘Check in’ and ‘Check out’ allows groups to work on the same document without creating multiple copies which would then require merging, and without losing track of the latest version.  This is efficient and time saving.  Version histories are a useful way of keeping track of a documents development and, where required, reverting to an earlier version.

SharePoint 1 Day Training Course

Paul Brown Training offer a 1 day skills-based course, designed to get your staff working and collaborating more effectively in the shortest possible time. Here is a brief overview of the course schedule:

  • Module 1: Working with SharePoint
    • Benefits of collaborative working
    • Site Structure
    • SharePoint building blocks
    • Navigation and Search
  • Module 2: Working with libraries and lists
    • Overview of standard lists
    • Creating and Managing lists
    • Managing items within lists and libraries
    • Working with calendars
    • Issue tracking with SharePoint
  • Module 3: Working with Documents
    • What is a document library?
    • Document versions
  • Module 4: Custom Navigation
    • Quick changes to navigation in SharePoint 2013
  • Module 5: Working with Surveys
    • Working with surveys
  • Glossary

Microsoft SharePoint training courses in London

For further information, please use the quick enquiry form at the top of the page. If you would like to discuss your SharePoint training needs, you can speak to one of our advisers on 0800 2922842. Calls are free from a UK landline.

Excel 2016 Training Courses in London

Microsoft Office 2016 training courses delivered at your  own offices in London

Office 2016 is here and with it comes another batch of new features and functions. Among the latest additions we now have six new chart types, a range of new functions and an improved autocomplete.

Many people love their charts, with the capability to view data trends more easily than numbers alone. The new charts in Excel 2016 are referred to as: Treemap, Sunburst, Histogram, Box & Whisper and Waterfall. Some users may find the learning curve on these new graphs a little steep, but they are covered in our new Excel 2016 Advanced Plus course.

The new Excel functions include:

  • TEXTJOIN: combines text from multiple ranges with user-defined delimiters
  • CONCAT: similar to CONCATENATE but more flexible and easier to work with
  • IFS: a great new way to simplify nested IF functions
  • SWITCH: finds an expression in a list of values in order, or returns an ‘else’ value
  • MAXIFS: returns the largest number in a range based upon defined criteria
  • MINIFS: as MAXIFS but returning the lowest value

There is also a range of PivotTable and Slicer enhancements, making Excel 2016 the most comprehensive version to date. Learning all of these new features will take time, however you can short-circuit the process with a 1 day Excel 2016 training course.

Our new Excel Advanced Plus course includes all of the new features and can be delivered onsite at your own offices anywhere in London. For more information, please call on 0800 2922842 or use the quick for at the top of this page.

Microsoft Excel training courses in London from just £55 per person

Microsoft Office 365 Training Courses London

office365Microsoft Office 365 training onsite at your own offices in London from just £55 per delegate

What is Office 365?

Office 365 is Microsoft’s Cloud subscription service and includes the full Office suite of Apps: Access, Excel, Outlook, PowerPoint and Word. All of the software is provided as both online and local Apps and can be readily accessed via PCs and mobile devices. Microsoft offers a range of flexible subscription options suitable for individuals and businesses alike. The subscription includes access to all of the latest updates and new versions of the software as soon as they are released. Watch the short video below for a quick overview of Office 365 and essential features:

Microsoft Office 365 Training Courses

We offer onsite Office 365 training at your own offices anywhere in London from only £55 per person. Our training prices are based on a simple 3-tier group system which you can view on our Onsite Training page. We provide all the equipment needed so that you can use virtually any office for your training. Our 1 day onsite Microsoft Office 365 training also includes a personal training manual and course completion certificate as evidence of ongoing staff development.

Who is the Course For?

This is a Foundation course and no prior training or experience with Microsoft Office 365 is required. Delegates do however need to be familiar with the individual MS Office applications and able to use them as their roles require. The course is primarily designed to teach the features of Office 365 itself and whilst it refers to the Office Apps as they relate to this, it does not go into detail. If your are looking for training on specific Microsoft Office software, you can find more information on our Course Content page.

Microsoft Office 365 Foundation Course Overview

  • Office 365 Essentials
    • What is Office 365?
    • Exploring the ‘Get Started’ screen
    • Downloading & installing the App on mobile devices
  • Outlook Web Application
    • Accessing the Outlook Web App
    • Setting up email services
    • Setting you OWA Theme
    • Sending email
    • Managing folders
    • Using categories
    • Working with Tasks
    • Using the Calendar
  • The Office Web Apps
    • Working with Office online
    • Web App features
    • Excel Web App
    • Sharing spreadsheets
    • Word Web App
    • PowerPoint Web App
    • Access Web App
    • Opening local files in a Web App
    • Using Office 365 on mobile devices
    • Working with the iPhone Web Apps (optional)
  • Using Microsoft OneDrive
    • Creating a local copy of OneDrive
    • Uploading & sharing documents
    • Saving Office documents to OneDrive
    • Managing OneDrive files
    • Connecting with PCs and mobile devices
  • Collaborating with OneDrive
    • Using SharePoint
    • Setting up a new site
    • Sharing your site
    • Adding pages & web parts
    • Adding a project timeline
    • Adding a Theme
    • Changing site settings
    • Adding a site email address
    • Adding pages
    • Using Lync
    • Sending instant messages
    • Audio & Video conferencing
    • Presenting via online meetings

For more information regarding Microsoft Office 365 training courses in London, please use our ‘Quick Form’ or visit the Contact page.

 

Excel VBA Training Courses in London

Excel VBA training at your offices in London from £65 per person

When you reach the point in Excel where you find yourself thinking that there must be an easier way of carrying out routine tasks, you might want to take a look at VBA. Visual Basic (or VBA) allows the user to set up scripts or ‘Macros’ which automate repetitive and time consuming processes.

For some tasks it may be possible to use the ‘Macro Recorder‘ for this purpose. This takes the form of a simple recording device which is very easy to use and requires little training. We cover the application of this tool when required on both our Intermediate & Advanced Excel training courses. However, its use is somewhat limited and there quickly comes a point when you cannot achieve the effect you need.

Excel VBA needn’t be difficult to learn and we approach the process in the same practical manner in which we teach all of our Microsoft courses. When broken down into small ‘chunks’, anyone who is proficient with Excel can learn to apply VBA scripts to their spreadsheets. We provide 1 day Excel VBA training courses which can be delivered at your own offices anywhere in London from as little as £60 per person. No prior knowledge of VBA is required, however you should be proficient with Excel to get the most from the course. If you are self-taught, you may find it advantageous to attend one of our Excel courses first to ensure that you have a solid foundation on which to build your VBA knowledge. Again, this can be conveniently delivered at your own offices in London. You can read more about this service on our Onsite Training page.

Daily rates for Excel VBA training are as follows:

  • 1 – 3 delegates: £500
  • 4 – 6 delegates: £550
  • 7 – 10 delegates: £600
  • 10+ delegates: £600 + £50 per extra person
To discuss the arrangement of VBA training at your London offices, please call free on 0800 2922842. Alternatively you can request more information using the form on our Contact page.

IT Training Courses London

IT Training courses at your own offices in London from £55 per person

As a National specialist IT training organisation we are fully qualified to deliver a wide range of computer-based courses. Traditionally this type of training has been conducted at training centres across the UK and can cost anything from £250 per person upwards. However, we have significantly reduced the cost by offering group rates for onsite training at your own offices, which can bring the cost down to as little as £55 per person. You can read more, including a full breakdown of our rates, on the Onsite Training Courses page.

Onsite IT training at your own offices in London has several clear advantages:

  • Lower training cost per employee
  • No wasted travelling time or costs
  • Greater convenience
  • Training syllabus can be tailored to suit your Company’s needs
We provide all the training equipment needed and can even supply laptops for each delegate if necessary. Consequently, you can use virtually any office for your IT training. We have provided computer-based training for wide range of organisations across the UK; you can read what they say about us on the Testimonials page.

For more information regarding onsite IT training courses in London, please call free on 0800 2922842 or email us at the address below.

Microsoft Excel Training Courses Croydon

You can now get Microsoft Excel training at your own offices in Croydon from as little as £55 per person.

Onsite training at your own offices works out far cheaper than a public open course when you have several staff who can benefit. We can deliver Foundation, Intermediate & Advanced Excel training for the following group rates:

  • 1 – 3 delegates: £450
  • 4 – 6 delegates: £500
  • 7 – 10 delegates: £550
  • 10+ delegates: £550 + £50 per extra delegate
Please note that these rates are per group, not per person and include personal Microsoft training manuals and course certificates. All prices are + VAT. We will provide all the equipment needed including a projector and screen. We can also supply laptops if required for a small rental of £15 each so that you can use virtually any office for your Excel training course.

For more information about onsite Microsoft Excel training courses in Croydon, please email info@exceltrainingcourseslondon.org or call free on 0800 2922842

Microsoft Excel Training Courses in London

Excel training courses delivered at your own offices anywhere in London and across the UK from just £55 per person

Microsoft Excel has become the default spreadsheet application and a sound working knowledge is now an essential office skill. Our range of Microsoft Excel courses will enable you and your staff to become more effective and efficient, in the shortest possible time.

Training Course Levels

We offer Excel training at three levels: Foundation, Intermediate and Advanced. Each course is delivered over one day as a practical workshop and teaches a range of essential spreadsheet skills.

Foundation Excel Syllabus

Aimed at those with little or no experience with Excel, this course teaches the basic skills of creating spreadsheets and inputting data. Delegates will learn how to format data and also how to build simple formulas and functions.

Intermediate Excel Syllabus

For those who use Excel regularly, the Intermediate course increases effectiveness by introducing a range of functions to streamline office tasks. Learn how to find data with VLookups and perform data analysis with PivotTables.

Advanced Excel Syllabus

Our Advanced Excel course introduces further logical, database and analytical functions to facilitate the most demanding tasks. Large amounts of complex data can be analysed and manipulated faster, leading to increased productivity.

Microsoft Office Versions

We can deliver training at all levels on Excel from 2003 up to the latest version. If required, we can supply laptops with your version of Office preloaded for the training.

Onsite Training Prices

We are specialists in onsite Microsoft Office training and have many years of experience working with some of the leading Companies in the UK. You can see what clients say about our services on the Testimonials page.

Our onsite training rates start from just £55 per delegate and include personal Excel manuals and course completion certificate. Please visit our Onsite Training Courses page for full details, including prices.

Microsoft Excel Training at Your Own Offices Across London

We can deliver Excel training onsite at your offices in any of the inner and outer London Boroughs including:

  • Camden
  • Greenwich
  • Hackney
  • Hammersmith
  • Islington
  • Kensington and Chelsea
  • Lambeth
  • Lewisham
  • Southwark
  • Tower Hamlets
  • Wandsworth
  • Westminster
  • Barking
  • Barnet
  • Bexley
  • Brent
  • Bromley
  • Croydon
  • Ealing
  • Enfield
  • Haringey
  • Harrow
  • Havering
  • Hillingdon
  • Hounslow
  • Kingston upon Thames
  • Merton
  • Newham
  • Redbridge
  • Richmond upon Thames
  • Sutton
  • Waltham Forest