Our Masterclass Series, designed to support individuals with already established IT skills and prepare them for an advanced level. If you are familiar with office-based software and looking to enhance your expertise, this series of short masterclasses is perfect for you. Each session is carefully curated to provide in-depth knowledge and practical insights, allowing you to elevate your existing skills to a higher level. Whether you choose to attend one or multiple courses, our flexible schedule accommodates your commitments so that you can work at your own pace and improve your skills.
Course 1 - Report Writing using Microsoft Word
This session will teach you how to create flawless and professional reports. During the course you will cover:
• Understanding what templates are and how to create and use them
• Creating and using styles within Reports or any Word document
• Creating contents page for any document
Course 2 - Pivot Tables using Microsoft Excel
This informal course will help you advance in your understanding with Pivot tables and use Conditional formatting to highlight data within Excel:
• Use Pivot tables to understand data and create charts
Course 3 - Advanced Formulas using Microsoft Excel Part 1
This informal course will enable you to use some of the prediction tools in and will enhance your knowledge in creating reports and your analysis, one step further. During the course you will cover:
• Understand and use formulas in Excel (If statement, IF AND)
Course 4 - Advanced Formulas using Microsoft Excel Part 2
This informal course will gain even more useful formulas to use within your spreadsheets.
• Sum and its derivations
• Count and its derivations
• Trim, Proper, Workday
Course 5 - Mastering Slides using Microsoft PowerPoint
In this short course you will cover how to use one of the most synonymous tools in digital presentations, Microsoft PowerPoint. During the course you will cover:
• Use the slide master and Design ideas
• Create buttons, Add Animations and Transitions
How will I attend this course?
How will I attend this course?
This course is delivered by a tutor online at a set date and time. Following the live taught session, you will need to commit to working through course material for the agreed hours and timescales set by your tutor.
What equipment will I need?
What equipment will I need?
You will need access to a laptop or PC, camera, microphone and internet connection. We may be able to support you if you do not have access to this equipment.
Completing this course will give you the opportunity to earn a Cambridgeshire Skills digital badge. Badges are endorsed by City and Guilds and are a great way to demonstrate your interest in the subject and provide evidence of learning.
What are the entry requirements?
What are the entry requirements?
There are no entry requirements for this course. Though a good grasp of IT will help this advanced course
Other recommended learning
Other recommended learning
Level 3 Certificate in IT User Skills
