3545 Courses

Duration 3.5 Days 21 CPD hours This course is intended for Intermediate Users of Office 365 and Excel Overview Creating Advanced Formulas Analyzing Data with Logical and Lookup Functions Organizing Worksheet Data with Tables Visualizing Data with Charts Analyzing Data with PivotTables, Slicers, and PivotCharts Inserting Graphics Enhancing Workbooks This course builds upon the foundational Microsoft Office Excel 2016, you create advanced workbooks and worksheets using advanced formulas and organizing your data into tables. Excel Intermediate Learn how to navigate Pivot Tables, (for example, Create a Pivot Table/ add data/ Add calculations); Formulas, Data organization (for example, multiple worksheets) Excel Advanced Data Analysis (for example, sparklines) , Macros (making changes to macros) and Building A Fast Dashboard (PivotCharts, slicers, etc.) Office 365 Training Getting More with OneDrive Office 365 Training When is a Team a Team? Includes Using Video with Audio, Exploring Teams/Navigating among Teams etc.

Limited Time Offer: Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Business Administration Now Hi, business enthusiast! When launching a new venture, understanding the fundamentals of Business Administration is crucial to your success. What’s the first thing you need to know? It’s the golden rule for running a thriving business! Embark on your journey to becoming a successful entrepreneur with the Business Administration Level 3 Diploma. This comprehensive course offers an in-depth exploration of Business Administration, providing you with the essential skills and knowledge to excel in various business settings. Enrolling in this Business Administration course is an excellent way to gain a solid foundation in business management and direction. Discover how effective business administration can pave the way for a range of careers with strong growth potential. Whether you're interested in health care management, business management, finance, accounting, or marketing, the skills you acquire will be invaluable in navigating these fields. Our structured bundle includes multiple in-depth courses designed to offer a rich and flexible learning experience. By immersing yourself in this comprehensive Business Administration program, you'll be well-prepared to take on diverse business challenges and make informed decisions. Start your journey today and equip yourself with the expertise needed for a successful career in Business Administration. Along with this Business Administration Bundle, you will get original hardcopy certificates, a transcript and a student ID card. Courses are included in this Bundle: Course 01: Business Administration Level 3 Course 02: Employment Law Level 3 Course 03: Introduction to Accounting Course 04: Level 3 Xero Training Course 05: Business Analysis Level 3 Course 06: GDPR Course 07: Level 3- Project Management Course 08: Customer Relationship Management Course 09:Team Management Course 10: Effective Communication Skills Diploma Course 11: Professional Bookkeeping Course Key Features of the Course FREE Business Administration Level 3 Diploma CPD-accredited certificate Get a free student ID card with Business Administration Level 3 Diploma training (£10 applicable for international delivery) Lifetime access to the Business Administration Level 3 Diploma course materials The Business Administration Level 3 Diploma program comes with 24/7 tutor support Get instant access to this Business Administration Level 3 Diploma course Learn Business Administration Level 3 Diploma training from anywhere in the world The Business Administration Level 3 Diploma training is affordable and simple to understand The Business Administration Level 3 Diploma training is entirely online Learning Outcomes Acquaint yourself on how to represent your boss and company to bring your success to new heights. Earn the skills of an effective administrator to recruit employees, conduct department meetings successfully, and engage with higher management. Strengthen your business writing skills, communication skills and telephone skills. Get the chance to broaden organising skills to schedule meetings and conferences as well as become punctual. Keep track of records and successfully file systems to avoid unnecessary turmoil for your organisation. Demonstrate the capacity to undertake rigorous secondary research on challenges, whether general business or company functions. Demonstrate the ability to apply broad management knowledge in real-world scenarios. Learn how to handle mail services and shipping and travel related arrangements skillfully. Course Curriculum: Course 01: Business Administration Level 3 Representing Your Boss and Company Skills of an Effective Administrator Business Writing Skills Communication Skills Business Telephone Skills Mail Services and Shipping Travel Arrangements Organising Meetings and Conferences Time Management Record Keeping and Filing Systems Effective Planning and Scheduling ---------------Other Courses Are--------------- Course 02: Employment Law Level 3 Course 03: Introduction to Accounting Course 04: Level 3 Xero Training Course 05: Business Analysis Level 3 Course 06: GDPR Course 07: Level 3- Project Management Course 08: Customer Service Management Course 09: Course 10: Effective Communication Skills Diploma Course 11: Professional Bookkeeping Course How will I get my Certificate? After successfully completing the Business Administration course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Business Administration bundle. Requirements This Business Administration course has been designed to be fully compatible with tablets and smartphones. Career path Upon completing this course bundle, you may pursue the following career paths: Business administrator (£20,000 - £30,000 per year) Business analyst (£25,000 - £35,000 per year) Project manager (£30,000 - £40,000 per year) Customer service representative (£20,000 - £25,000 per year) Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Business Administration Level 3) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

The Retail Advisor - Customer Service Excellence and Sales Techniques Course offers a dynamic learning journey tailored for those aiming to master the art of retail management and customer engagement. This course covers essential areas such as retail management, accounting, and visual merchandising, providing a strong foundation for understanding how retail businesses operate efficiently. Delving into the psychology of customers, it equips learners with insights into consumer behaviour to enhance sales strategies and boost customer satisfaction. Complementary modules in business studies and line management ensure learners develop a well-rounded grasp of the retail environment. Alongside core business knowledge, the course addresses career development with focused sessions on CV writing, workplace productivity, and life coaching. These elements prepare participants to navigate career progression confidently within the retail sector. Designed entirely for remote learning, this course fits seamlessly around busy schedules, offering the flexibility to develop expertise without the constraints of location. Whether aiming to refine sales techniques or advance within retail leadership, this programme provides the tools needed to succeed in today’s competitive market. Courses included in this Retail Advisor - Customer Service Excellence and Sales Techniques Bundle: Course 01: Retail Management Course 02: Retail Accountant Course 03: Visual Merchandising Diploma Course 04: Sales: Psychology of Customers Course 05: Business Studies Course 06: Career Development Course 07: CV Writing Course 08: Workplace Productivity Course 09: Line Management Course 10: Life Coaching and Career Counselling Key Benefits Accredited by CPD Instant e-certificate Fully online, interactive Retail Advisor - Customer Service Excellence and Sales Techniques course Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance The Retail Advisor - Customer Service Excellence and Sales Techniques course is for both beginners and those already working in the field. It covers gradually from basics to advanced concepts of being a successful Retail Advisor - Customer Service Excellence and Sales Techniques. Anyone passionate about learning can take this course and develop skills and a portfolio to have a competitive edge in the job market. Also, upon completing our Retail Advisor - Customer Service Excellence and Sales Techniques course, you will get a widely respected accreditation and a deeper knowledge of the topic. Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Certificate Once you've successfully completed your course, you will immediately be sent a digital certificate. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Retail Advisor - Customer Service Excellence and Sales Techniques training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Retail Advisor - Customer Service Excellence and Sales Techniques training.

Duration 4 Days 24 CPD hours This course is intended for Risk professionals Business analysts Project managers Compliance professionals IT professionals Anyone whose work includes evaluating and mitigating risk Overview This boot camp prepares you to pass the ISACA CGEIT exam, which covers four domain areas designed to reflect the work performed by individuals who have a significant management, advisory or assurance role relating to the governance of IT. Domain 1: Governance of enterprise IT Domain 2: IT resources Domain 3: Benefits realization Domain 4: Risk optimization This CGEIT Boot Camp is designed for experienced IT governance personnel and those who have responsibilities for the stewardship of IT resources. You will learn how to effectively implement and manage governance across all areas of technology ? as well as align that technology with strategic enterprise goals. This training also explains the CGEIT examination process and helpsprepare you for your CGEIT exam by providing guidance and testing your exam readiness through sample questions. You?ll leave fully prepared to earn your CGEIT certification. Course Outline Domain 1: Governance of enterprise IT Domain 2: IT resources Domain 3: Benefits realization Domain 4: Risk optimization

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report

What Will I Learn? Communicate well in a professional setting Discuss general business matters in Vietnamese Discuss finance Discuss sales and marketing Discuss accounting Discuss human resource management Discuss production management Requirements Some basic Vietnamese Description This course is intended to help you communicate confidently in Vietnamese in professional environments. With this Vietnamese for Business course, you'll learn everything you need to know for your job in Vietnamese in Vietnam. From advanced vocabulary and language to generally talk about business matters in Vietnamese, this course will help you out all the way. Learn professionally greet and meet with co-workers and clients. Moreover, this course also discusses finance, the stock market, and investing including converse about management and human resources, sales and marketing, general business matters in Vietnam, etc. If you're interested in learning the Vietnamese language for the business purpose, then welcome to join the course and take your skills to an advanced level. In Vietnamese for Business you will learn: 1. How to generally talk about business matters in Vietnamese 2. How to professionally greet and meet with coworkers and clients 3. How to discuss finance, the stock market, and investing 4. How to converse about management and human resources 5. How to talk about sales and marketing 6. How to discuss general business matters 7. Much more Vietnamese language practice This course is for anyone studying the Vietnamese language who has already learned the tones and alphabet and is ready for more advanced vocabulary and language. While it is specifically designed for those working in a professional environment it is also a great supplement for general Vietnamese language learners as the vocabulary, pronunciation, and style are all natural and colloquial. In other words, this is the way that local Vietnamese people use the language every day. It took me ten years to attain the level of fluency that I currently enjoy in the language. I have recently moved back to Vietnam, where I teach Vietnamese to foreigners, Business, and other subjects full time. If you're serious about learning the Vietnamese language, I encourage you to join the course and take your next step toward total fluency! Who is the target audience? People with a basic understanding of Vietnamese who are or intend to communicate in the work related setting with Vietnamese people   Introduction Introduction Vietnamese for Business FREE 00:13:00 Professional Greeting, Finance and Real Estate Professional Greetings 00:13:00 Finance 00:11:00 Real Estate 00:11:00 Commodities, Meetings, Sales & marketing Metals and Commodities 00:08:00 Meetings 00:11:00 Sales & Marketing 00:09:00 Human Resources, Accounting, and Management Human Resources 00:07:00 Accounting 00:03:00 Management 00:05:00 Conclusion Conclusion 00:06:00

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want This course will help you understand the intricacies of logistics, inventory management and procurement strategies. From this course, you will learn the essential skills of cost-reduction, supply chain process optimisation and enhance overall operational efficiency. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Understand tips for effective supply chain management Know the key issues of SCM Understand vendor-managed inventory Learn warehouse management Understand the role of logistics in SCM Know the finished goods supply chain Get to know the significance of SCM Understand demand planning Know the role of IT in SCM Learn global supply chain management Understand reverse logistics Why Supply Chain Management Training Course right for you? This comprehensive course will guide you on the nuances of supply chain management, supply chain network design, demand planning, and the relevance of IT in SCM. You will have a broad understanding of global supply chain management, finished goods supply chain, and vendor-managed inventory. In addition, this course will educate you on warehouse management, factors of warehouse efficiency, and the throughput of the process chain. Apart from that, this interactive course will update you on the critical issues of SCM and the tips for effective SCM. By the end of the course, you will have a deep understanding of supply chain management, supply chain network design, demand planning, and reverse logistics. Xero Accounting and Bookkeeping Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   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. Course Curriculum SCM - Introduction SCM - Introduction Importance of SCM Importance of SCM What is Supply Chain Management What is Supply Chain Management Supply Chain Network Design Supply Chain Network Design What is Demand Planning What is Demand Planning Role of IT in SCM Role of IT in SCM Role of Logistics in SCM Role of Logistics in SCM Global Supply Chain Management Global Supply Chain Management Finished Goods Supply Chain Finished Goods Supply Chain What is Reverse Logistics What is Reverse Logistics Vendor Managed Inventory Vendor Managed Inventory Warehouse Management Warehouse Management Factors of Warehouse Efficiency Factors of Warehouse Efficiency Throughput of Process Chain Throughput of Process Chain Key Issues of SCM Key Issues of SCM Tips for Effective SCM Tips for Effective SCM Who should take this course? This extensive course is suitable for those who want to have an in-depth understanding of supply chain management, logistics, and supply chain network design. It is ideal for those who wish to pursue a career in the field of supply chain management. Entry Requirements There are no academic entry requirements for this supply chain management training course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This supply chain management training 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 can grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. 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. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Why Join Digital Marketing Training Course at Osborne Training Osborne Training is well Recognised for quality Regular Lectures led by Industry Expert Tutors Unlimited Access to the State of the Art Virtual Learning Campus Exclusive Access to High quality study materials Flexible payment option available Join Digital Marketing Training course as Pure Online or Blended with Classroom Delivery Access to Digital Marketing Internship for 3 months at the end of the training Unlimited Tutorial Support from expert tutors Get a Student Discount Card from NUS* Get a Free Tablet PC for limited period* Practical Hands-on Projects, Practical focused Assignments and Group-work for greater skills enhancement and understanding real life issues for real life problems Once you complete the bookkeeping course, you will get a certificate from Osborne Training confirming your professional Digital Marketing Qualifications. What jobs could I qualify for? Senior Digital Marketing Manager Digital Marketing Coordinator Executive Digital Marketing Strategist Digital Marketing Consultant In these roles, you could earn on average more than £40,000 annually (source: Reed Salary Checker, UK). Moreover, many go on to become successful (Millionaire sometime) entrepreneur by offering Digital Marketing services or formulating successful Digital Marketing Strategy for their own business. Digital Marketing Qualifications Digital Marketing Qualifications at Osborne Training are developed in Association with Google. Osborne Training offers Total Digital Marketing Course which combines all major skills required to be a successful Digital Marketeer and you also have option to join a complementary Internship at the end of your course. In joining the Total Digital Marketing Course at Osborne Training, you will make one of the greatest decision of your career and can look forward to a successful career in digital marketing. Digital Marketing Course Overview Total Digital Marketing Course covers major areas of Digital Marketing to make you completely ready for the digital era. The Digital Marketing course comes with optional Internship at the end of the training making you highly employable. Practical focused and hands-on approach of the training method helps you to be ready to offer real life solutions for real life problems. Digital Marketing Training Course Content Basics of marketing Marketing In Digital Era All About Web Search Engine Optimization Search Engine Marketing Affiliate Marketing Social Media Marketing Email marketing and nurturing (inbound) Mobile app marketing Content marketing Web, mobile and app analytics Growth Hacking Creating robust digital marketing strategy