1576 Running courses in Cardiff delivered Online

The most effective method to Run an Efficient Payroll Finance frameworks assume significant parts in organizations. They help measure representative installments and make vital allowances, including duty and National Insurance. Different assignments are performed to help run finance each month. Be that as it may, if organizations are not cautious, they can invest an excessive amount of energy on finance, leaving little for other significant parts of the business. That clarifies why it is critical to run a proficient finance. With a viable framework set up, it turns out to be not difficult to conquer the different difficulties that wasteful frameworks present. This course has been intended to assist you with figuring out how to make any current finance framework more productive for better results. To begin with, it clarifies the different difficulties a wasteful finance can present and the need to defeat them. Then, it clarifies different issues organizations regularly experience with manual finance measures. It proceeds to examine different ways little and huge organizations can improve their payrolls for expanded proficiency. You Will Learn: The difficulties that finance frameworks regularly present The issues organizations experience with manual payrolls Instructions to run a productive finance Instructions to improve a current finance framework The advantages of running a productive finance framework Advantages of Taking the Course Taking this course will help you to: Better comprehend the job of finance frameworks in organizations Defeat existing difficulties in business finance measures Figure out how to improve finance handling proficiency Gain proficiency with the substance of consistent preparing and training among representatives Discover why most organizations are moving from manual finance to mechanized finance frameworks Value finance and its job in huge and independent ventures Consider your objectives and choose whether you are keen on taking up a profession in bookkeeping Plan for your future business fire up

Organisational Skills for Administrators Organisational skills are something that successful business owners share. The ability to organise work and resources is key to running a successful business. Today's competitive business environment calls for strong organisational skills. A small business succeeds when deadlines and appointments are kept and met, without any wastage of time. Managers use organisational skills to steer their companies forward. Time management, scheduling, task prioritisation and planning are critical aspects of an administrator's organisational skills. Just like receptionists and secretaries, administrators are often associated with greeting guests at the office and answering phone calls. However, they are the core of businesses. They enable each member of the business team to get their jobs done. They communicate on behalf of executives, organise schedules, develop and maintain contact lists and offer support, among other roles. They are integral to business teams and, thus, must possess the right skill set to get their jobs done. This course covers various facets of an administrator's organisational skills. You Will Learn: The definition of organisational skills and what they entail The benefits of organisational skills Over 10 organisational skills for administrators and what they involve Benefits of Taking This Course: Taking this course will help you: Understand organisational skills and their role in business settings Determine the organisational skills that you possess Learn how to develop and improve your organisational skills Learn the benefits of possessing organisational skills Learn how organisational skills benefit both the administrator and the company or employer Determine if you have got what it takes to become an administrator Identify the skills to work on as an administrator Determine the skills to include in your CV, as an administrator who is looking for better job opportunities

Cleaning Specialist is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Cleaning Specialist and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 06 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Module 01: An Introduction to the Cleaning Job An Introduction to the Cleaning Job 00:18:00 Module 02: The Diversity of Cleaning Jobs The Diversity of Cleaning Jobs 00:25:00 Module 03: Cleaning Equipment, Products and Clothing Cleaning Equipment, Products and Clothing 00:23:00 Module 04: House Cleaning House Cleaning 00:22:00 Module 05: Food Kitchen and Commercial Kitchen Cleaning Food Kitchen and Commercial Kitchen Cleaning 00:22:00 Module 06: Bathrooms and Toilets Bathrooms and Toilets 00:21:00 Module 07: Office Cleaning Office Cleaning 00:19:00 Module 08: Cleaning External Surfaces and Areas Cleaning External Surfaces and Areas 00:17:00 Module 09: Dealing with Non-Routine Waste Dealing with Non-Routine Waste 00:20:00 Module 10: Chemical Safety, Keyholding and Alarm Codes for Cleaners Chemical Safety, Keyholding and Alarm Codes for Cleaners 00:20:00 Module 11: Starting a Cleaning Business and Planning for it Planning and Starting a Cleaning Business 00:16:00 Module 12: Running the Business with Quality Service Running the Business with Quality Service 00:21:00 Module 13: Customer Satisfaction Customer Satisfaction 00:22:00 Module 14: Management of Staff Management of Staff 00:21:00 Module 15 Marketing, Advertising and Sales Marketing, Advertising and Sales 00:23:00 Module 16: Expansion Management Expanding Your Business 00:17:00 Module 17: Business Insurance, Tax and Additional Equipment Business Insurance, Tax and Additional Equipment 00:23:00

Description Learn how to train animals, walk them safely, look after them and start your own pet business! This Pet Business Certificate starts with the basics of first aid and find out how to administer pills, liquid medications, and injections to an uncooperative cat or dog. You will explore pet care, including nutrition, exercise, first aid, and identification of common diseases. You'll also explore sticky situations that can arise, such as lost pets, pets that die unexpectedly, and pets that need immediate veterinary care. You will learn about finances and explore start-up costs, accounting, fee-setting, business plans, and low-cost marketing. You'll learn how to obtain required insurance, hire employees as your business expands, and entice financial institutions to loan you money.  By the end of this course, you'll have all the knowledge you need to become a professional pet sitter. In addition, you'll see how your pet sitting business can grow to continually challenge and satisfy you. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is This Pet Business Certificate Course for? Pet Business Certificate is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Pet Business Certificate is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction 00:06:00 Legal Requirements Legal Requirements 00:37:00 Running Your Own Business Running Your Own Business 00:16:00 Marketing Marketing 00:16:00 Setting Your Prices Setting Your Prices 00:11:00 Business Costs Business Costs 00:08:00 Forms & Record Keeping Forms & Record Keeping 00:15:00 Pre-Service Visit Pre-Service Visit 00:07:00 Difficulties & Challenges Difficulties & Challenges 00:17:00 Assessment Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: A staff retreat is important to maintain harmony in an office environment. It usually takes longer than two hours of staff meetings to get the work done. This Staff Retreating Certificate Course will help you change your approach towards your colleagues and help bolster your communication with them. In this course, you will learn about importance of discussing experiences in staff retreats, know the reasons, develop and present staff retreats relevant activities, evaluation questionnaire, checklist, etc. You will be able to garner knowledge which will help you increase productivity, efficiency and sales. Learning Outcomes: Analyse experience with staff retreats Get information for what staff retreats are operated Realise the chief staff retreat undertakings categories Improve as well as present retreat activities Figure out the critical components for success of a staff retreat Formulate a planning Learn how to apply the keys to running checklist for a staff retreat Enhance an assessment questionnaire Identify post-retreat activities that would assert the consistent success of your staff retreats Turn your top three take home ideas into reality for producing successful staff retreats Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Staff Retreating Certificate Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Staff Retreating Certificate Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Course Overview 00:15:00 Staff Retreats 00:15:00 Types of Undertakings at a Staff Retreat 00:15:00 Designing a Staff Retreat 00:45:00 Running the Retreat 00:30:00 Post-Retreat 00:15:00 Mock Exam Mock Exam- Staff Retreating Certificate Course 00:20:00 Final Exam Final Exam- Staff Retreating Certificate Course 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Unlock the door to your business future with our QLS Endorsed Business Development, Analysis, and Finance course bundle. This comprehensive selection includes three QLS-endorsed courses: Business Development, Diploma in Business Analysis, and Basic Business Finance, each conferring a hardcopy certificate upon completion as a testament to your theoretical prowess. In addition to these, five CPD QS accredited courses are part of the package. These insightful courses delve into Business Law, Marketing Strategies for Business, Business Continuity Management, Business Intelligence and Data Mining, and Touch Typing Essentials. Armed with this robust knowledge, you can confidently navigate the business world, adeptly handling development, analysis, and finance. Whether your interest lies in entrepreneurship, corporate finance, or business analysis, this bundle offers an enriching theoretical journey into the heart of business. Key Features of the QLS Endorsed Business Development, Analysis and Finance Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our QLS Endorsed Business Development, Analysis and Finance bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Business Development QLS Course 02: Diploma in Business Analysis QLS Course 03: Basic Business Finance 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: Business Law Course 02: Marketing Strategies for Business Course 03: Business Continuity Management Course 04: Business Intelligence and Data Mining Course 05: Touch Typing Essentials 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 QLS Endorsed Business Development, Analysis and Finance courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Gain a comprehensive understanding of business development principles. Acquire skills to perform effective business analysis. Understand the basics of business finance. Familiarise with the legal aspects of running a business. Learn how to develop effective marketing strategies. Understand the importance of business continuity management. Gain insights into business intelligence and data mining. Our QLS Endorsed Business Development, Analysis, and Finance bundle presents a comprehensive theoretical journey into the world of business. The course bundle is a balance of QLS-endorsed and CPD QS accredited courses, covering critical areas like business development, business analysis, business finance, business law, marketing strategies, business continuity management, business intelligence, data mining, and touch typing essentials. This bundle is a gateway to a holistic understanding of business processes, structures, and strategies, whether you're a budding entrepreneur, an aspiring business analyst, or a business graduate seeking deeper knowledge. Dive into this wealth of knowledge and embark on a successful business career! CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring entrepreneurs looking to understand the nuances of business development, analysis, and finance. Individuals aiming to pursue a career in business analysis or finance. Business professionals seeking to broaden their knowledge and skills. Students of business studies wishing to supplement their academic learning. Career path Business Development Manager (Salary Range: £30,000 - £60,000) Business Analyst (Salary Range: £35,000 - £70,000) Finance Manager (Salary Range: £40,000 - £75,000) Business Law Consultant (Salary Range: £40,000 - £90,000) Marketing Strategist (Salary Range: £25,000 - £55,000) Business Continuity Manager (Salary Range: £40,000 - £80,000) Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Unveil your entrepreneurial spirit with our encompassing course bundle: "Candle Making, Startup and Baking Business - QLS Endorsed". Through this journey, you'll find the theoretical knowledge needed to start your Candle Making Business, learn the intricacies of a Startup, and discover the secret recipe to a successful Baking Business. Begin your journey with our QLS-endorsed courses, diving deep into the realm of Candle Making Business, exploring the essential components of a successful Business Startup, and kneading your path to Baking Business mastery. Upon course completion, receive a hardcopy certificate, showcasing your theoretical proficiency in Candle Making, Startup and Baking Business. To complement these, our bundle also includes five CPD QS accredited courses, each covering an essential aspect of your business journey. Key Features of the Candle Making, Startup and Baking Business Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Candle Making, Startup and Baking Business bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Candle-Making Business QLS Course 02: Business Startup QLS Course 03: Baking: Starting Your Own Bakery 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: Cookery Course Course 02: UK Cooking and Gastronomy Technician Course 03: Mastering Entrepreneurship Course 04: Business Management Course 05: Business Law 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 Candle Making, Startup and Baking Business courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Ready to embark on your entrepreneurial journey in Candle Making, Startup, and Baking Business? Enroll today! Learning Outcomes: Understand the theoretical aspects of starting and managing a Candle Making Business. Learn the essential components of launching a Business Startup. Gain theoretical knowledge about starting and running a successful Baking Business. Enhance your culinary skills through the Cookery Course and UK Cooking and Gastronomy. Gain entrepreneurial knowledge through the Mastering Entrepreneurship course. Learn about Business Management and Business Law. Grasp the key factors for the successful operation of your business. The "Candle Making, Startup, and Baking Business - QLS Endorsed" bundle equips you with the comprehensive theoretical knowledge you need to kick-start your entrepreneurial journey. With our blend of three QLS-endorsed and five CPD QS accredited courses, we pave the way for you to explore your passion in Candle Making, Startup, and Baking Business. Embrace your entrepreneurial spirit and join us as we explore the theoretical concepts of candle making, starting up a business, and baking, paving the way to fulfilling your business aspirations. CPD 260 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring entrepreneurs interested in Candle Making, Startup and Baking Business. Individuals who want to gain theoretical knowledge in the field of entrepreneurship. Anyone looking to refine their skills in cookery and gastronomy. Individuals aiming to understand business management and business law. Career path Candle Making Business Owner - £20,000 - £40,000 per year. Startup Founder - £25,000 - £70,000 per year. Bakery Owner - £20,000 - £50,000 per year. Gastronomy Technician - £20,000 - £40,000 per year. Business Manager - £30,000 - £60,000 per year. Business Law Consultant - £40,000 - £80,000 per year. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Level 5 Certificate in Cleaning Overview In order to maintain a clean and healthy living environment, cleaning is an integral part of our everyday life. However, cleaning needs a certain set of abilities and knowledge, and it can be a difficult and time-consuming task. This is where the Level 5 Certificate in Cleaning comes in handy. After finishing this course, you will have an in-depth knowledge of the cleaning sector and know how to successfully and efficiently offer high-quality cleaning services. The 17 modules in the course cover every facet of cleaning, from basic housekeeping to cleaning offices and commercial kitchens to cleaning exterior surfaces and spaces. Every module aims to equip you with the necessary information and abilities to thrive in the cleaning sector. Additionally, you will learn about keyholding, chemical safety, and cleaner alarm codes-all of which are critical knowledge for any professional cleaner. The course covers effective cleaning techniques in addition to staff management, staff startup, marketing, advertising, and sales. Using this all-inclusive strategy guarantees that you possess not just the ability to deliver high-quality cleaning services but also the know-how and abilities to manage a profitable cleaning company. Learning Outcome Familiarise with the cleaning job Understand the diversity of cleaning jobs Gain in-depth knowledge of cleaning equipment, products and clothing Deepen your understanding of house cleaning How Much Do Cleaners Earn? Senior - £25,000 (Apprx.) Average - £20,000 (Apprx.) Starting - £17,000 (Apprx.) Requirement Our Level 5 Certificate in Cleaning is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Level 5 Certificate in Cleaning Module 01: An Introduction to the Cleaning Job An Introduction to the Cleaning Job 00:16:00 Module 02: The Diversity of Cleaning Jobs The Diversity of Cleaning Jobs 00:23:00 Module 03: Cleaning Equipment, Products and Clothing Cleaning Equipment, Products and Clothing 00:21:00 Module 04: House Cleaning House Cleaning 00:20:00 Module 05: Food Kitchen and Commercial Kitchen Cleaning Food Kitchen and Commercial Kitchen Cleaning 00:20:00 Module 06: Bathrooms and Toilets Bathrooms and Toilets 00:19:00 Module 07: Office Cleaning Office Cleaning 00:17:00 Module 08: Cleaning External Surfaces and Areas Cleaning External Surfaces and Areas 00:15:00 Module 09: Dealing with Non-Routine Waste Dealing with Non-Routine Waste 00:18:00 Module 10: Chemical Safety, Keyholding and Alarm Codes for Cleaners Chemical Safety, Keyholding and Alarm Codes for Cleaners 00:18:00 Module 11: Starting a Cleaning Business and Planning for it Starting a Cleaning Business and Planning for it 00:14:00 Module 12: Running the Business with Quality Service Running the Business with Quality Service 00:19:00 Module 13: Customer Satisfaction Customer Satisfaction 00:20:00 Module 14: Management of Staff Management of Staff 00:19:00 Module 15: Marketing, Advertising and Sales Marketing, Advertising and Sales 00:21:00 Module 16: Expansion Management Expansion Management 00:15:00 Module 17: Business Insurance, Tax and Additional Equipment Business Insurance, Tax and Additional Equipment 00:21:00

Duration 5 Days 30 CPD hours This course is intended for This is an intermediate course for z/OS system programmers, z/OS performance analysts, and z/OS performance administrators new to performance management for their z/OS system.Note: ES54 is intended for individuals new to WLM and the z/OS performance area Overview The objectives for this course are as follows:Describe a performance and tuning methodologyDevelop a systematic z/OS performance and tuning planDescribe the factors which could affect the performance of an z/OS systemUse the WLM ISPF applicationDescribe the components of a service definitionDefine workloads and service levels and classification rulesState which z/OS commands affect WLM operationIdentify the major WLM services for z/OS, including enclaves and application environments, and how they are used by DB2, WebSphere, and CICSAnalyze CPU performance when running in a shared LPAR environmentUtilize and monitor zIIP and zAAP specialty enginesMeasure and tune z/OS DASD, processor storage, and coupling facility configurationsExplain the functions and facilities of RMF and SMFAnalyze performance bottlenecks using RMFUse Workload License Charges (WLC), defined capacity and soft capping to manage software costsDescribe advanced z/OS environments that utilize Intelligent Resource Director (IRD), HiperDispatch, z/OSMF Workload Management, and I/O Priority ManagerUse the z/OSMF Workload Management (WLM) taskUse Performance Monitoring with z/OSMFModify a WLM service definition to meet the requirements for monitoring a specific system workloadCreate and customize Monitoring DesktopsReview any issues by using the Monitoring Desktops options displaysAssess the performance of the workloads running on the z/OS This course is designed for new performance analysts to learn to work with the Workload Manager (WLM) in goal mode. Learn concepts of WLM and performance management in the z/OS system using the WLM. Day 1 Welcome Unit 1 - Tuning methodology Unit 2 - Using SMF and RMF to monitor performance Lab 1 - Introduction to your system Lab 2 - Using RMF Monitor I and Monitor II Day 2 Unit 3 - Performance impacts when running in a shared LPAR environment Unit 4 - Basic system workload management (part 1) Lab 3 - Implementing a WLM environment on z/OS (part 1) Day 3 Unit 4 - Basic system workload management (part 2) Lab 3 - Implementing a WLM environment on z/OS (part 2) Day 4 Unit 5 - WLM commands, internals, and service Lab 4 - Using RMF Monitor III to solve performance problems Day 5 Unit 6 - z/OS DASD performance topics Unit 7 - Tuning processor storage Unit 8 - Miscellaneous performance topics Lab 5 - z/OSMF and performance management

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