- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
612 Computer Skills courses
Register on the Advanced SAS Programming Using MacrosSQL today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Advanced SAS Programming Using MacrosSQL is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Advanced SAS Programming Using MacrosSQL Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Advanced SAS Programming Using MacrosSQL, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Advanced SAS Programming Using MacrosSQL Unit - 1 Section 0-00- Why SAS 00:01:00 Unit - 2 Section 2-02- SAS Studio through SAS OnDemand- Registration 00:04:00 Section 2-03- Logging-in to SAS after installation 00:01:00 Section 2-04- SAS Interface and windows 00:06:00 Unit - 3 Section 3-00- Section Overview - Macros 00:01:00 Section 3-01-Macro Variables - introduction 00:14:00 Section 3-02-Application of macro variables 00:13:00 Section 3-03-01-Nested macro vars 00:11:00 Section 3-03-02-More on Ampersand resolutions using a cool example 00:09:00 Section 3-04-00-SAS Macros - introduction 00:10:00 Section 3-04-01-SAS Macros - Examples 00:07:00 Section 3-04-02-Keyword positional and mixed params 00:06:00 Section 3-04-03-Conditional Logic in Macros 00:11:00 Section 3-05-Macro Functions 00:12:00 Section 3-05-Options Statement- mprint-mlogic-symbolgen 00:13:00 Section 3-07-Connecting the two worlds - Call Symput - Symget 00:14:00 Section 3-09-01-02- Bringing data into SAS using Import Wizard 00:04:00 Section 3-09-02- Bringing data into SAS using LIBNAME statement 00:05:00 Section 3-09-03- Bringing data into SAS using FILENAME 00:05:00 Unit - 4 Section 4-00- Section Overview - Proc SQL 00:01:00 Section 4-01-01-Proc SQL - copying data 00:13:00 Section 4-01-02-Proc SQL - filtering data 00:07:00 Section 4-01-03-Proc SQL - sorting data 00:08:00 Section 4-01-04-Proc SQL - removing duplicates 00:05:00 Section 4-02-01-Proc SQL - Union 00:09:00 Section 4-02-02-Proc SQL - Except 00:04:00 Section 4-02-03-Proc SQL - Intersect 00:02:00 Section 4-03-00-Merging data using Joins-Introduction 00:08:00 Section 4-03-01-Proc SQL - inner join 00:14:00 Section 4-03-02-Proc SQL - full join 00:08:00 Section 4-03-03-Proc SQL - left and right joins 00:07:00 Section 4-04-01-Proc SQL - creating macro vars 00:07:00 Unit - 5 Section 5-00- Bonus lecture 00:02:00 Resources Resources - Advanced SAS Programming Using MacrosSQL 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
Register on the CompTIA A+ (220-1001) today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The CompTIA A+ (220-1001) is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The CompTIA A+ (220-1001) Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the CompTIA A+ (220-1001), all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Section 01: All about the CompTIA A+ CompTIA A+ 2019 Core 1 (220-1001) Course Introduction 00:02:00 What is the CompTIA A+? 00:02:00 Why Get A+ Certified? 00:03:00 What is on the CompTIA A+ Core 1 (220-1001) Exam? 00:09:00 How to Pass the A+ Exam 00:04:00 How to Use This Video Course 00:03:00 Section 02: Safety and Professionalism Tools of the Trade 00:06:00 Troubleshooting Theory 00:10:00 Section 03: The Visible Computer Primary PC Connections 00:05:00 External Connections 00:11:00 Inside the PC 00:08:00 What is a Computer? 00:07:00 Section 04: CPUs What is a CPU? 00:15:00 CPU Speeds and Cores 00:12:00 Caching 00:07:00 CPU Sockets 00:12:00 Installing a CPU 00:11:00 Liquid Cooling 00:04:00 Section 05: RAM RAM Technology 00:11:00 RAM Capacity 00:08:00 RAM Features 00:07:00 Installing RAM 00:07:00 Section 06: Firmware What is the BIOS? 00:06:00 POST 00:09:00 System Setup 00:09:00 Troubleshooting Firmware 00:12:00 Section 07: Motherboards Form Factors 00:06:00 Chipsets 00:05:00 Touring the Motherboard 00:14:00 Touring the Case 00:07:00 Installing a Motherboard 00:09:00 Section 08: Power Supplies The Power Supply 00:09:00 Mounting a Power Supply 00:05:00 Choosing a Power Supply 00:08:00 Cooling Your PC 00:11:00 Troubleshooting Power Supplies 00:09:00 Troubleshooting Core Components 00:14:00 Section 09: Mass Storage Technologies Introduction to Mass Storage 00:13:00 Magnetic Disk Drives 00:08:00 Solid State Drives 00:08:00 SCSI 00:03:00 Boot Order 00:07:00 Section 10: Implementing Mass Storage New Installation - First Drive 00:05:00 RAID 00:11:00 Hardware RAID 00:07:00 Mass Storage Troubleshooting 00:08:00 Section 11: Essential Peripherals Optical Media 00:10:00 USB Standards 00:10:00 Understanding USB 00:11:00 Configuring USB 00:07:00 Thunder and Lightning 00:06:00 Keyboards and Mice 00:08:00 Sight and Sound 00:06:00 Readers and Scanners 00:08:00 Using Expansion Cards 00:08:00 Section 12: Building a PC The Right PC for the Job 00:13:00 Section 13: Display Technologies Monitor Technologies 00:08:00 LCD Breakdown 00:04:00 Graphics Cards and Connections 00:13:00 Installing a Graphics Card 00:07:00 Projectors 00:05:00 Troubleshooting Monitors 00:06:00 Section 14: Essentials of Networking Introduction to Networking 00:08:00 Hubs vs. Switches 00:05:00 Hexadecimal 00:07:00 WANs and Routers 00:09:00 Cables and Connectors 00:11:00 Crimping Cables 00:10:00 Structured Cabling 00:11:00 Section 15: Local Area Networking Introduction to TCP/IP 00:14:00 Network IDs and Subnet Masks 00:05:00 Special IP Addresses 00:09:00 NAT 00:07:00 Dynamic IP Addressing 00:10:00 IPv6 00:07:00 Port Numbers 00:12:00 TCP, UDP, and ICMP 00:06:00 Understanding DNS 00:09:00 Working with DNS 00:07:00 Windows Naming 00:08:00 Routers 00:12:00 Basic Router Configuration 00:12:00 Advanced Router Configuration 00:06:00 VLANs 00:07:00 Network Troubleshooting 00:05:00 Section 16: Wireless Networking Wireless Network Hardware 00:11:00 Wi-Fi Standards 00:10:00 Basic WAP Setup 00:11:00 Connecting to a Wi-Fi Network 00:09:00 It's a Huge Mesh 00:04:00 Beyond Wi-Fi 00:07:00 Troubleshooting Wireless Connections 00:07:00 Section 17: The Internet Beyond the LAN 00:03:00 Internet Tiers 00:06:00 Dial-up Connections 00:08:00 Broadband Connections 00:10:00 Firewalls and Servers 00:06:00 FTP 00:07:00 E-Mail 00:08:00 Proxy Servers 00:06:00 Virtual Private Networks (VPNs) 00:08:00 Internet of Things (IoT) 00:04:00 Section 18: Virtualization Understanding Virtualization 00:10:00 Your First Virtual Machine 00:11:00 Advanced Virtualization Setup 00:10:00 Cloud Computing 00:08:00 Cloud Ownership 00:03:00 Cloud-Based Applications 00:06:00 Section 19: Portable Computing Laptop Features 00:08:00 Laptop Hardware Troubleshooting - The Tools 00:05:00 Laptop Hardware - Core Hardware 00:04:00 Laptop Hardware - CPU and Motherboard 00:07:00 Touring Your Laptop Display 00:04:00 Section 20: Understanding Mobile Devices What is a Mobile Device? 00:09:00 Mobile Connections 00:10:00 Touring Android 00:10:00 Touring iOS 00:08:00 Virtual Reality 00:03:00 Section 21: Care and Feeding of Mobile Devices Maintaining Mobile Devices 00:11:00 Mobile Devices and E-mail 00:10:00 Mobile Synchronization 00:08:00 Section 22: Printers and Multifunction Devices Laser Printers 00:13:00 Inkjet Printers 00:08:00 Impact Printers 00:04:00 Thermal Printers 00:04:00 Installing a Local Printer 00:14:00 Sharing Printers 00:08:00 Installing Wireless and Cloud Printers 00:10:00 Troubleshooting Printers 00:10:00 3D Printing 00:07:00 Section 23: Securing Computers Dealing with Threats 00:07:00
Register on the CompTIA A+ (220-1002) today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The CompTIA A+ (220-1002) is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The CompTIA A+ (220-1002) Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the CompTIA A+ (220-1002), all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Section 01: All About the CompTIA A+ 2019 Core 2 Exam CompTIA A+ 2019 Core 2 (220-1002) Course Introduction 00:02:00 What is the CompTIA A+ 00:02:00 Why Get A+ Certified? 00:03:00 What is on the CompTIA A+ Core 2 (220-1002) Exam? 00:04:00 How to Pass the CompTIA A+ Exam 00:04:00 How to use this Video Course 00:03:00 Section 02: Safety and Professionalism Professional Communication Part 1 00:06:00 Professional Communication Part 2 00:07:00 Physical Safety 00:07:00 Section 03: The Visible Computer What is an Operating System? 00:09:00 Users and Super Users 00:05:00 Why Windows? 00:08:00 Windows Editions and Versions 00:12:00 Touring the macOS 00:06:00 Touring Linux 00:08:00 Section 04: CPUs 32-Bit vs. 64-Bit Processing 00:12:00 Section 05: RAM Virtual Memory 00:06:00 Section 06: Power Supply Power Protection 00:10:00 Section 07: Implementing Mass Storage Understanding Partitioning 00:04:00 MBR Partitioning 00:12:00 GPT Partitioning 00:09:00 Understanding File Systems 00:12:00 Popular File Systems 00:07:00 Formatting in Action 00:11:00 Dynamic Disks 00:09:00 Software RAID in Storage Spaces 00:10:00 Encrypting Mass Storage 00:09:00 Section 08: Building a PC Boot from Everything 00:12:00 Installing Windows 00:12:00 Post-Installation Tasks 00:12:00 Windows Installation options 00:07:00 Section 09: Windows under the Hood What is the Registry? 00:11:00 Processes 00:07:00 Services 00:04:00 Your Windows Toolset 00:08:00 Windows 7 Task Manager 00:09:00 Windows 10 Task Manager 00:06:00 Information and Configuration Tools 00:11:00 Performance Monitor 00:12:00 Event Viewer 00:07:00 Tools for Programmers 00:08:00 Section 10: Users, Groups, and Permissions Introduction to Users and Groups 00:06:00 Managing Users and Groups 00:12:00 NTFS Permissions 00:08:00 Linux and macOS Permissions 00:05:00 File Explorer 00:14:00 Sharing Resources 00:11:00 Security Policies 00:08:00 Section 11: Maintaining and Optimizing Operating Systems Patch Management 00:11:00 Working with Disks 00:06:00 Working with Applications 00:07:00 System Restore 00:05:00 Backing up Your Files 00:07:00 Task Scheduler 00:07:00 Section 12: Working with the Command-Line Interface Understanding the CLI 00:11:00 Navigating the CLI 00:14:00 Working with Folders 00:07:00 Working with Files 00:11:00 Working with Drives 00:13:00 Super Copy Commands 00:09:00 Advanced Windows Command Line 00:08:00 Advanced Linux Commands 00:13:00 Command-Line Permissions 00:08:00 Introduction to Scripting 00:10:00 Interpreted Languages 00:12:00 Section 13: Troubleshooting Operating Systems Windows Recovery Environment 00:05:00 Advanced Windows Startup Options 00:07:00 Troubleshooting Boot Problems 00:10:00 Troubleshooting at the GUI 00:11:00 Troubleshooting Applications 00:07:00 Kernel Panic 00:05:00 Section 14: Display Technologies Resolutions and Aspect Ratios 00:06:00 Multiple Monitors 00:05:00 Section 15: Essentials of Networking Network Card Troubleshooting 00:09:00 Section 16: Local Area Networking Working with Connections 00:09:00 Working with Workgroups 00:08:00 Working with Active Directory 00:14:00 Windows Sharing with Mac and LInux 00:07:00 Net Command 00:04:00 Firewall Configuration 00:11:00 Windows Firewall 00:08:00 Port Forwarding 00:07:00 Section 17: Wireless Networking Wireless Encryption 00:11:00 Enterprise Wireless 00:16:00 Section 18: The Internet Telnet and SSH 00:07:00 Remote Desktop Connections 00:06:00 The World Wide Web 00:09:00 Troubleshooting Internet Connections 00:07:00 Section 19: Portable Computing Power Management 00:11:00 Section 20: Care and Feeding of Mobile Devices Mobile Device Security 00:08:00 Mobile Security Troubleshooting 00:06:00 Mobile Device Troubleshooting 00:10:00 Section 21: Securing Computers Threats 00:10:00 Physical Security 00:08:00 Passwords and Authentication 00:14:00 Malware 00:14:00 Anti-Malware 00:11:00 Social Engineering 00:06:00 Licensing 00:10:00 Incident Response 00:05:00 Environmental Controls 00:06:00 Section 22: Operational Procedures Documents You Need to Know 00:09:00 Data You Need to Know 00:04:00 Change Management 00:06:00 The Zen of Backup 00:11:00 Recycling and Data Destruction 00:07:00
A Computer Maintenance Specialist keeps computers in a good state of repair. They may run diagnostic programs to determine the causes of and help to resolve problems. The Start Your Career as Web Developer - Complete Training course is designed for the people who want to pursue the lucrative career of computer maintenance specialists. Topics included in the course are the types of computer, computer basics, the anatomy of a PC, how a PC works, input and output devices, and more. In short, the course covers almost everything that you need to know about becoming a computer specialist. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Course Content Introduction Introduction 00:03:00 How to Get Course requirements 00:02:00 Getting Started on Windows, Linux or Mac 00:02:00 How to ask a Great Questions 00:01:00 FAQ's 00:01:00 HTML Introduction HTML 00:05:00 Choosing Code Editor 00:06:00 Installing Code Editor (Sublime Text) 00:04:00 Overview of a Webpage 00:05:00 Structure of a Full HTML Webpage 00:07:00 First Hello World! Webpage 00:09:00 HTML Basic Heading tags 00:09:00 Paragraph 00:08:00 Formatting Text 00:12:00 List Items Unordered 00:05:00 Classes 00:09:00 IDs 00:06:00 Comments 00:04:00 HTML Intermediate Images 00:12:00 Forms 00:05:00 Marquee 00:06:00 Text area 00:06:00 Tables 00:06:00 Links 00:07:00 Navbar - Menu 00:04:00 HTML Entities 00:05:00 Div tag 00:06:00 Google Maps 00:07:00 HTML Advanced HTML Audio 00:07:00 HTML Video 00:05:00 Canvas 00:06:00 Iframes 00:05:00 Input Types 00:04:00 Input Attributes 00:06:00 Registration Form 00:04:00 Contact Us Form 00:10:00 Coding Exercise 00:01:00 Solution for Coding Exercise 00:01:00 JavaScript Introduction What is JavaScript 00:09:00 Hello World Program 00:06:00 Getting Output 00:11:00 Internal JavaScript 00:13:00 External JavaScript 00:09:00 Inline JavaScript 00:04:00 Async and defer 00:06:00 JavaScript Basics Variables 00:16:00 Data Types 00:11:00 Numbers 00:06:00 Strings 00:04:00 String Formatting 00:05:00 JavaScript Operators Arithmetic operators 00:03:00 Assignment operators 00:02:00 Comparison operators 00:05:00 Logical operators 00:06:00 JavaScript Conditional Statements If-else statement 00:05:00 If-else-if statement 00:04:00 JavaScript Control Flow Statements While loop 00:09:00 Do-while loop 00:04:00 For loop 00:15:00 Coding Exercise 00:01:00 Solution for Coding Exercise 00:01:00 JavaScript Functions Creating a Function 00:08:00 Function Call() 00:07:00 Function with parameters 00:05:00 JavaScript Error Handling Try-catch 00:05:00 Try-catch-finally 00:17:00 JavaScript Client-Side Validations On Submit Validation 00:09:00 Input Numeric Validation 00:12:00 PHP Introduction What is PHP 00:08:00 Installing XAMPP for PHP, MySQL and Apache 00:12:00 Installing Code Editor(Visual Studio Code) 00:07:00 Creating PHP Project on XAMPP 00:03:00 Hello World Program 00:06:00 PHP Basic Variables 00:16:00 Echo and Print 00:08:00 Data Types 00:11:00 Numbers 00:06:00 Boolean 00:04:00 Arrays 00:06:00 Multi-Dimensional Array 00:07:00 Sorting Arrays 00:04:00 Constants 00:05:00 PHP Strings Strings 00:04:00 String Formatting 00:05:00 String Methods 00:08:00 Coding Exercise 00:01:00 Solution for Coding Exercise 00:01:00 PHP Operators Arithmetic operators 00:03:00 Assignment operators 00:02:00 Comparison operators 00:05:00 Increment - decrement operators 00:03:00 Logical operators 00:06:00 Ternary operator 00:03:00 PHP Decision-Making System If statement 00:05:00 If-else statement 00:02:00 If-else-if-else statement 00:03:00 Switch-case statement 00:05:00 PHP Control Flow Statements Flow Chart 00:06:00 While loop 00:09:00 Do-while loop 00:03:00 For loop 00:15:00 Foreach loop 00:04:00 Coding Exercise 00:01:00 Solution for Coding Exercise 00:01:00 PHP Functions Creating a Function 00:08:00 Function with Arguments 00:08:00 Default Argument 00:03:00 Function return values 00:06:00 Call-by-value 00:02:00 Call-By-Reference 00:02:00 PHP Super Globals $_POST Method 00:06:00 $_GET Method 00:02:00 PHP Advanced Form Handling 00:08:00 Date and Time 00:08:00 Include 00:06:00 Require 00:02:00 Sessions 00:08:00 File Reading 00:02:00 File Upload 00:06:00 PHP Object-Oriented Programming[OOPs] What is OOP 00:03:00 Class and Objects 00:11:00 Constructor 00:04:00 Destructor 00:03:00 Access Modifiers 00:10:00 Inheritance 00:12:00 Method overriding 00:06:00 Abstract Class 00:03:00 Interface 00:08:00 PHP - MySQL Application [CRUD] MySQL Basic PhpMyAdmin 00:04:00 Creating Database and Table 00:07:00 Database Connection 00:05:00 PHP Form Create records 00:16:00 PHP Form Reading records 00:11:00 PHP Form Update Data 00:15:00 PHP Form Delete records 00:04:00 PHP Real-World Code Forms Registration Form 00:04:00 MD5 Algorithm for Encrypting 00:03:00 Sha Algorithm 00:02:00 Login Form 00:12:00 PHP Validations On Submit Validation 00:09:00 Input Numeric Validation 00:12:00 Login Form Validation 00:05:00 Form Server-side all Data Validation 00:06:00 Form Server-side Validation 00:06:00 PHP Error Handling Try-throw-catch 00:06:00 Try-throw-catch-finally 00:02:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
The Office Administrator Skills for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. This Office Administrator Skills consists of several modules that take around 3 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why Choose this Course? Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full tutor support on weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Course Content Module 01: Introduction to Office Administration Introduction to Office Administration 00:16:00 Module 02: Skills of an Effective Administrator Skills of an Effective Administrator 00:16:00 Module 03: What are Soft Skills? What are Soft Skills 00:10:00 Module 04: Communication Communication 00:08:00 Module 05: Teamwork Teamwork 00:07:00 Module 06: Problem-Solving Problem-Solving 00:08:00 Module 07: Time Management Time Management 00:08:00 Module 08: Attitude and Work Ethic Attitude and Work Ethic 00:08:00 Module 09: Adaptability/Flexibility Adaptability/Flexibility 00:08:00 Module 10: Self-Confidence (Owning It) Self-Confidence (Owning It) 00:09:00 Module 11: Ability to Learn from Ability to Learn from 00:08:00 Module 12: Networking Networking 00:08:00 Module 13: Negotiation Techniques Negotiation Techniques 00:17:00 Module 14: Conflict Management Conflict Management 00:15:00 Module 15: Stress Management Stress Management 00:17:00 Mock Exam Mock Exam - Office Administrator Skills 00:20:00 Final Exam Final Exam - Office Administrator Skills 00:20:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
An essential part of your skillset as an office worker and administrator is an excellent understanding of the many uses of Microsoft Excel. This superb course will enable your abilities to use it as a primary tool to create workbooks and formulas. But you will also be guided in the use of more complicated functions involving automation, formatting, and calculation. By the end of the lessons, you will be more than accomplished at producing stunning graphs and worksheets that will perform the bulk of the work for you. Learning Outcomes: Learn how to create worksheets and workbooks Use functions and formulas to calculate results Create attractive charts and graphs for meetings Write automated workbooks that drive activities Impress senior colleagues with dynamic presentations of data Why Choose this Course? Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99.00. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is This Course for? This course is designed for senior administrators or PAs that need to store and manipulate company data or employee statistics. Requirements This Microsoft Excel Course is fully compatible with any kind of device. Whether you are using Windows computer, 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 The course is suitable for those in the roles of; Personal Assistant Secretary Heads of Departments Administrator Receptionist Course Content Microsoft Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Mock Exam Mock Exam - Microsoft Excel 00:20:00 Final Exam Final Exam - Microsoft Excel 00:20:00 Assignment Assignment - Microsoft Excel 2 weeks, 1 day Order Your Certificate Order your Certificate QLS 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
