493 Courses in Bradford

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing 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. Our competitive rates start from £550.00 per day of training Tailored training courses: 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. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate 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

This dynamic programme empowers attendees to enhance their emotional intelligence, forge meaningful connections in every interaction, engage in impactful coaching conversations, and cultivate resilience and psychological safety. Through interactive workshops, compelling discussions, and practical exercises, participants will acquire skills and insights necessary to foster a space for collaboration helping shape an environment of trust and openness in their professional and personal spaces

Introducing our comprehensive “Online Dating Tips for Miss Date Doctor” package, designed to equip you with expert guidance and proven strategies for navigating the digital dating landscape with confidence and success. Discover the secrets to standing out in the online dating world and attracting quality matches who are genuinely compatible with you. In this package, you’ll gain access to a wealth of valuable resources and personalized coaching from Miss Date Doctor, a trusted relationship expert. With her guidance, you’ll learn how to optimize your online dating profile, enhance your communication skills, and overcome common challenges faced in the world of online dating. Here’s what you can expect from our “Online Dating Tips for Miss Date Doctor” package: Profile Optimization Techniques: Craft an enticing and authentic online dating profile that captures attention and showcases your unique personality. Learn the art of choosing the perfect profile picture, writing engaging bios, and optimizing your presence on popular dating platforms like Tinder, Bumble, or OkCupid. Effective Communication Strategies: Master the art of online conversation and learn how to engage potential partners in meaningful dialogue. Discover techniques for initiating conversations, keeping them flowing, and creating a genuine connection that translates from the digital realm to real-life interactions. Gain insights into flirting, banter, and maintaining interesting conversations. Navigating Online Platforms: Understand the nuances of different online dating platforms and maximize your chances of finding success on each one. Whether it’s a mainstream app or a specialized dating website, you’ll learn how to tailor your approach and increase your visibility among potential matches. Explore related terms such as “best dating apps,” “dating site tips,” and “online dating platform comparison” to gain a comprehensive understanding. Safety and Security Guidelines: Prioritize your well-being with essential safety tips for online dating. Learn to identify red flags, protect your personal information, and ensure your online interactions remain secure. Explore related topics like “online dating safety,” “scam awareness,” and “privacy precautions” to stay informed and confident while navigating the digital dating world. Overcoming Common Challenges: Gain insights into overcoming common hurdles and setbacks encountered in online dating. From handling rejection gracefully to managing expectations, you’ll develop resilience and a positive mindset that will propel you forward on your dating journey. Explore related terms such as “dealing with rejection in online dating,” “managing dating expectations,” and “building dating confidence” for additional guidance. Enroll in our “Online Dating Tips for Miss Date Doctor” package today and empower yourself with the tools and knowledge necessary to transform your online dating experience. Let us guide you toward attracting meaningful connections and finding the love you deserve. Don’t let online dating become a source of frustration; embrace it as an exciting opportunity for personal growth and fulfilling relationships. With the “Online Dating Tips for Miss Date Doctor” package, you’ll be equipped to navigate the digital landscape confidently and embark on a journey towards love and happiness. https://relationshipsmdd.com/product/online-dating-tips-package/

A48 Piling Rig - Bored above 20 Tonnes

A47 Piling Rig - Bored below 20 Tonnes

CPCS A46 Piling Rig - Driven above 20 Tonnes

CPCS A45 Piling Rig - Driven Below 20 Tonnes

This course is designed to provide operatives with thorough theory and practical training in the role of the piling rig attendant.

Acceptance and Commitment Therapy (ACT) Package: Embrace Your True Self and Live Authentically Discover the transformative power of Acceptance and Commitment Therapy (ACT) with Miss Date Doctor’s specialized package. ACT is a cutting-edge form of therapy that helps you accept your thoughts and emotions while aligning your actions with your core values. Say goodbye to old patterns of avoidance and self-doubt, and embrace a life of psychological flexibility and authenticity. Our experienced therapists will guide you through targeted exercises and techniques that empower you to embrace discomfort, develop resilience, and make meaningful changes in your life. With the ACT package, you’ll find the courage to face challenges head-on, build stronger relationships, and achieve your personal and relationship goals. This comprehensive program will equip you with the tools needed to navigate life’s uncertainties and build a stronger, happier you. 3 X 1 HOUR SESSION https://relationshipsmdd.com/product/acceptance-and-commitment-therapy-package/

Introducing “Hire a Therapist” Package: Personalized Support for Your Mental Health and Emotional Well-being Are you considering seeking professional support for your mental health and emotional well-being? Miss Date Doctor’s “Hire a Therapist” Package offers you personalized and confidential counselling sessions with experienced therapists to help you navigate life’s challenges, overcome obstacles, and achieve personal growth. Therapy provides a safe and supportive space to explore your thoughts, emotions, and concerns with the guidance of a skilled therapist. Our team of dedicated therapists is committed to helping you enhance your overall well-being and lead a more fulfilling life. Here’s how the “Hire a Therapist” Package can support you: Personalized Assessment: Our therapists will conduct a thorough assessment to understand your unique needs and goals for therapy. Individualized Approach: Your therapy sessions will be tailored to address your specific concerns and support your personal growth. Emotional Support: We offer a compassionate and non-judgmental environment where you can freely express your feelings and experiences. Confidentiality: Your therapy sessions are completely confidential, ensuring a safe space for open and honest communication. Coping Strategies: Our therapists will equip you with practical coping strategies to manage stress, anxiety, and other emotional difficulties. Self-Exploration: Therapy encourages self-discovery and self-awareness, helping you gain insights into your thoughts, behaviours, and emotions. Goal Setting: Together with your therapist, you’ll set achievable goals to work towards positive change and personal growth. Flexible Sessions: “Hire a Therapist” Package offers flexibility in scheduling sessions, accommodating your availability and preferences. The “Hire a Therapist” Package at Miss Date Doctor is designed to provide you with personalized support and guidance on your journey to better mental health and emotional well-being. Our skilled therapists are committed to helping you overcome challenges, enhance your resilience, and lead a more fulfilling life. Invest in your mental and emotional health and take the first step towards positive change with the “Hire a Therapist” Package. Embrace the opportunity to explore your thoughts and feelings in a confidential and supportive environment. Let our experienced therapists guide you towards a brighter and more empowered future. 3 x 1 hour sessions https://relationshipsmdd.com/product/hire-a-therapist-package/