5344 Productivity courses in Cardiff delivered Online

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified HR Management and Recruitment Training bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 33 course mega bundle that will exceed your expectations within your budget. The HR Management and Recruitment Training related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive HR Management and Recruitment Training bundle will help you build a solid foundation to become a proficient worker in the sector. This HR Management and Recruitment Training Bundle consists of the following 30 CPD Accredited Premium courses - Course 01:HR Management Course 02:UK Employment Law Course 03:Interview and Recruitment Course 04:Recruitment and Termination Course 05:Safer Recruitment Training Course 06:Employee Performance Management Course 07:Cross-Cultural Awareness Training Course 08:Document Control Course 09:Information Management Course 10:Microsoft Word, PowerPoint & Outlook Course 11:Corporate Paralegal Course 12:Admin, Secretarial & PA Course 13:Stakeholder Management Course 14:Contract Analyst Course 15:Management Skills: A New Manager Course 16:Decision Making and Critical Thinking Course 17:Presentation Skills Course 18:Equality, Diversity and Discrimination Course 19:Workplace Confidentiality Course 20:General Data Protection Regulation (GDPR) Awareness Course 21:Workplace Productivity Course 22:Leadership and People Management Diploma Course 23:Change Management Course 24:Team Management Course 25:Employee Relations Course 26:Corporate Governance Course 27:Online Meeting and Virtual Conference Course 28:Facilities Management Course 29:Motivation Course 30:Life Coaching and Career Counselling 3 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Learning Outcome This tailor-made HR Management and Recruitment Training bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This HR Management and Recruitment Training Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 330 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the HR Management and Recruitment Training bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in HR Management and Recruitment Training Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

The Sales Accelerator programme is a fresh approach to improving business development productivity. It focuses on identifying and using a series of business productivity metrics in order to build a clear action plan for improving sales results - typically within 90 days. The metrics are grouped under three headings: The basic principle is that a small improvement in each area can lead to a significant increase in sales results and productivity. And the object of the programme is to show how best to achieve that. The programme therefore looks at each of these three areas in turn, spending a day on each. Suitable for any and all businesses and all levels of experience and expertise, this is a remarkably practical and hands-on programme. During the workshop, participants discuss, review and apply many proven sales and marketing techniques and personal selling ideas. The goal is to generate and commit to changes and actions that can lead to a 10-30% increase in the next three to six months. There's also a consultancy option, rather than the workshop-based programme. See below for details. Day one - Activity Key objective This first module introduces the Sales Accelerator model. The goal here is to show participants how to increase their pro-active activity levels by around 10%. It covers all aspects of creating new business opportunities, from existing customers and non-customers alike, and is linked to personal activity improvement goals. Main elements Improve the productivity, accuracy and effectiveness of your business approach by using new and unique models and techniques. Different methods of creating and generating new business opportunities in the short, medium and long term. This includes sourcing new business, up-selling, cross-selling, warm calling and gaining referrals. Using organised persistence to track and build new customer revenue. Managing your sales time effectively. Key learning points Sales productivity - understand the dynamics of increasing the combination of activity levels, deal value and conversion rate of proposals/quotations to orders and implement an improvement plan. Sales goal setting: setting business development objectives for quantity and quality - plus tips and tricks of top performers. Maintain a peak activity level, on a consistent basis using 'organised persistence' and structured business development tracking methodology. How to prioritise opportunities and manage your time when sourcing new business. Identify potential new customers - and particularly the decision-makers and influencers - with greater accuracy. Make outbound business or appointment calls with improved confidence, control and results. Day two - Value Key objective To be able to better anticipate, identify, create, and develop business opportunities using a customer / client-focused communication-based business model and consultative skills. Main elements How to develop sales more effectively from new and existing customers; and managing the first appointment with a new customer. Use structured and assertive drawing-out skills to identify, develop and formalise business opportunities and to gain commitment. How to better position your company and your products and services against your main competitors. Create and deliver persuasive business messages based on specific need areas, criteria and value. Key learning points Advanced consultative selling - use a variety of structured and advanced questioning techniques to confidently and efficiently uncover opportunities, need areas and business criteria - confidently and efficiently. Involve the customer/client at all times, and to a far greater degree, and keep better control of business development process. Value message - differentiate your solutions clearly and accurately with customer/client-matched value statements. Presenting the right USPs, features and benefits and making them relevant and real to the customer. Qualification and reading buying signals. Day three (held around four weeks after the first module) - Conversion Key objective This module looks at how to improve the final qualification, progression and conversion of opportunities in your sales pipeline. Also includes price negotiation, overcoming objections and obstacles to gaining agreement. The module begins with a learning review, sharing participants' experiences over the last four weeks in applying the new techniques and skills acquired during the first two modules. This is an opportunity to revisit particularly challenging areas as well as to share and celebrate successes. Main elements Structuring and preparing for negotiating a deal and knowing when and how to move into the 'end-game' mode. Anticipate and answer customer objections and questions more confidently. Build more credibility and proof into your business process to reduce 'buyer's remorse' and speed-up decision-making. Being more assertive and developing better instincts and strategic thinking in progressing quotations and proposals. Key learning points Smart ways to position price, emphasise value and be a strong player without being the cheapest. Becoming more assertive in closing deals, and the importance of organised follow-up on the telephone. Qualify pipeline opportunities with more accuracy, using a proven check-list. Use an 'option generator' to simplify complex proposals, increase business value and close business faster. Writing more effective sales proposal documents and quotations. How best to draw-out, understand, isolate and answer customer objections, negotiate points and concerns. Practical methods of asking for agreement and closing a sale

Get ready for an exceptional online learning experience with the Emotional Intelligence, Organizational Behaviour, REBT, Psychology & Career Development bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Emotional Intelligence, Organizational Behaviour, REBT, Psychology & Career Development is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. This Emotional Intelligence package offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Emotional Intelligence package has something for everyone. As part of the Emotional Intelligence, Organizational Behaviour, REBT, Psychology & Career Development package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Emotional Intelligence bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Emotional Intelligence Bundle Comprises the Following CPD Accredited Courses: Emotional Intelligence Organizational Behaviour, HR and Leadership Level 3 Coaching & Mentoring Course Master Emotional Intelligence for Crucial Moments Rational Emotive Behaviour Therapy (REBT) Certificate Influencing and Negotiating Personal and Networking Skills Anger Management and Conflict Resolution Program Career Development and Passion Positive Psychology Masterclass Goal Setting, Motivation, and Resilience for Life Using Mindfulness at Work for Productivity Self-Help Psychology: Mental Freedom Self Confidence & Self Esteem Workplace Productivity Training Career Development Plan Fundamentals CV Writing and Job Searching Learn to Level Up Your Leadership Networking Skills for Personal Success Ace Your Presentations: Public Speaking Masterclass Learning Outcome: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the Emotional Intelligence Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with Emotional Intelligence. Build a strong knowledge base in your chosen course via Emotional Intelligence. Benefit from the flexibility and convenience of online learning. With the Emotional Intelligence package, validate your learning with a CPD certificate. Each course from Emotional Intelligence bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This Emotional Intelligence bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with Emotional Intelligence, Organizational Behaviour, REBT, Psychology & Career Development, a rich anthology of 15 diverse courses. Each course in the Emotional Intelligence bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. This Emotional Intelligence, Organizational Behaviour, REBT, Psychology & Career Development bundle will take you on a unique and enriching educational journey. The Emotional Intelligence bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Emotional Intelligence, Organizational Behaviour, REBT, Psychology & Career Development bundle offers you the flexibility and convenience to learn at your own pace. Make the Emotional Intelligence package your trusted companion in your lifelong learning journey. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Emotional Intelligence, Organizational Behaviour, REBT, Psychology & Career Development bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Career path Unleash your potential with the Emotional Intelligence, Organizational Behaviour, REBT, Psychology & Career Development bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Emotional Intelligence bundle package. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

With specialized skills being on primary focus, professionals most of the time tend to forget about few skills that every boss looks for. One of the very first things they look at you is if you are a creative thinker and an innovative person. This course deals with skills mostly ignored yet important nevertheless. The next thing the boss seeks out for in you is if you have the ability to build your own self-esteem and how assertive you are as a professional at your work. This course discusses on how to put more effort in your personal development. If you want to become a critical thinker and good at problem-solving, this course is just perfect for you! Learning Outcomes: How to recognise the variation between creativity and innovation How to locate their individual creativity Means to create their respective creative atmosphere The significance of creativity as well as innovation in business Problem solving methods and tools Personal and group techniques so as to assist produce creative concepts How to apply creative concepts Recognise the terms of personal proficiency and the skills sets can develop the personal productivity, as well as the attitudes we should nurture Elaborate the reasons for which multi-tasking is a myth Relate the role of long term goals for the short term effectiveness Learn sharing a personal vision and improve dreams as well as goals from it Execute the 80/20 rule know the way it should affect your planning Recognise the features of a healthy organisation system Improvise a strategy for a proficient workspace, involving a customised information centre as well as a filing system Implement a system allowing them for processing any kind of information crossing their desk Apply the Eisenhower principle to prioritise work as well as your routines so that you can simplify your life Realise the reasons for which they procrastinate along with developing strategies to tackle tasks Execute tools to turn their households more productive as well as more effective How to apply problem solving steps and tools How to analyze information to clearly describe problems How to identify appropriate solutions Ways to think creatively and be a contributing member of a problem solving team How to select the best approach for making decisions How to create a plan for implementing, evaluating, and following up on decisions Ways to avoid common decision-making mistakes 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? Essential Skills Training 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 Essential Skills Training 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. Module: 1 What Is Creativity and Innovation? 00:15:00 Individual Creativity 00:30:00 Developing the Right Environment for Creativity 00:15:00 Creativity and Innovation in Business 00:15:00 Where Does Creativity Fit Into the Problem-Solving Process? 00:30:00 Defining the Problem 00:30:00 Creative Techniques 00:45:00 Encouraging Creativity In A Team 00:30:00 Putting It All Together 00:15:00 Module: 2 What is Self-Esteem? 00:30:00 Improving Self-Esteem 00:30:00 Building Self-Esteem 00:15:00 Increasing our Self-Esteem 00:15:00 Esteemed Confidence 00:30:00 Ask for What You Want 00:30:00 Create What You Want 00:00:00 Module: 3 Understanding Personal Efficiency 00:15:00 Developing the Right Attitude 00:15:00 Laying the Foundation 00:15:00 The Building Blocks of a Good Organizational System 00:15:00 Creating the Right Environment 00:30:00 Setting Up Your Virtual Environment 00:15:00 Setting Up Your Information Management Center 00:30:00 Managing Information in Six Easy Steps 00:15:00 Prioritizing Your Tasks 00:15:00 Saying No 00:15:00 Creating Routines 00:15:00 Stopping Procrastination Now (Not Later!) 00:15:00 Module: 4 Definitions of Problem Solving & Decision Making 00:30:00 Making Decisions 00:30:00 The Problem Solving Model 00:15:00 The Problem Solving Toolkit 00:30:00 Aspirinia 00:15:00 Swotting Up 00:15:00 Making Good Group Decisions 00:30:00 Analyzing and Selecting Solutions 00:15:00 Planning and Organizing 00:15:00 Module: 5 Understanding Critical Thinking 00:30:00 Where Do Other Types of Thinking Fit In? 00:15:00 Pitfalls to Reasoned Decision Making 00:15:00 The Critical Thinking Process 01:00:00 A Critical Thinker's Skill Set 01:00:00 Creating Explanations 00:15:00 Dealing with Assumptions 00:15:00 Critical and Creative Thought Systems 01:00:00 Putting It Into Practice 00:15:00 Mock Exam Mock Exam- Essential Skills Training 00:30:00 Final Exam Final Exam- Essential Skills Training 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Feeling the squeeze of GCSEs approaching? Did you know that in the UK, 55% of students find English and Maths the most challenging subjects? Don't let statistics dictate your success! This GCSE Maths and GCSE English preparation bundle is designed to equip you with the confidence and skills to ace your GCSEs and unlock a world of possibilities. The GCSE Maths and GCSE English Preparation course bundle transcends traditional GCSE boundaries, immersing you in Functional Skills Maths and English to further enhance your numeracy and literacy skills. As part of the GCSE Maths and GCSE English Preparation journey, you will also delve into the world of GCSE ICT, exploring Network Essentials in a way that makes sense to the digital-savvy learner of today. Moreover, as a unique value-addition, this GCSE Maths and GCSE English Preparation bundle offers Time Management & Productivity Training, to help you excel in your GCSE subjects. Courses Are Included in this GCSE Maths and GCSE English Preparation - CPD Certified Bundle: Course 01: GCSE English Preparation Course 02: IGCSE Maths Preparation Course 03: Functional Skills Maths Course 04: IGCSE ICT: Network Essentials Course 05: Functional Skills English Don't let exam anxieties hold you back. Take control of your future and enrol in this course today! Learning Objectives of GCSE Maths and GCSE English Preparation : Develop a strong foundational understanding of GCSE English and GCSE Maths. Enhance functional skills in Maths and English, complementing your GCSE study plan. Gain theoretical insights into GCSE ICT, focusing on Network Essentials, and enriching your GCSE curriculum. Understand how to manage time and increase productivity, optimising your study habits for GCSE success. Develop effective strategies for GCSE exam preparation and study planning. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of GCSE Maths and GCSE English Get a free student ID card with GCSE Maths and GCSE English Training program (£10 postal charge will be applicable for international delivery) The GCSE Maths and GCSE English is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the GCSE Maths and GCSE English course materials The GCSE Maths and GCSE English comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: GCSE English Preparation Module 01: Introduction To GCSE English Module 02: Edexcel English Section A Part 01 Module 03: Edexcel English Section A Part 02 Module 04: Edexcel English Section B Module 05: Edexcel English Section C Module 06: Cambridge English Exercise 1-4 Module 07: Cambridge English Exercise 5 Module 08: Cambridge English Exercise 6 Module 09: Basics Of Grammar Part 01 Module 10: Basics Of Grammar Part 02 Module 11: The Basics Of Sentences Module 12: Structure Of Sentences Module 13: English Language Reading Part 01 Module 14: English Language Reading Part 02 Module 15: English Academic Writing Part 01 Module 16: English Academic Writing Part 02 Module 17: Punctuation And Capitalisation In Writing Module 18: Most Common Mistakes And How To Avoid Them Module 19: Cambridge English Listening Module 20: Cambridge English Speaking Course 02: IGCSE Maths Preparation Module 01: Introduction Module 02: Previous Exams Solving Module 03: 2020 Specimen Solving Module 04: Examples Of Candidate Response In Previous Years Module 05: Additional General Questions Course 03: Functional Skills Maths Integers ( Directed Numbers) Factors And Multiples Fractions Simplification Rule : BODMAS Decimal Numbers Rational Numbers Approximation Estimation And Scientific Notation Or Standard Form Percentage Ratio And Proportion Unitary Method And Its Applications Profit , Loss, Discount And Tax =========>>>>> And 2 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*5 = £65) CPD Hard Copy Certificate: £29.99 CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This GCSE Maths and GCSE English Preparation bundle is suitable for GCSE students in need of Maths and English exam prep Home learners and homeschoolers Adults seeking skills refreshment Parents supporting their children Anyone wanting to improve maths and English skills Requirements You will not need any prior background or expertise to enrol in this GCSE Maths and GCSE English Preparation. Career path This GCSE Maths and GCSE English Preparation bundle will allow you to kickstart or take your career in the related sector to the next stage. Higher Education Apprenticeships Skilled Jobs Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee.

Level 2 & 4 Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access

Embark on a transformative DevOps journey! This comprehensive course equips you with skills in Ansible, Docker, GitLab, backups, and more. Master the art of self-hosting your infrastructure, streamlining deployments, and boosting efficiency. Launch your DevOps career today and unleash the endless possibilities!

Duration 3 Days 18 CPD hours This foundational course to Citrix Workspace intelligence ushers you into the new generation of Citrix. You will discover how intelligent features help organize, guide, and automate the future of your work.You will gain an understanding of the fundamentals of web services, APIs, and systems integrations through building microapps designed to boost employee productivity and optimize the end user experience.Through this course, you will learn the fundamentals of Citrix Workspace intelligence features, web services, security considerations and API troubleshooting to help you successfully deploy intelligent workspace features in your environment. This foundational course to Citrix Workspace intelligence ushers you into the new generation of Citrix. You will discover how intelligent features help organize, guide, and automate the future of your work. You will gain an understanding of the fundamentals of web services, APIs, and systems integrations through building microapps designed to boost employee productivity and optimize the end user experience. Through this course, you will learn the fundamentals of Citrix Workspace intelligence features, web services, security considerations and API troubleshooting to help you successfully deploy intelligent workspace features in your environment.

This workshop helps you understand the neuroscience behind why working ‘harder’ isn’t the answer to being effective at work. You'll get to recognise your default behaviour and helpful alternatives to managing competing requests on your time.

🌟 Unlock Your Excel Potential with Microsoft Excel 2019 - Intermediate Level Training! 🌟 Master the art of Excel with our comprehensive online course designed specifically for intermediate learners. Elevate your skills, boost productivity, and excel in spreadsheet management like never before. 📊 Course Curriculum 📊 🔹 Section 1 - Excel - Intermediate: Dive into the intermediate level of Excel functionalities, bridging the gap between basic and advanced techniques. 🔹 Section 2 - Lists: Learn the art of managing data efficiently with lists, organizing information for streamlined analysis and presentation. 🔹 Section 3 - DataBase Functions: Harness the power of database functions, empowering you to manipulate data with ease and precision. 🔹 Section 4 - Data Validation: Ensure data accuracy and integrity by implementing effective data validation techniques, preventing errors in your spreadsheets. 🔹 Section 5 - Importing and Exporting: Master the process of importing and exporting data seamlessly, integrating external information into your Excel sheets effortlessly. 🔹 Section 6 - Creating Basic Charts: Transform data into impactful visuals with basic chart creation, enhancing your ability to communicate insights effectively. 🔹 Section 7 - Pivot Tables: Unlock the potential of pivot tables, harnessing their analytical power to summarize and analyze complex data sets effortlessly. 🔹 Section 8 - Working with Large Data: Navigate and manipulate extensive data sets efficiently, optimizing your workflow with strategies tailored for large-scale information. 🔹 Section 9 - LookUp Functions: Explore lookup functions to search for and retrieve specific data, refining your ability to find information swiftly. 🔹 Section 10 - Advanced Functions: Elevate your Excel proficiency with advanced functions, expanding your capabilities to handle complex calculations and tasks. 🔹 Section 11 - Excel Intermediate - Conclusion: Wrap up your intermediate Excel journey, reinforcing key concepts and preparing you for further advancements. 🎓 Why Choose Our Course? 🎓 🚀 Comprehensive Learning: A structured curriculum tailored to the needs of intermediate Excel users, covering a wide array of functionalities. 👨‍🏫 Expert Guidance: Led by industry experts well-versed in Excel, ensuring a rich learning experience with practical insights. 🤝 Interactive Learning: Engage with interactive exercises and real-life examples, solidifying your understanding through hands-on practice. 📈 Career Growth: Acquire skills highly sought after in the job market, giving you a competitive edge in various professional domains. 🔓 Don't miss this opportunity to take your Excel skills to the next level! Enroll now and unleash your potential with Microsoft Excel 2019 - Intermediate Level Training. 🔓 Course Curriculum Section 1 - Excel - Intermediate Excel Intermediate Introduction 00:00 Intermediate Shortcut Keys 00:00 Section 2 - Lists What are Lists 00:00 Sorting a List 00:00 Sorting - Multiple Criteria 00:00 Custom Sort 00:00 What are Filters 00:00 Format a List as a Table 00:00 Section 3 - DataBase Functions Introduction to DataBase Functions 00:00 DSum Function 00:00 DSum Function - Single Criteria 00:00 DSum Function - Multiple Criteria 00:00 DAverage 00:00 DCount Function 00:00 Subtotal 00:00 Section 4 - Data Validation Data Validation - List 00:00 Data Validation - Decimal 00:00 Input and Error Messages 00:00 Section 5 - Importing and Exporting Importing Data from Text Files 00:00 Importing Data from MS Access 00:00 Exporting Data to a Text File 00:00 Section 6 - Creating Basic Charts Creating Basic Charts 00:00 The Chart Ribbon 00:00 Adding and Modifying Data on a Chart 00:00 Formatting Charts 00:00 Section 7 - Pivot Tables Understanding Pivot Tables 00:00 Creating Pivot Tables 00:00 Pivot Table Calculations 00:00 Grouping Pivot Table Data 00:00 Formatting Pivot Table Data 00:00 Drilling Down into Pivot Table Data 00:00 Creating Pivot Charts 00:00 Filtering Pivot Table Data 00:00 Filtering using the Slicer 00:00 Section 8 - Working with Large Data Grouping Data 00:00 Consolidating Data 00:00 Section 9 - LookUp Functions VLookUp 00:00 HLookUp 00:00 Index and Match 00:00 Section 10 - Advanced Functions FV Function 00:00 PMT Function 00:00 Hyperlinks 00:00 Text to Columns 00:00 Section 11 - Excel Intermediate - Conclusion Excel Intermediate - Conclusion 00:00