15383 Courses

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

The Real Estate Investment School is a four day course, that unravels the complexity of Investment Cash Flows through Advanced Modelling, Interpretation and Theory.

This Diabetes Awareness training covers key aspects of diabetes management, ensuring everyone understands the importance of blood sugar control and how to handle emergencies.

Why Choose Twinmotion Realtime Rendering Training Course? Click here for info Empower architects, designers, and visualization experts with our Twinmotion training. Learn tools, materials, lighting, animation, and rendering. Explore advanced techniques for lifelike landscape and special effects using Twinmotion's asset library. Opt for in-person or live online sessions. Duration: 10 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own hours of your choice, available from Mon to Sat between 9 am and 7 pm Twinmotion Real-time 3D Architecture Visualization Course Outline: Module 1: Introduction to Twinmotion Explore Twinmotion's real-time 3D visualization capabilities Master the Twinmotion interface for efficient scene manipulation Prepare 3D files for import and manage the workflow Module 2: Materials and Realism Enhance scenes with realistic materials and visual quality Utilize videos as materials and apply glow effects Create grunge materials for added texture and realism Employ the X-ray material for specific visualization needs Module 3: Landscape and Vegetation Integrate vegetation using Twinmotion's scatter, HQ trees, and growth features Customize grass and utilize HQ vegetation assets for realism Create time-lapse effects for vegetation growth Module 4: Library and Object Import Access the Twinmotion library for furniture and objects Seamlessly import external 3D objects Obtain high-quality 3D assets from the internet and add to the user library Utilize BIM-objects for additional assets Module 5: Lighting and Animation Work with various lighting options, including area light and volumetric light Add animated characters and vehicles for dynamism Incorporate construction vehicles and aircraft for realism Module 6: Volumes and Interactivity Utilize volumes and the animator feature for dynamic scenes Implement urban elements and measurement tools for accuracy Module 7: Nature and Weather Effects Utilize Twinmotion's nature features, including physical sky and weather effects Create realistic lighting for outdoor scenes Add ocean effects for water elements Module 8: Rendering Techniques Master rendering processes, from creating images to exporting panoramas and animations Implement depth of field improvements for captivating visuals Create BIM motion virtual reality phases for immersive experiences Utilize the Twinmotion presenter feature for streamlined presentations Module 9: Final Project Apply knowledge and skills to complete a final render project in Twinmotion Download Twinmotion https://www.twinmotion.com › download Learn how to download and install Twinmotion, the fast, easy real-time archvis tool.

***24 Hour Limited Time Flash Sale*** Port Management, Commercial law & Logistic Management Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Enhance your expertise and accelerate your career with our exclusive bundle of 8 courses: Port Management, Commercial Law & Logistic Management. This comprehensive package is meticulously designed to equip you with the knowledge and insights required to excel in these dynamic fields. Unleash your potential as you delve into the intricacies of port management, navigate the complexities of commercial law, and master the art of logistic management. In this bundle, you will embark on an intellectual journey that will broaden your horizons and deepen your understanding of key concepts. Immerse yourself in the world of supply chain management, explore the intricacies of airport management, become a proficient transport manager, and gain expertise in warehouse management and import/export. These courses cover the critical aspects required to excel in these fields, enabling you to stay ahead of the curve in today's competitive job market. Key Features of the Port Management, Commercial law & Logistic Management Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Port Management, Commercial law & Logistic Management bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Port Management QLS Course 02: Commercial law QLS Course 03: Logistic Management 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Supply Chain Management Course 02: Airport Management Course 03: Transport Manager Course 04: Warehouse Management Diploma Course 05: Import/Export In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Port Management, Commercial law & Logistic Management courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Acquire in-depth knowledge of port management principles, practices, and strategies. Understand the legal framework governing commercial transactions and develop proficiency in commercial law. Master the fundamentals of logistic management and learn how to optimize supply chains. Gain insights into supply chain management techniques and strategies for enhanced efficiency. Develop expertise in airport management and understand the complexities of the aviation industry. Become a competent transport manager with a comprehensive understanding of transportation logistics. Obtain the skills necessary for effective warehouse management and gain expertise in import/export procedures. Embark on a transformative learning journey with our Port Management, Commercial Law & Logistic Management bundle. This meticulously curated collection of courses provides you with a comprehensive understanding of the intricate dynamics within these industries. Delve into the world of port management, explore the nuances of commercial law, and gain expertise in the art of logistic management. This bundle combines theoretical knowledge with practical insights to empower you with a holistic skill set that will set you apart in the job market. CPD 270 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Professionals seeking to expand their knowledge and expertise in port management, commercial law, and logistic management. Individuals aspiring to pursue careers in the maritime industry, legal sector, or logistics and supply chain management. Graduates and postgraduates aiming to enhance their employability and gain a competitive edge in the job market. Entrepreneurs and business owners looking to optimize their understanding of the legal and logistical aspects of their operations. Career path Port Manager: £35,000 - £70,000 per annum Commercial Lawyer: £40,000 - £100,000 per annum Logistic Manager: £30,000 - £60,000 per annum Supply Chain Manager: £35,000 - £80,000 per annum Airport Manager: £30,000 - £70,000 per annum Warehouse Manager: £25,000 - £50,000 per annum Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

10 QLS Endorsed Courses for Logistics Manager | 10 Endorsed Certificates Included | Life Time Access

In this course, you will learn how to create vehicles using 100% blueprints and ready-to-use Unreal Engine 5 assets. You will see how you can import your own assets from Blender, Maya, or Max and set them up. This course is meant for intermediate and expert users of Unreal Engine 5 as the basics of Unreal Engine 5 won't be covered.

3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 10 CPD Courses | Lifetime Access

24 Hours Left! Don't Let Year-End Deals Slip Away - Enrol Now! Enhance your skills and boost your career prospects with our comprehensive Procurement Administrator Course. With a range of courses covering supply chain management, product management, quality management, import/export processing, operations and maintenance management, cost control process and management, transport and logistics management, warehouse safety training, and manual handling training, this bundle is designed to provide you with the knowledge and expertise needed to excel in the procurement field. The first course in this bundle is QLS-endorsed, and upon completion, you will receive a QLS hardcopy certificate for free, adding value to your credentials. In addition, the remaining 10 courses are CPD-QS accredited, ensuring that you receive high-quality training that is recognised by industry professionals. Learn how to streamline procurement processes, optimise supply chain operations, manage product portfolios, implement quality management systems, and ensure compliance with import/export regulations. Gain valuable insights into cost control, transportation, logistics, warehouse safety, and manual handling techniques. With relevant content, this course bundle will equip you with the skills needed to excel in the procurement field and meet the demands of the job market. With the current job market trends, the demand for qualified procurement administrators is on the rise. By completing this comprehensive course bundle, you will gain a competitive edge in the job market and enhance your career prospects. So, whether you are a beginner looking to enter the procurement field or an experienced professional looking to upskill, this course bundle is tailored for you. This Procurement Administrator Bundle Package includes: Course 01: Diploma in Procurement Administrator at QLS Level 5 10 Premium Additional CPD QS Accredited Courses - Course 01: Supply Chain Management Course Course 02: Product Management Course 03: Complete Quality Management Course 04: Import/Export Processing Course 05: Operations and Maintenance Manager Course 06: Cost Control Process and Management Course 07: Transport and Logistics Management Course 08: Warehouse Safety Training Course 09: Manual Handling Training Course 10: Complete Communication Skills Master Class Why Prefer This Procurement Administrator Bundle? You will receive a completely free certificate from the Quality Licence Scheme Option to purchase 10 additional certificates accredited by CPD Get a free Student ID Card - (£10 postal charges will be applicable for international delivery) Free assessments and immediate success results 24/7 Tutor Support After taking this Procurement Administrator bundle courses, you will be able to learn: Upon completion of the Procurement Administrator Course, you will be able to: Streamline procurement processes and optimise supply chain operations Manage product portfolios and implement quality management systems Ensure compliance with import/export regulations and manage transportation and logistics Implement cost control processes and manage warehouse safety Master manual handling techniques and best practices Understand the role of operations and maintenance management in procurement Enhance your skills in supply chain management and product management ***Curriculum breakdown of Procurement Administrator*** Module 01: Supply Chain Basics Module 02: Role of Procurement in an Organisation Module 03: The Purchasing Cycle Module 04: Purchasing Toolkits Module 05: Managing Competitive Bids Module 06: Quality Management Module 07: Supplier Relationship Management Module 08: Analysing and Reducing Risk in the Supply Chain Module 09: Improving Efficiency and Accuracy Module 10: Category Management Module 11: Inventory Management Module 12: E-Procurement Module 13: Communication Skills Module 14: Customer Service How is the Procurement Administrator Bundle Assessment Process? You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you successfully pass the exams. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This comprehensive course bundle is ideal for: Beginners looking to enter the procurement field Procurement administrators looking to upskill and enhance their knowledge Supply chain professionals seeking to expand their skill set Product managers looking to gain insights into procurement processes Professionals working in logistics, transportation, and warehousing industries Career path This bundle will give you an edge in various professions, such as Procurement Administrator Supply Chain Manager Operations Manager Logistics Coordinator Warehouse Manager Product Manager Quality Control Manager According to industry statistics professionals in these roles can earn competitive salaries ranging from £30,000 to £70,000 per year, depending on their level of experience and expertise Certificates CPD QS Accredited Certificate Digital certificate - Included Upon successfully completing the Bundle, you will need to place an order to receive a PDF Certificate for each course within the bundle. These certificates serve as proof of your newly acquired skills, accredited by CPD QS. Also, the certificates are recognised throughout the UK and internationally. CPD QS Accredited Certificate Hard copy certificate - Included International students are subject to a £10 delivery fee for their orders, based on their location. Diploma in Procurement Administrator at QLS Level 5 Hard copy certificate - Included

24 Hours Left! Don't Let Year-End Deals Slip Away - Enrol Now! If you are looking for a comprehensive commercial management course, then you have come to the right place. Our Commercial Management course bundle includes 11 courses that cover various aspects of commercial management, from commercial and contract law to financial analysis, marketing, and corporate social responsibility. The first course in this bundle is QLS-endorsed, which means that you will receive a hardcopy certificate from QLS upon completing it. This certificate will be a valuable addition to your CV, as it demonstrates your commitment to learning and your knowledge of commercial management. The other ten courses in this bundle are CPD-QS accredited, which is a recognized accreditation that ensures the quality of the training you will receive. Through this course bundle, you will learn how to manage contracts, analyse financial data, handle taxes, and manage relationships with customers and the public. You will also learn how to navigate the import/export process, use Xero accounting software, and develop effective marketing and PR strategies. By the end of this course bundle, you will have gained a broad and deep understanding of commercial management, and you will be equipped with the skills you need to succeed in this field. Enrol now in our Commercial Management course bundle and take the first step towards advancing your career in this exciting field. This Commercial Management Bundle Package includes: Course 01: Diploma in Commercial Management at QLS Level 5 10 Premium Additional CPD QS Accredited Courses - Course 01: Commercial Law Course 02: Contracts Law UK Course 03: Financial Analysis Course Course 04: Tax Accounting Course Course 05: Import/Export Processing Course 06: Xero Accounting & Bookkeeping Course Course 07: Customer Relationship Management Course 08: Public Relation Course 09: Marketing Course Course 10: Corporate Social Responsibility (CSR) Why Prefer This Commercial Management Bundle? You will receive a completely free certificate from the Quality Licence Scheme Option to purchase 10 additional certificates accredited by CPD Get a free Student ID Card - (£10 postal charges will be applicable for international delivery) Free assessments and immediate success results 24/7 Tutor Support After taking this Commercial Management bundle courses, you will be able to learn: Understand the principles of commercial law and contract law in the UK Analyse financial data to make informed business decisions Understand the UK tax system and how to handle taxes for businesses Navigate the import/export process and comply with regulations Use Xero accounting software to manage business finances Manage customer relationships and develop effective marketing strategies Develop and implement corporate social responsibility strategies to enhance the reputation of a business ***Curriculum breakdown of Commercial Management *** Module 01: Introduction to Commercial Management Module 02: Commercial Relationship Part-1 Module 03: Commercial Relationship Part-2 Module 04: Partnership and Agreements Module 05: Budget Management Module 06: Cash Flow Management Part- 1 Module 07: Cash Flow Management Part- 2 Module 08: Negotiation Module 09: Commercial Risk Management Module 10: Commercial Project Management Module 11: Customer Relationship Management (CRM) Part-1 Module 12: Customer Relationship Management (CRM) Part-2 Module 13: Managing Customer Lifecycle Module 14: Roles of Shareholders in Commercial Management Module 15: Loans and Debts Management Module 16: Commercial Legislations How is the Commercial ManagementBundle Assessment Process? You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you successfully pass the exams. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Our Commercial Management course bundle is designed for individuals who are interested in pursuing a career in commercial management, as well as professionals who want to enhance their skills and knowledge in this field. This course bundle is particularly relevant for: Entrepreneurs and business owners Managers and executives Accountants and financial analysts Sales and marketing professionals HR professionals Career path This bundle will give you an edge in various professions. Such as: Commercial Manager - £50,000 per year Financial Analyst - £40,000 per year Tax Advisor - £35,000 per year Marketing Manager - £45,000 per year PR Manager - £35,000 per year Import/Export Coordinator - £25,000 per year CSR Manager - £40,000 per year Certificates CPD QS Accredited Certificate Digital certificate - Included Upon successfully completing the Bundle, you will need to place an order to receive a PDF Certificate for each course within the bundle. These certificates serve as proof of your newly acquired skills, accredited by CPD QS. Also, the certificates are recognised throughout the UK and internationally. CPD QS Accredited Certificate Hard copy certificate - Included International students are subject to a £10 delivery fee for their orders, based on their location. Diploma in Commercial Management at QLS Level 5 Hard copy certificate - Included