3397 Courses in Coventry delivered Online

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.

🏡 Master Your Household Finances with Household Ledger Course! 📊 Are you ready to take control of your household finances and achieve financial freedom? Introducing our Household Ledger course, a comprehensive text-based program designed to empower you with the skills and knowledge needed to manage your finances effectively. Say goodbye to financial stress and hello to financial empowerment with our easy-to-follow lessons and practical exercises.   🌟 Benefits of Taking the Household Ledger Course: Financial Literacy: Gain a solid understanding of basic financial principles, including budgeting, tracking expenses, and managing debt. Improved Money Management: Learn how to create and maintain a household ledger to track income, expenses, and savings accurately. Debt Reduction: Discover strategies for reducing debt and building a solid financial foundation for you and your family. Budgeting Mastery: Develop effective budgeting techniques to allocate funds wisely, prioritize spending, and achieve your financial goals. Financial Planning: Learn how to set realistic financial goals, create a savings plan, and prepare for unexpected expenses or emergencies. Empowerment and Confidence: Gain the confidence to make informed financial decisions and take control of your financial future. Enhanced Communication: Improve communication with family members about financial matters, fostering teamwork and cooperation in managing household finances.   👨‍👩‍👧‍👦 Who is this for? Individuals and families looking to gain control over their household finances. Those seeking to improve their financial literacy and money management skills. Anyone struggling with debt or financial stress and in need of practical solutions. Couples or families wanting to work together to achieve their financial goals.   🚀 Career Path: While the Household Ledger course primarily focuses on personal finance management, the skills learned can also be valuable in various career paths, including: Financial Planning: Pursue a career as a financial planner or advisor, helping individuals and families create comprehensive financial plans to achieve their goals. Accounting and Bookkeeping: Apply your knowledge of budgeting and ledger management in roles such as accounting clerk, bookkeeper, or financial analyst. Financial Counseling: Become a financial counselor or coach, assisting clients in overcoming financial challenges, managing debt, and achieving financial wellness. Education: Share your expertise by teaching financial literacy courses in schools, community centers, or online platforms, empowering others to take control of their finances. Entrepreneurship: Use your financial management skills to start your own business or consultancy focused on personal finance education and coaching.   🔍 FAQ: Q: Is this course suitable for beginners? A: Yes! The Household Ledger course is designed for individuals with varying levels of financial knowledge, including beginners. Our easy-to-follow lessons and practical exercises make it accessible to everyone. Q: Do I need any special software to take this course? A: No, you do not need any special software. The Household Ledger course utilizes simple and accessible methods for managing household finances, including manual ledger tracking techniques. Q: How long does it take to complete the course? A: The duration of the course depends on your learning pace and schedule. On average, students complete the course in 4-6 weeks, dedicating a few hours per week to study and practice. Q: Will I receive a certificate upon completion of the course? A: Yes, upon successful completion of the Household Ledger course, you will receive a certificate of achievement, showcasing your newfound skills in household finance management. Q: Can I apply the skills learned in this course to manage small business finances? A: While the focus of the course is on household finances, many of the principles and techniques taught can be applied to small business finance management as well. Q: Is there any support available if I have questions or need assistance during the course? A: Yes, our dedicated support team is available to assist you throughout your learning journey. You can reach out via email or through our online platform for prompt assistance.   🌐 Ready to Take Control of Your Finances? Don't let financial stress hold you back from achieving your dreams. Enroll now in the Household Ledger course and embark on a journey to financial empowerment and security. Start building a brighter financial future for you and your loved ones today! 💰🏡✨ Course Curriculum Module 1 Introduction to Household Ledger Management Introduction to Household Ledger Management 00:00 Module 2 Mastering Budgeting and Financial Tracking Mastering Budgeting and Financial Tracking 00:00 Module 3 Frugal Living and Efficient Spending Frugal Living and Efficient Spending 00:00 Module 4 Building an Emergency Fund for Financial Security Building an Emergency Fund for Financial Security 00:00 Module 5 Mastering Debt Management and Achieving Financial Freedom Mastering Debt Management and Achieving Financial Freedom 00:00 Module 6 Introduction to Investing for Financial Growth Introduction to Investing for Financial Growth 00:00 Module 7 Secure Your Future_ Retirement Planning for a Comfortable Retirement Secure Your Future_ Retirement Planning for a Comfortable Retirement 00:00

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

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

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

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

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

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables