257 Courses in London

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 from our growing 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. 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

Who is this course for? The Architecture and Interior Design course is ideal for individuals aiming to master both interior design and architecture. Guided by certified tutors from Autodesk and Adobe, students will gain comprehensive skills in these fields. Click here for more info: Website Duration: 40 hours.1-on-1 Training. In-Person or Live online. When can I book: 9 am - 7 pm (Choose your preferred day and time once a week). Flexible timing with advance booking Course Features: Compatibility: Our training courses are compatible with both Mac and Windows operating systems, ensuring accessibility for all users. Price Assurance: We guarantee the best value for your investment, ensuring competitive pricing for high-quality training. Personalized Training: Benefit from one-on-one training sessions tailored to your specific needs and skill level, ensuring a personalized learning experience. Flexible Scheduling: Enjoy the flexibility to choose your preferred training time and day. Sessions are available seven days a week, from Monday to Sunday, between 9 am and 8 pm, accommodating your busy schedule. Lifetime Support: Receive lifetime email and phone support, ensuring that you have access to assistance even after completing the course. Technical Assistance: Get help with configuring your computer for software installation, ensuring a smooth learning experience without technical hurdles. Referral Discounts: Earn special discounts when you refer a friend to our courses, making learning a rewarding experience for you and your network. Group Training Savings: Avail significant savings on group training courses, encouraging collaborative learning and making education more accessible for groups. When can you schedule this Training Course? Personalized training experience with our flexible 1-on-1 sessions. Design your own timetable by pre-booking a convenient hour of your choice, available from Monday to Saturday between 9 a.m. and 7 p.m. Alternatively, you can call 02077202581 to book over the phone. How long is the training? The course spans 40 hours, which you can divide over as many days as needed to fit your ideal schedule. What's the teaching method? Our sessions are 1-on-1, offered either in-person face to face or live online. You'll receive personalized attention, tailored content, a flexible learning pace, and individual support. Live online 1-on-1 sessions over Zoom are also an option. What will you learn? In this comprehensive training program, you'll gain proficiency in a thoughtfully curated selection of software tools. Option A: AutoCAD (13 hours) SketchUp (10 hours) Vray (6 hours) Photoshop (6 hours) InDesign (5 hours) Additionally, you'll receive free online portfolio design assistance, career growth guidance, and mock interviews to enhance your job market readiness. Option B: AutoCAD (10 hours) 3ds Max (17 hours) Vray (4 hours) Photoshop (5 hours) InDesign (4 hours) Certified trainers in AutoCAD, 3ds Max, SketchUp, and Adobe software will conduct this training program. It caters to beginners, intermediate, and advanced learners, focusing on core skills for creating 2D drawings, plans, sections, elevations, construction details, and 3D visualizations. Our experienced instructors will guide you through essential commands and methodologies for producing precise 2D and 3D drawings. We have developed these CAD courses, utilizing the expertise of our professionals to provide the most efficient and effective instruction. Upon completion, participants will: Master Software Tools: Excel in AutoCAD, SketchUp, Vray, Photoshop, and InDesign for digital design. Advanced Design Skills: Create intricate 2D/3D designs, plans, and visualizations. Project Management: Manage layouts, plotting, and projects efficiently. Realistic Rendering: Produce lifelike visualizations using Vray. Creative Composition: Understand design principles for impactful creations. Portfolio Development: Create a professional online portfolio. Career Readiness: Prepare for job interviews and enhance resumes. Potential Jobs: Architect Interior/Exterior Designer CAD Technician Visualization Specialist Design Consultant Project Manager These skills open doors to varied roles in architecture and design, ensuring career growth and job readiness. Course Features: Compatibility: Our training courses are compatible with both Mac and Windows operating systems, ensuring accessibility for all users. Price Assurance: We guarantee the best value for your investment, ensuring competitive pricing for high-quality training. Personalized Training: Benefit from one-on-one training sessions tailored to your specific needs and skill level, ensuring a personalized learning experience. Flexible Scheduling: Enjoy the flexibility to choose your preferred training time and day. Sessions are available seven days a week, from Monday to Sunday, between 9 am and 8 pm, accommodating your busy schedule. Lifetime Support: Receive lifetime email and phone support, ensuring that you have access to assistance even after completing the course. Technical Assistance: Get help with configuring your computer for software installation, ensuring a smooth learning experience without technical hurdles. Referral Discounts: Earn special discounts when you refer a friend to our courses, making learning a rewarding experience for you and your network. Group Training Savings: Avail significant savings on group training courses, encouraging collaborative learning and making education more accessible for groups. When can you schedule this Training Course? Personalized training experience with our flexible 1-on-1 sessions. Design your own timetable by pre-booking a convenient hour of your choice, available from Monday to Saturday between 9 a.m. and 7 p.m. Alternatively, you can call 02077202581 to book over the phone. How long is the training? The course spans 40 hours, which you can divide over as many days as needed to fit your ideal schedule. What's the teaching method? Our sessions are 1-on-1, offered either in-person face to face or live online. You'll receive personalized attention, tailored content, a flexible learning pace, and individual support. Live online 1-on-1 sessions over Zoom are also an option. What will you learn? In this comprehensive training program, you'll gain proficiency in a thoughtfully curated selection of software tools. Option A: AutoCAD (13 hours) SketchUp (10 hours) Vray (6 hours) Photoshop (6 hours) InDesign (5 hours) Additionally, you'll receive free online portfolio design assistance, career growth guidance, and mock interviews to enhance your job market readiness. Option B: AutoCAD (10 hours) 3ds Max (17 hours) Vray (4 hours) Photoshop (5 hours) InDesign (4 hours) Certified trainers in AutoCAD, 3ds Max, SketchUp, and Adobe software will conduct this training program. It caters to beginners, intermediate, and advanced learners, focusing on core skills for creating 2D drawings, plans, sections, elevations, construction details, and 3D visualizations. Our experienced instructors will guide you through essential commands and methodologies for producing precise 2D and 3D drawings. We have developed these CAD courses, utilizing the expertise of our professionals to provide the most efficient and effective instruction.

Customized and Bespoke 3ds Max Training: Face-to-Face and Online Options

Gain the skills and essential knowledge needed for completing the manual bookkeeping activities that underpin all accountancy and finance roles. Course Overview Students studying this qualification will develop practical accountancy skills in the double-entry bookkeeping system and in using associated documents and processes. They will cover transactions for accuracy, make entries in appropriate books and ledgers and calculate sales invoices and credit notes. Gain the skills and essential knowledge needed for completing the manual bookkeeping activities that underpin all accountancy and finance roles. The jobs it can lead to: • Trainee bookkeeper • Finance assistant • Accounts administrator • Clerical assistant Entry Requirements: Students can start with any qualification depending on existing skills and experience. For the best chance of success, we recommend that students begin their studies with a good standard of English and maths. Course Content: Introduction to Bookkeeping: This unit provides students with an understanding of manual and digital bookkeeping systems, including the associated documents and processes. Students will learn the basic principles that underpin the double-entry bookkeeping systems. Learning outcomes: • Understand how to set up bookkeeping systems. • Process customer transactions. • Process supplier transactions. • Process receipts and payments. • Process transactions into the ledger accounts. Principles of Bookkeeping Controls: This unit builds on the knowledge and skills acquired from studying Introduction to Bookkeeping and explores control accounts, journals and reconciliations. Students will develop the ability to prepare the value added tax (VAT) control accounts as well as the receivables and payables ledger accounts. They will use the journal to record a variety of transactions, including the correction errors. Students will be able to redraft the initial trial balance, following adjustments. Learning outcomes: • Use control accounts. • Reconcile a bank statement with the cash book. • Use the journal. • Produce trial balances. DURATION 3 Months WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

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

Who is this for? InDesign Evening Classes. Refine your Adobe InDesign skills with expert tutors. Master layout creation, typography, and image manipulation. Design captivating brochures, magazines, and more. Choose between in-person or live online sessions. Earn a Certificate of Completion and enjoy lifetime email support. Explore our complimentary trial session. Check our Website Duration: 10 hours Approach: 1-on-1 sessions with tailored content. Schedule: 1-on-1 sessions, available Mon to Sat from 9 am to 7 pm. Course Title: Mastering Adobe InDesign Course Duration: 10 Hours Session 1: Introduction to Adobe InDesign (1 hour) Overview of Adobe InDesign interface Understanding tools and panels Setting up new documents and document properties Basic navigation and shortcuts Session 2: Mastering Page Layouts (1.5 hours) Working with master pages Creating and managing text frames and image placeholders Managing multiple pages and spreads Using grids and guides for precise layouts Session 3: Typography and Text Formatting (1.5 hours) Working with fonts, styles, and text formatting options Understanding text threading and linking Advanced text composition techniques Utilizing paragraph and character styles for consistency Session 4: Advanced Image Manipulation (1.5 hours) Importing and manipulating images and graphics Understanding image resolution and color modes Working with clipping paths and transparency Applying image effects and filters Session 5: Interactive Documents and Digital Publishing (2 hours) Creating hyperlinks and interactive buttons Embedding multimedia elements (audio, video) in documents Exporting documents for digital platforms (eBooks, PDF forms) Introduction to responsive design for various devices Session 6: Advanced Techniques and Special Effects (1 hour) Utilizing advanced drawing tools and shapes Applying special effects like drop shadows, transparency, and blending modes Working with tables and charts Introduction to data merge for personalized content Session 7: Printing and Prepress (1 hour) Understanding print terminology and specifications Preflighting documents for print readiness Color management and preparing files for different printing processes Exporting files for professional printing Session 8: Project Work and Review (0.5 hour) Participants work on a practical project applying learned skills Instructor-guided project review and feedback Session 9: Tips, Tricks, and Best Practices (0.5 hour) Time-saving shortcuts and productivity hacks Best practices for efficient workflow and file management Troubleshooting common issues and errors Session 10: Q&A and Certification (0.5 hour) Addressing participant queries and concerns Certificate distribution and course completion celebration This comprehensive 10-hour course aims to equip participants with advanced skills in Adobe InDesign, covering essential aspects of design, typography, interactivity, and print preparation. Participants will engage in hands-on activities, projects, and discussions to reinforce their learning throughout the course. By the end of this 10-hour advanced InDesign course, you will: Gain a comprehensive understanding of InDesign's most powerful features and advanced techniques. Create sophisticated page layouts with eye-catching special effects for professional-level designs. Efficiently manage fonts, colors, and shapes to enhance the visual appeal of your documents. Develop interactive PDFs with navigation, page transitions, and embedded video for engaging presentations. Master the use of character styles, paragraph styles, and word styles to streamline text formatting. Utilize advanced object styles and anchored objects for efficient layout design. Work effectively with Adobe Stock, Photoshop, Illustrator, and other Creative Cloud applications for seamless integration. Create PDF forms and implement interactive button-triggered animations for interactive documents. Optimize workflow with keyboard shortcuts, scripts, and advanced preferences for a smoother design process. Learn valuable tips and best practices from industry experts to boost your productivity and efficiency. Enhance your mastery of InDesign through our advanced program, meticulously designed to hone your skills. Explore intricate page layouts and seamlessly integrate captivating special effects into your projects. Our seasoned Adobe trainers, renowned for their approachable teaching style, will guide you through InDesign's powerful features, sharing invaluable insights derived from years of practical experience. This interactive course provides ample opportunities for hands-on practice, ensuring your confidence in harnessing InDesign's diverse technical capabilities. Key Course Highlights: In-depth exploration of InDesign's advanced functionalities. Individualized attention, fostering open discussions and encouraging questions. Expert trainers, small class sizes, and a supportive and collaborative learning environment. Comprehensive learning materials and resources, all inclusive. Continuous support for any post-course inquiries or concerns, ensuring your ongoing success. Enhance your InDesign proficiency, crafting polished designs effortlessly. Elevate your skills with our advanced course, ensuring: Thorough coverage of InDesign's technical capabilities. Personalized attention and ample opportunity for questions. Supportive, knowledgeable trainers in a comfortable learning environment. Comprehensive materials and resources for your learning journey. Continued assistance for post-course queries and concerns. Download InDesign

Why Choose Rhino Introduction to Intermediate Training Course? Learn: 3D NURBS models. Master: Surfacing modeling. Interface: Rhino's navigation. Rendering Skills: Enhance presentations with Rhino renderings. Check our Website Flexible Scheduling: 1-on-1 training sessions according to your convenience. Choose any hour between 9 a.m. and 7 p.m., Mon to Sat. You can call us at 02077202581 to book over the phone. Duration: 10 hours. Methods: Personalized training either in-person, or live online. Introduction and Navigation Become acquainted with Rhino's interface, menus, and screen layout. Efficiently traverse through Rhino models, ensuring precision in 2D lines, polylines, and NURBS curves. Utilize modeling setup features, incorporating constraints like snap, ortho, and planar for accuracy. Leverage object snaps and Smart Track functionality to enhance precision. Solid and Surface Modeling Develop rapid 3D solids and surfaces, employing Rhino's organized layering system. Utilize coordinates and constraints for meticulous modeling, exploring 3D space and elevations. Create diverse shapes, such as rectangles, circles, arcs, ellipses, and polygon curves. Elevate models with Rhino render and render color, incorporating free-form curves, helix, and spiral curves. Efficiently handle model views with pan, zoom, and view management tools. Implement various editing commands for curve manipulation and transform curves into surfaces and solids. Utilize history tracking for advanced editing and execute general editing actions: move, copy, rotate, mirror, and scale. Create arrays with both polar and rectangular arrangements and employ boolean operations like union, difference, and intersection. Offset curves and surfaces effectively, ensuring meticulous detailing. Intermediate Edit and Surfacing Introduce key NURBS modeling concepts and terminologies. Edit curves and surfaces via control point manipulation and rebuild them for optimal refinement. Employ the nudge modeling aid for precise adjustments and generate deformable shapes. Create curves through projection techniques and split surfaces using curves and surfaces. Blend surfaces seamlessly, utilizing symmetry tools, lighting, and rendering effects. Convert intricate 3D objects into detailed 2D drawings, expertly crafting page layouts. Advanced Surfacing and Solid Modeling Construct model primitives and solid text, employing techniques such as pipe and extrusion. Modify solids efficiently using Boolean tools, expanding your surface modeling capabilities. Employ techniques like extrusion, lofting, and revolving for intricate surfaces. Create sweeps using 1 and 2 rail curves, mastering surface network techniques for complex shapes. Upon completion, you will: Master Rhino Tools: Navigate interfaces, utilize advanced tools for precise modeling, and employ features like object snaps and Smart Track. Expert Solid and Surface Modeling: Develop intricate 3D solids and surfaces, create diverse shapes, and use Rhino render effectively. Advanced Editing Skills: Apply intermediate and advanced editing techniques, including symmetry tools and realistic rendering. Precision Modeling: Utilize coordinates, constraints, and advanced aids for accurate detailing and problem-solving. Professional Project Execution: Create high-quality renderings, 2D drawings, and polished 3D models for real-world design scenarios. Upon completion, you'll be adept at 3D modeling, product design, and architecture, positioning you as a valuable asset in the design industry. Why Choose Our Rhino Courses? Rhino, also known as Rhinoceros, stands as a robust 3D computer graphics and computer-aided design software, utilized extensively in domains like architecture, industrial design, and multimedia. Our Rhino courses are meticulously crafted to empower you in mastering this software. Led by seasoned instructors, our courses provide a comprehensive understanding of Rhino, enabling you to create exceptional designs. Rhino 3D Training: Our Rhino 3D training caters to beginners and those seeking advanced techniques. Course Highlights: Precise 3D Modeling: Master free-form 3D NURBS models with precision. Advanced Functionality: Explore Rhino's features, including advanced surfacing commands. User Interface Mastery: Navigate Rhino's interface and hone skills in curves, surfaces, and solids. Expert Guidance: Acquire expertise in Rhino's modeling environment under expert guidance. Modeling Techniques: Learn free-form and precision modeling techniques. Modeling Aids: Utilize tools for accurate modeling and create basic Rhino renderings. Benefits of our Courses: Expert Guidance: Receive instruction from experienced architects and designers, providing practical, real-world insights for comprehensive learning. Comprehensive Resources: Access bespoke video tutorials for additional learning and reference, enhancing your understanding of the course materials. Digital Reference Material: Receive a digital reference book to support your revision efforts, providing a comprehensive resource for your studies. Ongoing Support: Enjoy free after-support through phone or email even after course completion, ensuring continuous assistance and guidance. Tailored Learning Experience: Customize your learning journey by adapting the syllabus and projects to align with your specific needs and interests, fostering a personalized educational experience. Certificate: Upon completion, earn a certificate from us, validating your achievement and recognizing your expertise in the field.

Photoshop face to face training customised and bespoke Online or Face to Face

Affinity Publisher Training Course for Beginners. Online Affinity Training with live instructors or face to face onsite. Learn to create and design layouts for flyers, brochures, newsletters, marketing documents and business stationery.

Autocad face to face training customised and bespoke.