1210 Database courses delivered On Demand

Land Your Dream Job! Get Personalised Career Support & Expert Tips, Craft Your CV, Explore Top Jobs & Ace Interviews!

Register on the Microsoft Excel Level 1, 2 & 3 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 a digital certificate as proof of your course completion. The Microsoft Excel Level 1, 2 & 3 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 Microsoft Excel Level 1, 2 & 3 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 Microsoft Excel Level 1, 2 & 3, 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 Microsoft Excel Beginners - Level 1 Getting Started With Microsoft Office Excel 2016 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 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying A Worksheet 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 Formatting A Worksheet 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 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Microsoft Excel Intermediate - Level 2 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Microsoft Excel Advanced - Level 3 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Resources Resources - Microsoft Office 2016 Excel Beginner to Advanced 00:00:00 Assignment Assignment - Microsoft Office 2016 Excel Beginner to Advanced 00:00:00 Recommended Materials Workbook - Microsoft Office 2016 Excel Beginner to Advanced 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.

Microsoft Office 2016 Essentials is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Microsoft Office 2016 Essentials and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 17 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Excel 2016 Getting Started With Microsoft Office Excel 2016 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 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet 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 Formatting a Worksheet Apply Text Formats 00:16: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:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Word 2016 Getting Started with Word Navigate in Microsoft Word 00:12:00 Create and Save Word Documents 00:24:00 Manage Your Workspace 00:06:00 Edit Documents 00:16:00 Preview and Print Documents 00:04:00 Customize the Word Environment 00:08:00 Formatting Text and Paragraphs Apply Character Formatting 00:17:00 Control Paragraph Layout 00:19:00 Align Text Using Tabs 00:07:00 Display Text in Bulleted or Numbered Lists 00:03:00 Apply Borders and Shading 00:05:00 Working More Efficiently Make Repetitive Edits 00:06:00 Apply Repetitive Formatting 00:10:00 Use Styles to Streamline Repetitive Formatting Tasks 00:14:00 Managing Lists Sort a List 00:05:00 Format a List 00:06:00 Adding Tables Insert a Table 00:07:00 Modify a Table 00:06:00 Format a Table 00:03:00 Convert Text to a Table 00:04:00 Inserting Graphic Objects Insert Symbols and Special Characters 00:04:00 Add Images to a Document 00:11:00 Controlling Page Appearance Apply a Page Border and Color 00:03:00 Add Headers and Footers 00:06:00 Control Page Layout 00:05:00 Add a Watermark 00:04:00 Preparing to Publish a Document Check Spelling Grammar and Readability 00:07:00 Use Research Tools 00:06:00 Check Accessibility 00:03:00 Save a Document to Other Formats 00:04:00 Workbooks - Microsoft Word 2016 (Beginner) Workbooks - Microsoft Word 2019 00:00:00 PowerPoint 2016 PowerPoint Interface Navigate the PowerPoint Environment 00:28:00 View and Navigate a Presentation 00:15:00 Create and Save a PowerPoint Presentation 00:13:00 Use PowerPoint Help 00:10:00 Presentation Basics Select a Presentation Type 00:08:00 Edit Text 00:13:00 Build a Presentation 00:27:00 Formatting Format Characters 00:11:00 Format Paragraphs 00:16:00 Format Text Boxes 00:09:00 Inserting Options Insert Images 00:10:00 Insert Shapes 00:15:00 Working with Objects Edit Objects 00:16:00 Format Objects 00:06:00 Group Objects 00:04:00 Arrange Objects 00:07:00 Animate Objects 00:07:00 Table Create a Table 00:09:00 Format a Table 00:03:00 Insert a Table from Other Microsoft Office Applications 00:06:00 Charts Create a Chart 00:10:00 Format a Chart 00:10:00 Insert a Chart from Microsoft Excel 00:05:00 Review and Presentatin Review Your Presentation 00:11:00 Apply Transitions 00:05:00 Print Your Presentation 00:05:00 Deliver Your Presentation 00:08:00 Access 2016 Introduction to Access Orientation to Microsoft Access 00:39:00 Create a Simple Access Database 00:10:00 Get Help and Configure Options in Microsoft Access 00:06:00 Modify Data Modify Table Data 00:17:00 Sort and Filter Records 00:05:00 Working with Queries Create Basic Queries 00:15:00 Sort and Filter Data in a Query 00:14:00 Perform Calculations in a Query 00:08:00 Access Forms Create Basic Access Forms 00:07:00 Work with Data on Access Forms 00:23:00 Working with Reports Create a Report 00:23:00 Add Controls to a Report 00:12:00 Enhance the Appearance of a Report 00:05:00 Prepare a Report for Print 00:03:00 Organize Report Information 00:15:00 Format Reports 00:12:00

Through this course, you will learn how to arrange Kafka a producer and consumer and Kafka Streams and Connectors accurately. You will also gain the skills needed to coordinate Kafka with existing application stages and to pass the Apache Kafka certification exam.

This course will help you learn the programming fundamentals with Python 3. It is designed for beginners in Python and is a complete masterclass. This course will help you understand Python GUI, data science, full-stack web development with Django, machine learning, artificial intelligence, Natural Language Processing, and Computer Vision.

A beginner's guide to mastering real-time stream processing using Apache Kafka and Kafka Streams API

The Bash Scripting, Linux and Shell Programming Masterclass course is a comprehensive guide to mastering Bash scripting, Linux, and shell programming. It's designed to address a common challenge: the complexity of navigating and controlling Linux-based systems. By simplifying these concepts, the course empowers learners to manage and operate within a Linux environment efficiently. The ability to script and program in the shell opens doors to streamlined processes, automation, and enhanced productivity, benefits that are crucial in today's tech-driven world. Through this masterclass, you will learn the essentials of Linux navigation, file management, and shell programming. Each section is crafted to build your skills progressively, ensuring a deep understanding of each aspect. Whether managing users, handling text files, or exploring advanced Bash features, the course is structured to provide practical, real-world applications. This approach not only enhances your technical skills but also boosts your problem-solving abilities within a Linux context. By the end of this course, you will be proficient in the technical aspects of Linux and Bash scripting and gain a strategic edge in applying these skills. The course is designed for accessibility, allowing learners to study at their own pace, from any device. This flexibility ensures that you can integrate learning seamlessly into your schedule, making it ideal for both beginners and those looking to refresh their skills Learning Outcomes Gain proficiency in basic Bash scripting and shell programming. Learn to navigate efficiently within the Linux environment. Develop skills to access and use help resources in Linux. Acquire expertise in managing files and folders in Linux. Understand how to manipulate and process text files. Learn to manage user accounts and permissions in Linux. Master techniques for terminating programs and safe logouts. Discover efficient shortcuts for faster Linux operations. Deepen understanding of Bash specifics and advanced features. Access a wealth of resources for ongoing Linux learning. Why choose this Bash Scripting, Linux and Shell Programming Masterclass? 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 Bash Scripting, Linux and Shell Programming Masterclass for? Beginners eager to learn about Linux and shell programming. IT professionals seeking to enhance their scripting skills. System administrators aiming to improve their Linux proficiency. Developers interested in automating tasks with Bash scripting. Anyone curious about mastering Linux-based systems. Career path Linux System Administrator: £25,000 - £50,000. DevOps Engineer: £30,000 - £70,000. IT Support Specialist: £20,000 - £40,000. Software Developer (with Linux skills): £25,000 - £55,000. Network Engineer: £25,000 - £50,000 Prerequisites This Bash Scripting, Linux and Shell Programming Masterclass does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Bash Scripting, Linux and Shell Programming Masterclass 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 Section 01: Introduction Introduction 00:02:00 Bash vs Shell vs Command Line vs Terminal 00:06:00 Section 02: Navigation Listing Folder Contents (ls) 00:05:00 Print Current Folder (pwd) 00:01:00 Change Folder (cd) 00:03:00 Using A Stack To Push Folders (pushd/popd) 00:03:00 Check File Type (file) 00:01:00 Find File By Name (locate) & Update Locate Database (updatedb) 00:02:00 Find A Command (which) 00:02:00 Show Command History (history) 00:02:00 Section 03: Getting Help Show Manual Descriptions (whatis) 00:01:00 Search Manual (apropos) 00:02:00 Reference Manuals (man) 00:02:00 Section 04: Working With Files/Folders Creating A Folder (mkdir) 00:02:00 Creating A File (touch) 00:02:00 Copy Files/Folders (cp) 00:02:00 Move & Rename Files/Folders (mv) 00:02:00 Delete Files/Folders (rm) 00:02:00 Delete Empty Folder (rmdir) 00:02:00 Change File Permissions (chmod) 00:06:00 Section 05: Text Files File Concatenation (cat) 00:03:00 File Perusal Filter (more/less) 00:02:00 Terminal Based Text Editor (nano) 00:03:00 Section 06: Users Run Commands As A Superuser (sudo) 00:03:00 Change User (su) 00:03:00 Show Effecter User and Group IDs (id) 00:02:00 Section 07: Killing Programs & Logging Out Kill A Running Command (ctrl + c) 00:02:00 Kill All Processes By A Name (killall) 00:02:00 Logging Out Of Bash (exit) 00:01:00 Section 08: Shortcuts Tell Bash That There Is No More Input (ctrl + d) 00:02:00 Clear The Screen (ctr + l) 00:02:00 Zoom In (ctrl + +) 00:02:00 Zoom Out (ctrl + -) 00:02:00 Moving The Cursor 00:02:00 Deleting Text 00:04:00 Fixing Typos 00:03:00 Cutting and Pasting 00:03:00 Character Capitalisation 00:03:00 Section 09: Bash Bash File Structure 00:03:00 Echo Command 00:04:00 Comments 00:04:00 Variables 00:06:00 Strings 00:06:00 While Loop 00:04:00 For Loop 00:04:00 Until Loop 00:03:00 Break & Continue 00:03:00 Get User Input 00:02:00 If Statement 00:09:00 Case Statements 00:06:00 Get Arguments From The Command Line 00:04:00 Functions 00:05:00 Global vs Local Variables 00:03:00 Arrays 00:06:00 Shell & Environment Variables 00:06:00 Scheduled Automation 00:03:00 Aliases 00:03:00 Wildcards 00:03:00 Multiple Commands 00:02:00 Section 10: Resource Resource 00:00:00 Assignment Assignment - Bash Scripting; Linux and Shell Programming Masterclass 00:00:00

Microsoft Excel Complete Course - Beginner Intermediate & Advanced To make learning Microsoft Excel easier for you, we have thoughtfully bundled our three greatest courses: Microsoft Excel Beginners, Intermediate, and Advanced. At this price, you won't find a better deal anywhere else. One of the most popular applications for visualizing and analyzing data that has been created to date is Microsoft Excel. These days, practically every industry and household use this helpful program for personal purposes. Excel is used by business owners for a plethora of tasks, including data analysis, visualizing data, tracking hours worked, money, and statements. This Microsoft Excel Complete Course can be very helpful to you whether you are a newbie, have some training and experience with the program, or haven't used Excel in a long time and need a thorough refresher to develop your skills. After completing this course, you will be a proficient Excel user. In a short period of time, our simple lessons will impart the knowledge in a very easy way. There won't be a rush because you can study whenever you want and at your own speed. After completing the course, your confidence in using Excel will increase. Course Highlights Microsoft Excel Complete Course - Beginner Intermediate & Advanced is an award winning and the best selling course that has been given the CPD Certification & 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 Microsoft Excel Complete Course - Beginner Intermediate & Advanced into 73 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 11 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 Microsoft Excel Complete Course - Beginner Intermediate & Advanced 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? Microsoft Excel Complete Course - Beginner Intermediate & Advanced 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 Microsoft Excel Complete Course - Beginner Intermediate & Advanced 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. Microsoft Excel Complete Course - Beginner Intermediate & Advanced Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started With Microsoft Office Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:28:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying A Worksheet 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 Formatting A Worksheet Apply Text Formats 00:16: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:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working With Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:24:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working With Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:06:00 Visualizing Data With Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:13:00 Using PivotTables And Pivot Charts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with Pivot Charts 00:08:00 Filter Data by Using Timelines and Slicers 00:11:00 Working With Multiple Worksheets And Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:06:00 Using Lookup Functions And Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:09:00 Sharing And Protecting Workbooks Collaborate on a Workbook 00:20:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines And Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:09:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Excel Templates Excel Templates 00:00:00 Resources Microsoft Excel 2019 00:00:00 Assignment Assignment - Microsoft Excel Complete Course - Beginner Intermediate & Advanced 00:00:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special IT Support Technician Training Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The IT Support Technician Training Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This IT Support Technician Training Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This IT Support Technician Training Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this IT Support Technician 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 IT Support Technician 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 IT Support Technician Training course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This IT Support Technician Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.This IT Support Technician 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 As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This IT Support Technician Training is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: How People Use Computers The Case for Computer Literacy 00:03:00 Features Common to Every Computing Device 00:02:00 Common General-Purpose Computing Devices 00:02:00 Networks of Computing Devices 00:04:00 Remotely-Accessed Computer Systems 00:04:00 Specialized Computer Systems 00:02:00 Specialty I/O Devices 00:01:00 Section 02: System Hardware CPUs 00:03:00 Passive and Active Cooling 00:03:00 RAM and Active Memory 00:05:00 Motherboards 00:03:00 Power Supplies 00:03:00 AMA - Ask Me Anything about System Hardware 00:07:00 Section 03: Device Ports and Peripherals Ports and Connectors 00:03:00 General Use I/O Devices 00:02:00 AMA - Ask Me Anything about I/O, Ports and Peripherals 00:07:00 Section 04: Data Storage and Sharing Basics of Binary 00:04:00 Storage Technologies 00:04:00 Mass Storage Variation 00:03:00 AMA - Ask Me Anything about Data Storage and Sharing 00:07:00 Section 05: Understanding Operating Systems Operating System Functions 00:04:00 Operating System Interfaces 00:05:00 AMA - Ask Me Anything about Understanding OS's 00:05:00 Section 06: Setting Up and Configuring a PC Preparing the Work Area 00:02:00 Setting up a Desktop PC 00:01:00 Completing PC Setup 00:04:00 AMA - Ask Me Anything about Setting up and Configuring a PC 00:09:00 Section 07: Setting Up and Configuring a Mobile Device Personalizing a Tablet 00:08:00 AMA - Ask Me Anything about Mobile Devices Part 1 00:07:00 AMA - Ask Me Anything about Mobile Devices Part 2 00:07:00 Section 08: Managing Files File Management Tools 00:02:00 File Manipulation 00:06:00 Backups 00:03:00 AMA - Ask Me Anything about Managing Files 00:08:00 Section 09: Using and Managing Application Software Walking Survey of Applications 00:03:00 Managing Applications 00:03:00 Applications and Extensions 00:04:00 AMA - Ask Me Anything about Working with Applications 00:07:00 Section 10: Configuring Network and Internet Connectivity Wi-Fi Setup 00:06:00 Going High Speed 00:03:00 Setting Up and Sharing Printers 00:05:00 AMA - Ask Me Anything about Networks and Internet Connectivity Part 1 00:07:00 AMA - Ask Me Anything about Networks and Internet Connectivity Part 2 00:05:00 Section 11: IT Security Threat Mitigation Physical Security 00:05:00 Dealing with Malware 00:03:00 Password Management 00:03:00 Clickworthy 00:03:00 Perils of Public Internet 00:02:00 AMA - Ask Me Anything about IT Threat Mitigation Part 1 00:07:00 AMA - Ask Me Anything about IT Threat Mitigation Part 2 00:08:00 Section 12: Computer Maintenance and Management Power Management 00:02:00 Cleaning and Maintaining Computers 00:02:00 Trash it or Stash it? 00:02:00 AMA - Ask Me Anything about Computer Maintenance and Management 00:11:00 Section 13: IT Troubleshooting Troubleshooting 101 00:03:00 AMA - Ask Me Anything about Troubleshooting Computers Part 1 00:10:00 AMA - Ask Me Anything about Troubleshooting Computers Part 2 00:11:00 Section 14: Understanding Databases Introduction to Databases 00:06:00 Database Details 00:06:00 AMA - Ask Me Anything about Databases 00:06:00 Section 15: Developing and Implementing Software Introduction to Programming 00:04:00 Programming with a PBJ Sandwich 00:08:00 AMA - Ask Me Anything about Databases 00:06:00

Overview This comprehensive course on NodeJS made easy for MEAN or MERN Stack Level 4 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This NodeJS made easy for MEAN or MERN Stack Level 4 comes with accredited certification from CPD, 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 NodeJS made easy for MEAN or MERN Stack Level 4. It is available to all students, of all academic backgrounds. Requirements Our NodeJS made easy for MEAN or MERN Stack Level 4 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 14 sections • 116 lectures • 06:46:00 total length •Module 01: Course and Instructor Introduction: 00:03:00 •Module 02: GITHub URL: 00:01:00 •Module 01: What is Node?: 00:05:00 •Module 02: Why Node?: 00:04:00 •Module 03: NodeJS package manager NPM: 00:02:00 •Module 04: Install Node and Visual Studio Code: 00:02:00 •Module 01: Create a simple node application: 00:04:00 •Module 02: Adding Dependencies: 00:04:00 •Module 03: OS Module: 00:05:00 •Module 04: Write a file sync and async: 00:07:00 •Module 05: Use Arrow Functions: 00:02:00 •Module 06: Append and Rename: 00:03:00 •Module 07: Read and Delete: 00:04:00 •Module 08: HTTP module in action: 00:03:00 •Module 09: Return JSON Response: 00:04:00 •Module 10: Use nodemon: 00:02:00 •Module 11: Scripts block: 00:04:00 •Module 01: Introduction 04: 00:04:00 •Module 02: What is REST?: 00:06:00 •Module 03: Create an Express App: 00:02:00 •Module 04: Express In Action: 00:05:00 •Module 05: Handle other HTTP Methods: 00:06:00 •Module 06: Use Router: 00:05:00 •Module 07: Create Customer Endpoint: 00:05:00 •Module 01: Introduction 05: 00:02:00 •Module 02: Mongo Command Line: 00:07:00 •Module 03: Steps: 00:03:00 •Module 04: Use Mongo Client: 00:04:00 •Module 05: Implement Find All: 00:04:00 •Module 06: GET single product: 00:04:00 •Module 07: What is body-parser?: 00:03:00 •Module 08: Configure body-parser: 00:02:00 •Module 09: Create Product: 00:04:00 •Module 10: Update Product: 00:06:00 •Module 11: Delete Product: 00:02:00 •Module 01: Introduction 06: 00:04:00 •Module 02: Steps: 00:01:00 •Module 03: Create Project: 00:06:00 •Module 04: Create Server JS: 00:02:00 •Module 05: Create and Configure Product Controller: 00:02:00 •Module 06: Create Mongoose Schema and Model: 00:02:00 •Module 07: Create: 00:04:00 •Module 08: Test and Flow: 00:03:00 •Module 09: Read: 00:03:00 •Module 10: Update: 00:04:00 •Module 11: Delete: 00:02:00 •Module 01: Introduction 07: 00:01:00 •Module 02: Steps 7: 00:01:00 •Module 03: Create the Project 7: 00:02:00 •Module 04: Get All: 00:02:00 •Module 05: Create and Update: 00:04:00 •Module 06: Get and Delete: 00:03:00 •Module 01: Mocha and Chai: 00:03:00 •Module 02: Steps 8: 00:02:00 •Module 03: Install Dependencies: 00:01:00 •Module 04: First Test: 00:06:00 •Module 05: Handle Failures: 00:02:00 •Module 06: Test Create and Get: 00:02:00 •Module 07: Before and after methods: 00:03:00 •Module 01: Introduction 09: 00:03:00 •Module 02: Steps 09: 00:03:00 •Module 03: Create DB Connection: 00:04:00 •Module 04: Mongoose Static Methods: 00:03:00 •Module 05: Create the Model and DAO: 00:07:00 •Module 06: Create the Controller: 00:08:00 •Module 07: Map Routes: 00:05:00 •Module 08: Test: 00:02:00 •Module 09: Use src folder: 00:02:00 •Module 10: Use Babel and ES6 Syntax: 00:06:00 •Module 01: Usecase: 00:01:00 •Module 02: Create the Project: 00:03:00 •Module 03: Setup Configuration: 00:04:00 •Module 04: Create Model: 00:05:00 •Module 05: Implement Patient DAO: 00:03:00 •Module 06: Create Patient Controller: 00:04:00 •Module 07: Create and Configure Routes: 00:03:00 •Module 08: Create Clinical DAO and Controller: 00:07:00 •Module 09: Run and Test: 00:06:00 •Module 10: Fix Bug and Test: 00:02:00 •Module 01: Introduction 11: 00:02:00 •Module 02: Install Docker Desktop: 00:01:00 •Module 03: Steps: 00:03:00 •Module 04: Create Dockerfile: 00:07:00 •Module 05: Create docker-compose.yml: 00:05:00 •Module 06: docker compose up: 00:05:00 •Module 01: Introduction 12: 00:01:00 •Module 02: AWS EC2 Introduction: 00:03:00 •Module 03: Launch an EC2 Instance: 00:05:00 •Module 04: Windows - Use MobaXterm and connect: 00:04:00 •Module 05: Install Mongo: 00:04:00 •Module 06: Install Node and Git: 00:02:00 •Module 07: Push Project to Github: 00:04:00 •Module 08: Run the APP on EC2 and Test: 00:04:00 •Module 01: Introduction 13: 00:01:00 •Module 02: Install React CLI: 00:01:00 •Module 03: Create Project: 00:06:00 •Module 04: Create Components: 00:03:00 •Module 05: Configure Routing: 00:04:00 •Module 06: Home Component: 00:03:00 •Module 07: Use State and React Hook: 00:04:00 •Module 08: Render Rows: 00:03:00 •Module 09: Enable CORS on the Node Project: 00:04:00 •Module 10: Test Home Page: 00:03:00 •Module 11: Add Patient - Create Form: 00:05:00 •Module 12: Handle Submit: 00:04:00 •Module 13: Add Clinical's - Create Form: 00:07:00 •Module 14: Add Clinical's - Handle Submit: 00:04:00 •Module 01: Introduction 14: 00:02:00 •Module 02: Steps 14: 00:01:00 •Module 03: Setup the database: 00:03:00 •Module 04: Setup Project: 00:02:00 •Module 05: Get All: 00:05:00 •Module 06: Get One: 00:03:00 •Module 07: Create: 00:04:00 •Module 08: Return after Insert: 00:02:00 •Module 09: Update: 00:03:00