4287 Courses delivered Online

Overview Do you face struggle when you open a Power Query seeing the number of things to do then and cannot make good use of your time? Then this Microsoft Excel: Master Power Query in 120 Minutes! Course is just what you need.to break free of your worries. Power Query is a business intelligence tool available in Excel that allows you to import data from many sources and then clean, transform and reshape your data as needed. The course is designed for learners opting to learn Power Query, a feature available in Excel. Power query is a data connection technology that enables you to connect combine refine and discover data from various sources to meet analysis needs.  The course will introduce you to the basic features of Power query and then show how to trim and transform Data in Excel Power Query, Format Dates and Values in Excel Power Query. You will also learn how to extract data from folders and doing auto clean up on Excel Power Query. You will also learn to merge and shape data according to analysis requirements and prepare models by tools such as power pivot. Learning Outcomes: Acquire proficiency in using Excel Power Query for efficient data management. Master the art of transforming raw data into actionable insights. Learn advanced techniques for data manipulation and analysis. Develop the ability to streamline complex data processes. Enhance your analytical thinking and problem-solving skills. 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 certification 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 Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career paths Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £50,000 Per Annum Financial Analyst: £28,000 - £45,000 Per Annum Marketing Analyst: £24,000 - £40,000 Per Annum Operations Analyst: £26,000 - £42,000 Per Annum Management Consultant: £35,000 - £55,000 Per Annum Course Curriculum Microsoft Excel: Master Power Query in 120 Minutes! Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Excel Power Query - Query Editor Ribbon 00:09:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Transform Data - Split Text Fields in Excel Power Query 00:10:00 Transform Data - Group By in Excel Power Query 00:03:00 Transform Data - Unpivoting Columns in Excel Power Query 00:05:00 Transform Data - Pivoting Columns in Excel Power Query 00:02:00 Transform Data - Split Columns into Other Columns in Excel Power Query 00:04:00 Transform Data - Filtering Rows in Excel Power Query 00:05:00 Transform Data - Sorting Columns in Excel Power Query 00:02:00 Transform Data - Transform and Add Columns in Excel Power Query 00:07:00 From Folder - Import From Folder in Excel Power Query 00:07:00 From Folder - Doing Auto Cleanup in Excel Power Query 00:13:00 From Folder - Extract Data from Forms in Excel Power Query 00:13:00 From Workbook - Extract Multiple Criteria in Excel Power Query 00:05:00 From Workbook - Extract Multiple Worksheets in Excel Power Query 00:04:00 Joins - Intro to Joins 00:04:00 Joins - Merging 00:08:00 Joins - Full Outer Join 00:06:00 Joins - Right Anti Join 00:09:00 Power Query - Convert Reports into Pivot Tables 00:05:00 Modulo 00:06:00

Delve into the dynamic digital era with our 'Online Multi-Business Master Plan' course, an educational odyssey designed for the ambitious entrepreneur. Visualize navigating the bustling world of online business, equipped with the knowledge and strategies to manage multiple ventures successfully. Your expedition commences with a foundational introduction, offering a panoramic view of various online business models. This sets the groundwork for understanding the diverse landscapes of the digital marketplace. As you progress, the course unveils the secrets to creating and optimising your multi-business website, a digital hub where your entrepreneurial dreams take shape. Advance further, and the course transitions into practical realms, guiding you on initiating your multi-business journey. You'll then be adeptly steered through innovative techniques for promoting your online enterprises, turning concepts into tangible success. The comprehensive nature of this course culminates with a deep dive into the Complete Online Multi-Business Master Plan, a blueprint for holistic digital business management. Alongside this, you'll gain familiarity with essential tools necessary for efficient and effective online operations, ensuring your ventures not only launch but also thrive in the competitive online arena. Learning Outcomes Gain insights into various online business models. Develop skills for creating and managing a multi-business website. Understand the initial steps for starting online businesses. Learn effective strategies for promoting online ventures. Familiarise with essential digital tools for business management. Why choose this Online Multi-Business Master Plan course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Online Multi-Business Master Plan course for? Aspiring digital entrepreneurs exploring multiple ventures. Existing business owners aiming to expand online. Digital marketing professionals enhancing their skills. Individuals interested in diversifying their income streams. E-commerce managers seeking multi-business management strategies. Career path Digital Entrepreneur - £30,000 to £60,000 Online Business Manager - £28,000 to £50,000 E-commerce Specialist - £26,000 to £45,000 Digital Marketing Consultant - £25,000 to £40,000 Web Development Manager - £32,000 to £55,000 SEO and Analytics Expert - £27,000 to £42,000 Prerequisites This Online Multi-Business Master Plan does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Online Multi-Business Master Plan was made by professionals and it is compatible with all PC's, Mac's, 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. Certification After studying the course materials, there will be a written assignment test which you can take 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. Course Curriculum Introduction Introduction to The Online Multi-Business Master Plan Course 00:03:00 Aims of this course 00:06:00 Course Structure 00:02:00 Online Business Models Online Business Models Overview 00:01:00 Business Models- Udemy 00:04:00 Business Models- Fiverr 00:04:00 Business Models- Amazon KDP 00:04:00 Business Models- Createspace 00:04:00 Business Models- Other Platforms 00:05:00 Your Multi-Business Website Your Multi-Business Website 00:04:00 Getting Started Create, Re-purpose, Repeat 00:04:00 Pick a Niche 00:12:00 Google Keyword Planner Overview 00:02:00 Pick a Platform 00:09:00 Plan, Plan & Test 00:05:00 Earn Your First Dollar 00:06:00 What if you fail- 00:02:00 Build your Systems 00:07:00 Automate and Outsource 00:03:00 Re-purpose and Repeat 00:08:00 Putting it all together 00:04:00 Promoting Your Multi-Business Promoting Your Multi-Business 00:06:00 The Complete Online Multi-Business Master Plan The Complete Online Multi-Business Master Plan 00:11:00 Essential Tools Paypal Overview 00:01:00 Fiverr Overview 00:03:00 MailChimp Overview 00:03:00 Conclusion Finally 00:02:00

Data Structure Level 5 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 Data Structure Level 5 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 9 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 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 A 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. Unit 01: Introduction Module 01: Promo Video 00:02:00 Module 02: Data Structure Introduction 00:05:00 Module 03: Computational Complexity Analysis 00:13:00 Unit 02: Arrays Module 01: Static and Dynamic Arrays 00:12:00 Module 02: Dynamic Arrays Source Code 00:07:00 Unit 03: Liked List Module 01: Singly and Doubly Linked Lists 00:15:00 Module 02: Doubly Linked Lists Source Code 00:10:00 Unit 04: Stack Module 01: Stack 00:12:00 Module 02: Stack Implementation 00:04:00 Module 03: Stack Source Code 00:04:00 Unit 05: Queues Module 01: Queues (Part-1) 00:06:00 Module 02: Queues (Part-2) 00:06:00 Module 03: Queue Source Code 00:04:00 Unit 06: Priority Queues (PQs) Module 01: Priority Queues (PQs) with an interlude on heaps 00:13:00 Module 02: Turning Min PQ into Max PQ 00:06:00 Module 03: Adding Elements to Binary Heap 00:10:00 Module 04: Removing Elements from Binary Heap 00:14:00 Module 05: Priority Queue Binary Heap Source Code 00:16:00 Unit 07: Union Find Module 01: Disjoint Set 00:06:00 Module 02: Kruskal's Algorithm 00:06:00 Module 03: Union and Find Operations 00:11:00 Module 04: Path Compression Union Find 00:07:00 Module 05: Union Find Source Code 00:08:00 Unit 08: Binary Search Trees Module 01: Binary Trees and Binary Search Trees (BST) 00:13:00 Module 02: Inserting Element into a Binary Search Tree (BST) 00:06:00 Module 03: Removing Element from a Binary Search Tree (BST) 00:14:00 Module 04: Tree Traversals 00:12:00 Module 05: Binary Search Source Code 00:13:00 Unit 09: Fenwick Tree Module 01: Fenwick Tree Construction 00:06:00 Module 02: Point Updates 00:05:00 Module 03: Binary Indexed Tree 00:14:00 Module 04: Fenwick Tree Source Code 00:06:00 Unit 10: Hash Tables Module 01: Hash Table 00:17:00 Module 02: Separate Chaining 00:08:00 Module 03: Separate Chaining Source Code 00:12:00 Module 04: Open Addressing 00:11:00 Module 05: Linear Probing 00:14:00 Module 06: Quadratic Probing 00:09:00 Module 07: Double Hashing 00:15:00 Module 08: Removing Element Open Addressing 00:08:00 Module 09: Open Addressing Code 00:15:00 Unit 11: Suffix Array Module 01: Introduction 00:03:00 Module 02: The Longest Common Prefix (LCP) Array 00:03:00 Module 03: Using SA/LCP Array to Find Unique Substrings 00:05:00 Module 04: Longest Common Substring (LCS) 00:11:00 Module 05: Longest Common Substring (LCS) Full Example 00:07:00 Module 06: Longest Repeated Substring (LRS) 00:05:00 Unit 12: AVL Trees Module 01: Balanced Binary Search Trees (BBSTs) 00:09:00 Module 02: Inserting Elements into an AVL Tree 00:10:00 Module 03: Removing an AVL Tree 00:09:00 Module 04: AVL Tree Source Code 00:17:00 Unit 13: Indexed Priority Queue Module 01: Indexed Priority Queue (Part-1) 00:25:00 Module 02: Indexed Priority Queue Source Code 00:09:00 Unit 14: Sparse Tables Module 01: Sparse Table 00:26:00 Module 02: Sparse Table Source Code 00:07:00

Duration 5 Days 30 CPD hours This course is intended for This introductory-level Python course is geared for experienced users who want to use Python in web development projects, or system administrators and web site administrators who want to use Python to support their server installations, as well as anyone else who wants to automate or simplify common tasks with the use of Python scripts. Basic familiarity with any programming or scripting language would be helpful, along with a working, user-level knowledge of Unix/Linux, Mac, or Windows. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Throughout the hands-on course students, will learn to write essential Python scripts using the most current and efficient skills and techniques. Working in a hands-on learning environment, guided by our expert team, attendees will learn to: Create working Python scripts following best practices Use python data types appropriately Read and write files with both text and binary data Search and replace text with regular expressions Get familiar with the standard library and its work-saving modules Use lesser known but powerful Python data types Create 'real-world', professional Python applications Work with dates, times, and calendars Know when to use collections such as lists, dictionaries, and sets Understand Pythonic features such as comprehensions and iterators Write robust code using exception handling Mastering Python Programming is an introductory and beyond-level practical, hands-on Python training course that leads the student from the basics of writing and running Python scripts to more advanced features such as file operations, regular expressions, working with binary data, and using the extensive functionality of Python modules. Extra emphasis is placed on features unique to Python, such as tuples, array slices, and output formatting. This comprehensive, practical course provides an in-depth exploration of working with the programming language, not an academic overview of syntax and grammar. Students will immediately be able to use Python to complete tasks in the real world. An overview of Python What is python? Python Timeline Advantages/Disadvantages of Python Getting help with pydoc The Python Environment Starting Python Using the interpreter Running a Python script Python scripts on Unix/Windows Editors and IDEs Getting Started Using variables Builtin functions Strings Numbers Converting among types Writing to the screen Command line parameters Flow Control About flow control White space Conditional expressions Relational and Boolean operators While loops Alternate loop exits Array types About array types (AKA sequences) Lists and list methods Tuples Indexing and slicing Iterating through a sequence Nested sequences Sequence functions, keywords, and operators List comprehensions Generator Expressions Working with files File overview Opening a text file Reading a text file Writing to a text file Reading and writing raw (binary) data Converting binary data with struct Dictionaries and Sets About dictionaries Creating dictionaries Iterating through a dictionary About sets Creating sets Working with sets Functions Defining functions Parameters Global and local scope Nested functions Returning values Sorting The sorted() function Alternate keys Lambda functions Sorting collections Using operator.itemgetter() Reverse sorting Errors and Exception Handling Syntax errors Exceptions Using try/catch/else/finally Handling multiple exceptions Ignoring exceptions Modules and Packages The import statement Module search path Creating Modules Using packages Function and Module aliases An Introduction to Python Classes About o-o programming Defining classes Constructors Methods Instance data Properties Class methods and data Regular Expressions RE syntax overview RE Objects Searching and matching Compilation flags Groups and special groups Replacing text Splitting strings Using the Standard Library The sys module Launching external programs Math functions Random numbers Reading CSV data Dates and Times Working with dates and times Translating timestamps Parsing dates from text Formatting dates Calendar data Working with the File System Paths, directories, and filenames Checking for existence Permissions and other file attributes Walking directory trees Creating filters with fileinput Using shutil for file operations Advanced Data Handling Defaultdict and Counter Prettyprinting data structures Compressed archives (zip, gzip, tar, etc.) Persistent data Network Programming Using requests Grabbing web content Sending email Using SSH for remote access Using FTP Writing real-life applications Reading input files a la Unix Parsing command-line options Detecting the current platform Implementing logging Additional course details: Nexus Humans Mastering Python Programming (TTPS4820) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Mastering Python Programming (TTPS4820) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Build a strong foundation in Mathematics with our beginner's course. Develop essential numerical skills and problem-solving techniques for professional growth.

Let's learn the basic concepts for developing chatbots with machine learning models. This compact course will help you learn to use the power of Python to evaluate your chatbot datasets based on conversational notes, online resources, and websites. Garner hands-on practice in text generation with Python for chatbot development.

Description: The 70-414 - Implementing an Advanced Server Infrastructure (MCSE) course will prepare you for the Exam 70-414: Implementing an Advanced Server Infrastructure. The course covers the advanced topics that IT professionals encounter in the enterprise environment. For passing the exam, you should have a thorough understanding of a fundamental server infra¬structure including monitoring, virtualisation, and high availability. There are four main objective areas on the 70-414 Exam which are discussed in the course thoroughly: Manage and maintain a server infrastructure Plan and implement a highly available enterprise infrastructure Plan and implement a server virtualisation infrastructure Design and implement identity and access solutions In the course, you will learn how to create the virtual infrastructure, plan and deploy virtual machines and implement solutions for the virtual administration. You will also learn about monitoring, high availability, updates, PKI, BCP and IDA. In short, the course will prepare you for the exam. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? 70-414 - Implementing an Advanced Server Infrastructure (MCSE) training course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our 70-414 - Implementing an Advanced Server Infrastructure (MCSE) course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Creating the Virtualization Infrastructure Introducing Microsoft System Center 2012 Components FREE 00:23:00 Using System Center for Virtualization 00:18:00 Using the VMM Management Console 00:08:00 Planning a VMM Deployment 00:14:00 Creating the Virtualization Host 00:13:00 Configuring Host Groups 00:04:00 Working with Libraries 00:10:00 Storage Infrastructure 00:22:00 Configuring a Storage Infrastructure for Virtualization 00:04:00 Confituring Storage in VMM 00:06:00 Network Infrastructure for Virtualization 00:22:00 Configuring Virtual Networking 00:06:00 Configuring Virtual Networks in VMM 00:06:00 Planning and Deploying Virtual Machines Considerations for Virtual Machine Setup 00:34:00 Planning Virtual Machine Deployment with VMM 00:13:00 How to Deploy a Virtual Machine 00:23:00 Monitoring Monitoring in Windows Server 2012 00:20:00 Enabling and Viewing Resource Metering Data C3TAD1 00:07:00 Introduction to Operations Manager 00:18:00 Management Packs 00:23:00 Notifications and Reporting 00:08:00 Integration with VMM 00:12:00 Solution for the Virtualization Administration System Center 2012 Administration 00:34:00 Delegated Administration 00:03:00 Automation with System Center 2012 00:10:00 VMM Private Clouds 00:06:00 High Availability Storage Spaces 00:48:00 RAID 00:08:00 NLB 00:22:00 The Infrastructure for Failover Clustering 00:21:00 Defining Failover Clustering 00:25:00 Integrating Failover Clustering with Server Virtualization 00:26:00 Multisite Planning a Multisite Failover Cluster 00:13:00 PKI The Certificate Authority 00:30:00 Certificate Templates 00:22:00 Overview of Certificate Services 00:11:00 CRL 00:13:00 Key Archival 00:07:00 Updates WSUS Deployment 00:25:00 WSUS 00:05:00 Using Configuration Manager 2012 00:17:00 Updating Virtualization 00:10:00 BCP BCP 00:25:00 Backups 00:13:00 Windows Backup Utility 00:07:00 Recovery 00:14:00 Backup and Recovery of VMs 00:09:00 IDA Planning and Implementing an AD FS Server Infrastructure 00:13:00 Planning and Implementing AD FS Claims Providers and Relying Parties 00:06:00 Planning and Implementing AD FS Claims and Claim Rules 00:07:00 Planning and Implementing an AD RMS Cluster 00:18:00 Installing an AD RMS Cluster 00:12:00 Planning and Implementing AD RMS Templates and Policies 00:06:00 Planning and Implementing External Access to AD RMS Services 00:07:00 Planning and Implementing AD RMS Integration with DAC 00:05:00 Mock Exam Mock Exam- 70-414 - Implementing an Advanced Server Infrastructure (MCSE) 00:20:00 Final Exam Final Exam- 70-414 - Implementing an Advanced Server Infrastructure (MCSE) 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Master Xero for comprehensive accounting and bookkeeping with our course. Navigate through setting up, managing accounts, inventory, payroll, VAT, and more, tailored for the needs of modern businesses.

Master pest control in the food industry with our course. Learn HACCP application, eco-friendly practices, and effective documentation strategies for a pest-free environment. Essential for food business professionals seeking comprehensive pest management knowledge.

This beginner's course exclusively delivers Python programming from basic to advanced. You will learn Python concepts in real-life programming examples by building real-world applications. Learn the syntax of Python language and understand the logic behind the programming process to create your Python programs successfully and master Python coding.