592 Courses

Overview From schools to big corporations, email is used as the formal communication channel. That is why, no matter which sector you want to work for, you must polish your email writing skills. You can take your email writing abilities to the next level with our Email Writing Masterclass course. The course aims to provide you with quality training in email writing. Through this course, you will be introduced to the essentials of writing effective emails. The course will teach you how to choose the right tone and style for your emails. In addition, you will grasp the techniques of managing emails and get effective tips to improve your email writing quality. So, if you want to master the art of email writing. Join now! Course Preview Learning Outcomes Learn the fundamentals of writing an email Understand what tone and writing style to use Know the strategies to manage your emails effectively Grasp useful tips and tricks for writing emails Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Email writing Email management Who Should Take This Email Writing Masterclass Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Email Writing Masterclass course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Email Writing Masterclass Certification After completing and passing the Email Writing Masterclass course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Email Writing Masterclass will equip you with effective skills and abilities and help you explore career paths such as  Business executives Copywriter Customer support executives PA Office admin Module 01: E-Mail Communications E-Mail Communications 00:40:00 Module 02: Fundamentals Of Writing Effective E-Mails Fundamentals of Writing Effective E-mails 00:55:00 Module 03: Manage Your E-Mail Manage Your E-mail 00:42:00 Module 04: Writing Styles And Tone Writing Styles and Tone 00:44:00 Module 05: Additional Tips For Writing Effective E-Mail Additional Tips for Writing Effective E-Mail 00:44:00 Module 06: Exercise Caution Exercise Caution 00:44:00 Assignment Assignment - Email Writing Training 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview Convincing strangers or assisting them over the phone can be a very challenging task. However, we can make this job easy for you with our exclusive Online Telephone Receptionist Course. This course is designed to deliver quality training and prepare you for the responsibilities. The course is divided into 12 informative modules. These modules will teach you the key skills you need to become a proficient telephone receptionist. Here, you will also get to learn how to represent your organisation in the right manner. Furthermore, the course will help you work on your time management and organisational skills. By the end of the course, you will be able to establish effective communication through the telephone.  So, what are you waiting for join today and start learning! Course Preview Learning Outcomes Acquire the core business telephone skills Learn how to properly represent your boss and your organisation Improve your time management and organisation skills Grasp the strategies for effective communication Familiarise yourself with the challenges associated with this role Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Telephone skills Time management Organising Who Should Take this Online Telephone Receptionist Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Online Telephone Receptionist Course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Online Telephone Receptionist Course Certification After completing and passing the Online Telephone Receptionist Course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Online Telephone Receptionist Course will equip you with effective skills and abilities and help you explore career paths such as  Personal Secretary Receptionist Office Admin Module 01: Additional Challenges Additional Challenges 00:07:00 Module 02:Communication (I) Communication (I) 00:07:00 Module 03: Communication (II) Communication (II) 00:08:00 Module 04:Core Skills Required Core Skills Required 00:11:00 Module 05:Organizing and Planning (I) Organizing and Planning (I) 00:07:00 Module 06: Organizing and Planning (II) Organizing and Planning (II) 00:07:00 Module 07: Self-Management (I) Self-Management (I) 00:07:00 Module 08: Self-Management (II) Self-Management (II) 00:07:00 Module 9:Time Management (I) Time Management (I) 00:07:00 Module 10:Time Management (II) Time Management (II) 00:08:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Interior Design Masterclass Overview The Interior Design Masterclass Course teaches you all you need to know about the subject from the foundation up so you may earn a professional certificate at no cost and display your accomplishments in the workplace. This extensive, instructor-led course on interior design mastery is intended to provide you with a thorough understanding of the nature of the relevant industry and your primary tasks within it. You need a certain set of talents to succeed in your line of work in today's cutthroat environment. You will improve your current knowledge and abilities while gaining the most in-demand skills to launch your career in this comprehensive training programme. You may easily advance your profession and learn at your own speed with the help of the online training materials for this course. Learning Outcomes: Master the core principles of space planning, colour theory, and material selection. Craft lighting schemes that enhance functionality and evoke specific moods. Design captivating residential and commercial spaces that meet diverse needs. Develop essential business skills for a successful interior design career. Navigate the digital landscape with industry-standard software proficiency. Why You Should Choose Office Admin, Secretarial and PA Diploma Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Interior Design Masterclass is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Interior Design Masterclass 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Interior Design Masterclass Module 01: Introduction to Interior Design Introduction to Interior Design 00:23:00 Module 02: Space Planning and Layout Space Planning and Layout 00:21:00 Module 03: Colour Theory and Application Colour Theory and Application 00:22:00 Module 04: Materials and Finishes Materials and Finishes 00:21:00 Module 05: Lighting Design Lighting Design 00:19:00 Module 06: Furniture and Furnishings Furniture and Furnishings 00:20:00 Module 07: Sustainable Design Sustainable Design 00:23:00 Module 08: Interior Design for Residential Spaces Interior Design for Residential Spaces 00:20:00 Module 09: Interior Design for Commercial Spaces Interior Design for Commercial Spaces 00:21:00 Module 10: Professional Practice and Business Skills Professional Practice and Business Skills 00:21:00 Module 11: Digital Tools and Software for Interior Design Digital Tools and Software for Interior Design 00:21:00 Module 12: Professional Networking and Industry Engagement Professional Networking and Industry Engagement 00:23:00

***24 Hour Limited Time Flash Sale*** Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality Career Bundle: Course 01: Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality Course 02: Win Customers Efficiently: Customer Service Diploma Course 03: Customer Relationship Management Course 04: Know Your Customer (KYC) Course 05: Diploma In Office Admin And Reception - Level 3 Course 06: Concierge Course 07: Hotel Management with Hotel Receptionist and Hospitality Management Course 08: Hotel & Hospitality Management Course 09: Hotel Management & Administrative Skills Course 10: Customer Service Diploma - CPD Accredited Course 11: Level 3 Diploma in Customer Service Course 12: Customer Service & Environment Course 13: Customer Services Coordinator Course 14: Customer Service Fraud Officer Course 15: Service Helpdesk & Technical Support Course 16: Professional Waiter Diploma Course 17: Hospitality & Catering - Food Safety Course 18: Restaurant Management Course 19: Finance and Cash Management for Hospitality Course 20: Event Planner Course Course 21: Receptionist Skills Course 22: Conflict Resolution Course 23: Business Etiquette and Professional Behavior Course 24: Developing Interpersonal Skills Course Course 25: Decision Making and Critical Thinking Training Course 26: Call Centre Training Course 27: Effective Communication Skills Course 28: Time Management Course 29: Marketing Strategies for Business Course 30: Corporate Risk And Crisis Management With Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in the Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality today and take the first step towards achieving your goals and dreams. Why buy this Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality? Free CPD Accredited Certificate upon completion of Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality Get a free student ID card with Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality Lifetime access to the Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality course materials Get instant access to this Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality course Learn Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality from anywhere in the world 24/7 tutor support with the Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality course. Start your learning journey straightaway with our Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality Training! Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of the Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality course. After passing the Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality course is ideal for: Students seeking mastery in Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality Professionals seeking to enhance Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality skills Individuals looking for a Level 2 Certificate in Understanding Excellence in Customer Service for a Hospitality-related career. Anyone passionate about Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality Requirements This Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality doesn't require prior experience and is suitable for diverse learners. Career path This Level 2 Certificate in Understanding Excellence in Customer Service for Hospitality bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Imagine the vibrant buzz of a five-star lobby, the clinking of glasses in a bustling restaurant, the seamless orchestration of a guest's perfect stay. The UK hospitality industry is booming, with a projected growth of 4.8% by 2025. Are you ready to be part of this exciting world? This comprehensive Hotel Management bundle equips you with the skills and knowledge to excel in various hospitality roles. From welcoming guests with a smile to managing bustling restaurants, this bundle equips you with the skills to thrive in diverse hospitality roles. Master reception operations, hotel management, restaurant service, and customer relations. Develop communication, time management, and digital marketing expertise. Become a confident and versatile hospitality professional, ready to launch your dream career. With a single payment, you will gain access to Hotel Management bundle, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the main course) and 11 PDF certificates for Absolutely free. This Hotel Management: Hotel Receptionist and Hospitality Management Bundle Package includes: Main Course: Diploma in Hotel Receptionist Course at QLS Level 5 10 Premium Additional CPD QS Accredited Courses - Course 01: Diploma in Hotel Manager at QLS Level 5 Course 02: Hotel Management & Administrative Skills Course 03: Restaurant Hospitality and Management Diploma Course 04: Catering Management Course 05: Concierge Course 06: Office Admin and Receptionist Skills Course 07: Customer Relationship Management Course 08: Phone-Based Customer Service Course 09: Time Management Training Course 10: CPA Marketing Fundamentals. Our Hotel Management: Hotel Receptionist and Hospitality Management training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today in this Hotel Management Training and gear up for excellence! Learning Outcomes of Hotel Management: Hotel Receptionist and Hospitality Management Master guest service excellence in hotels and restaurants. Understand hotel operations and management principles. Develop effective communication and customer relationship skills. Apply marketing and administrative best practices in hospitality. Gain expertise in specific areas like catering and concierge services. Enhance your employability with industry-recognized qualifications. Why Choose Us? Get a Free QLS Endorsed Certificate upon completion of this course Get a free student ID card with this Training This course is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Lifetime access to this course materials This course comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Main Course: Diploma in Hotel Receptionist Course at QLS Level 5 Module 01: Introduction to Reception and Receptionist Module 02: An Overview of Hotel Industry Module 03: The Process of Selection and Recruitment in Hospitality Industry Module 04: Management of Front Office Operations Module 05: Business Telephone Skills Module 06: Mail Services and Shipping Module 07: Travel Arrangements Module 08: Time Management Module 09: Record Keeping and Filing Systems Module 10: Communication Skills Module 11: Marketing in Travel and Tourism Business Module 12: Customer Satisfaction Module 13: E-Hospitality and Technology Course 01: Diploma in Hotel Manager at QLS Level 5 Module 01: Introduction to Hospitality Management Module 02: An Overview of Hotel Industry Module 03: The Process of Selection and Recruitment in Hospitality Industry Module 04: The Process of Development and Training in Hospitality Industry Module 05: Management of Front Office Operations Module 06: Management of Housekeeping, Engineering and Security Operations Module 07: Management of Food and Beverage Operations Module 08: Management of Service Quality in Hospitality Industry Module 09: Marketing in Travel and Tourism Business Module 10: Accounting in Hospitality Industry Course 02: Hotel Management & Administrative Skills Module 01: An Overview Of Hotel Reception Module 02: Hotel Reception Standard Procedures Module 03: Customer Service In Hotel Reception Module 04: Communication Skills Required For Hotel Reception Module 05: Telephone Handling In A Hotel Module 06: How To Handle Difficult Hotel Guests Module 07: Administrative Skills As A Hotel Receptionist Module 08: Computer Skills And Programs Module 09: Brand Standards In The Hospitality World Module 10: Being A Team Player: Working With Other Hotel Departments and much more... =========>>>>> And 8 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*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £119) CPD 255 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This bundle is open to everybody. New to Hospitality Career Changers Hotel Staff Aspiring Managers Requirements You will not need any prior background or expertise to enrol in this Hotel Management: Hotel Receptionist and Hospitality Management bundle. . Career path After completing this Hotel Management: Hotel Receptionist and Hospitality Management bundle, you are to start your career or begin the next phase of your career. Hotel receptionist Hotel manager Restaurant manager Catering manager Concierge Hospitality entrepreneur 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. Diploma in Hotel Receptionist Course at QLS Level 5 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Professional Floristry Overview Have you ever dreamt of turning everyday blooms into breathtaking arrangements? The world of floristry offers a creative and fulfilling career path, allowing you to bring beauty and joy to people's lives. This 'Professional Floristry' course is your gateway to blossoming into a skilled florist. This comprehensive program equips you with the knowledge and techniques to flourish in the floral industry. You'll delve into the essential services florists provide, from creating stunning bouquets to crafting elegant wedding arrangements. We'll explore the vast world of flowers and plants, from proper care and handling to selecting the perfect blooms for each occasion. The course then dives into the principles of floral design, teaching you how to translate your creativity into captivating arrangements. By mastering these skills, you'll gain the confidence to create bouquets, corsages, and even stunning basket arrangements. Whether you're drawn to the elegance of wedding floristry or the artistry of funeral tributes, this course equips you for various floral design specialities. We'll also cover the practicalities of entering the floristry industry, from finding the right job to starting your own floral business. This course is ideal for anyone with a passion for flowers and a desire to express themselves creatively. Whether you're a budding entrepreneur or a hobbyist seeking to elevate your skills, 'Professional Floristry' is your path to a blooming career. Learning Outcomes Gain a thorough understanding of the diverse services offered by florists. Master the proper care and handling techniques for various flowers and plants. Develop a repertoire of popular flowers and foliage to use in your designs. Apply the core principles of floral design to create visually stunning arrangements. Learn practical skills for crafting bouquets, corsages, and other floral creations. Why You Should Choose Office Admin, Secretarial and PA Diploma Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Professional Floristry is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Professional Floristry 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Professional Floristry Introduction to Floristry 00:46:00 Services Provided by Florists 00:23:00 Flowers and Plants 01:08:00 Flower Care and Treatment 00:40:00 Choosing Popular Flowers and Fillers 00:41:00 Elements and Principles of Design 00:54:00 How to Make Floral Arrangements 01:04:00 Making Bouquet, Corsage, Fruit Basket & Basket Garden 00:35:00 Wedding Floristry 01:05:00 Making Funeral Flower Arrangements 00:31:00 Beautiful Floral Designs 00:45:00 Getting a Job in the Floristry Industry 00:30:00 Starting Your Own Floristry Business 01:13:00 Bonus Material: Important Images Used in this Course [PDF] 00:00:00

**10 FREE QLS Endorsed Certificates and Included with Lifetime Access** The Level 5 Diploma in Accounting and Finance is designed to provide individuals with a solid foundation in accounting and finance practices. This accredited course offers an in-depth exploration of key concepts such as financial management, accounting principles, and the preparation of financial statements. As a QLS-endorsed programme, it is structured to meet the needs of learners seeking a comprehensive understanding of the theoretical and analytical aspects of the accounting profession, providing them with the knowledge needed to progress within this field. Ideal for those aiming for higher positions in accounting and finance, this course also caters to individuals looking to formalise their qualifications. By studying this diploma, learners will develop essential competencies that can help in various accounting roles. The qualification offers an academic route for career progression, with a focus on equipping students with the necessary tools to succeed in the modern financial landscape. It is suitable for both those new to the profession and those looking to formalise their existing expertise. Accounting and Finance - QLS Endorsed Bundle Includes the following Courses Course 01: Diploma in Accounting and Finance at QLS Level 5 Course 02: Award in Accounting & Bookkeeping at QLS Level 2 Course 03: Award in Business Finance at QLS Level 2 Course 04: Diploma in Financial Reporting at QLS Level 4 Course 05: Certificate in Office Admin and Organisation Skills at QLS Level 3 Course 06: Diploma in Facilities Management at QLS Level 5 Course 07:Diploma in Economics at QLS Level 5 Course 08: Diploma in Business Analysis at QLS Level 5 Course 09: Diploma in Business and Management at QLS Level 5 Course 10: Diploma in Forex Trading at QLS Level 5 Learning Outcomes Master financial reporting principles for strategic decision-making. Analyse and interpret economic factors influencing business dynamics. Develop advanced skills in business analysis and decision support. Acquire proficiency in bookkeeping and essential business finance concepts. Demonstrate expertise in office administration and organisational skills. Navigate the complexities of facilities management with strategic efficiency. Gain insights into economic theories and their practical applications. Excel in business and management with a comprehensive QLS Level 5 diploma. Expand knowledge in forex trading strategies and market dynamics. Cultivate versatile skills for diverse roles in the finance and business sectors. 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 In a realm where every penny counts and every decision reverberates through balance sheets, mastering the art of accounting and finance is not just a skill-it's a strategic advantage. Whether you're a seasoned professional aiming to sharpen your financial acumen or a newcomer eager to dive into the dynamic world of numbers, our bundle is your way to fiscal excellence. Dive into the intricacies of financial reporting, business analysis, and economics, equipping yourself with the skills needed for success in today's dynamic landscape. Explore the realms of accounting, bookkeeping, and business finance, gaining a solid foundation in the fundamentals. Go into the strategic aspects of business and management, honing your decision-making prowess. Elevate your proficiency in office administration and organisation skills, ensuring you're equipped with the versatility demanded by modern workplaces. Navigate the complexities of facilities management and forex trading, emerging with a robust skill set. This comprehensive bundle is designed to empower you with a diverse skill set, making you an invaluable asset in the realms of finance, business, and management. Go on a learning journey with outcomes that include mastering financial reporting, honing business analysis skills, and becoming adept in office administration. Develop expertise in economic principles, strengthen decision-making abilities in business and management, and gain proficiency in forex trading strategies. Enhance organisational skills, dive into the nuances of facilities management, and build a foundation in bookkeeping and business finance. This bundle opens doors to various career paths, ensuring you are well-prepared for the diverse challenges of the professional landscape. If you aspire to excel in financial reporting, business analysis, or office administration, this course is tailored for you. Perfect for individuals aiming for managerial roles or those intrigued by the intricacies of forex trading and facilities management, this bundle caters to diverse career aspirations. Join us on this educational journey and empower yourself for success in the competitive world of finance and business. 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? Recent graduates seeking a strong foundation in finance and business. Aspiring professionals aiming for managerial roles. Individuals looking to advance their careers in accounting and finance. Those intrigued by the strategic aspects of business analysis. Office administrators aspiring to enhance their organisational skills. Professionals interested in the complexities of facilities management. Individuals with a passion for economics and its practical applications. Aspiring forex traders eager to master market dynamics. Career path Financial Analyst Business Development Manager Office Administrator Facilities Manager Economic Researcher Forex Trader 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

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Imagine the lights, the laughter, the unforgettable moments that define every great event-do you see yourself as the architect behind these masterpieces? Whether it's the magic of a perfectly executed wedding, the joy of a child's party, or the elegance of a corporate event, this Event Management course bundle offers you the keys to unlock a world where every detail counts and every celebration is a story waiting to be told. The UK events industry is estimated to be worth over £70 billion a year, and with celebrations big and small happening every day, there's a growing demand for skilled party planners. This comprehensive bundle provides you with everything you need to launch a successful career in party planning. You'll gain the essential skills required to plan and execute exceptional events, from birthdays and graduations to weddings and corporate functions. Learn how to manage budgets, source vendors, create stunning decorations, and ensure your events run smoothly and leave a lasting impression on your guests. Key Features of the Event Management: Party Planner, Wedding and Kids Party Planner Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Event management: Party Planner, Wedding and Kids Party Planner bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Event Management - Party Planner QLS Course 02: Wedding and Event Management QLS Course 03: Kids Party Planner Diploma 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: Party Planner: Start Your Own Party Planning Business Course 02: Restaurant Management Course 03: Catering - Catering Management Course 04: HACCP Training Course 05: Office Admin & Receptionist - Level 7 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 Event Management: Party Planner, Wedding and Kids Party Planner courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes of Event Management Grasp the key elements of planning and executing successful events. Understand the complexities of wedding and party planning. Learn how to specifically plan and manage kids' parties. Acquire skills to start your own party planning business. Gain insights into restaurant and catering management. Learn about HACCP and its importance in food safety. Develop administrative skills for effective office management. Don't miss out on this opportunity to turn your event planning passion into a rewarding career. Enrol today and take the first step towards a fulfilling future filled with creativity, celebration, and satisfied clients! Why Choose Us? Get a 3 Free QLS Endorsed Certificate upon completion of Event Management Get a free student ID card with Event Management Training program (£10 postal charge will be applicable for international delivery) The Event Management is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Event Management course materials The Event Management comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** QLS Course 01: Event Management - Party Planner Module 01: Introduction To Event Management Module 02: Role Of An Event Planner Module 03: Event Classification Module 04: Events And Clients Module 05: Steps To Plan An Event Module 06: Invitation To The Event Module 07: Event Decorations Module 08: Developing An Event Planning Business Module 09: Event Marketing Module 10: Cleaning And Waste Disposal QLS Course 02: Wedding and Event Management Module 01: An Overview Of Wedding Industry Module 02: Profession Of A Wedding Planner Module 03: Wedding Timelines Module 04: Wedding Budgets Module 05: The Vision, Venue, And Theme Determining Module 06: Food And Beverage And The Wedding Cake Module 07: Music, Photography And Floral Décor Module 08: Wedding Attire Module 09: Setting The Stage: Choosing, Equipping And Decorating Venue Module 10: Wedding Day Details Module 11: Post Wedding Activity And Evaluation Module 12: Starting Your Own Wedding Planning Business QLS Course 03: Kids Party Planner Diploma Module 01: Planning a Kids' Party Module 02: Improvement Module 03: Types of Kids' Parties Module 04: Management Review Meetings Module 05: Choosing a Theme Module 06: Planning the Entertainment Module 07: Focusing on Catering Module 08: Making the Day Memorable 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*X = £X) QLS Endorsed Hard Copy Certificate: Free (For The 3 QLS Courses: Previously it was £357) CPD 350 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Aspiring event planners and managers Wedding and party planning professionals Corporate event coordinators and organizers Hospitality and tourism industry professionals Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Event Planner Wedding Planner Party Planner Event Coordinator Catering Manager Hospitality Professional Certificates Advanced Diploma in Event Management at QLS Level 7 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. 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. Diploma in Wedding Planning at QLS Level 5 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Highlights of the Course Course Type: Online Learning Duration: 4 hours 13 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about microsoft excel Understand the core competencies and principles of microsoft excel Explore the various areas of microsoft excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Excel Online Training Course Master the skills you need to propel your career forward in Microsoft excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Microsoft Excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft Excel course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft excel. Enrol in this Microsoft Excel course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft Excel course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Microsoft Excel course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Microsoft Excel course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Microsoft Excel course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the interface 00:03:00 0102 Enter data & saving workbook 00:04:00 0103 Applying Formulas 00:03:00 0104 Changing a worksheet's structure 00:04:00 0105 Find, Replace & Spell Check 00:03:00 0106 Applying fonts, background colors, and borders 00:05:00 0107 Formatting numbers and dates 00:04:00 0108 Making the pieces fit 00:04:00 0109 Inserting headers & footers and Repeating Rows 00:02:00 0110 Managing Large Workbooks 00:05:00 Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) 00:08:00 Ex 0201 Formula Writing (Don't Miss This) 00:02:00 Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs 00:24:00 Ex 0301 SumIf & SumIfs 00:08:00 0302 Count Functions 00:08:00 Ex 0302 Count Functions 00:02:00 0303 AverageIf & AverageIfs 00:03:00 Ex 0303 AverageIf & AverageIfs 00:03:00 Text Functions - Manipulating Text 0401 Change Case (Upper, Lower, Proper) 00:04:00 Ex 0401 Change Case (Upper, Lower, Proper) 00:03:00 0402 Separating Text on Symmetrical Data 00:06:00 Ex 0402 Separating Text on Symmetrical Data 00:06:00 0403 Separating Text on Non-Symmetrical Data 00:08:00 Ex 0403 Separating Text on Non-Symmetrical Data 00:05:00 Logical Functions - Working With Conditions 0501 If Functionality 00:04:00 Ex 0501 IF Functionality 00:03:00 0502 If with AND 00:05:00 Ex 0502 If with AND 00:03:00 0503 If with OR 00:03:00 Ex 0503 If with OR 00:03:00 0504 If with “AND” & “OR” / IF with Countif 00:08:00 Ex 0504 If with “AND” & “OR” / IF with Countif 00:04:00 0505 Nested IF (A Genie with 3 wishes) 00:13:00 Ex 0505 Nested IF (A Genie with 3 wishes) 00:05:00 Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 00:23:00 Ex 0601 Vlookup (Exact Match) # 1 00:04:00 0602 Type of References (Use of $ sign) 00:11:00 0603 Vlookup (Exact Match) # 2 00:04:00 Ex 0603 Vlookup (Exact Match) # 2 00:06:00 0604 Double Vlookup 00:11:00 Ex 0604 Double Vlookup 00:10:00 0605 Vlookup on Duplicate Values 00:10:00 Ex 0605 Vlookup on Duplicate Values 00:05:00 0606 Vlookup (Approximate Match) 00:08:00 Ex 0606 Vlookup (Approximate Match) 00:02:00 0607 Vlookup with If (Conditional Vlookup) 00:05:00 Ex 0607 Vlookup with If (Conditional Vlookup) 00:02:00 0608 Hlookup (Exact Match) 00:03:00 Ex 0608 Hlookup (Exact Match) 00:03:00 0609 Hlookup (Approximate Match) 00:02:00 Ex 0609 Hlookup (Approximate Match) 00:02:00 0610 Lookup (Don't use this !) 00:05:00 Ex 0610 Lookup (Don't use this !) 00:02:00 0611 Vlookup with Match (Create Magical Vlookup) 00:14:00 Ex 0611 Vlookup with Match (Create Magical Vlookup) 00:05:00 0612 Match (Gives us Column/Row Index #) 00:03:00 Ex 0612 Match (Gives us Column/Row Index #) 00:03:00 0613 Index & Match (Made for Each Other) 00:11:00 Ex 0613 (1) Index & Match (Made for Each Other) 00:05:00 Ex 0613 (2) Index & Match (Made for Each Other) 00:03:00 Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 00:02:00 0702 Now, Today & Autofill 00:02:00 0703 DateValue & TimeValue 00:02:00 0704 Calculate WorkingDays 00:03:00 0705 DatedIf 00:05:00 Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:12:00 Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:07:00 0802 Creating a Loan Table 00:09:00 Ex 0802 Creating a Loan Table 00:06:00 0803 Calculate Depriciation 00:02:00 Ex 0803 Calculate Depriciation 00:02:00 Sort & Filter 0901 Basic Sorting & Shortcut keys 00:16:00 Ex 0901 Basic Sorting & Shortcut keys 00:06:00 0902 Sorting Using Custom List 00:08:00 Ex 0902 Sorting Using Custom List 00:02:00 0903 Horizontal Sorting 00:01:00 Ex 0903 Horizontal Sorting 00:01:00 0904 Basic Filter & Shortcut Keys 00:09:00 Ex 0904 Basic Filter & Shortcut Keys 00:05:00 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:06:00 Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:03:00 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:07:00 Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:02:00 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:07:00 Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:01:00 0908 Advanced Filter (Applying Complex Criteria's) 00:13:00 Ex 0908 Advanced Filter (Applying Complex Criteria's) 00:05:00 Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 00:06:00 1002 Format Axis 00:02:00 1003 Plot Values on Secondary Axis 00:04:00 1004 Life of Pie (Charts) 00:03:00 1005 How to Show Axis Title 00:03:00 1006 How to Show Data Label 00:02:00 1007 Show data with chart in Data Table 00:02:00 1008 Column Chart 00:02:00 1009 Bar Chart 00:02:00 1010 Line Chart 1 00:03:00 1011 Line Chart 2 00:03:00 1012 Area Chart 00:01:00 1013 Pie Chart 00:03:00 1014 Pie of Pie or Bar of Pie 00:03:00 1015 Line Chart with Log Scale 00:02:00 1016 Bubble Chart 00:01:00 1017 Selecting Chart Elements 00:05:00 1018 Use of Format Dialog box 00:03:00 1019 Modifying Chart & Plot Area 00:04:00 1020 Modifying Data Series 00:02:00 1021 How to handle Missing Data 00:04:00 1022 Modifying 3-D Charts 00:03:00 1023 Creating Combination of upto 5 Different Charts 00:03:00 1025 Creating Picture Charts 00:02:00 Data Consolidation - Multiple Workbooks Worksheets Consolidate Data using Excel Inbuilt Function 00:06:00 Ex Consolidate Data using Excel Inbuilt Function 00:03:00 Data Validation 1201 Applying Data Validation 00:13:00 Ex 1201 Applying Data Validation 00:05:00 1202 Dependent Dropdown List 00:07:00 Ex1202 Dependent Dropdown List 00:05:00 Using Data Validation with Vlookup & Match 00:05:00 Other Data Validation Examples 00:10:00 Protection of Worksheet Workbook 1301 Worksheet Level Protection 00:01:00 Ex 1301 Worksheet Level Protection 00:01:00 1302 Cell Level Protection 00:05:00 Ex 1302 Cell Level Protection 00:02:00 1303 Hiding Formulas from Formula Bar 00:03:00 Ex 1303 Hiding Formulas from Formula Bar 00:02:00 1304 Protecting Workbook Structure 00:01:00 Ex 1304 Protecting Workbook Structure 00:01:00 1305 Workbook Level Protection 00:02:00 Ex 1305 Workbook Level Protection 00:01:00 Pivot Table & Techniques 1401 Understanding pivot Table 00:12:00 1402 Using Pivot Table in Real Scenario 00:10:00 Ex 1402 Using Pivot Table in Real Scenario 00:09:00 1403 Grouping in Pivot Table 00:04:00 Ex 1403 Grouping in Pivot Table 00:01:00 1404 Using Slicers (A Visually attractive Filter) 00:03:00 Ex 1404 Using Slicers (A Visually attractive Filter) 00:01:00 What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) 00:04:00 Ex 1501 Goal Seek (A Reverse Approach) 00:02:00 1502 One Way Data Table 00:03:00 1503 Two Way Data Table 00:02:00 1504 Scenario Manager 00:04:00 1505 Solver Add-In 00:07:00 Automation in Excel - Macros 1601 Record your first Macro 00:15:00 1602 Record Another Macro 00:02:00 1603 Assigning macro to a Shape, Button, Picture etc 00:02:00 1604 Editing or Deleting a Macro 00:03:00 1605 Security Settings of a Macro 00:02:00 Assessment Assessment - Microsoft Excel 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 4 hours 13 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about microsoft excel Understand the core competencies and principles of microsoft excel Explore the various areas of microsoft excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Excel Online Training Course Master the skills you need to propel your career forward in Microsoft excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Microsoft Excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft Excel course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft excel. Enrol in this Microsoft Excel course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft Excel course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Microsoft Excel course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Microsoft Excel course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Microsoft Excel course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the interface 00:03:00 0102 Enter data & saving workbook 00:04:00 0103 Applying Formulas 00:03:00 0104 Changing a worksheet's structure 00:04:00 0105 Find, Replace & Spell Check 00:03:00 0106 Applying fonts, background colors, and borders 00:05:00 0107 Formatting numbers and dates 00:04:00 0108 Making the pieces fit 00:04:00 0109 Inserting headers & footers and Repeating Rows 00:02:00 0110 Managing Large Workbooks 00:05:00 Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) 00:08:00 Ex 0201 Formula Writing (Don't Miss This) 00:02:00 Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs 00:24:00 Ex 0301 SumIf & SumIfs 00:08:00 0302 Count Functions 00:08:00 Ex 0302 Count Functions 00:02:00 0303 AverageIf & AverageIfs 00:03:00 Ex 0303 AverageIf & AverageIfs 00:03:00 Text Functions - Manipulating Text 0401 Change Case (Upper, Lower, Proper) 00:04:00 Ex 0401 Change Case (Upper, Lower, Proper) 00:03:00 0402 Separating Text on Symmetrical Data 00:06:00 Ex 0402 Separating Text on Symmetrical Data 00:06:00 0403 Separating Text on Non-Symmetrical Data 00:08:00 Ex 0403 Separating Text on Non-Symmetrical Data 00:05:00 Logical Functions - Working With Conditions 0501 If Functionality 00:04:00 Ex 0501 IF Functionality 00:03:00 0502 If with AND 00:05:00 Ex 0502 If with AND 00:03:00 0503 If with OR 00:03:00 Ex 0503 If with OR 00:03:00 0504 If with “AND” & “OR” / IF with Countif 00:08:00 Ex 0504 If with “AND” & “OR” / IF with Countif 00:04:00 0505 Nested IF (A Genie with 3 wishes) 00:13:00 Ex 0505 Nested IF (A Genie with 3 wishes) 00:05:00 Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 00:23:00 Ex 0601 Vlookup (Exact Match) # 1 00:04:00 0602 Type of References (Use of $ sign) 00:11:00 0603 Vlookup (Exact Match) # 2 00:04:00 Ex 0603 Vlookup (Exact Match) # 2 00:06:00 0604 Double Vlookup 00:11:00 Ex 0604 Double Vlookup 00:10:00 0605 Vlookup on Duplicate Values 00:10:00 Ex 0605 Vlookup on Duplicate Values 00:05:00 0606 Vlookup (Approximate Match) 00:08:00 Ex 0606 Vlookup (Approximate Match) 00:02:00 0607 Vlookup with If (Conditional Vlookup) 00:05:00 Ex 0607 Vlookup with If (Conditional Vlookup) 00:02:00 0608 Hlookup (Exact Match) 00:03:00 Ex 0608 Hlookup (Exact Match) 00:03:00 0609 Hlookup (Approximate Match) 00:02:00 Ex 0609 Hlookup (Approximate Match) 00:02:00 0610 Lookup (Don't use this !) 00:05:00 Ex 0610 Lookup (Don't use this !) 00:02:00 0611 Vlookup with Match (Create Magical Vlookup) 00:14:00 Ex 0611 Vlookup with Match (Create Magical Vlookup) 00:05:00 0612 Match (Gives us Column/Row Index #) 00:03:00 Ex 0612 Match (Gives us Column/Row Index #) 00:03:00 0613 Index & Match (Made for Each Other) 00:11:00 Ex 0613 (1) Index & Match (Made for Each Other) 00:05:00 Ex 0613 (2) Index & Match (Made for Each Other) 00:03:00 Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 00:02:00 0702 Now, Today & Autofill 00:02:00 0703 DateValue & TimeValue 00:02:00 0704 Calculate WorkingDays 00:03:00 0705 DatedIf 00:05:00 Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:12:00 Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:07:00 0802 Creating a Loan Table 00:09:00 Ex 0802 Creating a Loan Table 00:06:00 0803 Calculate Depriciation 00:02:00 Ex 0803 Calculate Depriciation 00:02:00 Sort & Filter 0901 Basic Sorting & Shortcut keys 00:16:00 Ex 0901 Basic Sorting & Shortcut keys 00:06:00 0902 Sorting Using Custom List 00:08:00 Ex 0902 Sorting Using Custom List 00:02:00 0903 Horizontal Sorting 00:01:00 Ex 0903 Horizontal Sorting 00:01:00 0904 Basic Filter & Shortcut Keys 00:09:00 Ex 0904 Basic Filter & Shortcut Keys 00:05:00 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:06:00 Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:03:00 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:07:00 Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:02:00 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:07:00 Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:01:00 0908 Advanced Filter (Applying Complex Criteria's) 00:13:00 Ex 0908 Advanced Filter (Applying Complex Criteria's) 00:05:00 Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 00:06:00 1002 Format Axis 00:02:00 1003 Plot Values on Secondary Axis 00:04:00 1004 Life of Pie (Charts) 00:03:00 1005 How to Show Axis Title 00:03:00 1006 How to Show Data Label 00:02:00 1007 Show data with chart in Data Table 00:02:00 1008 Column Chart 00:02:00 1009 Bar Chart 00:02:00 1010 Line Chart 1 00:03:00 1011 Line Chart 2 00:03:00 1012 Area Chart 00:01:00 1013 Pie Chart 00:03:00 1014 Pie of Pie or Bar of Pie 00:03:00 1015 Line Chart with Log Scale 00:02:00 1016 Bubble Chart 00:01:00 1017 Selecting Chart Elements 00:05:00 1018 Use of Format Dialog box 00:03:00 1019 Modifying Chart & Plot Area 00:04:00 1020 Modifying Data Series 00:02:00 1021 How to handle Missing Data 00:04:00 1022 Modifying 3-D Charts 00:03:00 1023 Creating Combination of upto 5 Different Charts 00:03:00 1025 Creating Picture Charts 00:02:00 Data Consolidation - Multiple Workbooks Worksheets Consolidate Data using Excel Inbuilt Function 00:06:00 Ex Consolidate Data using Excel Inbuilt Function 00:03:00 Data Validation 1201 Applying Data Validation 00:13:00 Ex 1201 Applying Data Validation 00:05:00 1202 Dependent Dropdown List 00:07:00 Ex1202 Dependent Dropdown List 00:05:00 Using Data Validation with Vlookup & Match 00:05:00 Other Data Validation Examples 00:10:00 Protection of Worksheet Workbook 1301 Worksheet Level Protection 00:01:00 Ex 1301 Worksheet Level Protection 00:01:00 1302 Cell Level Protection 00:05:00 Ex 1302 Cell Level Protection 00:02:00 1303 Hiding Formulas from Formula Bar 00:03:00 Ex 1303 Hiding Formulas from Formula Bar 00:02:00 1304 Protecting Workbook Structure 00:01:00 Ex 1304 Protecting Workbook Structure 00:01:00 1305 Workbook Level Protection 00:02:00 Ex 1305 Workbook Level Protection 00:01:00 Pivot Table & Techniques 1401 Understanding pivot Table 00:12:00 1402 Using Pivot Table in Real Scenario 00:10:00 Ex 1402 Using Pivot Table in Real Scenario 00:09:00 1403 Grouping in Pivot Table 00:04:00 Ex 1403 Grouping in Pivot Table 00:01:00 1404 Using Slicers (A Visually attractive Filter) 00:03:00 Ex 1404 Using Slicers (A Visually attractive Filter) 00:01:00 What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) 00:04:00 Ex 1501 Goal Seek (A Reverse Approach) 00:02:00 1502 One Way Data Table 00:03:00 1503 Two Way Data Table 00:02:00 1504 Scenario Manager 00:04:00 1505 Solver Add-In 00:07:00 Automation in Excel - Macros 1601 Record your first Macro 00:15:00 1602 Record Another Macro 00:02:00 1603 Assigning macro to a Shape, Button, Picture etc 00:02:00 1604 Editing or Deleting a Macro 00:03:00 1605 Security Settings of a Macro 00:02:00 Supplementary Resources Supplementary Resources - Microsoft Excel Diploma 00:00:00 Assessment Assessment - Microsoft Excel Diploma 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00