2937 Courses in Swanscombe

Microsoft Excel® in Depth The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

This qualification is aimed at those working in an environment where an AED is available.

Education on socials skills Dealing with rejection Relationships and contraception Emotional intelligence training and exercises Teaching about high expectations Teaching the importance of discipline How to have a healthy relationship How to be happy Self improvement coaching Best self improvement coaches techniques exercises The importance of work ethic The importance of your friend choices Financial discipline Social anxiety Socialising and safety Exercises on the importance of self-acceptance Self-love teaching and exercises The importance of self-respect Dealing with anxiety and fear Preparing your teenager for life 6 sessions https://relationshipsmdd.com/product/preparing-your-teenager-for-life-package/

This package is perfect if you have no one to go out with this weekend or you want to try some new venues without your usual friends. This weekend have some fun!!We will send an M.D.D Staff member to hang out with you for two weekends in a row go shopping, go to the cinema,go bowling,go for a meal,go to the gallery, museum or club this package is to keep you company on the weekend due to strict M.D.D policy there are no overnight stays,no visiting friends or colleagues and no visits to premises this package is for singles and people who want someone to go out with or get to meet new people and receive relationship coaching and guidance at the same time.We created this package as part of our upcoming fight loneliness campaign.We will pay for food and drinks charges Dating advice for singles 2 weekends Please contact for more information (03333443853) https://relationshipsmdd.com/product/m-d-d-socialize-package/

Self esteem building Improve social anxiety Learning what to say and do in text and dates Education on modern dating techniques Online messages formatting and wording Confidence Coaching Online dating tips Online dating Coaching with your own personal dating coach Kino escalation Introspection and characteristic testing https://relationshipsmdd.com/product/online-dating-coaching-package/

7 sessions 2 separately 5 sessions with coach Marriage counselling Resolve arguments and problems Strengthen marriage One growth arena per session Emotional intelligence training Love, respect, communication training Trust and loyalty strengthening Couples improvement programme MDD Modern EFT techniques Prevent a breakup Enhance love and satisfaction in your relationship 1 hour x 5 https://relationshipsmdd.com/product/save-my-marriage-package/

Couples therapy assessment calls Gottman method Insight gaining therapy Communication counselling Positive psychology couples therapy Couples therapy effective communication exercises Homework and couples therapy implementation tasks Attachment therapy Resolve serious conflicts Improve trust and honesty Address core issues Dating advice and relationship advice Couples therapy near me https://relationshipsmdd.com/product/m-d-d-couples-therapy-8-session-package/

Relationship coaching Talk through emotions and needs Address fears and emotions Ascertain your fears and address them Teaching better relationship strategies Personal dating coaching for 2 months 1 hour per week Dating advice for singles https://relationshipsmdd.com/product/how-do-i-know-partner-is-the-one-package/

Unlock a Rewarding Path as a Dementia Advocate Are you ready to make a difference by understanding and supporting individuals with Dementia? Embark on a fulfilling journey of advocacy through our comprehensive Dementia training courses – Dementia Champion and Dementia Interpreters. This course is an advanced level of training with innovative practical elements and teachings from experts which will change your approach and better your service. You will also be able to display your team’s achievements with pins and certificates that will differentiate you from other services. So often we have training that takes care of the physical elements of our service users but this truly explores how to take care of emotional and cognitive health, ensuring that you are catering to your service users at all levels. Dementia Champion Course £1000 + VAT Modules: What Dementia is and what it isn’t Living with Dementia What causes Dementia? Diagnosis and who can help Common difficulties and how to help The emotional impact of Dementia Positive communication Duration 3 Full Days Maximum Delegates 12 for face-to-face or unlimited for virtual Location Location: We can travel to any UK location for your convenience. *Note: Price may vary based on travel distance. Full Day - Dementia Interpreters Course £800 + VAT Duration 2 x 3-hour sessions Maximum Delegates 16 Location Location: We can travel to any UK location for your convenience. *Note: Price may vary based on travel distance. Half Day - Dementia Interpreters Course £495 + VAT Duration 1 x 3-hour session Maximum Delegates 8 Location Location: We can travel to any UK location for your convenience. *Note: Price may vary based on travel distance.

Choose what you want to learn in this fast-track hairdressing course. Aimed at those who’ve left college with a hairdressing qualification but don’t feel confident enough on the salon floor or those needing to brush up on a specific skill. Our training concentrates on cutting, colouring, styling and barbering.