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
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
FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter
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.
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
P402 Surveying and sampling strategies for asbestos in buildings is the industry standard qualification for asbestos surveyors. In addition to holding the qualification, asbestos surveyors are required to undertake and provide evidence of annual refresher training.
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.
P404 Air Sampling of Asbestos and MMMF and Requirements for a Certificate of Reoccupation Following Clearance of Asbestos is the industry standard qualification for those whose work involves air sampling and clearance testing, such as asbestos analysts. In addition to holding the qualification, they are required to undertake and provide evidence of annual refresher training. RP404 Refresher is a new course, specifically designed to meet this requirement. RP404 Refresher enables candidates to revise and update their knowledge on air sampling and clearance testing techniques, and to receive a certificate of course completion by passing a written examination, which covers both the theory and practice of air sampling and clearance testing.
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.