609 Computer Skills courses delivered Online

Overview This comprehensive course on Computer Science: Graph Theory Algorithms will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Computer Science: Graph Theory Algorithms comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Computer Science: Graph Theory Algorithms. It is available to all students, of all academic backgrounds. Requirements Our Computer Science: Graph Theory Algorithms 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 17 sections • 44 lectures • 08:37:00 total length •Promo: 00:03:00 •Introduction: 00:14:00 •Common Problem: 00:10:00 •Depth First Search: 00:11:00 •Breadth First Search: 00:08:00 •Breadth First Search Shortest Path on a Grid: 00:17:00 •Storage and Representation of Trees: 00:10:00 •Beginner Tree Algorithms: 00:10:00 •Rooting Tree: 00:05:00 •Center(s) of a Tree: 00:06:00 •Isomorphisms in Trees: 00:11:00 •Isomorphisms in Trees Source Code: 00:10:00 •Lowest Common Ancestor: 00:17:00 •Topological Sort: 00:14:00 •Shortest and Longest Paths on DAGs: 00:10:00 •Khan's Algorithm: 00:13:00 •Dijkstra's Shortest Path Algorithm: 00:25:00 •Dijkstra's Shortest Path Algorithm Source Code: 00:09:00 •Bellman-Ford Algorithm: 00:15:00 •Floyd-Warshall Algorithm: 00:16:00 •Floyd-Warshall Algorithm Source Code: 00:09:00 •Algorithm to Find Bridges and Articulation Points: 00:20:00 •Algorithm to Find Bridges and Articulation Points Source Code: 00:09:00 •Tarjan's Algorithm for Finding Strongly Connected Components: 00:17:00 •Tarjan's Algorithm for Finding Strongly Connected Components Source Code: 00:07:00 •Travelling Salesman Problem (TSP) with Dynamic Programming: 00:21:00 •Travelling Salesman Problem (TSP) with Dynamic Programming Source Code: 00:14:00 •Existence of Eulerian Paths and Circuit: 00:10:00 •Finding Eulerian Paths and Circuits: 00:16:00 •Eulerian Paths Source Code: 00:08:00 •Prim's Minimum Spanning Tree Algorithm (Lazy Version): 00:15:00 •Prim's Minimum Spanning Tree Algorithm ( Eager Version): 00:15:00 •Prim's Minimum Spanning Tree Algorithm Source Code ( Eager Version): 00:09:00 •Max Flow Ford-Fulkerson Method: 00:13:00 •Max Flow Ford-Fulkerson Method Source Code: 00:17:00 •Network Flow: Unweighted Bipartite Graph Matching: 00:11:00 •Network Flow: Mice and Owls: 00:08:00 •Network Flow: Elementary Math: 00:11:00 •Network Flow: Edmond-Karp Algorithm: 00:06:00 •Network Flow: Edmond-Karp Algorithm Source Code: 00:10:00 •Network Flow: Capacity Scaling: 00:10:00 •Network Flow: Capacity Scaling Source Code: 00:06:00 •Network Flow: Dinic's Algorithm: 00:12:00 •Network Flow: Dinic's Algorithm Source Code: 00:09:00

Overview This comprehensive course on Complete Microsoft Access Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Complete Microsoft Access Course 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 Complete Microsoft Access Course. It is available to all students, of all academic backgrounds. Requirements Our Complete Microsoft Access Course 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 3 sections • 58 lectures • 08:04:00 total length •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 Table Data: 00:17:00 •Sort and Filter Records: 00:05:00 •Create Basic Queries: 00:15:00 •Sort and Filter Data in a Query: 00:14:00 •Perform Calculations in a Query: 00:08:00 •Create Basic Access Forms: 00:07:00 •Work with Data on Access Forms: 00:23:00 •Create a Report: 00:12: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 •Relational Database Design: 00:16:00 •Create a Table: 00:09:00 •Create Table Relationships: 00:09:00 •Create Query Joins: 00:14:00 •Relate Data Within a Table.avi: 00:04:00 •Work with Subdatasheets from: 00:05:00 •Use Field Validation: 00:16:00 •Use Form and Record Validation: 00:14:00 •Create Parameter Queries: 00:12:00 •Summarize Data: 00:06:00 •Create Subqueries: 00:07:00 •Create Action Queries: 00:05:00 •Create Unmatched and Duplicate Queries: 00:06:00 •Data Normalization: 00:10:00 •Create a Junction Table: 00:04:00 •Improve Table Structure: 00:06:00 •Include Control Formatting in a Report: 00:04:00 •Add a Calculated Field to a Report: 00:05:00 •Add a Subreport to an Existing Report: 00:07:00 •Add Controls to Forms: 00:11:00 •Enhance Navigation and Organization of Forms: 00:14:00 •Apply Conditional Formatting: 00:04:00 •Import Data into Access: 00:08:00 •Export Access Data: 00:06:00 •Link Tables to External Data Sources: 00:05:00 •Create a Mail Merge: 00:02:00 •Create a Macro: 00:08:00 •Restrict Records by Using a Condition: 00:04:00 •Validate Data by Using a Macro: 00:05:00 •Automate Data Entry by Using a Macro: 00:04:00 •Manage a Database: 00:08:00 •Determine Object Dependency: 00:04:00 •Manage a Database: 00:07:00 •Determine Object Dependency: 00:04:00 •Document a Database: 00:04:00 •Splitting a Database for Multiple User Access: 00:05:00 •Implement Security: 00:03:00 •Convert an Access Database to an ACCDE File: 00:04:00 •Package a Database with a Digital Signature: 00:01:00 •Create a Database Switchboard: 00:05:00 •Modify a Database Switchboard: 00:02:00 •Set Start up Options: 00:04:00

Overview This comprehensive course on HTML and CSS Coding: Beginner to Advanced will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This HTML and CSS Coding: Beginner to Advanced 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 HTML and CSS Coding: Beginner to Advanced. It is available to all students, of all academic backgrounds. Requirements Our HTML and CSS Coding: Beginner to Advanced 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 13 sections • 127 lectures • 11:50:00 total length •Introduction: 00:03:00 •Course Curriculum: 00:07: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 •Introduction: 00:05:00 •Choosing Code Editor: 00:06:00 •Installing Code Editor (Sublime Text): 00:04:00 •Overview of a Webpage: 00:05:00 •Full HTML Code Page: 00:07:00 •First Hello World! Webpage: 00:09:00 •Introduction: 00:03:00 •Heading: 00:09:00 •Paragraph: 00:08:00 •Formatting Text: 00:12:00 •List Items Unordered: 00:05:00 •List Items Ordered: 00:04:00 •Classes: 00:09:00 •ID's in CSS: 00:06:00 •Comments in HTML: 00:04:00 •Summary: 00:04:00 •Introduction: 00:02:00 •Images: 00:12:00 •Forms: 00:05:00 •Form Actions: 00:04:00 •Br tag: 00:03: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 •Summary: 00:02:00 •Introduction: 00:02:00 •HTML5 Audio: 00:07:00 •HTML5 Video: 00:05:00 •Progress Bar: 00:04:00 •Drag and Drop: 00:18:00 •Canvas: 00:06:00 •I frames: 00:05:00 •Input Types: 00:04:00 •Input Attributes: 00:06:00 •YouTube Video Linking: 00:04:00 •Creating Responsive Page: 00:05:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Registration Form: 00:04:00 •Login Form: 00:04:00 •About Us Form: 00:02:00 •Contact Us Form: 00:10:00 •Footer Form: 00:03:00 •Integrate All Together: 00:07:00 •Coding Exercise: 00:01:00 •Solution for Coding Exercise: 00:02:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Challenge - HTML 5 Clock Face with Numbers: 00:05:00 •Project overview: 00:03:00 •Conclusion on Project: 00:01:00 •Summary: 00:02:00 •Introduction: 00:03:00 •CSS Syntax: 00:05:00 •Creating a first page with CSS Style: 00:13:00 •Inline CSS: 00:06:00 •Internal CSS: 00:05:00 •CSS External: 00:10:00 •CSS Classes: 00:09:00 •CSS IDs: 00:06:00 •Colors: 00:08:00 •Backgrounds: 00:04:00 •Floating: 00:09:00 •Positioning: 00:06:00 •Margins: 00:07:00 •Padding: 00:04:00 •Borders: 00:03:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Styling Text: 00:07:00 •Aligning Text: 00:04:00 •Styling Links: 00:10:00 •Font Family: 00:07:00 •Font Styles: 00:03:00 •Applying Google Fonts: 00:07:00 •Box Model: 00:09:00 •Icons: 00:09:00 •Tables: 00:16:00 •Navigation-Menu: 00:11:00 •Dropdowns: 00:15:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Advanced Selectors: 00:05:00 •Forms: 00:17:00 •Website Layout: 00:21:00 •Rounded Corners: 00:08:00 •Color Keywords: 00:06:00 •Animations: 00:08:00 •Pseudo Classes: 00:03:00 •Gradients: 00:03:00 •Shadows: 00:03:00 •Calculations: 00:05:00 •Creating Responsive Page: 00:06:00 •Summary: 00:02:00 •Introduction: 00:01:00 •Button Styles: 00:06:00 •Flexbox: 00:14:00 •CSS Grid: 00:15:00 •Pagination: 00:07:00 •Multiple Columns: 00:06:00 •Image Reflection: 00:03:00 •UI - UX Design: 00:09:00 •Social Media Icons: 00:08:00 •External CSS Style adding: 00:06:00 •Coding Exercise: 00:01:00 •Solution for Coding Exercise: 00:03:00 •Summary: 00:02:00 •Introduction: 00:01:00 •CSS Project Getting: 00:05:00 •CSS Project Overview: 00:08:00 •Summary: 00:01:00 •Introduction: 00:02:00 •Installing Free FTP Solution (FileZilla): 00:04:00 •Setting Up FTP (File Transfer Protocol): 00:03:00 •Publish Website to Hosting Server: 00:04:00 •Summary: 00:01:00

Overview This comprehensive course on MS Access Tables and Queries for Beginner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This MS Access Tables and Queries for Beginner 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 MS Access Tables and Queries for Beginner. It is available to all students, of all academic backgrounds. Requirements Our MS Access Tables and Queries for Beginner 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 2 sections • 20 lectures • 03:32:00 total length •Module 01: Tour of the screen: 00:11:00 •Module 02: Using Design view to create and edit tables: 00:45:00 •Module 03: Using the lookup wizard: 00:09:00 •Module 04: Importing data from Other Data Sources into Access: 00:18:00 •Module 05: Linking Tables from Other Data Sources into Access: 00:10:00 •Module 06: Exporting data from Access to other data types: 00:03:00 •Module 07: Creating and Managing Table Relationships: 00:10:00 •Module 08: Database Tools: 00:05:00 •Module 09: Sort and Filter a Table: 00:06:00 •Module 10: Basic Queries: 00:22:00 •Module 11: Prompting the user for the criteria: 00:05:00 •Module 12: Creating Calculated Fields in a Query: 00:10:00 •Module 13: Creating Totals Queries: 00:08:00 •Module 14: Multiple table Queries: 00:12:00 •Module 15: Viewing the SQL code for an Access Query: 00:06:00 •Module 16: Using the Query Wizards: 00:09:00 •Module 17: Creating Subqueries: 00:03:00 •Module 18: Creating Make Table, Append, Update and Delete Queries: 00:19:00 •Module 19: Displaying a certain number of records: 00:01:00 •Assignment - MS Access Tables and Queries for Beginner: 00:00:00

Overview No more hunt-and-peck. Transform yourself into an outstanding typist! Enrol in the Touch Typing course to boost your typing speed and efficiency, and take full advantage of what your device offers. All companies demand fast typists to produce high-quality documents with speed and accuracy. This course will provide you with developed skills for any keyboard-based device. Switching to touch typing can pay off in more ways than you can imagine. The comfort you get also helps improve posture. Upgrade your skills to improve your career prospects, and pave the way to success! How will I get my certificate? At the end of the course there will be an online MCQ test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Touch Typing. It is available to all students, of all academic backgrounds. Requirements Our Touch Typing is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 12 lectures • 01:00:00 total length •Module 01: Getting Started: 00:05:00 •Module 02: DRILL 1 The home keys: 00:05:00 •Module 03: DRILL 2 e and i, g and h: 00:05:00 •Module 04: DRILL 3 o and n, shift keys and t: 00:05:00 •Module 05: DRILL 4 extra practice . and y: 00:05:00 •Module 06: DRILL 5 , and w: 00:05:00 •Module 07: DRILL 6 m and u: 00:05:00 •Module 08: DRILL 7 v and x: 00:05:00 •Module 09: DRILL 8 sentence drills: 00:05:00 •Module 10: DRILL 9 figures: 00:05:00 •Module 11: DRILL 10 alphabetical paragraphs: 00:05:00 •Module 12: Recap: 00:05:00

Overview This comprehensive course on ChatGPT Masterclass: A Complete ChatGPT Zero to Hero  will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This ChatGPT Masterclass: A Complete ChatGPT Zero to Hero 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 ChatGPT Masterclass: A Complete ChatGPT Zero to Hero. It is available to all students, of all academic backgrounds. Requirements Our ChatGPT Masterclass: A Complete ChatGPT Zero to Hero 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 9 sections • 38 lectures • 02:45:00 total length •Introduction: 00:04:00 •Start on Windows, macOS, and Linux: 00:01:00 •How to ask great questions: 00:02:00 •FAQs: 00:01:00 •What is ChatGPT: 00:05:00 •Create a ChatGPT account@: 00:06:00 •How to use ChatGPT: 00:10:00 •ChatGPT for day-to-day activities: 00:04:00 •Advanced ChatGPT Plus: 00:05:00 •ChatGPT for programmers: 00:12:00 •Improve Problem-solving skills: 00:06:00 •Create an Algorithms: 00:06:00 •How to build a website with ChatGPT: 00:05:00 •Develop a Stunning Landing page for product sales: 00:07:00 •Create a Documentation: 00:03:00 •Code Debugging with ChatGPT: 00:05:00 •The Best Businesses Ideas to start with ChatGPT: 00:05:00 •SEO Basics for your website: 00:06:00 •How to make an online course using ChatGPT: 00:05:00 •Selling Competitive products with ChatGPT: 00:04:00 •Exercise on real-world sales query: 00:01:00 •Solution for an exercise: 00:02:00 •ChatGPT to Prepare Resume: 00:03:00 •Interview preparation with ChatGPT: 00:05:00 •ChatGPT for PowerPoint content: 00:03:00 •Innovative Job Searching using ChatGPT: 00:04:00 •Write a short film with ChatGPT for Creative Fiction and Screenplays: 00:03:00 •Make the best diet plan for a day: 00:03:00 •Suggest a meal plan with seafood as the special ingredient: 00:03:00 •Write a Business Email for the franchise: 00:03:00 •Create Legal documents like sale deeds etc.: 00:03:00 •Sum with ChatGPT: 00:05:00 •VLOOKUP with ChatGPT: 00:05:00 •Introduction to Dall-E 2: 00:04:00 •Dall-E 2 Creating 3D Graphic design: 00:03:00 •Dall-E 2 Deep Dive in Editing your own image: 00:04:00 •How to Make Money with Dall-E 2: 00:03:00 •Integrating ChatGPT with Google Search: 00:06:00

Overview This comprehensive course on Microsoft Excel - 25 Must-Know Formulas and Functions will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel - 25 Must-Know Formulas and Functions 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 Microsoft Excel - 25 Must-Know Formulas and Functions. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel - 25 Must-Know Formulas and Functions 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 2 sections • 2 lectures • 01:12:00 total length •Must-Know Formulas and Functions: 01:12:00 •Resource - Microsoft Excel - 25 Must-Know Formulas and Functions: 00:00:00

Overview This comprehensive course on CNC Programming will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This CNC Programming  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 CNC Programming. It is available to all students, of all academic backgrounds. Requirements Our CNC Programming 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 1 sections • 16 lectures • 01:19:00 total length •Section 01: Scope of the Course: 00:03:00 •Section 02: Numerical Control of Machine Tools: 00:04:00 •Section 03: CNC- Computer Numerical Control Syst: 00:02:00 •Section 04: Components of CNCs: 00:04:00 •Section 05: Point to Point CNC Machines: 00:03:00 •Section 06: Incremental & Absolute CNC Machines: 00:03:00 •Section 07: Open & Close Control Loop CNC Machines: 00:02:00 •Section 08: 2 &3 Axes CNC Machines: 00:02:00 •Section 09: Importance of Higher axes Machining: 00:02:00 •Section 10: Programming Format: 00:06:00 •Section 11: Cartesian Coordinate System: 00:03:00 •Section 12: How to Write a Program: 00:08:00 •Section 13: Basic CNC Programming (Absolute Mode): 00:09:00 •Section 14: Basic CNC Programming (Incremental): 00:04:00 •Section 15: A Simple Coding Exercise: 00:17:00 •Section 16: Applications of CNC: 00:07:00

Overview Master the use of the world's most popular data analysis and office tool, with absolutely no previous experience or training needed.This course will help you quickly become an expert in the use of Microsoft's best-selling Excel, allowing you to be a valuable asset to any business or organisation.The Microsoft Excel Level 3course will teach you how to manage finances, produce spreadsheets, and file invoices in no time. Our innovative training method will have you visualising and presenting company data efficiently. Learn to impress your peers and managers with your intuitive use of Excel and make sure that your administration skills are faultless. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel Level 3. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel Level 3 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 21 sections • 73 lectures • 10:39:00 total length •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 •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: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 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09: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:06:00 •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 •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 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •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 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Collaborate on a Workbook: 00:19:00 •Protect Worksheets and Workbooks: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •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 •Excel Templates: 00:00:00 •Resources - Microsoft Excel - Beginner Course - Cpd Accredited: 00:00:00 •Assignment - Microsoft Excel Level 3: 00:00:00

Overview This comprehensive course on Advanced Excel Course (Formula, VLOOKUP & Power Query) will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Advanced Excel Course (Formula, VLOOKUP & Power Query) 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 Advanced Excel Course (Formula, VLOOKUP & Power Query). It is available to all students, of all academic backgrounds. Requirements Our Advanced Excel Course (Formula, VLOOKUP & Power Query) 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 5 sections • 41 lectures • 02:56:00 total length •How to Get the most of the course: 00:01:00 •Text formulas in Excel: 00:08:00 •Text Formulas Exercise: 00:01:00 •Text Formulas Exercise (answers): 00:01:00 •Mathematical Formulas In Excel: 00:04:00 •Mathematical Formulas Exercise: 00:01:00 •Mathematical Formulas Exercise (answers): 00:01:00 •Date and Time Formulas In Excel: 00:05:00 •Date and Time Formulas Exercise: 00:01:00 •Date and Time Exercise Formulas (answers): 00:01:00 •Logic Formulas In Excel: 00:12:00 •Logic Formula Exercise: 00:01:00 •Logic Formula Exercise (answers): 00:01:00 •Financial Formula In Excel: 00:06:00 •Financial Formula Exercise: 00:01:00 •Financial Formula Exercise (answers): 00:02:00 •Informational Formula In Excel: 00:04:00 •Informational Formula Exercise: 00:01:00 •Informational Formula Exercise (answers): 00:01:00 •Menu Example with Excel Vlookup: 00:08:00 •Wildcard Search with Excel Vlookup: 00:09:00 •Looking to the Left with Excel Vlookup: 00:17:00 •2-Way Lookup: 00:14:00 •Comparing Lists with Excel Vlookup: 00:03:00 •Microsoft Excel Vlookup Tips and Tricks: 00:14:00 •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Enabling M in Power Query: 00:02:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Simple Expressions: 00:08:00 •Simple Expressions - Nested Expressions: 00:03:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Variables: 00:08:00 •Formatting Excel Keyboard Shortcuts: 00:02:00 •Table Excel Keyboard Shortcuts: 00:02:00 •Editing Excel Keyboard Shortcuts: 00:05:00 •Formula Excel Keyboard Shortcuts: 00:03:00 •Workbook Excel Keyboard Shortcuts: 00:02:00 •Handy Excel Shortcuts Keyboard Shortcuts: 00:05:00 •Assignment - Advanced Excel Course (Formula, VLOOKUP & Power Query): 00:00:00