2150 Other courses in Gravesend delivered Live Online

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

The insights gained from data analysis are only truly valuable when you can be clearly expressed to other people – bosses, colleagues, clients, customers, or other stakeholders. In this workshop you’ll learn how to turn raw qualitative or quantitative data into a clear visual story through infographics and data visualization. We'll discuss the key principles for planning an effective visual, look at examples of best (and worst) practice, and learn repeatable and practical design techniques for enhancing the story. We'll also give you an overview of useful tools that will help you turn your idea into a finished infographic or data visualization. You could be conjuring up eye-catching slide decks, building effective reports and dashboards, pitching to investors, or presenting persuasive data to your most important customers.  This is a fully interactive online workshop, so be prepared to join discussions and get hands on with building your own visualisations.  Takeaways Be able to evaluate the elements that make an infographic or visualization effective. Learn quick and repeatable visual tricks for ensuring infographics convey a clear message. Understand how to tailor your approach to different audiences and context. Discover a bunch of free tools and resources to help you build your own visualizations. Understand how online, interactive visualizations work and how to create them. Delivery  We deliver our courses over Zoom, to maximise flexibility. The training can be delivered in a single day, or across multiple sessions. All of our courses are live and interactive – every session includes a mix of formal tuition and hands-on exercises. To ensure this is possible, the number of attendees is capped at 16 people.  Tutor Alan Rutter is the founder of Fire Plus Algebra. He is a specialist in communicating complex subjects through data visualisation, writing and design. He teaches for General Assembly and runs in-house training for public sector clients including the Home Office, the Department of Transport, the Biotechnology and Biological Sciences Research Council, the Health Foundation, and numerous local government and emergency services teams. He previously worked with Guardian Masterclasses on curating and delivering new course strands, including developing and teaching their B2B data visualisation courses. He oversaw the iPad edition launches of Wired, GQ, Vanity Fair and Vogue in the UK, and has worked with Condé Nast International as product owner on a bespoke digital asset management system for their 11 global markets.
 Testimonials "Just to say what a great course this was. I have made my first report employing some of the ideas and tools you showed us – to rapturous responses! The next actions are clear for all and they all understood it! Thank you for helping me to organise my data and thoughts, showing how to present the key message up front, and how to keep it simple and focused. Gearing up for another report now!" Kay Anderson | Head of Finance | Mima "We have been using Tableau to display data for some time but knew we could do more to engage our end users. Alan’s training gave us a framework to start thinking about what we wanted to achieve with our visualisations and analysis, and some great tips on how to display information for maximum impact. Alan was an engaging trainer and we found the workshops very energising." Ellen Austin | Senior Data Analyst | London School of Economics

This course is designed to help adult learners develop the necessary language skills for academic success in an English-speaking environment. Through a combination of reading, writing, listening, and speaking exercises, participants will enhance their abilities to comprehend and produce academic texts, engage in critical thinking, and effectively communicate their ideas in written and spoken English.  Course Duration: 12 weeks (24 sessions) Course Objectives: By the end of this course, participants will: 1. Improve their academic vocabulary and understanding of complex grammatical structures. 2. Enhance their reading comprehension skills for academic texts. 3. Develop effective note-taking strategies for lectures and presentations. 4. Enhance their academic writing skills, including essay structure and research techniques. 5. Improve their ability to deliver academic presentations and participate in discussions. 6. Gain familiarity with academic conventions and citation styles. Course Outline: Week 1: Introduction to Academic English - Assessing participants' language proficiency and academic goals - Overview of the course syllabus and expectations - Introduction to academic vocabulary and common idiomatic expressions Week 2: Reading Comprehension - Scanning and skimming techniques for efficient reading - Strategies for understanding main ideas and supporting details - Vocabulary building through reading academic texts Week 3: Note-taking Skills - Effective note-taking during lectures and presentations - Organizing and summarising information - Practice exercises and listening activities Week 4: Academic Writing: Paragraph Structure - Understanding the components of a well-structured paragraph - Developing topic sentences and supporting ideas - Practice exercises on paragraph development Week 5: Academic Writing: Essay Structure - Introduction to essay structure: introduction, body, and conclusion - Crafting clear and concise thesis statements - Developing coherent and well-supported arguments Week 6: Research Skills and Citations - Introduction to academic research techniques - Evaluating sources for credibility and relevance - Understanding and applying citation styles (e.g., APA, MLA) Week 7: Grammar for Academic Writing - Review of essential grammar structures for academic writing - Practice exercises on sentence structure and complex grammar - Common grammatical errors to avoid in academic writing Week 8: Academic Writing: Research Papers - Understanding the research paper format and structure - Conducting literature reviews and integrating sources - Drafting and revising research papers Week 9: Academic Speaking: Presentations - Preparing and delivering effective academic presentations - Using visual aids and engaging the audience - Practicing presentation skills through individual and group activities Week 10: Academic Speaking: Discussions and Debates - Participating in academic discussions and debates - Expressing opinions and supporting arguments effectively - Listening and responding critically to others' viewpoints Week 11: Academic Writing: Critical Analysis - Analyzing and critiquing academic texts - Developing critical thinking and evaluation skills - Writing critical analysis essays Week 12: Review and Final Projects - Reviewing course content and addressing individual needs - Finalizing and presenting individual projects - Course evaluation and feedback session Note: This syllabus is a guideline and can be customised based on the specific needs and preferences of the participants. You can opt in and out of different modules. 

This Strategy Insights Masterclass explores what strategic planning is really about and how to approach it effectively (including how to consider the uncertainty of the future).

Why Choose 3ds Max Basic to Intermediate Training Course? Course info Looking to take your 3D modelling and animation skills to the next level then Our Intermediate 3DS Max course is designed to help you do just that! A bespoke course ideal for anyone who has a solid understanding of modelling in the 3D environment for films & games. Duration: 20 hrs Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule and hours of your choice, available from Mon to Sat between 9 am and 7 pm. Why Opt for Our 3ds Max Basic to Intermediate Course? Elevate your 3D modeling and animation skills with our tailored Intermediate 3DS Max course, perfect for those proficient in 3D modeling for films and games. 3ds Max Interface: Familiarize yourself with essential interface areas, tool names, and shortcuts. Master the Scene Explorer for comprehensive scene control. Learn initial software settings for an efficient workflow. Organize your project folder for streamlined work management. Enhance workflow through scene navigation shortcuts and visual styles setup. Understand scene unit configuration for precision. Foundations of 3D Modeling: Acquire industry-standard 3D modeling techniques. Implement compositing modeling with procedural geometry. Utilize non-destructive methods via Modifiers to enhance base geometries. Create 3D models using Splines and modifiers like Extrude, Sweep, and Lathe. Explore Boolean operations for complex shape creation. Delve into Mesh Modeling, enabling manual mesh editing for customized objects. Mesh Modeling: Navigate mesh modeling tools in 3ds Max. Model hard surface objects using mesh modeling and other techniques. Unleash creativity in modeling various objects. Material Creation and Application: Understand material basics and texture application. Create, apply, and resize materials on models. Utilize pictures as references for modeling. Apply multiple materials to one object. Incorporate transparency, reflection, and self-illuminating textures. Utilize images with transparency for intricate texture designs. Camera Control Techniques: Learn camera creation and viewpoint adjustment. Modify camera focal length and lock settings for stability. Adjust camera exposure for desired image brightness. Explore cameras with and without targets, understanding their differences. Lighting: Create realistic lighting using daylight systems. Fine-tune daylight settings based on geographical location. Optimize render settings for high-quality output. Utilize various light types for interior illumination. Master light distribution and apply color filters and textures. Implement HDRI environment images for realistic lighting effects. Animation Essentials: Gain a basic understanding of animation principles. Animate objects manually through keyframing. Create walkthrough animations using cameras and paths. Construct efficient camera rigs for path-based animations. Render animations as video output. Advanced Rendering Techniques: Explore rendering with V-Ray Simulate daylight systems and interior lighting in V-Ray Set up studio lighting configurations in both V-Ray advanced rendering. Course Requirements: A computer with 3ds Max and Vray installed (trial versions available on Autodesk and Chaos Group websites) Basic familiarity with 3D modeling concepts is beneficial but not mandatory Enthusiasm for learning 3ds Max and Vray to create impressive 3D models, visualizations, and animations

Legionella Responsible Person Online is suitable for any persons wanting to gain an understanding of Legionella and how to prevent or control the risk of exposure to Legionella bacteria.

Embark on a transformative journey to become a qualified MHFAider®. Master your skills and learn how to spot and support people with mental health issues and make a difference whether at work, volunteering, or in your community.

Join our Women in Insurance Leadership Workshop and gain insights from industry experts on how to succeed in the male-dominated insurance sector. This workshop is designed to empower women by providing valuable tools and resources to enhance leadership skills, build professional networks, and create a more inclusive workplace culture. Don't miss this opportunity to connect with other women in the industry and take your career to the next level. Register today!

What does this course cover? This is an online course for developing history leadership in primary teaching. This term, we will be piloting the course as an immersive programme covering the key elements of primary history subject leadership, enabling all involved in history leadership at primary to carry out their role effectively. How is this course structured and delivered? Sessions 1, 8 and 10 are compulsory to attend live. Participants will be required to complete a gap task after each session and contribute to an online reflection diary. The other sessions will be recorded for participants to work through at their convenience. Who is this course for? This programme is designed for anyone who is a subject coordinator or subject leader for history in their primary school. You may have just been appointed as a subject leader, or be more experienced but looking for formal training or fresh inspiration and direction. What are the outcome? This course will: equip you fully for the demands of history leadership in primary schools increase your confidence to develop an innovative, inclusive and effective history curriculum in your school develop your understanding of efficient action planning and how to make a wider impact help you to make the case for history with senior leaders enable you to enthuse others and lead staff meetings about history develop your understanding of current issues in primary history education The course will include a chance to share resources and assessment approaches, plus much more What will each session cover? Session 1: Introductory meeting (Live attendance) Wednesday 15 October 2025, 4pm–5.30pm Introduction and aims Reflection activity on the current state of history in your school Key responsibilities of the history subject leader Current Ofsted implications for the subject and what to expect in an inspection How the HA and latest Ofsted material can support you Session 2: What makes an effective history subject leader? (Recorded) How to effectively support teachers and learners as a history leader How to create a vision, lead change, and manage time Effective action planning and improvement Auditing your history provision and building your evidence trail Developing an innovative, inclusive and effective history curriculum in your school Disciplinary knowledge: What is history? What do historians do? Suggested gap task: Conducting teacher and/or pupil voice questionnaires. Compulsory gap task: Add to your reflection diary for the programme. If relevant, reflect on how you will use the teacher questionnaire or pupil voice. Session 3: What makes effective teaching of history? (Recorded) The role of the teacher Supporting SEND pupils Securing substantive knowledge and concepts across the curriculum How to support colleagues by identifying core knowledge How to involve the whole staff in mapping out and embedding the progression of concepts across the curriculum Suggested gap task: Consider SEND in your curriculum. Compulsory gap task: Add to your reflection diary for the programme reflecting on SEND. Session 4: Curriculum and practice at EYFS (Recorded) Unpicking and supporting the requirements of the EYFS curriculum and Development Matters Developing historical and chronological understanding in EYFS as part of Understanding the world Progression and transition from EYFS to Key Stage 1 Ensuring coherence: how to start developing concepts Making use of the local history on your doorstep for EYFS and KS1 Accessing resources and support for EYFS Suggested gap task: Fact finding and liaison. Compulsory gap task: Add to your reflection diary for the programme reflecting on current EYFS practice. Session 5: Curriculum and practice at Key Stage 1 (Recorded) Unpicking and supporting the requirements of the National Curriculum for KS1 Progression: building upon transition from EYFS What do KS1 require before KS2? Ensuring coherence: further developing the school’s chosen substantive concepts How to develop disciplinary concepts Developing appropriate chronological understanding in KS1 Enhancing and engaging children’s knowledge and retention through enquiry The use of working walls in KS1 to support learning Accessing resources and support for KS1 Suggested gap task: Check your KS1 curriculum for coverage and progression, building upon what they have learnt in EYFS. Compulsory gap task: Add to your reflection diary for the programme reflecting on KS1 practice in your setting. Session 6: Curriculum and practice at Key Stage 2 (Recorded) Unpicking and supporting the requirements of the National Curriculum for KS2 How to incorporate local history with progression in KS2 What do we want the children in Year 6 to leave with? Developing appropriate chronological understanding in KS2 Preparing for transition to Key Stage 3 Ensuring coherence: building upon the school’s chosen concepts for progression What the HA can do to support the teaching of KS2 units? Resources and support for KS2 Suggested gap task: Check your KS2 curriculum for coverage and progression, building upon what they have learnt in EYFS and KS1. Compulsory gap task: Add to your reflection diary for the programme reflecting on KS2 practice in your setting. Session 7: Approaching sensitive issues in history (Recorded) What do we mean by diversity in history and why is it important? How to ensure a wider diversity in your history teaching Barriers to making the curriculum more diverse and how to overcome them Approaches to sensitive issues in history lessons, including: - Refugees and migration history - War - Climate change Suggested gap task: Consider opportunities for increasing diverse voices and raising climate issues in your curriculum. Compulsory gap task: Add to your reflection diary for the programme considering how you might address the sensitive or current issues raised in this session. Session 8: Interim review meeting (Live attendance) Monday 19 January 2026, 4pm–5.30pm A review session allowing subject leaders to reflect upon their progress so far Opportunity to respond to suggestions, clarify information, or raise issues from the previous sessions Time to ask questions, share good practice or recommended resources with the rest of the cohort Suggested gap task: Time to follow up on anything raised in this session or to complete any previous tasks, following clarification and inspiration from this session. Compulsory gap task: Add to your reflection diary for the programme, reflecting on your priorities and actions using suggestions from the presenter or other delegates. Session 9: Assessment and evidence (Recorded) Assessment and expectations A word about writing Triangulating the evidence What to look for in a work scrutiny Suggested gap task: Conduct a work scrutiny on one aspect to check across the school, in conjunction with a focused pupil voice on the same aspect. Compulsory gap task: Add to your reflection diary considering how you will conduct a work scrutiny and what you will focus on – or, if relevant, reflect on what you discovered and how you will address any issues. Session 10: Final meeting (Live attendance) Wednesday 11 February 2026, 4pm–5.30pm Following up any requests arising from the interim meeting (Session 8) Discussion or clarification of any issues arising from previous sessions Discussion of priorities, next steps and any issues Sharing ideas for enthusing others and leading staff meetings: “What worked for me?” Communicating with headteachers, governors, colleagues and parents Are you ready for the HA Quality Mark? Suggested gap task: Identifying your school’s next steps Compulsory gap task: Complete your final piece in your reflection diary.

Indesign face to face training customised and bespoke. One to One Online or Face to Face