2639 Courses delivered Live Online

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

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. 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 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 Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk 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 trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' 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 classroom, 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. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? 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. Requirements Requirements Preferably, delegates should have attended the Excel Advanced 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

Duration 2 Days 12 CPD hours This course is intended for Professionals desiring to be able to communicate clearly and concisely in their writing will benefit from this course. Overview Awareness of common spelling and grammar issues in business writing. Basic concepts in sentence and paragraph construction. Basic structure of agendas, email messages, business letters, business proposals, and business reports. Collaborative writing techniques, tools and best practices Tips and techniques to use when deciding the most appropriate format to use for agendas, email messages, business letters, business proposals, and business reports In this course, you will learn the essential skills needed to organize your thoughts and select the best words and phrases to clearly convey them in writing. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. 1. Working With Words Monitoring Spelling, Grammar, and Verb Tense Creating a Reference Sheet 2. Constructing Sentences Recognizing Sentence Parts Classifying Sentence Type Increasing Readability with Punctuation 3. Creating Paragraphs The Three Basic Components Organization Methods 4. Finding Facts Identifying and Using Key Resources Fact-Finding and Information Gathering 5. Collaborative Writing Clarifying the Objective Collaborative Writing Strategies and Patterns 6. Types of Collaborative Business Writing Applying Different Construction Techniques Cut & Paste, Puzzle, Sequential Summative Integrating Construction 7. Collaborative Tools and Processes Planning and Revision Creating Outlines and Storyboards Building Team Cohesion 8. Writing Meeting Agendas Choosing an Agenda Format Structuring and Writing the Agenda 9. Writing E-Mails, Reports and Proposals Addressing Your Message Using Proper Grammar and Defining Acronyms Structuring, Formatting, and Writing Your Report Additional course details: Nexus Humans Writing for the Business Professional training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the Writing for the Business Professional 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. 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.

Why Learn Revit and 3dsMax V-Ray Visualization Basic to Advance Training Course? Course info Master architectural visualization and photorealistic renderings. In-person or live online options available. Learn Revit and 3dsMax, V-Ray rendering, and advanced techniques. Hands-on projects for real-world experience. Duration: 40 hrs Method: 1-on-1 - Individual support. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. Comprehensive Training: Master Revit, 3dsMax, and advanced visualization techniques for exceptional results. V-Ray Rendering: Explore realistic rendering with V-Ray, including advanced techniques and materials. Real-World Projects: Work on industry-relevant projects for a professional portfolio. Flexible Learning: Choose in-person or live online sessions for an engaging experience. Lesson Recordings: Access recorded classes to reinforce your understanding. Lifetime Email Support: Get guidance and assistance from experienced instructors beyond the course duration. Autodesk Certified Instructors. Comprehensive Training: Master Revit, 3dsMax, and advanced visualization techniques for exceptional results. V-Ray Rendering: Explore realistic rendering with V-Ray, including advanced techniques and materials. Real-World Projects: Work on industry-relevant projects for a professional portfolio. Flexible Learning: Choose in-person or live online sessions for an engaging experience. Lesson Recordings: Access recorded classes to reinforce your understanding. Lifetime Email Support: Get guidance and assistance from experienced instructors beyond the course duration. Autodesk Certified Instructors. Part 1: Revit (16 hours) Module 1: Introduction to Revit Familiarizing with the Revit interface and workspace Embracing the Building Information Modeling (BIM) workflow Creating a fundamental building model as a starting point Module 2: Basic Modeling in Revit Working with essential elements such as walls, doors, and windows Constructing floors and roofs to complete the building structure Crafting functional and visually appealing stairs and railings Module 3: Advanced Modeling in Revit Delving into the creation and manipulation of families Utilizing parameters and constraints to enhance modeling efficiency Exploring intricate geometries for complex designs Module 4: Annotation and Documentation in Revit Enhancing project documentation by adding text and dimensions Generating informative schedules for better project management Mastering the printing and exporting processes for professional output Part 2: 3ds Max (16 hours) Module 1: Introduction to 3ds Max Navigating the 3ds Max interface and workspace Understanding the 3D modeling workflow for design visualization Initiating the creation of basic 3D models Module 2: Basic Modeling in 3ds Max Working with primitive shapes to build foundational models Creating and refining splines to form versatile shapes Advancing to complex 3D model development for intricate designs Module 3: Materials and Textures in 3ds Max Exploring the material editor and its functionalities Skillfully applying and adjusting materials for realistic renders Incorporating textures to add depth and detail to the models Module 4: Lighting and Cameras in 3ds Max Mastering the art of lighting creation and manipulation Utilizing the daylight system for enhanced realism Understanding cameras and perspectives for compelling visual storytelling Part 3: V-Ray (8 hours) Module 1: Introduction to V-Ray Getting acquainted with the V-Ray interface and workflow Exploring V-Ray materials and textures for high-quality renders Module 2: Lighting and Rendering in V-Ray Creating and refining lighting setups for stunning renders Utilizing global illumination to enhance the realism of scenes Implementing advanced rendering techniques for professional output Module 3: Materials and Textures in V-Ray Crafting and modifying V-Ray materials for realistic surfaces Applying V-Ray textures to add depth and realism to objects Utilizing V-Ray displacement maps for intricate details For 3ds Max free trial, visit: https://www.autodesk.co.uk/products/free-trial. To access the V-Ray free trial, visit: https://www.chaosgroup.com/. Start your journey to becoming a proficient designer and renderer in the world of 3D modeling and visualization. Download Revit Revit and 3dsMax V-Ray Visualization Basic to Advance Training Course: Proficient Software Skills: Acquire a strong command of Revit and 3dsMax, along with advanced techniques in V-Ray rendering. High-Quality Visualizations: Create realistic and visually stunning architectural visualizations using V-Ray. Architectural Modeling: Master the process of modeling architectural elements with precision and efficiency. Materials and Textures: Understand how to apply realistic materials and textures to enhance visualizations. Lighting Setup: Set up lighting environments to achieve optimal illumination and ambiance in renderings. Rendering Techniques: Explore advanced rendering techniques, including global illumination, caustics, and ambient occlusion. Real-World Projects: Complete industry-relevant projects to build a professional-grade portfolio. Problem-Solving Skills: Develop the ability to troubleshoot and resolve rendering challenges effectively. Efficient Workflows: Learn time-saving workflows and best practices for efficient visualization production. Portfolio Showcase: Showcase your newly acquired skills through a diverse range of visualizations.

Crafting Dental Excellence: A Comprehensive Journey Backed by City and Guilds Kickstart your transformative journey in dental care with Cavity Training’s Level 3 Diploma in Dental Nursing. Endorsed by City and Guilds, this 11-unit course is meticulously curated by industry stalwarts, providing a harmonious fusion of in-depth theoretical knowledge and tangible hands-on experience. Spanning 18-24 months, the programme immerses you in our interactive virtual classroom, punctuated with in-workplace assessments and culminating in a final exam. Whether you’re charting a new career path or seeking to amplify your stature in dental healthcare, our diploma offers a robust foundation, empowering you to flourish in any dental setting. Learn about the Cavity Training Dental Nurse Course Here at Cavity we have built a reputation on trust and reliability. In recent years the industry needs have shifted and we have had to think of more ways to help our much-loved clients. With huge deficits in the nursing field we have developed a course in partnership with City and Guilds which surpasses all the criteria needed to ensure a fulfilling career in Dental Nursing. One Course Fee The cost is £2500. You can either pay as a lump sum or alternatively, you can split into 12 installments of £209. One to One Contact As well as an online e-portfolio, each student will have a designated assessor assigned to them who will support them through the course as well as in-surgery visits. Full E-library included Exclusively to Cavity Training we have the full e-Library of over 40 textbooks with all the resources you need for your coursework. BADN Membership FREE student membership to The British Association of Dental Nurses (BADN) once you start your training with us. 100+ Years Experience We have 33 assessors and tutors across the country with a vast amount of experience between them. Backed by City & Guilds Cavity Training has worked hard to gain accreditation from City and Guilds and are proud to be working with them. How we compare with our competitors? Don't just take our word for it, here is what our staff think Bridget I did my course years ago. It was classroom based one night per week. I think I would prefer to be more ‘hands on’ like it is now. Cavity really are a great company to work for. I truly believe that there expertise will ensure the next generation are amazing! Gina I did mine over an apprenticeship but the company my employer used wasn’t great and I didn’t get much support. Although I passed I can only imagine the length that Cavity have gone to to ensure that the students feel supported. As an employee, its super! Enquire Today

During this 2 day course, you will develop a learning-based action plan to use in your workplace ensuring that you can put the learning into action.

During this 2 day course, you will develop a learning-based action plan to use in your workplace ensuring that you can put the learning into action.

During this 2 day course, you will develop a learning-based action plan to use in your workplace ensuring that you can put the learning into action.

Who is this course for? This course is ideal for individuals interested in learning landscape architecture, emphasizing the planning, design, and management of various outdoor spaces, such as private gardens, public parks, and commercial landscapes. Click here for more info: Website 1-on-1 training, Monday to Saturday, 9 a.m. to 7 p.m., or call to book. Tailor your 40-hour course  Option A: AutoCAD, Sketchup, Vray, and Photoshop.  Option B: Rhino, Sketchup, Vray, and Photoshop. Both covering specializes in Planting Plans and Maps. Course Outline - Option A: AutoCAD, Sketchup, Vray, Photoshop (Total: 40 hours) AutoCAD (10 hours): Module 1: Introduction to AutoCAD (2 hours) - Overview of AutoCAD interface and tools - Creating, opening, and saving drawings - Basic drawing and editing commands Module 2: Drawing and Editing (3 hours) - Working with lines, circles, and arcs - Utilizing polylines and polygons - Modifying objects: Move, Copy, Rotate, and Scale Module 3: Precision Drawing (3 hours) - Using coordinate systems for precision - Dimensioning and text incorporation - Hatching and gradients for added detail Module 4: Advanced Tools (2 hours) - Leveraging blocks and attributes - Managing layers and object properties - Creating layouts and preparing for plotting Sketchup (16 hours): (Specializing in Planting Plans, Vegetation Plans, and Maps) Module 1: Introduction to Sketchup (2 hours) - Navigating the Sketchup interface - Grasping basic 2D and 3D modeling concepts - Creating and manipulating objects Module 2: Advanced Modeling (6 hours) - Model intricate garden elements with curves and surfaces - Expertly edit and transform geometry - Specialized focus on Planting Plans, Vegetation Plans, and Maps Module 3: Visualization with Vray (4 hours) - Understanding the Vray rendering engine - Applying materials and textures for realism - Setting up lighting and cameras for realistic rendering Module 4: Image Enhancement with Photoshop (10 hours): - Introduction to Photoshop for design purposes - Editing and enhancing Sketchup and Vray outputs - Creating visually striking presentations Additional Resources: Access free online portfolio design assistance, career growth guidance, and mock interviews to ensure your readiness for the competitive job market. Course Outline - Option B: AutoCAD, Rhino, Vray, Photoshop (Total: 40 hours) AutoCAD (12 hours): Module 1: Introduction to AutoCAD (2 hours) - Overview of AutoCAD interface and tools - Creating, opening, and saving drawings - Basic drawing and editing commands Module 2: Drawing and Editing (3 hours) - Working with lines, circles, and arcs - Utilizing polylines and polygons - Modifying objects: Move, Copy, Rotate, and Scale Module 3: Precision Drawing (3 hours) - Using coordinate systems for precision - Dimensioning and text incorporation - Hatching and gradients for added detail Module 4: Advanced Tools (4 hours) - Leveraging blocks and attributes - Managing layers and object properties - Creating layouts and preparing for plotting Rhino (14 hours): Module 1: Introduction to Rhino (2 hours) - Navigating the Rhino interface - Grasping basic 2D and 3D modeling concepts - Creating and manipulating objects Module 2: Advanced Modeling (6 hours) - Model intricate garden structures with curves and surfaces - Proficiently edit and transform geometry - Build complex 3D structures Module 3: Visualization with Vray (6 hours) - Setting up lights and cameras for garden renders - Exploring rendering settings and options - Post-production and compositing techniques Image Enhancement with Photoshop (8 hours): - Introduction to Photoshop for design purposes - Editing and enhancing Rhino and Vray outputs - Creating visually striking presentations Both Option A and Option B provide comprehensive training in essential design software, with the choice between specialization in Sketchup (Option A) or a broader skill set with Rhino (Option B). Additionally, both options offer access to valuable resources for career preparation. When Can I Book this Training Course? Personalized 1-on-1 training sessions available, allowing for a tailored learning experience. Pre-book your preferred time slot from Monday to Saturday between 9 a.m. and 7 p.m. Alternatively, call 02077202581 to book over the phone. Training Duration 40-hour training program, with the flexibility to split hours based on your ideal learning schedule. Training Method Choose between in-person Face to Face or Live Online 1-on-1 training. Expect personalized attention, flexible learning pace, and individualized support throughout your training. Live Online sessions available over Zoom for added convenience. Enroll in our 1-on-1 Course Today! Comprehensive Training Program Overview Option A: AutoCAD (10 hours) Sketchup (16 hours) (Specializing in Planting Plans, Vegetation Plans, and Maps) Vray (4 hours) Photoshop (10 hours) Option B: AutoCAD (12 hours) Rhino (14 hours) Vray (6 hours) Photoshop (8 hours) Benefits of Option A: Diverse Skillset: Gain expertise in AutoCAD, Sketchup, Vray, and Photoshop for various design fields. Specialization: Focus on Planting Plans, Vegetation Plans, and Maps within Sketchup. Realistic Renderings: Learn Vray for compelling 3D renderings. Image Editing: Enhance images effectively with Photoshop. Career Readiness: Access resources like portfolio design assistance and mock interviews for job market readiness. Benefits of Option B: Versatile Expertise: Master AutoCAD, Rhino, Vray, and Photoshop for various design disciplines. Advanced 3D Modeling: Excel in complex designs with Rhino and 3ds Max. Quality Renderings: Create impressive 3D renderings with Vray. Image Editing Mastery: Perfect design concepts with Photoshop. Additional Training Course Benefits: Compatible with both Mac and Windows operating systems. Price Assurance for exceptional value. Flexible scheduling from Monday to Sunday, 9 am to 8 pm. Lifetime Email and Phone Support. Assistance in configuring your computer for seamless software installation. Referral Benefits, including special discounts for friend referrals and savings on group training courses.

Duration 2 Days 12 CPD hours This course is intended for Anyone desiring to improve their ability to speak self-assuredly, in front of both internal and external groups will benefit from this course. Overview Understand what separates an effective presentation from an ineffective presentation. Design a proficient presentation geared toward their audience. Create powerful slides that enhance the address. Enhance their public speaking skills with tips and techniques used by professional speakers. Prepare mentally for their best performance. Engage their audience more effectively and with greater passion. Whether speaking publicly or to a specific audience, your ability to build, develop and deliver a purposeful presentation is key to being able to convey your message and achieve your desired results. From open to close, it is crucial to learn the tools necessary to maintain engagement and to organize ideas to create coherent and convincing oral presentations. In this course, you will learn strategies to structure and develop presentation content focused on audience need and key points, identifying the areas in which you are most polished, as well as picking up hints and tips to address any gaps. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. 1. Foundation, Structure, and Organization Why a presentation The difference between effective and ineffective presentations Delivering passion and value Structure determines success 2. Creating the Basic Structure Building the backbone Capturing audience attention Understanding your audience 3. Organizing Your Program Planning analog Creating the topic outline Fact-Finding 4. Designing and Building Your Presentation Choosing proper content Building and writing Your presentation Slide design 5. Delivering Your Presentation Preparing mentally Appearing confident in front of the crowd 6. Engaging Your Audience from Start to Finish Understanding and matching learning styles Closing Your presentation and providing calls to action Additional course details: Nexus Humans The Art of Effective Presentations (Second Edition) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the The Art of Effective Presentations (Second Edition) 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. 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.