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

5812 Computing courses in Penistone delivered Online

Mastering Java for Beginners & Experts

4.9(27)

By Apex Learning

Overview This comprehensive course on Mastering Java for Beginners & Experts will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Mastering Java for Beginners & Experts 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 Mastering Java for Beginners & Experts. It is available to all students, of all academic backgrounds. Requirements Our Mastering Java for Beginners & Experts 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 • 70 lectures • 05:35:00 total length •Introduction To This Course.: 00:02:00 •Setup Eclipse On Windows: 00:05:00 •Setup Eclipse On Mac OS X: 00:05:00 •Setup Eclipse On Linux: 00:05:00 •Run Code Online: 00:02:00 •Printing To The Console: 00:04:00 •Comments.: 00:06:00 •Variables.: 00:05:00 •Datatypes: 00:16:00 •Constant Variables: 00:03:00 •Console Input: 00:04:00 •Operators: 00:06:00 •If statement (Conditional Statement): 00:08:00 •Switch statement (Conditional Statement): 00:07:00 •For Loop.: 00:05:00 •While Loop.: 00:05:00 •Do While Loop.: 00:05:00 •Loop Control Statements: 00:03:00 •Numbers: 00:08:00 •Characters: 00:06:00 •Strings.: 00:05:00 •Arrays: 00:08:00 •For Each Loop: 00:04:00 •Date & Time: 00:04:00 •Regular Expressions.: 00:07:00 •Simple Example 1: 00:05:00 •Passing Values To Functions: 00:03:00 •Method Overloading: 00:05:00 •Command Line Arguments: 00:04:00 •Multiple Arguments Simplified: 00:06:00 •Byte Streams: 00:07:00 •Character Streams: 00:02:00 •Standard Streams: 00:04:00 •Listing Files & Folders: 00:02:00 •Creating Folders: 00:02:00 •Simple Example 2: 00:05:00 •Multiple Catch Blocks: 00:04:00 •Throw and Throws Keywords: 00:03:00 •Finally Block: 00:03:00 •User Created Exceptions: 00:08:00 •Simple Class Example: 00:08:00 •Constructor: 00:04:00 •This keyword: 00:05:00 •Inheritance.: 00:06:00 •Modifier Types: 00:04:00 •Overriding: 00:05:00 •Abstraction: 00:05:00 •Interfaces: 00:04:00 •Enum: 00:03:00 •Stacks.: 00:04:00 •Vector.: 00:06:00 •BitSet: 00:05:00 •Properties: 00:05:00 •Hashtable: 00:04:00 •List.: 00:04:00 •Set.: 00:04:00 •SortedSet: 00:03:00 •Map: 00:03:00 •Map.Entry: 00:03:00 •Sorted Map: 00:02:00 •Enumeration.: 00:05:00 •Client Example.: 00:07:00 •Server Example.: 00:11:00 •Creating Threads Using a Runnable Interface: 00:09:00 •Creating Threads by Extending a Thread Class: 00:03:00 •Simple Example 3: 00:04:00 •Keyboard Events: 00:04:00 •Mouse Events: 00:04:00 •Resource.: 00:00:00 •Assignment - Mastering Java for Beginners & Experts: 00:00:00

Mastering Java for Beginners & Experts
Delivered Online On Demand5 hours 35 minutes
£12

Workshop Technology: Machine Shop Theory

4.9(27)

By Apex Learning

Overview This comprehensive course on Workshop Technology: Machine Shop Theory will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Workshop Technology: Machine Shop Theory 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? At the end of the course there will be an online written 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 Workshop Technology: Machine Shop Theory. It is available to all students, of all academic backgrounds. Requirements Our Workshop Technology: Machine Shop Theory 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 9 sections • 41 lectures • 02:20:00 total length •Scope of the Course: 00:10:00 •Metal Cutting Processes: 00:02:00 •Cutting Tools: 00:03:00 •Nomenclature of Single Point Cutting Tool: 00:04:00 •Tool Signature: 00:02:00 •Mechanics of Metal Cutting: 00:04:00 •Types of Chips: 00:03:00 •Coolant or Cutting Fluids: 00:03:00 •Types of Lathe Machine: 00:09:00 •Construction of A Lathe: 00:09:00 •Accessories and Attachments: 00:07:00 •Specification of Lathe: 00:02:00 •Lathe Operations: 00:02:00 •Taper and Taper Turning: 00:04:00 •Thread Cutting: 00:03:00 •Cutting Speed and Feed: 00:02:00 •Construction of A Drilling Machine: 00:04:00 •Types of Drilling Machine: 00:09:00 •Types of Drills: 00:03:00 •Twist Drill Geometry: 00:04:00 •Drilling Operations: 00:05:00 •Size of Drilling Machine: 00:01:00 •Cutting Speed and Feed: 00:02:00 •Working Principle: 00:03:00 •Types of Shaper: 00:01:00 •Parts of Shaper: 00:05:00 •Shaper Mechanism: 00:04:00 •Shaper Operations: 00:01:00 •Types of Planer: 00:01:00 •Working Principle: 00:02:00 •Difference Between Shaper and Planer: 00:02:00 •Principle Parts of Slotter: 00:03:00 •Slotter Operations: 00:02:00 •Working Principle: 00:02:00 •Milling Methods: 00:03:00 •Types of Milling Cutters: 00:01:00 •Types of Milling Machines: 00:07:00 •Size of Milling Machine: 00:01:00 •Indexing and Dividing Head: 00:02:00 •Milling Operations: 00:03:00 •Assignment - Workshop Technology: Machine Shop Theory: 00:00:00

Workshop Technology: Machine Shop Theory
Delivered Online On Demand2 hours 20 minutes
£12

Comprehensive Guide to Functional Maths with Integers to Fractions

By NextGen Learning

Functional Skills Maths is essential for everyday life, from calculating bills to working out a discount in a sale. Understanding integers, fractions, decimals, percentages, and ratios are all necessary skills that are needed to function in modern society. Learning outcomes: Develop an understanding of integers and how to perform operations with them. Learn about factors, multiples, and simplification rules to solve numerical problems. Develop an understanding of fractions, decimals, and rational numbers and learn how to perform operations with them. Understand approximation, estimation, and scientific notation or standard form. Learn how to calculate percentages and ratios and how to apply them to real-life situations. Understand profit, loss, discount, and tax and learn how to calculate them in different scenarios. This Functional Skills Maths course covers a range of topics that are essential for daily life. Through this course, you will learn about integers, factors, multiples, fractions, decimals, rational numbers, approximation, estimation, scientific notation or standard form, percentages, ratios, and profit, loss, discount, and tax. This course aims to provide you with the knowledge and skills needed to function effectively in modern society. Whether you are a student, professional, or someone who wants to improve their math skills, this course is suitable for anyone who wants to develop their mathematical abilities. The course is delivered through online tutorials, quizzes, and video lectures, allowing you to learn at your own pace and in your own time. Upon completion of this course, you will be able to perform mathematical operations with integers, fractions, decimals, and percentages. You will be able to calculate ratios and apply them to real-life situations. You will also be able to understand profit, loss, discount, and tax and how to calculate them in different scenarios. Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Students who want to improve their math skills. Professionals who need to perform calculations as part of their job. Individuals who want to develop their mathematical abilities. Anyone who wants to improve their understanding of maths. Career path Accounting Assistant: £16,000 - £28,000 per year Sales Assistant: £14,000 - £22,000 per year Administrative Assistant: £16,000 - £24,000 per year Retail Supervisor: £18,000 - £28,000 per year Customer Service Representative: £16,000 - £24,000 per year Warehouse Operative: £14,000 - £22,000 per year

Comprehensive Guide to Functional Maths with Integers to Fractions
Delivered Online On Demand8 hours
£15

Test zoom link

By CodeCraft Academy

Test zoom link
Delivered OnlineFlexible Dates
FREE

CNC Programming

4.9(27)

By Apex Learning

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

CNC Programming
Delivered Online On Demand1 hour 19 minutes
£12

Excel Must know Formulas and Functions

4.9(27)

By Apex Learning

Overview This comprehensive course on Excel 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 Excel 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 Excel Must know Formulas and Functions. It is available to all students, of all academic backgrounds. Requirements Our Excel 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 • 13 lectures • 01:53:00 total length •Building basic math formulas: 00:08:00 •Autosum and Relative references: 00:09:00 •Absolute references: 00:06:00 •Named Ranges: 00:06:00 •Linking sheets and workbooks: 00:06:00 •If, And, Or, and the nested If functions: 00:16:00 •Countif, Sumif, Averageif, Sumifs, and Countifs functions: 00:09:00 •Vlookup and Hlookup functions: 00:15:00 •Match and Index functions: 00:07:00 •Date and time formulas and functions: 00:12:00 •Text functions: 00:11:00 •Tracing formulas: 00:08:00 •Assignment - Excel Must know Formulas and Functions: 00:00:00

Excel Must know Formulas and Functions
Delivered Online On Demand1 hour 53 minutes
£12

Coding with HTML, CSS, & Javascript

4.9(27)

By Apex Learning

Overview Enrol in our Coding with HTML, CSS, & Javascript today and build the necessary skills, knowledge and experience to transform your career. The Coding with HTML, CSS, & Javascript could enhance your continuing professional development thus propelling you more towards your dream job. This Coding with HTML, CSS, & Javascript could be your key, if you are interested in a long term career in the field of Coding with HTML, CSS, & Javascript. This Coding with HTML, CSS, & Javascript course consists of a number of easy to digest, in-depth modules which are designed to provide you with detailed knowledge on Coding with HTML, CSS, & Javascript. This Coding with HTML, CSS, & Javascript aims to accompany you through your journey to help you become a master of Coding with HTML, CSS, & Javascript. Learn through a mixture of interactive lessons and online study materials. 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 Coding with HTML, CSS, & Javascript. It is available to all students, of all academic backgrounds. Requirements Our Coding with HTML, CSS, & Javascript 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 7 sections • 66 lectures • 08:06:00 total length •1.1 Intro: 00:03:00 •1.2 Install the Tools and Get Started: 00:05:00 •2.1 Intro to HTML: 00:01:00 •2.2 What is HTML: 00:11:00 •2.3 Start a New HTML File & Use Tags: 00:12:00 •2.4 Header Tags: 00:05:00 •2.5 Edit Text: 00:09:00 •2.6 Links: 00:09:00 •2.7 Images: 00:10:00 •2.8 Lists: 00:04:00 •2.9 Challenge 1: 00:16:00 •2.10 HTML Outro: 00:01:00 •3.1 CSS Intro: 00:04:00 •3.2 Add CSS Styles: 00:16:00 •3.3 Classes and IDs: 00:07:00 •3.4 Borders: 00:06:00 •3.5 Sizing: 00:04:00 •3.6 Padding and Margin: 00:07:00 •3.7 Text Styles: 00:04:00 •3.8 DIVs: 00:08:00 •3.9 Postioning: 00:08:00 •3.10 Hover: 00:03:00 •3.11 Easily Center Elements: 00:02:00 •3.12 Fonts: 00:06:00 •3.13 Challenge: 00:23:00 •3.14 CSS Outro: 00:01:00 •4.1 Intro to Bootstrap: 00:02:00 •4.2 Install Bootstrap: 00:10:00 •4.3 Indenting and Containers: 00:07:00 •4.4 The Grid System: 00:16:00 •4.5 Images: 00:07:00 •4.6 Buttons: 00:06:00 •4.7 Challenge 3: 00:11:00 •4.8 Bootstrap Outro: 00:01:00 •5.1 Landing Page Intro: 00:01:00 •5.2 Sketch Your Landing Page: 00:05:00 •5.3 The Top Section: 00:16:00 •5.4 Polish the Top Section: 00:06:00 •5.5 Adding Images: 00:11:00 •5.6 The Main Points Section: 00:14:00 •5.7 Collecting Emails With an Opt-In Form: 00:11:00 •5.8 Challenge 4: 00:03:00 •5.9 Landing Page Outro: 00:02:00 •6.1 Business Site Intro: 00:01:00 •6.2 Sketch Up: 00:03:00 •6.3 Using Fancy Font Logo: 00:07:00 •6.4 Carousel Basics: 00:10:00 •6.5 Carousel Extras: 00:09:00 •6.6 Text on Images: 00:15:00 •6.7 Phone Number Icon: 00:04:00 •6.8 Google Maps: 00:13:00 •6.9 Font Awesome: 00:09:00 •6.10 Challenge 4: 00:08:00 •6.11 Business Site Outro: 00:01:00 •7.1 Intro: 00:01:00 •7.2 Portfolio Sketch: 00:08:00 •7.3 Jumbotron: 00:10:00 •7.4 Nav Bar: 00:24:00 •7.5 Panels: 00:11:00 •7.6 Challenge 5: 00:13:00 •7.7 Portfolio Outre: 00:01:00 •8.1 Hosting: 00:01:00 •8.2 Bluehost: 00:06:00 •8.3 Uploading: 00:05:00 •8.4 Tips: 00:11:00 •8.5 Hosting Outro: 00:01:00

Coding with HTML, CSS, & Javascript
Delivered Online On Demand8 hours 6 minutes
£12

50 Tips to Upgrade your Excel Skill

4.9(27)

By Apex Learning

Overview This comprehensive course on 50 Tips to Upgrade your Excel Skill will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This 50 Tips to Upgrade your Excel Skill 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 50 Tips to Upgrade your Excel Skill. It is available to all students, of all academic backgrounds. Requirements Our 50 Tips to Upgrade your Excel Skill 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 7 sections • 52 lectures • 02:57:00 total length •Welcome: 00:02:00 •Camera Tool: 00:05:00 •Add Line Break in Formula Bar: 00:03:00 •Advanced Copy-Paste using Office Clipboard: 00:03:00 •Navigation between Worksheets using Shortcut Keys: 00:01:00 •Flash Fill: 00:02:00 •Add Multiple Rows and Columns Quickly: 00:02:00 •Delete Blank Rows: 00:03:00 •Multi Level Row and Column Sorting: 00:04:00 •Add Sparklines: 00:03:00 •Paste Special - Transpose: 00:03:00 •Snap to Grid: 00:03:00 •Create Custom Auto fill List: 00:06:00 •Absolute Cell Reference: 00:03:00 •Import Data from Web page: 00:04:00 •Move Cell Direction: 00:03:00 •Delete Data using Mouse: 00:02:00 •Status Bar Quick Calculations: 00:03:00 •Link Text Boxes to Cell: 00:04:00 •Phone Number and ZIP Code Format: 00:04:00 •Speaking Cell: 00:05:00 •Invisible Text: 00:03:00 •Worksheet Grouping: 00:04:00 •Advanced Transpose: 00:04:00 •XLStart Folder: 00:03:00 •Use Slicers: 00:05:00 •Convert Text to Numbers: 00:03:00 •Hiding Workbook Elements: 00:02:00 •Useful Shortcut Keys: 00:03:00 •Sort data from Left to Right: 00:03:00 •Advanced Filter (Complex): 00:11:00 •Email as PDF: 00:02:00 •Synchronous Scrolling: 00:03:00 •Quick Analysis of data within Excel: 00:02:00 •Fill blank cells with Value: 00:03:00 •Hidden Chart Source Data: 00:03:00 •Two more Shortcuts: 00:03:00 •Add Blank Rows: 00:03:00 •Custom views in Excel: 00:06:00 •EMBED Feature: 00:04:00 •Adding Country code in Mobile Numbers: 00:04:00 •Plot an Average Line to a Chart: 00:04:00 •3D Referencing: 00:04:00 •Extract Unique Values: 00:03:00 •Excel Array Formula: 00:04:00 •Forecast Sheet: 00:04:00 •Add Spin Controls in Excel: 00:05:00 •Move Data using Mouse: 00:01:00 •Add new entry in Auto Correct to use across Office Applications: 00:05:00 •Find Differences between Two Lists: 00:02:00 •Find formulas Quickly: 00:02:00 •Thank You: 00:01:00

50 Tips to Upgrade your Excel Skill
Delivered Online On Demand2 hours 57 minutes
£12

Advanced Excel Course (Formula, VLOOKUP & Power Query)

4.9(27)

By Apex Learning

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

Advanced Excel Course (Formula, VLOOKUP & Power Query)
Delivered Online On Demand2 hours 56 minutes
£12

Intermediate Python Coding

4.9(27)

By Apex Learning

Overview This comprehensive course on Intermediate Python Coding will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Intermediate Python Coding 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 Intermediate Python Coding. It is available to all students, of all academic backgrounds. Requirements Our Intermediate Python Coding 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 10 sections • 59 lectures • 05:21:00 total length •Course Introduction: 00:02:00 •Course Curriculum: 00:05:00 •How to get Pre-requisites: 00:02:00 •Getting Started on Windows, Linux or Mac: 00:01:00 •How to ask Great Questions: 00:02:00 •Introduction to Class: 00:07:00 •Create a Class: 00:09:00 •Calling a Class Object: 00:08:00 •Class Parameters - Objects: 00:05:00 •Access Modifiers(theory): 00:10:00 •Summary: 00:02:00 •Introduction to methods: 00:06:00 •Create a method: 00:07:00 •Method with parameters: 00:12:00 •Method default parameter: 00:06:00 •Multiple parameters: 00:05:00 •Method return keyword: 00:04:00 •Method Overloading: 00:05:00 •Summary: 00:02:00 •Introduction to OOPs: 00:05:00 •Classes and Objects: 00:08:00 •Class Constructors: 00:07:00 •Assessment Test1: 00:01:00 •Solution for Assessment Test1: 00:03:00 •Summary: 00:01:00 •Introduction: 00:04:00 •Inheritance: 00:13:00 •Getter and Setter Methods: 00:12:00 •Polymorphism: 00:13:00 •Assessment Test2: 00:03:00 •Solution for Assessment Test2: 00:03:00 •Summary: 00:01:00 •Introduction: 00:03:00 •Access Modifiers (public, protected, private): 00:21:00 •Encapsulation: 00:07:00 •Abstraction: 00:07:00 •Summary: 00:02:00 •Introduction: 00:01:00 •Dice Game: 00:06:00 •Card and Deck Game Playing: 00:07:00 •Summary: 00:01:00 •Introduction: 00:01:00 •PIP command installations: 00:12:00 •Modules: 00:12:00 •Naming Module: 00:03:00 •Built-in Modules: 00:03:00 •Packages: 00:08:00 •List Packages: 00:03:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Reading CSV files: 00:11:00 •Writing CSV files: 00:04:00 •Summary: 00:01:00 •Introduction: 00:01:00 •Errors - Types of Errors: 00:08:00 •Try - ExceptExceptions Handling: 00:07:00 •Creating User-Defined Message: 00:05:00 •Try-Except-FinallyBlocks: 00:07:00 •Summary: 00:02:00

Intermediate Python Coding
Delivered Online On Demand5 hours 21 minutes
£12