1179 Learning courses in London

Course Title: 3ds Max Night Training Program. Join our 3ds Max Evening Course for after-work convenience and guidance in 3D modeling. Personalized attention, and build an impressive portfolio. 3ds Max Courses & Classes Online and in-person in London. Click here for more info: Website Training Duration: 10 hours Learning Approach: 1-on-1 sessions and Customized content. Course Schedule: Reserve a convenient hour from 9 am to 7 pm, Monday to Saturday, to suit your schedule. I. Introduction to 3ds Max Course Overview Familiarization with the User Interface Basic Navigation and Settings II. Creating 3D Objects Formation of Primitive Objects Crafting Complex Shapes using Editable Poly Application of Modifiers to Objects Implementing Materials and Textures III. Lighting Introducing Light Sources in a Scene Different Types of Lighting Adjustment of Light Properties Creating Shadows IV. Camera Establishing Cameras and Camera Views Fine-Tuning Camera Settings Camera Animation Techniques V. Animation Fundamentals Keyframe Animation Techniques Utilizing the Time Slider and Track View Animation of Object Transformations Animated Materials and Textures VI. Rendering Configuration of Render Settings Selection of Output Format Batch Rendering Procedures Post-Processing Effects VII. Project-Based Learning Application of Learned Techniques in a Final Project Creative Problem-Solving for Project Completion In-Depth Course Outline: Modeling Techniques Edit Poly Modeling Extrusion, Chamfer, Cut, and Slicing Techniques Symmetry Mirror Modeling Designing Furniture (Tables and Chairs) Basic House Model Design Creating Lines and Shapes Importing Plans from AutoCAD/Vectorworks Interior Space Design Doors, Windows, Railings, Trees, and Stairs Modifiers Compound Objects (Connect, Scatter, Pro Boolean, Loft, Terrain) Bend, Taper, Twist, Stretch, Skew, FFD, Wave, and Ripple Lattice and Lathe Techniques 3ds Max Basic Lighting Omni Light Spot Light Direct Light 3ds Max Camera Techniques Free Camera Target Camera Texturing and Rendering Diffuse and Bump Mapping Incorporating Environment and Background Images Rendering Images with Advanced Lighting in 3ds Max For a hands-on experience, access a free 30-day trial of 3ds Max, a robust 3D modeling and rendering software for design visualization, games, and animation, via Autodesk's official website. Download 3ds max. Autodesk Download a free 30 day trial of 3ds Max, 3D modelling and rendering software. Learning Outcomes after 3ds Max: Advanced 3D Skills: Master intricate 3D modeling, animation, and rendering techniques. Project Experience: Apply skills to real-world projects, building a professional portfolio. Problem-Solving: Develop critical thinking for complex design challenges. Potential Jobs: 3D Modeler: Create detailed 3D models for various industries. Character Animator: Animate lifelike characters for entertainment media. Architectural Visualizer: Produce realistic architectural renders. Interior Designer: Visualize and present interior designs. Game Environment Artist: Design immersive game environments. Product Visualization Specialist: Render detailed product visuals. Visual Effects Artist: Create stunning visual effects for film/TV. Freelance 3D Artist: Take on diverse projects as an independent professional. Details: Duration: 10 Hours of Comprehensive Training Focus: Advanced 3D Modeling, Animation, and Rendering Techniques Learning Format: Personalized One-on-One Sessions for Maximum Attention Availability: Flexible Scheduling, Monday to Saturday, 9 am to 7 pm Instructors: Certified Experts and Industry Professionals Materials: Certificate of Completion and Extensive Training Guides Interactive Learning: Live Feedback Sessions and Access to Recorded Classes Support: Lifetime Email and Phone Assistance for Continued Learning Special Benefits: Competitive Rates, Referral Discounts, and Assistance with Software Installation This intensive 3ds Max Masterclass provides advanced training in 3D design and animation, ensuring personalized attention, interactive learning, and lifelong support for your creative journey. Personalized Instruction: Skilled trainers provide tailored one-on-one coaching, meeting your unique learning requirements. Practical Learning: Participate in hands-on demonstrations, strengthening skills applicable in design, gaming, and film industries. Comprehensive Materials: Obtain a Certificate of Attendance and detailed guides for continuous reference. Interactive Engagement: Engage in live sessions with tutors, gaining valuable feedback and access to session recordings. Flexible Learning: Choose between online or in-person sessions, aligning with your schedule and preferences. Value and Support: Benefit from competitive rates, referral discounts, and lifelong assistance via email and phone. Seamless Start: Get help with software installation, ensuring a smooth and hassle-free learning experience.

Managing Stress in Challenging Times This course looks at the symptoms and causes of stress and how these affect us emotionally, behaviorally, and physically. You will learn some simple stress-busting techniques that will have a positive influence on your beliefs and behaviors around stress. You will also have the opportunity to develop a personal action plan which will serve as an ongoing reference point for dealing with pressure in its many forms - home, family, social, and work. What You Will Learn At the end of this program, you will be able to: Recognize the symptoms and causes of stress Manage and reduce the effects of stress in your life with simple stress-busting techniques Create a simple personalized plan to manage stress and promote a healthier, happier, and more productive lifestyle Getting Started Foundation Concepts What is stress? Why stress matters Flight or fight response and role of hormones Work-Life Balance How to create balance and set boundaries Learning how to say 'no' Stress-Reduction Techniques Visualization and relaxation techniques Behaviors and beliefs Putting things in perspective Circle of influence (vs. circle of control) Slowing down Be Responsible and Kind to Yourself Basic human needs Honest communication Your responsibility to yourself and others Calming thoughts

Why choose Vectorworks Garden Design Training Course? Vectorworks, a user-friendly industry-standard software, is perfect for interior design, architectural planning, 3D modeling, and landscaping projects. Its versatility makes it suitable for both home enthusiasts and professionals. Course Info 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 face-to-face sessions and live online instruction. Vectorworks Garden Design Training Course: Master the art of garden design with Vectorworks software in our specialized training program. Led by certified tutors and industry experts, this course equips you with comprehensive skills and techniques tailored to garden design. Create stunning 2D layouts and 3D landscapes, visualize designs, and produce professional documentation for your projects. Benefits: In-Person and Live Online Options: Choose between in-person or live online sessions for flexible learning. Certified Tutors and Experts: Learn from experienced tutors passionate about garden design. Comprehensive Curriculum: Cover essential aspects of garden design using Vectorworks. Lesson Recordings: Access valuable session recordings for review and reinforcement. Lifetime Email Support: Receive ongoing assistance from industry experts for continuous growth. Course Duration: 16 hours Course Description: This advanced Vectorworks course is tailored for individuals who already possess basic knowledge of the software and wish to enhance their skills to become proficient users. Participants will learn more advanced 2D and 3D techniques, including advanced 3D modeling, rendering, visualization, and customizing Vectorworks to suit their specific needs and workflows. The course will cover topics such as creating custom tools, working with planting plans, and integrating with AutoCAD. Course Outline: Module 1: Vectorworks Interface and Basic Concepts - Understanding the Vectorworks interface and palettes - Opening, saving, and managing files - Creating and editing objects and shapes - Utilizing Undo/Redo and Snaps for precision - Applying graphic attributes and working with dimensions Module 2: Modeling and Drawing Techniques - Exploring advanced tools and commands in detail - Integrating with AutoCAD and data exchange - Creating, modifying, and editing text - Utilizing callout text tool for annotations - Organizing information using design layers and classes Module 3: Working with Buildings and Models - Utilizing design layers and sheet layers for architectural projects - Assigning objects to layers and classes - Working with viewports and sheet layers for presentation - Drawing buildings, including walls and roofs - Setting up and rendering perspective views Module 4: Creating Site and Landscape Plans - Importing land surveys or architects' files - Drawing site surveys and working with hard landscape elements - Adding and customizing plantings using the plant tool - Editing plant definitions and creating custom plant symbols - Generating plant schedules and reports Module 5: Vectorworks Architect Features - Setting up files and scaling the drawing - Customizing text styles and dimension standards - Working with scanned images and creating site models - Designing floors, doors, and windows using standard Vectorworks elements - Creating and managing title blocks, labels, notes, and keynotes Module 6: Working Drawings and Final Project - Developing the final project with 2D and 3D elements - Applying site modifiers and stairs to the design - Generating printing layouts for presentations - Creating working drawings with detailed plans and elevations Download Vectorworks Trial https://www.vectorworks.net/trial Proficiently use Vectorworks software for garden design, including creating accurate site plans and garden layouts. Apply 2D and 3D modeling techniques to visualize garden designs and present them professionally. Incorporate plants, hardscape elements, and other design elements into garden layouts effectively. Generate detailed construction drawings for seamless implementation of garden projects. Understand the key features and functionalities of Vectorworks specific to garden design. Demonstrate proficiency in utilizing Vectorworks tools for various garden design tasks. Interact collaboratively in face-to-face or online learning environments, engaging with instructors and peers. Utilize lesson recordings to review and reinforce course concepts for continuous learning. Seek personalized guidance and assistance through lifetime email support from certified tutors and industry experts. Transform creative garden design ideas into practical and stunning real-world projects using Vectorworks software.

Aqualyx is one of the leading brands that is used for fat dissolving. Aqualyx can be used on the face and body to great effect. Just one session can dramatically reduce fat deposits and return a more youthful and defined facial contour for small areas such as the jowls and chin. For larger areas like tummies, bingo wings and bums, clients may need up to 5 sessions to see dramatic results. Aqualyx & Deso are water-based solutions injected into the fatty tissue, surround the cells and destroy them. The remains of the fat cells are then excreted by the body safely as waste. Aqualyx is used for people who want to get rid of stubborn areas of fat in their faces and bodies and is clinically proven for these purposes. Course Entry Requirements: This course is suitable for both medics and non-medics. You can enrol on this training course if you meet one of the following:  NVQ Level 3 in beauty therapy, ITEC or HND Medically qualified as a nurse, doctor or dentist with current registration with the NMC, GMC or GDC. 12 Months of Needling Experience or 6 Months of Needling Experience and Anatomy & Physiology Level 3 or Above. Course Structure: 20 hours of pre-study E-learning and 1 practical training Course Agenda: Areas covered within the course: Anatomy and physiology of the skin and tissues Infection control Sharps and hazardous waste training First aid and anaphylaxis training Pre-study fat-dissolving theory training Practical training Clinical set up Professional live demonstrations Course Benefits Benefits for Students Specialised Training: Our course provides specialised training in Aqualyx and Deso fat dissolving treatments. You will learn the techniques, protocols, and safety considerations involved in these procedures. This specialised training will enhance your skill set and allow you to offer advanced fat dissolving treatments to your clients. Practical Experience: We prioritise hands-on learning to ensure that you gain practical experience in administering Aqualyx and Deso fat dissolving treatments. Under the guidance of experienced instructors, you will have the opportunity to practice these procedures on models. This practical training will increase your confidence and competence in performing the treatments effectively. Expanded Service Offering: By enrolling in our training course, you will expand your service offering as an aesthetics practitioner. Aqualyx and Deso fat dissolving treatments are highly sought after by clients who want to target localised fat deposits non-surgically. Adding these treatments to your repertoire will attract new clients and provide existing clients with more comprehensive solutions. Professional Advancement: Completing our Aqualyx & Deso Fat Dissolving Training Course will contribute to your professional advancement. You will gain in-depth knowledge about fat dissolving treatments, build expertise in these procedures, and enhance your professional credibility. This can lead to career growth opportunities, such as working in reputable clinics, establishing your own practice, or even training other professionals in the field. Benefits for Clients Targeted Fat Reduction: Clients seeking Aqualyx and Deso fat dissolving treatments desire targeted fat reduction in specific areas of their body. By enrolling in our training course, you will acquire the skills to accurately assess and administer these treatments, effectively helping clients reduce unwanted fat deposits in a non-surgical manner. Non-Invasive Solution: Aqualyx and Deso fat dissolving treatments provide a non-invasive alternative to surgical procedures for fat reduction. Clients benefit from a less invasive approach that involves fewer risks, minimal downtime, and reduced recovery periods. Offering these non-invasive treatments can attract clients who prefer a non-surgical solution to their aesthetic concerns. Customised Treatment Plans: As a trained practitioner, you will be able to create customised treatment plans for your clients. By assessing their unique needs and goals, you can develop tailored protocols and treatment strategies. This personalised approach ensures that clients receive individualised care and optimal results. Earning Potential The demand for Aqualyx and Deso fat dissolving treatments continues to grow. By enrolling in our training course and becoming proficient in these procedures, you can significantly increase your earning potential. Clients are willing to invest in effective fat reduction treatments, and as a skilled practitioner, you can attract a larger clientele and set competitive pricing for your services. Satisfied clients often become repeat customers and refer others, further boosting your earning potential. Enrolling in our Aqualyx & Deso Fat Dissolving Training Course not only benefits you as a student but also provides valuable advantages for your clients and potential earning potential in the aesthetics industry. Take the opportunity to expand your expertise and offer innovative solutions to clients seeking fat reduction treatments. Frequently Asked Questions Is this course suitable for beginners or those with prior experience? Aqualyx & Deso Fat Dissolving Training Course is designed for aesthetics practitioners who already have a foundation in basic injection techniques and experience in the field. Prior experience in administering injections is essential to enrol in this advanced course. Will I receive a certification upon completion? Yes, upon successfully completing our training course, you will receive a certification in Aqualyx & Deso Fat Dissolving. This certification acknowledges your advanced skills and expertise in administering these fat dissolving treatments. It can enhance your professional reputation and provide a competitive edge in the aesthetics industry. What topics are covered in the course curriculum? Our course curriculum covers various topics related to Aqualyx and Deso fat dissolving treatments. These include product knowledge, patient selection and assessment, injection techniques, treatment protocols, managing complications, and post-treatment care. The curriculum is designed to provide you with a comprehensive understanding of the Are there any hands-on training opportunities? Yes, our Aqualyx & Deso Fat Dissolving Training Course includes hands-on training sessions. Under the supervision of experienced instructors, you will have the opportunity to practice and refine your skills in administering these fat dissolving treatments. This practical experience is vital for your professional development. Will I have access to ongoing support after completing the course? Absolutely! We provide ongoing support to our students even after they complete the training course. Our instructors and support staff are available to answer any questions, provide guidance, and offer assistance as you navigate your career in Aqualyx and Deso fat dissolving treatments. We are committed to supporting your continued growth and success. Are there financing options available for the course? We offer flexible payment options and financing plans to make our Aqualyx & Deso Fat Dissolving Training Course more accessible. Please reach out to our admissions team for detailed information on available payment options and financing plans.

Overview Appreciative Inquiry is a form of action research that collects people’s stories of best practices. We can use these best practices as a way to initiate organisational change. This course will guide attendees through the process of Appreciative Inquiry (AI) and give them the techniques to succeed in using the AI system. This course will benefit anyone that leads change and wants to create positive dialogue that leads to improvements within their organisation. Description David Cooperrider, Suresh Srivastva, and their colleagues at Case Western Reserve University developed AI in the 1980s. According to them, the aim of Appreciative Inquiry is to help the organisation in: Envisioning a collectively desired future Realising that vision in ways that successfully translate intention into reality and beliefs into practices The AI approach can be applied in almost all groups of people and once the process starts, the change is put in motion. The appreciative approach works in individual conversations among colleagues, managers and employees. AI consultants around the world are increasingly using an appreciative approach to bring about collaborative and strengths-based change. This course will provide attendees with the means to effectively develop the skills of managers for the benefit of their organisation. They will be taken through the full process of appreciative inquiry; developing a wide understanding of the tools and techniques required to effectively improve communication and affect change. What can Appreciative Inquiry achieve? Well, just imagine you were better able to: Solve problems within an organisation in a positive and forward-thinking way. Be more curious and excited about the challenges faced within the business. Ask unconditional, positive questions to strengthen the organisations capacity to increase potential. Approach change in an affirmative mindset. Use questions to create movement and change within the company. Simply apply core communication skills, for overall organisational success Topics covered: What is Appreciative Inquiry? – A review of the subject with an activity that helps embed understanding and a case study that explains the process in action. Benefits of Appreciative Inquiry to the Organisation – Establishing how AI can aid and improve the way an organisation works and how people communicate within it. Exploring how specific organisational issues can be viewed positively. Appreciative Inquiry Questions – Understanding how questions can be used to identify positive organisational improvements and refocus our approach to business issues. Appreciative Inquiry Interviews – A set process for performing AI interviews and framing consultations to get the best out of those involved. A chance to practice the given approach and hone personal skills. The 4D Model – An overview of the AI 4D Model (Discovery, Dream, Design, Destiny) and how it is applied. The 4D Model: Topic – Demonstrating how selecting the topic is the beginning of the 4D model process. Choosing the participants own topic to work on throughout the training. The 4D Model: Discovery – Showing how positive discussions are kick-started at this stage and taking a chance to look at, ‘the best there is and what has been’. The 4D Model: Dream – ‘Thinking big and beyond what they have in the past’. Creating an amazing and positive vision for the future. The 4D Model: Design – Laying the foundation with a design of the vision, principles, and set of propositions that describe the ideal end state. Defining the desired state by creating a hierarchy and blueprint for success. The 4D Model: Destiny – Defining clear actions that will help the organisation and individuals achieve what they have set out to. The output is the self-reinforcing nature of using positive and affirmative inquiry to improve the business. The 4D Model: Summary Task – Review of learning and knowledge check. The Change Process – Exploring Dr. Kotter’s 8-step change process and how it can support the AI approach. Rooms of Change – Understanding feelings and attitudes to change, using this interesting and memorable model. Using an activity to help participants consider their own ‘change position’ and what this might mean for them. Strategies for Managing Change – A simple set of skills to help overcome the challenges faced by people trying to implement change. Applying these strategies to the 4D Model and Appreciative Inquiry. Recall Quiz – A chance to review learning in an engaging way. Summary – Developing actions and key points to take away. Who should attend Managers who want to learn about and practice the Appreciative Inquiry approach to drive positive changes. Requirements for Attendees None.

Why choose Vectorworks Landmark Training Course? Course info Explore the Vectorworks Landmark Training Course! 1-on-1 Live Online sessions led by certified tutors and industry experts. Master Vectorworks Landmark for landscape and site design, creating captivating outdoor spaces. Enroll now to unleash your design skills. Duration: 16 hrs. Method: 1-on-1, Personalized attention. 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. This course focuses on Vectorworks Landmark fundamentals, providing essential tools and techniques for landscape architecture, design, and related disciplines. Participants should have a basic understanding of Vectorworks software. The course covers 2D and 3D drawing, file organization, landscape plan/model creation, and more. Learning Objectives: Organize drawing files using industry standards and best practices for effective collaboration. Utilize imported files and field-collected data for base plans and site inventories. Integrate 2D and 3D elements for plan documentation and model analysis. Utilize worksheet features for material quantification and project efficiency. Course Prerequisites: Participants should be familiar with basic drafting concepts, computer operations, and keyboard shortcuts. This training demonstrates sustainable design principles and the use of CAD tools for erosion control, runoff calculations, plant tracking, and sun/shade analysis. Participants will learn to create a 3D site digital terrain model and assess proposed plantings' effects on solar heat gain and water usage. Vectorworks Landmark Basic to Intermediate Training Course Duration: 16 hours Join our comprehensive Vectorworks Landmark Basic to Intermediate Training, designed for landscape architects and designers. Master 2D and 3D landscape design with essential techniques, covering site analysis, plans, irrigation, and 3D visualization. Unleash your creativity with custom plant symbols and detailed planting plans using the plant database. Course Outline: I. Introduction to Vectorworks Landmark (1 hour) An overview of Vectorworks Landmark for landscape design Interface orientation and basic tool usage Navigation and viewport controls Landscape design project creation and management II. Site Analysis and Site Plans (3 hours) Collecting site information and producing site analysis drawings Crafting site plans and hardscape design Working with contours, elevations, and terrain models Incorporating site amenities like paths, fences, and walls III. Planting Plans (5 hours) Utilizing the plant database to select suitable plants for specific regions Creating personalized plant symbols Developing comprehensive planting plans and plant lists Understanding plant compatibility and growth patterns IV. Irrigation Design (2 hours) Designing and editing irrigation systems and zones Integrating irrigation components into the site plan Generating irrigation reports for efficient planning V. 3D Visualization (3 hours) Creating captivating 3D models of landscape designs Applying textures and materials to hardscape elements and plants Utilizing the Renderworks engine for high-quality rendering Enhancing designs with lighting and special effects VI. Customization (1 hour) Tailoring the interface for landscape design efficiency Creating custom object styles and resource libraries VII. Collaboration and Sharing (1 hour) Importing and exporting data from other software platforms Sharing landscape design drawings with colleagues and collaborators VIII. Conclusion and Next Steps (1 hour) Comprehensive review of course content Guidance on further learning resources Q&A session and feedback gathering Enroll in our Vectorworks Landmark Basic to Intermediate Training to enhance your landscape design expertise and unleash your creative prowess. Download Vectorworks Landmark https://www.vectorworks.net/en-GB/landmark By the end of the Vectorworks Landmark Training Course, participants will: Understand the key features and functionalities of Vectorworks Landmark for landscape design. Demonstrate proficiency in using essential tools for site analysis, site plans, and hardscape design. Create detailed planting plans, selecting appropriate plants, and understanding their compatibility and growth patterns. Design efficient and effective irrigation systems, including generating irrigation reports. Create 3D visualizations of landscape designs, applying textures, materials, lighting, and special effects. Customize the interface and create personalized object styles and resources. Collaborate and share landscape design drawings with other software users. Have the foundation to pursue further learning and exploration in landscape design using Vectorworks Landmark.

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

Learn CAD in 10 hrs

Sewing machine class for absolute beginners. The class will cover setting up a machine, learning about thread, bobbins, needles, feet, fabric, basic maintenance, tools, making seams and hems, understanding seam allowances, and you will create a cushion cover to take home with you.

InDesign face to face training customised and bespoke.