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 common objects of an Access database</li><li>Design and build the structure of a database</li><li>Input and maintain data</li><li>Design user-friendly data entry forms</li><li>Search the database using queries</li><li>Generate reports from your data</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<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>Introducing Microsoft Access</strong></p> <ul> <li>The Access interface</li></ul> <p><strong>Database terminology</strong></p> <ul> <li>Access database objects</li><li>Fields and records</li><li>Properties</li></ul> <p><strong>Designing a database</strong></p> <ul> <li>Planning and designing a table</li><li>Creating fields</li><li>Setting common field properties</li><li>Defining key fields</li></ul> <p><strong>Working with table data</strong></p> <ul> <li>Entering and editing data</li><li>Sorting and filtering table records</li><li>Deleting records</li></ul> <p><strong>Relationships</strong></p> <ul> <li>Why use table relationships?</li><li>Relationship types</li><li>Referential Integrity</li><li>Working with table subdatasheets</li></ul> <p><strong>Querying a database</strong></p> <ul> <li>Creating simple Select Queries</li><li>Specifying query criteria</li><li>Sorting query results</li><li>Adding calculated fields</li></ul> <p><strong>Designing Forms</strong></p> <ul> <li>Creating simple forms for data entry</li><li>Designing custom forms</li><li>Working with form sections</li><li>Creating sub forms</li></ul> <p><strong>Designing Reports</strong></p> <ul> <li>Creating basic list reports</li><li>Working with grouping and sorting in a report</li><li>Adding totals to a report</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 the user that wants to explore the creation of a relational database. It will focus on the structuring of the database itself and the creation of the basic functional elements of a database in order to manage data.</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 Access Introduction  - In-company (now with live online classes)

General Admission

<p><strong>Course Objectives</strong></p> <p>At the end of this course you will be able to:</p> <ul> <li>Collaborate on documents</li><li>Add reference marks and notes</li><li>Make long documents easier to use</li><li>Secure a document</li><li>Work with forms</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><strong>Collaborating on Documents</strong></p> <ul> <li>Modify User Information</li><li>Share a Document</li><li>Compare Document Changes</li><li>Review a Document</li><li>Merge Document Changes</li><li>Review Tracked Changes</li><li>Coauthor Documents</li></ul> <p><strong>Adding Reference Marks and Notes</strong></p> <ul> <li>Add Captions</li><li>Add Cross-References</li><li>Add Bookmarks</li><li>Add Hyperlinks</li><li>Insert Footnotes and Endnotes</li><li>Add Citations and a Bibliography</li></ul> <p><strong>Simplifying and Managing Long Documents</strong></p> <ul> <li>Insert Blank and Cover Pages</li><li>Insert an Index</li><li>Insert a Table of Contents</li><li>Insert an Ancillary Table</li><li>Manage Outlines</li><li>Create a Master Document</li></ul> <p><strong>Securing a Document</strong></p> <ul> <li>Suppress Information</li><li>Set Formatting and Editing Restrictions</li><li>Add a Digital Signature to a Document</li><li>Restrict Document Access</li></ul> <p><strong>Forms</strong></p> <ul> <li>Create Forms</li><li>Manipulate Forms</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 users who would like to create and work with lengthy and well structured documents, collaborate with others on documents, and create forms in Microsoft Word</p> 
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Preferably, delegates should have attended the Word Intermediate 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 Word 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>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>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>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)

<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 </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> classrom, one to one, tailored and bespoke courses.</strong></p><p><strong><strong>Tailored In Company training:</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

<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> classroom, one to one, tailored and bespoke courses.</strong></p><p><strong><strong>Tailored In Company training:</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>
        
            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>

Microsoft Excel Macros & VBA - classroom

<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> classroom, one to one, tailored and bespoke courses.</strong></p><p><strong><strong>Tailored In Company training:</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>
        
            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 Macros & VBA - Online  classroom

<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

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>The primary audience for this course is any IT, facilities or data centre professional who works in and around the data centre and who has the responsibility to achieve and improve the availability and manageability of the data centre.</p>Overview<p>After completion of the course the participant will be able to:? Choose an optimum site for mission-critical data centre based on current and future needs? Describe all components that are important for high availability in a data centre and how to effectively setup the data centre? Name and apply the various industry standards? Describe the various technologies for UPS, fire suppression, cooling, monitoring systems, cabling standards, etc, and to select and apply them effectively to cost-efficiently enhance the high-availability of the data centre.? Review the electrical distribution system to avoid costly downtime? Enhance cooling capabilities and efficiency in the data centre by using existing and new techniques and technologies for the increased cooling requirements of the future? Design a highly reliable and scalable network architecture and learn how to ensure installers apply proper testing techniques? Create effective maintenance contracts with equipment suppliers ensuring the best return on investment? Setup effective data centre monitoring ensuring the right people get the right message? Ensure proper security measures, both procedural and technical, are established to safeguard your company's valuable information in the data centre</p><p>The course will address how to setup and improve key aspects such as power, cooling, security, cabling, safety, etc., to ensure a high available data centre. It will also address key operations and maintenance aspects.</p></div><div id="course-pills-2"><h4>The Data Centre, it?s Importance and Causes for Downtime</h4><h4>Data Centre Standards and Best Practices</h4><h4>Data Centre Location, Building and Construction</h4><ul><li>Selecting appropriate sites and buildings and how to avoid pitfalls<br />Various components of an effective data centre and supporting facilities setup</li></ul><h4>Raised Floor/Suspended Ceiling</h4><ul><li>Uniform, concentrated and rolling load definitions<br />Applicable standards<br />Raised Floor guidelines<br />Signal Reference Grid, grounding of racks<br />Disability act and regulations<br />Suspended ceiling usage and requirements</li></ul><h4>Light</h4><ul><li>Standards<br />Light fixture types and placement<br />Emergency lighting, Emergency Power Supply (EPS)</li></ul><h4>Power Infrastructure</h4><ul><li>Power infrastructure layout from generation to rack level<br />ATS and STS systems<br />Redundancy levels and techniques<br />Three-phase and single-phase usage<br />Power distribution options within the computer room<br />Power cabling versus bus bar trunking<br />Bonding versus grounding<br />Common Mode Noise and isolation transformers<br />Distribution boards, form factors and IP-protection grades<br />Power quality guidelines<br />Real power versus apparent power<br />How to size and calculate load in the data centre Generators<br />Static and dynamic UPS systems, selection criteria, how they operate and energy efficiency option<br />Battery types, correct selection and testing<br />Thermo-graphics</li></ul><h4>Electro Magnetic Fields</h4><ul><li>Electrical fields and magnetic fields definitions and units of measurements<br />Sources of EMF<br />Effects of EMF on human health and equipment<br />(H)EMP<br />Standards<br />EMF shielding solutions</li></ul><h4>Equipment Racks</h4><ul><li>Rack standards, properties and selection criteria<br />Security considerations<br />Power rail/strip options</li></ul><h4>Cooling Infrastructure</h4><ul><li>Temperature and humidity recommendations<br />Cooling measurement units and conversion rates<br />Sensible and latent heat definitions<br />Differences between comfort and precision cooling<br />Overview of different air conditioner technologies<br />Raised floor versus non-raised floor cooling<br />Placement of air conditioner units and limitations to be observed<br />Supplemental cooling options<br />Cold aisle/hot aisle containment</li></ul><h4>Water Supply</h4><ul><li>Importance of water supply and application areas<br />Backup water supply techniques</li></ul><h4>Designing a Scalable Network Infrastructure</h4><ul><li>The importance of a Structured Cabling System<br />Planning considerations<br />Copper and Fiber cable technology and standards<br />ANSI/TIA-942 Cabling hierarchy and recommendations<br />Testing and verification<br />SAN storage cabling<br />Network redundancy<br />Building-to-building connectivity<br />Network monitoring system requirements</li></ul><h4>Fire Suppression</h4><ul><li>Standards for fire suppression<br />Detection systems<br />Various total flooding fire suppression techniques and systems, their benefits and disadvantages<br />Handheld extinguishers<br />Signage and safety<br />Regulatory requirements and best practices</li></ul><h4>Data Centre Monitoring</h4><ul><li>Data centre monitoring requirements<br />EMS versus BMS<br />Water leak detection systems<br />Notification options and considerations</li></ul><h4>Operational Security and Safety Practices</h4><ul><li>Data centre security layers<br />Physical, infrastructure and organisational security<br />Safety measures and essential signage</li></ul><h4>Labelling</h4><ul><li>Choosing a labelling scheme<br />Recommended labelling practices<br />Network labelling</li></ul><h4>Documentation</h4><ul><li>How to setup proper documentation<br />Document management policies and procedures</li></ul><h4>Cleaning</h4><ul><li>Cleaning practices for the data centre</li></ul><h4>MTBF/MTTR</h4><ul><li>Standards and definitions<br />Calculation models<br />The ?real? value</li></ul><h4>Maintenance Contracts/SLA/OLA</h4><h4>EXAM: Certified Data Centre Professional</h4></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Certified Data Centre Professional (CDCP) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Certified Data Centre Professional (CDCP) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Nexus Human

IT Certifications

Construction Design & Management (CDM)

Certified Cloud Security Professional (CCSP)

AWS Certified Cloud Practitioner

Certified in Data Protection (CDP)

Certified Cyber Professional (CCP)

Certified Data Centre Professional (CDCP)

<h1 id="isPasted" style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Online MHFA England Adult Mental Health First Aid Course.&nbsp;</h1><div fr-original-style="" style="box-sizing: border-box;"><a href="https://www.mindmapswellbeing.com/brochure-request/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Download brochure for course details here.</a><a href="https://www.mindmapswellbeing.com/_webedit/uploaded-files/All%20Files/Online%20Mental%20Health%20First%20Aid.pdf" rel="noopener noreferrer" target="_blank" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">&nbsp;</a>&nbsp;</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">This online version of the mental health first aid course will offer the same learning outcomes as the face to face training, and every person who completes the course will be certified as a Mental Health First Aider. &nbsp;The Online Mental Health First Aid course is a blended approach of individual learning and four instructor-led live sessions, hosted on a new Online Learning Hub. &nbsp;As a training course, Mental Health First Aid teaches people how to identify, understand and help someone who may be experiencing a mental health issue. The organisation&#39;s courses and resources also promote self-care as a vital way for people to help protect their mental health and prevent issues from getting worse. &nbsp;As with all our courses at Mindmaps Wellbeing, your course will be delivered by a Registered Mental Health Nurse, MHFA England Instructor and Open University Associate Lecturer and Practice Tutor experienced in remote teaching. Our live online learning will also include an assistant who is a MHFAider. &nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Our fee is &pound;300pp Groups of 5+ contact <a href="mailto:info@mindmapswellbeing.com" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">info@mindmapswellbeing.com</a>&nbsp;for reduced group fees.&nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Live instructor led sessions;&nbsp;</strong></div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">10:00 &ndash; 12:30 &amp; 14:30 &ndash; 17:00 both days&nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Individual learning modules around these times. You will gain access to this on the Friday before your course start date.</div><p id="isPasted" 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;"><u fr-original-style="" style="box-sizing: border-box;">Why choosing Mindmaps Wellbeing is a good choice for your training.</u></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The MHFA England RRP is &pound;325pp, our rate is &pound;300pp and our fee includes:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Instructor led training sessions over two days</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Course Manual</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Workbook</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Handy Cue Card</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ MHFAider Certificate upon completion</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Plus, exclusively when you choose Mindmaps Wellbeing, it also includes:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Your instructors are <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Registered Mental Health Nurses and Healthcare Educators</strong> (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life).</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Access to our online MHFAider peer support groups moderated by the instructor team.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Advanced Delegate Plan &ndash; This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</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;">For a little extra:&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Quarterly Facilitated MHFAider Forum &ndash; to provide ongoing expert support and guidance.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Organisational MINDWELL Companion tailored for your workplace / organisation.</p>

Online MHFA England Adult Mental Health First Aid Course. 
Download brochure for course details here.  This online version of the mental health first aid course will offer the same learning outcomes as the face to face training, and every person who completes the course will be certified as a Mental Health First Aider. The Online Mental Health First Aid course is a blended approach of individual learning and four instructor-led live sessions, hosted on a new Online Learning Hub. As a training course, Mental Health First Aid teaches people how to identify, understand and help someone who may be experiencing a mental health issue. The organisation's courses and resources also promote self-care as a vital way for people to help protect their mental health and prevent issues from getting worse. As with all our courses at Mindmaps Wellbeing, your course will be delivered by a Registered Mental Health Nurse, MHFA England Instructor and Open University Associate Lecturer and Practice Tutor experienced in remote teaching. Our live online learning will also include an assistant who is a MHFAider. Our fee is £300pp Groups of 5+ contact info@mindmapswellbeing.com for reduced group fees. Live instructor led sessions; 10:00 – 12:30 & 14:30 – 17:00 both days Individual learning modules around these times. You will gain access to this on the Friday before your course start date.
Why choosing Mindmaps Wellbeing is a good choice for your training.
The MHFA England RRP is £325pp, our rate is £300pp and our fee includes:
✅ Instructor led training sessions over two days
✅ Course Manual
✅ Workbook
✅ Handy Cue Card
✅ MHFAider Certificate upon completion
Plus, exclusively when you choose Mindmaps Wellbeing, it also includes:
✅ Your instructors are Registered Mental Health Nurses and Healthcare Educators (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life).
✅ Access to our online MHFAider peer support groups moderated by the instructor team.
✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider.
✅ Advanced Delegate Plan – This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available.
 
For a little extra: 
✅ Quarterly Facilitated MHFAider Forum – to provide ongoing expert support and guidance. 
✅ Organisational MINDWELL Companion tailored for your workplace / organisation.

Mindmaps Wellbeing

Health & Wellbeing

Occupational Health & Wellbeing

Mental Health

Accredited Mental Health First Aid

Mental Health At Work

Mental Health Nurse

Online MHFA England mental health first aid course delivered by Registered Mental Health Nurses from Mindmaps Wellbeing. 

Why choosing Mindmaps Wellbeing is a good choice for your mental health training.
The MHFA England RRP is £325pp, our rate is £300pp and our fee includes:
✅ Instructor led training sessions over two days 
✅ Course Manual
✅ Workbook
✅ Handy Cue Card
✅ MHFAider Certificate upon completion
Plus, exclusively when you choose Mindmaps Wellbeing, it also includes:

✅ Your instructors are Registered Mental Health Nurses and Healthcare Educators (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life).

✅ Access to our online MHFAider peer support groups moderated by the instructor team.

✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider.

✅ Advanced Delegate Plan – This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available.

For a little extra: 

✅ Quarterly Facilitated MHFAider Forum – to provide ongoing expert support and guidance. 

✅ Organisational MINDWELL Companion tailored for your workplace / organisation.


MHFA England Mental Health First Aid

<p dir="ltr" id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Overview</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong></span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Dive into our Organisational Planning &amp; Ethics course, tailored for the evolving job market. With technology and healthcare jobs booming, over 4.7 million new opportunities will open up by 2032 in the USA. This course teaches you to set goals, use resources well, and adapt to changes.&nbsp;</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Learn why ethics matter in building trust, improving your company&#39;s image, and making workplaces better. You&#39;ll get ready to lead businesses to success. Make positive impacts in the society. From marketing to crisis management and new technologies, become a leader for the future.&nbsp;</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Get set for a dynamic business world.</span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><br fr-original-style="" style="box-sizing: border-box;"></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learning Outcomes</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Understand the principles of organisational ethics.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Develop a comprehensive marketing plan.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Identify key elements of effective marketing strategies.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Evaluate strategies for minimising environmental damage.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Utilize new technologies for organisational enhancement.</span></p></li></ul><br fr-original-style="" style="box-sizing: border-box;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Description</strong></span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explore the dynamic world of Organisational Planning &amp; Ethics through our comprehensive course. It is designed for those aiming to make a big impact in the modern business world.</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">This course delves deep into essential skills and knowledge. Learn how to create robust marketing plans. By mastering the art of crisis management, we guide you every step of the way.</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Learn how to minimise environmental damage. Leverage the latest technologies to drive organisational success. Dive into the core elements of marketing. Discover the significance of organisational ethics in shaping a positive company culture.</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">This course prepares you for future challenges. It empowers you to lead with confidence and integrity in a changing job market. Get ready to transform your career and make a lasting impression in the world of business.</span></p><br fr-original-style="" style="box-sizing: border-box;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who is this course for?</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Professionals seeking to enhance organisational ethics and planning.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Individuals interested in pursuing careers in marketing and strategic management.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Students looking to gain practical insights into modern business practices.</span></p></li></ul><br fr-original-style="" style="box-sizing: border-box;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Career Path</strong></span></p><ol fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Marketing Manager: Expected yearly salary of $70,000 - $150,000.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Environmental Consultant: Expected yearly salary of $50,000 - $90,000.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Crisis Management Specialist: Expected yearly salary of $60,000 - $120,000.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Strategic Planning Analyst: Expected yearly salary of $80,000 - $140,000.</span></p></li></ol>

Course Cloud

Organisation

Explore the dynamic world of Organisational Planning & Ethics through our comprehensive course. It is designed for those aiming to make a big impact in the modern business world.

Organisational Planning & Ethics

Reading

Nottingham

Dickson Training Ltd

First Line Management Course

Classroom Course

Online Course

Oxford

Are you looking to Scale with Purpose AND Grow the Value of your business?

Join us for our FREE world-renowned SCALING UP Business Growth Workshop to learn the 7 tips (at least!) on how to Scale with Purpose.
Scale your business and accelerate profitable growth using the time-tested and results-driven Scaling Up methodology. 
We will introduce you to our proven systems and tools which have successfully enabled over 40,000 business leaders, owners and their leadership teams to achieve sustainable growth. You'll learn the keys to PEOPLE, STRATEGY, EXECUTION AND CASH.
Work smarter, not harder. Scale faster and avoid the pitfalls

What: A FREE Scaling Up event to help you understand how to scale with purpose and grow your value
Why: Clarity - it's about taking time out to plan. To create the plan for your next 90 days and for 2025

Where: Online 
When: Wednesday November 13th 2024 2pm-3.30pm (UK)
This isn't just a seminar where you sit and absorb - you will be working ON your business so you go away with renewed clarity about what to do next...

Ready to Get Down to Business and Scale-Up?
ALIGN - Get faster results with less effort by developing organisational clarity and accountability.
ACCELERATE - Develop a strategic advantage over the competition. Position your brand as a market leader.
ADVANCE - Using the Rockefeller Habits 2.0 Scaling Up Coaches have enabled companies to dominate their industries and make a more significant difference in the world.
Who should attend?
This workshop is specially designed for anyone who leads a business, whether you do this alone or within a leadership or management team. 
You should consider registering whether you are a CEO, CFO, entrepreneur or member of the leadership team. It is incredibly useful to bring your group to this event.
Those who attend this Scaling Up event will gain invaluable insight on how they can get back to business and advance their business growth.
What you will learn 
We will focus on the four critical decisions all businesses face - so you can get back to business:
Scaling Up PEOPLE
The Leaders: the FACE and PACE of the company
Align your team around core values and purpose
Create culture that works
Scaling Up STRATEGY
The Core: Values, Purpose, and Competencies
The 7 strata of Strategy
The One Page Strategic Plan
Scaling Up EXECUTION
The Priority: focus, finish lines and fun
The Meeting Rhythm: the heartbeat of the organization.
Systematise It
Grow the value of your business
What you will go away with
A plan – for the next 90 days and for the coming year
The ability to hit the ground running throughout 2025 confident you know what your whole team are doing
Time to think –  time out of the office – strategic thinking time
The book – Scaling up - revised edition (2022)
Cadence – build cadence and rhythm into your year… annual, monthly and quarterly - this is the start
Our Proven OPSP template
A system for building your business
Course Materials
Materials provided on the day of the workshop include:
• A detailed workbook with information and examples of the concepts presented
• A one-page strategic plan and other actionable tools to help grow your business.

Ignium Consulting Ltd

Strategic Planning

Business Development

Business Strategy

Leadership Development

Business & Management

Business Accelerator

Are you looking to Scale with Purpose AND Grow the Value of your business?

Join us for our FREE world-renowned SCALING UP Business Growth Workshop to learn the 7 tips (at least!) on how to Scale with Purpose.

Scale your business and accelerate profitable growth using the time-tested and results-driven Scaling Up methodology. 

We will introduce you to our proven systems and tools which have successfully enabled over 40,000 business leaders, owners and their leadership teams to achieve sustainable growth. You'll learn the keys to PEOPLE, STRATEGY, EXECUTION AND CASH.

Work smarter, not harder. Scale faster and avoid the pitfalls


What: A FREE Scaling Up event to help you understand how to scale with purpose and grow your value

Why: Clarity - it's about taking time out to plan. To create the plan for your next 90 days and for 2025

Where: Online 

When: Wednesday November 13th 2024 2pm-3.30pm (UK)

This isn't just a seminar where you sit and absorb - you will be working ON your business so you go away with renewed clarity about what to do next...



Learn The 7 Key Tips To Scaling Your Business in 2025 and Beyond

Early Bird (Before November 10th)

Last Minute November Bookings

Hayes

Research Quality Association

Practical Approach to Auditing Systems and Processes

RQA Member

Non Member

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">This masterclass is designed to provide a practical application of the content that is covered within The DEI Playbook including:</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">A deep dive into the six steps of the DEI framework&nbsp;<ol style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">DEI Strategy</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">Leadership commitment</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">Recruitment and hiring of diverse talent</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">inclusive performance management</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">equitable and inclusive organisational culture</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">marketplace and community impact</li></ol></li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">Measuring DEI using a scorecard</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">ISO audit - how to prepare for and conduct it</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">The success factors of inclusive culture change&nbsp;</li><li id="isPasted" style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">Project management techniques and best practice</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">A change communications toolkit</li></ul><p id="isPasted" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 18px; color: rgb(254, 114, 53); box-sizing: border-box;" fr-original-style="font-size: 18px; color: rgb(254, 114, 53);">Who is this learning for?</span></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Diversity and inclusion leads and practitioners</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">HR professionals tasked with diversity and inclusion within their remit</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Managers and leaders looking to develop an inclusive culture</li></ul><p id="isPasted" 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;"><span style="color: rgb(254, 114, 53); font-size: 18px; box-sizing: border-box;" fr-original-style="color: rgb(254, 114, 53); font-size: 18px;">What type of learning is this?</span></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Small group learning allows lots of time to focus on the &#39;doing&#39; as well as on learning</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Global cohorts so there is a greater opportunity to learn in a cross-cultural context</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Action learning so you can ask questions, engage with others and get feedback in the moment</li><li id="isPasted" style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Facilitated as an in-person event but also available as a virtual offer</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;"><span style="color: rgb(254, 114, 53); font-size: 18px; box-sizing: border-box;" fr-original-style="color: rgb(254, 114, 53); font-size: 18px;">What will this do for you?</span></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">You won&rsquo;t have to continue to rely on hope and luck as a strategy to achieve success. We will work on all the aspects that are introduced in The DEI Playbook to:</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Give you the tools to help you make the most effective decisions</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Show how you can implement changes that are long-lasting</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Provide practical guidance and support x1 individual support and implementation session (more sessions can be added for a bonus fee after the main event)</li></ul><p id="isPasted" style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><span style="color: rgb(51, 51, 51); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51); font-size: 14px;">This solution&nbsp;</span><span data-key="202" style="color: rgb(51, 51, 51); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51); font-size: 14px;">is developed by licensed and accredited practitioners with practical business experience.</span></p><span style="color: rgb(51, 51, 51); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51); font-size: 14px;">

</span><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><span data-key="204" style="color: rgb(51, 51, 51); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51); font-size: 14px;">On completion, a certificate of attendance will be issued to all participants towards CPD (Continuous Professional Development).</span></p>

This masterclass is designed to provide a practical application of the content that is covered within The DEI Playbook including:
A deep dive into the six steps of the DEI framework 
DEI Strategy
Leadership commitment
Recruitment and hiring of diverse talent
Inclusive performance management
Equitable and inclusive organisational culture
Marketplace and community impact
Measuring DEI using a scorecard
ISO audit - how to prepare for and conduct it
The success factors of inclusive culture change
A change communications toolkit
Project management techniques and best practice
Who is this learning for?
Diversity and inclusion leads and practitioners
HR professionals tasked with diversity and inclusion within their remit
Managers and leaders looking to develop an inclusive culture
What type of learning is this?
Small group learning allows lots of time to focus on the 'doing' as well as on learning
Global cohorts so there is a greater opportunity to learn in a cross-cultural context
Action learning so you can ask questions, engage with others and get feedback in the moment
Facilitated as an in-person event but also available as a virtual offer
What will this do for you?
You won’t have to continue to rely on hope and luck as a strategy to achieve success. We will work on all the aspects that are introduced in The DEI Playbook to:
Give you the tools to help you make the most effective decisions
Show how you can implement long-lasting changes
Provide practical guidance and support x1 individual support and implementation session (more sessions can be added for a bonus fee after the main event)
This solution is developed by licensed and accredited practitioners with practical business experience.
On completion, a certificate of attendance will be issued to all participants towards CPD (Continuous Professional Development).

Starling

Equity & Diversity

Leadership

Organizational Development

Professional Development

Diversity & Inclusion

Continuous Professional Development (CPD)

This one day masterclass is designed to provide a practical application of the content that is covered within The DEI Playbook and is aimed at anyone tasked with launching and implementing diversity and inclusion within their organisation. 

DEI Masterclass - Bringing The DEI Playbook To Life!

DEI Masterclass ticket

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span 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;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">A one-day course to help you understand the real estate sector, its characteristics and its importance to the general economy. This course will help anyone supporting or moving into the sector with the knowledge and tools to communicate effectively with real estate professionals. By the end of the course delegates will have gained key skills in Real Estate Investment strategy and Analytics. They will also become familiar with the players, structure, general terminology and overall needs of Real Estate.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span 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;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course, you will&hellip;</strong></strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Learn what is Real Estate and why it is different from other asset classes</li><li value="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Get to grips with the overall size and structure of the UK Real Estate Market</li><li value="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Learn and analyse the links between the different parts of the property market</li><li value="4" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Understand who works in the Real Estate Market, their qualifications and their job descriptions</li><li value="5" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Recognise how and when to use basic real estate concepts: Rent, Value, Yield, Risk and Return, etc&hellip;</li><li value="6" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Learn how to read a real estate market report</li><li value="7" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Understand how current affairs, politics and economics affects Real Estate Investment</li><li value="8" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Use household names and iconic companies, cities and buildings to help consolidate your appreciation of this exciting sector</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span 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;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Professionals outside the field (e.g. Lawyers, Lenders, Recruitment Professionals, Public Servants etc.) who regularly work with property companies</li><li value="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Customer Service Employees who interacts with Real Estate Firms</li><li value="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Junior employees in the HR department of Real Estate Firms Professionals in other sector interested in changing their career path to the Real Estate sector</li><li value="4" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Recent non-cognate Graduates interested in entering the field of Real Estate</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span 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;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong></strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><em fr-original-style="" style="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;">Morning</strong></strong></em></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Real Estate or Property?</li><li value="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">What is Real Estate - Physical characteristics &amp; Investment characteristics</li><li value="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Why buy Real Estate?</li><li value="4" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">How big is the UK Real Estate market? - Total size and size of various sub sectors</li><li value="5" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Key Real Estate Market Locations, Sale Prices and Rents</li><li value="6" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">The Property Market system - The Occupier market, The Investment market, The Property Development market, The Land market &amp; How the four markets interact and make money</li><li value="7" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">How to calculate Sale Price and Real Estate Returns</li><li value="8" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">How to read a Real Estate market report</li><li value="9" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">How many famous properties do you know? - How much did they cost to build? Who occupies these buildings? Are they good value for money?</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span 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;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><em fr-original-style="" style="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;">Afternoon</strong></strong></em></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Who works in Real Estate and what do they do?</li><li value="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Typical Real Estate CVs - Education and Experience, Professional bodies and accreditations &amp; Typical career paths</li><li value="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Real Estate Professionals and the Real Estate Lifecycle - The Investment lifecycle &amp; The Development lifecycle</li><li value="4" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Real Estate Companies&rsquo; - Types of property company, Organisational structure, Typical wages and employment benefits, Accessibility, CSR and Diversity &amp; Related industries</li><li value="5" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Real Estate Networks</li><li value="6" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">The future of Real Estate</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span 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;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">CPD Accredited Certificate</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Course Files</li><li value="4" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span 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;"></span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the An Introduction to Real Estate such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



A one-day course to help you understand the real estate sector, its characteristics and its importance to the general economy. This course will help anyone supporting or moving into the sector with the knowledge and tools to communicate effectively with real estate professionals. By the end of the course delegates will have gained key skills in Real Estate Investment strategy and Analytics. They will also become familiar with the players, structure, general terminology and overall needs of Real Estate.


On this course, you will…
Learn what is Real Estate and why it is different from other asset classes
Get to grips with the overall size and structure of the UK Real Estate Market
Learn and analyse the links between the different parts of the property market
Understand who works in the Real Estate Market, their qualifications and their job descriptions
Recognise how and when to use basic real estate concepts: Rent, Value, Yield, Risk and Return, etc…
Learn how to read a real estate market report
Understand how current affairs, politics and economics affects Real Estate Investment
Use household names and iconic companies, cities and buildings to help consolidate your appreciation of this exciting sector


Who will benefit from this course?
Professionals outside the field (e.g. Lawyers, Lenders, Recruitment Professionals, Public Servants etc.) who regularly work with property companies
Customer Service Employees who interacts with Real Estate Firms
Junior employees in the HR department of Real Estate Firms Professionals in other sector interested in changing their career path to the Real Estate sector
Recent non-cognate Graduates interested in entering the field of Real Estate


Course Outline
Morning
Real Estate or Property?
What is Real Estate - Physical characteristics & Investment characteristics
Why buy Real Estate?
How big is the UK Real Estate market? - Total size and size of various sub sectors
Key Real Estate Market Locations, Sale Prices and Rents
The Property Market system - The Occupier market, The Investment market, The Property Development market, The Land market & How the four markets interact and make money
How to calculate Sale Price and Real Estate Returns
How to read a Real Estate market report
How many famous properties do you know? - How much did they cost to build? Who occupies these buildings? Are they good value for money?


Afternoon
Who works in Real Estate and what do they do?
Typical Real Estate CVs - Education and Experience, Professional bodies and accreditations & Typical career paths
Real Estate Professionals and the Real Estate Lifecycle - The Investment lifecycle & The Development lifecycle
Real Estate Companies’ - Types of property company, Organisational structure, Typical wages and employment benefits, Accessibility, CSR and Diversity & Related industries
Real Estate Networks
The future of Real Estate


Included in the Course
CPD Accredited Certificate
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the An Introduction to Real Estate such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Bayfield Training

 This course will help anyone supporting or moving into the sector with the knowledge and tools to communicate effectively with real estate professionals. 

An Introduction to Real Estate (Foundational Level)

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is aimed at people in senior roles including CIOs, chief digital officers and other aspiring CxOs, as well as consultants and others involved in digital transformations, service delivery and strategic delivery.</p>Overview<p>By the end of this course, you will understand: The internal and external factors to consider while crafting digital strategy How IT strategy differs from digital strategy and how they can be integrated Creating a digital strategy that achieves the most value from digital Implementing and sustaining digital strategy Developing and nurturing digital capabilities for continual business innovation and value co-creation</p><p>This course takes you on a digital strategy journey. Its iterative, eight-step model moves from ?vision? through to ?actions? and is about creating sustainable, digital momentum. You experience the four key capabilities to develop a holistic, digital capability framework: digital leadership, managing innovation and emerging technologies, risk management and structuring a digital enterprise. <strong>This class includes an exam voucher.</strong></p>Prerequisites<p>Delegates attending this course must have successfully achieved the ITIL 4 Foundation Qualification; your certificate must be presented as documentary evidence to gain admission to this course. Although there is no mandatory requirement, ideally candidates should have at least two years professional experience working in IT Service Management.</p></div><div id="course-pills-2"><h3>1 - ITIL GUIDING PRINCIPLES TO ALL ASPECTS OF DIGITAL AND IT STRATEGY</h3> <ul> <li>Focus on Value</li> <li>Start Where You Are</li> <li>Progress Iteratively with Feedback</li> <li>Collaborate and Promote Visibility</li> <li>Think and Work Holistically</li> <li>Keep It Simple and Practical</li> <li>Optimise and Automate</li> </ul> <h3>2 - LEVERAGE DIGITAL STRATEGY TO REACT TO DIGITAL DISRUPTION</h3> <ul> <li>Digital Technology</li> <li>Digital Business</li> <li>Digital Organisation</li> <li>Digitisation</li> <li>Digital Transformation</li> <li>Business Strategy and Business Models</li> <li>Digital and IT Strategy</li> <li>Products</li> <li>Services</li> <li>Relationship Between Digital, IT Strategy and Components of ITIL SVS.</li> </ul> <h3>3 - RELATIONSHIP BETWEEN CONCEPTS OF DIGITAL AND IT STRATEGY, SERVICE VALUE SYSTEM AND SERVICE VALUE CHAIN</h3> <ul> <li>Environmental Analysis</li> <li>External Analysis: PESTLE</li> <li>Internal Analysis: Four Dimensions of Service Management</li> </ul> <h3>4 - HOW AN ORGANISATION USES DIGITAL AND IT STRATEGY TO REMAIN VIABLE IN ENVIRONMENTS</h3> <ul> <li>How an Organisation?s Viability is Related to Agile, Resilient, Lean, Continuous and Co-Creational it is</li> <li>How to Analyse the VUCA Factors and Address them in a Digital and IT Strategy</li> <li>Organisation?s Position in a Particular Market or Industry</li> <li>Digital Positioning Tool to Determine Appropriate Position for a Digital Organization</li> </ul> <h3>5 - EXPLAIN AND COMPARE THREE LEVELS OF DIGITAL DISRUPTION</h3> <ul> <li>Ecosystem</li> <li>Industry/Market</li> <li>Organisational</li> <li>Influenced factors</li> <li>Achieving Customer/Market Relevance</li> <li>Achieving Operational Excellence</li> <li>Internal and External Focus</li> <li>Balanced Approach</li> </ul> <h3>6 - STRATEGIC APPROACHES BY DIGITAL AND IT TO ACHIEVE CUSTOMER/MARKET RELEVANCE AND OPERATIONAL EXCELLENCE</h3> <ul> <li>How to Apply Approaches to Achieve Customer/Market Relevance</li> <li>Customer Journeys</li> <li>Omnichannel Delivery and Support</li> <li>Context-Sensitive Delivery and Support</li> <li>Customer Analytics</li> <li>Customer Feedback and 360Ã¸ Approaches</li> <li>How to Achieve Operational Excellence in the Four Dimensions of Service Management</li> <li>Understand the Financial Aspects of Digital and IT Strategy in Terms of the Following</li> <li>Financial Policies</li> <li>Portfolio Optimization</li> <li>Funding Projects, Products and Services</li> <li>Balancing Cost of Innovation and Operation</li> <li>Charging Models</li> <li>Assess Strategic Approaches for Digital Organizations</li> </ul> <h3>7 - RISKS AND OPPORTUNITIES OF DIGITAL AND IT STRATEGY</h3> <ul> <li>Concept of Risk Management in the Context of a Digital Organisation</li> <li>Context of Digital and IT Strategy</li> <li>Identify Risk</li> <li>Assess Risk</li> <li>Concept of Risk Posture and Show How to Determine an Acceptable Balance Between Opportunity and Risk</li> <li>Explain the Concept of Innovation, Including its Key Elements and Techniques</li> <li>Apply Techniques to Develop and Maintain a Culture of Innovation</li> </ul> <h3>8 - STEPS AND TECHNIQUES INVOLVED IN DEFINING AND ADVOCATING FOR DIGITAL AND IT STRATEGY</h3> <ul> <li>How to Use Digital Readiness Assessment to Perform Gap Analysis Between an Organisation?s Current and Desired Positions Approaches for Scraping Data from Dynamic Websites</li> <li>How to Define and Communicate a Vision and a Strategy</li> <li>How to Use Business Cases to Advocate for a Digital and IT Strategy</li> </ul> <h3>9 - IMPLEMENTATION OF A DIGITAL AND IT STRATEGY</h3> <ul> <li>How to Define Operating Models for Digital Organisations</li> <li>Major Skills Required of Leaders in Digital Organisation</li> <li>Apply Approaches to Strategy Coordination and Implementation:</li> <li>Large-Scale Transformation</li> <li>Incremental Transformation</li> <li>Mergers and Acquisitions</li> <li>Individual Changes</li> <li>Approaches to POMs (Parallel Operating Models)</li> <li>How to Assess Success of a Digital and IT Strategy</li> <li>Typical Activities of a Digital Transformation Programme</li> </ul></div>

ITIL

Design & Technology Courses (DT)

IT (Information Technology)

Institute of Leadership & Management (ILM)

ICDL (International Certification of Digital Literacy)

<h4 style="color: rgb(12, 46, 63); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(12, 46, 63);">Hello and thank you for joining us.</h4><h4 style="color: rgb(12, 46, 63); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(12, 46, 63);">In this WebWorkshop, you will learn:</h4><ul style="color: rgb(12, 46, 63); box-sizing: border-box;" fr-original-style=" color: rgb(12, 46, 63);"><li 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;">How to get everyone home safe every day.</p></li><li 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;">How to shift from &lsquo;doing&rsquo; safety to &lsquo;being&rsquo; safe.</p></li><li 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;">How to accommodate humans for being human.&nbsp;</p></li><li 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;">How the definition of safety must move beyond the physical to include psychological, emotional and spiritual.</p></li></ul><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">We run these WebWorkshops in a way which makes the information stick. You will not get an hour of PowerPoint slides, and instead will be taken on a journey through what Compassionate Safety is and what it can achieve.</span></div>

Hello and thank you for joining us.In this WebWorkshop, you will learn:
How to get everyone home safe every day.
How to shift from ‘doing’ safety to ‘being’ safe.
How to accommodate humans for being human.
How the definition of safety must move beyond the physical to include psychological, emotional and spiritual.
We run these WebWorkshops in a way which makes the information stick. You will not get an hour of PowerPoint slides, and instead will be taken on a journey through what Compassionate Safety is and what it can achieve.

Ppwd Consulting

PPWD’s Compassionate Safety approach generates environments that accommodate humans for being human. Our approach aligns personal and organisational mindsets, beliefs and values. In doing so, workplaces are created where people thrive and flourish.

2116 Courses

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

By Microsoft Office Training

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

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 Powerpoint Introduction - In-company (now with live online classes)

By Microsoft Office Training

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

By Microsoft Office Training

Microsoft Excel Advanced

By Microsoft Office Training

Microsoft Excel Macros & VBA - classroom

By Microsoft Office Training

Microsoft Excel Macros & VBA - Online classroom

By Microsoft Office Training

Microsoft Access Advanced - In-company / Bespoke

By Microsoft Office Training

Search By Location