3595 Courses delivered On Demand

Description: As the most-used spreadsheet program in the world, learning how to use the Microsoft Excel will give you an edge in your professional career. This Microsoft Excel 2010 complete course is created to help you in learning all the functions and features of this program. Whether you are a beginner, intermediate and advanced level user, this course will help you in learning all the necessary skills, knowledge, and information about the Microsoft Excel. You will learn how to plan and organise your data using the tools in this program. You will know how to use the functions of Microsoft Excel that will help you in finishing your tasks effectively.This course will provide you with the necessary skills, knowledge and information of Microsoft Excel.  Who is the course for? Professionals who want to learn all about Microsoft Excel 2010 program. People who have an interest in knowing all the functions and features of Microsoft Excel. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft Excel 2010 - Beginners, Intermediate, Advanced course is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Accountant Account Assistant Administrative Assistant Administrator Bookkeeper Office Manager Personal Assistant Secretary. Microsoft Excel 2010 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 00:30:00 Module Ten - Formatting Your Data 01:00:00 Module Eleven - Advanced Formatting Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2010 for Beginners 00:00:00 Microsoft Excel 2010 Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 01:00:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 01:00:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working with Functions 01:00:00 Module Seven - Working with Macros 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Applying Advanced Chart Features 01:00:00 Module Ten - Working with PivotTables and PivotCharts 01:00:00 Module Eleven - Using the Automated Analysis Tools Add -In 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2010 Intermediate Level 00:00:00 Microsoft Excel 2010 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with PivotTables and PivotCharts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2010 Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2010 Complete Course - Beginners, Intermediate, Advanced 00:30:00 Final Exam Final Exam- Microsoft Excel 2010 Complete Course - Beginners, Intermediate, Advanced 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview Gain expert internal audit skills by enrolling in the Internal Audit Training Diploma course.Internal audit is a vital part of financial management. This Internal Audit Training Diploma course will provide you with a thorough understanding of internal auditing. It will introduce you to the auditing form and assurance best practices, teaching you a range of internal auditing procedures. It will also teach you about UK internal audit standards as well as how to conduct audit interviews and report on audit outcomes.Kickstart a high earning career in the internal audit sector with the Internal Audit Training Diploma course. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Internal Audit Training Diploma. It is available to all students, of all academic backgrounds. Requirements Our Internal Audit Training Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 8 sections • 8 lectures • 02:54:00 total length •Auditing as a Form of Assurance: 00:11:00 •Internal Audit Procedures: 00:22:00 •Technology-Based Internal Audit: 00:23:00 •Internal Control and Control Risk: 00:36:00 •Audit Interviews: 00:18:00 •Reporting Audit Outcome: 00:23:00 •UK Internal Audit Standards: 00:24:00 •Career as an Auditor: 00:17:00

Overview This comprehensive course on Investment Banking & Valuation will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Investment Banking & Valuation comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Investment Banking & Valuation. It is available to all students, of all academic backgrounds. Requirements Our Investment Banking & Valuation is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more!   Course Curriculum 8 sections • 8 lectures • 02:18:00 total length •Introduction to Investment Banking: 00:16:00 •Structure and Side of Investment Banking: 00:16:00 •Valuation Methods in Investment Banking: 00:29:00 •Leveraged Buyout (LBO): 00:21:00 •Initial Public Offering (IPO): 00:28:00 •Merger and Acquisition: 00:15:00 •Ethics in Investment Banking: 00:13:00 •Assignment - Investment Banking & Valuation: 00:00:00

Course Overview: Data analysis is a hot skill in today's job market. According to a recent study by LinkedIn, demand for data analysts is growing 15 times faster than the average for all occupations. And the salaries are good too. The average salary for a data analyst in the UK is £40,000. If you're looking to get ahead in your career or learn a new skill that's in high demand, then the Data Analysis in Excel Level 3 Course is for you. In this course, you'll learn how to use Excel to analyse data like a pro. You'll learn how to clean, format, and analyse data using various Excel tools and techniques. You'll also learn how to create charts and graphs to visualise your data. This course won't merely make you adept at Excel. It will mould you into a data wizard, wielding Excel as a potent tool to make data sing and secrets reveal themselves. Enrol Today and Start Learning! Key Features of the Course: Embark on your data analysis journey with us and discover these exciting features: A CPD Certificate to validate your newfound skills. 24/7 Learning Assistance for any hour inspiration strikes. Engaging learning materials to ensure an enriching learning experience. Who is This Course For? Our Data Analysis in Excel Level 3 Course caters to ambitious individuals with a basic understanding of Excel, eager to take their skills to new heights. This course welcomes everything from budding data enthusiasts to established business analysts seeking to fortify their analytical toolkits. What You Will Learn: Dive deep into the labyrinth of data as you master essential modules such as 'Search for and Replace Data,' 'Sort and Filter Data,' and 'Query Data with Database Functions.' Venture further into data exploration with our 'Outline and Subtotal Data' module, where you'll learn to summarise your data for a more organised view efficiently. The journey continues with modules like 'Create Charts' and 'Modify and Format Charts,' enabling you to translate complex data into easy-to-understand visuals. Furthermore, our dedicated modules on 'Creating a PivotTable' and 'Analysing PivotTable Data' promise a comprehensive understanding of one of Excel's most powerful tools. Why Enrol in This Course: Rated as a top-reviewed course and constantly updated to keep up with the latest trends, our Data Analysis in Excel Level 3 Course equips you with sought-after skills like data forecasting, creating sparklines, using advanced chart features, and more. Requirements: While no specific prerequisites are required, a basic understanding of Excel and an eagerness to explore the fascinating world of data analysis would be beneficial. Career Path: On completion of this Data Analysis in Excel Level 3 Course course, you'll be ready to step into diverse roles such as: Data Analyst (£30,000-£35,000) Business Intelligence Analyst (£32,000-£37,000) Market Research Analyst (£28,000-£33,000) Operations Analyst (£31,000-£36,000) Financial Analyst (£35,000-£40,000) Supply Chain Analyst (£30,000-£35,000) Sales Analyst (£29,000-£34,000) Certification: Upon successful completion of the course, you'll be awarded a prestigious CPD Certificate, demonstrating your expertise in data analysis using Excel. So, are you ready to discover the hidden stories in data and revolutionise decision-making? Enrol in our Data Analysis in Excel Level 3 Course and start your journey today! Course Curriculum 11 sections • 32 lectures • 04:43:00 total length •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00 •Assignment - Data Analysis in Excel Level 3 Course: 00:00:00

Overview This comprehensive course on Certificate in Know Your Customer & Customer Due Diligence will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Certificate in Know Your Customer & Customer Due Diligence comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Certificate in Know Your Customer & Customer Due Diligence. It is available to all students, of all academic backgrounds. Requirements Our Certificate in Know Your Customer & Customer Due Diligence is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 7 sections • 7 lectures • 02:15:00 total length •Introduction to KYC: 00:31:00 •Customer Due Diligence: 00:21:00 •AML (Anti-Money Laundering): 00:29:00 •KYC, AML, and Data Privacy Regulations for Businesses Operations in the United Kingdom: 00:21:00 •Regulations to be Complied by Industries: 00:20:00 •Methods for carrying out KYC and AML and the Future of KYC Compliance: 00:13:00 •Assignment - Certificate in Know Your Customer & Customer Due Diligence: 2 days

Overview This comprehensive course on Investing in Recession will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Investing in Recession comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Investing in Recession. It is available to all students, of all academic backgrounds. Requirements Our Investing in Recession is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 5 sections • 13 lectures • 00:49:00 total length •Introduction 00:03:00 •What Is Investing? 00:03:00 •Why You Should Invest?: 00:04:00 •How much to Invest?: 00:05:00 •What is Recession & Why Does it Occur?: 00:04:00 •How You Can Benefit from Recession?: 00:02:00 •Secret Assets Part 1: 00:05:00 •Secret Assets Part 2: 00:04:00 •Secret Assets Part 3: 00:05:00 •Secret Assets Part 4: 00:05:00 •Portfolio: 00:03:00 •Right Mindset for Investing in Recession.: 00:06:00 •Assignment - Investing in Recession: 00:00:00

Overview This comprehensive course on Stock Market Investing for Beginners will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Stock Market Investing for Beginners comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Stock Market Investing for Beginners . It is available to all students, of all academic backgrounds. Requirements Our Stock Market Investing for Beginners is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 20 sections • 20 lectures • 02:10:00 total length •Module 01: Introduction to the Course .: 00:01:00 •Module 02: Introduction to Stocks.: 00:04:00 •Module 03: Money Required for Primary Investment.: 00:02:00 •Module 04: Opening an Investment Account.: 00:05:00 •Module 05: Brokerage Account Walkthrough.: 00:13:00 •Module 06: Finding Winning Stocks.: 00:24:00 •Module 07: Earning from Dividends.: 00:06:00 •Module 08: Diversifying Portfolio.: 00:05:00 •Module 09: Investment Plan.: 00:07:00 •Module 10: Rebalancing Portfolio.: 00:05:00 •Module 11: Understanding Order Types.: 00:05:00 •Module 12: Investment Tax.: 00:06:00 •Module 13: Investment Rules: Rule-1: 00:01:00 •Module 14: Investment Rules: Rule-2.: 00:01:00 •Module 15: Investment Rules: Rule-3.: 00:02:00 •Module 16: Investment Rules: Rule-4.: 00:02:00 •Module 17: Investment Rules: Rule-5.: 00:01:00 •Module 18: Stock Market Dictionary.: 00:10:00 •Module 19: Setting Up the Trading Platform.: 00:30:00 •Assignment -Stock Market Investing for Beginners: 00:00:00

Hospitality Management: Hospitality Management Course Online This Hospitality Management: Hospitality Management Course aims to provide practical guidance and specialist knowledge on topics such as housekeeping, catering, front office operations, quality of service, and staff training requirements. This Hospitality Management: Hospitality Management Course is an in-depth training program for new managers and aspiring professionals in the hospitality and tourism industries. This Hospitality Management: Hospitality Management Course will give you a solid understanding of the hospitality industry and its key areas, with a focus on different types of hotels and hospitality roles. This Hospitality Management: Hospitality Management Course will teach you how to manage all hotel operations as well as develop an effective service management program that incorporates safety, security, quality, and cutting-edge technology. By the end of this Hospitality Management: Hospitality Management Course, you will gain all of the necessary skills and knowledge to become a successful Hotel Manager and advance your career in the Hospitality sector. Main Course: Level 5 Hospitality Management Course Free courses included with Hospitality Management: Hospitality Management Course Course 01: Level 4 Time Management Course 02: Level 2 Food Hygiene and Safety for Catering Course 03: Food Allergen Awareness Training Course 04: Level 7 Diploma in Event Management Course 05: Level 3 HACCP Training Course Special Offers of this Hospitality Management: Hospitality Management Course: This Hospitality Management: Hospitality Management Course includes a FREE PDF Certificate. Lifetime access to this Hospitality Management: Hospitality Management Course Instant access to this Hospitality Management: Hospitality Management Course 24/7 Support Available to this Hospitality Management: Hospitality Management Course [ Note: Free PDF certificate will provide as soon as completing the Hospitality Management: Hospitality Management Course] Hospitality Management: Hospitality Management Course Online Course Curriculum of Hospitality Management: Hospitality Management Course Module 01: An Overview of the Hospitality Industry Module 02: Travel and Tourism Module 03: Forces Affecting Growth and Change in the Hospitality Industry Module 05: Understanding the Management of Food and Beverage Operations Module 06: Understanding Accounting in Hospitality Module 07: Restaurant Operations Module 08: Balance Sheet and the P&L Statement Module 09: Budgets Assessment Method of Hospitality Management: Hospitality Management Course After completing Hospitality Management: Hospitality Management Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Hospitality Management: Hospitality Management Course After completing the Hospitality Management: Hospitality Management Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Hospitality Management: Hospitality Management Course Online This Hospitality Management: Hospitality Management Course is ideal for anyone who works in or aspires to work in the hospitality industry, which includes the following professions: - Hospitality Manager, Hotel Manager, Housekeeping Manager, Catering Manager. Requirements Hospitality Management: Hospitality Management Course Online To enrol in this Hospitality Management: Hospitality Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Hospitality Management: Hospitality Management Course. Be energetic and self-motivated to complete our Hospitality Management: Hospitality Management Course. Basic computer Skill is required to complete our Hospitality Management: Hospitality Management Course. If you want to enrol in our Hospitality Management: Hospitality Management Course, you must be at least 15 years old. Career path Hospitality Management: Hospitality Management Course Online Candidates who successfully complete our Hospitality Management: Hospitality Management Course may pursue a wide range of careers, including: Manager of Maintenance Manager of Marketing Manager of Operations Manager of Sales Event Planner

Forex trading basics, including a market overview, types of Forex traders, the advantages and risks of trading Forex, are covered in this course.

Excel Crash Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Excel Crash Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 03 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Analysis of Twitter Dataset and Designing Heatmaps Introduction to the Excel crash course 00:06:00 Understanding the Twitter Dataset 00:05:00 Extracting Other Details for Analysis 00:09:00 Creating Pivot Tables 00:08:00 Applying Conditional Formatting using Color Scales 00:03:00 Adding Slicers to Dashboard 00:02:00 Applying Custom Number Formats 00:03:00 Adding Custom Images to Charts 00:11:00 Interlude - Data Manipulation Challenge 00:02:00 Adding Heatmap Legend 00:02:00 Wrapping Up - Introduction to Open Analytics 00:02:00 Advanced Currency Converter using Dynamic Arrays Introduction to Modern Excel Tables and Dynamic Arrays 00:11:00 Using Power Query for Data Manipulation 00:08:00 Applying Power Query Data Transformations 00:06:00 Structured Table Referencing 00:12:00 XLOOKUP Function and Pivot Table Calculations 00:05:00 Laundry Service Model and Invoicing Dashboard Introduction to the Project 00:01:00 Overview of the Laundry Model Project 00:04:00 Understanding the Inputs 00:03:00 Formatting the Input Tables 00:04:00 Duplicate and Combine Tables with Power Query 00:09:00 Rounding Digits in Power Query 00:02:00 Load Specific Tables from Power Query 00:02:00 Feature Extraction and Named Ranges 00:10:00 Combining Elements - Data Validation with Named Ranges 00:08:00 Combining Elements - Understanding the INDIRECT Function 00:02:00 Combining Elements - Dynamic Drop-down Menu with Data Validation 00:04:00 Combining Elements - INDEX and MATCH with Multiple Criteria 00:12:00 Understanding the MATCH Formula with Multiple Criteria 00:06:00 Business Invoice Dashboard Design 00:06:00