10933 Courses delivered Online

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report

Advanced Professional Certificate Courses These are short online certificate courses of a more advanced nature designed to help you develop professionally and achieve your career goals, while you earn a professional certificate which qualifies you for the appropriate continuous professional development (CPD). Advanced Professional Certificate in Commercial Trust Law The course explores the principles and nature of Equity as a separate and fundamental source of common law. The course introduces critical historical events that contributed to the birth of this legal system. The course presents an in-depth analysis of Trust and Trust mechanisms, elaborates on different types of Trusts, and presents the nature of respective rights and obligations of the parties in a trust. In addition, the course explores the rationale behind the commercialisation of Trust and explains the impact of using Trusts as commercial vehicles. The course introduces some practical examples of the relationship between Trust and contract and explains the difference between Trust and other contracts. The course also elaborates on different types of commercial Trusts and presents the rules framing Trusts under different jurisdictions. Course Details After the successful completion of this lecture, you will be able to learn about the following; Understand the Principles and nature of Equity. Understand the history, concept, and rationale of a Trust. Determine different types of Trusts. Analyse the nature of respective rights and obligations of the parties in a trust. Analyse the rationale behind the commercialisation of Trust. Determine the impact of the commercialisation of Trust. Understand the relation between Trust and contract. Understand the difference between Trust and other contracts. Elaborate on different types of commercial Trusts. Understand rules framing Trust under different jurisdictions. Accreditation All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. Entry Requirements 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 gets updated on current ideas in their respective field. We recommend this certificate for the following audience. Legal advisors. Law practitioners. Contract specialists. Legal officers. Contract managers. Business developers. Trade advisors. Trade compliance officers. Law lecturers. Business lecturers. Legal and business researchers.

Level-7 QLS Endorsed | 22-in-1 Diploma Bundle| Free CPD PDF+ Transcript Certificate| Lifetime Access| Learner Support

Our Creative Writing course, running for five weeks, will explore the art of storytelling in depth. Is your child a budding writer aiming to excel in 11+ exams in the UK? Our Creative Writing course is designed just for them Over five weeks, we'll delve into the art of storytelling, focusing on creating pieces that set your child apart and building essential exam skills. From mastering the nuances of the five senses to paragraph and story structure, our expert exam tutor, Kristen, will guide students every step of the way. We'll help your child answer those seemingly boring questions with enthusiasm, explore figures of speech, enrich vocabulary, and unleash their creative potential. This will be the perfect course to learn about exam skills for 11+ creative writing tasks!

Through this workshop, you'll gain a thorough understanding of the necessary protocols and regulations to maintain professional standards and compliance. Whether you're new to your field or seeking to refresh your knowledge, our workshop provides valuable insights and practical guidance to help you navigate the complexities of professional practice with confidence.

Highlights of the Course Course Type: Online Learning Duration: 2 Hours 36 Minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Microsoft Visio Understand the core competencies and principles of Microsoft Visio Explore the various areas of Microsoft Visio Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Visio 2016 Training Course Master the skills you need to propel your career forward in Microsoft Visio. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Microsoft Visio 2016 training course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft Visio 2016 training course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft Visio practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Visio industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Visio. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft Visio. Enrol in this Microsoft Visio 2016 training course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft Visio 2016 training course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Visio can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Microsoft Visio 2016 training course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Microsoft Visio 2016 training 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%. Advance Your Career This Microsoft Visio 2016 training course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. 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. Course Curriculum Course Overview Course Overview 00:02:00 Introduction to Microsoft Visio Basic Elements of the Visio Environment 00:01:00 The Visio Interface 00:08:00 Shapes, Stencils and Templates 00:06:00 The Backstage View 00:01:00 Saving and Printing 00:01:00 Saving Visio Documents 00:04:00 Printing Drawings 00:03:00 Create Workflow Diagrams Create Workflow Diagrams 00:01:00 Selecting and Applying Templates 00:07:00 Arranging Shapes and Connectors 00:12:00 Adding Text to Shapes 00:04:00 Adjusting the Size and Alignment of Shapes 00:07:00 Grouping Objects 00:03:00 Creating a Callout 00:03:00 Create and Edit Organizational Charts Create and Edit Organizational Charts 00:01:00 Create an Organizational Chart 00:07:00 Using the Organization Chart Wizard 00:04:00 Importing Data into an Organizational Chart 00:05:00 Create and Use Floor Plans Edit an Organization Chart 00:02:00 Working With Floor Plans 00:01:00 Creating a Floor Plan 00:11:00 Creating Layouts 00:03:00 Create Cross-Functional Flowcharts Cross-Functional Flowcharts - Introduction 00:01:00 Creating Cross-Functional Flowcharts 00:08:00 Formatting Cross-Functional Flowcharts 00:02:00 Design Network Diagrams Design Network Diagrams 00:01:00 Creating Network Diagrams 00:10:00 Using External Stencils 00:05:00 Editing Shape Data 00:05:00 Optimize Diagrams with Layers 00:01:00 Assigning Layers 00:02:00 Customize Diagrams Optimize Diagrams with Easy-To-Do Adjustments 00:01:00 Formatting Shapes and Connectors 00:06:00 Design like a Pro with Themes and Variants 00:02:00 Saving Customized Shapes for Reuse 00:03:00 Applying Containers - Introduction 00:01:00 Applying Containers 00:03:00 Bonus Lecture 00:01:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

🌟 Unleash Your Potential in Communication and Presentation! 🌟   Welcome to the 'Foundations of Effective Communication and Presentation Mastery' online course! Are you ready to master the art of communication and captivate your audience with compelling presentations? Look no further - this comprehensive course is your gateway to success. 🚀 MODULE 01: Communications Mastery Unlock the secrets of effective communication. Learn to express yourself with clarity, persuasion, and impact. Discover the power of verbal and non-verbal communication techniques that will elevate your interactions to new heights. 🎙️ MODULE 02: Public Speaking Mastery Dive into the world of confident public speaking. Overcome stage fright, develop engaging narratives, and command the stage with charisma. From structuring speeches to conquering nerves, this module will turn you into a captivating speaker. 🖼️ MODULE 03: Presentation Mastery Master the art of delivering memorable presentations. From slide design to storytelling, learn how to create visually stunning and emotionally resonant presentations that leave a lasting impression on your audience. 🎁 MODULE 04: BONUS: Create Incredible and Inexpensive Talking Head Videos Explore the world of video communication. Discover cost-effective ways to create professional-looking talking head videos that connect with your audience, whether for marketing, education, or personal branding.   ✨ What You'll Gain: Confidence in communication, both verbal and non-verbal. Skills to captivate and engage any audience, large or small. Techniques to craft compelling narratives and impactful presentations. Strategies to create impressive videos without breaking the bank.   🎓 Who Is This Course For? Professionals seeking to enhance their communication skills. Students aiming to excel in presentations and public speaking. Entrepreneurs looking to create impactful content through videos. Anyone eager to boost their confidence in communication!   💡 Why Choose This Course? Comprehensive Curriculum: Expertly crafted modules cover every aspect of effective communication and presentation. Practical Insights: Actionable tips and real-world examples make learning engaging and immediately applicable. Experienced Instructors: Learn from industry professionals with a wealth of experience. Lifetime Access: Access the course content anytime, anywhere, and progress at your own pace. 🎯 Elevate your communication prowess and presentation skills! Join the 'Foundations of Effective Communication and Presentation Mastery' course today and unlock your full potential! 🌟 Enroll now and embark on a transformative journey towards becoming a communication virtuoso! Course Curriculum Module 01: Communications Mastery Quick, Ethical Ways to Cheat Your Way to Communication Success 00:00 You Are In Great Company - Find Out Who 00:00 GPS for Your Communications 00:00 You Will Be Motivating, Not Data Dumping 00:00 Exciting New Update to this Course 00:00 Getting Feedback So It Won_t Hurt 00:00 Yes, Even Beginner CAN Tell Stories 00:00 Powering Your Points With Images and Slides 00:00 Practice In the Friendliest Environment of All 00:00 Test Tubes for You 00:00 You Have Earned a Professional Critique 00:00 Time to Give TJ a Piece of Your Mind 00:00 You have Now Mastered Basic and Beyond Communication Skills 00:00 Extra-Tips on How to Get Over Nervousness and Being Scared 00:00 Module 02: Public Speaking Mastery Promo video Public Speaking for Beginners 00:00 These Simple Secrets Will Make You Look Like a Public Speaking Veteran 00:00 This Is How You Get Your Audience to Do What You Want 00:00 You Will Never Have to Be Scared, Even Though Everybody Else Is 00:00 Unlock the Keys to Motivating Your Audience 00:00 Getting Feedback the Right Way to Make You Stronger 00:00 Mastering the Easiest Public Speaking Technique of All 00:00 Your Picture Will Be Worth More The a 1000 Words 00:00 Only Perfect Practice Makes Perfect 00:00 You Can Pass the Ultimate Test 00:00 You Have Earned a Personalize Coaching Session Now 00:00 Conclusion - You Are No Longer a Public Speaking Beginner 00:00 Module 03: Presentation Mastery Promo Video - Presentation Skills for Beginners 00:00 4 Quick Tips to Improve Your Presentation Skills In the Next Five Minutes 00:00 You Now Know the Dirty Little Secret of Presentation Skills 00:00 Never Waste Time Starting a Presentation Again 00:00 You Can Get the Audience to Do What You Want 00:00 Never Be Convicted of Death by PowerPoint 00:00 The Easy Way to Tell Relevant Stories 00:00 Your Own Free Focus Group 00:00 The Most Efficient Way to Practice You Presentation Skills 00:00 Passing the Ultimate Test 00:00 Now You Have Earned Personal Coaching 00:00 Conclusion- You are No Longer a Beginner at Presentation Skills 00:00 Module 04: BONUS: Create Incredible and Inexpensive Talking Head Videos The Video Advantage In All Your Proposals - Quick Win! 00:00 Hype Versus Reality - Why Most People Never Create Simple Video 00:00 Mastering the Human Side Of Looking and Sounding Your Best on Video 00:00 How This course Will Improve Your Business 00:00 Your Proposals will Stand Head and Shoulders Above Your Competitors 00:00 Your Clients Will Find You Their Most Responsive Partner Ever 00:00 Your Website Can Be Video-Centric 00:00 Now You Can Answer Frequently Asked Questions Just Once! 00:00 Talk Your Customers Through Your Whole Business Process 00:00 Have an Even Greater Presence on YouTube 00:00 Speak Your Thought Leadership 00:00 Your Exciting Video Newsletters Will Outshine Text Newsletters 00:00 Your Client Video Testimonials Will Prove Your Credibility Beyond a Doubt 00:00 Facebook Live Will Never Scare You Again 00:00 Project Your Best Face on Skype and Zoom 00:00 Deliver Keynote Speeches Without Ever Leaving Home 00:00 Supercharge Your Public Relations Efforts With Video 00:00 The Crisis Communications Secret Weapon 00:00 Drastically Reduce Your Time Training Employees and Others 00:00 Anything You Can Type You Can Now Speak on Video 00:00 Conclusion - You are Now Ready to Use Video Successfully In All Communications 00:00

This online course introduces a model for determining and analysing market value vs fair value of an individual art work. LEVEL 3: Fair Value Analysis This is the third online course in our 'Pathway to become an art market analyst'. This course is a building block on both Big Data and the Art Market (Level 1) and Artist Market Analysis (Level 2), and takes the participant on an analytical journey to establish the market value and the fair value of an individual art object. The analysis is based on the Damien Hirst data provided in Level 2: Artist Market Analysis, and it is important that you finish this course before going on to Level 3. The course introduces participants to the difference between market value and fair value, and provides a practical guide for using market trends to analyse and adjust comparable transactions, and to use this to help establish market value. The ArtTactic Market Metrics from Level 2: Artist Market Analysis, is brought into the analysis to establish the 'Fair Value' of the art work. In addition to this, we will provide a 15 minute online Excel workshop on how to analyse comparable transactions using a subset of the data provided in the Level 2 online course. The course includes: Videos: You will have access to 1h 10m of online video content. The content of this course is building on ArtTactic's own framework for fair analysis and what Anders Petterson is regularly teaching for Art Business programmes at Sotheby's Institute in London. The course also include a 15 minutes Excel workshop. Slides: The students can download pdf copies of the slides used in the presentations. Excel spreadsheet: The student will have access to a subset of data (auction data for Damien Hirst) and a spreadsheet with both tables and graphical tools. Certificate of Completion [NEW]: The student will be issued with a certificate of completion when all the online videos have been completed. CPD Accredited: Our courses have been independently evaluated for Continuing Professional Development (CPD) purposes by The CPD Certification Service. Certification: Continuing Professional Development (CPD) Our courses have been independently evaluated for Continuing Professional Development (CPD) purposes by The CPD Certification Service. This means our courses comply with universally accepted principles of Continual Professional Development (CPD) and have been structured to meet the criteria of personal development plans. Join one of the online courses below and get an ArtTactic Certificate of Completion with the Continuing Professional Development (CPD) certification stamp. Your Instructor Anders Petterson, Founder of ArtTactic Anders Petterson is a leading authority on the art market, with particular focus on art market research and analysis. He is the Founder and Managing Director of ArtTactic, a London-based art market research and data intelligence company he set up in 2001. All the online courses are based on his own experience in collecting, analysing and presenting data on the global art market, and the courses will give an insight into how ArtTactic conceptualizes, designs and executes research projects linked to art market and introduces analytical models to better understand the value of art. Anders is regularly lecturing on MA and Executive courses at Sotheby's Institute, Christie's Education and ESA Business School (Beirut) covering topic such as Art Market Analysis, Art & Technology and NFTs as well as Art as an Asset Class. He is also a regular speaker on these topics at international conferences and seminars. ArtTactic is also well-known for its industry research on the art market and its intersection with other industries, such as the Deloitte | ArtTactic Art & Finance Report, TEFAF Art Dealer Finance Report 2018, and the TEFAF Art Patronage Report 2020. ArtTactic has also produced the Hiscox Online Art Trade Report annually since 2013. Anders Petterson is a founding Board Member of Professional Advisors to the International Art Market (PAIAM), a role he had between 2011 and 2021. PAIAM was founded in London in 2011 bringing together professionals who provide specialist services to the art market.such as lawyers, accountants, tax advisors, insurance specialists and logistics experts, amongst others. Connect on LinkedIn Course Curriculum Introduction Introduction to Fair Value Analysis (1:39) Fair Value Analysis Market Value vs Fair Value (4:24) Artwork Analysis - Object Qualities (9:40) Market Trend Analysis & Value Adjustments (7:10) Comparable Transaction Analysis (9:30) Market Value Analysis (6:45) Fair Value Analysis (11:03) Excel Workshop - Comparable transaction analysis + Sample Analysis Excel Workshop - Comparable Transactions (12:31) SAMPLE: Damien Hirst - Fair Value Analysis Summary  Frequently Asked Questions When does the course start and finish? The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.How long do I have access to the course?How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own. It's important to note that this is a SINGLE-user only subscription (see T&Cs). Contact us if you are looking for a team discount on info@arttactic.com.What if I am unhappy with the course?We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.Is this course for me?We have a broad and diverse set of students taking these courses in terms of geography, age and professional backgrounds. Based on our experience so far, the courses have attracted non-art market professionals that are looking to explore opportunities in the art market or the broader art industry - and are looking for tools to help them navigate and better understand where these opportunities might exist, and how their own interest and professional background could fit in. At the other end, we also have seen a strong interest from the art trade who are looking at exploring more quantitative and data-driven methods for their own business and to meet the demand for an increasingly data-hungry client base. However, if you have any questions, please contact us and we can set up a call to discuss what course option might be the best for you.

Introducing the Psychotherapy London Package: Expert Guidance for Personal Growth and Emotional Well-being Are you searching for professional psychotherapy services in London to support your personal growth and emotional well-being? Miss Date Doctor’s Psychotherapy London Package offers you access to highly trained therapists who are dedicated to helping you navigate life’s challenges and achieve greater self-awareness and fulfillment. Psychotherapy is a collaborative and evidence-based therapeutic approach that addresses various mental health concerns, relationship issues, and emotional difficulties. Our experienced therapists in London provide a safe and confidential space for you to explore your thoughts, emotions, and experiences, facilitating positive change and growth. Here’s how the Psychotherapy London Package can support you: Comprehensive Assessment: Our therapists will conduct a thorough assessment to understand your unique needs, challenges, and goals. This assessment will serve as the foundation for designing a tailored treatment plan that suits your specific requirements. Evidence-Based Techniques: The Psychotherapy London Package draws from a range of evidence-based techniques and modalities, ensuring that you receive the most effective and appropriate therapeutic interventions. Individualized Approach: Your therapy sessions will be personalized to address your specific concerns and aspirations. Our therapists recognize that each individual’s journey is unique, and they will tailor the treatment to support your personal growth. Emotional Support: Our therapists provide a supportive and empathetic environment where you can freely express your thoughts and feelings. This emotional support is crucial for fostering a strong therapeutic alliance and promoting healing. Stress Reduction: Psychotherapy can be an effective tool for managing stress and anxiety. Through guided discussions and coping strategies, you’ll develop skills to navigate life’s challenges with greater resilience. Relationship Enhancement: If you are seeking to improve your relationships, our therapists will provide guidance and techniques to enhance communication, foster emotional intimacy, and resolve conflicts effectively. Self-Exploration and Awareness: Psychotherapy encourages self-exploration and self-awareness. By gaining insight into your thoughts and behaviours, you’ll be empowered to make positive changes in your life. Positive Change: With the support of our skilled therapists, you’ll work towards achieving meaningful and lasting positive changes in various aspects of your life. The Psychotherapy London Package at Miss Date Doctor offers you the opportunity to embark on a transformative journey of personal growth and emotional well-being. Our therapists are committed to helping you navigate life’s challenges and empowering you to lead a more fulfilling and balanced life. Take the first step towards greater self-awareness and well-being with the Psychotherapy London Package. Invest in your mental and emotional health, and unlock your potential for positive change. Discover the benefits of psychotherapy and experience the guidance and support you deserve on your journey to a happier and healthier life. 3 x 1 hour sessions https://relationshipsmdd.com/product/psychotherapy-london-package/

mindfulness meditation for children and teens - learn how to teach - mindfulness teachers