Name: Microsoft Access Advanced - In-company / Bespoke
Price: 550 GBP
Availability: InStock

London

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Identify the components of the Microsoft Project environment</li><li>Create a new project plan</li><li>Create the project schedule</li><li>Use different views to analyse the project plan</li><li>Create, allocate and manage resources in a project plan</li><li>Finalise a project plan</li><li>Track progress</li><li>View and report project plan information</li></ul><p>' 1 year email support service</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><p><strong>Very good course. Learnt a lot. Looking forward to the next level.</strong></p></li><li>Alexandra - CIAL</li></ul><p>'</p><p>1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Introduction to Microsoft Project</strong></p><ul><li>Recap on project management concepts</li><li>Project environment overview</li><li>The 3 databases: Tasks, Resources and Assignments</li><li>Different ways of displaying the Project Plan</li><li>Access Help</li></ul><p><strong>Creating a Project Plan</strong></p><ul><li>Create a New Project Plan</li><li>Project Information</li><li>Create and apply the project calendar</li><li>Defining recurring exceptions to the calendar</li><li>Defining the calendar's work weeks</li><li>Create the Summary tasks</li><li>Create the Work Breakdown Structure</li></ul><p><strong>Task creation and scheduling</strong></p><ul><li>Exploring the Entry Table and its fields</li><li>Task editing and the Task Information window</li><li>Task Durations</li><li>Defining Milestones</li><li>Manual Scheduling vs Automatic Scheduling</li><li>Changing the Task's Calendar</li><li>Create a split in a Task</li><li>Create Task Relationships</li><li>Adding Lag or Lead to a Relationship</li><li>Identifying the Critical Path</li><li>Adding Constraints and Deadlines to Tasks</li><li>Create Recurring Activities</li><li>Adding Notes and links to Tasks</li></ul><p><strong>Managing Resources</strong></p><ul><li>Exploring the Entry Table and its fields</li><li>Resource editing and the Resource Information window</li><li>Resource Types</li><li>Fixed Costs vs Variable Costs</li><li>Adding Resource Costs</li><li>Defining when costs accrue</li><li>Changing the Resource Calendar and Availability</li><li>Project calendar vs Resource and Task Calendar</li><li>Assigning Resources to Tasks</li><li>Effort Driven Scheduling</li><li>Resolving Resource Overallocation</li></ul><p><strong>Tracking the Project Progress</strong></p><ul><li>Setting a Project Baseline</li><li>Entering Actuals</li><li>Different ways of viewing the Progress</li><li>Checking if the Project is on track</li></ul><p><strong>Viewing and Reporting Project Detail</strong></p><ul><li>Adding Tasks to the Timeline and sharing it</li><li>Modifying the Timescale and Zoom level</li><li>Formatting the Gantt View</li><li>Filtering and Grouping Tasks</li><li>Print and Troubleshoot the Gantt View</li><li>Using built-in Reports in Microsoft Project</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>General knowledge of the Windows OS</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Microsoft Office know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Office Training

Microsoft Project Introduction - In-company

General Admission

<p><strong>Course Objectives</strong></p> <p>At the end of this course you will be able to:</p> <ul> <li>Modify the PowerPoint environment</li><li>Using Master View in order to customise a design template</li><li>Add and customize SmartArt graphics</li><li>Add animations and change its effect options</li><li>Add action buttons to control the flow of the presentation</li><li>Use various options to customise slide shows</li><li>Use different PowerPoint file types to distribute presentations</li></ul> <p>' 1 year email support service</p> <p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p> <p><em><strong>Customer Feedback</strong></em></p> <ul> <li> <p><strong>Very clearly explained</strong></p> </li><li> <p><strong>Good pace.</strong></p> </li><li>Lucy Tailor - ACER</li></ul> <p>'</p> <p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p> <p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p> <ul> <li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul> <p><strong><strong>Tailored training courses:</strong></strong></p> <p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Customising the PowerPoint Environment</strong></p> <ul> <li>Customise the User Interface</li><li>Set PowerPoint Options</li></ul> <p><strong>Customising Design Templates</strong></p> <ul> <li>Modify Slide Masters and Slide Layouts</li><li>Add Headers and Footers</li><li>Modify the Notes Master and the Handout Master</li></ul> <p><strong>Adding SmartArt to a Presentation</strong></p> <ul> <li>Create SmartArt</li><li>Modify SmartArt</li></ul> <p><strong>Working with Media</strong></p> <ul> <li>Add Audio to a Presentation</li><li>Add Video to a Presentation</li></ul> <p><strong>Working with Animations</strong></p> <ul> <li>Entrance, Emphasis and Exit Animations</li><li>Animate Charts by Category and Series</li><li>Customise Animations and Transitions</li></ul> <p><strong>Collaborating on a Presentation</strong></p> <ul> <li>Review a Presentation</li><li>Store and Share Presentations on the Web</li></ul> <p><strong>Customising a Slide Show</strong></p> <ul> <li>Annotate a Presentation</li><li>Set Up a Slide Show</li><li>Create a Custom Slide Show</li><li>Add Hyperlinks</li><li>Add Action Buttons</li><li>Record a Presentation</li></ul> <p><strong>Securing and Distributing a Presentation</strong></p> <ul> <li>Secure a Presentation</li><li>Create a Video or a CD</li><li>Distribute the Presentation in different File Formats</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>This course is designed for delegates who want to gain the skills necessary to work with design templates, various types of diagrams, special effects, custom slide shows, collaboration functionality, and advanced presentation delivery.</p> 
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Preferably, delegates should have attended the Powerpoint Introduction course.</p> 
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Microsoft Office know-how can instantly increase your job prospects as well as your salary.</p> <p>80 percent of job openings require spreadsheet and word-processing software skills</p> 
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Powerpoint Advanced - In-company (now with live online classes)

<p><strong>Course Objectives</strong></p> <p>At the end of this course you will be able to:</p> <ul> <li>Identify and work with basic Word 2013 tools and features</li><li>Edit text in a Word document</li><li>Modify the appearance of text in a Word document</li><li>Organise data in tables and lists</li><li>Insert special characters and graphical objects</li><li>Control the appearance of pages in a Word document</li><li>Proof a document</li><li>Customise the Word environment</li></ul> <p>'1 year email support service</p> <p>Take a look at the <strong>consistent excellent feedback from our corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p> <p><em><strong>Customer Feedback</strong></em></p> <ul> <li> <p><strong>Good pace, questions encoraged, trainer ensured everyone was kept at same level.</strong></p> </li><li>Jenny Price - ACER</li></ul> <p>'</p> <p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p> <p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p> <ul> <li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul> <p><strong><strong>Tailored training courses:</strong></strong></p> <p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Getting Started with Word</strong></p> <ul> <li>Identify the Components of the Word Interface</li><li>Create a Word Document</li><li>Help</li></ul> <p><strong>Editing a Document</strong></p> <ul> <li>Navigate and Select Text</li><li>Modify Text</li><li>Find and Replace Text</li></ul> <p><strong>Formatting Text and Paragraphs</strong></p> <ul> <li>Apply Character Formatting</li><li>Align Text Using Tabs</li><li>Display Text as List Items</li><li>Control Paragraph Layout</li><li>Apply Borders and Shading</li><li>Apply Styles</li><li>Manage Formatting</li></ul> <p><strong>Adding Tables</strong></p> <ul> <li>Insert a Table</li><li>Modify a Table</li><li>Format a Table</li><li>Convert Text to a Table</li></ul> <p><strong>Managing Lists</strong></p> <ul> <li>Sort a List</li><li>Renumber a List</li><li>Customise a List</li></ul> <p><strong>Inserting Graphic Objects</strong></p> <ul> <li>Insert Symbols and Special Characters</li><li>Add Images to a Document</li></ul> <p><strong>Page Setup</strong></p> <ul> <li>Apply a Page Border and Color</li><li>Add a Watermark</li><li>Add Headers and Footers</li><li>Control Page Layout</li></ul> <p><strong>Proofing a Document</strong></p> <ul> <li>Check Spelling and Grammar</li><li>Other Proofing Tools</li><li>Check Accessibility</li></ul> <p><strong>Customising the Word Environment</strong></p> <ul> <li>Customise the Word Interface</li><li>Additional Save Options</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>This course is intended for delegates who want to learn the fundamentals skills of working with Microsoft Word</p> 
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>General knowledge of the Windows OS</p> 
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Word Introduction - In-company (now with live online classes)

<p><strong>Course Objectives</strong></p><p>The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data.</p><p>'</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><p><strong>Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great.</strong></p></li><li>Kelly Moreley - TACT</li></ul><ul><li><strong>Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys.</strong></li><li>Jenny Price - Acer</li></ul><p>1 year email support service</p><p>Take a look at the <strong>consistent excellent feedback from our corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.</p><p><strong><strong>Tailored training courses:</strong></strong></p><p>In, in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Recap on Excel formulas and calculations</strong></p><ul><li>Overview of formulas in Excel</li><li>Relative, Absolute and Mixed cell references</li></ul><p><strong>Group editing worksheets</strong></p><p><strong>Autofill and Flash Fill</strong></p><p><strong>Changing Excel’s environment Options</strong></p><ul><li>Changing the default number of sheets</li><li>Creating an Autofill Custom List</li><li>Adding tools to the Quick Access Toolbar</li></ul><p><strong>Mastering Excel Tables</strong></p><ul><li>Introducing Excel Tables</li><li>Formatting a Table</li><li>Creating Calculated Columns</li><li>Using Slicers to filter your data</li><li>Using Totals to get statistics out of your data</li><li>Removing duplicates</li><li>Converting Tables back to normal Ranges</li></ul><p><strong>Using names Ranges</strong></p><ul><li>In Excel formulas</li><li>As a way of navigating through the workbook</li></ul><p><strong>Advanced Formulas</strong></p><ul><li>Simple IF examples</li><li>Using IF to check if a cell is blank</li><li>Nested IFs</li><li>VLOOKUP</li><li>HLOOKUP</li><li>Text Functions</li><li>Date Functions</li></ul><p><strong>Conditional formatting</strong></p><ul><li>Apply Conditional Formatting</li><li>Customising Conditional Formatting</li><li>Using Icons in Conditional Formatting</li><li>Using Formulas to conditionally format cells</li></ul><p><strong>Linking spreadsheets and workbooks</strong></p><ul><li>Making a reference to another worksheet</li><li>Making a reference to another workbook</li><li>Editing links</li><li>Troubleshooting links</li></ul><p><strong>Analysing databases</strong></p><ul><li>Quick analysis</li><li>Sorting a database</li><li>Apply filters to a database</li><li>Advance filter</li><li>Sorting and Filtering by Conditional Formats</li></ul><p><strong>Charts</strong></p><ul><li>Analyse trends in data using Sparklines</li><li>Creating charts from start to finish</li><li>Exploring the different Chart Types</li><li>Apply Chart Styles</li><li>Formatting Chart Elements</li><li>Filtering Charts by Series or Categories</li><li>Adding a Trendline to a Chart</li><li>Create a Chart Template</li></ul><p><strong>Attaching security to a spreadsheet and workbook</strong></p><ul><li>Protect Cells</li><li>Protect Structure of worksheets</li><li>Protect a Workbook by adding passwords</li></ul><p><strong>Introduction to Pivot Tables</strong></p><ul><li>What are Pivot Tables?</li><li>Using recommended pivot tables to analyse your data</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>For those who want to explore in more detail formulas and functions, data analysis and data presentation.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates would have attended the Excel Introduction course.</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Excel know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Excel Intermediate - In-company

<p><strong>Course Objectives</strong></p> <p>At the end of this course you will be able to:</p> <ul> <li>Identify the components of the PowerPoint interface</li><li>Create slides</li><li>Format text on slides</li><li>Add and modify graphical objects to a presentation</li><li>Work with tables in a presentation</li><li>Add charts to a presentation</li><li>Prepare the SlideShow</li></ul> <p>'1 year email support service</p> <p>Take a look at the <strong>consistent excellent feedback from our corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p> <p><em><strong>Customer Feedback</strong></em></p> <ul> <li> <p><strong>Very patient Trainer. Happy to adapt course + help with problems on existing presentations.</strong></p> </li><li>Andrea Lethbridge - CNN</li></ul> <p>'</p> <p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p> <p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p> <ul> <li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul> <p><strong><strong>Tailored training courses:</strong></strong></p> <p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Getting Started with PowerPoint</strong></p> <ul> <li>Identify the Components of the PowerPoint Interface</li><li>Create a PowerPoint Presentation</li><li>Accessing Help</li></ul> <p><strong>Choose the right view for the task in PowerPoint</strong></p> <ul> <li>Normal view</li><li>Slide Sorter view</li><li>Notes Page view</li><li>Outline view</li><li>Add, rearrange, and delete slides in PowerPoint</li></ul> <p><strong>Working with Themes</strong></p> <ul> <li>Add colour and design to my slides with themes</li><li>Remove the current slide design (theme)</li></ul> <p><strong>Slide Layout</strong></p> <ul> <li>What is a slide layout?</li><li>Apply or change a slide layout</li></ul> <p><strong>Working with text</strong></p> <ul> <li>Add text to a slide</li><li>Create a new text box</li><li>Format text</li></ul> <p><strong>Tables</strong></p> <ul> <li>Add a table to a slide</li><li>Format a Table</li><li>Copy and paste a table from Word</li><li>Insert an Excel spreadsheet within PowerPoint</li><li>Edit Cells, Rows and Columns</li><li>Delete a table</li></ul> <p><strong>Graphics</strong></p> <ul> <li>Working with Clipart, and Shapes</li><li>Selecting objects, shapes, pictures or text boxes</li><li>Arrange a picture, shape or other object</li></ul> <p><strong>Adding Charts to Your Presentation</strong></p> <ul> <li>Create a Chart</li><li>Format a Chart</li><li>Insert a Chart from Microsoft Excel</li></ul> <p><strong>Inserting date and slide numbers</strong></p> <ul> <li>Add slide numbers to your presentation</li><li>Hide slide numbers on the title slide</li><li>Change where the page numbers appear on your slides</li><li>Start your slide numbering with a specific number</li></ul> <p><strong>Print slides, notes, or handouts</strong></p> <p><strong>Create the Slide Show</strong></p> <ul> <li>Record your slide show</li><li>Preview the recorded slide show</li><li>Turn slide timings off</li><li>Set the slide timings manually</li><li>Add or remove transitions between slides</li><li>Add Animations to Text and Objects</li><li>Deliver the Presentation</li></ul> <p><strong>Speakers notes</strong></p> <ul> <li>Add speaker notes to your slides</li><li>View your speaker notes as you deliver your slide show</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>This course is designed for end users who are interested in learning the fundamentals needed to create and modify engaging presentations.</p> 
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>General knowledge of the Windows OS</p> 
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Microsoft Office know-how can instantly increase your job prospects as well as your salary.</p> <p>80 percent of job openings require spreadsheet and word-processing software skills</p> 
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Powerpoint Introduction - In-company (now with live online classes)

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Record and edit a Macro</li><li>Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects.</li><li>Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures</li><li>Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope</li><li>Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks</li><li>Create an error handling routine in case things go wrong with VBA code</li></ul><p>' 1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Best Training Ever!</strong></li><li>Just finished a bespoke 1-1 training course in Excel Advanced, Macros &amp; VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability.</li></ul><ul><li>Amanda Morris - Treasury &amp; Systems Accountant at Reall - Real Equity for All</li></ul><ul><li><p><strong>The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience..</strong></p></li><li>Simon Harper - Lloyd's of London</li></ul><ul><li><p><strong>My learning experience was awesome.</strong></p></li><li>Perdinand Reagan - Subsea7</li></ul><ul><li><p><strong>Very nice and relaxed approach to teaching. Was definitely a good learning experience</strong><strong>.</strong></p></li><li>Jerome Pupe - S5 Agency World</li></ul><ul><li><strong>The Trainer – Very positive + patient + helpful + thorough</strong></li><li>Agnes Souza - Direct Wines</li></ul><p>'</p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Introduction to Macros and VBA</strong></p><ul><li>Introducing Visual Basic for Applications</li><li>Recording a Macro</li><li>Naming conventions for Macro Procedures</li><li>Running a Macro</li><li>Absolute or Relative Cell Referencing</li><li>Saving and Opening Files with Macros</li><li>Making macros always available</li><li>Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes</li><li>Editing a Macro in the Visual Basic Editor</li><li>Understanding the Development Environment</li><li>Customising the Editor</li><li>Tips for General Typing in VBA</li><li>Using Visual Basic Help</li></ul><p><strong>Working with Procedures</strong></p><ul><li>Program Design</li><li>Understanding Modules</li><li>Naming Rules</li><li>Creating a Module</li><li>Understanding Procedures</li><li>Programming Macro Concepts</li><li>Creating a Subroutine</li><li>Creating a Function</li><li>Understanding Arguments</li><li>Exiting Procedures</li><li>Calling Procedures</li></ul><p><strong>Objects, Properties, Methods and Events</strong></p><ul><li>Understanding Objects Properties, Methods, and Events</li><li>Navigating the Object Hierarchy</li><li>Understanding Collections</li><li>Accessing a Member of a Collection</li><li>Understanding Hierarchy</li><li>Using the Object Browser</li><li>Using the With Statement</li><li>Working with Properties</li><li>Working with Methods</li><li>Creating an Event Procedure</li><li>Reserved Macro Names</li></ul><p><strong>Using Expressions, Variables and Intrinsic Functions</strong></p><ul><li>Understanding Expressions and Statements</li><li>Declaring Variables</li><li>Understanding Data Types</li><li>Determining the Value of Variables</li><li>Working with Variable Scope</li><li>Using Built-in VBA Functions</li><li>Understanding Constants</li><li>Using Message Boxes</li><li>Controlling the Answer to a Message Box</li><li>Using Input Boxes</li><li>Declaring and Using Object Variables</li></ul><p><strong>Controlling Program Execution</strong></p><ul><li>Understanding Control-of-Flow Structures</li><li>Using the If...End If Decision Structures</li><li>Nested If Statements</li><li>Using the Select Case ... End Select Structure</li><li>Using the Do ... Loop Structure</li><li>Using the For ... Next Structure</li><li>Using the For Each ... Next Structure</li><li>Guidelines for Use of Control-of-Flow Structures</li></ul><p><strong>Debugging and Handling Errors</strong></p><ul><li>Understanding Errors</li><li>Using Debugging Tools</li><li>Setting Breakpoints and Using Break Mode</li><li>Stepping Through Code</li><li>Trapping Errors with the On Error Statement</li><li>Understanding the Err Object</li><li>Working with Inline Error Handling</li><li>Writing an Error-Handling Routine</li></ul><p><strong>Working with Forms and Controls</strong></p><ul><li>Understanding UserForms</li><li>Creating a Form</li><li>Displaying and Removing a Form</li><li>Aligning and Sizing Controls</li><li>Using the Toolbox</li><li>Working with a Form's Properties, Methods, and Events</li><li>Working with Form and Control Properties, Methods and Event</li><li>Setting the Tab Order</li><li>Populating a Control</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates should have attended the Excel Advanced course.</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Excel Macros & VBA - In-company

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Work with advanced lookup and reference functions</li><li>Create macros to automate common tasks</li><li>Use advanced techniques to analyse data</li><li>Create PivotTables and PivotCharts</li><li>Work with data validation tools</li><li>Import and export data</li></ul><p>'</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Best Training Ever!</strong></li><li>Just finished a bespoke 1-1 training course in Excel Advanced, Macros &amp; VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability.</li></ul><ul><li>Amanda Morris - Treasury &amp; Systems Accountant at Reall - Real Equity for All</li></ul><ul><li><p><strong>The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic.</strong></p></li><li>Marving Lopez - AM Best Europe</li></ul><ul><li><strong>Pedro was excellent. Very knowledgeable, clear and great rapport with class.</strong></li><li>Darren Barkey - Direct Wines</li></ul><ul><li><strong>Great content and learnt a lot. Really enjoyable :)</strong></li><li>Kristie-Lee Ryan - Stirling Ackroyd</li></ul><p>1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p>Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.</p><p><strong>Advanced Functions</strong></p><ul><li>COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL</li><li>IF, OR, AND, IFERROR</li><li>VLOOKUP to lookup Exact Values and Approximate values</li><li>MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET</li></ul><p><strong>Analysing Data</strong></p><ul><li>PMT function to calculate a monthly payment of a loan</li><li>What If Analysis using Goal Seek</li><li>Use scenarios to consider many different variables</li><li>Using Solver Add-in to optimize variables</li></ul><p><strong>PivotTables</strong></p><ul><li>Create a PivotTable to analyse worksheet data</li><li>Add or remove fields in a PivotTable</li><li>Change the data source for a PivotTable</li><li>Working with external data sources</li><li>Using different Statistical Functions</li><li>Calculate a Running Total, % of Grant Total, Difference From…</li><li>Using the Slicer and Timeline to filter the PivotTable</li><li>Using Filters in a PivotTable</li><li>Group by Date, Auto Group by ranges of values, Custom Group</li><li>Create a PivotChart</li><li>The GETPIVOTDATA function</li></ul><p><strong>Formula auditing</strong></p><ul><li>Precedents and dependents</li><li>Error checking</li><li>Watch a formula and its result by using the Watch Window</li><li>Evaluate a nested formula one step at a time</li></ul><p><strong>Data Validation</strong></p><ul><li>Number Validation</li><li>Data List Validation</li><li>Message Prompts and Alerts</li><li>Conditional Data Validation</li><li>Data Validation Errors</li></ul><p><strong>Consolidation</strong></p><ul><li>Consolidate data by position</li><li>Consolidate data by category</li><li>Use a formula to consolidate data</li></ul><p><strong>Outline (group) data in a worksheet</strong></p><ul><li>Create an outline of rows</li><li>Create an outline of columns</li><li>Copy outlined data</li><li>Hide or remove an outline</li></ul><p><strong>Connect external data to your workbook</strong></p><ul><li>Using the Power Query Editor to import data</li><li>From Text and CSV, From Access, From Web, From another Workbook</li><li>Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more.</li><li>Deleting Applied Steps</li><li>Refreshing your data</li></ul><p><strong>Working with Form Controls; Buttons, Option Buttons and Scroll Bars</strong></p><p><strong>Introduction to Macros</strong></p><ul><li>Change Macro Security settings</li><li>How to Record a macro</li><li>Some Macro Examples</li><li>Delete a macro</li><li>Edit the macro to view the VBA code</li><li>Copy part of a macro to create another macro</li><li>Assign a macro to a button</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates should have attended the Excel Intermediate course.</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Excel know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Excel Advanced - In-company

<p>This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and  data Modelling, to create Visualizations, and publish Reports to different platforms<br />.</p> <p><strong>Course Objectives</strong></p> <p>At the end of this course you will be able to:</p> <ul> <li>Connect to data from different sources.</li><li>Use the Query Editor</li><li>Perform Power BI desktop data Shaping and Transformation.</li><li>Create Power BI desktop Modelling.</li><li>Create Power BI desktop Visualizations and Reports.</li></ul> <p>' 1 year email support service</p> <p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p> <p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence.</p> <p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p> <ul> <li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul> <p><strong><strong>Tailored training courses:</strong></strong></p> <p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p> <p>Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.</p><p><strong>Introduction to Power BI</strong></p> <ul> <li>Power BI Jargon explained</li><li>A quick look at Power BI Desktop</li><li>A quick look at the Power BI service</li><li>Helpful resources</li></ul> <p><strong>Power BI and Excel</strong></p> <ul> <li>Introduction to using Excel data in Power BI</li><li>Upload Excel data to Power BI</li><li>Import Power View and Power Pivot to Power BI</li></ul> <p><strong>Getting started with Power BI Desktop</strong></p> <ul> <li>Overview of Power BI Desktop</li><li>Accessing Help and Helpful resources</li><li>Connect to data sources in Power BI Desktop</li></ul> <p><strong>Shaping and Transforming Data with Query Editor</strong></p> <ul> <li>Introduction to the Query Editor</li><li>Data Sources Power BI Desktop can Connect to</li><li>Introduction to Steps and M code</li><li>Combining Data Using Merge and Append Queries</li><li>Data Type Properties</li><li>Working with Delimiters</li><li>Clean and transform your data with the Query Editor</li><li>Text Specific Transformation Tools</li><li>Number Specific Transformation Tools</li><li>Date Specific Transformation Tools</li><li>Split and Merge columns</li><li>Creating an Index Column</li><li>Adding Conditional Columns</li><li>Columns From Examples</li><li>Grouping and Aggregating data</li><li>Pivoting and Unpivoting</li><li>Using filters</li></ul> <p><strong>Modeling the data</strong></p> <ul> <li>Introduction to modeling your data</li><li>How to manage your data relationships</li><li>Create calculated columns</li><li>Optimizing data models</li><li>Create calculated measures</li><li>Show Values As and Quick Measures</li><li>Create calculated tables</li><li>Explore your time-based data</li><li>Introduction to DAX</li><li>DAX calculation types</li><li>DAX functions</li></ul> <p><strong>Visualizations</strong></p> <ul> <li>Introduction to visuals in Power BI</li><li>Create and customize simple visualizations</li><li>Modify colors in charts and visuals</li><li>Shapes, text boxes, and images</li><li>Page layout and formatting</li><li>Group interactions among visualizations</li><li>Visual hierarchies and drill-down</li><li>Using custom visualizations</li><li>Create a KPI Visualization</li><li>Geo-Data and Maps</li></ul> <p><strong>Reports, Publishing and Sharing</strong></p> <ul> <li>Introduction to the Power BI service</li><li>Quick insights in Power BI</li><li>Create and configure a dashboard</li><li>Ask questions of your data with natural language</li><li>Create custom Q&amp;A suggestions</li><li>Share dashboards with your organization</li><li>Introduction to content packs, security, and groups</li><li>Publish Power BI Desktop reports</li><li>Print and export dashboards and reports</li><li>Create groups in Power BI</li><li>Use content packs</li><li>Update content packs</li><li>Publish to web</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create  Visualizations, and publish Reports to different platforms.</p> 
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Before attending this course, delegates should have:<br />- A general knowledge of database concepts (fields, records and relationships)<br />- Familiarity with Excel.</p> 
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Business Intelligence<br /><br />Data Analysis<br /><br />ETL &amp; Data Warehousing</p> 
                        </div>

Microsoft Power BI Desktop In-company (now with live online classes)

Wigan

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyVGhpcyUyMGRheSUyMGlzJTIwZm9yJTIwZXhwZXJpZW5jZWQlMjBoZWF0aW5nJTIwZW5naW5lZXJzJTIwYW5kJTIwZGVzaWduZXJzLiUyMFdlJTIwd2lsbCUyMHN0YXJ0JTIwdGhlJTIwZGF5JTIwd2l0aCUyMGxlYXJuaW5nJTIwaG93JTIwdG8lMjBkbyUyMG1hbnVhbCUyQyUyMGhhbmQlMjBjYWxjdWxhdGlvbnMlMjBvZiUyMGhlYXQlMjBsb3NzZXMlMjBmb3IlMjB0eXBpY2FsJTIwYnVsZGluZ3MlMjBhbmQlMjBidWlsZGluZyUyMG1hdGVyaWFscy4lMjBXZSUyMHdpbGwlMjB0aGVuJTIwZ2V0JTIwaW50byUyMHBpcGUlMjBzaXppbmclMkMlMjBmbG93JTIwcmF0ZXMlMkMlMjBwdW1wJTIwc2l6aW5nJTIwZXRjJTIwdXNpbmclMjB0aGUlMjBmYWJ1bG91cyUyMElNSSUyMEh5VG9vbHMlMjBhcHAlMjBhbmQlMjBkZW1vbnN0cmF0aW5nJTIwc29tZSUyMG9mJTIwdGhlaXIlMjBwb3B1bGFyJTIwZXF1aXBtZW50LiUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTVEJTdEJTVEJTdEJTVEJTdE" fr-original-style="" style="box-sizing: border-box;">This day is for beginner and experienced heating engineers and designers. We will start the day with learning how to do manual, long hand calculations of heat losses for typical buldings and building materials. We will then use the fabulous Heat Engineer Software to calculate bespoke building materials and fully understand a heating engineers requirement for accurate heat losses to the new Part L building regulations. We will use the radiator sizing and pipe sizing software tools for any flow temperature &nbsp;&amp; Delta T and include correction values, MWT calculations automatically.</span></p>

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyVGhpcyUyMGRheSUyMGlzJTIwZm9yJTIwZXhwZXJpZW5jZWQlMjBoZWF0aW5nJTIwZW5naW5lZXJzJTIwYW5kJTIwZGVzaWduZXJzLiUyMFdlJTIwd2lsbCUyMHN0YXJ0JTIwdGhlJTIwZGF5JTIwd2l0aCUyMGxlYXJuaW5nJTIwaG93JTIwdG8lMjBkbyUyMG1hbnVhbCUyQyUyMGhhbmQlMjBjYWxjdWxhdGlvbnMlMjBvZiUyMGhlYXQlMjBsb3NzZXMlMjBmb3IlMjB0eXBpY2FsJTIwYnVsZGluZ3MlMjBhbmQlMjBidWlsZGluZyUyMG1hdGVyaWFscy4lMjBXZSUyMHdpbGwlMjB0aGVuJTIwZ2V0JTIwaW50byUyMHBpcGUlMjBzaXppbmclMkMlMjBmbG93JTIwcmF0ZXMlMkMlMjBwdW1wJTIwc2l6aW5nJTIwZXRjJTIwdXNpbmclMjB0aGUlMjBmYWJ1bG91cyUyMElNSSUyMEh5VG9vbHMlMjBhcHAlMjBhbmQlMjBkZW1vbnN0cmF0aW5nJTIwc29tZSUyMG9mJTIwdGhlaXIlMjBwb3B1bGFyJTIwZXF1aXBtZW50LiUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTVEJTdEJTVEJTdEJTVEJTdE" fr-original-style="" style="box-sizing: border-box;">By the end of a fairly intense but hopefully fun day, you will have the knowledge to design the hydronics and calculate the heat loss of any system or building type using both Heat Engineer Software and IMI-Hydronic HyTools App.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyVGhpcyUyMGRheSUyMGlzJTIwZm9yJTIwZXhwZXJpZW5jZWQlMjBoZWF0aW5nJTIwZW5naW5lZXJzJTIwYW5kJTIwZGVzaWduZXJzLiUyMFdlJTIwd2lsbCUyMHN0YXJ0JTIwdGhlJTIwZGF5JTIwd2l0aCUyMGxlYXJuaW5nJTIwaG93JTIwdG8lMjBkbyUyMG1hbnVhbCUyQyUyMGhhbmQlMjBjYWxjdWxhdGlvbnMlMjBvZiUyMGhlYXQlMjBsb3NzZXMlMjBmb3IlMjB0eXBpY2FsJTIwYnVsZGluZ3MlMjBhbmQlMjBidWlsZGluZyUyMG1hdGVyaWFscy4lMjBXZSUyMHdpbGwlMjB0aGVuJTIwZ2V0JTIwaW50byUyMHBpcGUlMjBzaXppbmclMkMlMjBmbG93JTIwcmF0ZXMlMkMlMjBwdW1wJTIwc2l6aW5nJTIwZXRjJTIwdXNpbmclMjB0aGUlMjBmYWJ1bG91cyUyMElNSSUyMEh5VG9vbHMlMjBhcHAlMjBhbmQlMjBkZW1vbnN0cmF0aW5nJTIwc29tZSUyMG9mJTIwdGhlaXIlMjBwb3B1bGFyJTIwZXF1aXBtZW50LiUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTVEJTdEJTVEJTdEJTVEJTdE" fr-original-style="" style="box-sizing: border-box;">I now have a fully detailed course book that is included within the course price.</span></p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyVGhpcyUyMGRheSUyMGlzJTIwZm9yJTIwZXhwZXJpZW5jZWQlMjBoZWF0aW5nJTIwZW5naW5lZXJzJTIwYW5kJTIwZGVzaWduZXJzLiUyMFdlJTIwd2lsbCUyMHN0YXJ0JTIwdGhlJTIwZGF5JTIwd2l0aCUyMGxlYXJuaW5nJTIwaG93JTIwdG8lMjBkbyUyMG1hbnVhbCUyQyUyMGhhbmQlMjBjYWxjdWxhdGlvbnMlMjBvZiUyMGhlYXQlMjBsb3NzZXMlMjBmb3IlMjB0eXBpY2FsJTIwYnVsZGluZ3MlMjBhbmQlMjBidWlsZGluZyUyMG1hdGVyaWFscy4lMjBXZSUyMHdpbGwlMjB0aGVuJTIwZ2V0JTIwaW50byUyMHBpcGUlMjBzaXppbmclMkMlMjBmbG93JTIwcmF0ZXMlMkMlMjBwdW1wJTIwc2l6aW5nJTIwZXRjJTIwdXNpbmclMjB0aGUlMjBmYWJ1bG91cyUyMElNSSUyMEh5VG9vbHMlMjBhcHAlMjBhbmQlMjBkZW1vbnN0cmF0aW5nJTIwc29tZSUyMG9mJTIwdGhlaXIlMjBwb3B1bGFyJTIwZXF1aXBtZW50LiUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTVEJTdEJTVEJTdEJTVEJTdE" fr-original-style="" style="box-sizing: border-box;">I personally use all of the above every day as a professional heating design consultant and there is no reason as to why you couldn&#39;t also do the same thing. #BeaPro</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p>

Rob Berridge Heating Design Consultants

Home Repair

HVAC (Heat, Ventilation & Air Conditioning)

Heating Engineer

Please check out our website www.heat-engineer.com but also my own private consultancy website www.robberridge.co.uk 

Heat Engineer Software In Depth

General admission

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Objectives</strong></p> <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">At the end of this course you will be able to:</p> <ul fr-original-style="" style="box-sizing: border-box;"> <li fr-original-style="" style="box-sizing: border-box;">Do advance Table design</li><li fr-original-style="" style="box-sizing: border-box;">Do advance Query design and Action Querys</li><li fr-original-style="" style="box-sizing: border-box;">Do advance Form design with the use of macros and buttons</li><li fr-original-style="" style="box-sizing: border-box;">Export and import data to and from different sources.</li></ul> <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1 year email support service</p> <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Take a look at the <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">consistent excellent feedback from our corporate clients</strong> visiting our site <em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ms-officetraining co uk</strong></em></p> <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p> <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> public, one to one, tailored and bespoke courses.</strong></p> <ul fr-original-style="" style="box-sizing: border-box;"> <li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Our competitive rates <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">start from &pound;550.00 per day of training</strong></strong></li></ul> <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Tailored training courses:</strong></strong></p> <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Advanced Table Design</strong></p> <ul fr-original-style="" style="box-sizing: border-box;"> <li fr-original-style="" style="box-sizing: border-box;">Advanced Field Properties</li><li fr-original-style="" style="box-sizing: border-box;">Table Properties</li></ul> <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Advanced Query Design</strong></p> <ul fr-original-style="" style="box-sizing: border-box;"> <li fr-original-style="" style="box-sizing: border-box;">Advanced Naming Conventions</li><li fr-original-style="" style="box-sizing: border-box;">Join Tables in Queries</li><li fr-original-style="" style="box-sizing: border-box;">Manage Query Joins</li><li fr-original-style="" style="box-sizing: border-box;">Use Self-Joins in Queries</li><li fr-original-style="" style="box-sizing: border-box;">Summarise Data in Queries</li><li fr-original-style="" style="box-sizing: border-box;">Parameter Queries</li><li fr-original-style="" style="box-sizing: border-box;">Action Queries</li><li fr-original-style="" style="box-sizing: border-box;">Crosstab Queries</li></ul> <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Advanced Form Design</strong></p> <ul fr-original-style="" style="box-sizing: border-box;"> <li fr-original-style="" style="box-sizing: border-box;">Create Subforms and Linked Forms</li><li fr-original-style="" style="box-sizing: border-box;">Form Controls</li><li fr-original-style="" style="box-sizing: border-box;">Command Buttons</li><li fr-original-style="" style="box-sizing: border-box;">Form Properties</li><li fr-original-style="" style="box-sizing: border-box;">Interface, Start-Up and Navigations Forms</li></ul> <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Working with Macros</strong></p> <ul fr-original-style="" style="box-sizing: border-box;"> <li fr-original-style="" style="box-sizing: border-box;">Create Single Macros</li><li fr-original-style="" style="box-sizing: border-box;">Run Macros</li><li fr-original-style="" style="box-sizing: border-box;">Work with Sub Macros</li><li fr-original-style="" style="box-sizing: border-box;">Use Conditional Macros</li><li fr-original-style="" style="box-sizing: border-box;">Run Macros from Buttons</li><li fr-original-style="" style="box-sizing: border-box;">Assign Macros to Events</li></ul> <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Extending Data Reach</strong></p> <ul fr-original-style="" style="box-sizing: border-box;"> <li fr-original-style="" style="box-sizing: border-box;">Import Data</li><li fr-original-style="" style="box-sizing: border-box;">Export Data</li><li fr-original-style="" style="box-sizing: border-box;">Work with Linked Tables</li></ul> <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Managing Databases</strong></p> <ul fr-original-style="" style="box-sizing: border-box;"> <li fr-original-style="" style="box-sizing: border-box;">Object Dependencies</li><li fr-original-style="" style="box-sizing: border-box;">Database Documenter</li><li fr-original-style="" style="box-sizing: border-box;">Performance Analyzers</li><li fr-original-style="" style="box-sizing: border-box;">Regular Management of a Database</li><li fr-original-style="" style="box-sizing: border-box;">Access Database Security</li></ul><h2 fr-original-style="" style="box-sizing: border-box;">
        
            Who is this course for?
        
        <div fr-original-style="" style="box-sizing: border-box;">Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for" fr-original-style="" style="box-sizing: border-box;">
                             <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros.</p> 
                        </div><h2 fr-original-style="" style="box-sizing: border-box;">
        
            Career path
        
        <div fr-original-style="" style="box-sizing: border-box;">Career path</div>
    </h2>

                        <div id="career_path" fr-original-style="" style="box-sizing: border-box;">
                             <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Microsoft Office know-how can instantly increase your job prospects as well as your salary.</p> <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">80 percent of job openings require spreadsheet and word-processing software skills</p> 
                        </div>

Microsoft Access Advanced - In-company / Bespoke

<span data-canva-clipboard="ewAiAGEAIgA6ADUALAAiAGgAIgA6ACIAdwB3AHcALgBjAGEAbgB2AGEALgBjAG8AbQAiACwAIgBjACIAOgAiAEQAQQBHAE4ARQBIAGEAMAA3ADAAdwAiACwAIgBpACIAOgAiAFEAVgAwAG4AMgBDAHQAawBXAFQAcABpAEQAQgA4AFEAOABlAFMAcgBtAEEAIgAsACIAYgAiADoAMQA3ADIAMgA5ADMAMgA2ADcANQA2ADIANgAsACIAQQA/ACIAOgAiAEIAIgAsACIAQQAiADoAWwB7ACIAQQAiADoAMwA3ADIALgAzADgANQA0ADkANAA0ADEANQAyADYANAAxACwAIgBEACIAOgAyADQANwA5AC4AOQA5ADkAOQA5ADkAOQA5ADkAOQA5ADkANQAsACIAQwAiADoANwA2ADcALgA1ADYAOQAwADUANQA1ADgANQA5ADMANwA1ACwAIgBBAD8AIgA6ACIASwAiACwAIgBhACIAOgB7ACIAQQAiADoAWwB7ACIAQQA/ACIAOgAiAEIAIgAsACIAQQAiADoAMQA1ADUAfQAsAHsAIgBBAD8AIgA6ACIAQQAiACwAIgBBACIAOgAiAFcAYQBuAHQAIAB0AG8AIABsAGUAYQByAG4AIABmAHIAbwBtACAAcwBvAG0AZQBvAG4AZQAgAHcAaABvABkgcwAgAGIAZQBlAG4AIABpAG4AIAB5AG8AdQByACAAcwBoAG8AZQBzACAAagB1AHMAdAAgADUAeQByAHMAIABhAGcAbwA/AFwAbgAiAH0ALAB7ACIAQQA/ACIAOgAiAEIAIgAsACIAQQAiADoAMQB9ACwAewAiAEEAPwAiADoAIgBBACIALAAiAEEAIgA6ACIAIABJACAAdwBhAHMAIABvAG4AYwBlACAAdwBoAGUAcgBlACAAeQBvAHUAIABhAHIAZQAgAG4AbwB3ACwAIABhAG4AZAAgAEkAJwB2AGUAIABtAGEAZABlACAAZQB4AHAAZQBuAHMAaQB2AGUAIABtAGkAcwB0AGEAawBlAHMAIQAgAFkAbwB1ACAAZwBlAHQAIAB0AG8AIABsAGUAYQByAG4AIABmAHIAbwBtACAAdABoAGUAcwBlACAAYQBuAGQAIABtAHkAIABlAHgAcABlAHIAaQBlAG4AYwBlACAAbwBmACAAYgB1AGkAbABkAGkAbgBnACAAbQB5ACAAdABoAHIAaQB2AGkAbgBnACAAcAByAGEAYwB0AGkAYwBlACAAbwB2AGUAcgAgADUAIAB5AGUAYQByAHMAIQBcAG4AIgB9ACwAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADEAfQAsAHsAIgBBAD8AIgA6ACIAQQAiACwAIgBBACIAOgAiACAASQAgAHcAaQBsAGwAIABkAHIAbwB3AG4AIABvAHUAdAAgAHQAaABlACAAbgBvAGkAcwBlACAAYQBuAGQAIABCAFMALAAgAGwAZQBhAGQAIAB5AG8AdQAgAGIAeQAgAHQAaABlACAAaABhAG4AZAAgAGEAbgBkACAAcwBoAG8AdwAgAHkAbwB1ACAAdwBoAGEAdAAgAHQAbwAgAGQAbwAuACAAIgB9ACwAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADUAMQB9ACwAewAiAEEAPwAiADoAIgBBACIALAAiAEEAIgA6ACIAXABuACIAfQAsAHsAIgBBAD8AIgA6ACIAQgAiACwAIgBBACIAOgAxAH0ALAB7ACIAQQA/ACIAOgAiAEEAIgAsACIAQQAiADoAIgAgAEcAZQB0ACAAdABoAGUAIABiAGEAcwBpAGMAcwAgAHIAaQBnAGgAdAAgAGYAcgBvAG0AIAB0AGgAZQAgAHMAdABhAHIAdAAgAHMAbwAgAHkAbwB1ACAAZABvAG4AJwB0ACAAbQBhAGsAZQAgAGUAeABwAGUAbgBzAGkAdgBlACAAbQBpAHMAdABhAGsAZQBzACAAKABsAGUAYQByAG4AIABmAHIAbwBtACAAbQB5ACAAbQBpAHMAdABhAGsAZQBzACEAKQBcAG4AIgB9ACwAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADEAfQAsAHsAIgBBAD8AIgA6ACIAQQAiACwAIgBBACIAOgAiACAAUwBtAGEAbABsACAAaQBuAHYAZQBzAHQAbQBlAG4AdAAgAHQAaABhAHQAIAB3AGkAbABsACAAcwBhAHYAZQAgAHkAbwB1ACAAdABpAG0AZQAgAGEAbgBkACAAbQBvAG4AZQB5ACAAaQBuACAAdABoAGUAIABsAG8AbgBnACAAcgB1AG4AXABuACIAfQAsAHsAIgBBAD8AIgA6ACIAQgAiACwAIgBBACIAOgAxAH0ALAB7ACIAQQA/ACIAOgAiAEEAIgAsACIAQQAiADoAIgBcAG4AIgB9ACwAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADIAfQAsAHsAIgBBAD8AIgA6ACIAQQAiACwAIgBBACIAOgAiAFMAbQBhAGwAbAAgAGkAbgB0AGkAbQBhAHQAZQAgAGcAcgBvAHUAcABzACAAbQBlAGEAbgAgAHQAaABlACAAYQBkAHYAaQBjAGUAIABpAHMAIAB0AGEAcgBnAGUAdABlAGQAIAB0AG8AIABpAG4AZABpAHYAaQBkAHUAYQBsAHMALAAgAGEAbgBkACAAZQBhAGMAaAAgAHAAZQByAHMAbwBuACAAaABhAHMAIABkAGkAcgBlAGMAdAAgAGEAYwBjAGUAcwBzACAAdABvACAAbQBlACAAIgB9ACwAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADIANQB9ACwAewAiAEEAPwAiADoAIgBBACIALAAiAEEAIgA6ACIAXABuAEIAZQBnAGkAbgBuAGUAcgAgAHQAbwAgAEIAbwBzAHMAIABpAHMAIABhACAAMQAyACAAdwBlAGUAawAgAG8AbgBsAGkAbgBlACAAcAByAG8AZwByAGEAbQBtAGUAIAB3AGgAaQBjAGgAIABnAGUAbgB0AGwAeQAgAHQAYQBrAGUAcwAgAHkAbwB1ACAAYgB5ACAAdABoAGUAIABoAGEAbgBkACAAYQBuAGQAIABjAHUAdABzACAAdABoAHIAbwB1AGcAaAAgAHQAaABlACAAbgBvAGkAcwBlACAAdABvACAAdABlAGEAYwBoACAAeQBvAHUAIAB0AGgAZQAgAGIAYQBzAGkAYwBzACAAbwBmACAAYgB1AHMAaQBuAGUAcwBzAC4AIABcAG4AIgB9AF0ALAAiAEIAIgA6AFsAewAiAEEAPwAiADoAIgBBACIALAAiAEEAIgA6AHsAIgBmAG8AbgB0AC0AcwBpAHoAZQAiADoAewAiAEIAIgA6ACIANQAwAC4AMQA1ADQANgAiAH0ALAAiAGYAbwBuAHQALQB3AGUAaQBnAGgAdAAiADoAewAiAEIAIgA6ACIAYgBvAGwAZAAiAH0ALAAiAGQAZQBjAG8AcgBhAHQAaQBvAG4AIgA6AHsAIgBCACIAOgAiAHUAbgBkAGUAcgBsAGkAbgBlACIAfQAsACIAdABlAHgAdAAtAGEAbABpAGcAbgAiADoAewAiAEIAIgA6ACIAYwBlAG4AdABlAHIAIgB9ACwAIgBmAG8AbgB0AC0AZgBhAG0AaQBsAHkAIgA6AHsAIgBCACIAOgAiAFkAQQBGAGMAZgByAGcAbABwAFYAQQAsADAAIgB9ACwAIgBmAG8AbgB0AC0AcwB0AHkAbABlACIAOgB7ACIAQgAiADoAIgBuAG8AcgBtAGEAbAAiAH0ALAAiAGMAbwBsAG8AcgAiADoAewAiAEIAIgA6ACIAIwAwADAAMAAwADAAMAAiAH0AfQB9ACwAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADIAMgAxAH0ALAB7ACIAQQA/ACIAOgAiAEEAIgAsACIAQQAiADoAewAiAGYAbwBuAHQALQB3AGUAaQBnAGgAdAAiADoAewAiAEIAIgA6ACIAbgBvAHIAbQBhAGwAIgB9ACwAIgBkAGUAYwBvAHIAYQB0AGkAbwBuACIAOgB7AH0AfQB9ACwAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADEAfQAsAHsAIgBBAD8AIgA6ACIAQQAiACwAIgBBACIAOgB7ACIAbABpAHMAdAAtAG0AYQByAGsAZQByACIAOgB7ACIAQgAiADoAIgBkAGkAcwBjACIAfQAsACIAbABpAHMAdAAtAGwAZQB2AGUAbAAiADoAewAiAEIAIgA6ACIAMQAuADAAIgB9ACwAIgBoAGUAYQBkAC0AaQBuAGQAZQBuAHQAIgA6AHsAIgBCACIAOgAiADEANwAwADAALgAwACIAfQAsACIAdABlAHgAdAAtAGEAbABpAGcAbgAiADoAewB9AH0AfQAsAHsAIgBBAD8AIgA6ACIAQgAiACwAIgBBACIAOgA2ADAAMAB9ACwAewAiAEEAPwAiADoAIgBBACIALAAiAEEAIgA6AHsAIgBsAGkAcwB0AC0AbQBhAHIAawBlAHIAIgA6AHsAfQAsACIAbABpAHMAdAAtAGwAZQB2AGUAbAAiADoAewB9ACwAIgBoAGUAYQBkAC0AaQBuAGQAZQBuAHQAIgA6AHsAfQB9AH0ALAB7ACIAQQA/ACIAOgAiAEIAIgAsACIAQQAiADoAMQA0ADcAfQAsAHsAIgBBAD8AIgA6ACIAQQAiACwAIgBBACIAOgB7ACIAZgBvAG4AdAAtAHMAaQB6AGUAIgA6AHsAfQAsACIAZgBvAG4AdAAtAHcAZQBpAGcAaAB0ACIAOgB7AH0ALAAiAGYAbwBuAHQALQBmAGEAbQBpAGwAeQAiADoAewB9ACwAIgBmAG8AbgB0AC0AcwB0AHkAbABlACIAOgB7AH0ALAAiAGMAbwBsAG8AcgAiADoAewB9AH0AfQBdAH0ALAAiAGIAIgA6AHsAIgBBACIAOgBbADYANwAsADEAMAAwACwANQA4ACwAOAAzACwAMQAwADAALAA2ADgALAAxACwAMQAwADMALAA0ACwAMQAwADMALAA0ADQAXQB9ACwAIgBkACIAOgAiAEEAIgAsACIAZwAiADoAZgBhAGwAcwBlACwAIgBoACIAOgAiAEEAIgB9AF0ALAAiAEIAIgA6ADIANAA4ADAALAAiAEMAIgA6ADEANwA0ADgAfQA=" id="isPasted" fr-original-style="" style="box-sizing: border-box;"></span><span data-canva-clipboard="ewAiAGEAIgA6ADUALAAiAGgAIgA6ACIAdwB3AHcALgBjAGEAbgB2AGEALgBjAG8AbQAiACwAIgBjACIAOgAiAEQAQQBHAE4ARQBIAGEAMAA3ADAAdwAiACwAIgBpACIAOgAiAFEAVgAwAG4AMgBDAHQAawBXAFQAcABpAEQAQgA4AFEAOABlAFMAcgBtAEEAIgAsACIAYgAiADoAMQA3ADIAMgA5ADMAMgA2ADcANQA2ADIANgAsACIAQQA/ACIAOgAiAEIAIgAsACIAQQAiADoAWwB7ACIARAAiADoAMgA0ADgAMAAuADAAMAAwADAAMAAwADAAMAAwADAAMAAwADUALAAiAEMAIgA6ADIANwA3AC4AMAA3ADkANwA4ACwAIgBBAD8AIgA6ACIASwAiACwAIgBhACIAOgB7ACIAQQAiADoAWwB7ACIAQQA/ACIAOgAiAEIAIgAsACIAQQAiADoAMwB9ACwAewAiAEEAPwAiADoAIgBBACIALAAiAEEAIgA6ACIAQQByAGUAIAB5AG8AdQAgAGEAIABuAGUAdwBsAHkAIABxAHUAYQBsAGkAZgBpAGUAZAAgAGgAbwBtAGUAbwBwAGEAdABoAC8AdABoAGUAcgBhAHAAaQBzAHQAIABvAHIAIABpAG4AIAB5AG8AdQByACAAMQBzAHQAIAB5AGUAYQByACAAbwBmACAAYgB1AHMAaQBuAGUAcwBzAD8AIABBAHIAZQAgAHkAbwB1ACAAYwBvAG4AZgB1AHMAZQBkACAAYQBuAGQAIABvAHYAZQByAHcAaABlAGwAbQBlAGQALAAgAHQAcgB5AGkAbgBnACAAdABvACAAYgB1AGkAbABkACAAYQAgAHQAaAByAGkAdgBpAG4AZwAgAGIAdQBzAHkAIABwAHIAYQBjAHQAaQBjAGUAPwAiAH0ALAB7ACIAQQA/ACIAOgAiAEIAIgAsACIAQQAiADoAMQA1ADkAMAB9ACwAewAiAEEAPwAiADoAIgBBACIALAAiAEEAIgA6ACIAXABuACIAfQBdACwAIgBCACIAOgBbAHsAIgBBAD8AIgA6ACIAQQAiACwAIgBBACIAOgB7ACIAZgBvAG4AdAAtAHMAaQB6AGUAIgA6AHsAIgBCACIAOgAiADYAOQAuADYAMAAxADEAIgB9ACwAIgBmAG8AbgB0AC0AZgBhAG0AaQBsAHkAIgA6AHsAIgBCACIAOgAiAFkAQQBGAGMAZgByAGcAbABwAFYAQQAsADAAIgB9ACwAIgBmAG8AbgB0AC0AdwBlAGkAZwBoAHQAIgA6AHsAIgBCACIAOgAiAG4AbwByAG0AYQBsACIAfQAsACIAZgBvAG4AdAAtAHMAdAB5AGwAZQAiADoAewAiAEIAIgA6ACIAbgBvAHIAbQBhAGwAIgB9ACwAIgB0AGUAeAB0AC0AYQBsAGkAZwBuACIAOgB7ACIAQgAiADoAIgBjAGUAbgB0AGUAcgAiAH0ALAAiAGMAbwBsAG8AcgAiADoAewAiAEIAIgA6ACIAIwAwADAAMAAwADAAMAAiAH0AfQB9ACwAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADEAMwB9ACwAewAiAEEAPwAiADoAIgBBACIALAAiAEEAIgA6AHsAIgBmAG8AbgB0AC0AdwBlAGkAZwBoAHQAIgA6AHsAIgBCACIAOgAiAGIAbwBsAGQAIgB9AH0AfQAsAHsAIgBBAD8AIgA6ACIAQgAiACwAIgBBACIAOgAxADUAfQAsAHsAIgBBAD8AIgA6ACIAQQAiACwAIgBBACIAOgB7ACIAZgBvAG4AdAAtAHcAZQBpAGcAaAB0ACIAOgB7ACIAQgAiADoAIgBuAG8AcgBtAGEAbAAiAH0AfQB9ACwAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADEAMwAwAH0ALAB7ACIAQQA/ACIAOgAiAEEAIgAsACIAQQAiADoAewAiAHQAZQB4AHQALQBhAGwAaQBnAG4AIgA6AHsAfQB9AH0ALAB7ACIAQQA/ACIAOgAiAEIAIgAsACIAQQAiADoAMQA1ADgAOQB9ACwAewAiAEEAPwAiADoAIgBBACIALAAiAEEAIgA6AHsAIgB0AGUAeAB0AC0AYQBsAGkAZwBuACIAOgB7ACIAQgAiADoAIgBjAGUAbgB0AGUAcgAiAH0AfQB9ACwAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADEAfQAsAHsAIgBBAD8AIgA6ACIAQQAiACwAIgBBACIAOgB7ACIAZgBvAG4AdAAtAHMAaQB6AGUAIgA6AHsAfQAsACIAZgBvAG4AdAAtAGYAYQBtAGkAbAB5ACIAOgB7AH0ALAAiAGYAbwBuAHQALQB3AGUAaQBnAGgAdAAiADoAewB9ACwAIgBmAG8AbgB0AC0AcwB0AHkAbABlACIAOgB7AH0ALAAiAGMAbwBsAG8AcgAiADoAewB9ACwAIgB0AGUAeAB0AC0AYQBsAGkAZwBuACIAOgB7AH0AfQB9AF0AfQAsACIAYgAiADoAewAiAEEAIgA6AFsANgA5ACwANwA2ACwAMQAwAF0AfQAsACIAZAAiADoAIgBBACIALAAiAGcAIgA6AGYAYQBsAHMAZQAsACIAaAAiADoAIgBBACIAfQBdACwAIgBCACIAOgAyADQAOAAwACwAIgBDACIAOgAxADcANAA4AH0A" id="isPasted" fr-original-style="" style="box-sizing: border-box;"></span><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Are you a newly qualified homeopath/therapist or in your 1st year of business? Are you confused and overwhelmed, trying to build a thriving busy practice?</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Want to learn from someone who&rsquo;s been in your shoes just 5yrs ago? I was once where you are now, and I&#39;ve made expensive mistakes! You get to learn from these and my experience of building my thriving practice over 5 years! I will drown out the noise and BS, lead you by the hand and show you what to do. &nbsp;Get the basics right from the start so you don&#39;t make expensive mistakes (learn from my mistakes!) Small investment that will save you time and money in the long run Small intimate groups mean the advice is targeted to individuals, and each person has direct access to me Beginner to Boss is a 12 week online programme which gently takes you by the hand and cuts through the noise to teach you the basics of business.</p><span data-canva-clipboard="ewAiAGEAIgA6ADUALAAiAGgAIgA6ACIAdwB3AHcALgBjAGEAbgB2AGEALgBjAG8AbQAiACwAIgBjACIAOgAiAEQAQQBHAE4ARQBIAGEAMAA3ADAAdwAiACwAIgBpACIAOgAiAFEAVgAwAG4AMgBDAHQAawBXAFQAcABpAEQAQgA4AFEAOABlAFMAcgBtAEEAIgAsACIAYgAiADoAMQA3ADIAMgA5ADMAMgA2ADcANQA2ADIANgAsACIAQQA/ACIAOgAiAEIAIgAsACIAQQAiADoAWwB7ACIAQQAiADoAMQAxADcAMQAuADYAOQAwADMANwA5ADYAMgAyADEAOAAxACwAIgBCACIAOgA2ADcAMgAuADgANwAyADIAMQAxADQAOQA1ADQAOAA0ADkALAAiAEQAIgA6ADEAMAA0ADAALgA2ADgAOQA4ADYAOAA1ADYANAAxADEAOAA4ACwAIgBDACIAOgA0ADkAMQAuADkANAA2ADIANgA2ADQAMAAxADgAOQAyADcAMwAsACIAQQA/ACIAOgAiAEsAIgAsACIAYQAiADoAewAiAEEAIgA6AFsAewAiAEEAPwAiADoAIgBCACIALAAiAEEAIgA6ADkANgA1AH0ALAB7ACIAQQA/ACIAOgAiAEEAIgAsACIAQQAiADoAIgBXAGgAYQB0ABkgcwAgAGkAbgBjAGwAdQBkAGUAZAA/AFwAbgAtACAANgAgAHQAZQBhAGMAaABpAG4AZwAgAHMAZQBzAHMAaQBvAG4AcwAgACgAMQBoAHIAKQAgAGMAbwB2AGUAcgBpAG4AZwA6ACAAcwB5AHMAdABlAG0AcwAsACAAbQBhAHIAawBlAHQAaQBuAGcALAAgAGYAaQBuAGEAbgBjAGUAcwAgAGEAbgBkACAAYgBvAHUAbgBkAGEAcgBpAGUAcwBcAG4ALQAgADYAIABpAG0AcABsAGUAbQBlAG4AdABhAHQAaQBvAG4AIABzAGUAcwBzAGkAbwBuAHMAIAAoADEAaAByACkAIAB3AGgAZQByAGUAIAB5AG8AdQAgAGgAYQB2AGUAIABhACAAYwBoAGEAbgBjAGUAIAB0AG8AIABhAHMAawAgAG0AZQAgAHEAdQBlAHMAdABpAG8AbgBzACwAIABsAGUAYQByAG4AIABmAHIAbwBtACAAeQBvAHUAcgAgAHAAZQBlAHIAcwAsACAAZwBlAHQAIABhAGMAYwBvAHUAbgB0AGEAYgBpAGwAaQB0AHkAIABhAG4AZAAgAGMAbwBuAHMAbwBsAGkAZABhAHQAZQAgAHkAbwB1AHIAIABsAGUAYQByAG4AaQBuAGcALgBcAG4ALQAgAEEAbABsACAAcwBlAHMAcwBpAG8AbgBzACAAdABvACAAYgBlACAAcgBlAGMAbwByAGQAZQBkACAAYQBuAGQAIABhAGMAYwBlAHMAcwBpAGIAbABlACAAdABvACAAcABhAHIAdABpAGMAaQBwAGEAbgB0AHMALgBcAG4ALQAgAEEAYwBjAGUAcwBzACAAdABvACAAYQAgAHAAcgBpAHYAYQB0AGUAIABGAEIAIABnAHIAbwB1AHAAIAB3AGgAZQByAGUAIABJACAAdwBpAGwAbAAgAGIAZQAgAGwAaQB2AGUAIABlAGEAYwBoACAAdwBlAGUAawAgAHQAbwAgAGEAbgBzAHcAZQByACAAcQB1AGUAcwB0AGkAbwBuAHMAXABuAC0AIABNAGEAcwB0AGUAcgBtAGkAbgBkACAAdwBoAGkAYwBoACAAdwBpAGwAbAAgAG4AbwB0ACAAYgBlACAAdABoAGkAcwAgAGcAbwBvAGQAIAB2AGEAbAB1AGUAIABlAHYAZQByACAAYQBnAGEAaQBuAFwAbgAtACAAQQBjAGMAZQBzAHMAIAB0AG8AIABkAGkAcwBjAG8AdQBuAHQAZQBkACAAMQAyADEAIABtAGUAbgB0AG8AcgAgAHMAZQBzAHMAaQBvAG4AcwAgAGEAdAAgAGUAbgBkACAAbwBmACAAcAByAG8AZwByAGEAbQBtAGUALgAiAH0ALAB7ACIAQQA/ACIAOgAiAEIAIgAsACIAQQAiADoAMgA1ADkAfQAsAHsAIgBBAD8AIgA6ACIAQQAiACwAIgBBACIAOgAiAFwAbgAiAH0AXQAsACIAQgAiADoAWwB7ACIAQQA/ACIAOgAiAEEAIgAsACIAQQAiADoAewAiAGYAbwBuAHQALQBzAGkAegBlACIAOgB7ACIAQgAiADoAIgA0ADAALgAwACIAfQAsACIAZgBvAG4AdAAtAGYAYQBtAGkAbAB5ACIAOgB7ACIAQgAiADoAIgBZAEEARgBjAGYAcgBnAGwAcABWAEEALAAwACIAfQAsACIAZgBvAG4AdAAtAHcAZQBpAGcAaAB0ACIAOgB7ACIAQgAiADoAIgBuAG8AcgBtAGEAbAAiAH0ALAAiAGYAbwBuAHQALQBzAHQAeQBsAGUAIgA6AHsAIgBCACIAOgAiAG4AbwByAG0AYQBsACIAfQAsACIAdABlAHgAdAAtAGEAbABpAGcAbgAiADoAewAiAEIAIgA6ACIAYwBlAG4AdABlAHIAIgB9ACwAIgBjAG8AbABvAHIAIgA6AHsAIgBCACIAOgAiACMAMAAwADAAMAAwADAAIgB9AH0AfQAsAHsAIgBBAD8AIgA6ACIAQgAiACwAIgBBACIAOgAxADcANAAxAH0ALAB7ACIAQQA/ACIAOgAiAEEAIgAsACIAQQAiADoAewAiAGYAbwBuAHQALQBzAGkAegBlACIAOgB7AH0ALAAiAGYAbwBuAHQALQBmAGEAbQBpAGwAeQAiADoAewB9ACwAIgBmAG8AbgB0AC0AdwBlAGkAZwBoAHQAIgA6AHsAfQAsACIAZgBvAG4AdAAtAHMAdAB5AGwAZQAiADoAewB9ACwAIgB0AGUAeAB0AC0AYQBsAGkAZwBuACIAOgB7AH0ALAAiAGMAbwBsAG8AcgAiADoAewB9AH0AfQBdAH0ALAAiAGIAIgA6AHsAIgBBACIAOgBbADEANwAsADcAMQAsADEAMQAsADYAOAAsADYAOQAsADEANQAsADYAMgAsADcAMgAsADEAMAAsADUAOAAsADYANABdAH0ALAAiAGQAIgA6ACIAQQAiACwAIgBlACIAOgAxADIAOAA2AC4AMQA5ADYAMgA0ADMAOQA4ADEANwA5ADkANgAsACIAZgAiADoANgAwADgALAAiAGcAIgA6AGYAYQBsAHMAZQAsACIAaAAiADoAIgBBACIAfQBdACwAIgBCACIAOgAyADQAOAAwACwAIgBDACIAOgAxADcANAA4AH0A" id="isPasted" fr-original-style="" style="box-sizing: border-box;"></span><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">What&rsquo;s included?&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">- 6 teaching sessions (1hr) covering: systems, marketing, finances and boundaries&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">- 6 implementation sessions (1hr) where you have a chance to ask me questions, learn from your peers, get accountability and consolidate your learning.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">- All sessions to be recorded and accessible to participants.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">- Access to a private FB group where I will be live each week to answer questions&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">- Mastermind which will not be this good value ever again&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">- Access to discounted 121 mentor sessions at end of programme.</p>

Are you a newly qualified homeopath/therapist or in your 1st year of business? Are you confused and overwhelmed, trying to build a thriving busy practice?
Want to learn from someone who’s been in your shoes just 5yrs ago? I was once where you are now, and I've made expensive mistakes! You get to learn from these and my experience of building my thriving practice over 5 years! I will drown out the noise and BS, lead you by the hand and show you what to do. Get the basics right from the start so you don't make expensive mistakes (learn from my mistakes!) Small investment that will save you time and money in the long run Small intimate groups mean the advice is targeted to individuals, and each person has direct access to me Beginner to Boss is a 12 week online programme which gently takes you by the hand and cuts through the noise to teach you the basics of business.
What’s included? 
- 6 teaching sessions (1hr) covering: systems, marketing, finances and boundaries 
- 6 implementation sessions (1hr) where you have a chance to ask me questions, learn from your peers, get accountability and consolidate your learning. 
- All sessions to be recorded and accessible to participants. 
- Access to a private FB group where I will be live each week to answer questions 
- Mastermind which will not be this good value ever again 
- Access to discounted 121 mentor sessions at end of programme.

Homeopathic Harmony

As a qualified homeopath of 5yrs, I've put together a brilliant offer for newly-qualified homeopaths who know all about remedies but almost nothing about running a successful, busy homeopathy practice. 

Very limited spaces, and the last time it will be this cheap before prices go up. 

You'll get a mix of group learning and direct access to me (learning from my mistakes so you don't have to waste time and money on making the same!). 

Beginner to Boss

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Be it a career change, an exciting new hobby, perfecting existing skills or simply enhancing professional employment prospects&ndash; we help you unlock creativity through our industry aligned all-encompassing Graphic Design Course.</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">" Having done my level 1 and level 2 in graphic design, I felt that I still had gaps in my knowledge and I wasn&#39;t comfortable with what I knew. I signed up with Blue Sky Graphics and I am really glad I did. I am definitely better now than when I started and this is all thanks to my tutor and Blue Sky Graphics 🙂 "</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><section data-id="a1c66d1" data-element_type="section" data-settings='{"background_background":"classic"}' style="color: rgb(74, 74, 74); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(74, 74, 74);"><div data-id="a6cdb97" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="adfa4f2" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">A Comprehensive Advanced Course</strong></p></div><div data-id="8058df1" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The graphic design course is a structured academic and industry aligned advanced course suitable for complete beginners, intermediates or those wanting to improve their existing skill set. The graphic design course is comprehensive and through our teaching methodology is designed to train participants to become professional Graphic Designers. There is an emphasis on corporate illustration, composition, painting and logos as well as advertisement designs while focusing on vectors, lines, features, shapes, and spaces. All this will be integrated into how graphic elements are printed after they are processed in graphic design software for the purpose of visually illustrating emotions and messages.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">During the course you will be exposed to:&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">advertisements, magazines, newspapers, corporate graphic designs particular to company cultures and brand identity, stationery, letterheads, business cards, logos, books, packaging and much more.</strong></p></div><div data-id="68acc2a" data-element_type="widget" data-widget_type="image.default" fr-original-style="" style="box-sizing: border-box;"><img width="1024" height="692" alt="" data-srcset="https://blueskygraphics.co.uk/wp-content/uploads/2022/12/Student-work-123456-1024x692.webp 1024w, https://blueskygraphics.co.uk/wp-content/uploads/2022/12/Student-work-123456-300x203.webp 300w, https://blueskygraphics.co.uk/wp-content/uploads/2022/12/Student-work-123456-768x519.webp 768w, https://blueskygraphics.co.uk/wp-content/uploads/2022/12/Student-work-123456.webp 1440w" data-src="https://blueskygraphics.co.uk/wp-content/uploads/2022/12/Student-work-123456-1024x692.webp" data-sizes="(max-width: 1024px) 100vw, 1024px" src="https://blueskygraphics.co.uk/wp-content/uploads/2022/12/Student-work-123456-1024x692.webp" sizes="(max-width: 1024px) 100vw, 1024px" srcset="https://blueskygraphics.co.uk/wp-content/uploads/2022/12/Student-work-123456-1024x692.webp 1024w, https://blueskygraphics.co.uk/wp-content/uploads/2022/12/Student-work-123456-300x203.webp 300w, https://blueskygraphics.co.uk/wp-content/uploads/2022/12/Student-work-123456-768x519.webp 768w, https://blueskygraphics.co.uk/wp-content/uploads/2022/12/Student-work-123456.webp 1440w" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"></div><div data-id="e3de655" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The graphic design course teaches you to understand and learn how to operate a labyrinthine yet amazing world of Adobe software. With this software we explore the uses of words, shapes, textures, forms, sizes and colours to communicate by combining ideas and images to make a new concept. Graphic design through common misconception is not just about layout and typography, but much more about ideas behind visual meaning. Graphic design can make a company more successful in the world if it makes communication smart, attractive and able to captivate its audience. Graphic design can effectively be used by businesses to make (or break) their brand identity, increase sales, promote web traffic or promote services and products through advertising on their websites to convey complex data to its readers in a clear way.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Elements of graphic design include:&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Colour, Size, Texture, Line, Shape, Space and, Form</strong>. It is important that each element is understood correctly, and this is one of the key principles we teach on our graphic design course. In other terms, graphic design communicates certain ideas or messages through visuals. These visuals can be as simple as a business logo, or as complex as pages of web design. This course goes beyond just the practical side of graphic design and includes the theory and substance behind modern graphic design.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Your teacher will guide you on:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">What salary you can expect at the start of your career?<br fr-original-style="" style="box-sizing: border-box;">How to get new clients for your business for freelance designers ?<br fr-original-style="" style="box-sizing: border-box;">How to find work for the new graphic designer starting out in the big world?<br fr-original-style="" style="box-sizing: border-box;">How to quickly integrate into the graphic design field?<br fr-original-style="" style="box-sizing: border-box;">How to combine working from home versus working at a studio ?</p></div><div data-id="9eeb2d6" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></div></div></section><section data-id="9dd6ca4" data-element_type="section" data-settings='{"background_background":"classic"}' style="color: rgb(74, 74, 74); box-sizing: border-box;" fr-original-style=" color: rgb(74, 74, 74);"><div data-id="c7b1c39" data-element_type="column" data-settings='{"background_background":"classic"}' fr-original-style="" style="box-sizing: border-box;"><div data-id="d1226d1" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 style="color: rgb(44, 132, 238); box-sizing: border-box;" fr-original-style=" color: rgb(44, 132, 238);">Begin one-to-one online learning with your very own private tutor</h2></div></div></section><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><img src="https://images.cademy.co.uk/0832ed64-c289-46fe-8a61-ae4fb9d9c688/14e85caa-6eee-4593-8ec3-48bdfc839153/original.webp" style="width: 698px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 698px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto;" fr-original-class="fr-draggable"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"></p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"></p><div data-id="833cc17" data-element_type="widget" data-widget_type="heading.default" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><div data-id="833cc17" data-element_type="widget" data-widget_type="heading.default" style="color: rgb(74, 74, 74); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(74, 74, 74);"><h2 style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);">Interested?</h2></div><div data-id="63ead7e" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(12, 12, 12); box-sizing: border-box;" fr-original-style=" color: rgb(12, 12, 12);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our course is 7 months long, consisting of 1 hour 30 minutes of online one-to-one sessions. When you enrol at Blue Sky Graphics expect at least 90 minutes of class sessions and 2 &ndash; 4 hours of homework per week.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">If we accommodate the course delivery into a shorter time frame, (for e.g. over 4 months instead of 7 months the Flexi 3 doubles from &pound;265.00 to &pound;450.00 over 4 months) the instalment is billed at the delivery rate.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The cost of traditional schooling is typically more expensive than online courses, but in the end it all comes down to how good the tutors are. With our online courses you can gain skills that are a necessity for graphic design remotely.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">That&rsquo;s right! Learn the skills needed to use Photoshop, Illustrator, InDesign and portfolio!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The online courses cost &pound;1799.00 (VAT inclusive) with no extra hidden costs and there are affordable instalment options too. Pay via debit or credit card or use a payment plan. A deposit of &pound;294.00 is required to secure your position.</p></div></div><div data-id="63ead7e" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(12, 12, 12); box-sizing: border-box;" fr-original-style=" color: rgb(12, 12, 12);"><br fr-original-style="" style="box-sizing: border-box;"></div>

Graphic Design Courses Birmingham

Graphic Design

GRAPHIC DESIGN COURSE

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><img src="https://images.cademy.co.uk/art-by-purnima/1f946b6c-ddfc-4430-8148-ab1d607d7f51/original.jpeg" style="width: 167px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 167px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto;" fr-original-class="fr-draggable">For all my amazing reviews please click the link below:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a data-fr-linked="true" href="https://www.craftcourses.com/providers/art-by-purnima/reviews" id="isPasted" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">https://www.craftcourses.com/providers/art-by-purnima/reviews</a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This 4-week Online Course is suitable for complete beginners and improvers who would like to learn to paint in Watercolour.<br fr-original-style="" style="box-sizing: border-box;">Each session is 40 minutes and starts at 10.00-10.40 am<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* You will learn to prepare your watercolour paints and mix colours.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* You will learn a variety of watercolour techniques including, washes, wet in wet, graded, dry brush Flat Wash, and Loose watercolours see photos.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">*You will be taught live by your tutor online with step-by-step demonstrations and clear explanations of the various stages.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* Learners will then carry the various tasks alongside the tutor who will be at hand for any questions that you may have.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">This is a 4 week course offered live online via zoom and the course is ongoing so you can join at any time.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-class="cancellation-policy">Cancellation and a full refund can be obtained up to 2 weeks before the course starts. Start dates may be amended on request.</p>
<h2 fr-original-style="" style="box-sizing: border-box;">What&#39;s included in the price?</h2>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Online Tuition<br fr-original-style="" style="box-sizing: border-box;">Step by step Demonstrations via Zoom in the live class<br fr-original-style="" style="box-sizing: border-box;">Clear explanation from your Tutor<br fr-original-style="" style="box-sizing: border-box;">Reference handouts sent via email</p>
<h2 fr-original-style="" style="box-sizing: border-box;">What you will need</h2>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Start Kit Available from Tutor please email for details<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">Watercolour paints - tubes or pans<br fr-original-style="" style="box-sizing: border-box;">Watercolour paper ( Cold Pressed 300 gsm 140lb)<br fr-original-style="" style="box-sizing: border-box;">Round watercolour brushes- size 4 and 6 ( or similar)<br fr-original-style="" style="box-sizing: border-box;">HB graphite pencil to draw image<br fr-original-style="" style="box-sizing: border-box;">Eraser<br fr-original-style="" style="box-sizing: border-box;">Mixing Palette<br fr-original-style="" style="box-sizing: border-box;">2 x jars of clean water<br fr-original-style="" style="box-sizing: border-box;">Kitchen paper<br fr-original-style="" style="box-sizing: border-box;">Hairdryer<br fr-original-style="" style="box-sizing: border-box;">Sketchbook<br fr-original-style="" style="box-sizing: border-box;">Tracing paper</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p>

Art By Purnima

Watercolour Painting

Watercolour for All 4 week Online Course Monday Morning Via Zoom

Southend on Sea

Droitwich Spa

Portsmouth

Rotherham

Manchester

Leeds

Slough

Bingley

Newport

Peterborough

Milton Keynes 

Nottingham

Paisley

Birmingham

Luton

Hull

Northampton

Bedford

Liverpool 

Swansea

BASIC to ADVANCED COURSE PACKAGE

Complete 3 courses over 2 full days and receive three qualifications:

Introduction to Phlebotomy Certificate (Nationally Recognised Level 3, Ireland Level 5)
Days 1 and 2: 9.30am – 5.00pm

Advanced Phlebotomy Certificate (Nationally Recognised Level 4, Ireland Level 6)
Day 1: 5.30pm - 8.30pm

Geopace Certificate of Competency (Nationally Recognised Accredited, CPD Practical Skills)
Day 2: 5.30pm - 8.30pm

Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.






Key Facts & Summary:


COURSE 1: INTRODUCTION TO PHLEBOTOMY COURSE - NATIONALLY RECOGNISED AND ACCREDITED VENEPUCTURE COURSE
UK Level Three (Ireland Level Five)
DUALLY ACCREDITED - Open College Network (OCN) and The CPD Certification Service (21 CPD Points)

PART 1 (DAY 1) - 9.30am to 5.00pm
PART 2 (DAY 2) - 9.30am to 5.00pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

A TWO DAY venepuncture course at Level 3. Trains up to the point of live blood draws.

On completion awards a Nationally Recognised and Accredited Certificate in Phlebotomy.

DAY ONE (PART 1) - THEORY
Attend the course location of your choice – starts at 9.30am and finishes approx. 5.00pm

DAY TWO (PART 2) - CLASSROOM
Your classroom tutor will recap on the theory element (above) after which you will begin your practical sessions learning and developing the skills required up to the point of Live Blood Draws.

DOWNLOAD A COURSE ITINERARY HERE



COURSE 2: ADVANCED PHLEBOTOMY COURSE - NATIONALLY RECOGNISED AND ACCREDITED VENEPUCTURE COURSE
UK Level Four (Ireland Level 6)
DUALLY ACCREDITED - Open College Network (OCN) and The CPD Certification Service (14 CPD Points)

PART 1 - THEORY
Complete your theory training online in the comfort of your own home or at work.

PART 2 - CLASSROOM
Follow on from your Day One Theory training, in the evening, from 5.30pm - 8.30pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

Skills and Practical Development:
Covers advanced specialised phlebotomy techniques to give you the leading edge as a phlebotomist. Learn to use a wide range of non-routine equipment.

On completion awards a Nationally Recognised and Accredited Certificate in Advanced Phlebotomy.

DOWNLOAD A COURSE ITINERARY HERE



COURSE 3: ROUTE TO COMPETENCY MASTERCLASS
CPD ACCREDITED - The CPD Certification Service

CLASSROOM
Follow on from your Day Two practical training, in the evening, from 5.30pm - 8.30pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

GEOPACE LIVE BLOOD SESSIONS enabling you to draw human blood under 1-to-1 supervision of your tutor. You will follow a Competency Checklist, signed off by your tutor on completion.

On completion awards a Geopace Certificate of Competency - Nationally Recognised and Accredited Route to Competency - Live Blood Draws Certificate

DOWNLOAD A COURSE ITINERARY HERE




How do I attend?

EITHER -
CLASSROOM OPTION - Attend one of our scheduled classroom locations, completing your Introduction to Phlebotomy Course over 2 days. You will also complete your Advanced Training at the end of the first day and your Competency Training at the end of the second day.

Our Introduction to Phlebotomy and Advanced Phlebotomy Training Kits are supplied at no charge when booking our virtual classroom training option.
If you would like to add one or both of these kits to your classroom training option then these are available to add at time of booking. Our comprehensive training kits each mirror the same equipment and supplies used in the classroom and both include detailed video tutorials, allowing you to continue to practice and "hone" your skills after you have completed your practical training.

OR -

VIRTUAL CLASSROOM OPTION- Complete your theory training online at home or work, then join us for a one day Zoom session to complete your Introduction to Phlebotomy virtual classroom training, followed by your Advanced Training in the evening of the same day. You have the option to add a classroom-based competency session, awarding a CPD Accredited Geopace Certificate of Competency, at time of booking.

Our Virtual Classroom option includes two very comprehensive training kits - one for your introductory course and one for your advanced course. Kits are included at no charge (normally £79.95 each) and are yours to keep and to continue to practice with after you have finished your courses. The equipment and supplies included in your kits are the same as those used if you choose the classroom option.

How do I book?

Choose whether you would like to attend in a classroom or if you would like to complete your training by virtual classroom.
Click on the Classroom - Booking Options or Virtual Classroom - Booking Options buttons below to see all upcoming dates and locations.

Please note - Competency Training
Our Route to Competency Masterclass - Live Blood Sessions can only be completed in a classroom environment. This is included when you book a classroom option. When booking the virtual classroom option you can choose to add this at time of booking. You will receive a voucher code to enable you to book onto any upcoming dates or locations. For most of our two day course we run our competency training at the end of the second day and therefore you should be able to complete your full training programme with us over two days.

If you are completing your training by virtual classroom please see our list of competency training locations here.

If you would like to "mix and match" your training dates and/or locations then please call our admin team on 01525 713377 who will be more than happy to put a training package together for you on dates and / or locations that suit you.

All courses are accredited and are Skills for Health & WHO compliant.

Geopace Training

Allied Health

Allied Health Professions (AHP)

Blood Taking

Healthcare Workers

Venepuncture

Phlebotomist

Phlebotomy

Accredited Phlebotomy

Healthcare

THIS COURSE PACKAGE INCLUDES:
1: INTRODUCTION TO PHLEBOTOMY COURSE (GPT003) - Level 3 (Ireland Level 5)
2: ADVANCED PHLEBOTOMY COURSE (GPT005) - Level 4 (Ireland Level 6)
3: GEOPACE COMPETENCY CERTIFICATE - CPD Certified (optional with Virtual Classroom)

Learn how to take blood ... train as a Phlebotomist

FAST-TRACK YOUR PHLEBOTOMY TRAINING

WITH OUR

COMPLETE TRAINING PACKAGE

20% off -  Multi-Course Discount

    Cover all stages from beginner through to Level 4

    Available as Classroom or Virtual Classroom

    Complete your beginner to advanced training in 2 days

    Awards 2 accredited qualifications - Introduction to Phlebotomy and Advanced Phlebotomy qualifications

    Both courses are dually accredited (OCN & CPD)

    Geopace Certificate of Competency included with classroom attendance or available as an option when booking virtual classroom

    Covers all steps up to live blood draw

    Learn advanced skills and techniques

    Virtual Classroom options include comprehensive Practise@Home Training Kits (yours to keep)

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Phlebotomy Training - Beginner to Advanced PACKAGE

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This 4 week online Course is suitable for complete beginners and improvers who would like to learn to paint in Watercolour.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">Each session is 40 minutes live on Tuesday evening and start at 7.00-7.40pm Via Zoom<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">On this Course you will:<br fr-original-style="" style="box-sizing: border-box;">* learn to prepare your water colour paints and mix colours.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* learn a variety of watercolour techniques including, washes, wet in wet, graded, dry brush Flat Wash, Loose watercolour see photos, we will cover a variety of subjects.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* will be taught live by your tutor online via zoom with step- by -step demonstrations and clear explanations of the various stages.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* Learners will then carry the various tasks alongside the tutor who will be at hand for any questions that you may have.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">This is a 4 week course offered live online via zoom this course rolls on and new dates will be added.</p>
<h2 fr-original-style="" style="box-sizing: border-box;">What&#39;s included in the price?</h2>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Online Tuition<br fr-original-style="" style="box-sizing: border-box;">Step by step Demonstrations via Zoom in the live class<br fr-original-style="" style="box-sizing: border-box;">Clear explanation from your Tutor<br fr-original-style="" style="box-sizing: border-box;">reference handouts sent via email</p>
<h2 fr-original-style="" style="box-sizing: border-box;">What you will need</h2>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Starter Kit Available from Tutor - Please email for details<br fr-original-style="" style="box-sizing: border-box;">Watercolour paints - tubes or pans<br fr-original-style="" style="box-sizing: border-box;">Watercolour paper ( Cold Pressed 300 gsm 140lb)<br fr-original-style="" style="box-sizing: border-box;">Round watercolour brushes- size 4 and 6 ( or similar)<br fr-original-style="" style="box-sizing: border-box;">HB graphite pencil to draw image<br fr-original-style="" style="box-sizing: border-box;">Eraser<br fr-original-style="" style="box-sizing: border-box;">Mixing Palette<br fr-original-style="" style="box-sizing: border-box;">2 x jars of clean water<br fr-original-style="" style="box-sizing: border-box;">Kitchen paper<br fr-original-style="" style="box-sizing: border-box;">Hairdryer<br fr-original-style="" style="box-sizing: border-box;">Sketchbook<br fr-original-style="" style="box-sizing: border-box;">Tracing paper</p>
<h2 fr-original-style="" style="box-sizing: border-box;">Suitable for</h2>
<ul fr-original-style="" fr-original-class="fa-ul course-checklists" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Adults</li>
<li fr-original-style="" style="box-sizing: border-box;">Engagement, birthdays &amp; anniversaries</li>
<li fr-original-style="" style="box-sizing: border-box;">Intermediate level</li>
<li fr-original-style="" style="box-sizing: border-box;">Seniors</li>
<li fr-original-style="" style="box-sizing: border-box;">Suitable for beginners</li>
<li fr-original-style="" style="box-sizing: border-box;">Teenagers</li>
<li fr-original-style="" style="box-sizing: border-box;">Wheelchair users</li>
</ul>

Watercolour Techniques for All - 4 week Online Course Tuesday Evenings Via Zoom

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyT25lJTIwaG91ciUyMHdlYmluYXIlMjB0byUyMGhlbHAlMjBwcmVwYXJlJTIwcmFsbHklMjBjb21wZXRpdG9ycyUyMGZvciUyMHRoZSUyMHRyYW5zaXRpb24lMjB0byUyMHdyaXRpbmclMjB5b3VyJTIwb3duJTIwcGFjZW5vdGVzLiUyMENvdmVyaW5nJTIwZXF1aXBtZW50JTIwbmVlZGVkJTJDJTIwaG93JTIwdG8lMjBwcmVwYXJlJTJDJTIwaG93JTIwdG8lMjBwcmFjdGljZSUyMGFuZCUyMGElMjBxdWljayUyMG92ZXJ2aWV3JTIwb2YlMjBFYXN5d3JpdGUlMjBTdGVlcmluZyUyMFdoZWVsJTIwQ292ZXIuJTIwV2hhdCUyMG1ha2VzJTIwZ29vZCUyMHBhY2Vub3RlcyUyMC0lMjBmaW5kJTIwb3V0JTJDJTIwaXQlMjBjb3VsZCUyMGJlJTIwdGhlJTIwbW9zdCUyMGNvc3QlMjBlZmZlY3RpdmUlMjBwZXJmb3JtYW5jZSUyMGFkdmFudGFnZSUyMGF2YWlsYWJsZS4lMjBBbGwlMjBhdHRlbmRlZXMlMjB3aWxsJTIwcmVjZWl2ZSUyMGElMjAxMCUyNSUyMG9mZiUyMEVhc3l3cml0ZSUyMHByb2R1Y3RzJTIwZnJvbSUyMFJhbGx5JTIwTmF2aWdhdGlvbiUyMFRyYWluaW5nJTIwU2VydmljZXMuJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlNUQlN0Q=" id="isPasted" fr-original-style="" style="box-sizing: border-box;">One hour webinar to help prepare rally competitors for the transition to writing your own pace notes. Covering equipment needed, how to prepare, how to practice and a quick overview of Easywrite Steering Wheel Cover. What makes good pace notes - find out, it could be the most cost effective performance advantage available. All attendees will receive a 10% off Easywrite products from Rally Navigation Training Services.</span>

</p>

One hour webinar to help prepare rally competitors for the transition to writing your own pace notes. Covering equipment needed, how to prepare, how to practice and a quick overview of Easywrite Steering Wheel Cover. What makes good pace notes - find out, it could be the most cost effective performance advantage available. All attendees will receive a 10% off Easywrite products from Rally Navigation Training Services. 

Rally Navigation Training Services

Sports & Fitness

Rally training webinar covering making pace notes for special stage rallying.

Rally Pacenote Writing for Beginners

Brighton

ONLINE STUDY - In your own time (approx. 6 hours study time) +
CLASSROOM SESSION - Morning, Afternoon or Evening session (approx. 3 hours)



Awarding Body: Open College Network (OCN) Credit for Learning
Award Level: Level 4 (Foundation Degree Level) - Ireland Level 6
CPD Certified: Yes (CPD Accreditation)
Minimum Age: 18 (16 with parental consent)
Entry requirements: None. (English Level 2 desirable)
Training Locations: Study online + Classroom
 
OCN Accredited at UK Level 4 (Ireland Level 6)

 
PART 1 - Theory: Complete this part of your course online at home or work in your own time (stop and start learning when it suits you). Can be completed on multiple devices - smart phones, kindle, laptop, tablet etc.

PART 2 - Skills and Practical Development:
Covers advanced specialised phlebotomy techniques to give you the leading edge as a phlebotomist. Learn to use a wide range of non-routine equipment.


Attend a classroom location to complete your practical training.


Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.


Course Itinerary:
PART 1 - THEORY (ONLINE)
M00 - Introduction:
Learning outcomes, Assumptions and Overview.
M01 - Basic Phlebotomy - revision:
Recap of basic phlebotomy theory and practice - precursor to
the advanced course.
M02 - Aspirated and Vacuated Systems:
Open systems (Syringe & Needle), closed systems (Vacutainer & Monovette), Alternative closed systems, Using Monovette - aspiration and evacuated techniques, monovette adapter systems.
M03 - Specialised and Advanced Phlebotomy Equipment:
The centrifuge - overview. Safe operation and use. Managing a centrifuge breakage or spillage.
Equipment and practices in unusual situations.
Patients with special needs and requiring specific attention.
Equipment preparation for blood samples that are collected at
0 degrees, 37 degrees C and other non-standard conditions.
A look at advances in technology and how to use the latest devices.
M04 - Point of Care Testing:
What is POC Testing? Advantages, Disadvantages and Clinical
Outcomes. Comparison of POC with lab testing. 10 common POC tests. Roles for phlebotomists performing POC Tests.
M05 - Neonates and Children:
Sample collection from new-born to pre-adult. A detailed overview of legal principles of law including child consent and child protection for phlebotomists. Neonatal and child blood collection equipment.
A comprehensive look at heel and finger-prick procedures including
microtainers, lancets and capillary tube collection. Detailed heel prick procedure. Paediatric finger prick collection. The life-threatening hazard of over-collecting. Communication techniques in differing age bands.
Consent and the law. Basic principles of lawful consent for neonates and paediatric patients. Child protection.
Detailed analysis of neonatal and paediatric blood collection including Guthrie card collection. Neonatal bottles - colours and tests. Paediatric blood gases collection.
Butterfly needles - when to use. Blood tests during pregnancy. Neonatal blood screening - nine conditions covered. Bilirubin in neonates.
M06 - Geriatric Patients:
The challenges of phlebotomy in older people. Understanding skin changes and venepuncture implications. A profile of common
geriatric blood tests. Age related problems. Procedural precautions.
M07 - Special Procedures:
Drawing blood from back of hand. Drawing blood from lower limb veins. Managing the unwilling or difficult patient. Managing the psychiatric patient. Managing the isolated patient. Non-routine blood tests. Managing the latex allergy patient (type 1 and type 4 reactions). Latex indicators. Sample handling - non-routine procedures. Drug trials and research projects.
M08 - Special Tests and Sample Handling Procedures:
A look at sample collection at specific times of day and night,
samples that are protected from light, collected on ice and
collected at body temperature. Procedures for each group - collection notes, analytic time, optimal collection time and notes for each group.
M09 - Advanced Phlebotomy Tasks:
Additional procedures. Maintaining POC equipment. Stock control and stock rotation. Quality control. Data entry. Product evaluation. Training and competency evaluation.
M10 - Alternative Environments:
A step-by-step look at non-clinical phlebotomy environments including private testing, DEFRA, forensic and police, cord blood collection, DNA analysis, veterinary services, overseas and volunteering.

PLEASE NOTE THAT PART 1 SHOULD BE COMPLETED
BEFORE JOINING US FOR YOUR PRACTICAL TRAINING

PART 2 (CLASSROOM)
MORNING , AFTERNOON OR EVENING SESSION:

1 - Welcome, introductions and overview:
- Classroom - health & safety briefing, schedule overview.
- Virtual Classroom - audio/visual checks and registration. Unpacking and overview of your training kit.
2 - Syringe and Needle (open system): Correct use and applications.
3 - Monovette (open and closed systems):
Using the Monovette system in aspiration mode - correct use and applications.
Using the Monovette system in evacuated mode - correct use and applications.
4 - IR Vein Detector:
Demonstration of the IR vein detector for assisting in detection of difficult veins.
5 - Veins in back of hand:
Detecting suitable veins in the back of the hand.
6 - POC testing:
Point of Care Testing - use of glucose meter to demonstrate a typical POC test procedure. Correct use and overview of other POC test devices.
7 - Using lancets (finger collection)
We look at the correct use of lancets for POC testing and whole blood micro-collection.
8 - Using lancets (heel collection)
We look at the correct use of lancets for neonatal blood spot tests (Guthrie Test).
9 - Capillary collection
Using glass capillary tubes for micro-collection. Correct use and handling.
10 - Microtube collection
Correct use of BD Microtainers (and similar micro-collection bottles) - collection and handling.

This course is supported with downloadable resources and may include extra video segments to reinforce your practical training.
 
(THE COURSE DELIVERY AWARDS SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR VIRTUAL CLASSROOM COURSE VERSION)



The UK's first and only Level 4 qualification in Phlebotomy (equivalent to Ireland Level 6)

    FDSc (Foundation Degree Level) qualification

    Nationally Recognised certificate

    Dually accredited: Open College Network  and CPD

    Covers both aspirated and evacuated systems

    Covers specialised blood collection systems & methods

    Classroom or Virtual Classroom learning options

    Comprehensive Training Kit is provided when booking our Virtual Classroom option (yours to keep)

    Complete your training from beginner to advanced level

    This course either follows on from our Introduction to Phlebotomy Course  or can be combined with our introductory course as part of a course package (see below)

    Available to candidates who have completed (or are currently enrolled to complete) our Introduction to Phlebotomy Course or have previous phlebotomy practical experience.


Advanced Phlebotomy - Skills & Techniques (GPT005)

Actors Studio

Screen Acting Weekly with Showreel

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">FREE Webinar: What Video Editing Software Is Best For You?</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Are you curious about all the editing software options available? Join our free webinar, "What Video Editing Software is Best For You?", and discover which platform will suit your needs. Whether you&#39;re a beginner or a seasoned professional, this session will guide you through the pros and cons of popular editing programs, helping you make an informed decision.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What You&#39;ll Learn:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">- Comprehensive comparison of the different platforms available from FREE to EXPENSIVE</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">- Key features and benefits of each program</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">- Tips on selecting the right software for your specific projects</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">- Live Q&amp;A session to address your unique questions</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Don&#39;t miss this opportunity to streamline your workflow and enhance your editing skills. Register now and take the first step towards finding your ideal editing software!</p>

FREE Webinar: What Video Editing Software Is Best For You?
Are you curious about all the editing software options available? Join our free webinar, "What Video Editing Software is Best For You?", and discover which platform will suit your needs. Whether you're a beginner or a seasoned professional, this session will guide you through the pros and cons of popular editing programs, helping you make an informed decision.
What You'll Learn:
- Comprehensive comparison of the different platforms available from FREE to EXPENSIVE
- Key features and benefits of each program
- Tips on selecting the right software for your specific projects
- Live Q&A session to address your unique questions
Don't miss this opportunity to streamline your workflow and enhance your editing skills. Register now and take the first step towards finding your ideal editing software!

Clockwork Eye Video Training

Photography & Video

Video

Video Marketing

Video Creation

Mobile Video Production

Film & Video

Videography

Presentation Skills

Video Production

Video Editing

Video & Mobile Marketing

Join our free webinar, "What Video Editing Software is Best For You?", to explore and compare top editing programs, find the best fit for your needs, and enhance your editing skills with expert guidance and live Q&A.

Video Editing Software Guide (Free Webinar)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">One hour webinar aimed at relative newcomers to road rallying, learn the basics of plotting map references, map reading, types of controls and timing.</p>

One hour webinar aimed at relative newcomers to road rallying, learn the basics of plotting map references, map reading, types of controls and timing.

Online webinar aimed at newcomers and beginners to road rallying helping to learn the basics.

59 Courses in Liverpool

Microsoft Project Introduction - In-company

By Microsoft Office Training

Microsoft Powerpoint Advanced - In-company (now with live online classes)

By Microsoft Office Training

Microsoft Word Introduction - In-company (now with live online classes)

By Microsoft Office Training

Microsoft Excel Intermediate - In-company

By Microsoft Office Training

Microsoft Powerpoint Introduction - In-company (now with live online classes)

By Microsoft Office Training

Microsoft Excel Macros & VBA - In-company

By Microsoft Office Training

Microsoft Excel Advanced - In-company

By Microsoft Office Training

Microsoft Power BI Desktop In-company (now with live online classes)

By Microsoft Office Training

Heat Engineer Software In Depth

By Rob Berridge Heating Design Consultants

Microsoft Access Advanced - In-company / Bespoke

By Microsoft Office Training

Search By Location