2571 Courses delivered Online

Description Microsoft Excel has hundreds, if not thousands, of functions and features. This course aims to cover some of the best – that is the ones I find most useful. In “Adventures in Excel”, I cover the simple-to-use but powerful functions that I use most often: Basic features including products and powers Key date functions including the calculation of due dates and days past due Generating random numbers and random dates The new IFS functions (new to Office365) Text functions The most useful logical functions and IS functions How to create a drop-down list The new XLOOKUP function Pivot tables   These functions are easy to use, and, unless your role is extremely specialised, they are probably the ones you’ll use 90% of the time. I hope you find the course helpful.   Learning Outcomes Participants in this course will learn: Basic Excel functions including SUM, AVERAGE, MIN, MAX, PRODUCT, POWER and SQRT Useful date functions including TODAY, EOMONTH, EDATE, and DAYS Generating random numbers using RAND and RANDBETWEEN; generating random dates; and randomly picking an item from a list or table The new RANDARRAY function in Office365 The new IFS functions in Office365 including AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS, and SUMIFS Text functions including TRIM, LOWER, UPPER, PROPER, LEFT, MID, RIGHT, FIND, TEXTJOIN and CONCATENATE Logical functions AND, OR, and NOT and IS functions ISTEXT, ISNUMBER, ISBLANK and ISERROR How to create a drop-down list The new SORT and FILTER functions in Office365 VLOOKUP and the new XLOOKUP function How to create a Pivot table and analyse data with one     Course Requirements There are no pre-course requirements.   Additional Resources Course Spreadsheet with the examples covered.     About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

Step-by-step tutorial to build a robust automation framework - TestNG, ANT, Maven, Jenkins, Cucumber, Git, Pageobject, Cloud,SQL

Being able to speak English is much different than mastering the language and using it accurately. Understanding English parts of speech and sentence structure are key to improving your speaking, writing, listening and reading. By the end of this course, you’ll have valuable skills that will help you quickly differentiate between the tenses and verbs and use each one in the proper situation, and form sentences using any of the tenses in the affirmative, negative and question forms. Learning Outcomes Confidently apply fundamental rules of English grammar in written communication tasks. Construct grammatically correct sentences with appropriate punctuation and capitalisation. Identify and rectify common grammatical errors and spelling mistakes effectively. Develop a deeper understanding of sentence structure and syntactic elements. Formulate clear and concise questions using correct grammatical structures. Demonstrate proficiency in spelling and utilise spelling conventions accurately. Enhance punctuation skills to improve clarity, coherence, and readability of written content. Analyse and interpret complex sentences to identify their grammatical components accurately. Apply strategies to enhance writing quality and coherence, avoiding common grammatical pitfalls. Employ advanced grammar knowledge to refine language usage and express ideas more precisely. Why choose this course Affordable, Accessible, informative and well-structured study materials Earn a globally recognised accredited qualification Study in your own time, at your own pace, through any device Benefit from feedback through mock exams and multiple-choice assessments Excellent career advancement/career switch opportunities Get 24/7 help or advice from our email and live chat teams Who is this course for Language enthusiasts aiming to improve their written English skills for personal or professional growth. Students seeking to enhance their understanding and application of English grammar rules. Professionals who require strong written communication skills in their workplace or academic settings. Individuals preparing for English language proficiency exams or certification tests. Non-native English speakers looking to improve their English language proficiency and writing abilities. Entry requirements This course is available to learners of all academic backgrounds, but you must be 16 or above to undertake the qualification. Apart from that, all you need is an internet connection, a good understanding of English and a passion for learning. Certification CPD Accredited Certificate After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post. Career path Writer/Author Editor/Proofreader Content Creator Journalist Copywriter Language Teacher/Tutor Communications Specialist Public Relations Officer Course Content Module 1: Introduction to the Course Module 2: The Basics of Grammar Module 3: The Basics of Sentence Module 4: Structure of Sentence Module 5: Question Module 6: Punctuation & Capitalisation Module 7: Spelling Module 8: Common Mistakes & Ways to Improve

Learn Database Driven Web Development With Django and Python!

To understand psychopathology, one must learn a foreign language, lend an ear as it were to a language that is complex and symbolic. We aim to explore the lived experiences on irregular perceptions of reality with an open mind. Each Saturday includes: a live dialogue between Prof. Ernesto Spinelli and an International Existential Therapist; a moment to share your thoughts and feelings with the teachers; and a final integration facilitated by Bárbara Godoy. This series of ten dialogues set out to explore the multifaceted dimentions and complexities associated with Existential Therapies. It attempts to engage with various interpretations of insanity through the lens of patients often painful, confounding, and deeply unsettling life experiences. Character- between Prof. Ernesto Spinelli and Prof. Robert Romanyshyn “I begin with the term psychopathology to emphasize that the word is about the logos—the thinking/speaking—about the sufferings of the psyche. To understand psychopathology, one must learn a foreign language, lend an ear as it were to a language that is complex, symptomatic, symbolic, and embodied. As complex, psychopathology reveals and conceals the sufferings of psyche. As symptomatic, psychopathology reminds one of things too important to forget but which are forgotten because they are too painful to remember. As symbolic, psychopathology is neither about facts nor ideas but about images, alchemical vessels that not only hold and contain psyche’s sufferings, but also cooks them. As embodied, psyche’s sufferings are inscribed in the flesh, etched as lines of character. To practice psychotherapy as an existential therapist situates therapist and patient in a dialogical field that is complex, symptomatic, symbolic, and embodied as a gestural field between them.” Prof. Robert Romanyshyn. Prof. Robert D. Romanyshyn, an Affiliate Member of The Inter-Regional Society of Jungian Analysts, a Fellow of the Dallas Institute of Humanities and Culture, and a Professor Emeritus of Clinical Psychology at Pacifica Graduate Institute, was recently awarded the Distinguished Lifetime Contributions to Humanistic Psychology Award from the Society for Humanistic Psychology APA Division 32. He has published eight books and numerous articles in psychology, philosophy, education, and literary journals. He is also a published poet and has written a one-act play about Frankenstein. In 2009 he created a multi-media DVD entitled Antarctica: Inner journeys in the Outer World, which offers a psychological reflection on the melting polar ice. In addition to online seminars and interviews, he has given lectures and workshops at universities and professional societies in the U.S., Europe, Australia, South Africa, Canada, and New Zealand. Prof. Ernesto Spinelli was Chair of the Society for Existential Analysis between 1993 and 1999 and is a Life Member of the Society. His writings, lectures and seminars focus on the application of existential phenomenology to the arenas of therapy, supervision, psychology, and executive coaching. He is a Fellow of the British Psychological Society (BPS) as well as an APECS accredited executive coach and coaching supervisor. In 2000, he was the Recipient of BPS Division of Counselling Psychology Award for Outstanding Contribution to the Profession. And in 2019, Ernesto received the BPS Award for Distinguished Contribution to Practice. His most recent book, Practising Existential Therapy: The Relational World 2nd edition (Sage, 2015) has been widely praised as a major contribution to the advancement of existential theory and practice. Living up to the existential dictum that life is absurd, Ernesto is also the author of an on-going series of Private Eye novels. Date and Time: Saturday 3 May from 2 pm to 3 pm – (UK time) Individual Dialogue Fee: £70 Venue: Online Zoom FULL PROGRAMME 2025: 25 January “Knots” with Prof. Ernesto Spinelli and Bárbara Godoy 22 February “Healing” with Dr. Michael Guy Thompson and Prof. Ernesto Spinelli 22 March “Difference” with Prof. Tod DuBose and Prof. Ernesto Spinelli 12 April “Polarisation” with Prof. Kirk Schneider and Prof. Ernesto Spinelli 3 May “Character” with Prof. Robert Romanyshyn and Prof. Ernesto Spinelli 21 June “Opening” with Dr. Yaqui Martinez and Prof. Ernesto Spinelli 19 July “Meaning” with Dr. Jan Resnick and Prof. Ernesto Spinelli 25 October “Invention” with Dr. Betty Cannon and Prof. Ernesto Spinelli 15 November “Hallucination” with Prof. Simon du Plock and Prof. Ernesto Spinelli 13 December “Hysteria” with Bárbara Godoy and Prof. Ernesto Spinelli Read the full programme here > Course Organised by:

We will follow a hands-on approach in this course to learn how to use and apply HTML5 and CSS3 concepts to the front-end page of your projects. A carefully structured beginner-level course that will help you level up your web development skills. You need not have any prior experience in HTML and CSS to take up this course.

Are you interested in pursuing a rewarding career as a web developer? Alternatively, perhaps you'd want to brush up on your skills and take things to a whole new level? Then this course is for you. A carefully structured course for both beginners and intermediate-level learners.

This compact crash course teaches learners to optimize their Microsoft Power BI use, gain insights into circular dependency errors and the new DAX functions, and use Power BI template files to enhance data modeling/analysis. The course provides guidance and real-world examples to streamline Power BI projects and achieve data visualization goals effectively.

Overview In the realm of digital publishing, the Amazon Kindle platform remains an undisputed leader, reshaping the way readers consume and authors disseminate their stories. Our 'Amazon Kindle Master Class' is designed to guide budding authors through the intriguing intricacies of the Kindle publishing process. Embarking on this course, learners will discover not only the theoretical underpinnings but also the strategic avenues to select compelling topics, write efficiently, and confidently launch their books on Amazon's esteemed platform. Delve into the very essence of Kindle publishing with a comprehensive exploration of the exclusive '1 Hour Kindle Method' and the manifold benefits it boasts. By weaving through the curriculum, authors-in-the-making will demystify the swift processes of penning, peer editing, cover design, and self-publishing. And as they journey further, the path becomes a rite of affirmation, grounding them in their inner strength and innate wisdom, readying them to make an indelible mark in the literary world. The course culminates with a reflective postscript, inviting learners to ponder their journey, embrace their achievements, and chart the road ahead, fortified with newfound skills and insights. Learning Outcomes: Understand the fundamental principles behind Kindle's publishing method. Identify compelling topics for book-writing from key sources. Execute efficient strategies to accelerate the book completion process. Master the steps of peer editing, cover designing, and swift self-publishing. Harness personal affirmations to enhance inner strength and wisdom for a successful writing journey. Why buy this Amazon Kindle Master Class course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on 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 Amazon Kindle Master Class 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 £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Amazon Kindle Master Class course for? Aspiring authors keen on navigating the Kindle publishing platform. Writers seeking streamlined processes to select and develop topics. Individuals aiming to swiftly and efficiently complete their books. Those yearning for personal growth through inner affirmations. Digital publishing enthusiasts eager to understand the Kindle ecosystem. Prerequisites This Amazon Kindle Master Class does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Amazon Kindle Master Class was made by professionals and it is compatible with all PC's, Mac's, 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 Kindle Author: £25,000 - £80,000 (varies based on royalties and sales) per annum Book Cover Designer: £18,000 - £40,000 per annum Self-Publishing Consultant: £30,000 - £55,000 per annum Editor for Digital Publications: £22,000 - £50,000 per annum Ebook Marketing Specialist: £27,000 - £53,000 per annum Content Strategist: £28,000 - £60,000 per annum Course Curriculum Module 01: Kindle Method Explained Kindle Method Explained 00:09:00 Module 02: 4 Benefits of the 1 Hour Kindle Method 4 Benefits of the Kindle Method 00:06:00 Module 03: 6 Key Places to Look to Find Book-Worthy Topics 6 Key Places to Look to Find Book-Worthy Topics 00:11:00 Module 04: The 4-Step Process to Complete Your Book Faster The 4-Step Process to Complete Your Book Faster 00:12:00 Module 05: Peer Editing (Step 2) & Designing Your Cover (Step 3) Peer Editing (Step 2) & Designing Your Cover (Step 3) 00:10:00 Module 06: How to 'Self-Publish' Your Book Fast (Step 4) How to 'Self-Publish' Your Book Fast (Step 4) 00:04:00 Module 07: The 7 Most Important Steps to Completing Your Book The 7 Most Important Steps to Completing Your Book 00:07:00 Module 08: Affirmation - I Harness My Inner Strength Affirmation - I Harness My Inner Strength 00:02:00 Module 09: Affirmation - I Harvest My Innate Wisdom Affirmation - I Harvest My Innate Wisdom 00:02:00 Module 10: Postscript Postscript 00:04:00 Assignment Assignment - Amazon Kindle Master Class 00:00:00

In this course, learn the C# programming fundamentals that are the building blocks of .NET programming, and build a solid foundation on the basics of C# programming language and coding constructs. No prior C# or .NET coding experience is required.