1076 Courses in Bristol delivered Online

🌟 Unlock the Full Power of Microsoft Excel 2019! 🌟 Ready to take your Excel skills to the next level? Dive into our comprehensive online course - 'Microsoft Excel 2019 - Advanced Level Training' - designed to transform you into an Excel maestro! 🚀 Here's What You'll Master: 📊 Section 1: Excel - Advanced - Get hands-on with advanced techniques and shortcuts to streamline your workflow. 📂 Section 2: Working with Multiple Workbooks - Seamlessly manage multiple workbooks and boost your productivity effortlessly. 🔒 Section 3: Protecting Worksheets and Workbooks - Learn how to safeguard your data with robust protection strategies. 📝 Section 4: Conditional Formulas - Unravel the power of conditional logic and unleash the true potential of formulas. 🧮 Section 5: Advanced Functions - Elevate your Excel expertise by mastering complex functions for data analysis. 📚 Section 6: Text Based Functions - Manipulate text effortlessly and efficiently with advanced text-based functions. 🔍 Section 7: What IF Tools - Explore the 'What If' analysis tools to make informed decisions and predictions. 🏁 Section 8: Excel Advanced - Conclusion - Wrap up with a comprehensive understanding and practical application of advanced Excel features. 🎁 Section 9: Bonus #1 - Advanced Pivot Tables - Delve into bonus content covering advanced techniques for Pivot Tables, a must-have skill for data analysis pros. 🌟 Why Choose Our Course? 🔐 Expert Guidance: Led by seasoned Excel professionals, ensuring clarity and depth in learning. 🔄 Practical Assignments: Apply your newfound skills through real-world exercises. 📈 Career Growth: Elevate your career prospects by mastering sought-after Excel abilities. 🌐 Accessible Learning: Study at your own pace from anywhere, anytime with our user-friendly online platform. 🤝 Join our vibrant community of learners dedicated to mastering Excel's advanced functionalities. 💡 Enroll now and revolutionize your Excel prowess with 'Microsoft Excel 2019 - Advanced Level Training'! Don't miss this chance to become an Excel wizard! 💡   Course Curriculum Section 1 - Excel - Advanced Excel Advanced Introduction 01:39 Advanced Shortcut Keys 02:58 Section 2 - Working with Multiple Workbooks Tracing Precedents 00:00 Tracing Dependants 00:00 Watch Window 00:00 Show Formulas 00:00 Section 3 - Protecting Worksheets and Workbooks Protecting Cells in a Worksheet 00:00 Protecting the Workbook Structure 00:00 Encryption with Passwords 00:00 Section 4 - Conditional Formulas Name Ranges 00:00 Simple IF Function 00:00 IF, AND 00:00 IF, OR 00:00 Nested Formulas 00:00 CountIF and CountIFs 00:00 SumIF and SumIFs 00:00 Section 5 - Advanced Functions Advanced VLookUp 00:00 IF and IS Error - Part 1 00:00 IF and IS Error - Part 2 00:00 Advanced Index Match 00:00 Dates - Part 1 00:00 Dates - Part 2 00:00 Replace and Substitute - Part 1 00:00 Replace and Substitute - Part 2 00:00 Section 6 - Text Based Functions Left, Right and Mid Function 00:00 Search Function 00:00 Concatenate and Search 00:00 Indirect - Static 00:00 Indirect - Dynamic 00:00 Section 7 - What IF Tools Goal Seek 00:00 Data Tables 00:00 Scenarios 00:00 Solver 00:00 Section 8 - Excel Advanced - Conclusion Excel Advanced - Conclusion 00:00 Section 9 - Bonus # 1 - Advanced Pivot Tables Building a Mini Dashboard 00:00

Best Saving Deal | 17-in-1 Premium Bundle | 170 CPD Points | Free PDF & transcript Certificates | Lifetime Access

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 classroom, 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. 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

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Diploma in Customer Relationship Management (CRM) Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Diploma in Customer Relationship Management (CRM) Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Diploma in Customer Relationship Management (CRM) Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Diploma in Customer Relationship Management (CRM) Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Diploma in Customer Relationship Management (CRM)? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Diploma in Customer Relationship Management (CRM) there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Diploma in Customer Relationship Management (CRM) course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Diploma in Customer Relationship Management (CRM) does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Diploma in Customer Relationship Management (CRM) was made by professionals and it is compatible with all PCs, Macs, tablets, and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Diploma in Customer Relationship Management (CRM) is a great way for you to gain multiple skills from the comfort of your home.   Module 01: Introduction to Customer Relationship Management (CRM) Introduction to Customer Relationship Management (CRM) 00:22:00 Module 02: CRM Fundamentals CRM Fundamentals 00:24:00 Module 03: CRM Strategies CRM Strategies 00:33:00 Module 04: Data Analysis in CRM Data Analysis in CRM 00:28:00 Module 05: CRM Databases CRM Databases 00:21:00 Module 06: Deepening Customer Relationship Deepening Customer Relationship 00:23:00 Module 07: Handling Customer Complaints Handling Customer Complaints 00:22:00 Module 08: Future of CRM Future of CRM 00:25:00 Assignment Assignment - Diploma in Customer Relationship Management (CRM) 02:30:00 Recommended Materials Workbook - Diploma in Customer Relationship Management (CRM) 03:47:00 Order Your Certificate Order Your Certificate QLS

In this course, students will learn general strategies for planning, designing, developing, implementing, and maintaining an IoT system through various case studies and by assembling and configuring an IoT device to work in a sensor network.

Are you intrigued by the fascinating world of laboratories? Wondering how you can embark on a rewarding career as a Lab Technician? Look no further than our comprehensive course bundle in Lab Technician, Microbiology, and Biomedical Science. In today's scientific landscape, the demand for skilled Lab Technicians is soaring. From conducting experiments to analysing data, Lab Technicians play a crucial role in various fields, including research institutions, healthcare facilities, and industrial laboratories. Our course bundle equips you with the knowledge and expertise necessary to excel in this dynamic profession. By enrolling in our program, you will delve into the intricacies of laboratory techniques, safety protocols, and data analysis methods. From handling samples to operating cutting-edge equipment, you will develop essential skills that are essential for conducting experiments with precision and accuracy. The course bundle comprises of the following eight comprehensive courses: Laboratory Technician Diploma Diploma In Microbiology Biomedical Science Basic Biology DNA and Genealogy Genetics Infection Control PPE Legislation and Compliance Learning Outcomes: Develop a comprehensive understanding of laboratory techniques and procedures for conducting scientific experiments. Gain knowledge of the principles and applications of microbiology, including the study of microorganisms, their growth, and identification. Acquire a deep understanding of biomedical science, exploring the interplay between biology and medical applications. Establish a solid foundation in basic biology, covering fundamental concepts and principles of living organisms. Explore the field of DNA and genealogy, understanding the role of DNA in determining ancestry and genealogical relationships. Gain insight into the principles of genetics, including inheritance patterns, gene expression, and genetic variation. Laboratory Technician Diploma: Master laboratory techniques, safety protocols, and data analysis methods. Gain practical skills in sample handling, equipment operation, and quality control. Develop proficiency in record-keeping and report writing. Join a supportive learning community. Diploma In Microbiology: Explore microorganisms and their impact on health, disease, and industries. Learn lab techniques for isolating and identifying microorganisms. Understand microbial genetics and applications in biotechnology. Contribute to public health. Biomedical Science: Discover the link between biology and medicine. Study human body systems, disease mechanisms, and diagnostic methods. Gain lab skills in cell culture and molecular biology. Prepare for a career in research or healthcare. Basic Biology: Build a foundation in biological principles. Study cells, genetics, and evolution. Analyse ecological interactions and biodiversity. Apply biology to medicine, agriculture, and conservation. DNA and Genealogy: Uncover ancestral connections through DNA analysis. Learn DNA structure and gene expression. Explore inheritance patterns and genetic testing. Interpret genetic data and trace family lineages. Genetics: Deepen your understanding of inheritance and genetic variation. Study gene expression, genetic disorders, and modern genetic technologies. Analyse complex traits and population genetics. Contribute to research and healthcare. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring laboratory technicians in research, healthcare, or industry. Those interested in microorganisms, their role, and applications. Individuals seeking a biomedical science career or further study. Those wanting a solid foundation in basic biology for various fields. Career path Laboratory Technician: £18K to £30K/year Microbiologist: £20K to £40K/year Biomedical Scientist: £25K to £45K/year Genetic Technologist: £25K to £40K/year Research Assistant: £20K to £35K/year Healthcare Scientist: £30K to £50K/year Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

Recognised Accreditation 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. 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. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. 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. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Managerial Skills For Managers Small Business Fundamentals Crash Course Mini MBA - Foundations of Business Strategy Consulting Entrepreneur Mindset Masterclass Situational Leadership Training Project Management Training Team Building Masterclass Complete Online Marketing & Advertising Course Outstanding Customer Service - The Ultimate Guide! Personal / Business Networking Skills For Maximum Success! Six Sigma - Business and Manufacturing Process Improvement Risk Management in Projects, Programs and Portfolios Supply Chain Management Data Analysis For Professionals Obtain Your Certificate Order Your Certificate of Achievement 00:00:00

Remote sensing technology has transformed the way we perceive and analyse the Earth’s surface. With a broad range of applications from agriculture and environmental management to urban planning and climate research, this course introduces learners to the core concepts and techniques that underpin this fascinating field. Over the duration of this course, you’ll gain a solid foundation in remote sensing principles, satellite data interpretation, and various imaging systems that provide invaluable insights into our planet. The course is designed to equip you with the knowledge necessary to understand the growing significance of remote sensing in solving complex global challenges. Whether you're a student of environmental science, geography, or simply curious about the potential of remote sensing technology, this course will enhance your understanding of how we collect and process data remotely. By exploring the key technologies used in satellite imagery, radar systems, and the application of data for decision-making, you'll be poised to explore the wide range of industries that benefit from this technology. This course is an ideal starting point for those wishing to pursue further study or a career in geospatial technologies. Step into the world of remote sensing and uncover how these advanced systems can make a real impact on our world. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: Introduction to Remote Sensing Module 02: Electromagnetic Spectrum and Remote Sensing Module 03: Platforms and Sensors Module 04: Image Interpretation Module 05: Remote Sensing Data Analysis Module 06: Applications of Remote Sensing in the UK Module 07: Future Trends in Remote Sensing Learning Outcomes: Master electromagnetic spectrum concepts crucial for remote sensing proficiency. Acquire knowledge of diverse platforms and sensors employed in the field. Develop expertise in interpreting intricate visual data from remote sensing. Hone skills in remote sensing data analysis tailored to the UK landscape. Explore applications spanning environmental monitoring to urban planning. Stay ahead by understanding the future trends shaping remote sensing technology. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Enthusiasts eager to explore remote sensing technology. Students aspiring to deepen their knowledge in earth observation. Professionals seeking to enhance their skill set in geospatial analysis. Government employees involved in environmental monitoring. Researchers interested in leveraging remote sensing for diverse studies. Urban planners aiming to integrate technology into city development. Geographers keen on applying remote sensing in their research. Anyone intrigued by the future possibilities of remote sensing technology. Career path Environmental Analyst GIS Specialist Satellite Data Analyst Urban Planner Remote Sensing Researcher Geospatial Consultant Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Be fully equipped for a lucrative career and assured future in QuickBooks Bookkeeping by learning to be a bookkeeper skilled at using QuickBooks. Take our Advanced Diploma in QuickBooks Online Bookkeeping course, and you'll be trained in the most sought-after accounting skill, as well as being familiar with the industry-standard software. Every successful company has a gifted bookkeeper working on their finances and almost certainly using QuickBooks. This course will quickly teach you all the necessary techniques for this form of accounting, with many tips and recommendations on how to customise the software to fit all your business needs. Enrol now and start your new career in finance. Courses included with this bundle Course 01: Diploma in QuickBooks Bookkeeping Course 02: Financial Modeling Using Excel Course 03: Team Management Course 04: Data Analysis in Excel Level 3 Course Course 05: Business Analysis Level 3 Course 06: Accounting and Tax Course 07: Fraud Management & Anti Money Laundering Awareness Complete Diploma Course 08: Time Management Course 09: Performance Management Course 10: Decision Making Course 11: Quality Management Enrol now in this QuickBooks bundle now! Course Curriculum of QuickBooks Bundle Course 1: Diploma in QuickBooks Bookkeeping Getting prepared - access the software and course materials Getting started Setting up the system Nominal ledger Customers Suppliers Sales ledger Purchases ledger Sundry payments Sundry receipts Petty cash VAT - Value Added Tax Bank reconciliation Payroll / Wages Reports Tasks CPD 110 CPD hours / points Accredited by CPD Quality Standards 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 (Diploma in Quickbooks Bookkeeping) 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.

The Internet of Things (IoT) promises a wide range of benefits for industry, energy and utility companies, municipalities, healthcare, and consumers. Data can be collected in extraordinary volume and detail regarding almost anything worth measuring, such as public health and safety, the environment, industrial and agricultural production, energy, and utilities.