Name: Microsoft Excel - Formatting Spreadsheets
Price: 99 GBP
Availability: InStock

Learn the fundamentals of creating and working with formulas and functions. In this class, you will learn:<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Building and copying simple formulas</li><li fr-original-style="" style="box-sizing: border-box;">Understand formulas operators and the order of operations</li><li fr-original-style="" style="box-sizing: border-box;">Learn to use functions such as SUM, AVERAGE, PMT, ROUND, TODAY, and NETWORKDAYS</li><li fr-original-style="" style="box-sizing: border-box;">Understand the difference between relative and absolute cell references</li><li fr-original-style="" style="box-sizing: border-box;">Create grand totals and work with formulas that contain 3-D references</li></ul>Class details:<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

AXIOM Learning Solutions

Microsoft Excel

Microsoft Excel - Functions and Formulas

General Admission

Within the basic four&nbsp;colour&nbsp;energies are contained two sets of opposites.Underlying each pair of opposites there is a TENSION.This tension acts like a force, just like gravity. &nbsp; You cannot see&nbsp;it,&nbsp;you cannot hear it or touch it with your hands. &nbsp; You will, however, experience the impact of the tension.We each make a choice in how we perceive this tension. &nbsp;We can choose to be proactive and use this tension to create win/win outcomes. &nbsp;We can choose to be reactive and disconnect from the energy viewing it as a negative.The choice we make determines our results.It is important to remember, we make our own choice. &nbsp; The person who represents your opposite energy is not responsible for your choice.When you&rsquo;re proactive in engaging with this tension you achieve successful dynamics. &nbsp;Become reactive with this tension and you will experience dysfunctional dynamics.<img src="https://images.cademy.co.uk/24bd9347-eb1e-4a9c-87b0-bc006b591fe3/af498831-25fb-4d00-8dd0-b9467a6a4096/original.jpeg" style="width: 300px; display: inline-block; vertical-align: bottom; margin: 5px 0px 5px 5px; text-align: right; cursor: auto; max-width: calc(100% - 5px); float: right; padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 300px; display: inline-block; vertical-align: bottom; margin: 5px 0px 5px 5px; text-align: right; cursor: auto; max-width: calc(100% - 5px); float: right;" fr-original-class="fr-draggable"> The Opposite Colour EnergiesBlue &amp; Yellow are Opposite&nbsp;ColoursThe tension between Blue energy &amp; Yellow energy is based around&nbsp;IDEAS&nbsp;and&nbsp;PROCESSES.Red &amp; Green are Opposite&nbsp;ColoursThe tension between Red energy &amp; Green energy is based around&nbsp;TASKS&nbsp;and&nbsp;PEOPLE.

Within the basic four colour energies are contained multiple sources of tension.
Each adjacent colour can work in harmony or result in conflict.  Mastering your ability to work with all the colour energies is a powerful way to transform your performance.
This tension acts like a force, just like gravity. You cannot see it, you cannot hear it or touch it with your hands. You will, however, experience the impact of the tension.
We each make a choice in how we perceive this tension. We can choose to be proactive and use this tension to create win/win outcomes. We can choose to be reactive and disconnect from the energy viewing it as a negative.
The choice we make determines our results.
It is important to remember, we make our own choice. The person who represents your adjacent or opposite energy is not responsible for your choice.
When you’re proactive in engaging with this tension you achieve successful dynamics. Become reactive with this tension and you will experience dysfunctional dynamics.

/
The Opposite Colour Energies
Blue & Yellow are Opposite Colours
The tension between Blue energy & Yellow energy is based around IDEAS and PROCESSES.
Red & Green are Opposite Colours
The tension between Red energy & Green energy is based around TASKS and PEOPLE.

colour-energies.com

Team Building

Insights

Insights Discovery

Gain insights into how to master the dynamics of the opposite colour energies and see the dynamics within your team shift towards healthy relationships.  Watch as your bottom line improves as suddenly more is getting done in a smarter way.

Mastering the Dynamics of the Colour Energies

Early Bird Discount

Learn additional functions and formulas to become a more expert Excel user.This class will give you hands-on instruction as you work with the IF, nested IF and IF/AND logical functions, the TRIM, PROPER, CONCATENATE, TEXT, LEFT, RIGHT, and MID text functions, VLOOKUP with an approximate and exact match, separating text into columns, and the SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF and COUNTIFS conditional functions to process worksheet data more efficiently.&nbsp;This class is:<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Excel - More Functions and Formulas

Microsoft Teams is a Microsoft 365 application that provides built-in online meetings with audio and video calling, integrated file sharing and file storage with Microsoft OneDrive, a team live chat tool, and more, to help people within and outside your organization communicate and collaborate effectively.This class provides an introduction to Teams, and how to collaborate with your team using features like chat, file sharing, calls, and calendars. You will learn how to create Teams, Groups and Channels, and learn how to add extra functionality using apps and bots.This class is:<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">120 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Teams

Microsoft Sharepoint

Microsoft 365

Collaboration

Microsoft Onedrive

Microsoft Teams - Fundamentals

In this 90-minute class, participants will learn how to effectively utilize this powerful tool for task and project management. The class begins with an overview of Microsoft Planner&#39;s interface and basic functionalities, including creating new plans, adding tasks, and assigning them to team members. Attendees will explore setting due dates, adding task details, and attaching files to ensure thorough task management. The class will also cover organizing tasks into buckets for better categorisation, using labels for visual tagging, and monitoring progress through the Planner&#39;s built-in charts and views. By the end of the session, participants will be equipped with the knowledge to streamline their workflow and enhance team collaboration using Microsoft Planner. Please note, this class does not cover Planner Premium topics.<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Office Skills & Productivity

Time Management

Project Management

Microsoft Office

Microsoft Planner

Microsoft Planner Basic: The Essentials

Microsoft OneDrive for Business provides your users with a single cloud based location to store and sync your files. In this class, you will learn how to upload and sync, how to access and share files, and how to use the OneDrive for Business mobile app.This class is:<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Office Productivity

Digital Skills

Microsoft OneDrive for Business - Essentials

Learn about the Outlook calendar, including how to create and manage appointments, recurring appointments, events, and meetings. Also learn about the different calendar options that affect how the calendar looks and functions. You will also learn about working with reminders, printing the calendar and creating another calendar.This class is:<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Office Skills

Meetings

Microsoft Outlook

Microsoft Outlook - Working with the Calendar

Microsoft Excel is a powerful tool to manage and understand data. This class will give you hands-on experience with a variety of tips and shortcuts that will make you more efficient when working with Excel.In this class, you will learn keyboard &amp; mouse shortcuts, Go To Special, Flash Fill, Auto Fill, Freezing rows and columns, splitting the worksheet into multiple panes, creating a new window with the current workbook content, working with cell comments, viewing status bar calculations, finding cells that contain constant values or formulas, viewing worksheet formulas, inserting Sparklines, and using Quick Analysis.&nbsp;This class is:<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Excel Analytics

Data Skills

Spreadsheet

Microsoft Excel - Tips and Shortcuts

In this class, you will gain hands-on experience with creating and using templates to automate the creation of documents in Microsoft Word. In addition, you will learn how to manage specific document content and styles, including how to create and use styles in Word documents and templates to automate text and paragraph formatting, and to use content controls such as a text control, a date picker and a drop down list control.This class is:<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Certification

Computer Skills

Microsoft Word

Microsoft Word - Templates and Styles

Learn the basic formatting techniques necessary to enhance the way data displays on a worksheet and in print. You will learn how to:<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Adjust column width and row height</li><li fr-original-style="" style="box-sizing: border-box;">Format text, change alignment of data, format numbers</li><li fr-original-style="" style="box-sizing: border-box;">Copy formatting to other cells</li><li fr-original-style="" style="box-sizing: border-box;">Create conditional formatting rules</li><li fr-original-style="" style="box-sizing: border-box;">Create and apply styles</li><li fr-original-style="" style="box-sizing: border-box;">Use Page Layout and Page Break Preview</li><li fr-original-style="" style="box-sizing: border-box;">Set up column and row headings to print on each page</li><li fr-original-style="" style="box-sizing: border-box;">Insert page breaks</li><li fr-original-style="" style="box-sizing: border-box;">Scale your data to fit on pages</li><li fr-original-style="" style="box-sizing: border-box;">Show/hide gridlines</li><li fr-original-style="" style="box-sizing: border-box;">Insert a header and footer&nbsp;</li></ul>This class is:<ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Excel - Formatting Spreadsheets

Chelmsford

Stratford

Our CITB Online - Site Supervisors’ Safety Training Scheme (SSSTS) Refresher course is designed to give attendees a broad reminder of their responsibilities for health and safety on construction sites. Approved and endorsed by the United Kingdom Contractors Group, the SSSTS refresher course is a must for anyone who occupies a supervisory role on UKCG sites and wants to brush up on their knowledge of their legal responsibilities and the latest construction industry regulations.
The SSSTS Refresher course has been created to provide existing supervisors, or those who are just entering into a supervisory role, with in-depth knowledge of health and safety legislation and procedures. If a candidate completed a full SSSTS training course up to 5 years ago, they will be required to attend a refresher programme.
Prerequisites
SSSTS certificates are of course valid for up to 5 years, but due to the ever-changing nature of the industry, it is recommended that staff stay up to date by enrolling on a refresher course long before the qualification expires.
Instructions
Please note all Site Supervisor Training courses with the venue “Remote Learning” will be delivered by a tutor over a video call.
This training will be delivered and assessed in English language; therefore, a good standard is required to complete the course.
Further attendee information will be sent in a separate email, please check your inbox.

SMC Safety Solutions

Site Supervisor Training Scheme (SSSTS) Refresher

This one-day course is a must for anyone considering or already working within a construction or civil engineering environment. This course provides Health and Safety awareness and is endorsed by Build UK as a standard training for all operatives on site.
Aims
To give a clear understanding of Regulations & Legislation that applies to construction work and is an ideal refresher for any operative that has previously completed training in Health & Safety.
Course Content
• Accident prevention
• Health & Safety law
• Control and management of the site and your how your role fits in with this
• Risk assessments and method statements
• Performing safely on site
• Reporting unsafe acts to prevent an accident
• Individual & employee responsibilities
• What to do if you think anyone’s Health and Safety is being put at risk
Assessment
At the end of this course, all delegates will have a clear understanding of the requirements of Health and Safety Legislation and their responsibilities to comply with them.
Candidates will need to complete a multiple-choice exam at the end of the CITB course. They will also need to engage and interact with others throughout the day.
Certificate
This certification for this course is valid for 5 years and is endorsed by Build UK as a standard training for all operatives. The certificate is part of CSCS Green Card requirements.
To remain certified in this area, you will need to retake the course before the expiry date or have completed an NVQ2 or higher in your skills set.
Instructions
Please note all Health & Safety Awareness courses with the venue “Remote Learning” will be delivered by a tutor over a video call.
This training will be delivered and assessed in English language; therefore, a good standard is required to complete the course.
Further attendee information will be sent in a separate email, please check your inbox.

Health & Safety Awareness (for Green CSCS)

Are you camera shy or overly self-critical when making videos for your business?Don&#39;t let it hold you back!🎥 Join us on our FREE webinar. Our webinar is designed to boost your confidence and enhance your presentation skills. Learn practical tips to overcome camera shyness and deliver engaging videos that captivate your audience.Don&#39;t miss out&mdash;register now and step into the spotlight with confidence!

Are you camera shy or overly self-critical when making videos for your business?

Don't let it hold you back!

✔ Join us on our FREE webinar.

Our webinar is designed to boost your confidence and enhance your presentation skills. Learn practical tips to overcome camera shyness and deliver engaging videos that captivate your audience.

Don't miss out—register now and step into the spotlight with confidence!

Clockwork Eye Video

Photography & Video

Video

Video Marketing

Video Creation

Mobile Video Production

Film & Video

Videography

Presentation Skills

Video Production

Video Editing

Video & Mobile Marketing

Overcome camera shyness and boost your presentation skills! 🎥 Join our FREE webinar designed to build your confidence and teach practical tips for creating engaging videos. Don’t miss out—register now and step into the spotlight with confidence!

Camera Confidence & Presentation Skills (FREE Webinar)

Bristol

<p id="isPasted" style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">LOOKING FOR: YA, ADULT FICTION, NON-FICTION<p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">Laura Williams is literary agent at the&nbsp;<a href="http://greeneheaton.co.uk/agents/laura-williams/" style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto; font-size: var(--font-size);" fr-original-style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto;">Greene and Heaton Literary Agency</a>.&nbsp;She is seeking literary fiction, commercial fiction, psychological thrillers and high concept Young Adult.<p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" id="isPasted" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">Laura is actively building a fiction list and a small non-fiction list. She is currently looking for literary fiction, edgy commercial fiction, psychological thrillers and high-concept contemporary young adult, as well as narrative non-fiction of all types. Her taste is quite dark, and she loves gothic, ghost stories, horror and anything sinister. She also loves books that make her cry, from big love stories to intense family dramas. She is open to historical or horror YA, but not magical or fantasy.&nbsp;<p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">Meditative or moving novels about modern life, appeal to Laura, sad stories with love and the importance of caring for each other shining through. She also loves stories about female friendships or conversely groups of women who don&#39;t get on, such as the hugely fun BAD SUMMER PEOPLE by Emma Rosenblum. She is always on the lookout for a big tragic love story to make her cry happy or sad tears.  At the more commercial end of fiction, think funny novels with warmth and romantic comedies with a bit of depth &ndash; think Marian Keyes.<p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">Most of all Laura is looking for novels she hasn&rsquo;t read before &ndash; something unusual structurally or thematically, something that shines a light on a subject the author is passionate about, something that&rsquo;ll break her heart or raise her blood in an entirely new way. Laura is always looking to promote diverse voices from across the globe, and is particularly keen on LGBTQI+ stories.<p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">Laura would like you to submit a covering letter, a 1-2 page synopsis and the first 5,000 words of your completed manuscript in a single word document.<p id="isPasted" style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">(In addition to the paid sessions, Laura is kindly offering one free session for low income/under-represented writers. Please email <a href="mailto:agent121@iaminprint.co.uk" style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto; font-size: var(--font-size);" fr-original-style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto;">agent121@iaminprint.co.uk</a> to apply, outlining your case for this option which is offered at the&nbsp;discretion of&nbsp;I Am In Print).&nbsp;By booking you understand you need to conduct an internet connection test with&nbsp;I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting.<p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">The submission deadline is: Monday 16 September&nbsp;2024

LOOKING FOR: YA, ADULT FICTION, NON-FICTION

Laura Williams is literary agent at the Greene and Heaton Literary Agency. She is seeking literary fiction, commercial fiction, psychological thrillers and high concept Young Adult.

Laura is actively building a fiction list and a small non-fiction list. She is currently looking for literary fiction, edgy commercial fiction, psychological thrillers and high-concept contemporary young adult, as well as narrative non-fiction of all types. Her taste is quite dark, and she loves gothic, ghost stories, horror and anything sinister. She also loves books that make her cry, from big love stories to intense family dramas. She is open to historical or horror YA, but not magical or fantasy. 

Meditative or moving novels about modern life, appeal to Laura, sad stories with love and the importance of caring for each other shining through. She also loves stories about female friendships or conversely groups of women who don't get on, such as the hugely fun BAD SUMMER PEOPLE by Emma Rosenblum. She is always on the lookout for a big tragic love story to make her cry happy or sad tears. At the more commercial end of fiction, think funny novels with warmth and romantic comedies with a bit of depth – think Marian Keyes.

Most of all Laura is looking for novels she hasn’t read before – something unusual structurally or thematically, something that shines a light on a subject the author is passionate about, something that’ll break her heart or raise her blood in an entirely new way. Laura is always looking to promote diverse voices from across the globe, and is particularly keen on LGBTQI+ stories.

Laura would like you to submit a covering letter, a 1-2 page synopsis and the first 5,000 words of your completed manuscript in a single word document.

(In addition to the paid sessions, Laura is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print). 

By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting.

The submission deadline is: Wednesday 13th August 2025

I Am In Print

Fiction Writing

SOLD OUT! 22nd August Laura Williams #Agent121. Looking for: YA, ADULT FICTION, NON-FICTION

<div dir="ltr" style="color: rgb(31, 31, 31); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(31, 31, 31);">
<div dir="ltr" style="color: rgb(31, 31, 31); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(31, 31, 31);">
<div dir="ltr" style="color: rgb(31, 31, 31); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(31, 31, 31);">

<p style="margin: 0cm; font-size: 15px; font-family: Calibri, sans-serif; color: var(--text); box-sizing: border-box;" id="isPasted" fr-original-style='margin:0cm;font-size:15px;font-family:"Calibri",sans-serif;'>Empower Your Business with YouTube: Practical Workshop&nbsp;Harness YouTube to expand your reach, build brand awareness, and boost sales. Our interactive YouTube for Business workshop provides essential skills to set up and optimise your channel for success.&nbsp;What You&#39;ll Learn:&nbsp;Create a Professional Channel: Build a captivating YouTube channel that represents your brand.Optimise for Search: Learn key techniques to ensure your videos are easily found.Effective Marketing: Discover strategies to promote your videos, generate leads, and increase conversions.Analyse Performance: Use analytics to refine your strategies and improve content.&nbsp;Enrol Today and Transform Your Business&nbsp;Seize this chance to harness YouTube&#39;s potential. Enrol now in our YouTube for Business workshop and start creating videos that engage and elevate your business. 

<p style='margin: 0cm 0cm 0.0001pt; font-size: 15px; font-family: Calibri, "sans-serif"; color: var(--text); box-sizing: border-box;' id="isPasted" fr-original-style='margin:0cm;margin-bottom:.0001pt;font-size:15px;font-family:"Calibri","sans-serif";'>Explainer Video:

<iframe width="560" height="315" src="https://www.youtube.com/embed/lND5ACrCVos?si=1wlFLPU_5PfiL4Ri" title="YouTube video player" frameborder="0" allowfullscreen="" fr-original-style="" style="box-sizing: border-box;">&nbsp;&nbsp;&nbsp;</iframe>


</div></div></div>

Empower Your Business with YouTube: Interactive Workshop
Harness YouTube to expand your reach, build brand awareness, and boost sales. Our interactive YouTube for Business workshop provides essential skills to set up and optimise your channel for success.
What You'll Learn:
Create a Professional Channel: Build a captivating YouTube channel that represents your brand.
Optimise for Search: Learn key techniques to ensure your videos are easily found.
Effective Marketing: Discover strategies to promote your videos, generate leads, and increase conversions.
Analyse Performance: Use analytics to refine your strategies and improve content.
Enrol Today and Transform Your Business
Seize this chance to harness YouTube's potential. Enrol now in our YouTube for Business workshop and start creating videos that engage and elevate your business.
Explainer Video:



Video Design

Learn how to create and manage a successful YouTube channel for your business. This workshop will cover everything you need to know when setting up and using YouTube in your business. You will also learn how to use YouTube analytics to track your channel's performance to help you make improvements.

YouTube For Business (Interactive Workshop)

This event is for users of HoardingUK, we would like to listen to your feedback and suggestions.

HoardingUK

HUK User Involvement Meeting

Micro-Workshop: How to Use AI to Make Video Marketing Easier

Want to create more video content but feel stuck for time or ideas? In this short, practical workshop, you'll discover how to use AI tools to speed up your video marketing process—from generating content ideas and writing scripts to creating subtitles, video descriptions, and more. Whether you're just getting started or looking to streamline what you already do, this session will show you how AI can help you create better videos, faster.

Check out our other workshops and webinars designed to help you create video content HERE.

If you would like help in creating video content then take a look at our Video Creators Club where you will get support, training, tutorials and network with other creators.

If you are creating videos and either spending loads of time creating the subtitle files or even paying to have them created then look no further. This simple and easy exercise will enable you to create subtitles in seconds and is as easy as copy and paste.

Video Marketing Made Easier With AI (A Micro-Workshop)

Following on from last month's activation harnessing fire energy, ignited by the New Moon in Leo, I invite you to join me to welcome in the Virgo New Moon that approaches fast. Ushering in a new cycle and a new influx of energy.

With its timely intercession at the tail end of summer, Virgo always seems to me like a real opportunity to feel into what is next. To access a greater sense of clarity and creativity. And to start to ready ourselves to fully call in the new aspects that are calling each of us.

This is also a great way that we can contribute to the collective. For as we each focus on that which is calling, we open up more of the field for others to connect to their own heart centredness and a more expanded sense of self.

As the sun travels out of Leo into Virgo the energy of creation is heightened with the auspicious presence of the Royal Star Regulus. An ideal time to focus on calling in your highest timeline and attracting what your heart desires. Further anchoring heart energy within and without.

This will be an energy activation and will include a transmission and/or connection to the Dragons. We will come together online and get those energies moving. 

What’s an energy activation? An energy activation is a reawakening of part or parts of your Divine blueprint. It has the capacity to create lasting change, by removing blocks, habits, patterns or stagnancy that are ready to go! 

This particular activation will most likely use a blend of guided meditation, channelling and light language, to bypass the conscious mind, as I am guided during our time together.

If you require any further information or have specific questions not covered in the FAQ, simply reach out to me via email here: melody@thisdivinelife.com 

8PM BST * 9PM CET * 12PM PST * 3PM EST

Beautiful image created by MythologyArt via Pixabay

This Divine Life

Dragon Energy Activation for the New Moon in Virgo

Bournemouth

Our Virtual (via Zoom) course provide the same high-quality tuition as our classroom-based sessions. Quarterly meetings will take place at the Academy



Dental Nursing Diploma with National Examining Board for Dental Nurses (NEBDN) is an internationally recognised qualification that will allow you to work as a Dental Nurse in hospitals, NHS and private dental practices.

Successful completion of Dental Nursing Diploma course will enable you to register as a Dental Care Professional with the General Dental Council (GDC) and practice as a qualified Dental Nurse.


Discover the exciting world of dental nursing and be a part of a growing field that offers endless opportunities for growth and development.
How will you learn?
In addition to our traditional class-based tuition, we also offer Virtual (via Zoom) Learning courses to cater to different learning preferences. Our Virtual Learning courses provide the same high-quality tuition as our classroom-based sessions. To participate, you will need a laptop, PC, smart phone or tablet with a built-in or external camera and microphone. From the comfort of your own home, you will have the opportunity to communicate with your tutor and classmates through video chat, using your phone or computer camera. This allows for seamless interaction, discussions, and collaborative learning.

Quarterly meetings at the Academy
To ensure a well-rounded learning experience, you will be required to attend face-to-face lessons at the Academy on a quarterly basis, which means every three months. These sessions serve several important purposes:

Practical Units: Some aspects of the course require hands-on practical training. The face-to-face lessons will cover these practical units, allowing you to gain valuable experience and apply the knowledge you have acquired during the virtual learning sessions.

Tests and Mock Exams: These assessments are important for evaluating your progress, identifying areas for improvement, and preparing you for the final exams. The Academy will provide a controlled and supervised environment to ensure the integrity and fairness of these assessments.
Attending quarterly face-to-face lessons provides a balanced approach to your learning journey. It combines the convenience and flexibility of virtual learning with the benefits of in-person interactions, practical training, and assessments. By participating in these sessions, you will have the opportunity to reinforce your knowledge, receive personalized feedback, and build a stronger connection with your tutor and classmates.
The Academy is dedicated to supporting your growth and success in dental nursing field, and the face-to-face lessons are an integral part of that commitment.



Being a Dental Nurse can be an exciting and fulfilling career that allows you to make a positive impact on people’s lives while enjoying a variety of work and opportunities to learn and grow. You’ll get to work with an amazing dental team and get to know patients, helping them to feel at ease and comfortable during their visit. You’ll be the one behind the scene making sure everything runs smoothly, and you’ll be the one that patients will turn to for assistance. You’ll also get to be a part of the latest advancements in dental technology and treatment. And on top of all that, you get to have a flexible schedule and a good earning potential, with the potential to advance in your career. All in all, being a dental nurse is one of the most exciting and fulfilling career that you can have, and you’ll get to leave work every day knowing you’ve made a real difference in the lives of others.


The course is delivered by Team of Dental Professionals who are examiners, dentists and experienced Dental tutors with years of experience in teaching Dentistry.
Dental Nurses are involved in a wide range of procedures, from routine check-ups to complex surgeries, which can make the job interesting and varied.

Patient-centered care: Dental Nurses have a direct impact on the patient’s experience and can make a positive difference in people’s lives by providing them with quality care.

Professional development: Dental Nurses have the opportunity to continue their education and expand their skills, leading to advancement and new opportunities in the field.
No previous experience required – we will teach you from A to Z.
Do you need a job?
Yes, you will have 3 months’ time from the start of your course to find a placement.
The Academy provides a list of Private and NHS Dental Surgeries, who are regularly contacting us when looking for more Trainee Dental Nurses, so you can contact them directly as a registered student at the Academy. This is a paid job, unless you would like to work voluntary for personal reasons. We also provide a reference letter to the employee in case you need it.
The course is ideal for you if:
You are looking for a qualification that leads to employment
You intend to participate within dentistry and make a positive contribution to the dental health
You wish to learn how to maintain high standards of hygiene, cleanliness, health & safety
You enjoy interacting with multidisciplinary team and different people


The curriculum is based on the GDC (General Dental Council) registration requirements for dental nurses. It sets out the knowledge, skills and behavioural requirements that should be developed and demonstrated. These are set out in terms of professional competencies, with the assessment method clearly outlined (e.g. how the skills and knowledge will be assessed in the final examinations – via written questions such as multiple choice (MCQ) or extended matching questions (EMQ) or via Objective Structured Clinical Examinations – OSCEs). We are proud to announce that our Dental Nursing students has the highest examination pass rate in OSCE examinations!
Free services– workshops, mock exams, eRoE marking and internal moderation.


Earn while you learn could be another benefit for doing this course. We provide a list of Private Surgeries who have been working with us for the last 14 years and looking to recruit more Trainee Dental Nurses.
Working together – At our Dental Department, we prioritise working together with our learners every step of the way. We firmly believe in providing unwavering support, equipping you with the necessary tools, skills, and assistance to ensure your success. We take immense pride in the achievements of our students, with a long list of graduates boasting remarkable success stories. Our commitment to your success serves as the foundation for our own accomplishments
What Can You Expect to Earn as a Dental Nurse? Compared to other caring professions, Dental Nursing is well paid and offers plenty of opportunity for continued training and development. This is great for those looking on a the long-term plan for their career and those who wish to work their way up the ladder through continued learning, experience & hard work. Trainee Dental Nurse salary for standard working week will be around £23,000 per annum. Average wage for a qualified Dental Nurses between £40,417 to £42,350 p.a.
When are the exams?
There are two exams:
1. Multiple choice theory exam. November and March.
2. Practical exam. January and June. 
Record of Experience (eROE)
To be eligible to sit your first exam, you have to complete your electronic Record of Experience (eROE). The eROE has to be submitted to your tutor by 31st Jan for March exam, and 31st August for November exam. 
London Waterloo Academy supports Mouth Cancer Research Foundation and encouraging learners to raise the awareness and participate in annual 10k walk.



Study mode – virtual (via Zoom) live stream lessons combined with a quarterly meetings Saturday/Sunday at the Academy
Duration – 1 year (part time)
Virtual (via Zoom) classes – once a week
Quarterly meetings at the Academy – date are discussed with the group in advance
Next Intake/start dates (please choose one for your course to start):
21 September 2024, Saturday classes from 9am to 11am
Registration fee – £300 (includes: administration, workshops, mock exams, RoE marking, internal moderation of RoE)
Tuition Fees – £1,400 (we offer payment plan, and accept instalments)
Exam fee – £510 will be charged at the point of candidate registration with NEBDN
One day introduction course – for those who are considering/not sure whether to step up into the Dental Industry £50.00
Call us +44 (0) 7484 014980 or email to info@waterlooacademy.co.uk or Facebook – London Waterloo Academy
Office location: The Foundry, 156 Blackfriars Rd, London SE1 8EN (Southwark Station (2-3 min walk) and Waterloo/Blackfriars Station (10 min walk))

London Waterloo Academy

Dental Nurse

Dental Assistant

VIRTUAL DENTAL NURSING DIPLOMA

Registration Fee

Tuition Fee

Exam Fee

One Day Introduction Course

This five-day course is a must for anyone who is considering or already working in a role with site manager responsibilities. This course covers all relevant legislation affecting safe working in the building, construction, and civil engineering industries.
It is endorsed by Build UK as the standard training for all construction managers.
Aims
To give a clear understanding of health, safety, welfare, and environmental legislation that affects your management role. It highlights the need for risk assessment in the workplace, the implementation of the necessary control measures and adequate communication to sustain a health and safety culture within the workforce.
Course Content
To give a clear understanding of health, safety, welfare, and environmental legislation that affects your management role. It highlights the need for risk assessment in the workplace, the implementation of the necessary control measures and adequate communication to sustain a health and safety culture within the workforce.
Course Content
• Health, safety, welfare and environmental legislation affecting your daily work
• New guidance and industry best practice
• Duties and responsibilities with regards to health, safety, welfare, and the environment
• Safe working
Prerequisites
This course is for you if you’re considering, or already have management responsibilities for planning, organising, monitoring, controlling and administering groups of staff e.g. site manager.
Assessment
At the end of this course, all delegates will have a clear understanding of controlling health and safety on site from a manager’s role.
Certificate
The certification for this course is valid for 5 years and is endorsed by Build UK as a standard training for all site managers.
To remain certified in this area, you will need to take a refresher course before the expiry date on your certificate, otherwise the full course will need to be retaken.
Instructions
Please note all online Site Management Safety Training Scheme courses with the venue “Online” will be delivered by a tutor over a video call.
This training will be delivered and assessed in English language; therefore, a good standard is required to complete the course.
Further attendee information will be sent in a separate email, please check your inbox.

56223 Courses delivered Online

Microsoft Excel - Functions and Formulas

By AXIOM Learning Solutions

Mastering the Dynamics of the Colour Energies

By colour-energies.com

Microsoft Excel - More Functions and Formulas

By AXIOM Learning Solutions

Microsoft Teams - Fundamentals

By AXIOM Learning Solutions

Microsoft Planner Basic: The Essentials

By AXIOM Learning Solutions

Microsoft OneDrive for Business - Essentials

By AXIOM Learning Solutions

Microsoft Outlook - Working with the Calendar

By AXIOM Learning Solutions

Microsoft Excel - Tips and Shortcuts

By AXIOM Learning Solutions

Microsoft Word - Templates and Styles

By AXIOM Learning Solutions

Microsoft Excel - Formatting Spreadsheets

By AXIOM Learning Solutions