Practical Excel training that will turn you into a certified Excel master About course Become a master of Excel Learn how to use the crucial Excel functions and tools. Learn from the experts The course is conducted by an Excel specialist with many years of experience. Test your knowledge In the course, you will find tests and practical tasks to consolidate your knowledge and skills. Do you want to master Excel quickly and efficiently? We offer you a unique opportunity to learn all the features of Excel in just a couple of days. The course is purely practical and will teach you the most useful tools included in the app. Whether you do data modeling, work on databases or analysis and reporting, this practical course will show you how to speed up and improve the quality of your work in each of these areas. Through the course, you will have few knowledge repetitions, practical tasks and tests that will help you remember all the information and put into practice the skills you have learned. The training offers access to the training videos and reference materials for an unlimited period. You’ll learn from our Excel expert with many years of experience in the field who will explain every issue step by step and will teach you how to perform your tasks with confidence. This course is available through a multimedia Kemp Center platform. You will learn from the comfort of your own home and at your own pace. You can always stop, return or return to any topic. On top of everything, after completion of the course, you will receive certificate confirming your skills. Join the Excel course and get the benefits: Learning from a professional instructor24/7 access from any devicePractical exercisesTests, quizzes and recapsCertificate of completionExtra materials and downloadable bonuses100% satisfaction guarantee Your Singing Instructor: Lewis Hardin Excel expert The Excel course is conducted by an MS Excel expert and trainer. He specializes in financial modeling and data analysis. He can’t imagine life without Excel and till now, he created and implemented dozens of business tools based on this program. Participants of his trainings appreciate him for his pragmatic approach, lightness of message, and an offbeat sense of humor. He is able to convey any issue in an accessible and understandable way. Overview of the course: The Excel course program: I. Module 1 – Editing Basic issues Excel applications; navigating in the program; naming; toolbar; formula behavior; special paste; moving and copying without disturbing file consistency; areas; relative and absolute references; keyboard shortcuts. Editing and formatting Fonts; borders; text layout; wrapping; merging; formats (text, number, currency, accounting, dates and times, percentage, scientific, special); conditional formatting; table formatting; width and height, auto-fit. Graphic and special elements Pictures; shapes; icons; 3D models; SmartArt; text boxes; equations; symbols; headings; comments. II. Module 2 – Analysis and modeling Create charts and tables Charts: column (bar); line; area; statistical; pie; doughnut; scatter; bubble; combination charts. Special charts: cascade; funnel; stock; surface; radar; maps; spark lines; PivotCharts. Filters (Slicer and Timeline): PivotTables and Plain Tables. Use formulas Rules for working on formulas. Review and application of formulas. Formulas: financial; temporal; mathematical and statistical; search; database; text; logical; IT; compliance; networking. Working on data (databases) Sort; filter; retrieve and transform data; import and export data; queries and connections; text as columns; instant fill; remove duplicates; data validation; consolidation; what-if analysis; forecast worksheet; outline (grouping and what-if analysis). III. Module 3 – Review, view and print Review and data protection Checking: spelling; thesaurus; workbook statistics. Accessibility settings; smart search; translator; comments and notes; protect worksheet; ink. View, printing and formats View: sheet views; page break preview; page layout and custom views; show grid view; formula bar and headings; zoom; arrange windows; freeze panes; enter macros. Printing: print area; page settings; margin settings; sheet adjustment. File formats and saving. IV. Module 4 – Advanced issues Advanced features Work with other apps Tools and plugins for professionals V. Tests Tests and repetitions of acquired knowledge The acquired knowledge will be consolidated and checked through tests after each training module. Tests improve the acquisition of knowledge and improve the attention and engagement throughout the training. Final test After completing the final test at the end of the Excel course, you will get certified. VI. Tasks Practical tasks and exercises Each participant of the Excel course will practice the acquired skills. In this way, the participant will assimilate skills for longer and adapt them to his/her style of operation. After completing the tasks and receiving feedback from our experts, the new skills will be fully acquired not only on an intellectual level but also on a practical level. VII. Bonus materials for the course Additional materials for use in everyday workAfter logging in, you will receive additional materials for use in everyday work. You will receive: short keyboards; a list of the best Excel plugins and tricks to improve work and many more. Experience Beginner-IntermediateLanguage English, German, French, Polish, Portuguese A letter from your expert instructor: If you want to become an Excel master, don’t waste your time on boring and ineffective training courses that will teach you only the theory. We have a better solution for you: We are pleased to invite you to the most practical course that will teach you how to use Excel in practice. And guess what? You will master all the features of Excel program within just a couple of days.You will learn how to work dynamically and flawlessly. Data analysis, database manipulation, creating statements and reports won’t be a problem for you anymore. You will learn everything in the shortest possible time and you’ll master the use of the most important and useful functions. You will work on sheets taken from the real life and perform activities independently. In this way you will acquire the ability to use the program at an expert level.Join us today! Learn with us and surprise everyone with your knowledge of Excel! Learning Excel with us is so interesting and never boring. Learn from the best and become one of themLewis HardinExcel course expert
FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter
Enhance your expertise with our comprehensive bundle of 8 courses: Airport Management, Import/Export & Cross-Cultural Awareness. This power-packed collection offers a unique blend of theoretical knowledge and practical insights, ensuring you acquire the skills necessary to excel in today's dynamic business world. What sets this bundle apart is the inclusion of 3 QLS-endorsed courses, providing you with tangible hardcopy certificates to showcase your achievements. Additionally, we offer 5 CPD QS accredited courses that are highly relevant and designed to bolster your professional capabilities. Immerse yourself in the fascinating realm of Airport Management, where you'll delve into the intricacies of aviation operations, security protocols, and customer service excellence. Gain an in-depth understanding of Import/Export processes, enabling you to navigate international trade with confidence. Develop cross-cultural awareness, honing your ability to effectively communicate and collaborate across diverse global markets. Key Features of the Airport Management, Import/Export & Cross-Cultural Awareness Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Airport Management, Import/Export & Cross-Cultural Awareness bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Airport Management QLS Course 02: Import/Export QLS Course 03: Cross-Cultural Awareness Training 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: Logistic Management Course 02: Supply Chain Management Course 03: Operations Management Course 04: Transport Manager Course 05: Warehouse Management Diploma 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 Airport Management, Import/Export & Cross-Cultural Awareness courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: By completing this bundle, you will: Acquire comprehensive knowledge of airport management principles and practices. Understand the intricacies of import/export procedures and compliance requirements. Develop cross-cultural awareness and communication skills essential for global business. Master logistics and supply chain management strategies to optimize efficiency. Gain expertise in operations management, ensuring streamlined processes. Become a competent transport manager, proficient in logistics coordination. Learn effective warehouse management techniques for optimal inventory control. Discover the ultimate bundle of Airport Management, Import/Export & Cross-Cultural Awareness courses that will elevate your professional standing in the dynamic business landscape. Immerse yourself in a world of aviation, international trade, and cross-cultural communication as you unlock the secrets to success. This comprehensive collection includes 3 QLS-endorsed courses that provide you with prestigious hardcopy certificates, validating your expertise. Additionally, 5 CPD QS accredited courses offer relevant insights and skills necessary to excel in various aspects of business operations. CPD 270 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Professionals seeking to enhance their knowledge and expertise in airport management. Individuals involved in import/export activities or aspiring to pursue a career in international trade. Business professionals engaging in cross-cultural communication and collaboration. Logistics and supply chain practitioners looking to optimize efficiency and streamline operations. Career path Airport Operations Manager: £35,000 - £60,000 per year. Import/Export Specialist: £28,000 - £45,000 per year. International Business Consultant: £40,000 - £70,000 per year. Logistics Manager: £30,000 - £55,000 per year. Supply Chain Analyst: £25,000 - £45,000 per year. Warehouse Operations Supervisor: £22,000 - £40,000 per year. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included
Our Team Leader Programme is designed specifically for new & existing Team Leads & Managers in Healthcare, such as General Practice, Primary & Secondary Care. This programme gives delegates the opportunity to spend time with peers, gain new tools & techniques that enable them to develop & support their team effectively. Building confidence to be able to have more proactive & challenging conversations with team members, supporting managers and reducing escalation.
A 5-day intensive, practical course covering model-making skills for theatre, film, animation or spatial design. Led by David Neat from his studio in Deptford.
This qualification is ideal for those already working, or preparing to work within industry wishing to become a First Aider in the workplace for the purposes of the Health and Safety (First Aid) Regulations 1981 and the Health and Safety (First Aid) Regulations (Northern Ireland) 1982. Topics covered include: the roles and responsibilities of the First Aider, CPR, Using a defibrillator, assessing an incident, recognising signs and symptoms of injury and illness, assisting a casualty who is suffering from major injury and illness, chest injuries, spinal injuries and anaphylaxis. How long will it take me to achieve this qualification? This is a 3 credit qualification, with a guided learning hour’s value of 24 and it has a minimum contact time of 18 hours, which is typically delivered via a 3 day course. For those retraining, the course time can be reduced to 2 days. How is the qualification assessed? Learners must undertake a practical assessment of their competence along with a short open response knowledge assessment, where learners are required to provide a short response to a prescribed series of questions. What next? In line with guidance provided by the HSE, the qualification supports/approves work place first aiders for a period of 3 years, after which point learners will need to retake the course. In addition to this, it is also recommended that learners refresh their knowledge annually. Cost – £179.00 per delegate. (including refreshments, certificates and workbooks) Get in touch via the contact us page for up and coming dates. Why not use your place of work and let us take the burden of travelling away from you.
P400 - Asbestos Surveying and Analysis is a one day foundation level course, which provides candidates with the fundamental knowledge to start a career in the asbestos surveying and analysis professions, and as a progression route to the asbestos Proficiency qualifications. It gives candidates an introductory level of knowledge on the health risks of asbestos fibres, and how to manage asbestos-containing materials in their work. Candidates for this course are not expected to have prior knowledge and experience but having an awareness of the contents of both HSG248 Asbestos: The analysts' guide (July 2021) and HSG264 Asbestos: the survey guide January 2010), would be advantageous.
P405 Managing Asbestos in Buildings is the industry standard qualification for those whose work involves asbestos management, such as duty holders and building managers. In addition to holding the qualification, they are required to undertake and provide evidence of annual refresher training. RP405 Refresher is a new course, specifically designed to meet this requirement. RP405 Refresher enables candidates to revise and update their knowledge on good asbestos management practices, and to receive a certificate of course completion by passing a written examination, which covers both the theory and practice of managing asbestos in buildings.
The main subject areas of the course are: the properties of asbestos and health effects of exposure to asbestos fibres an introduction to regulatory requirements types of asbestos and its uses in buildings types of asbestos surveys the asbestos register, risk assessment and management plan asbestos remediation
The Wine and Spirit Education Trust (WSET) Level 1 Award in Wines is an ideal starting point for any wine enthusiast who: is considering embarking on a professional career in the drinks industry would like to improve their knowledge of wine through more structured training, and be awarded a certificate to prove they know their stuff It is an enjoyable, relaxed and interactive course designed to introduce participants, in a structured way, to wine styles, storing and serving of wine, and food and wine matching. No prior experience of wine tasting is necessary. There is a short multiple-choice assessment at the end of the day to ensure you have met all the criteria, and can be awarded the certificate. The WSET Level 1 Award in Wines has full accreditation from OfQual as part of the UK Qualifications & Credits Framework as a Level 1 Vocational Qualification. The Fee includes: All WSET course materials Professional WSET tuition by WSET Certified tutor Wine samples to taste during the day. We teach you the WSET Level 1 Systematic Approach to Tasting Wine (SAT) ® which will enable you to analyse wines objectively and consistently registration with WSET, all examination fees, and an internationally-recognised certificate upon successful completion Tea & coffee breaks VAT at 20% Funding Funding for this course is available: DEVELOP is the educational programme of The Drinks Trust, the drinks and hospitality industry charity. DEVELOP offers fully funded training and skills courses, delivered by industry-leading providers for people already working, or with an ambition to work, in the drinks and hospitality industry. Manchester Wine School has partnered with The Drinks Trust to bring courses free of charge to eligible students. All of the WSET courses are available for funding with DEVELOP. To learn more please visit the Drinks Trust website HERE Criteria of eligibility for DEVELOP funding: must be 18 or over, eligible to work in the UK, have a National Insurance Number, and be earning less than £26k/pa