• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

1907 Organ courses in Cardiff delivered Live Online

Women in Healthcare Leadership Workshop

5.0(1)

By Own Your Success

Women in Healthcare Leadership Workshop Our Aims For This Workshop: Become clear about your leadership style and philosophy. Understanding how to navigate yourself and your team in a VUCA environment. How to communicate with presence and impact. Topic 1 Foundations For Effective Leadership Develop your leadership story – (know yourself) Your values, influences and leadership philosophy Clear vision and purpose as a leader Adapting style to suit the context Topic 2 Leading Through Rapid Change (Uncertainty) Exploring the VUCA environment (Volatile, Uncertain, Complex, Ambiguous) Understanding the psychological process of change Resilience and stress management Topic 3 Communication Skills For Influential Leaders How to prepare to be present so you have a presence Explore and understand your own innate communication style Importance of voice, pace, trust, and rapport THE FACILITATOR Ruth Sangale Ruth has 20 years HR and OD experience in the public and private sectors, leaving the NHS in 2012 to set up her own business “Enjoy Work” and specialise in Creative Leadership development and executive coaching. She works internationally coaching and running residential leadership programs for global organisations such as UNICEF, WHO, UN Women, and PLAN International and charitable NGOs in a range of countries including, Afghanistan, Brazil, India, Kenya, and Belize. In the UK she designs and delivers workshops for mostly the NHS, on topics such as career development, resilience and positive psychology, feedback skills, coaching skills for leaders and team development. She is an ICF-accredited coach and has an M Sc in Innovation, Creativity and Leadership. In her work she uses creative tools such as drama, visualization, drawing, mindfulness and storytelling to stimulate creative thinking and develop leadership capability. She has two daughters and in her free time loves hiking, climbing mountains and salsa dancing. THE PANEL Sam Foster - Chief Nursing Officer - Oxford University Teaching Hospitals Sam joined the Board of Oxford University Hospitals NHSFT in September 2017 as an experienced Chief Nurse who previously worked at the Heart of England NHS Foundation Trust where she held the role of Chief Nurse for four years. Sam has also worked in a number of Trusts in clinical, operational and educational roles. Sam's portfolio includes the professional leadership and education of over 5,000 Nurses, Midwives and AHPs. In addition to the Executive leadership of the Trust Facilities and PFI Services, she is accountable for the Estates and delivery of the capital program. Sam leads the Urgent Care program across the Oxfordshire system. Avey Bhatia - Chief Nursing Officer - Guys & St Thomas’ NHS Trust Avey Bhatia is Chief Nurse at Guy’s and St Thomas’ Trust. Avey returned to the Trust as Chief Nurse in November 2020, having trained as a critical care nurse at St Thomas’ in the early part of her career. Avey qualified in 1991 and her clinical experience includes theatres, general intensive care, coronary care and cardiothoracic nursing. She held various staff nurse and sister posts at hospitals in London before becoming Chief Nurse and Director of Infection Prevention and Control at St George's University Hospitals NHS Foundation Trust in 2017.  Avey holds a postgraduate diploma in health services management and a Masters in Public Administration. She is also the Trust’s Director of Patient Experience, and the executive lead for adults’ and children’s safeguarding, and for infection, prevention and control. Beyond Guy’s and St Thomas’, Avey is Vice President for the Florence Nightingale Foundation and Honorary Vice President of The Nightingale Fellowship. She is a Trustee for the St John of Jerusalem Eye Hospital Group.  Caroline Alexander CBE - Group Chief Nurse - Barts NHS Trust Caroline graduated as a nurse in 1987 from Edinburgh University (BSc/RGN) and has an MSc in Nursing Studies from South Bank University (2001). From 1987 to 1993 she specialised in nursing older people in Edinburgh and then London at Guy’s Hospital as a ward sister. Caroline then worked for the Foundation of Nursing Studies for three years supporting nurses to use research in practice. In 1998 Caroline returned to the NHS and worked in Tower Hamlets in a range of roles within older people’s services. In 2005, Caroline took up her first Director post, as Director of Nursing and Therapies within Tower Hamlets PCT. With the clustering of PCTs in London in 2011, she took on the Director of Nursing and Quality within NHS East London and the City initially and then within NHS North East London when the clusters merged in 2012. until she joined NHS England as Regional Chief Nurse for London in April 2013. Caroline took up her current role of Chief Nurse for Barts Health in March 2016. Caroline was a 2008 Florence Nightingale Leadership Scholar and has been awarded Honorary Doctorates from City, University of London in 2017, Middlesex University in 2018 and University of East London in 2021. She is a Trustee of the Foundation of Nursing Studies. In 2020 she was made a CBE in the Queen’s Birthday Honours. Who will attend? Emerging Leaders looking to step into management roles Current Leaders looking to progress into senior management roles This workshop is open to any woman who works in health care and wants to take her next step in their career; women include trans women and non-binary people who are comfortable in a female-centered group. Group Rate Discounts 2-3 people, 7% discount 4+ people, 20% discount We have two group rates which you can take advantage of depending on the size of the group you wish to book: Option 1️⃣ Groups between 2 & 3 are eligible for the 7% Discount. Please use this code at checkout: GROUP 2+  Option 2️⃣ For groups of over 4+ attendees, the eligible discount is 20%. Please use this code at checkout: GROUP 4+  Where do I add the discount code? 

Women in Healthcare Leadership Workshop
Delivered OnlineJoin Waitlist
£340 to £425

3D Studio Max and CAD Courses 1 on 1

By ATL Autocad Training London

These courses are designed for aspiring 3D artists, students, graduates, creative professionals, CAD designers, and anyone passionate about 3D art. Whether you're looking to launch a career, enhance existing skills, or explore new creative avenues, our courses provide comprehensive training tailored to various skill levels and interests. Check our Website Duration: 16 hours Method: 1-on-1 and Tailored content Dates and Times: Select your preferred hour from Monday to Saturday, available between 9 am and 7 pm. CAD and 3D Studio Max Training Course Duration: 16 hours Course Outline: Introduction to AutoCAD Familiarizing yourself with the AutoCAD interface Navigating the drawing environment Mastering fundamental 2D geometry creation Exploring essential drawing tools and commands Introduction to blocks and symbols for efficient design Advanced AutoCAD Techniques Delving into advanced drawing methods Proficiently manipulating and editing 2D geometry Crafting custom symbols and blocks for enhanced productivity Working with text and annotations for clear communication Utilizing layers and line types for organized design 3D Modeling in AutoCAD Venturing into the world of 3D modeling Precision crafting of 3D solids and surfaces Seamless modification and manipulation of 3D geometry Crafting custom materials and textures for realistic designs Effective utilization of AutoCAD's lighting and camera systems Introduction to 3ds Max Embracing the 3ds Max interface and configuring the workspace Proficiency in navigating within 3ds Max Understanding the viewport for optimized design Exploring basic 3D modeling techniques in 3ds Max Materials and Textures in 3ds Max Application and modification of textures for enhanced designs Mastering the art of UVW mapping for precise texturing Utilizing the material editor for creative freedom Crafting custom materials aligned with your design vision Harnessing the power of Vray materials for lifelike renders Lighting in 3ds Max Introduction to various lighting techniques Grasping light properties for impactful designs Strategic setup of lights to enhance scenes Illuminating scenes with Vray lights Cameras in 3ds Max Mastery of camera systems in 3ds Max Exploring camera properties for cinematic effects Creating animations with cameras for dynamic scenes Utilizing Vray cameras for stunning renders Rendering in 3ds Max Unveiling the art of rendering Utilizing Vray Global Illumination for realistic lighting Leveraging Vray Physical Cameras for precise control Enhancing scenes with Vray HDRI Lighting Following a Vray Rendering Workflow for professional results Advanced Modeling Techniques Proficiency in crafting complex geometry Utilizing modifiers for intricate designs Exploring polygonal modeling for versatile creations Creating both organic and inorganic models with expertise Unleashing the potential of advanced modeling techniques Projects Application of acquired skills to create real-world scenes Designing a detailed interior scene with meticulous attention Crafting a visually impactful exterior scene Creating a complex scene featuring multiple objects and materials Course Requirements: A computer with AutoCAD and 3ds Max installed Basic knowledge of computer operations A keen interest in 2D and 3D modeling and design Course Goals: Upon course completion, you will possess a comprehensive understanding of AutoCAD and 3ds Max, enabling you to craft intricate 3D scenes enriched with advanced materials, textures, lighting, and rendering. These newfound skills empower you to advance your capabilities in both 2D and 3D modeling and rendering. Upon successful completion of this comprehensive AutoCAD and 3ds Max training, participants will attain the following skills: AutoCAD Proficiency: Mastery of 2D geometry, drawing tools, and symbols. Advanced AutoCAD Techniques: Expertise in editing, custom blocks, text, and layers. 3D Modeling in AutoCAD: Competence in crafting 3D solids, textures, and lighting. Introduction to 3ds Max: Proficient navigation of the interface and fundamental 3D modeling. Materials and Textures: Application and customization of textures using Vray. Lighting and Cameras: Mastery of lighting and camera systems within 3ds Max. Rendering: Production of high-quality renders through Vray. Advanced Modeling: Proficiency in handling complex geometry and creating organic models. Real-World Projects: Capability to design interiors, exteriors, and intricate scenes. Skills Acquired: Mastering 3D Modeling Techniques in 3D Studio Max Advanced Texturing and Material Application Skills Proficiency in Lighting and Rendering Techniques Expertise in Animation and Keyframe Techniques Comprehensive Scene Composition and Camera Setup Knowledge Career Opportunities: Senior 3D Modeler Experienced CAD Designer Lighting and Rendering Specialist Animation Director Architectural Visualization Expert Upon completing our 3D Studio Max and CAD Courses, students will acquire advanced 3D modeling, animation, and CAD design skills, paving the way for rewarding careers in roles such as Senior 3D Modeler, CAD Designer, Lighting Specialist, Animation Director, and Architectural Visualization Expert. You will gain access to the following benefits: An Autocad and 3ds Max Certificate of Attendance. A comprehensive PDF training guide for 3ds Max and CAD. Real-time feedback during sessions, with the option to record them as video archives. We offer the following advantages: Price guarantee to ensure the best value for your investment. Personalized one-on-one training for focused learning. Flexible scheduling options available seven days a week, from 9 am to 7 pm. Lifetime email and phone support for ongoing assistance. Assistance with software installation and computer setup. Referral discounts and special offers on group training courses.

3D Studio Max and CAD Courses 1 on 1
Delivered in London or OnlineFlexible Dates
£576

3ds Max Basic to Intermediate Training

By London Design Training Courses

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

3ds Max Basic to Intermediate Training
Delivered in London or OnlineFlexible Dates
£600

Level 3 Certificate in Assessing Vocational Achievement

By Step Into Learning

If you work with adults and young people and wish to gain a knowledge of the principles and practice of assessment as well as the practical aspects of carrying out assessment, then Level 3 Certificate in Assessing Vocational Achievement is for you.

Level 3 Certificate in Assessing Vocational Achievement
Delivered OnlineFlexible Dates
£400

AutoCAD-Mac Introduction to Advanced Training Course

By ATL Autocad Training London

AutoCAD-Mac Introduction to Advanced Training Course This project-based course is tailored for AutoCAD Mac users, architecture and interior design students and professionals. Click here for more info: Website When Can I Book This Training Course? Personalized experience with 1-on-1 sessions designed to fit your unique needs. Available from Monday to Saturday, 9 am to 7 am Or Call to Book 02077202581. Duration of Training: 16 hours. Training Method:  1-on-1, providing the option for in-person sessions or live online training. Course Content Section 1: Introduction Course Overview Section 2: Basic Concepts Status Bar and The Units Drawing Commands Control Points - Vertex or Verteces Modifying Commands Snap Settings Drawing An Outline Section 3: Dimensions and Customization Adding Dimensions and Dimension Style Manager Importing Dimension Styles Customizing Shortcuts Section 4: Advanced Techniques Adding Walls Thickness with Offset Command Adding interior layout Cleaning Layout lines with Trim Section 5: Text and Styling Text Editing and Importing Text Styles Main File Formats in AutoCAD Section 6: Design Elements Creating Openings in the Floor Plan Adding Openings - Part 2 Adding Openings - Part 3 Drawing Doors & Windows Using Line Types & Linetype Scale Group and Ungroup Commands Using Blocks Using Blocks Library & Dynamic Blocks Section 7: Layers and Furnishing Layers - Part 2 Layers - Part 3 Furnishing Bedrooms & Bathrooms - Part 1 Adding Furniture, Fixtures, and Equipments | part 2 Adding Furniture, Fixtures, and Equipments | part 3 Drawing the Kitchen Drawing the Living Room Drawing Dining Room & Adding Casework Adding Steps and Railings Using Stretch Command Finishing Steps and patio areas Hatch command Hatch Customization Adding Plants & Finishing Floor Plan Section 8: Layout and Printing Paper Space & Page Setup Manager Working with Viewport & Using Print Command Scale & Using Multiple Viewports Locking Viewport Scale Drawing A Titleblock - Part 1 Drawing A Titleblock - Part 2 Copying the Titleblock Using Titleblock with Attributes Section 9: Roof Plan and Organization Drawing The Roof Plan Placing Roof Plan on Sheet Organizing Project Drawings & Using Layer Freeze AutoCAD Crashing And What To Do Section 10: Elevations Exterior elevations - Drawing the Outline Exterior elevations - Drawing the Openings Elevations - Detailing - Part 1 Elevations - Detailing - Part 2 Elevations - Repeating the workflow Elevations - Finishing 3rd Elevation Elevations - Drawing the final elevation Section 11: Sections Sections: Drawing Cut Lines & the Outline Sections: Placing 1st Section on Sheet Sections: Drawing Section #2 - Different Technique Sections: Adding Final Detail Section 12: Interior Elevations Interior Elevations: Drawing the Outline Interior Elevations: Placing on Sheet Interior Elevations: Using Block Clip Interior Elevations: Final Drawing Section 13: Conclusion Putting the Final Set Together Proficient AutoCAD Skills: Master essential tools for efficient drawing creation and manipulation. Accurate 2D Designs: Create precise and high-quality layouts with attention to detail. Effective Object Handling: Excel in selecting, moving, copying, and scaling objects. File Management: Organize drawings efficiently and understand different file formats. Precise Measurements: Utilize inquiry commands for accurate design analysis. Annotations and Hatching: Apply text, dimensions, and hatching to enhance drawings. Object Organization: Manage layers and object properties for organized designs. Reusable Content: Efficiently use blocks, tool palettes, and groups for productivity. Layout Optimization: Create layouts with viewports for optimal design presentation. Professional Output: Generate professional plots and PDF output for polished results. Enhanced Productivity: Explore AutoCAD toolsets and web/mobile apps for streamlined workflow. Course Overview: Learn versatile AutoCAD for Mac drawing techniques, applicable across all industries, enabling you to excel in the application. Our trainers incorporate exercises from various disciplines. Who Should Attend: Ideal for newcomers to AutoCAD for Mac, self-taught users seeking correct techniques, and those transitioning from other CAD tools. Requirements: A solid Mac OS understanding is essential, while prior CAD knowledge is not required. Pre-course preparation guidance is provided for new AutoCAD users. Highlights: Perfect for AutoCAD for Mac beginners. Gain skills for precise 2D layouts and designs. Versatile drawing techniques for all industries. Choose between in-class or live online training. Autodesk Certified Tutors: AutoCAD 1-2-1 courses. Hands-on learning with expert trainers. Lifetime post-course email support. Tailored on-request training available. Certificate: Digital certificate included. Tailored Mac Training: Excel in AutoCAD with specialized Mac training, leveraging its distinct features and interface for heightened efficiency. Comprehensive Skill Enhancement: Advance from fundamental to intermediate AutoCAD Mac proficiency, creating precise and professional 2D drawings. Industry-Relevant Expertise: Attain in-demand skills valued by employers in architecture, engineering, and design sectors. Hands-On Project Exposure: Immerse yourself in practical exercises mirroring real-world design scenarios, fostering practical competence. Lesson Recordings for Review: Access recorded lessons for reinforcement and deeper AutoCAD Mac comprehension. Ongoing Email Support: Benefit from lifetime email support, ensuring assistance beyond course completion."

AutoCAD-Mac Introduction to Advanced Training Course
Delivered in London or OnlineFlexible Dates
£558

INTERNATIONAL TRADE

By Export Unlocked Limited

Introduction to International Trade This module provides a foundational understanding of the development and significance of international trade, focusing on the UK's trade strategy and its global role. Participants will explore key topics such as trade definitions, the World Trade Organization (WTO), the evolution of customs, and major post-WW2 trade developments. Additionally, the module covers the UK's entry into and exit from the EU, and the current UK Digital Strategy for International Trade. **Agenda Highlights**: - Definitions and importance of international trade - Overview of the WTO - Customs fundamentals - Post-WW2 global trade growth - Impact of EU membership and Brexit - UK Digital Strategy for international trade growth

INTERNATIONAL TRADE
Delivered OnlineFlexible Dates
£395

Vectorworks Intermediate Training Course

By ATL Autocad Training London

Who is this course for? Vectorworks Intermediate Training Course. This intermediate course empowers designers with Vectorworks skills, enhancing productivity and enabling the creation of intricate, high-quality designs. Design career with this essential training. Vectorworks courses cater to individuals of all skill levels. Click here for more info: Website Scheduling: 1-on-1 training, your schedule. Book any hour, Mon to Sat, 9 am - 7 pm. Call 02077202581 to reserve. Duration: 16 hours. Method: In-person sessions and live online.  Comprehensive Course Outline Please note that the following is a general outline, and the specific topics covered during your training will be tailored to your student level, available time, and course preferences. Essential Foundations Navigating the Interface and User-Friendly Navigation Document Settings Adjustment and Template File Creation Effective File Navigation: Zooming, Panning, and Page Fitting Object Selection Techniques and Deletion Creating Basic Drawings with Precision Utilizing Object Snaps for Accurate Drawing Understanding the Object Info Palette Exploring Fundamental 2D Tools and Tool Modes Crafting Complex Lines and Shapes Project Organization Efficiently Organizing Your Drawings Using Classes Customizing Colors, Line Types, and Line Thickness Views Management: Saving and Editing Views Annotating and Printing Your Designs Adding Text and Annotations Incorporating Dimensions for Clarity Preparing and Printing Your Drawings Advanced Presentation Techniques Leveraging the Power of Sheets and Viewports Creating Standard and Cropped Viewports Annotating and Editing Viewports Exploring Viewport Display Overrides and Sheet Layer Printing Streamlining Workflows Between Viewports and Design Layers Efficiently Saving and Editing Views for Navigation Enhancement Importing DWG and File Formats Importing and Effectively Working with DWG Files Integrating Sketches and Photos into Your Drawings Enhancing Efficiency Creating and Editing Symbols Resource Browser: Management and Organization of Symbols Maximizing Productivity with Worksheets, Schedules, and Reports Custom Attribute Creation and Management (Hatches, Gradients, and Image Fills) Designing Custom Title Blocks Free 30-day Trial Vectorworks https://www.vectorworks.net/trial After completing this course, you will: Master Vectorworks: Gain proficiency in Vectorworks software, including its interface and essential design tools. Precise Drawing: Create accurate drawings with dimensions and object snaps. Project Management: Efficiently organize and manage design projects using classes and views. Clear Presentation: Annotate and dimension your drawings for professional presentations and printing. Advanced Presentation: Learn advanced presentation techniques, including sheets and viewports. File Integration: Work with DWG files, sketches, and photos to enhance your designs. Efficiency Boost: Discover time-saving workflows, symbol creation, and customization. Top Job Opportunities for Designers: Architectural Drafter Interior Designer Landscape Designer CAD Technician Graphic Designer Construction Estimator Product Designer Set Designer Event Planner Urban Planner These roles span various industries and offer career growth for Vectorworks-trained designers in fields like architecture, engineering, entertainment, and more. Tailored Vectorworks Training Our Vectorworks courses are customized to your needs, offering 1-2-1 sessions that adapt content to your expertise, experience, and project requirements. Whether in class, onsite, or via live online sessions, these bespoke courses ensure optimal learning outcomes. Course Overview Begin your journey into Vectorworks, unlocking the potential for digital 2D and 3D visualization in interior design, architecture, 3D modeling, and landscaping. Vectorworks, a user-friendly industry-standard software, is suitable for both PC and Mac users. Course Highlights Master proper drawing setup and utilize 2D drawing tools for professional plans and elevations. Navigate and leverage the built-in symbol library effectively. Transform 2D plans into fully rendered 3D perspectives with textures and lighting. Create a comprehensive project presentation print. (Note: This course does not cover complex curved shapes.) Tailored Training | Vectorworks Personalized One-on-One Guidance Flexible Learning Schedule Ongoing Post-Course Support Access to Extensive Learning Materials Recognition with a Certificate of Attendance Affordable Training Rates Assistance with Software Configuration Rewards for Referrals Special Group Training Discounts Convenient Hours to Suit Your Schedule Customized Courses for Your Animation Needs

Vectorworks Intermediate Training Course
Delivered in London or OnlineFlexible Dates
£558

Microsoft Access Advanced (live online classes)

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 1 year email support service Take a look at the consistent excellent feedback from our corporate clients 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 public, one to one, tailored and bespoke courses. Tailored in company training courses: 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. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? 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. Career path Career path Microsoft Office 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

Microsoft Access Advanced (live online classes)
Delivered OnlineFlexible Dates
£550

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

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Understand the Outlook interface Send and receive email messages Organise email messages Manage their calendar Manage their contacts Work with tasks and notes Customise Outlook ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients 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 public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: 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. Getting Started With Outlook Navigate the Outlook Interface Perform Basic Email Functions Use Outlook Help Composing Messages Create an Email Message Check Spelling and Grammar Format Message Content Attach Files and Items Enhance an Email Message Manage Automatic Message Content Reading and Responding to Messages Customise Reading Options Work with Attachments Manage Your Message Responses Managing Your Messages Manage Messages Using Tags, Flags, and Commands Organise Messages Using Folders Managing Your Calendar View the Calendar Manage Appointments Manage Meetings Print Your Calendar Managing Your Contacts Create and Update Contacts View and Organise Contacts Working With Tasks and Notes Create and manage Tasks Create and manage Notes Customising the Outlook Environment Customise the Outlook Interface Create and Manage Quick Steps Who is this course for? Who is this course for? This course is intended for the user who needs to learn how to use Microsoft Outlook to compose and send email, schedule appointments and manage contact information. Requirements Requirements General knowledge of the Windows OS

Microsoft Outlook Introduction - In-company (now with live online classes)
Delivered in London or UK Wide or OnlineFlexible Dates
£550

Microsoft Excel Advanced

By Microsoft Office Training

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

Microsoft Excel Advanced
Delivered OnlineFlexible Dates
£550