2984 Code courses

This course will fully prepare you for virtually any Excel-related career path

Nobody can afford to ignore the internet as a medium for connecting with customers, building a brand, or promoting a cause. This course will teach you everything you need to become a digital marketer in 2023 or create a successful online presence for your business. You will learn a strategy-building technique. Customer experience, traffic generation, advertising strategies, analytics, and ROI tracking are all covered in the course. Companies are attempting to stay ahead of the competition with the rise of social media, search engine optimisation, and other digital marketing strategies. A digital marketing course can provide the skills and knowledge required to assist businesses in reaching their objectives. Companies use digital marketing to raise brand awareness and promote their products to their target market. As a result, businesses can reach out to customers in more precise and personalised ways. Digital marketing seeks to reach and engage customers online to increase sales and grow your business. So enrol now and grow your business online with this Digital Marketing training. Key Topics To Be Covered: Strong online presence of the business. Make your website visible in search results through effective SEO Engaging video content will drive traffic to your website. Increase sales with digital marketing like never before by properly targeting and optimising! Utilise your audience data and analytical capabilities in digital marketing. Solid mailing list and a solid revenue-generating marketing channel. To increase traffic, use company profiles, LinkedIn, and blogs. Twitter hashtags, retweets, and analytics! Facebook Ads and interact with your audience through pages and groups. Instagram marketing and ads help grow businesses quickly. Why Prefer this Digital Marketing Course? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standards-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support Experts created the Digital Marketing course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the Digital Marketing course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the course: Module 01: Introduction Welcome General Tips & Tricks Series How to register your company How to see Email Sender's Company and Logo in Your Gmail How to Generate a sitemap of a website How to protect a website from Spam on WordPress How to identify registration data of website How to identify duplicate content from the web How to create google alerts How to find the age of the domain How to check if the website server is down How to send google search information to your friends How to find the web host of any website Discover new sites that are similar to what you like already How to easily highlight the important parts of a web page How to get compute level answers without searching The easiest way to Setup email reminders How to corrupt a file you shared online How to create a throwaway email Module 02: YouTube YouTube accounts Setup Account optimization How to create & Setup YouTube channel banner YouTube channel tags, thumbnails & custom thumbnails Analyse YouTube keyword research YouTube SEO techniques What are YouTube cards & how does it work How to optimise comments & reply to them in bulk How to grow your channel with competitor Analysis How to manage multiple YouTube accounts YouTube Paid Advertising How to monetise your YouTube channel Module 03: Google AdWords What are Google Ads & how does it work Account Setup Competitor's analysis Campaign types & how to select the right campaign Bids & Budgets How to target the right audience Google Ads advance campaign settings Choosing the right keywords How to write ads that get more clicks Module 04: Google Analytics How to install tracking code on your website How to add filters & remove internal traffic How to track paid campaigns How to look and analyse different segment data How to configure goals in google analysis How to link google Adwords account How to manage multiple analytics accounts How to remove spam traffic Module 05: Email Marketing Email marketing tools set up How to install signup or popup forms on the website How to collect email addresses without a website How to create a 'Hook' to your signup forms Discover the psychology behind acquiring more leads Email marketing automation process Email analytics Module 06: Twitter Twitter Account Setup Knowing Twitter features Following Twitter accounts Twitter profile optimization How to get Twitter followers Twitter analytics Module 07: Facebook Set your Facebook page Facebook Icon, cover image & description How to get your first page likes Discover how to increase your page likes How to manage multiple Facebook page Facebook comments Leveraging Facebook groups Facebook Auto Posting Run a competition Facebook Ads How to get the best out of Facebook Facebook pixel & Re-marketing Module 08: Instagram Setup Instagram bio & profile image Leveraging Instagram accounts A simple way to create free content on Instagram The secret of hashtags on Instagram Reposting Instagram App How to get genuine Instagram followers Assessment Process Once you have completed all the course modules, your skills and knowledge will be tested with an automated multiple-choice assessment. You will then receive instant results to let you know if you have successfully passed the course. CPD 15 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Side Hustlers. Website Owners. Business Owners. Social Media Marketers. Digital Marketers. Newcomers. Brand Owners. Freelancers. Requirements Enrol on Digital Marketing with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register on the course without any delay. We only ask that all students have a passion for learning and literacy, and be over the age of 16. Complete the online from your computer, tablet, or smartphone, and learn in a way that suits you. Career path This knowledge will boost the value of your CV and allow you to apply for jobs in a wide range of industries, including Digital Marketing Consultants Entrepreneurs Marketing Executives Digital Marketers Digital Agencies Marketing Consultants Marketing Managers Certificates Certificate of completion Digital certificate - £10

Become a Microsoft Certified Excel Expert - includes lectures, test exercises, and video solutions

Let your online presence reflect your services, products, and articles by developing a successful online business or website using effective search engine optimization (SEO) strategies! This course will help you move your website and content to the first page of Google and other major search engines by getting you up to speed with the latest SEO techniques.

Duration 5 Days 30 CPD hours This course is intended for This introductory-level Python course is geared for experienced web developers new to Python who want to use Python and Django for full stack web development projects. Overview Working in a hands-on learning environment, guided by our expert team, attendees will learn to: Develop full-stack web sites based on content stored in an RDMS Use python data types appropriately Define data models Understand the architecture of a Django-based web site Create Django templates for easy-to-modify views Map views to URLs Take advantage of the built-in Admin interface Provide HTML form processing Geared for experienced web developers new to Python, Introduction to Full Stack Web Development with Python and Django is a five-day hands-on course that teaches students how to develop Web applications using the Django framework. Students will explore the basics of creating basic applications using the MVC (model-view-controller) design pattern, as well as more advanced topics such as administration, session management, authentication, and automated testing. 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. The Python Environment Starting Python Using the interpreter Running a Python script Getting help Editors and IDEs Getting Started Using variables Built in functions Strings Numbers Converting among types Writing to the screen Command line parameters Flow Control About flow control Conditional expressions Relational and Boolean operators while loops Lists and Tuples About sequences Lists and list methods Tuples Indexing and slicing Iterating through a sequence Sequence functions, keywords, and operators List comprehensions Working with Files File overview The with statement Opening a file Reading/writing files Dictionaries and Sets About dictionaries Creating and using dictionaries About sets Creating and using sets Functions Returning values Function parameters Variable Scope Sorting with functions Errors and Exception Handling Exception overview Using try/catch/else/finally Handling multiple exceptions Ignoring exceptions Modules and Packages Creating Modules The import statement Module search path Creating packages Classes About OO programming Defining classes Constructors Properties Instance methods and data Class/static methods and data Inheritance Django Architecture Django overview Sites and apps Shared configuration Minimal Django layout Built in flexibility Configuring a Project Executing manage.py Starting the project Generating app files App configuration Database setup The development server Using cookiecutter Creating models Defining models Related objects SQL Migration Simplel model access Login for Nothing and Admin for Free Setting up the admin user Using the admin interface Views What is a view HttpResponse URL route configuration Shortcut: get_object_or_404() Class-based views Templates About templates Variable lookups The url tag Shortcut: render() Querying Models QuerySets Field lookups Chaining filters Slicing QuerySets Related fields Q objects Advanced Templates Use Comments Inheritance Filters Escaping HTML Custom filters Forms Forms overview GET and POST The Form class Processing the form Widgets Validation Forms in templates Automated Testing Why create tests? When to create tests Using Django's test framework Using the test client Running tests Checking code coverage

Duration 3 Days 18 CPD hours This course is intended for This course is designed for the following roles: Network engineers Network security engineers Network architects Sales/presales engineers Overview After taking this course, you should be able to: Describe Cisco SD-WAN security functions and deployment options Understand how to deploy on-premises threat prevention Describe content filtering options Implement secure Direct Internet Access (DIA) Explain and implement service chaining Explore Secure Access Service Edge (SASE) and identify use cases Describe Cisco Umbrella Secure Internet Gateway (SIG) and deployment options Implement Cisco Umbrella SIG and Domain Name System (DNS) policies Explore and implement Cloud Access Security Broker (CASB) and identify use cases (including Microsoft 365) Describe how to use Cisco ThousandEyes to monitor cloud services Configure Cisco ThousandEyes to monitor Microsoft 365 applications Examine how to protect and optimize access to the Software as a Service (SaaS) application with Cisco SD-WAN Cloud OnRamp Describe and deploy Cloud OnRamp for multi-cloud, including interconnect and colocation use cases Examine Cisco SD-WAN monitoring capabilities and features with vManage and vAnalytics The Implementing Cisco SD-WAN Security and Cloud Solutions (SDWSCS) v1.0 course is an advanced training course focused on Cisco SD-WAN security and cloud services. Through a series of labs and lectures you will learn about on-box security services, including application-aware enterprise firewall, intrusion prevention, URL filtering, malware protection, and Transport Layer Security (TLS) or Secure Socket Layer (SSL) decryption. You will also learn about cloud integration with multiple cloud service providers across multiple use cases. Additionally, the course labs will allow you to configure and deploy local security services and cloud security services with the Cisco Umbrella Secure Internet Gateway (SIG), as well as integrate the Cisco SD-WAN fabric with a cloud service provider using the Cisco vManage automated workflows. The course lab environment is built using Cisco Catalyst 8000v IOS XE routers and Cisco SD-WAN 20.7 code, and it includes the integration of Cisco FirePOWER Threat Defense for network security and Cisco ThousandEyes for network monitoring. The course will allow you to earn 24 Continuing Education (CE) credits toward recertification. Course Outline Introducing Cisco SD-WAN Security Deploying On-Premises Threat Prevention Examining Content Filtering Exploring Cisco SD-WAN Dedicated Security Options Examining Cisco SASE Exploring Cisco Umbrella SIG Securing Cloud Applications with Cisco Umbrella SIG Exploring Cisco SD-Wan ThousandEyes Optimizing SaaS Applications Connecting Cisco SD-WAN to Public Cloud Examining Cloud Interconnect Solutions Exploring Cisco Cloud OnRamp for Colocation Monitoring Cisco SD-WAN Cloud and Security Solutions Additional course details: Nexus Humans Cisco SD-WAN Security and Cloud Onboarding v1.0 (SDWSCS) 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 Cisco SD-WAN Security and Cloud Onboarding v1.0 (SDWSCS) 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.

The Control of Substance Hazardous to Health (COSHH) 2002 is a regulatory law in the UK, which aims at reducing and preventing threats of hazardous substances in the workplace. COSHH regulation in the UK is mandatory for all workplaces that work or may come into contact with hazardous substances in the workplace. Explore the ways to ensure health and safety in the workstation while you learn to overcome the challenges. Take a step towards driving your career forward and get ahead of the curve with our COSHH Training course. This Certificate in COSHH Training at QLS Level 3 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 120 CPD points) to make your skill development & career progression more accessible than ever! Why Prefer This COSHH Training Course? Opportunity to earn certificate a certificate endorsed by the Quality Licence Scheme after completing the COSHH Training course FREE COSHH Training CPD-accredited certificate Get a free student ID card with COSHH Training (£10 applicable for international delivery) Lifetime access to the COSHH Training course materials The COSHH Training program comes with 24/7 tutor support Get instant access to this COSHH Training course Learn COSHH Training from anywhere in the world The COSHH Training is affordable and simple to understand The COSHH Training is entirely online This COSHH Training is designed for you to advance your understanding of hazardous substances as defined in the Control of Substances Hazardous to Health Regulations 2002. The COSHH course incorporates ways to determine the health issues that can arise from the hazardous substance in the work premises as well as how to prevent them from affecting your colleagues. Throughout this online COSHH Training program, you will demonstrate perception on how to control and monitor the measures taken to reduce the risks, how to identify the hazardous substance, how to assess the risk associated with the chemical and hazardous materials, and last but not least, how to plan and implement the control measure according to organisation structure or policy. Furthermore, this COSHH Training includes the guidelines that follow the approved code of practice, which you will need to follow and execute to comply with COSHH rules and regulations in the workplace. You'll get a Free Student ID card by enrolling in this COSHH course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. In case of any query regarding the COSHH Training course, you will also have support from a team of experts who will be available during the weekdays (Monday - Friday) to assist you through email and chat boxes. On top of everything, with this COSHH Training you will get an accredited certificate that includes 10 CPD points which will help you to make a mark for yourself in the competitive job market. This COSHH Training Course certificate will also help you create an impression of self-reliance and dedication that will surely attract prospective employers to prioritise your job application. Enrol the COSHH Training Program today to develop skills that will drive your career forward and get ahead of the curve. What will I learn from this COSHH Training Course? An overview of COSHH and its standards in the UK Identify and interpret the key COSHH regulations and how they apply to different work environments. Recognize health problems and illnesses related to exposure to hazardous substances as outlined in COSHH guidelines. Develop the ability to identify hazardous substances in the workplace in compliance with COSHH standards. Conduct effective COSHH risk assessments to evaluate potential hazards and determine appropriate control measures. Implement control measures in line with COSHH to minimize exposure to hazardous substances and ensure workplace safety. Monitor the effectiveness of control measures as required by COSHH regulations and adapt strategies when necessary. Understand how COSHH regulations impact various industries and their specific responsibilities regarding hazardous substances. Demonstrate the process of effectively documenting COSHH assessments and control measures for compliance purposes. Gain knowledge on the proper use of personal protective equipment (PPE) and other tools to comply with COSHH safety requirements. The COSHH training course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of this program, you will receive an instant e-certificate as proof of comprehensive skill development and competency. Students can expect to complete this course in around 04 hours. You'll also get dedicated expert assistance from us to answer any queries you may have while studying our course. Start your learning journey with this course straight away and take a step forward in securing a better future! Why should you choose the COSHH Training course with Academy for Health & Fitness? Opportunity to earn a certificate accredited by CPD after completing this COSHH Training Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Globally accepted standard structured lesson planning Innovative and engaging contents and activities Assessments that measure higher-level thinking and skills Complete the COSHH Training program in your own time, at your own pace Each of our students gets full tutor support on weekdays (Monday to Friday) ****Course Curriculum of COSHH Training**** Here are the topics you will cover on the COSHH Training: COSHH Explained COSHH Regulations Health Problems Related to Hazardous Substances Identifying Hazardous Substances COSHH Risk Assessments Control Measures and Monitoring Implementing Control Measures Assessment Process of COSHH Training After completing an online course module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analysed, and the score will be shown for your review. The passing score for each test will be set at 60%. After passing the Certificate in COSHH Training at QLS Level 3 exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This COSHH course is designed for the individual who is already working or would like to work in companies or organisations that involves dealing with chemicals and hazardous substances in the workplace. This includes profession, but is not limited to, people who work in professions such as: Catering and baking Cleaning Beauty and hairdressing Engineering Vehicle repair and painting Welding Offshore oil and gas Printing Woodworking Agriculture Leisure facilities Requirements Enrol on the COSHH Training with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register on the COSHH Training without any delay. We only ask that all students have a passion for learning and literacy, and be over the age of 16. Complete the COSHH Training course online from your computer, tablet, or smartphone, and learn in a way that suits you. Career path Enrolling on this COSHH Training programme may open doors to a wide range of career opportunities. Recent graduates and people already working in the COSHH relevant field are also encouraged to enrol. Certificates Certificate of completion Digital certificate - £10 Certificate in COSHH Training at QLS Level 3 Hard copy certificate - £89 Show off Your New Skills with a Certificate of Completion After successfully completing the Certificate in COSHH Training at QLS Level 3, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 89 GBP inside the UK 99 GBP (including postal fees) for International Delivery Certificate Accredited by CPDQS 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International Delivery)

Highlights of the Course Course Type: Online Learning Duration: 1 Hour Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about paralegal or legal secretary Understand the core competencies and principles of paralegal or legal secretary Explore the various areas of paralegal or legal secretary Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert paralegal or legal secretary Paralegal Training Course Master the skills you need to propel your career forward in paralegal or legal secretary. This course will equip you with the essential knowledge and skillset that will make you a confident paralegal or legal secretary and take your career to the next level. This comprehensive paralegal course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this paralegal course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective paralegal or legal secretary practice and equip you with the essential skills, confidence and competence to assist you in the paralegal or legal secretary industry. You'll gain a solid understanding of the core competencies required to drive a successful career in paralegal or legal secretary. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for paralegal or legal secretary or for people who are aspiring to specialise in paralegal or legal secretary. Enrol in this paralegal course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive paralegal course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this paralegal or legal secretary can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This paralegal course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This paralegal course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This paralegal course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Introduction 00:01:00 The Legal Support Specialist: Definition - Titles and Role - Scope of Work The Legal Support Specialist: Definition - Titles and Role - Scope of Work 00:03:00 Working in a law firm or in-house legal department - Differences and advantages 00:07:00 Legal Framework for the Legal Support Specialist: Standards and code of conduct 00:08:00 The Job Description of Legal Assistants 00:09:00 Career Development Plan 01:48:00 Matter Management - The Legal Matter Life Cycle The Matter Management Life Cycle 00:03:00 Phase 1: Receive the Matter - The “Legal Service Order Form” 00:09:00 Phase 2: Assess the Matter - Conflict Check - KYC and DD checks 00:06:00 Phase 3: Assign the Matter - Criteria for team assignments 00:05:00 Phase 4: Engage the client - Letter of Engagements and Billing Arrangements 00:07:00 Phase 5: Deliver the work 00:02:00 Phase 6: Manage - Timekeeping - Understanding the billing system 00:03:00 Phase 6: Manage - Review of Narratives 00:05:00 Phase 7: Close the matter - Closure checklist and Lesson Learned 00:25:00 Files, Documents and Records Management File Management - How to create and manage a filing system for your company 00:07:00 Records and Documents Management 00:09:00 Mastering your soft skills Soft skills for Legal Assistants 00:03:00 Communication Skills - E-mail Communication Ettiquete 00:13:00 Emotional Intelligence at the workplace 00:25:00 Stress Management 00:15:00 Confidentiality at the workplace 00:09:00 Assessment Assessment - Paralegal Training 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Overview This comprehensive course on Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query comes with accredited certification 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 Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 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 12 sections • 76 lectures • 06:08:00 total length •Course Outline and Introduction: 00:04:00 •Minimum Requirements for the Course: 00:01:00 •Prepayments Introduction: 00:01:00 •Month End Date Prepaid Expenses Amortization Calculation: 00:00:00 •Exact Prepaid Expenses Payment Date Calculation: 00:00:00 •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 •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 •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 •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 •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 •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 •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 •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 •Thank you: 00:02:00 •Ultimate Prepaid Expenditure Model (Super Bonus): 00:02:00 •Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query: 00:00:00

The 'Visual Basic and VBScript Training' course is a comprehensive program that equips learners with the skills to create and manipulate software applications using Visual Basic (VB) and VBScript. Participants will delve into the fundamental concepts, advanced techniques, and graphical user interface (GUI) development, enabling them to build interactive and user-friendly applications. This course covers a range of topics, from basic scripting to advanced resource management, empowering learners to harness the power of these programming languages for various software development needs. Learning Outcomes: Gain proficiency in creating and manipulating software applications using Visual Basic. Understand the core concepts of classes and their role in application development. Explore file handling techniques for efficient data management. Develop graphical user interfaces (GUI) for user-friendly application interaction. Implement dialog boxes to enhance user experience and gather input. Learn advanced scripting techniques to optimize application functionality. Utilize resource management techniques for efficient application design. Develop proficiency in VBScript for creating dynamic web pages and scripting actions. Why buy this Visual Basic and VBScript Training? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on 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 Visual Basic and VBScript Training 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 £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Visual Basic and VBScript Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Aspiring software developers looking to learn Visual Basic and VBScript. Programmers seeking to expand their knowledge of application development. Web developers interested in using VBScript for dynamic web content. IT professionals looking to enhance their scripting and programming skills. Prerequisites This Visual Basic and VBScript Training 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. Career path Software Developer - Median salary of $110,000 - $120,000 per year. Web Developer - Median salary of $75,000 - $85,000 per year. Application Developer - Median salary of $90,000 - $100,000 per year. Systems Analyst - Median salary of $80,000 - $90,000 per year. IT Consultant - Median salary of $90,000 - $100,000 per year. Course Curriculum Section 01: Introduction Introduction To This Course 00:02:00 Setup On Windows 00:06:00 Run Code Online 00:01:00 Section 02: Basics Console Output 00:04:00 Comments 00:03:00 Variables 00:03:00 Console Input 00:02:00 Data Types 00:08:00 Constants 00:03:00 Enumerations 00:04:00 Directives 00:05:00 Operators 00:06:00 If Statement 00:05:00 Switch Statement 00:04:00 Loops 00:08:00 Strings 00:05:00 Date & Time 00:04:00 Arrays 00:06:00 For Each Loop 00:04:00 ArrayList 00:04:00 Hashtable 00:05:00 SortedList 00:03:00 Stack 00:05:00 Queue 00:04:00 Subs 00:07:00 Functions 00:04:00 Exception Handling 00:05:00 Section 03: Classes Simple Class Example 00:09:00 Constructor 00:03:00 Destructor 00:03:00 Shared Properties 00:04:00 Inheritance 00:04:00 Scope 00:03:00 Section 04: File Handling File Handling 00:07:00 Section 05: GUI Setup A GUI Project 00:03:00 Forms 00:05:00 TextBox 00:06:00 Label 00:02:00 Button 00:04:00 ListBox 00:04:00 ComboBox 00:03:00 RadioButton 00:04:00 CheckBox 00:02:00 DateTimePicker 00:03:00 PictureBox 00:03:00 ProgressBar 00:03:00 GroupBox 00:04:00 TreeView 00:04:00 ListView 00:02:00 Events 00:03:00 Section 06: Dialog Box Color Dialog 00:03:00 Font Dialog 00:03:00 Open File Dialog 00:03:00 Save File Dialog 00:05:00 Print Dialog 00:03:00 Section 08: Resource Menus 00:02:00 Anchoring & Docking 00:04:00 Modals 00:03:00 Regular Expressions 00:09:00 Parsing an XML File 00:06:00 Section 07: Advanced Resource - Visual Basic and VBScript Training 00:00:00 Assignment Assignment - Visual Basic and VBScript Training 00:00:00