178 Courses

Duration 3 Days 18 CPD hours This course is intended for Before taking this course delegates should already be familiar with basic analytics techniques, comfortable with basic data manipulation tools such as spreadsheets and databases and already familiar with at least one programming language Overview This course teaches delegates who are already familiar with analytics techniques and at least one programming language how to effectively use the programming language for three tasks: data manipulation and preparation, statistical analysis and advanced analytics (including predictive modelling and segmentation). Mastery of these techniques will allow delegates to immediately add value in their work place by extracting valuable insight from company data to allow better, data-driven decisions. Outcomes: After completing the course, delegates will be capable of writing production-ready R code to perform advanced analytics tasks enabling their organisations make better, data-driven decisions. Becoming a world class data analytics practitioner requires mastery of the most sophisticated data analytics tools. These programming languages are some of the most powerful and flexible tools in the data analytics toolkit. Topic 1 Intro to our chosen language Topic 2 Basic programming conventions Topic 3 Data structures Topic 4 Accessing data Topic 5 Descriptive statistics Topic 6 Data visualisation Topic 7 Statistical analysis Topic 8 Advanced data manipulation Topic 9 Advanced analytics ? predictive modelling Topic 10 Advanced analytics ? segmentation

Overview Become a master of workplace efficiency with the tools available in Microsoft Office Suite. Whether you want to advance your career or develop your knowledge, skills and productivity in the modern office environment, taking this Complete Microsoft Office: 8 Course Bundle + Practice Templates course is an ideal choice to gain the expertise you need to succeed. This bundle course is designed to help professionals advance their career in IT and guide them through every stage of their IT career, from choosing the right career path to earning qualifications and career advancement strategies. This comprehensive course provides expert-crafted content and interactive resources that will help you to gain professional-level skills and proficiency in Microsoft Office's suite of software. You will also discover a wide range of topics enabling you to master the capabilities of Microsoft Office Suite. Successful completion of the course can lead to a career as a computer support specialist, computer systems analyst, network systems administrator and many more. Highlights of Complete Microsoft Office: 8 Course Bundle + Practice Templates : Be able to create basic spreadsheets and use formulas for tracking expenses. Learn how to use complex formulas and perform data analysis on your organisation's revenue and expense patterns. Successfully take your Excel skills to the ultimate level with advanced charts, graphs, formulas and data analysis. Make impressive presentations for your next business conference or meeting, assignment or project work using animation, audio or video and collaborative tools. Master the art of data management, customer tracking, and buying patterns. Learn how to automate repetitive and time-consuming Excel procedures and operations for highest efficiency. Create eye-catching documents starting from scratch and take advantage of Word's spelling, grammar and translation capabilities. Course design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Online study materials Mock exams Multiple-choice assessment How is the course assessed? To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Will I receive a certificate of completion? Upon successful completion, you will qualify for the UK and internationally-recognised certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15. Why study this course Whether you're an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge. The Complete Microsoft Office: 8 Course Bundle + Practice Templates is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.

Step into the world of efficient data management and analysis with the 'Microsoft Excel Complete Bundle' course. Discover the power of Excel through comprehensive modules designed to transform your understanding of spreadsheets. From basic functions to advanced data analysis techniques, this course is your gateway to mastering Excel like never before. Whether you're a novice eager to grasp the fundamentals or a seasoned user aiming to refine your skills, this course promises to elevate your proficiency in Excel to new heights. Unlock the secrets of data manipulation and visualization as you embark on a journey that blends creativity with precision. Imagine creating complex formulas effortlessly and presenting data insights with clarity and impact. With engaging tutorials and practical exercises, you'll not only learn the tools but also gain the confidence to apply them in real-world scenarios. Excel becomes more than a tool; it becomes your strategic partner in decision-making and problem-solving. Join us and embark on a transformative learning experience that empowers you to excel in Excel. Why buy this Microsoft Excel? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the 'Microsoft Excel Complete Bundle' there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the PDF certificate for £4.99. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Microsoft Excel course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Microsoft Excel does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Microsoft Excel was made by professionals and it is compatible with all PCs, Macs, tablets, and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Microsoft Excel is a great way for you to gain multiple skills from the comfort of your home. Administrative Assistant: £22,000 - £28,000 Annually Financial Analyst: £30,000 - £45,000 Annually Project Manager: £35,000 - £50,000 Annually Data Analyst: £25,000 - £40,000 Annually Accountant: £25,000 - £40,000 Annually Business Consultant: £30,000 - £60,000 Annually    

Microsoft Office 2016 Complete Course Over 80% of UK job listings require proficiency in Microsoft Office. Enhancing your skills in Office 2016 can increase your employability and pave the way for career advancement. Dive into the essentials of Microsoft Office 2016 with our comprehensive course designed for beginners. Whether you're new to Office or looking to refresh your skills, this course offers a deep dive into Word, Excel, PowerPoint, Outlook, and Access.  Structured in five detailed modules, each section of this Microsoft Office course is dedicated to maximising your proficiency in one of these critical Office components. Embark on a journey from the basics to more advanced features, with each module carefully crafted to build your skills step-by-step. Through 30-minute focused lessons and hands-on activities, you'll gain confidence in navigating interfaces, creating compelling documents, analysing data, and much more. Enhance your skillset, boost your productivity, and open doors to new career opportunities with our Microsoft Office 2016 Complete Course for Beginners. Enrol now and take the first step towards mastering Microsoft Office 2016! What Will You Learn? Navigating and customising the interface for each Office application. Creating, formatting, and managing documents in Word. Building spreadsheets, using formulas, and analysing data in Excel. Designing impactful presentations with PowerPoint. Managing emails effectively and organising your schedule in Outlook. Developing and managing databases in Access. Enhancing your productivity with Office 2016's comprehensive tools. Practical skills through guided activities and real-world scenarios. 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.

Description A certificate program in customer service helps students gain entry-level customer service positions by teaching them how to use basic office computer applications, such as word processors, spreadsheets, and email programs. Students also learn how to study the product and give adequate information to customers. They also learn how to analyze basic behavioral patterns of different customer personalities and the right ways to deal with them. Who is the course for? Managers, supervisors and customer service staff, as well as staff in departments, directly deal with customers on daily basis in any kind of job or business. 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 a cost of £39 or in PDF format at a 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 recognised 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 Customer Service Basics course helps students to work as a company's client interaction and conflict-resolution representatives. Together with experience, you will stand high chances of promotion and ultimately gain the title of manager. Customer Service Basics Customer Service and Retention Templates 01:00:00 Customer Service & Retention Checklist 01:00:00 Customer Service Checklist 01:00:00 Mock Exam Mock Exam- Customer Service Basics 00:20:00 Final Exam Final Exam- Customer Service Basics 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview This comprehensive course on XLOOKUP and VLOOKUP will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This XLOOKUP and VLOOKUP 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 XLOOKUP and VLOOKUP. It is available to all students, of all academic backgrounds. Requirements Our XLOOKUP and VLOOKUP 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 2 sections • 20 lectures • 01:52:00 total length •What is XLOOKUP?: 00:01:00 •XLOOKUP Syntax: 00:08:00 •XLOOKUP Rules: 00:05:00 •XLOOKUP NA Error: 00:03:00 •XLOOKUP match_mode: 00:09:00 •XLOOKUP search_mode: 00:06:00 •XLOOKUP Wildcards: 00:11:00 •XLOOKUP Horizontal Lookup: 00:04:00 •XLOOKUP Across Different Spreadsheets: 00:03:00 •XLOOKUP Final Example: 00:07:00 •Introduction: 00:02:00 •What is VLOOKUP?: 00:01:00 •VLOOKUP Syntax: 00:06:00 •VLOOKUP - Range_lookup FALSE: 00:06:00 •VLOOKUP - Range_lookup TRUE: 00:06:00 •VLOOKUP Rules: 00:06:00 •VLOOKUP NA Errors: 00:06:00 •VLOOKUP Wildcards: 00:11:00 •VLOOKUP Insert Function: 00:04:00 •VLOOKUP Across Different Tabs: 00:07:00

AAT Accounting Training Course Fast Track: AAT Level 2 & 3 are the Beginner and Intermediate levels of AAT qualification in Accounting. These two levels are a part of three mandatory qualification levels required to be an AAT Certified Accountant.  AAT Level 2 course covers the foundational areas and is suited for people with limited or no accounts knowledge. It is the first step for aspirants intending to build a successful career in accounting. The course by taking you through basic accounting principles will enable you to work in an entry-level role in the accounting or finance department.  AAT Level 3 is an intermediate or advanced level of AAT accounting qualification. By the end of this course, you'll be competent enough to work in finance, accountancy, or bookkeeping role. Why Take This Course? Build a remarkable reputation: Complete all the three AAT Levels to earn the highly regarded 'MAAT' status. A bright future: With an opportunity to progress to chartered accountancy. Increase your salary: Up-skill yourself and increase your earning potential. Work overseas: AAT qualifications are recognised internationally, giving you the freedom to work abroad. The AAT Level 2 Foundation Certificate in Accounting covers the following areas: Bookkeeping Transactions Bookkeeping Controls Elements of Cost Work Effectively in Finance Using Accounting Software (i.e SAGE) The Level 3 Diploma in Accounting covers the following areas: Advanced Bookkeeping Final Accounts Preparation Indirect Tax Management Accounting: Costing Ethics for Accountants Spreadsheets for Accounting

FREE Level 5 QLS Endorsed Certificate | 11 CPD Courses+11 PDF Certificates| 145 CPD Points | Installment Payment

Overview The Advanced Diploma in Microsoft Excel is the best way for you to gain deep insight and knowledge of this topic. You will learn from industry experts and obtain certificates after completing the course. Enrol now for a limited-time discounted price. Like all the courses of The Teachers Training, this Advanced Diploma in Microsoft Excel is designed with the utmost attention and thorough research. All the topics are broken down into easy to understand bite-sized modules that help our learners to understand each lesson very easily. We don't just provide courses at The Teachers Training; we provide a rich learning experience. After purchasing a course from The Teachers Training, you get complete lifetime access with tutor support.  Our expert instructors are always available to answer all your questions and make your learning experience exquisite. After completing the Advanced Diploma in Microsoft Excel, you will instantly get an e-certificate that will help you get jobs in the relevant field and will enrich your CV. What You Will Learn Get to know about relevant job opportunities. Format data labels, create excel values and build basic formulas in excel. Learn all the functions like SUM(), MIN(), MAX() etc Be able to insert images and shapes and customise icons Change layout views, convert spreadsheets into PDFs and print specific ranges of cells Learn how to group and filter pivot table data Skills You Will Gain Keyboard shortcuts Conditional formatting Flash Fill Filters/ AutoFilter Fast Track your Excel skills 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. Assessment To successfully complete the course you must have to attend the MCQ assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. 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.

Course Overview: About 87% of global consumers use at least one computer or device to access the internet daily. Mastering the essentials of computer and the internet is crucial in today’s digital age. The Learning Computer and Internet Level 2 course provides an in-depth exploration of computer systems, internet functionalities, and software applications, offering you the knowledge to navigate the digital world with ease. This course covers a wide range of computer-related topics, from fundamental operating systems and hardware to advanced concepts like cybersecurity and data protection. With engaging, interactive content, you’ll gain practical skills and insights that enhance your computer proficiency and digital competence. Embark on an enlightening journey through the digital landscape. Enrol in Learning Computer and Internet Level 2 today and elevate your computer skills to thrive in a connected world! Key Features of the Course: FREE Learning Computer and Internet Level 2 CPD-accredited certificate Get a free student ID card with Learning Computer and Internet Level 2 training (£10 applicable for international delivery) Lifetime access to the Learning Computer and Internet Level 2 course materials The Learning Computer and Internet Level 2 program comes with 24/7 tutor support Get instant access to this Learning Computer and Internet Level 2 course Learn Learning Computer and Internet Level 2 training from anywhere in the world The Learning Computer and Internet Level 2 training is affordable and simple to understand The Learning Computer and Internet Level 2 training is entirely online Who is This Course For? This course is designed for individuals seeking to build upon foundational knowledge of computer and the internet. Whether a student, professional, or enthusiast, this course will elevate your proficiency. Learning Outcome Grasp the intricacies of various operating systems and their configurations. Understand the diverse range of applications and their functionalities. Navigate through storage solutions, network components, and software tools. Comprehend the concept of licensing and its implications. Become adept in word processing, spreadsheets, and creating presentations. Learn the terminologies of networking, ensuring smooth connectivity. Safeguard yourself online and understand the fundamentals of digital security. Acquire skills to use browsers, e-mails, and collaborative platforms effectively. Why Enrol in This Course: Enrolling in "Learning Computer and Internet Level 2" is your gateway to a world of opportunities and possibilities. You will develop essential skills in high demand across various industries, making you a valuable asset in the job market. Our course is top-reviewed, recently updated to reflect the latest trends, and aligns with the evolving digital landscape, ensuring you stay ahead in the digital race. Requirements: Enrolling in this Learning Computer and Internet Level 2 course requires a basic understanding of computer usage. No prior technical knowledge is needed, making it accessible to beginners and those looking to refresh their skills. Career Path: Upon completing this Learning Computer and Internet Level 2 course, you'll be well-equipped to pursue various professions in the digital domain. Here are seven course-related professions in the UK, along with their average salaries: IT Support Specialist: £25,000 - £40,000 per year Data Entry Clerk: £18,000 - £25,000 per year Digital Marketing Assistant: £20,000 - £30,000 per year Office Administrator: £18,000 - £25,000 per year Cybersecurity Analyst: £30,000 - £50,000 per year Web Developer: £25,000 - £45,000 per year Database Administrator: £30,000 - £50,000 per year Certification: Upon completing the Learning Computer and Internet Level 2 course, learners will be awarded a CPD certificate, validating their enhanced knowledge of computer and the Internet. Course Curriculum 6 sections • 81 lectures • 22:23:00 total length •What is an Operating System: 00:48:00 •Configuring the Operating System: 00:06:00 •What is an Application: 00:10:00 •Using Control Panel: 00:18:00 •Hardware and Peripherals: 00:07:00 •Storage: 00:12:00 •Connectivity Devices: 00:05:00 •Network Components: 00:09:00 •Software and Concepts: 00:11:00 •Licensing: 00:06:00 •Using Software: 00:07:00 •Software Tools: 00:10:00 •Software: 00:14:00 •Hardware, Devices, and Peripherals: 00:05:00 •Backup and Restore: 00:03:00 •Application Features: 01:21:00 •Working with Word Processing: 00:44:00 •Working with Spreadsheets: 00:49:00 •Making a Presentation: 01:08:00 •Databases: 00:34:00 •Collaboration: 00:03:00 •Course Introduction: 00:02:00 •Web Browsers: 00:46:00 •Networking Terminology: 00:35:00 •E-mail: 00:38:00 •Communicating in the Modern World: 00:14:00 •Protecting Yourself: 00:15:00 •Web Searching: 00:31:00 •Protecting Yourself: 00:31:00 •Identify Components of a Personal Computer IPU: 00:08:00 •Sign In to Windows 8: 00:07:00 •Signing In to Windows 8 and Managing Tiles: 00:08:00 •Navigate the Start Screen: 00:18:00 •Using the Account ID Menu: 00:02:00 •Access and Identify the Charms: 00:03:00 •Viewing the Charms: 00:02:00 •Modern Apps and Common Navigation Features: 00:03:00 •Navigating a Modern App: 00:07:00 •Multitasking with Apps: 00:05:00 •Working with Multiple Apps: 00:05:00 •Navigate the Desktop IPU: 00:07:00 •Navigating The desktop: 00:07:00 •Manage Files and Folders with File Explorer IPU: 00:09:00 •Managing Files and Folders: 00:15:00 •Elements of a Desktop Window: 00:12:00 •Working with the Elements of a Desktop Window: 00:10:00 •Creating and Modifying Files with Wordpad: 00:14:00 •Printing a Document: 00:05:00 •Navigate Internet Explorer 10: 00:08:00 •Navigating Internet Explorer 10: 00:09:00 •Browse the Web: 00:12:00 •Using Internet Explorer and Share: 00:08:00 •Customize the Start Screen: 00:07:00 •Creating Groups on the Start Screen: 00:03:00 •Changing PC Setting: 00:07:00 •Customize the Desktop IPU: 00:09:00 •Personalizing the Desktop: 00:11:00 •Set Privacy Levels and Passwords: 00:05:00 •Changing Your Password: 00:05:00 •Use Windows Defender IPU: 00:05:00 •Changing Windows Defender Settings: 00:06:00 •Store and Share Files with SkyDrive: 00:03:00 •What Makes Windows 10 Different?: 00:14:00 •Primary Feature Overview: 00:14:00 •Navigating and Using Windows 10: 00:36:00 •Course Overview: 00:13:00 •Types of Security Threats: 00:29:00 •Social Engineering: 00:30:00 •Identity Theft: 00:29:00 •Data Classification: 00:28:00 •Types of Classifications: 00:18:00 •Protecting Your Digital Information: 00:45:00 •Password Management: 00:13:00 •Malware: 00:17:00 •Software Detection: 00:28:00 •Security from End-to-End: 00:26:00 •Secure E-mail Use: 00:21:00 •Secure Web Browsing: 00:29:00 •Piracy: 00:16:00 •Security Policies: 00:18:00 •Moving Forward: 00:12:00