52702 Courses delivered Online

In an increasingly digital age, protecting oneself and others online is more than just a good idea—it’s essential. The Online Safety and Harms Protection Course guides you through the risks, threats, and behaviours that shape today’s internet landscape. From harmful content and misinformation to cyberbullying and online exploitation, this course offers a strong awareness-focused foundation to help navigate online spaces more securely and responsibly. Designed to suit learners from all backgrounds, the course uses clear explanations and structured insights to address the growing concerns surrounding online activity. You’ll explore strategies for recognising risk, supporting vulnerable individuals, and promoting positive online engagement. Whether you're a parent, educator, or simply curious about digital safety, this course helps you stay one step ahead in an ever-evolving digital environment—without the jargon or the fluff. Course Curriculum Module 1 The Growth Of The Internet Module 2 Introduction To Online Safety Module 3 Conceptualising Online Risk Module 4 Online Risks And Harms Contact, Conduct, And Commerce Module 5 Your Responsibilities Module 6 Teaching Online Safety And Harms Module 7 Cyberbullying Module 8 Hackers, Crackers, Criminals And Cons Module 9 Addiction And Other Health Risk Module 10 Laws And Regulations Module 11 Staying Safe On The Internet Module 12 Posting Photos And Videos Safely Module 13 Sharing Information With Others Module 14 Protecting Children Upon successful completion, you will qualify for the UK and internationally-recognised CPD accredited certification. You can choose to make your achievement formal by obtaining your PDF Certificate at the cost of £9 and Hard Copy Certificate for £15. CPD 10 CPD hours / points Accredited by CPD Quality Standards

Architecture is the art and science of designing and building structures. It is a complex and ever-evolving field that encompasses a wide range of topics, from the history of architecture to the latest building technologies. The course covers a wide range of topics, including the history of architecture, architectural styles, interior design, and lighting design. Learning outcomes of Architecture Bundle: Understand the history and development of architecture Identify and describe different architectural styles Apply principles of interior design Use lighting to create different atmospheres Understand the relationship between architecture and society Analyze architectural drawings and plans Create architectural drawings and plans Communicate effectively about architecture This Architecture Bundle Consists of the following Premium courses: Course 01: Architectural Studies Course 02: AutoCAD VBA Programming - Beginner course Course 03: Mastering Colour-Architectural Design & Interior Decoration Course 04: Revit Architecture Ultimate Interior Design Course Course 05: Revit Architecture Ultimate Exterior Design for Beginners Course 06: Revit Architecture Advanced Exterior Design Course Course 07: Autodesk Revit: Modeling & Rendering Course 08: WELL Building Standard Course 09: LEED V4: Building Design and Construction Course 10: Building Surveyor Course 11: Construction Industry Scheme (CIS) Enroll in the Architecture bundle course today and learn more about the art and science of designing buildings and structures! The Architecture bundle course is an introduction to the art and science of architecture. The course covers a wide range of topics, from the history of architecture to the principles of design. You will learn about different architectural styles, from ancient to modern, and will gain an understanding of the factors that influence architectural design. You will also learn about interior design, including the principles of colour theory and lighting design. The curriculum of Architecture Bundle Course 01: Architectural Studies Introduction Ancient Architecture Architectural Ideas and Movements Architectural Styles Art Deco Architectural Style Scandinavian Architectural Style Victorian Architectural Style Classical and Early Christian Architectural Style Gothic Architectural Style Baroque and Rococo Architectural Style Eclecticism Architectural Style Modern and Post-Modern Architectural Style Interior Designing Colour in Interior Designing Lighting in Interior Design Part One Lighting in Interior Design Part Two Course 02: AutoCAD VBA Programming - Beginner course Introduction VBA Integrated Development Environment (IDE) Understanding AutoCAD Object Model in VBA Using Variables in VBA User Forms and Controls Conditionals and Decisions in VBA Looping and Iterations in VBA Drawings Objects in VBA Code Debugging in VBA Error Handling in VBA Conclusion Course 03: Mastering Colour-Architectural Design & Interior Decoration Introduction The Impact of Fashion and Colour Trends Colour Terminology Colour Basics and Neutral Colours Warm vs. Cool Colours Colour Schemes Colour Ratios and Applications Using Colour to Trick the Eye Conclusion ===> And 8 More Courses <=== How will I get my Certificate? After successfully completing the Architecture bundle course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) PS The delivery charge inside the UK is £3.99, and international students have to pay £9.99. Enroll in the Architecture Bundle course today and learn about the art and science of designing buildings and structures! CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Students who are interested in learning about architecture Professionals who want to brush up on their architectural knowledge Anyone who is curious about the history and development of architecture People who want to develop their critical thinking and problem-solving skills Those who want to pursue a career in architecture, design, or construction Requirements This Architecture course has been designed to be fully compatible with tablets and smartphones. Career path Having this Architecture bundle course will increase the value of your CV and open you up to multiple job sectors. Architect: £25,000 - £75,000 Interior designer: £20,000 - £50,000 Lighting designer: £20,000 - £40,000 Construction manager: £30,000 - £60,000 Urban planner: £25,000 - £50,000 Historic preservationist: £20,000 - £40,000 Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Architectural Studies) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

Construction Site Management Accredited Career Bundle Are you ready to take charge of construction site management from the comfort of your own space? The Construction Site Management Accredited Career Bundle Course provides everything you need to gain a deep understanding of site management principles. With this course, you’ll gain in-depth knowledge of essential topics like risk management, planning, safety regulations, and project coordination – all designed to keep your site running smoothly and safely. You’ll navigate the complexities of managing teams, resources, and timelines, all while honing your skills in essential management techniques. Whether you’re looking to advance in the industry or explore new opportunities, this course is tailored for anyone keen to learn the ins and outs of construction site management. It’s not just about knowing how to manage a site; it’s about understanding how to keep things efficient, productive, and safe. The course offers a structured and engaging learning journey, designed to equip you with the tools to make smart decisions and manage complex tasks effectively. If you’re keen to enhance your career in construction site management, this bundle will serve as the perfect guide. Key Features of this Career Bundle CPD Accredited Courses Instant PDF certificate Fully online, interactive course Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Construction Site Management Courses : Construction Site Management Construction Management PPE CMD Site Safety Management Health And Safety At Work Emergency First aid at work Risk Assessment Construction Project Management Site Management Asbestos Awareness & Safety Property Development Diploma Working at Height Working at Confined Space Coshh Noise Awareness Abrasive Wheels Leadership Skills Communication Skills Deligation Conflict Resolution Covid-19 Awareness Course Accreditation These Construction Site Management bundle courses are CPD accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Construction Site Management course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 220 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Construction Site Management bundle is ideal for anyone looking to start a career in the field, which includes the following related professions: Project Manager Building Inspector Site Engineer Site Coordinator Site Foreman Construction Site Supervisor Safety, Health and Environment Executive Requirements No prior degree or experience is required to enrol in this Construction Site Management course. Career path This Site Management Course will help you to explore avariety of career paths in the related industry, including: Site Manager Site Supervisor Construction Project Manager Building Inspector Site Engineer Construction Coordinator Health and Safety Manager Quantity Surveyor Contracts Manager Facilities Manager Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

Sales Overview: Delivery Driver Online Course Are you ready to embark on a fulfilling career as a delivery driver? Welcome to our comprehensive 'Delivery Driver Online Course' designed to equip you with the essential skills, knowledge, and strategies to excel in the dynamic world of delivery driving. Whether you're delivering food, packages, or goods, this course is your passport to success on the road.   Module 1: Introduction to Delivery Driver In this introductory module, you'll gain insights into the role of a delivery driver, its significance in various industries, and the opportunities it offers. Understand the responsibilities, expectations, and potential career paths available to delivery drivers. Module 2: Challenges and Strategies for Delivery Drivers Navigate through the unique challenges faced by delivery drivers, from time management to navigating through traffic. Learn effective strategies to overcome obstacles, optimize routes, and ensure timely deliveries, even in the most demanding situations. Module 3: Safety Considerations and Best Practices for Delivery Drivers Safety is paramount in delivery driving. Explore safety protocols, defensive driving techniques, and hazard awareness to minimize risks and protect yourself, your cargo, and others on the road. From inclement weather to handling emergencies, you'll be prepared for any scenario. Module 4: Customer Service Skills for Delivery Drivers Delivering more than just packages, this module hones your customer service skills to delight customers with every delivery. From professionalism to handling customer inquiries and complaints, learn how to leave a positive and lasting impression. Module 5: Tools and Technologies for Efficient Delivery Driving Discover the latest tools, technologies, and apps that streamline delivery operations and enhance efficiency. From GPS navigation systems to route optimization software, leverage cutting-edge solutions to maximize productivity and minimize downtime. Module 6: Ethical Considerations and Challenges for Delivery Drivers Ethics and integrity are the cornerstones of successful delivery driving. Explore ethical dilemmas, privacy concerns, and legal considerations that impact delivery drivers. Uphold ethical standards and navigate through challenging situations with integrity and professionalism. Module 7: Recap and Future Development as a Delivery Driver In this concluding module, reflect on your journey as a delivery driver and identify areas for growth and development. Set goals, explore opportunities for advancement, and chart your course for continued success in the dynamic field of delivery driving.   Why Choose Our Delivery Driver Online Course? Flexible Learning: Access modules anytime, anywhere, and at your own pace. Expert Guidance: Learn from industry professionals and subject matter experts. Interactive Content: Engaging multimedia content, quizzes, and practical exercises enhance learning retention. Career Advancement: Gain a competitive edge and unlock opportunities for career advancement in the delivery industry.   Don't miss this opportunity to elevate your delivery driving skills and embark on a rewarding career journey. Enroll in our 'Delivery Driver Online Course' today and drive your success on the road ahead! Course Curriculum Module 1: Introduction to Delivery Driver Introduction to Delivery Driver 00:00 Module 2: Challenges and Strategies for Delivery Drivers Challenges and Strategies for Delivery Drivers 00:00 Module 3: Safety Considerations and Best Practices for Delivery Drivers Safety Considerations and Best Practices for Delivery Drivers 00:00 Module 4: Customer Service Skills for Delivery Drivers Customer Service Skills for Delivery Drivers 00:00 Module 5: Tools and Technologies for Efficient Delivery Driving Tools and Technologies for Efficient Delivery Driving 00:00 Module 6: Ethical Considerations and Challenges for Delivery Drivers Ethical Considerations and Challenges for Delivery Drivers 00:00 Module 7: Recap and Future Development as a Delivery Driver Recap and Future Development as a Delivery Driver 00:00

Description Safeguarding Children and vulnerable young Adults Diploma It may come as a surprise to many that there are actual diploma courses in Safeguarding Children and vulnerable young Adults. The target audience consists of individuals who interact with this set on a daily basis, for instance, teachers, social workers, child advocates, counsellors etc. to warrant their safety and welfare. In our society, a lot of children go through abuse and ill-treatment. It is, therefore, the duty of adults to protect them and nurture them in a healthy environment. This course will touch upon important ideas like helping children maximize their potential, developing their skills and safeguarding them. It will enable all participants to hone the knowledge and abilities required to exercise this responsibility. Working with and for children is a satisfying and rewarding career choice that can help you to make a difference. As a community, our aim should be to develop a safe atmosphere for children and youngsters to prosper and grow into fine mature adults. The technical definition of a child is someone between the stage of infancy and adulthood. According to The United Nations Convention of 1989, on the Rights of the child, a child is an individual aged 0 to 18 years. The British criminal law, however, considers any person up to 14 years of age as a child, although they may be convicted from the age of 10 for any crime or offence. Consequently, an individual between 14 to 19 years of age is categorized as a teenager, youngster or adolescent. A person's progress and growth are contingent on many environmental and genetic factors. When these are affected negatively, so will the youngster's development. Even though the term 'Safeguarding' does not have a legal definition, it may be thought of in its basic form as 'keeping the children safe from any abuse, injury, illness or harm'. Post the execution of 'Every Child Matters' agenda, 'Safeguarding' has replaced the term 'Child Protection'. It is now the responsibility of each professional who works for and with children and adolescents to protect them emotionally, physically and sexually and to ensure that they are not neglected in any way by extending proper care. Children and young adults are easy targets and thus prone to being harmed in a lot of ways. It may not seem obvious to an outsider and hence, they need to keep their eyes and ears open to ensure the safety of the ward. What You Will Learn 1. Attachment and Bonding 2. Safeguarding In General 3. Safeguarding Children, Young People and Vulnerable Adults 4. Human trafficking and modern-day slavery 5. Radicalisation and Extremism 6. Strengths-based social care for children, young people and their families Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

Scrum Product Owner Workshop: In-House Training: Virtual In-House Training The Product Owner is responsible for maximizing the value of the product and the work of the Development Team. The Product Owner must be knowledgeable, available, and empowered to make decisions quickly in order for an Agile project to be successful. The Product Owner's key accountability is the Product Backlog. Managing, maintaining, and evolving the Product Backlog involves: Establishing a clear Vision that engages the Development Team and stakeholders Clearly expressing Product Backlog items Ordering the items in the Product Backlog to best achieve the Vision and goals Ensuring that the Product Backlog is visible, transparent, and clear to all Working with the Development Team throughout the project to create a product that fits the customer's needs The overall course goal is to support you in becoming an effective Product Owner. What you will Learn You'll learn how to: Differentiate between poor, good, and great Product Owner attributes, and their impact on the team, product, stakeholders, and the organization Engage your stakeholders by knowing your customers and market Develop an effective and value-driven Product Backlog Evaluate the Product Owner's role in Scrum's 5 events and team engagement Foundation Concepts Agile foundation Product owner role Product Ownership Product ownership Project vision Understanding your customers and market Personas Stakeholder management and engagement The Product Backlog Epics and user stories Preparing user stories for a sprint The product backlog Visualizing the product backlog Product backlog prioritization Technical debt Sprint Planning and Delivery Sprint planning The sprint Sprint Reviews, Retrospectives, and Closing Sprint reviews Key agile patterns Retrospectives Closing the project

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that in the UK, 80% of businesses use spreadsheets according to a recent study? Spreadsheets are a fundamental part of many businesses, but are you getting the most out of them? Proficiency in Excel is a highly sought-after skill in the UK. The average salary for an Excel expert can reach £50,000 and there's a consistent demand for qualified candidates across various industries.This comprehensive Microsoft Excel bundle can help you unlock the full potential of this powerful tool and take your career to the next level. With a single payment, you will gain access to Microsoft Excel course, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for Absolutely free. This Microsoft Excel Bundle Package includes: Main Course : Diploma in Complete Excel Course for All at QLS Level 5 10 Additional CPD Accredited Premium Courses related to Microsoft Excel: Course 01: Ultimate Microsoft Excel For Business Bootcamp Course 02: Business Data Analysis Course 03: Financial Modelling Using Excel Course 04: Microsoft Excel - Beginner, Intermediate & Advanced Course 05: Microsoft Excel Training: Depreciation Accounting Course 06: New Functions in Microsoft Excel Course 07: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 08: Microsoft Excel - 25 Must-Know Formulas and Functions Course 09: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 10: Microsoft Excel: Excel Sheet Comparison with VBA This Microsoft Excel course bundle is designed to take you from complete beginner to advanced user. You'll learn all the essential skills you need to manage data effectively, create impactful charts and graphs, and use formulas and functions to automate complex tasks. Whether you're looking to improve your financial modelling skills, build dynamic dashboards, or simply become more efficient with everyday spreadsheet tasks, this bundle has a course for you. Learning Outcomes of Microsoft Excel Master essential formulas and functions for data manipulation and analysis. Create dynamic charts and graphs to present data insights effectively. Automate tasks and workflows using advanced Excel features. Build interactive dashboards to monitor key performance indicators (KPIs). Learn best practices for data cleaning, organisation, and presentation. Explore VBA programming to further customise your spreadsheets. Invest in your future and enrol now to unlock exciting career possibilities with the power of Microsoft Excel! Why Choose Our Microsoft Excel Bundle? Get a Free QLS Endorsed Certificate upon completion of Microsoft Excel Get a free student ID card with Microsoft Excel Training The Microsoft Excel is affordable and simple to understand The Microsoft Excel is an entirely online, interactive lesson with voiceover audio Lifetime access to the Microsoft Excel course materials The Microsoft Excel comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Main Course : Diploma in Complete Excel Course for All at QLS Level 5 Section 01: Getting Started Section 02: Excel Basics Section 03: Excel Essential Functions Section 04: XLookup Only For Excel 2021 And Office 365 Section 05: Get Data And Tools Section 06: Formatting Data And Tables Section 07: Pivot Tables Section 08: Excel Charts Section 09: Advanced Excel Charts Section 10: Pivot Charts and much more... Course 01: Ultimate Microsoft Excel For Business Bootcamp Microsoft Excel 2019 New Features Getting Started With Microsoft Office Excel Performing Calculations Modifying A Worksheet Formatting A Worksheet Printing Workbooks Managing Workbooks Working With Functions Working With Lists Analyzing Data and much more... Course 02: Business Data Analysis Module 01: Introduction To Business Analysis Module 02: Business Environment Module 03: Business Processes Module 04: Business Analysis Planning And Monitoring Module 05: Strategic Analysis And Product Scope Module 06: Solution Evaluation Module 07: Investigation Techniques Module 08: Ratio Analysis Module 09: Stakeholder Analysis And Management Module 10: Process Improvement With Gap Analysis and much more... =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your QLS Endorsed Certificates and CPD Accredited Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £119) CPD 255 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 Microsoft Excel Training course. This course is ideal for:. Beginners Intermediate Users Advanced Users Data Analysts Business Professionals Anyone who wants to excel in Excel! Requirements You will not need any prior background or expertise to enrol in this Microsoft Excel bundle. Career path After completing this Microsoft Excel bundle, you are to start your career or begin the next phase of your career. Data Analyst Business Analyst Financial Analyst Project Manager Accountant Entrepreneur Certificates CPD QS Accredited PDF Certificate Digital certificate - Included Diploma in Complete Excel Course for All at QLS Level 5 Hard copy certificate - Included

The Professional Certificate Course in Supervisory Structure of International Banking Institutions and Markets is designed to provide a comprehensive understanding of the global financial system. This course covers key topics such as international financial markets, institutions, and regulations, the impact of globalization on the shadow banking system, institutions affecting lending and banking regulations, and international agreements regarding banking and finance. Upon completion, students will thoroughly understand the supervisory structure of international banking institutions and markets. The Professional Certificate Course in Supervisory Structure of the International Banking Institutions and Markets is a comprehensive program designed to provide students with a deep understanding of the global financial system. Students will gain a thorough understanding of the supervisory structure of international banking institutions and markets. After the successful completion of the course, you will be able to learn about the following, International financial Markets, Institutions and Regulations. Globalization and Shadow Banking System. Institutions affecting Lending and Banking Regulations. International Agreements regarding Banking and Finance.   The Professional Certificate Course in Supervisory Structure of the International Banking Institutions and Markets is designed to provide a comprehensive understanding of the global financial system. This course covers key topics such as international financial markets, institutions, and regulations, the impact of globalization on the shadow banking system, institutions affecting lending and banking regulations, and international agreements regarding banking and finance. Upon completion, students will have a thorough understanding of the supervisory structure of international banking institutions and markets. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Supervisory Structure of the International Banking Institutions and Markets Self-paced pre-recorded learning content on this topic. Supervisory Structure of the International Banking Institutions and Markets Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. Banking professionals Financial regulators Government officials Business executives Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Tailored training courses: In, 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction 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