374 Spreadsheet courses delivered Online

Description Master the use of Google G Suite to boost your productivity and enjoy the benefits of business email, video conferencing, online storage and file sharing with the intensive Google G Suite Essential Training course. Google G Suite, formerly known as Google Apps, is a collection of applications or collaborative productivity apps, especially for email that includes Google Drive, Google Docs, Slides, and Drawings, Google Sheets and Forms, Google Hangouts, Google Calendar, and Google sites. A G suit email looks like any Gmail account. The only difference is G Suit email will be like example@yourdomail.com instead of the Gmail account like example@gmail.com. Google G Suit provides business professional email, shared calendars, online document editing and storage, video meetings, and much more. Throughout the course, you will learn the essential features of Google G suits such as navigating in the G-Suite (Google Apps) environment, storing documents by using Google Drive, communicating using Google Hangouts, and collaborating by using Google Sites. Then the course shows you how to manage your schedules using Google calendar. Finally, the course teaches you how to collaborate and share files with Google Docs, Slides, and Drawings, Google Sheets and Forms. In short, the course covers all the essential features and functions of the Productivity app Google G Suite. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Google G Suite Essential Training is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Google G Suite Essential Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Lesson 1: About G Suite TOPIC A Overview 00:05:00 TOPIC B Signing In 00:15:00 Lesson 2: Google Drive TOPIC A Getting Started with Google Drive 00:15:00 TOPIC B Work with Files 00:15:00 TOPIC C Organize and Search Google Drive 00:15:00 Lesson 3: Google Docs (Part 1) TOPIC A Getting Started with Google Docs 00:15:00 TOPIC B Composing and Editing Google Docs (Part 1) 00:15:00 TOPIC C Composing and Editing Google Docs (Part 2) 00:15:00 Lesson 4: Google Docs (Part 2) TOPIC A Working with Images and Tables 00:15:00 TOPIC B Collaborate with Google Docs 00:15:00 TOPIC C Reviewing and Distributing Documents 00:15:00 Lesson 5: Google Sheets TOPIC A Getting Started with Google Sheets 00:15:00 TOPIC B Editing Spreadsheets 00:15:00 TOPIC C Working with Spreadsheet Data 00:15:00 TOPIC D Formatting and Finalizing Spreadsheets 00:15:00 Lesson 6: Google Slides TOPIC A Getting Started with Google Slides 00:15:00 TOPIC B Formatting a Presentation 00:15:00 TOPIC C Editing Google Slides 00:15:00 TOPIC D Presenting and Sharing Google Slides 00:15:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Where should management effort be directed? In controlling costs and ensuring proper engineering in live projects? - yes, of course, but true cost control comes by understanding, eliminating and minimising risk prior to a business committing any funds. This course studies the stages required for practical financial and business appraisals of projects and capital expenditure. This course has two primary objectives: To impart the knowledge and skills required to ensure as risk-free as possible expenditure of that scarce resource, cash - the investors', governments' or shareholders' money must not be squandered To improve the quality of the appraisal process in the widest sense - demonstrating how the process of project and capital expenditure appraisal can be used to dramatically improve cost control and deliver as risk-free as possible expenditure As a result of the course, participants will be able to: Understand the economics of appraisal Be in control of their projects from the start Understand the economics of their projects - and devise the most appropriate mode Carry out sensitivity analysis and identify risk Improve their methods of appraisal and approach Focus on the risk areas and take out risk and control costs before they over-run The benefits of attending this course will be demonstrable from day one. Thorough appraisals and risk assessment follow through to success in project management and detailed cost control and project management. 1 Introduction Why appraise? Taking risk out of investment The short- and long-term results of not appraising business expenditure 2 Developing an appraisal process The process - overall and stage-by-stage objectives Understand business and technical risks Manage resources and time Do you invest enough time and effort at this stage? Take out the risks - control costs before you are committed to contracts and action Checklists 3 Appraisal arithmetic Review of the arithmetic of appraisalThe time value of moneyThe effects of different interest or required ratesThe effects of inflation (or deflation) in prices and costs Understanding the economics of appraisal is essential 4 Appraisal measures Meaning and use of appraisal measures Identifying the most appropriate measures for your particular business Payback Discounted cash flow measures - NPV and IRR Other measures - FW, AW, Profitability Index The meaning of the measures and their application in practice 5 Cost benefit analysis The effect on decision-making of more intangible benefits Cost benefit analysis Ensuring costs are genuine Measuring intangible benefits Environmental issues Consideration of intangible benefits in the appraisal decision-making process 6 Developing appropriate models Developing models - examples of spreadsheet models and measures for many different situations Modelling investment opportunities - summarising outcomes Sensitivity analysis - identifying, quantifying and taking out risk 7 Developing an appraisal process The process - managing risk from the outset Using the process in risk management, negotiating and project management Take out risk by thoroughly knowing your project - developing your own process

Duration 2 Days 12 CPD hours This course is intended for This introductory-level course is intended for Business Analysts and Data Analysts (or anyone else in the data science realm) who are already comfortable working with numerical data in Excel or other spreadsheet environments. No prior programming experience is required, and a browser is the only tool necessary for the course. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Throughout the hands-on course students, will learn to leverage Python scripting for data science (to a basic level) using the most current and efficient skills and techniques. Working in a hands-on learning environment, guided by our expert team, attendees will learn about and explore (to a basic level): How to work with Python interactively in web notebooks The essentials of Python scripting Key concepts necessary to enter the world of Data Science via Python This course introduces data analysts and business analysts (as well as anyone interested in Data Science) to the Python programming language, as it?s often used in Data Science in web notebooks. This goal of this course is to provide students with a baseline understanding of core concepts that can serve as a platform of knowledge to follow up with more in-depth training and real-world practice. This course introduces data analysts and business analysts (as well as anyone interested in Data Science) to the Python programming language, as it's often used in Data Science in web notebooks. This goal of this course is to provide students with a baseline understanding of core concepts that can serve as a platform of knowledge to follow up with more in-depth training and real-world practice. Additional course details: Nexus Humans Python for Data Science Primer: Hands-on Technical Overview (TTPS4872) 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 Python for Data Science Primer: Hands-on Technical Overview (TTPS4872) 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.

You will hardly find a company or business who doesn't use Microsoft Excel. It is one of the most popular spreadsheet tools that is used to store, organize and analyse data. You can also manipulate the data to create useful visuals to understand trends and calculations. Having a professional Microsoft Excel degree can become an asset for you. Whether you are planning to start your career or want a promotion, our Microsoft Excel 2010 Intermediate Level will help you greatly. Please note that this course is for intermediate level. If you haven't completed the beginners course, then it will be a bit difficult for you to cope up with the intermediate features. But, if you are a quick learner and can adapt with changes, then you can enrol to this course without any doubt and master Microsoft Excel easily. It will help you to stand out in the crowd with your advanced MS Excel skills to that you can stay ahead in the workplace. Course Highlights Microsoft Excel 2010 Intermediate Level is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Microsoft Excel 2010 Intermediate Level into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 10 hours, 40 minutes and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft Excel 2010 Intermediate Level Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Microsoft Excel 2010 Intermediate Level is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Microsoft Excel 2010 Intermediate Level is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Excel 2010 Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 01:00:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 01:00:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working with Functions 01:00:00 Module Seven - Working with Macros 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Applying Advanced Chart Features 01:00:00 Module Ten - Working with PivotTables and PivotCharts 01:00:00 Module Eleven - Using the Automated Analysis Tools Add -In 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Excel 2010 Intermediate Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2010 Intermediate level 00:20:00 Final Exam Final Exam- Microsoft Excel 2010 Intermediate level 00:20:00

This Instructional Design Courses will provide you with a strong foundation in instructional design and help you understand how to determine and organise what to teach. You will learn how to research teaching strategies, and teaching tools and design individual activities and group activities. This Course At A Glance Accredited by CPD UK Endorsed by Quality Licence Scheme Understand the system approach to instructional design, its theories, and the concept behind informational processing Learn the terminologies such as eLearning, instructional design, and blended learning Gain knowledge about the fundamentals of designing and developing instructional materials Learn the components, objectives, and teaching styles in instructional design Know how to create clearer and more memorable visual content Learn how to identify your audience, their roles, and goals, and understand what they already do or want to do Understand how to design and develop learning programs using the constructivist theory of education Know how to research teaching strategies and discover a range of learning styles Know how to balance a lecture with fun activities and make it look real Learn how to create facilitator guides, in-class activities and assessments Understand how to design workbooks, handouts, slideshows and marketing materials Instructional Design Course at QLS Level 5 Overview This Instructional Design Course is designed for anyone in the teaching industry, who loves instructional designing, or is perhaps interested in designing and developing content for teaching and building more advanced skills. This online course will help you understand the history and evolution of instructional design, principles, and features of the design and development of instructional material. You will understand what makes an amazing training curriculum, how to identify your audience, and how to organise tasks and subtasks. This course emphasises how to create a slideshow, evaluation quizzes, workbooks, handouts, in-class activities and other materials to facilitate an interesting teaching environment. You will learn the steps to design a curriculum structure and know curriculum teaching design and curriculum production. Upon successful completion of this Instructional Design Course, you will be acquainted with the essential elements of instructional design, curriculum life cycle, and effective assessment tools, and learn how to create and design documents that are required to make the classroom activities more interesting and fruitful. Who should take this course? This Instructional Design Courses is primarily aimed at: Teachers Aspiring teachers Academic staff Home tutor Content Writers SEN teaching assistant Human resource professional Instructional designer Anyone associated with the teaching industry This course is not, however, limited to a particular sector or line of work. This course is open to anybody who wants to gain substantial knowledge and skills to design eLearning study materials. Entry Requirements There are no academic entry requirements for this Instructional Design Course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This Instructional Design Course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Course Curriculum Introduction and Welcome to Curriculum Structural Design Start Here - Instructional Des What Makes an Amazing Training Curriculum - Part 1 What Makes an Amazing Training Curriculum - Part 2 Identify With Your Audience Identify With Your Audience Introduction Identify Their Roles Identify Their Goals Identify Their Why Identify What They Do Identify What They Already Do Identify What They Already Do Activity Identify What They Want to Do Identify What They Need to Do Organize What They Do Organize What They Do Intro Organize Tasks and Subtasks Organize Tasks and Subtasks - Part 2 Create Modules and Lessons Set Up a Curriculum Design Spreadsheet Determine What to Teach Understanding Objectives Understanding Objectives Activity Determine Conventions to Teach Determine Algorithms to Teach Determine Concepts to Teach Organize What to Teach Simplify and Group Objectives Part 1 Simplify and Group Objectives Part 2 Add Objectives to the Curriculum Design Spreadsheet Mark Objectives for Assessments Determine the Initial Class Structure Solidify Specific Course Groupings Customize Course Titles and Lesson Titles Determine Course Timelines Instructional Design Pro (Part 2) Introduction Introduction Determine Why They'd Want It Create Lesson Hooks - Part 1 Create Lesson Hooks - Part 2 Create Lesson Hooks Activity Create the Class Hook Create the Agenda and Takeaways Research Teaching Strategies Research Teaching Strategies Intro Discover the Four Learning Styles Research Individual Activities - Part 1 Research Individual Activities - Part 2 Research Group Activities - Part 1 Research Group Activities - Part 2 Research Group Activities - Part 3 Research Partner Activities Research Teaching Tools Research Teaching Tools Intro Keep Their Attention Keep Their Attention Activity Get Follow Along Get Follow Along Activity Get Understanding Get Understanding Activity Determine If They Got It Select Teaching Strategies and Tools Select the Right Teaching Strategies - Part 1 Select the Right Teaching Strategies - Part 2 Supplement With the Right Teaching Tools Balance Lecture With Activities Make it Real to Them Insert Relevant Stories Insert 'What Now' Examples Insert Fun Things Proof the Specific Class Structure Proof the Curriculum Structural Design and Teaching Design Proof the Course Timelines Instructional Design (Part 3) Introduction Introduction Create Facilitator Guides Create the Framework - Part 1 Create the Framework - Part 2 Fill in The Framework With Text Use Pictures to Add Impact - Part 1 Use Pictures to Add Impact - Part 2 Create in Class Activities and Assessments Create Activity Content - Part 1 Create Activity Content - Part 2 Create 'Your Turn' Assignments Create Workbooks and Handouts Create Learner Workbooks - Part 1 Create Learner Workbooks - Part 2 Create a Class Agenda Create Tip Sheets - Part 1 Create Tip Sheets Activity Create a Slideshow Create Your Core Content Slides Create Your Supplemental Slides Add Pictures to Your Slides Create Evaluation Surveys Quiz Design Your Evaluation Survey Produce Your Evaluation Survey Interpret Your Evaluation Survey Create Marketing Materials Create a Marketing Message Create a Marketing Flyer Create a Marketing Video - Part 1 Create a Marketing Video - Part 2 Instructional Design Pro Wrap Up Get Your Certification Supplementary Resources Supplementary Resources - Instructional Design at QLS Level 5 Assessment Assessment - Instructional Design at QLS Level 5 Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Sale Ends Today Automotive Engineering & Design Masterclass Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, or perhaps you're a beginner, unsure of where to start or how to break into your desired field? Whichever stage you're in, our exclusive Basic Automotive Engineering & Design Masterclass Bundle provides unique insights and tools that can help you achieve your goals. So, get ready to accelerate your career and become a leader in automotive engineering in the UK automotive sector, which is rapidly evolving with the advent of electric and hybrid technologies. The Automotive Engineering & Design Masterclass spans a wide array of critical subjects to mold you into a highly skilled automotive professional. Starting with essentials such as Automotive Engineering: Onboard Diagnostics and progressing to complex areas like Electric and Hybrid Vehicles Engineering, this course ensures a deep understanding of both foundational and advanced concepts. It also focuses on topics like Car Mechanic and Repair Training, while specialised modules like Electric Vehicle Battery Management System and Turbocharging equip you with niche skills that are highly valued in the industry. Courses Are Included In this Bundle: Course 01: Automotive Engineering: Onboard Diagnostics Course 02: Automotive Design Course 03: Automotive Engineering: Electric and Hybrid Vehicles Engineering Course 04: Automotive Engineering: Car Mechanic and Repair Training Course 05: Automotive Engineering: Supercharger Automobile Engineering Course 06: Automotive Engineering: Engine Lubrication Systems Online Course Course 07: A complete course on Turbocharging Course 08: Car Maintenance and Safety Training Course 09: Motorbike Maintenance & Servicing Course 10: Electric Vehicle Battery Management System Course 11: Vehicle Routing Problem with Spreadsheet Course 12: Power Electronics for Electrical Engineering Course 13: MATLAB Simulink for Electrical Power Engineering Course 14: Large Goods Vehicle (LGV)/HGV Course 15: Hybrid Vehicle Expert Training Course 16: MET Technician Course 17: Energy Saving in Electric Motors Course 18: Mechanical Engineering Course 19: Engineering Mechanics Course for Beginners Course 20: Electrical Machines for Electrical Engineering Course 21: Electrical Engineering - Light Current System Course 22: Heating Ventilation and Air Conditioning (HVAC) Technician Course 23: Electrical Engineering With Electric Circuits Course 24: Electronic Device Maintenance and Troubleshooting Course Course 25: Trigonometry for Electrical Engineering Course 26: Robotics - Sensors Course 27: Manual Handling Course 28: Workshop Technology: Machine Shop Theory Course 29: Good Manufacturing Practices (GMP) Course 30: Fire Safety Step into the future of automotive technology by mastering the skills taught in the Automotive Engineering & Design Masterclass. This comprehensive training will not only elevate your technical and design capabilities but also enhance your career prospects in a sector that is integral to technological advancement and environmental sustainability. Enrol now to transform your passion for automotive technology into a rewarding career that helps shape the future of transportation! Learning Outcomes of this Bundle: Diagnose and troubleshoot with advanced onboard diagnostics skills. Design and engineer cutting-edge electric and hybrid vehicles. Master mechanical aspects of supercharging and turbocharging technologies. Effectively maintain and repair diverse automotive systems. Develop comprehensive skills in battery management for electric vehicles. Apply modern electrical engineering principles to automotive technology. But that's not all. When you enrol in Automotive Engineering & Design Masterclass Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Why Prefer this Course? Get a Free CPD Accredited Certificate upon completion of the course Get a Free Student ID Card with this training program (£10 postal charge will be applicable for international delivery) The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! The Automotive Engineering & Design Masterclass is expertly designed to ensure that you emerge as a highly proficient professional, ready to tackle the challenges of the modern automotive industry. This course will empower you with advanced onboard diagnostics skills, a foundational aspect of automotive engineering that is critical in the era of high-tech vehicles. By understanding how to diagnose and troubleshoot vehicle systems effectively, you'll be able to offer invaluable insights and solutions in difficult scenarios, significantly enhancing your employability and career advancement opportunities. Furthermore, the masterclass dives deep into the design and engineering of electric and hybrid vehicles, placing you at the forefront of automotive innovation. As the industry shifts towards sustainable and eco-friendly solutions, your ability to engineer these advanced vehicles will position you as a key player in driving the future of transportation. This expertise not only boosts your career potential but also aligns you with global trends towards green technology. Moreover, this diploma offers learners the opportunity to acquire a Recognised Qualification that is highly valued in the field of Automotive Engineering. With this Certification, graduates are better positioned to pursue career advancement and higher responsibilities within the Automotive Engineering setting. The skills and knowledge gained from this course will enable learners to make meaningful contributions to Automotive Engineering related fields impacting their Automotive Engineering experiences and long-term development. Course Curriculum Course 01: Automotive Engineering: Onboard Diagnostics Module 01: Introduction Module 02: Brief history Basic working of OBD Module 03: Onboard diagnostic apps Module 04: Exhaust gas - Diagnostics Module 05: APPS on Onboard diagnostics Module 06: Engine - Diagnostics Module 07: Diagnostics - spark plug Module 08: Diagnostics - Fuel injection Module 09: Diagnosis - Lubrication Course 02: Automotive Design Module 01: Emotion and Flow: Secrets of Car Designer Line Quality Module 02: Get Inspired: Developing Your Style and Technique with Speed Forms Module 03: Master Your Wheels: Secrets of Drawing Circles Module 04: Talk the Talk: The Vocabulary of Automotive Design Module 05: In the Beginning: Secrets of Drawing Great Side Views Module 06: Coming and Going: Secrets of Drawing Great Front and Rear Views Module 07: A View from the Top: Secrets of Drawing a Tip-Up View Module 08: Toward the Within: Introduction to Interiors Module 09: In a Brilliant Light: Understanding Light and Shadows Module 10: Shine Like it does: Understanding Reflections Course 03: Automotive Engineering: Electric and Hybrid Vehicles Engineering Module 01: Introduction Module 02: Key Motivations for HEVs Rise Module 03: What is HEV & world famous models Module 04: Architecture of Hybrid Electric vehicles Module 05: Parallel Hybrid Vehicles Module 06: Other types of Architecture Module 07: Modes of Operation Module 08: Engine & Motor Module 09: Motor Efficiency Module 10: Generator & Power Split Device Module 11: Battery storage systems Module 12: Fundamentals of Regenerative Braking =========>>>>> And 27 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*30 = £390) CPD Hard Copy Certificate: Free (For The First Course: Previously it was £29.99) CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Aspiring automotive engineers. Current auto mechanics. Electrical engineering students. Automotive design enthusiasts. Hybrid technology professionals. Manufacturing sector employees. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Automotive Engineer: $68,000 - $110,000 Mechanical Engineer: $70,000 - $100,000 Electrical Engineer: $75,000 - $105,000 Automotive Technician: $40,000 - $65,000 Systems Designer: $85,000 - $120,000 Production Manager: $60,000 - $90,000 Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited e-Certificate - Free Enrolment Letter - Free Student ID Card - Free CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

🚀 Unleash Your Excel Mastery with 'Microsoft Excel 2016 (Basic to Advanced)' Course! 🚀 Are you tired of spending hours grappling with Excel, only to end up with frustrating and inefficient solutions? Do you dream of becoming the Excel wizard in your workplace, effortlessly creating powerful and efficient solutions? Look no further! Introducing our groundbreaking online course: 'Microsoft Excel 2016 (Basic to Advanced).'   🌟 Why Choose 'Microsoft Excel 2016 (Basic to Advanced)'? ✅ Master Advanced Excel Techniques: Dive deep into the world of Excel with our comprehensive modules that cover everything from advanced formulas and functions to data visualization and analysis. ✅ Practical Real-World Applications: Say goodbye to theoretical lessons! We focus on real-world scenarios, ensuring you can immediately apply your newfound skills to solve complex problems in your professional life. ✅ Build Efficiency: Learn the secrets of crafting efficient and streamlined Excel solutions. From automating repetitive tasks to optimizing complex workflows, you'll become a productivity powerhouse. ✅ Expert-Led Instruction: Our experienced instructors are Excel aficionados with a passion for teaching. Benefit from their wealth of knowledge and insider tips, ensuring you stay ahead of the curve. ✅ Interactive Learning: Engage with hands-on exercises, quizzes, and projects that reinforce your understanding and transform you into a confident Excel pro. ✅ Lifetime Access: Gain unlimited access to the course content, updates, and a supportive community. Your learning journey doesn't end - it evolves.   🎓 What You'll Learn: Advanced Formulas and Functions: Supercharge your spreadsheet skills with complex formulas and functions, unlocking Excel's true potential. Data Visualization Mastery: Transform raw data into visually stunning charts and graphs, making your reports and presentations more impactful. Automation Techniques: Streamline your work by mastering Excel's automation features, saving time and reducing errors. Data Analysis Strategies: Unlock the power of PivotTables, data models, and analysis tools to gain valuable insights from your data. Optimizing Workflows: Learn to design efficient workflows and templates that enhance collaboration and productivity.   🌐 Who Is This Course For? Professionals aiming to boost their Excel proficiency. Entrepreneurs seeking to optimize business processes. Students preparing for a data-driven career. Anyone who wants to stay ahead in today's competitive workplace.   Don't miss out on this opportunity to elevate your Excel skills and stand out in the crowd. Join 'Microsoft Excel 2016 (Basic to Advanced)' today and pave the way for a successful and efficient future! Course Curriculum Microsoft Excel 2016 Basic Pre Sell Video 00:00 Lesson 1 - Overview 00:00 Lesson 2 - Interface 00:00 Lesson 3 - File Menu - Part 1 00:00 Lesson 4 - File Menu - Part 2 00:00 Lesson 5 - Home Menu 00:00 Lesson 6 - Insert Menu 00:00 Lesson 7 - Page Layout Menu 00:00 Lesson 8 - Formulas Menu 00:00 Lesson 9 - Data Menu - Part 1 00:00 Lesson 10 - Data Menu - Part 2 00:00 Lesson 11 - Review Menu 00:00 Lesson 12 - View Menu 00:00 Lesson 13 - Templates 00:00 Lesson 14 - Dates 00:00 Lesson 15 - Numbers 00:00 Lesson 16 - Text 00:00 Lesson 17 - B - Calculations-Manual 00:00 Lesson 18 - Calculations 00:00 Lesson 19 - Page Set Up 00:00 Lesson 20 - Print Settings 00:00 Lesson 21 - Conclusion 00:00 Microsoft Excel 2016 Advanced Lesson 1 - Overview 00:00 Lesson 2 - Calculations - Absolute References 00:00 Lesson 3 - Calculations - Relative References 00:00 Lesson 4 - Using Logical Formulas 00:00 Lesson 5 - Using Text Formulas 00:00 Lesson 6 - Using Lookup Formulas 00:00 Lesson 7 - Using Financial Formulas 00:00 Lesson 8 - Using Date and Time Formulas 00:00 Lesson 9 - Sorting Data 00:00 Lesson 10 - Formatting Data into Tables 00:00 Lesson 11 - Using Pivot Tables - Part 1 00:00 Lesson 12 Using Pivot Tables - Part 2 - Design 00:00 Lesson 13 - Formatting Data as Charts 00:00 Lesson 14 - Formatting As Data as Maps 00:00 Lesson 15 - Formatting Data as Formal Reports 00:00 Lesson 16 - Formatting Data for Other Office Documents 00:00 Lesson 17 - Cell Protection and Collaboration 00:00 Lesson 18 - Cell Protection and Collaboration - Part 2 00:00 Lesson 19 - Interface with Google Sheets 00:00 Lesson 20 - Conclusion 00:00

Overview This Microsoft Excel Course for Everyone - Complete Excel Course is your passport to spreadsheet mastery.Explore Excel in detail and improve your abilities with practical activities that go beyond boring lectures. Take on spreadsheets like an expert, from data entry to difficult formulas and eye-catching graphics. But the magic doesn't end there! After finishing successfully, you'll not only impress with your proficiency with Excel, but you'll also obtain a respected CPD certification to enhance your CV and make a statement in the job market. Consider it your golden ticket to go up in your job!Enrol right away to see how your confidence and chances rise! Don't wait! How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel Course for Everyone - Complete Excel Course. It is available to all students, of all academic backgrounds. Requirements Compatible with a wide range of gadgets, including smartphones, tablets, laptops, Macs, and PCs. Particularly designed to be easily accessed with an internet connection on tablets and smartphones. No strict deadlines; learn whenever it's convenient for you. Individuals with basic English proficiency. Career Path After completing this course, it will increase the value of your CV and open you up to multiple sectors, such as : Data Analyst: £25,000 - £50,000 per year Financial Analyst: £30,000 - £60,000 per year Operations Manager: £35,000 - £70,000 per year Accountant: £25,000 - £50,000 per year Business Intelligence Analyst: £35,000 - £65,000 per year These salary ranges can vary based on factors such as experience, location, and the specific industry of the business. Course Curriculum 15 sections • 80 lectures • 06:51:00 total length •Introduction: 00:03:00 •Course Curriculum: 00:04:00 •Getting started on Windows, macOS, Android, and IOS: 00:01:00 •How to ask great questions: 00:02:00 •FAQ's: 00:01:00 •Starting Excel: 00:04:00 •Introduction: 00:02:00 •Worksheet basics: 00:22:00 •Entering values and formulas: 00:12:00 •Data formats: 00:10:00 •Data handling basics - cut copy and paste: 00:07:00 •Save and print in excel: 00:10:00 •Excel Ranges: 00:05:00 •Introduction: 00:01:00 •Basic formula operations: 00:06:00 •Mathematical functions level 1: 00:20:00 •Mathematical functions level 2: 00:12:00 •Text functions level 1: 00:09:00 •Text functions level 2: 00:13:00 •Logical functions: 00:11:00 •Date time functions: 00:06:00 •V Lookup formula: 00:12:00 •HLookup formula: 00:04:00 •HLookup + Match formula: 00:09:00 •Match + Index formula: 00:05:00 •Introduction: 00:02:00 •XLookup: 00:08:00 •Handling #NA and Approximates match in XLookup: 00:11:00 •Wildcard matching in XLookup: 00:06:00 •Introduction: 00:02:00 •Split text into columns: 00:07:00 •Flash Fill: 00:07:00 •Remove Duplicates: 00:08:00 •Data Validation: 00:07:00 •Get- import Data from Text: 00:06:00 •Get - import Data from CSV: 00:03:00 •Introduction: 00:01:00 •Formatting Font: 00:04:00 •Formatting Alignment: 00:06:00 •Formatting Number: 00:05:00 •Formatting Date: 00:03:00 •Formatting tables: 00:05:00 •Introduction: 00:01:00 •Creating Pivot Table: 00:07:00 •Value field settings: 00:04:00 •Number format: 00:02:00 •Pivot Table Design: 00:03:00 •Excel Exercise: 00:01:00 •Solution for Excel Exercise: 00:02:00 •Introduction: 00:01:00 •Excel Charts - Categories: 00:03:00 •Elements of a chart: 00:04:00 •Easy way to create charts: 00:02:00 •Column or Bar charts: 00:04:00 •Formatting charts: 00:04:00 •Line charts: 00:02:00 •Area charts: 00:02:00 •Pie and Doughnut charts: 00:04:00 •Format AreaPlot or XY chart: 00:08:00 •Scatter or bubble charts: 00:02:00 •Introduction: 00:01:00 •Frequency Distribution and Histograms: 00:04:00 •Waterfall charts: 00:02:00 •Hierarchy charts: sunburst and tree map: 00:03:00 •Combination charts: 00:02:00 •Sparklines: 00:05:00 •Pivot charts: 00:02:00 •Maps chart: 00:04:00 •3D Maps chart: 00:03:00 •Introduction: 00:01:00 •Stock charts: 00:02:00 •Radar charts: 00:02:00 •Surface charts: 00:02:00 •Heat maps: 00:04:00 •Named ranges: 00:05:00 •Indirect Name range Function: 00:06:00 •Import Data table from PDF file - Excel 2021: 00:04:00 •Import Data from Website - Excel 2019 above: 00:09:00 •Project: Sales forecast tracker: 00:07:00 •Product Sale Tax invoice: Tax Calculations: 00:05:00

🌟 Unlock Your Excel Potential with Microsoft Excel 2019 - Intermediate Level Training! 🌟 Master the art of Excel with our comprehensive online course designed specifically for intermediate learners. Elevate your skills, boost productivity, and excel in spreadsheet management like never before. 📊 Course Curriculum 📊 🔹 Section 1 - Excel - Intermediate: Dive into the intermediate level of Excel functionalities, bridging the gap between basic and advanced techniques. 🔹 Section 2 - Lists: Learn the art of managing data efficiently with lists, organizing information for streamlined analysis and presentation. 🔹 Section 3 - DataBase Functions: Harness the power of database functions, empowering you to manipulate data with ease and precision. 🔹 Section 4 - Data Validation: Ensure data accuracy and integrity by implementing effective data validation techniques, preventing errors in your spreadsheets. 🔹 Section 5 - Importing and Exporting: Master the process of importing and exporting data seamlessly, integrating external information into your Excel sheets effortlessly. 🔹 Section 6 - Creating Basic Charts: Transform data into impactful visuals with basic chart creation, enhancing your ability to communicate insights effectively. 🔹 Section 7 - Pivot Tables: Unlock the potential of pivot tables, harnessing their analytical power to summarize and analyze complex data sets effortlessly. 🔹 Section 8 - Working with Large Data: Navigate and manipulate extensive data sets efficiently, optimizing your workflow with strategies tailored for large-scale information. 🔹 Section 9 - LookUp Functions: Explore lookup functions to search for and retrieve specific data, refining your ability to find information swiftly. 🔹 Section 10 - Advanced Functions: Elevate your Excel proficiency with advanced functions, expanding your capabilities to handle complex calculations and tasks. 🔹 Section 11 - Excel Intermediate - Conclusion: Wrap up your intermediate Excel journey, reinforcing key concepts and preparing you for further advancements. 🎓 Why Choose Our Course? 🎓 🚀 Comprehensive Learning: A structured curriculum tailored to the needs of intermediate Excel users, covering a wide array of functionalities. 👨‍🏫 Expert Guidance: Led by industry experts well-versed in Excel, ensuring a rich learning experience with practical insights. 🤝 Interactive Learning: Engage with interactive exercises and real-life examples, solidifying your understanding through hands-on practice. 📈 Career Growth: Acquire skills highly sought after in the job market, giving you a competitive edge in various professional domains. 🔓 Don't miss this opportunity to take your Excel skills to the next level! Enroll now and unleash your potential with Microsoft Excel 2019 - Intermediate Level Training. 🔓 Course Curriculum Section 1 - Excel - Intermediate Excel Intermediate Introduction 00:00 Intermediate Shortcut Keys 00:00 Section 2 - Lists What are Lists 00:00 Sorting a List 00:00 Sorting - Multiple Criteria 00:00 Custom Sort 00:00 What are Filters 00:00 Format a List as a Table 00:00 Section 3 - DataBase Functions Introduction to DataBase Functions 00:00 DSum Function 00:00 DSum Function - Single Criteria 00:00 DSum Function - Multiple Criteria 00:00 DAverage 00:00 DCount Function 00:00 Subtotal 00:00 Section 4 - Data Validation Data Validation - List 00:00 Data Validation - Decimal 00:00 Input and Error Messages 00:00 Section 5 - Importing and Exporting Importing Data from Text Files 00:00 Importing Data from MS Access 00:00 Exporting Data to a Text File 00:00 Section 6 - Creating Basic Charts Creating Basic Charts 00:00 The Chart Ribbon 00:00 Adding and Modifying Data on a Chart 00:00 Formatting Charts 00:00 Section 7 - Pivot Tables Understanding Pivot Tables 00:00 Creating Pivot Tables 00:00 Pivot Table Calculations 00:00 Grouping Pivot Table Data 00:00 Formatting Pivot Table Data 00:00 Drilling Down into Pivot Table Data 00:00 Creating Pivot Charts 00:00 Filtering Pivot Table Data 00:00 Filtering using the Slicer 00:00 Section 8 - Working with Large Data Grouping Data 00:00 Consolidating Data 00:00 Section 9 - LookUp Functions VLookUp 00:00 HLookUp 00:00 Index and Match 00:00 Section 10 - Advanced Functions FV Function 00:00 PMT Function 00:00 Hyperlinks 00:00 Text to Columns 00:00 Section 11 - Excel Intermediate - Conclusion Excel Intermediate - Conclusion 00:00