On this course you'll learn how to be more productive using Microsoft Excel. We'll show you how to use tools to organise and visualise data. You'll increase your knowledge of using formulas and inserting functions - eg TODAY, SUM, SUMIF, VLOOKUP, IF etc. We end the course showing you the power of PivotTables to quickly summarise your data, and we'll show you how to use the Quick Analyse tool.
Customised Content
The course can be tailored to cover specific topics relevant to the learner's training requirements.
Flexible Duration
The course has a flexible duration lasting up to 6 hours. Bookings/payment can be made by the hour on a pay-as-you go basis - a minimum booking of 2 hours is required.
Training Times
Training sessions can be booked at convenient times to fit in with the learner's schedule.
Requirements
Learners should have existing skills using Microsoft Excel, eg be familiar with the majority of topics covered on our Microsoft Excel Basic User course. Learners will need a Windows PC, with a reliable broadband connection, installed with Microsoft 365 (we can provide a 3-month temporary licence as an optional extra). The course can be delivered using Zoom or Microsoft Teams.
Notes
Learners will receive an electronic training manual.
Certification
Learners who complete all topics from the course will receive an e-Certificate of Completion. Learners have the option of completing a competence assessment, learners who pass the assessment will receive an e-Certificate of Competence (this may be used as evidence of CPD depending on the requirements of the learner’s profession).
Customised Content
The workshop can be tailored to cover specific topics to meet staff training requirements.
Flexible Duration
The workshop duration is flexible - our recommended duration is 2 to 3 hours. Workshops can take place over a period of time, eg 2 hours a week for 3 weeks.
Group Size
We like to keep group sizes small and effective - our recommended class size is between 2 and 4 learners.
Requirements
Learners will need a Windows PC, with a reliable broadband connection, installed with Microsoft 365. Workshops are delivered using Microsoft Teams. Learners will need to be able to view the instructor's shared screen and be able to use their own PC at the same time.
Notes
Learners will receive an electronic training manual.
Certification
Learners who complete the workshop will receive an e-Certificate.