• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

2675 Code courses delivered Online

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query

4.5(3)

By Studyhub UK

Ascend to the next level of Excel proficiency with our comprehensive Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course. This in-depth training will equip you with the skills to create sophisticated dashboards using advanced Excel formulas, VBA, and Power Query, empowering you to transform raw data into actionable insights. Master the art of financial modeling with our prepaid expenses models, learning how to calculate amortization schedules and create detailed summaries using Excel formulas. Delve into the power of Power Query to effortlessly manipulate and analyze large datasets, building dynamic dashboards without the limitations of formulas. Learning Outcomes Gain proficiency in creating automated dashboards using advanced Excel formulas, VBA, and Power Query Develop expertise in financial modeling using prepaid expenses models Master the calculation of amortization schedules and prepaid expenses summaries Implement Power Query to manipulate and analyze large datasets Create dynamic dashboards without the limitations of formulas Enhance your Excel skills and data analysis capabilities Why choose this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 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 Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course for? Accounting and finance professionals seeking to enhance their Excel skills for financial modeling and dashboard creation Business analysts and data analysts aiming to expand their expertise in data manipulation and visualization Excel enthusiasts interested in mastering advanced Excel formulas, VBA, and Power Query Individuals seeking to create interactive and insightful dashboards for data-driven decision-making Anyone seeking to elevate their Excel skills and become a proficient data analyst Career path Financial Analyst (£35,000 - £55,000) Business Analyst (£40,000 - £60,000) Data Analyst (£45,000 - £65,000) Management Accountant (£40,000 - £60,000) Business Intelligence Analyst (£45,000 - £65,000) Senior Financial Analyst (£50,000 - £70,000) Prerequisites This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 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 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 Thank you 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 Assignment Assignment - Microsoft Excel: Automated Dashboard Using Advanced Formula VBA Power Query 00:00:00

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
Delivered Online On Demand6 hours 8 minutes
£10.99

Reinforcement Learning and Deep RL Python (Theory and Projects)

By Packt

The course is crafted to reflect the in-demand skills in the marketplace that will help you in mastering the key concepts and methodologies of RL and deep RL, along with several practical implementations. This course will help you know the theory and practical aspects of reinforcement and deep reinforcement learning.

Reinforcement Learning and Deep RL Python (Theory and Projects)
Delivered Online On Demand14 hours 16 minutes
£59.99

Ultimate PHP & MySQL Web Development & OOP Coding

By iStudy UK

The world is comprised of many different people, with many different cultures, who speak many different languages. Even though English is considered the staple international language, not everyone understands or speaks in English. That is why there is a huge need for people in the world to help others learn this language in order to eliminate the language barrier we have. You could be one of these people with the help of this Teaching English as Foreign Language (TEFL) course. This is a very elaborate course but helps you to become the perfect English teacher to those who don't know it so well. It starts with helping you to teach in different situations - as per needs and constraints - and work with many different approaches for different students. Following that there are specific chapters dedicated to help you teach speaking, listening, reading, writing and grammar in English. You will also learn about creating lesson plans and testing as well. The course is filled with exercises and examples to help you in your way to become a great English as a foreign language teacher. Course Highlights Ultimate PHP & MySQL Web Development & OOP Coding is an award winning and the best selling course that has been given the CPD Qualification Standards & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Ultimate PHP & MySQL Web Development & OOP Coding into 133 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 10 hours, 6 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Ultimate PHP & MySQL Web Development & OOP Coding Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Ultimate PHP & MySQL Web Development & OOP Coding is CPD Qualification Standards and IAO accredited. 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 backgrounds. Requirements Our Ultimate PHP & MySQL Web Development & OOP Coding 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD Qualification Standards and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Section 01: Introduction & Setup Introduction 00:02:00 Setup On Windows 00:15:00 Setup On Mac 00:11:00 Setup On Linux 00:12:00 Online Code Editor 00:03:00 Section 02: Basics Basic File Syntax 00:05:00 Printing (echo) 00:06:00 Comments 00:05:00 Variables 00:06:00 Variable Data Types 00:07:00 Variable Naming 00:03:00 Constants 00:02:00 Arrays 00:05:00 Associative Arrays 00:06:00 Multidimensional Arrays 00:04:00 Section 03: Control Structures if Statement 00:06:00 if...else Statement 00:02:00 if...elseif...else Statement 00:05:00 Switch Statement 00:06:00 while Loop 00:06:00 do...While Loop 00:03:00 for Loop 00:03:00 foreach Loop 00:05:00 Break Statement 00:02:00 Continue Statement 00:02:00 Section 04: Functions Basic Function 00:03:00 Passing Function Arguments 00:03:00 Passing Function Arguments By Reference 00:04:00 Default Argument Value 00:02:00 Function Returning Values 00:05:00 Dynamic Function Calls 00:03:00 Variable Scope 00:04:00 Section 05: Forms Simple HTML Form 00:07:00 GET vs POST 00:05:00 $_SERVER ['PHP_SELF'] 00:07:00 Validating Form Data With PHP 00:07:00 Required Fields 00:05:00 Display Error Messages 00:05:00 Validate Name 00:03:00 Validate Email 00:03:00 Validate URL 00:07:00 Keep The Values In The Form 00:04:00 Section 06: File Handling Read File (readfile()) 00:02:00 Open, Read & Close A File (fopen(), fread(), fclose()) 00:04:00 Read Single Line (fgets()) 00:03:00 Check End-Of-File (feof()) 00:02:00 Read Single Character (fgetc()) 00:02:00 Write To File (fwrite()) 00:03:00 Configure php.ini File For File Uploading 00:02:00 Front End HTML Upload Form 00:04:00 PHP Upload Script 00:15:00 Check If File Exists 00:03:00 Limit File Size 00:05:00 Limit File Type 00:04:00 Section 07: MySQL MySQL vs MySQLi vs PDO 00:05:00 Creating A Database & Table (phpMyAdmin) 00:06:00 Connecting To A Database 00:06:00 Get Data Using SELECT Query 00:10:00 WHERE Property For Filtering 00:03:00 LIKE Property For Pattern Search 00:02:00 Sorting Results Using ORDER BY Property 00:01:00 Using JOINS 00:08:00 Insert Data Using INSERT Query 00:04:00 Get ID Of The Last Inserted Row 00:02:00 Insert Multiple Rows 00:05:00 Update Data Using UPDATE Query 00:03:00 Delete Data Using DELETE Query 00:02:00 Delete All Rows In A Table Using TRUNCATE Query 00:02:00 Delete Table Using DROP Query 00:02:00 Limit Data Selections Using LIMIT, ROWNUM 00:04:00 Create Table Using CREATE Query 00:03:00 Clone/Duplicate Table 00:03:00 Alter Table 00:05:00 Create Database 00:02:00 Drop Database 00:02:00 SQL Injection & Prepared Statements 00:09:00 Section 08: XML What Is XML? 00:02:00 What Is SimpleXML? 00:02:00 Parse XML String 00:08:00 Parse XML File 00:02:00 Get Node Values 00:02:00 Get Node Values of Specific Elements 00:03:00 Get Node Values - Loop 00:03:00 Get Attribute Values 00:02:00 What Is The XML Expat Parser? 00:02:00 Initializing The XML Expat Parser 00:10:00 Load and Output XML Using DOM Parser 00:02:00 Looping Through XML Using DOM Parser 00:03:00 Section 09: AJAX What Is AJAX? 00:02:00 Load Simple Data Using AJAX Front End 00:08:00 Load Simple Data Using AJAX Back End 00:05:00 Load Data From A Database Using AJAX 00:08:00 Section 10: Emails Send A Plain Text Email 00:04:00 Send A HTML Email 00:06:00 Email Attachments 00:17:00 PHPMailer Setup 00:03:00 Send Email Using PHPMailer 00:04:00 Send HTML Email Using PHPMailer 00:04:00 Email Attachments Using PHPMailer 00:02:00 Section 11: Object Oriented Programming What Is Object Oriented Programming (OOP)? 00:03:00 Basic Class With Variables 00:04:00 Functions 00:05:00 Constructor 00:04:00 Destructor 00:02:00 Inheritance 00:06:00 Multi Class Inheritance 00:03:00 Function Overriding 00:03:00 Public vs Private vs Protected 00:05:00 Interfaces 00:04:00 Constants 00:03:00 Abstract Class 00:06:00 Static Keyword 00:03:00 Final Keyword 00:02:00 Initiating Parent Constructor 00:02:00 Section 12: Error Handling die() Function 00:02:00 Custom Error Handler 00:04:00 Triggering An Exception 00:03:00 Exception Handling 00:05:00 Create Database & Table 00:04:00 User Class & Database Connection 00:15:00 Register User Form 00:09:00 Inserting User Data Into Database 00:10:00 Registration Form Field Validation 00:12:00 Securing User Password 00:03:00 Check If Username or Email Already Exists 00:11:00 Retain Data After Failed Registration 00:03:00 Section 13: Advanced Validate an Integer Within a Range 00:04:00 Validate IPv6 Address 00:03:00 Validate URL - Must Contain QueryString 00:03:00 Remove Characters With ASCII Value > 127 00:04:00 Including & Requiring External PHP Files 00:05:00 Section 14 : Resource Resource 00:00:00 Assignment Assignment - Ultimate PHP & MySQL Web Development & OOP Coding 00:00:00

Ultimate PHP & MySQL Web Development & OOP Coding
Delivered Online On Demand10 hours 6 minutes
£25

Wordpress from Scratch

5.0(1)

By LearnDrive UK

The course will show you how to build a website from scratch using WordPress.

Wordpress from Scratch
Delivered Online On Demand1 hour
£5

SEO and Digital Marketing Diploma

By iStudy UK

SEO and Digital Marketing Diploma Overview Email marketing, SEO, and social media platforms like Facebook, Twitter, and Pinterest are all covered in this SEO and Digital Marketing Diploma course. This certificate is ideal for individuals who want to succeed in the fast-paced field of SEO and digital marketing. A thorough education in modern marketing techniques is provided by the SEO and Digital Marketing Diploma. Your role-specific knowledge and competence in data analytics, SEO keywords, website auditing, keyword analysis, monetising websites, and plugin installation will be acquired through video lessons, online study materials, suggested reading, and automated assessments. An additional goal of this course is to provide you with real-world knowledge on how to grow an online following on various social media platforms, such as Facebook, YouTube, LinkedIn, and Twitter. Why You Should Choose SEO and Digital Marketing Diploma Diploma Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? SEO and Digital Marketing Diploma Diploma is CPD certified and IAO accredited. 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 backgrounds. Requirements Our SEO and Digital Marketing Diploma 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module 01: Introduction Welcome 00:01:00 Module 02: General Tips & Tricks Series How to register your company 00:04:00 How to see Email Sender's Company and Logo in Your Gmail 00:02:00 How to Generate sitemap of a website 00:03:00 How to protect a website from Spam on WordPress 00:02:00 Quick way to identify whether the website is Mobile optimized 00:03:00 How to identify registration data of website 00:01:00 How to identify duplicate content from the web 00:03:00 How to create google alerts 00:03:00 How to find the age of the domin 00:02:00 How to check if the website server is down 00:01:00 How to create text notes thatwill self destruct after being read 00:02:00 How to send google search information to your friends 00:03:00 How to find webhost of any website 00:02:00 Discover new sites that are similar to what you like alredy 00:03:00 How to easily highlight the important parts of a web page 00:01:00 How to share you email online without worrying about spam 00:02:00 How to get compute level answers without searching 00:03:00 The easiest way to setup email reminders 00:03:00 How to find the original URL tht's hiding behind a short URL 00:02:00 How to corrupt a file you shared online 00:01:00 How to create a throwaway email 00:02:00 How to check if your email account has been compromised 00:01:00 Module 03: SEO (Search Engine Optimisation) How to register website on Google search console 00:06:00 How to Optimize your website homepage 00:06:00 SEO - How to add a sitemap on google search 00:07:00 How to shortlist targeted keyword list in google keyword planner 00:08:00 How to set international targeting on google search 00:02:00 How to remove a URL from google search engine 00:03:00 How to identify competitors keyword 00:08:00 How to leverage top sites to get on google search results 00:04:00 Discover powerful data analytics to mesure SEO performance 00:06:00 How to do keyword research 00:11:00 How to write perfect title tags for search engines 00:05:00 How to optimise heading tags, external and internal links 00:08:00 What are backlinks & how to get them 00:06:00 How to write a perfect Meta description 00:06:00 How to enhance speed & performance of your website 00:04:00 Module 04: YouTube Youtube account setup 00:04:00 Account optimization 00:09:00 How to create & setup Youtube channel banner 00:05:00 Youtube channel tags, thumbnails & custom thumbnails 00:08:00 Analyse Youtube keyword research 00:05:00 Youtube SEO techniques 00:07:00 What are Youtube cards & how does it work 00:06:00 How to optimise comments & reply them in bulk 00:03:00 How to grow your channel with competitor Analysis 00:07:00 How to manage multiple YouTube accounts 00:02:00 A simple yet powerful trick to increase your subscribers list 00:03:00 Youtube Paid Advertising 00:13:00 How to monetise your YouTube channel 00:02:00 Module 05: Google Adwords What are Google Ads & how does it work 00:16:00 Account setup 00:04:00 Competitors analysis 00:08:00 Campaign types & how to select the right campaign 00:07:00 Bids & Budgets 00:08:00 How to target the right audience 00:07:00 Google Ads advance campaign settings 00:07:00 Choosing the right keywords 00:05:00 How to write ads that gets more clicks 00:06:00 Module 06: Google Analytics How to install tracking code on your website 00:04:00 How to add filters & remove internal traffic 00:04:00 How to track paid campaigns 00:04:00 How to look and analyse different segment data 00:06:00 How to configure goals in google analysics 00:05:00 How to link google Adwords account 00:03:00 How to manage multiple analytics accounts 00:02:00 How to remove spam traffic 00:04:00 Module 07: Email Marketing Email marketing tools set up ( Mailchimp and Gestresponse) 00:10:00 How to install signup or popup forms on the website 00:17:00 How to collect email address without a wbsite 00:05:00 How to create a 'Hook' to your signup forms 00:08:00 Discover the psychology behind acquiring more leads 00:09:00 Email marketing automation process 00:08:00 Email analytics 00:07:00 Module 08: Linkedln How to increase your connections in no time 00:08:00 Secret of LinkedIn InMails 00:05:00 Discover the best ways to use Linkedin Groups 00:09:00 How to setup a company page on Linkedin 00:04:00 How to increase traffic to your website using Linkedin blog 00:07:00 Module 09: Twitter Twitter Account setup 00:03:00 Knowing Twitter features 00:06:00 Following twitter accounts 00:03:00 Twitter profile optimisation 00:06:00 How to get Twitter followers 00:10:00 Posting first 5 tweets for engagement 00:05:00 Leveraging Hashtags to increase your tweets visibility 00:04:00 What are twitter polls & how do you use them 00:05:00 A powerful trick to acquire customers on twitter 00:03:00 How to get followers retweet your post 00:03:00 How to embed a twitter button to your website or post 00:02:00 Twitter analytics 00:04:00 Module 10: Facebook Set your Facebook page 00:05:00 Facebook Icon, cover image & description 00:06:00 How to get your first page likes 00:08:00 Discover how to increase your page likes 00:02:00 How to manage multiple Facebook page 00:03:00 Facebook comments 00:05:00 Leveraging Facebook groups 00:05:00 Facebook Autoposting 00:04:00 Run a competition 00:06:00 Facebook Ads 00:04:00 How to get best out of Facebook 00:15:00 Facebook pixel & Re-marketing 00:04:00 Module 11: Instagram How to setup a Instagram business profile 00:07:00 Set up Instagram bio & profile image 00:03:00 Leveraging Instagram accounts 00:06:00 A simple way to create free content on Instagram 00:05:00 Secret of hashtags on Instagram 00:04:00 Reposting Instagram App 00:04:00 How to get genuine Instagram followers 00:05:00 Discover how to grow your business through Instagram stories 00:05:00 How to get your posts reposted on Instgram by influncers 00:05:00 Module 12: Mobile App A quick way to do App store marketing research 00:16:00 How to discover the estimate size of your market 00:08:00 Discover the best ways to promote your app 00:15:00 App installs via Facebook Ads 00:16:00 App installs via Google Ads 00:14:00 How to make money from your app 00:08:00 How to optimise your App store listing ? 00:14:00 Discover growth hacking techniques for App downloads 00:09:00 Techniques to get to the top of App store ranking 00:07:00

SEO and Digital Marketing Diploma
Delivered Online On Demand11 hours 23 minutes
£25

The Complete Guide for SQL with Microsoft SQL Server

By Packt

In this comprehensive course, you will learn everything you need to know about SQL and Microsoft SQL Server, from the basic to advanced topics. With easy-to-follow lessons and hands-on exercises, you will gain the skills and confidence to work with databases like a pro. Perfect for beginners and anyone looking to expand their data management skills.

The Complete Guide for SQL with Microsoft SQL Server
Delivered Online On Demand7 hours 52 minutes
£82.99

Build an Online Magazine or Blog Website in 1 Hour Using Wix

4.5(3)

By Studyhub UK

Embark on a transformative journey into the digital realm with our course, 'Build an Online Magazine or Blog Website in 1 Hour Using Wix.' In just a single hour, unlock the secrets to crafting a captivating online presence that not only reflects your unique style but also engages your audience effectively. This course isn't just a tutorial; it's a dynamic exploration into the art of website creation. Imagine, within the span of 60 minutes, you'll progress from site setup and design to the seamless integration of a Wix blog, culminating in a polished platform that's ready to showcase your content to the world. Through an immersive blend of step-by-step guidance and creative inspiration, this course empowers you to harness the full potential of Wix, transforming your digital vision into reality effortlessly. Learning Outcomes Master Site Setup and Formatting: Acquire the skills to set up your website, experiment with fonts, and choose an appealing colour palette to establish a visually striking online presence. Design Expertise with Wix: Explore the intricacies of Wix design as you learn to add custom headers, incorporate parallax effects, and create bespoke blog elements, elevating the aesthetic appeal of your online space. Seamless Blog Integration: Dive into the world of blogging by seamlessly integrating the Wix Blog into your site, enhancing your ability to share content and connect with your audience. Innovative Pop-Up Menus: Elevate user experience by mastering the creation of pop-up menus using Wix Lightboxes, adding a touch of interactivity and sophistication to your website. Effective Content Organization: Learn the art of connecting articles to custom elements, creating category pages, and making final connections, ensuring your content is not just visible but also thoughtfully organized for maximum impact. Why choose this Build an Online Magazine or Blog Website in 1 Hour Using Wix 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 Build an Online Magazine or Blog Website in 1 Hour Using Wix course for? Individuals aspiring to establish a vibrant online presence effortlessly. Bloggers and content creators aiming to enhance the visual appeal and functionality of their websites. Entrepreneurs seeking a quick and effective solution for showcasing their products or services. Beginners in website development keen on mastering Wix within a short timeframe. Small business owners looking to create an engaging online platform for their brand. Career path Web Designer: £25,000 - £35,000 Content Creator/Blogger: £20,000 - £30,000 Digital Entrepreneur: £30,000 - £40,000 Freelance Website Developer: £25,000 - £35,000 Social Media Manager: £25,000 - £35,000 Online Marketing Specialist: £30,000 - £40,000 Prerequisites This Build an Online Magazine or Blog Website in 1 Hour Using Wix does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Build an Online Magazine or Blog Website in 1 Hour Using Wix 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 00:01:00 Getting Started Set up your site, formatting fonts and selecting a colour palette 00:07:00 Add the Wix Blog to Your Site 00:02:00 Start Designing Adding a custom header strip with parallax 00:10:00 Creating the 1st custom blog element 00:07:00 Creating the 2nd custom element 00:06:00 Adding a Wix blog element 00:06:00 Pop-Up Menu Creation Pop-Up Menu creation using Wix Lightboxes 00:06:00 Connecting Your Articles To Your Elements To Make Them Visible Creating Category Pages 00:03:00 Connect the blog to custom elements 00:05:00 Final Connections 00:09:00 Assignment Assignment - Build An Online Magazine or Blog Website in 1 hour using Wix 00:00:00

Build an Online Magazine or Blog Website in 1 Hour Using Wix
Delivered Online On Demand1 hour 2 minutes
£10.99

Essential Wix Training

4.5(3)

By Studyhub UK

Discover the power of Wix with the Essential Wix Training course. This concise and informative program equips you with the skills to create dynamic and engaging websites using Wix's versatile platform. From adding interactive elements like chat, blogs, and videos to managing events and memberships, you'll learn to craft captivating web experiences. With step-by-step guidance, you'll also master the Wix Editor's tools and explore the Wix App Market to enhance your website's functionality. Learning Outcomes: Understand the fundamentals of building websites with Wix. Integrate dynamic features like chat, blogs, and videos into your site. Incorporate social media content using the Instagram Feed app. Enhance engagement with interactive elements like events and memberships. Explore advanced Wix Editor functionalities for customizing backgrounds and media. Manage blogs effectively using the Wix Editor's tools. Navigate and leverage the Wix App Market to expand your site's capabilities. Gain proficiency in using the Wix Editor for seamless website creation. Why buy this Essential Wix 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 Essential Wix Training you will be able to take the MCQ test that will assess your knowledge. 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 Essential Wix Training course is ideal for Individuals looking to build websites without coding knowledge. Entrepreneurs aiming to establish an online presence. Small business owners seeking to create their own websites. Freelancers interested in offering website design services using Wix. Prerequisites This Essential Wix 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 Wix Website Designer: £20,000 - £40,000 per year. Freelance Wix Developer: Earnings vary based on projects. Small Business Website Manager: £25,000 - £45,000 per year. Digital Marketing Specialist with Wix Expertise: £25,000 - £50,000 per year. Entrepreneurial Website Owner: Earnings vary based on the business. Course Curriculum Essential Wix Training Overview 00:01:00 Adding the Chat App 00:01:00 Adding the Blog App 00:02:00 Adding the Instagram Feed 00:02:00 Adding the Video App 00:02:00 Adding the Events App 00:02:00 Adding the Members Area 00:02:00 Adding a Bookings App 00:02:00 Adding a Music App 00:02:00 Adding a Music App 00:01:00 Switching to the Wix Editor 00:02:00 The Wix Editor - Part 2 00:02:00 The Wix Editor - Part 3 - Backgrounds 00:02:00 The Wix Editor - Part 4 - Add Button 00:03:00 The Wix Editor - Part 5 - Media 00:02:00 The Wix Editor - Part 6 - Blog Management 00:01:00 The Wix Editor Tools 00:02:00 Wix App Market - Part 1 00:02:00 Wix App Market - Part 2 00:01:00 Conclusion 00:01:00

Essential Wix Training
Delivered Online On Demand35 minutes
£10.99

Data Analysts' Toolbox - Excel, Python, Power BI, Alteryx, Qlik Sense, R, Tableau

By Packt

This course explains how huge chunks of data can be analyzed and visualized using the power of the data analyst toolbox. You will learn Python programming, advanced pivot tables' concepts, the magic of Power BI, perform analysis with Alteryx, master Qlik Sense, R Programming using R and R Studio, and create stunning visualizations in Tableau Desktop.

Data Analysts' Toolbox - Excel, Python, Power BI, Alteryx, Qlik Sense, R, Tableau
Delivered Online On Demand46 hours 14 minutes
£101.99

Project Contract Management Skills: Virtual In-House Training

By IIL Europe Ltd

Project Contract Management Skills: Virtual In-House Training Contracts are a critical part of most large or strategic projects/programs. As such, it is imperative that Project and Program Managers be well versed on basic implications of a contract as well as best practices in contract management. While not as critical a need, anyone involved in projects that involve external relationships should have a healthy appreciation for the power of good contract management. The overall goal of the course is to provide knowledge to manage complex contracts in a global environment. What You Will Learn After this program, you will be able to: Explain overall project procurement process from a buyer and seller perspective Recognize the importance of key contractual terms and how they affect projects Evaluate and contribute to the pre-contract documents and processes Identify and mitigate common pitfalls throughout the procurement process Utilize techniques to administer contracts Getting Started Introductions Course structure Course goals and objectives Foundation Concepts The Importance of Contract Management Terms and Definitions Contract Management Process Legal Systems Codes of Conduct Planning Business Analysis Procurement Management Plan Procurement Statement of Work (SOW) Common Pitfalls Solicit Contract Market Analysis Bid documents Sellers' Proposals Pitfalls Execute Contract Evaluate and Award Contract Negotiate Contract Execute Contract Common Pitfalls Deliver the Contract Preparing to Deliver Project Plan Risk Management Common Pitfalls Administer Contract Enabling Contract Management Contract Performance Monitoring and Control Change Management Financial Management / Payment Dispute Management & Resolution Contract Completion and Closure

Project Contract Management Skills: Virtual In-House Training
Delivered OnlineFlexible Dates
£1,250