2690 Code courses in Manchester delivered Online

Duration 3 Days 18 CPD hours This course is intended for This course is appropriate for advanced users, 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. Students can apply the course skills to use Python in basic web development projects or automate or simplify common tasks with the use of Python scripts. Overview This skills-focused course is about 50% hands-on lab to lecture ratio, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert instructor, you'll learn how 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 Work with with the standard library and its work-saving modules Create 'real-world', professional Python applications Know when to use collections such as lists, dictionaries, and sets Work with Pythonic features such as comprehensions and iterators Write robust code using exception handling Introduction to Python Programming Basics is a hands-on Python programming course that teaches you the key skills you?ll need to get started with programming in Python to a solid foundational level. The start of the course will lead you through writing and running basic Python scripts, and then guide you through how to use 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 course provides you with an excellent kick start for users new to Python and scripting, enabling you to quickly use basic Python skills on the job in a variety of ways. You?ll be able use Python in basic web development projects, or use it to automate or simplify common tasks with the use of Python scripts. The course also serves as a solid primer course / foundation for continued Python study in support for next level web development with Python, using Python in DevOps, Python for data science / machine learning or Python for systems admin or networking support. Python Quick View What is Python? Python timeline Advantages/disadvantages Installing Python Getting help The Python Environment Starting Python Using the interpreter Running a Python script Editors and IDEs Getting Started with Python Using variables Builtin functions String data Numberic data Converting types Console input/output Command line parameters Flow Control About flow control The if statement Relational and Boolean operators while loops Exiting from loops Array Types About array types Lists and list methods Tuples Indexing and slicing Iterating through a sequence Sequence functions, keywords, and operators List comprehensions and generators Working with Files File overview Opening a text file Reading a text file Writing to a text file Dictionaries and Sets About dictionaries Creating dictionaries Iterating through a dictionary About sets Creating sets Working with sets Functions Defining functions Returning values Parameters and arguments Variable scope Sorting The sorted() function Custom sort keys Lambda functions Sorting in reverse Using min() and max() Errors and Exception Handling Exceptions Using try/catch/else/finally Handling multiple exceptions Ignoring exceptions Modules and Packages Creating Modules The import statement Module search path Using packages Function and module aliases Getting Started with Object Oriented Programming and Classes About object-oriented programming Defining classes Constructors Understanding self Properties Instance Methods and data Class methods and data Inheritance Additional course details: Nexus Humans Introduction to Python Programming Basics (TTPS4800) 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 Introduction to Python Programming Basics (TTPS4800) 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.

Duration 3 Days 18 CPD hours This course is intended for This course is intended for experienced administrators with a background in either software development or system administration. Team leaders, lead developers, and other accidental Team Foundation Server administrators are also encouraged to take this course. This course will also help a student prepare for the relevant Microsoft certification exam. Overview At course completion, attendees will have had exposure to: - TFS editions and components - Supported topologies and environments - Must-have TFS administration tools - Hardware and software requirements - Required service accounts and permissions - Installing Team Foundation Server - Configuring Team Foundation Server - Managing relevant SQL Server components - Managing relevant SharePoint components - Installing and using Team Explorer - Team project collections and team projects - Using and customizing process templates - TFS licensing and Client Access Licenses - Connecting and using Microsoft Excel & Project - Installing and using Team Explorer Everywhere - Integrating TFS and SharePoint - Using the TFS web portal - Git and TFVC version control systems - Basic and advanced version control workflows - Configuring and using code search - Controlling access to version controlled items - Command-line and third party tools - Configuring automated builds - Deploying and using Visual Studio agents - Configuring agent pools and queues - Creating and queuing automated builds - Configuring Package Management - Configuring Release Management - Creating a release definition - Creating and deploying a release - Strategies for upgrading and migrating to TFS - Integrating TFS with other systems and data - High availability and scalability options - Capacity planning and disaster recovery - Backing up, restoring, and moving TFS data - Managing the data warehouse - Using PowerShell to manage TFS - Customizing Team Foundation Server - Extending Team Foundation Server Provides students with the knowledge and skills to deploy, configure, and manage Microsoft Team Foundation Server 2019 and related software components. Introduction to Team Foundation Server Introduction to Team Foundation Server Editions, components, and configurations Visual Studio Team Services comparison TFS' support of Application Lifecycle Management TFS administrator responsibilities and tasks ?Must-have? tools of a TFS administrator Planning and Deploying TFS Planning the deployment System requirements, software, and accounts Installing and configuring TFS Installing Team Explorer Troubleshooting Configuring TFS Administrator roles and tools Managing team project collections Managing team projects Managing process templates Securing TFS, SharePoint, and SQL Server Renaming and deleting a team project Client Applications TFS Client Access Licenses (CAL) Team Explorer and the web portal Microsoft Excel and Microsoft Project SharePoint project portal Team Explorer Everywhere Command-line and 3rd party tools Version Control Overview of Git and TFVC version control systems Integration with Visual Studio Using TFVC and Git version control Basic and advanced workflows Controlling access to version control Command-line tools and utilities TFS Proxy, MSSCCI Provider, and TFS Sidekicks Building and Releasing Overview of the Visual Studio build system Build agents, agent pools, agent queues Creating and queuing a build Monitoring, and managing a build Securing the build process Running tests as part of the build Overview of Package Management Overview of Release Management Defining, creating, and deploying a release Upgrading, Migrating, and Integrating Upgrading Team Foundation Server In-place vs. migration upgrade Performing post-upgrade tasks Migrating work items Migrating items under version controlled Integrating with Team Foundation Server Custom and 3rd party solutions Advanced Administration Monitoring the health of Team Foundation Server Web-based diagnostic tools Options for scalability and high availability Disaster recovery, backup, and restore Moving Team Foundation Server Managing the data warehouse Using PowerShell to manage TFS Customizing and Extending Customizing vs. extending Customizing a process template Customizing a work item type Creating default work items Creating and using a global list Using Witadmin.exe Using work item templates Creating a custom report Using the REST API to extend Team Foundation Server Additional course details: Nexus Humans Administering Team Foundation Server 2017 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 Administering Team Foundation Server 2017 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.

Javascript for Data Structures Course Overview This course, JavaScript for Data Structures, offers a comprehensive introduction to fundamental data structures using JavaScript. Learners will explore core concepts such as lists, stacks, queues, and sets, gaining a solid understanding of how data is organised and managed in programming. The course emphasises clear, logical thinking and problem-solving skills applicable to software development, data analysis, and computer science. By the end, participants will be able to implement key data structures effectively, enhancing their coding proficiency and preparing them for more advanced programming challenges or career opportunities in technology-related fields. Course Description This course delves into essential data structures within JavaScript, providing detailed coverage of lists, stacks, queues, and sets. Learners will study how these structures operate, their use cases, and how to manipulate them efficiently in code. The curriculum is designed to develop both theoretical understanding and coding ability through structured explanations and examples. Throughout the course, students will develop skills in data organisation, algorithmic thinking, and memory management principles. This knowledge is critical for writing optimised code and tackling complex computational problems in software development and data science domains. Javascript for Data Structures Curriculum Module 01: Introduction Module 02: Essential Concepts Module 03: List Data Structure Module 04: Stack Data Structure Module 05: Queue Data Structure Module 06: Set Data Structure Module 07: Final Thought (See full curriculum) Who Is This Course For? Individuals seeking to build strong foundations in data structures using JavaScript. Professionals aiming to enhance their software development skills. Beginners with an interest in programming and computer science. Students preparing for technical roles in coding or data analysis. Career Path Software Developer Front-End Developer Data Analyst Junior Programmer Computer Science Student

Keep your drivers informed, compliant, and confident behind the wheel. This subscription is designed to improve driver knowledge, reduce risks, and support ongoing transport compliance. Each course tackles real-world challenges with clear, practical guidance drivers can apply immediately. 📲 24/7 online access for 12 months – start anytime, on any device!

Copper cabling systems training course description A hands on training course covering installation, termination and testing of copper cables in an internal environment. The course covers all copper cabling but hands on sessions focus on unshielded Twisted Pair. What will you learn Recognise different copper cables and when to use them. Install and terminate UTP cables. Test and certify UTP cables. Copper cabling systems training course details Who will benefit: Professional cable installers. Prerequisites: None Duration 2 days Copper cabling systems training course contents Communications principles Use of cables in data networks, Use of cables in telephone networks, conductors and insulators, current, resistance, voltage and Ohms law. Copper cabling per cabling Coaxial versus twisted pair. UTP and STP. Cat 5, 5e, 6 and 7. Straight through, cross over, others. Hands on: Building a simple network. Cable termination Cable termination Preparing cables for termination, termination techniques, termination tools. Wiring standards, colour codes. Hands on: Making your own cables and using them in the simple network. Cable architectures Structure cabling system components, topologies, horizontal wiring, vertical wiring, telecomms rooms, server rooms. Hubs, switches and routers implications. Trunking. Cabling documentation, symbols and abbreviations. Hands on: punch blocks, testing continuity. Cable installation Site surveys: pathways and spaces, support structures, distance limitations. Recommended installation practices, laying and setup, retrofits. Health and safety factors, fire and building codes. Hands on: Performing a site survey, installing cable with floor boxes. Testing Basic testing, volt meters, tone set, Cat 5 testers, Cat 5e testers, Cat 6 testers. Certifying performance, Cat 5, 5e and 6 performance parameters. External factors. Common faults. Hands on: Testing an installation, troubleshooting faults. Other aspects Telephony cables, shielded cables. Hands on: installing telephone cable, testing continuity.

Description: Are you someone who is passionate about becoming a Wedding Photographer, but do not know where to start? Want to know what it takes to make it as a Wedding Photographer? Then you have come to the right place to learn about wedding photography. Weddings are wondrous events to get to shoot, and the most priceless thing in wedding photography is to capture genuine emotion, happiness, excitement, and joy. Through this Level 3 Diploma in Wedding Photography, you will discover the secrets of capturing excellent wedding photos. The course teaches you techniques for shooting in a wide range of styles confidently, and professionally. Enhance your knowledge more about camera, lenses, flash and technical settings. Apart from this, learn to deal with low light, complex situations and capture photos with the perfect timing. After completing the course, you will be able to capture beautiful, compelling, and eye-catching wedding images. Who is the course for? Any photographer interested in making money, being a part of someone's special day, and start a flexible business that can be done anywhere in the world. probably not for you if you've never picked up a camera before. Check out Phil's Photography Masterclass to learn the basics of photography before enrolling in this one.P 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 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. 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: 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. Introduction 01. introduction ##00 FREE 00:02:00 01. Introduction ##01 What is this Course all about-sanj 00:01:00 01. Introduction ##02 Who am I 00:01:00 01. Introduction ##03 Top 5 Tips for Better Wedding Photos 00:03:00 01. Introduction ##04 Why should you Become a Wedding photographer 00:03:00 01. Introduction ##05 How to Succeed with this course 00:01:00 01. Introduction ##06 Live Posing Session 00:13:00 01. Introduction ##01 What is this course all about 00:01:00 Setting Up Your Wedding Photography Business 02. Setting Up Your Business ##01 Section Intro 00:01:00 02. Setting Up your Business ##02 What Type of Wedding Photographer are you 00:03:00 02. Setting Up Your Business ##03 Equipment You Need toGet Started 00:05:00 02. Setting Up Your Business ##04 What Camera Brand is Best 00:02:00 2. Setting Up Your Business ##05 Where Should you buy Camera equipment 00:01:00 02. Setting Up Your Business ##06 Picking a Name for Your Company 00:03:00 02 Setting Up Your Business ##07 Launching a Website - Top Tips for a Successful Site 00:05:00 02. Setting Up Your Business ##08 Action Item-Pick a Name & Build a Website 00:01:00 02. Setting Up Your Business ##09 Creating Wedding Photography Packages 00:05:00 02. Setting Up Your Busines ##10 Pricing for Success 00:09:00 02. Setting Up Your Busines ##11 How to Get Your First Client 00:04:00 02. Setting Up Your Busines ##12 The Importance of Contracts 00:03:00 02. Setting Up Your Busines ##13 The Wedding Photography 00:02:00 02. Setting Up Your Busines ##15 Recap - Setting up your business 00:02:00 Wedding Day Overview 03. Wedding Day Overview ##01 Section Intro 00:02:00 03. Wedding Day Overview ##02 Taking Care of Business on the Wedding Day 00:02:00 03. Wedding Day Overview ##03 Overview of What to Photograph 00:12:00 03. Wedding Day Overview ##04 Using Pinterest to find Inspirational Photos 00:02:00 03. Wedding Day Overview ##05 Recap of Wedding Overview 00:01:00 How to Photograph a Wedding 04. How to Shoot a Wedding ##01 Section Intro 00:03:00 04. How to Shoot a Wedding ##02 Wedding Day Equipment Check 00:05:00 04. How to Shoot a Wedding ##03 Wedding Day Consideration-Day-Night-Indoor-Outdoor 00:03:00 04. How to Shoot a Wedding ##04 Do You Need an Assistant or Second Shooter 00:04:00 04. How to Shoot a Wedding ##05 How Much to Pay a second Shooter 00:01:00 04. How to Shoot a Wedding ##06 Scheduling the Wedding Day (First, Looks, Candide, Posed Family Shits) 00:02:00 04. How to Shoot a Wedding ##07 Achieving Your Look 00:01:00 04. How to Shoot a Wedding ##08 Details 00:05:00 04. How to Shoot a Wedding ##09 Groom Preparation 00:09:00 04. How to Shoot a Wedding ##10 Bride Preparation 00:11:00 04. How to Shoot a Wedding ##11 Walking Down the Aisle 00:04:00 04. How to Shoot a Wedding ##12 Ceremony Coverage 00:12:00 04. How to Shoot a Wedding ##13 Readers 00:03:00 04. How to Shoot a Wedding ##14 Rings, Vows,Kiss 00:03:00 04. How to Shoot a Wedding ##15 Post-Ceremony 00:05:00 04. How to Shoot a Wedding ##16 How to Shoot Family Shots 00:08:00 04. How to Shoot a Wedding ##17 Posed Couple Shots 00:13:00 04. How to Shoot a Wedding ##18 Grand Entrance 00:01:00 04. How to Shoot a Wedding ##19 Reception Details 00:06:00 04. How to Shoot a Wedding ##20 Toast and Speeches 00:06:00 04. How to Shoot a Wedding ##21 Cake Cutting 00:03:00 04. How to Shoot a Wedding ##22 First Dance 00:06:00 04. How to Shoot a Wedding ##23 Bouquet Garter Toss 00:03:00 04. How to Shoot a Wedding ##24 Dance Party 00:06:00 04. How to Shoot a Wedding ##25 Recap - How to Shoot a Wedding 00:01:00 Editing Wedding Photos - Post-Production Workflow 05. Editing Wedding Photos ##01 section Intro 00:01:00 05. Editing Wedding Photos ##02 Choosing an Editing App 00:02:00 05. Editing Wedding Photos ##03 Editing in Lightroom 00:10:00 05. Editing Wedding Photos ##04 Exporting from Lightroom 00:03:00 05. Editing Wedding Photos ##05 Editing in Photoshop 00:11:00 05. Editing Wedding Photos ##06 Creating Online Galler 00:06:00 05. Editing Wedding Photos ##07 Recap of Editing Section 00:01:00 Succeeding with Wedding Photography - Taking it to the next level! 06. Succeeding Wedding Photography ##01 Section Intro 00:01:00 06. Succeeding Wedding Photography ##02 Being Happy - Tips from a Wedding Photographer 00:52:00 06. Succeeding Wedding Photography ##03 Making it a Business and Sticking to it 00:02:00 06. Succeeding Wedding Photography ##04 Building Out Your Portfolio 00:01:00 06. Succeeding Wedding Photography ##05 Dealing With Saturated Photography Markets 00:02:00 06. Succeeding Wedding Photography ##06 Competing With Family Photographers for Jobs 00:01:00 06. Succeeding Wedding Photography ##07 Working With Other Vendors for Success 00:01:00 06. Succeeding Wedding Photography ##08 Using Social Networks to Expand Your Business 00:02:00 06. Succeeding Wedding Photography ##09 Testimonials - Yelp, Wedding Wire, The Knot 00:02:00 06. Succeeding Wedding Photography ##10 Recap Succeeding With Wedding Photography 00:03:00 Bonus: Shooting Engagement Photos 08. Bonus Engagement Photography ##01 Section Intro 00:01:00 08. Bonus Engagement Photography ##02 Equipment Check for the Engagement Photo Session 00:01:00 08. Bonus Engagement Photography ##03 How Much To Charge for an engagement Session 00:01:00 08. Bonus Engagement Photography ##04 Picking the Perfect Location for Engagement Photos 00:02:00 08. Bonus Engagement Photography ##05 Tips for Posing and Interacting with Clients for engagement Photos 00:01:00 08. Bonus Engagement Photography ##06 Engagement Photo Review 00:07:00 08. Bonus Engagement Photography ##07 Bonus Engagement Recap 00:01:00 How to Use Pinterest to Find Great Wedding Poses 00:02:00 How-to-Register-a-Domain-Name-with-Godaddy-with-a-Promo-Code 00:04:00 Course Conclusion 07. Wrap Up ##01 Thank You and What's Next 00:01:00 Course Certification Order your Certificate 00:00:00

Unreal Engine 4: The Complete Beginner's Course teaches you the fundamentals of video game development using Unreal Engine 4. Whether you have prior programming knowledge or not, this course will help you leverage the cutting-edge 3D game design software in developing the video games you always wanted.

Course overview Take a practical approach to enhance your Excel modelling skills with the Advanced Excel Models using Formulas, VBA & Power Query course. In this course, you will learn how to build robust Excel models using Formulas, VBA and Power Query. This Advanced Excel Models using Formulas, VBA & Power Query course offers a wide range of training modules to enhance your abilities to create better models. You will discover the advanced Excel formulas to prepare reports, forecast and perform mathematical calculations. We will introduce you to the three excel models and show the functions used to prepare these pro models. In addition, you will learn the Excel formulas for prepaid expenses and explore the steps to create dynamic dashboards based on Power Query and Pivot Table without any formula. Learning outcomes Familiarize yourself with the advanced Excel formulas Be able to manage prepaid expenses Deepen your understanding of the prepaid expense models Learn about the pro Excel models and formulas Strengthen your knowledge of Power Query and PowerPivot Learn how to create Power query and pivot table based dashboard without any formula Who Is This Course For? This Advanced Excel Models using Formulas, VBA & Power Query course is recommended to anyone interested in learning how to prepare robust Excel models using advanced formulas, Power Query and VBA. In addition, the skills gained from this training will provide excellent opportunities for career advancement. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £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 and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Advanced Excel Models using Formulas, VBA & Power Query Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst System Support and Reporting Analyst Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thankyou Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This course will teach you everything that you need to know to get started with C# scripting in Unity. You will learn step-by-step from scratch every feature of the C# language as well as how to implement them in Unity's API to build amazing games.

The Clinical Coding - CPD Accredited 3 Courses Bundle offers a structured, no-nonsense introduction to the essential aspects of clinical coding, all from the comfort of your own screen. Whether you’re already familiar with ICD-10, OPCS-4 and SNOMED CT, or wondering if they’re characters from a sci-fi novel, this bundle lays it all out with clarity and precision. From decoding medical terminology to understanding the legal and ethical considerations of working with confidential health records, this course trio has the full alphabet soup of clinical coding covered. Split across 13 well-defined modules, the content delves into the fundamentals of clinical records, explores classification systems used globally, and explains the logic behind code assignment—yes, there is logic, we promise. With CPD accreditation to give your CV a boost and a strong focus on knowledge that’s relevant across healthcare settings, this course bundle is ideal for those who prefer accuracy over guesswork and order over chaos. Let’s just say, if your idea of fun involves turning symptoms into structured data, you’re in the right place. Course 01: Clinical Coding Course 02: Medical Law Course 03: Medication ** Special Offer: Free PDF and Hard Copy Certificates** Key Benefits Get instant PDF and Hard Copy certificate Fully online courses Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance Course Curriculum: Clinical Coding Module 01: Introduction to Clinical Coding Module 02: Introduction to Clinical Records Its Confidentiality Module 03: Clinical Terminology and Jargons Module 04: Introduction to ICD-10 Coding Module 05: General Coding Standards of ICD-10 Module 06: ICD-10 5th Edition Codes (Chapter 1 to 4) Module 07: ICD-10 5th Edition Codes (Chapter 5 to 10) Module 08: ICD-10 5th Edition Codes (Chapter 11 to 15) Module 09: ICD-10 5th Edition Codes (Chapter 16 to 22) Module 10: Introduction to OPCS-4 Module 11: Introduction to SNOMED CT Module 12: Other types of Clinical Coding Module 13: Legal and Ethical Aspects of Working in a Clinical Environment Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing each Clinical Coding - CPD Accredited 3 Courses Bundle bundle course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Clinical Coding - CPD Accredited 3 Courses Bundle course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 30 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Clinical Coding - CPD Accredited 3 Courses Bundle training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Clinical Coding - CPD Accredited 3 Courses Bundle training.