42830 Learning courses in Glasgow delivered Online

With Actress, Acting and Audition Coach Sarah Hannah Introduction Join our internationally recognised Screen Acting Weekly Course and develop your technical performance skills and character understanding over 5 Weekly Evening Sessions before applying your new skills on a professional set at Pinewood Studios as you participate in filming two showreel scenes. Over weekly sessions, the Director will use practical techniques to build your confidence in performance and help you master the technical requirements to be a successful screen actor. You will focus on the importance of character preparations, how to portray emotion, comedy and drama on camera in addition to career advice before shooting a professional acting showreel. Upon completion of the Screen Acting Weekly course, you will emerge with a heightened sense of assurance and confidence in your screen acting abilities and the tools to progress with your acting career, whether you’re new to the industry or a Drama School Graduate looking for more acting opportunities in TV & Film. Meet Your Tutor Sarah Hannah Acting Coach Sarah Hannah is a highly experienced Professional Actress, Acting and Audition Coach. Bringing her extensive experience of working on stage and on screen, Sarah will focus on enhancing your presence on camera and cover the technical skills required of a professional screen actor. Course Outline The course led by Acting Coach Sarah Hannah is held at The Audition House, Central London, and the first 5 weekly sessions run for 3 hours (6-9pm). There are 3 additional showreel filming sessions at Pinewood Studios. You will be required for 2 out of the 3 filming sessions. We film during the day and you will be given a specific filming time and will not be required all day. As this course is inclusive of all levels of ability, it offers a comprehensive overview of screen acting skills, starting from the basics and progressing to more advanced concepts. It will include resources, material and instructional stratergies that cater to beginners while also offering challenges for those with more advanced skills. Booking Options Select a course date and add to cart to proceed with payment. This course has limited availability and spaces are first come first served. Please read our Terms and Conditions before proceeding with your booking. £750.00 Weds 24th April-Thurs 30th May 2024 Lesson 1: Wednesday 24th April 2024 – 6-9pm Central London Lesson 2: Wednesday 1st May 2024 – 6-9pm Central London Lesson 3: Wednesday 8th May 2024– 6-9pm Central London Lesson 4: Wednesday 15th May 2024 – 6-9pm Central London Lesson 5: Wednesday 22nd May 2024 – 6-9pm Central London Filming Sessions: Tuesday 28th, Wednesday 29th and Thursday 30th May 2024 at Pinewood Studios. You are required for 2 of the 3 filming sessions. Weds 18th Sept-Thurs 24th Oct 2024 Lesson 1: Wednesday 18th September 2024 – 6-9pm Central London Lesson 2: Wednesday 25th September 2024 – 6-9pm Central London Lesson 3: Wednesday 2nd October 2024– 6-9pm Central London Lesson 4: Wednesday 9th October 2024 – 6-9pm Central London Lesson 5: Wednesday 16th October 2024 – 6-9pm Central London Filming Sessions: Tuesday 22nd, Wednesday 23rd and Thursday 24th October 2024 at Pinewood Studios. You are required for 2 of the 3 filming sessions. Additional Information Features Practical acting training for screen Shoot two scenes for your professional acting showreel with our Award Winning Crew Suitable if you are (17 yrs+) and committed to improving your screen acting skills Attracts a varied age range from 17 yrs+. International Students Welcome The course is taught in English, so it is important that you have proficient English language skills Small Class Size Learning Outcomes Learn techniques to effectively analyse a Film/TV Script Create truthful and inspirational characters Build confidence performing in-front of camera Understanding the workflow of a busy film set Audition preparation Career advice and direction – how to market yourself Course Location Training Sessions (1-5) 6pm – 9pmThe Audition House, 129A Whitfield Street, Fitzrovia, London, W1T 5EQ The Audition House is a two minute walk from Warren Street tube and 5 minutes from Euston Station Filming Sessions (6-8) Between 8am and 4pmActors Studio, Pinewood Studios, Pinewood Road, Iver Heath, Buckinghamshire, SL0 0NH Free Parking available at Pinewood Studios Free frequent shuttle bus service from London Uxbridge Tube Station, Slough and Gerrards Cross. Transfer from station to Pinewood Studios – 10 minutes Canteen and Coffee shops on site Excellent transport links from London

Portfolio Management Skills: On-Demand Project Management Institute (PMI)® Charter Global Registered Education Provider (R.E.P.) International Institute for Learning (IIL) has been reviewed and approved as a provider of project management training by PMI®. Become a strong, effective change advocate for meaningful portfolio management. This course is designed to equip and enable you to effectively and efficiently support the Executive Leadership and Operational Management to plan, implement, manage, and evolve portfolio management in your organization. It focuses on helping you become a strong and effective change advocate for meaningful portfolio management that delivers objective measurements of benefit contribution towards the strategic objectives to lead, manage, and continuously improve portfolio management governance, processes, and frameworks with and through the direction of a portfolio practice, principles, and delivery boards. What you Will Learn At the end of this program, you will be able to: Articulate the benefits of portfolio management Link the initiatives in an organization with its strategic objectives Participate in the introduction of portfolio management in an organization Create or improve the portfolio governance structure Lead the inventory of ongoing and new initiatives Assist the executives in the prioritization of initiatives through the use of Multi-criteria Analysis and other selection tools Support the executives in balancing the portfolio based on the optimal use of resources and priorities Create a portfolio delivery plan Define thresholds and variance reporting criteria Assist the executives and the financial team in the definition of Stage Gate Funding Lead the Stage Gate reviews Analyze the benefits that are being realized by the initiatives Foundation Concepts Definitions Benefits of Portfolio Management Objectives of Portfolio Management Portfolio Life Cycles Governing the Portfolio Portfolio Governance structure Roles and responsibilities Initial activities when starting portfolio management Prioritizing Initiatives Prioritize purpose Multi-Criteria Analysis Analytical Hierarchy Process (AHP) Strategic alignment Balancing the Portfolio Allocating resources and budgets Communicating decisions of initiatives status Planning the Portfolio Planning review cycles Using Stage Gate Funding Setting thresholds and variance reporting Tool examples Managing the Portfolio Delivery Project and Program Life Cycles Stage Gate Reviews Loop back to Prioritize, Balance and Plan Interaction with the Portfolio Delivery Board Project, Program and Functional Managers' roles and responsibilities

The course 'Learn When to Say No' aims to help individuals understand the importance of saying no, the challenges associated with it, and practical strategies for saying no effectively. Participants will learn what situations to say no to, when to say no, and how to communicate their boundaries confidently. Learning Outcomes: Recognize the significance of saying no and comprehend the difficulties in doing so. Identify specific situations where saying no is appropriate and learn to determine the right timing for expressing no. Develop effective communication skills to confidently say no in various scenarios. Acquire practical strategies and tools to handle challenging situations and navigate through potential conflicts when saying no. Why buy this Learn When to Say No? 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 Learn When to Say No 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 course for? This Learn When to Say No 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 skill. Prerequisites This Learn When to Say No does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Learn When to Say No 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 As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Learn When to Say No is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: The Why of No - why No matters and why it's hard to say Why is No Important? 00:07:00 Why is No Difficult? Your Inner Gopher 00:09:00 Why is No Difficult? Six things that Drive you to Say Yes 00:09:00 Section 02: The What of No - What to say No to, and when to say it How to Challenge your Instincts on No 00:05:00 What to Say No to 00:05:00 Specific things to Say No to 00:05:00 When to Say No 00:08:00 What are your Choices? 00:09:00 When to Say No to Relationships 00:04:00 What does No Mean? 00:04:00 Section 03: How to say NO in lots of situations How to be Happy with No 00:07:00 How to Decide Yes or No: Six Tools to Help Make Your Decision 00:10:00 How to Decide Yes or No: Six Ways of Thinking about Any Problem 00:05:00 How to Make No Feel Easier 00:09:00 How to Say No 00:04:00 How to say No to Friends and Loved Ones 00:02:00 How to say No to your Customers 00:03:00 How to say No to False Assumptions 00:06:00 How to say No to Temptation 00:04:00 How to Get on with it: How to say No to Procrastination 00:08:00 How to Get on with it: How to say No to Procrastination 00:08:00 How to say No in Negotiations 00:11:00 More Tips on How to Say No 00:05:00 Section 04: The What if of No; I've got you covered What if they Resist your No? 00:12:00 What if you want to Say Yes? 00:04:00 Four 'What if?' Questions 00:04:00 What if you don't Follow my Advice? 00:02:00 Assignment Assignment - Learn When to Say No 00:00:00

Duration 1 Days 6 CPD hours Writing is a key method of communication for most people, and it?s one that many people struggle with. This workshop will give participants a refresher on basic writing concepts (such as spelling, grammar, and punctuation), and an overview of the most common business documents (such as proposals, reports, and agendas), giving you that extra edge in the workplace. 1 - Getting Started Workshop Objectives Pre-Assignment Review 2 - Working with Words Spelling Grammar Creating a Cheat Sheet 3 - Constructing Sentences Parts of a Sentence Punctuation Types of Sentences 4 - Creating Paragraphs The Basic Parts Organization Methods 5 - Writing Meeting Agendas The Basic Structure Choosing a Format Writing the Agenda 6 - Writing E-mails Addressing Your Message Grammar and Acronyms 7 - Writing Business Letters The Basic Structure Choosing a Format Writing the Letter 8 - Writing Proposals The Basic Structure Choosing a Format Writing the Proposal 9 - Writing Reports The Basic Structure Choosing a Format Writing the Report 10 - Other Types of Documents Requests for Proposals Projections Executive Summaries Business Cases 11 - Proofreading and Finishing A Proofreading Primer How Peer Review Can Help Printing and Publishing 12 - Wrapping Up Words from the Wise Additional course details: Nexus Humans Business Writing training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Business Writing course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

***24 Hour Limited Time Flash Sale*** Data Analysis, Statistics & Economics - QLS Endorsed Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Immerse yourself in the realm of Data Analysis, Statistics & Economics with our eight-course bundle, meticulously curated to offer a robust foundation in these critical fields. Our comprehensive package includes three prestigious QLS-endorsed courses in Statistics, Economics, and Basic Data Analysis, ensuring a strong foundational understanding. Plus, we supplement this knowledge with five relevant CPD QS accredited courses encompassing cutting-edge domains like Google Data Studio, Azure Machine Learning, AWS SageMaker Canvas, and more. No matter your current knowledge level, this course bundle will deepen your understanding of Data Analysis, Statistics & Economics and elevate your theoretical knowledge. Your achievement will be acknowledged with a hardcopy certificate for each QLS-endorsed course, a tangible testament to your dedication and hard work. In this digital age, skills in Data Analysis, Statistics & Economics are more than just desirable; they're indispensable. Equip yourself with the theoretical knowledge needed to navigate the complexities of these domains confidently. Whether you're looking to enhance your current skillset, seeking a career change, or just curious, this bundle is the perfect choice. Dive into the world of Data Analysis, Statistics & Economics today, and prepare to discover a wealth of knowledge. Key Features of the Data Analysis, Statistics & Economics Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our [Course_Title] bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Statistics QLS Course 02: Economics QLS Course 03: Basic Data Analysis 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Google Data Studio: Data Analytics Course 02: Azure Machine Learning Course 03: Machine Learning Model Using AWS SageMaker Canvas Course 04: Statistics & Probability for Data Science & Machine Learning Course 05: 2021 Data Science & Machine Learning with R from A-Z In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Data Analysis, Statistics & Economics courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes Gain a robust theoretical understanding of Statistics, Economics & Basic Data Analysis. Develop a strong foundation in Google Data Studio for data analytics. Acquire theoretical knowledge of Azure Machine Learning and its applications. Familiarise with Machine Learning model creation using AWS SageMaker Canvas. Understand the role of Statistics & Probability in Data Science and Machine Learning. Learn the principles and applications of Data Science & Machine Learning with R. Receive QLS-endorsed hardcopy certificates for three foundational courses. Dive into the comprehensive world of Data Analysis, Statistics & Economics with our tailored eight-course bundle. Our blend of three QLS-endorsed courses and five CPD QS accredited courses ensures a well-rounded understanding of these ever-relevant fields. Enhance your theoretical knowledge base and embrace the opportunity to explore different facets of these domains, from basic principles to the utilisation of cutting-edge tools. CPD 270 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals interested in gaining a theoretical understanding of Data Analysis, Statistics & Economics. Professionals looking to supplement their existing knowledge with a broadened skillset. Students seeking to complement their academic studies with additional courses. Career changers looking to delve into the fields of Data Analysis, Statistics & Economics. Career path Data Analyst: £26,000 - £50,000 Economic Consultant: £30,000 - £60,000 Statistical Analyst: £30,000 - £55,000 Machine Learning Engineer: £40,000 - £80,000 Business Intelligence Analyst: £35,000 - £65,000 Operations Research Analyst: £28,000 - £55,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Level 7 Diploma in Leadership & Management Online Training This Level 7 Diploma in Leadership & Management course will help you advance your career by providing you with the most up-to-date Leadership & Management information. The Level 7 Diploma in Leadership & Management course requires no prior knowledge or experience, as candidates are introduced to the characteristics and qualities of an effective leader. The term 'leader' refers to someone who is followed by others, while 'manager' refers to someone who has people working for them. To guide his or her team to achieve organizational goals, a successful business owner must be both an influential leader and an active manager. Whether you are a novice or a seasoned pro, this Training Tale course will help you develop the leader within you. By the end of the Level 7 Diploma in Leadership & Management course, you will have a solid understanding of what makes a great leader and how to put the strategies you have learned into practice to advance your career. Enrol in this Level 7 Diploma in Leadership & Management course to learn how to improve your Leadership & Management skills. Main Course: Leadership and Management Course Free Courses: Course 01: Level 7 Business Management Course 02: Level 5 Negotiation Skills Level 7 Diploma in Leadership & Management Training Course Curriculum Level 7 Diploma in Leadership & Management Module 01: Understanding Management and Leadership Module 02: Leadership over Yourself Module 03: Creativity and Innovation Module 04: Leadership and Teambuilding Module 05: Motivation and People Management Module 06: Communication and Leadership Module 07: Presentation, One-to-one Interview and Meeting Management Module 08: Talent Management Module 09: Strategic Leadership Module 10: Stress Management Assessment Method of Level 7 Diploma in Leadership & Management After completing each module of the Level 7 Diploma in Leadership & Management Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Level 7 Diploma in Leadership & Management After completing the MCQ/Assignment assessment for this Level 7 Diploma in Leadership & Management course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Level 7 Diploma in Leadership & Management Online Training This Level 7 Diploma in Leadership & Management course is for anyone serious about their professional development. Requirements Level 7 Diploma in Leadership & Management Online Training There are no specific requirements for this Level 7 Diploma in Leadership & Management course because it does not require any advanced knowledge or skills. Career path Level 7 Diploma in Leadership & Management Online Training Certificates Certificate of completion Digital certificate - Included

**10 FREE QLS Endorsed Certificates and Included with Lifetime Access** In today’s ever-shifting regulatory climate, understanding the rules of engagement is no longer a nice-to-have—it’s essential. This course offers a sharp look into the frameworks that keep organisations steady amidst uncertainty. Whether you're part of a small business or a larger corporate setup, staying ahead of the risks and knowing how to respond when the unexpected knocks is no longer optional. Here, learners gain clarity on the mechanisms that support strong internal oversight, policy awareness, and risk handling—without having to sift through mountains of jargon. The content is thoughtfully structured to walk you through vital concepts step by step, designed with professionals, managers and keen learners in mind. From operational pitfalls to governance essentials, the course breaks down key elements into digestible parts, always with an eye on clarity and relevance. It’s entirely online, meaning you can take charge of your learning on your own schedule—no train fares or seminar buffets required. Whether you're brushing up or starting fresh, it’s a tidy way to boost your know-how and keep your knowledge aligned with industry expectations. Compliance and Risk Management - QLS Endorsed Bundle Includes the following Courses Course 01: Certificate in Compliance and Risk Management at QLS Level 3 Course 02: Diploma in AML, KYC & CDD at QLS Level 4 Course 03: Diploma in Accounting and Finance at QLS Level 5 Course 04: Award in Accounting & Bookkeeping at QLS Level 2 Course 05: Diploma in Business Analyst Training at QLS Level 5 Course 06: Award in Business Finance at QLS Level 2 Course 07: Diploma in Business Law at QLS Level 5 Course 08: Diploma in Financial Reporting at QLS Level 4 Course 09: Diploma in Forex Trading at QLS Level 5 Course 10: Certificate in GDPR Training at QLS Level 3 Learning Outcomes Navigate financial regulations for effective compliance. Execute due diligence processes with precision. Master accounting and bookkeeping principles. Analyse business data for strategic decision-making. Understand the legal framework governing businesses. Communicate financial information transparently. Gain expertise in Forex trading dynamics. Implement GDPR principles for data protection. Develop robust risk management strategies. Apply anti-money laundering measures effectively. Key Features 10 FREE QLS Endorsed Certificate Fully online, interactive course Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases As the heartbeat of successful enterprises, compliance and risk management are the twin pillars that fortify your business against uncertainties and propel it towards prosperity. Immerse yourself in a comprehensive exploration of financial regulations, risk mitigation, and legal frameworks that underpin the business landscape. Navigate the complexities of AML, KYC, and CDD, gaining expertise in financial integrity protocols crucial for safeguarding organisations. Dive into the intricate realms of accounting, finance, and business law, refining your understanding at each QLS level. Our diploma in Business Analyst Training equips you with analytical prowess, essential for strategic decision-making. Acquire knowledge in GDPR compliance, ensuring your ability to navigate the evolving data protection landscape. Whether you aspire to reinforce your current role or transition to a new sector, this bundle is your gateway to a versatile skill set. With courses designed to align with industry demands, you'll stand out in today's competitive job market. Certificate Once you've successfully completed your course, you will immediately be sent a CPD-accredited PDF certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). After successfully completing the assignment, learners will be able to order FREE QLS Endorsed certificate for Each Courses. CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Professionals aspiring for financial expertise. Individuals entering the compliance and risk field. Business analysts seeking advanced training. Finance professionals aiming for legal comprehension. Those keen on mastering GDPR regulations. Individuals interested in forex trading. Aspiring accountants and bookkeepers. Professionals aiming for a well-rounded skill set. Career path Compliance Officer Risk Analyst Financial Analyst Business Analyst Forex Trader Legal Consultant Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. QLS Endorsed Certificate Hard copy certificate - Included

Awarded by NCFE + Ofqual Regulated + Tutor Support + Fully Online

Project Leadership Skills - Français: On-Demand To be effective within an organization, project managers must have a wide variety of skills and abilities.These include: creating and executing a vision;motivate others;influence without authority;networking;communicate up, down and laterally;the negociation;stakeholder management;and manage conflicts. This workshop aims to develop the soft skills essential to leading a team and creating lasting business change.Participants will gain insight into social science and brain science to motivate and empower others.They will learn and experiment with various influencing strategies and tactics. Participants will also discover their personal communication preferences, strengths and blind spots and learn how to best communicate with others they find 'difficult'.They will learn better how to manage the human side of change and learn strategies for managing each step.In the process.Practical negotiation and conflict management activities reinforce theoretical learning, rooting it in real life and making it actionable. What You Will Learn At the end of this program, you will be able to: Explain the importance of a vision in driving motivation and engagement Apply a scientific approach to better motivate those around you Strategically maximize your personal and positional power for better project results Determine influence and network development strategies necessary for personal development Know how to respond to communication challenges related to different personality styles Make the link between the expectations of stakeholders and the success criteria of a project Assess key stakeholders across different dimensions of complexity Apply the four rules of principled negotiation to real-life conflict situations Recognize key aspects of a physiological response to conflict Make the right choice of tools and techniques to "demine" an emotional situation Maximize different strategies and tactics to manage ambiguity at work Manage vision and purpose / Motivate others Communication and alignment with the vision Link the present to the future The Importance of Purpose The art and science of motivation Network development and influence Positive policy and project success Types of power in an organization power and influence Network Development Best Practices Communication The medium and the message Personality and communication styles Communication challenges Stakeholder management / Negotiation Identification of stakeholders Stakeholder analysis The basics of negotiation reasoned negotiation Manage the conflict Conflict dynamics The Anatomy of Conflict Conflict management approaches and tools Dealing with Ambiguity Summary and Next Steps Review of key concepts Create your personal action plan

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