983 Programming Languages courses

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

This course is focused on concepts of Python Boto3 Module and Lambda using Python. It covers how to use Boto3 module, concepts of Boto3 (session, resource, client, meta, collections, waiters, and paginators), and AWS Lambda to build real-time tasks with lots of step-by-step examples.

Learn to use Fusion 360 for large 3D print projects confidently, real-life model objects like a phone, and design 3D print parts to fit them precisely. Learn to create multiple 3D print parts that interact together, such as hinges, click systems, and more. Acquire 3D modeling knowledge to use these production methods and create unique designs.

Overview Learn AutoCAD Programming using VB.NET - Hands On! Course 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 Learn AutoCAD Programming using VB.NET - Hands On! Course 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 05 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. Unit 01: Introduction Module 01: Course Outline 00:05:00 Module 02: Introduction 00:01:00 Module 03: Who is this Course for? 00:01:00 Module 04: What will I learn from this Course? 00:01:00 Module 05: What is VB.NET? 00:01:00 Module 06: What is AutoCAD .NET API? 00:01:00 Module 07: What are the advantages of programming in AutoCAD .NET API? 00:01:00 Module 08: Hands-on Projects overview 00:06:00 Unit 02: Exploring AutoCAD .NET API Components Module 01: AutoCAD .NET API Components Overview 00:01:00 Module 02: AutoCAD .NET API Assemblies 00:02:00 Module 03: Understanding AutoCAD Object Hierarchy 00:03:00 Module 04: AutoCAD .NET API Application Object 00:02:00 Module 05: AutoCAD .NET API Document Object 00:02:00 Module 06: AutoCAD .NET API Database Object 00:04:00 Unit 03: Hello AutoCAD from VB.NET Module 01: Section Overview 00:04:00 Module 02: Installing Visual Studio 2019 00:05:00 Module 03: Setting up Visual Studio 2019 Integrated Development Environment (IDE) 00:04:00 Module 04: Creating First VB.NET Plugin (Hello AutoCAD) 00:12:00 Module 05: Different ways to communicate with the User 00:04:00 Module 06: Configuring VS2019 Target Processor 00:10:00 Unit 04: Creating AutoCAD Objects using VB.NET Module 01: Creating AutoCAD Object using VB.NET Overview 00:01:00 Module 02: Creating DrawObjects Project 00:04:00 Module 03: Creating a Line Object using VB.NET 00:15:00 Module 04: Creating a MText Object using VB.NET 00:12:00 Module 05: Creating a Circle Object using VB.NET 00:09:00 Module 07: Creating a Polyline Object using VB.NET 00:08:00 Module 08: Creating Multiple Circles Vertically 00:09:00 Module 09: Creating Multiple Circles Horizontally 00:05:00 Unit 05: Manipulating AutoCAD Objects using VB.NET Module 01: Manipulating AutoCAD Objects Overview 00:01:00 Module 02: Creating the Project ManipulateObjects 00:04:00 Module 03: Creating the SingleCopy Method 00:13:00 Module 04: Creating the MultipleCopy Method 00:11:00 Module 05: Creating the EraseObject Method 00:12:00 Module 06: Creating the MoveObject method 00:07:00 Module 07: Creating the MirrorObject method 00:10:00 Module 08: Creating the RotateObject method 00:07:00 Module 09: Creating the ScaleObject method 00:05:00 Module 10: Creating the OffsetObject method 00:05:00 Unit 06: Exploring AutoCAD Dictionaries using VB.NET Module 01: Exploring AutoCAD Dictionaries - Overview 00:02:00 Module 02: Creating LayersLineTypesAndStyles Project 00:06:00 Module 03: Creating the ListLayers Method 00:11:00 Module 04: Creating the CreateLayer Method 00:10:00 Module 05: Creating the UpdateLayer Method 00:12:00 Module 06: Creating the SetLayerOnOff Method 00:08:00 Module 07: Creating the SetLayerFrozenOrThaw Method 00:04:00 Module 08: Creating the DeleteLayer Method 00:05:00 Module 09: Creating the LockUnlockLayer Method 00:04:00 Module 10: Creating the SetLayerToObject Method 00:08:00 Module 11: Creating the ListLineTypes Method 00:09:00 Module 12: Creating the LoadLineType Method 00:07:00 Module 13: Creating the SetCurrentLineType Method 00:05:00 Module 14: Creating the DeleteLineType Method 00:09:00 Module 15: Creating the SetLineTypeToObject Method 00:05:00 Module 16: Exploring TextStyles - Overview 00:01:00 Module 17: Creating the ListStyles Method 00:08:00 Module 18: Creating the UpdateCurrentTextStyleFont Method 00:12:00 Module 19: Creating the SetCurrentTextStyle Method 00:08:00 Module 20: Creating the SetTextStyleToObject Method 00:08:00 Unit 07: User Interactions in VB.NET Module 01: User Input Functions - Overview 00:02:00 Module 02: Creating the UserInteractions Project 00:03:00 Module 03: Creating the GetName Method 00:11:00 Module 04: Creating the SetLayer Method using the GetString function 00:12:00 Module 05: Creating the CreateLineUsingGetpoint Method 00:11:00 Module 06: Creating the CalculateDefinedArea Method 00:17:00 Module 07: Creating the DrawObjectsUsingGetKeywords Method 00:14:00 Module 08: Creating the GetDistanceBetweenTwoPoints Method 00:05:00 Module 09: Creating the CountObjects Method 00:15:00 Unit 08: Selection Sets and Filters Module 01: Selection Sets and Filters - Overview 00:13:00 Module 02: Creating the SelectionSets Project 00:05:00 Module 03: Creating the SelectAllAndChangeLayer Method 00:12:00 Module 04: Creating the SelectObjectOnScreen Method 00:08:00 Module 05: Creating the SelectWindowAndChangeColor Method 00:06:00 Module 06: Creating the SelectCrossingAndDelete Method 00:05:00 Module 07: Creating the SelectFenceAndChangeLayer Method 00:06:00 Module 08: Creating the CountPickFirstSelection Method 00:07:00 Module 09: Creating the SelectLines Method 00:13:00 Module 10: Creating the SelectMTexts Method 00:05:00 Module 11: Creating the SelectPlines Method 00:04:00 Module 12: Creating the SelectWalls Method 00:07:00 Module 13: Creating the SelectStairs Method 00:03:00 Module 14: Creating the SelectFrenchDoors Method 00:04:00 Module 15: Creating the SelectBifoldDoors Method 00:03:00 Module 16: Creating CountReceptacles Method 00:04:00 Module 17: Creating the CountLightingFixtures Method 00:10:00 Unit 09: Developing Projects - Hands On Module 01: Developing Projects - Hands on Overview 00:02:00 Module 02: BlocksCounter Plugin Demo 00:03:00 Module 03: Creating the BlocksCounter Project 00:04:00 Module 04: Creating the CountBlocksToTable Method 00:08:00 Module 05: Creating the PromptUser Function 00:08:00 Module 06: Creating the GatherBlocksAndDrawTable Method 00:12:00 Module 07: Continuation of GatherBlocksAndDrawTable Method 00:17:00 Module 08: Running and Debugging the BlocksCounter Project - Part 1 00:15:00 Module 09: Running and Debugging the BlocksCounter Project - Part 2 00:11:00 Module 10: Running and Debugging the BlocksCounter Project - Part 3 00:01:00 Module 11: Creating the ObjectExtractor Plugin Project 00:04:00 Module 12: Creating the ExtractObjects Method 00:07:00 Module 13: Creating the ExtractLine Method 00:16:00 Module 14: Running and Debugging the ExtractLine Method 00:05:00 Module 15: Creating the ExtractCircle Method 00:11:00 Module 16: Creating the ExtractMText Method 00:13:00 Module 17: Creating the ExtractPolyline Method 00:19:00 Module 18: Creating the ExtractBlock Method 00:10:00 Unit 10: Conclusion Module 01: Congratulations and Thank you very much! 00:01:00 Assignment Assignment - Learn AutoCAD Programming using VB.NET - Hands On! 00:00:00

Overview This comprehensive course on Learn AutoCAD Programming using VB.NET - Hands On! will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Learn AutoCAD Programming using VB.NET - Hands On! 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 Learn AutoCAD Programming using VB.NET - Hands On!. It is available to all students, of all academic backgrounds. Requirements Our Learn AutoCAD Programming using VB.NET - Hands On! 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 11 sections • 105 lectures • 12:09:00 total length •Module 01: Course Outline: 00:05:00 •Module 02: Introduction: 00:01:00 •Module 03: Who is this Course for?: 00:01:00 •Module 04: What will I learn from this Course?: 00:01:00 •Module 05: What is VB.NET?: 00:01:00 •Module 06: What is AutoCAD .NET API?: 00:01:00 •Module 07: What are the advantages of programming in AutoCAD .NET API?: 00:01:00 •Module 08: Hands-on Projects overview: 00:06:00 •Module 01: AutoCAD .NET API Components Overview: 00:01:00 •Module 02: AutoCAD .NET API Assemblies: 00:02:00 •Module 03: Understanding AutoCAD Object Hierarchy: 00:03:00 •Module 04: AutoCAD .NET API Application Object: 00:02:00 •Module 05: AutoCAD .NET API Document Object: 00:02:00 •Module 06: AutoCAD .NET API Database Object: 00:04:00 •Module 01: Section Overview: 00:04:00 •Module 02: Installing Visual Studio 2019: 00:05:00 •Module 03: Setting up Visual Studio 2019 Integrated Development Environment (IDE): 00:04:00 •Module 04: Creating First VB.NET Plugin (Hello AutoCAD): 00:12:00 •Module 05: Different ways to communicate with the User: 00:04:00 •Module 06: Configuring VS2019 Target Processor: 00:10:00 •Module 01: Creating AutoCAD Object using VB.NET Overview: 00:01:00 •Module 02: Creating DrawObjects Project: 00:04:00 •Module 03: Creating a Line Object using VB.NET: 00:15:00 •Module 04: Creating a MText Object using VB.NET: 00:12:00 •Module 05: Creating a Circle Object using VB.NET: 00:09:00 •Module 06: Creating an Arc Object using VB.NET: 00:07:00 •Module 07: Creating a Polyline Object using VB.NET: 00:08:00 •Module 08: Creating Multiple Circles Vertically: 00:09:00 •Module 09: Creating Multiple Circles Horizontally: 00:05:00 •Module 01: Manipulating AutoCAD Objects Overview: 00:01:00 •Module 02: Creating the Project ManipulateObjects: 00:04:00 •Module 03: Creating the SingleCopy Method: 00:13:00 •Module 04: Creating the MultipleCopy Method: 00:11:00 •Module 05: Creating the EraseObject Method: 00:12:00 •Module 06: Creating the MoveObject method: 00:07:00 •Module 07: Creating the MirrorObject method: 00:10:00 •Module 08: Creating the RotateObject method: 00:07:00 •Module 09: Creating the ScaleObject method: 00:05:00 •Module 10: Creating the OffsetObject method: 00:05:00 •Module 01: Exploring AutoCAD Dictionaries - Overview: 00:02:00 •Module 02: Creating LayersLineTypesAndStyles Project: 00:06:00 •Module 03: Creating the ListLayers Method: 00:11:00 •Module 04: Creating the CreateLayer Method: 00:10:00 •Module 05: Creating the UpdateLayer Method: 00:12:00 •Module 06: Creating the SetLayerOnOff Method: 00:08:00 •Module 07: Creating the SetLayerFrozenOrThaw Method: 00:04:00 •Module 08: Creating the DeleteLayer Method: 00:05:00 •Module 09: Creating the LockUnlockLayer Method: 00:04:00 •Module 10: Creating the SetLayerToObject Method: 00:08:00 •Module 11: Creating the ListLineTypes Method: 00:09:00 •Module 12: Creating the LoadLineType Method: 00:07:00 •Module 13: Creating the SetCurrentLineType Method: 00:05:00 •Module 14: Creating the DeleteLineType Method: 00:09:00 •Module 15: Creating the SetLineTypeToObject Method: 00:05:00 •Module 16: Exploring TextStyles - Overview: 00:01:00 •Module 17: Creating the ListStyles Method: 00:08:00 •Module 18: Creating the UpdateCurrentTextStyleFont Method: 00:12:00 •Module 19: Creating the SetCurrentTextStyle Method: 00:08:00 •Module 20: Creating the SetTextStyleToObject Method: 00:08:00 •Module 01: User Input Functions - Overview: 00:02:00 •Module 02: Creating the UserInteractions Project: 00:03:00 •Module 03: Creating the GetName Method: 00:11:00 •Module 04: Creating the SetLayer Method using the GetString function: 00:12:00 •Module 05: Creating the CreateLineUsingGetpoint Method: 00:11:00 •Module 06: Creating the CalculateDefinedArea Method: 00:17:00 •Module 07: Creating the DrawObjectsUsingGetKeywords Method: 00:14:00 •Module 08: Creating the GetDistanceBetweenTwoPoints Method: 00:05:00 •Module 09: Creating the CountObjects Method: 00:15:00 •Module 01: Selection Sets and Filters - Overview: 00:13:00 •Module 02: Creating the SelectionSets Project: 00:05:00 •Module 03: Creating the SelectAllAndChangeLayer Method: 00:12:00 •Module 04: Creating the SelectObjectOnScreen Method: 00:08:00 •Module 05: Creating the SelectWindowAndChangeColor Method: 00:06:00 •Module 06: Creating the SelectCrossingAndDelete Method: 00:05:00 •Module 07: Creating the SelectFenceAndChangeLayer Method: 00:06:00 •Module 08: Creating the CountPickFirstSelection Method: 00:07:00 •Module 09: Creating the SelectLines Method: 00:13:00 •Module 10: Creating the SelectMTexts Method: 00:05:00 •Module 11: Creating the SelectPlines Method: 00:04:00 •Module 12: Creating the SelectWalls Method: 00:07:00 •Module 13: Creating the SelectStairs Method: 00:03:00 •Module 14: Creating the SelectFrenchDoors Method: 00:04:00 •Module 15: Creating the SelectBifoldDoors Method: 00:03:00 •Module 16: Creating CountReceptacles Method: 00:04:00 •Module 17: Creating the CountLightingFixtures Method: 00:10:00 •Module 01: Developing Projects - Hands on Overview: 00:02:00 •Module 02: BlocksCounter Plugin Demo: 00:03:00 •Module 03: Creating the BlocksCounter Project: 00:04:00 •Module 04: Creating the CountBlocksToTable Method: 00:08:00 •Module 05: Creating the PromptUser Function: 00:08:00 •Module 06: Creating the GatherBlocksAndDrawTable Method: 00:12:00 •Module 07: Continuation of GatherBlocksAndDrawTable Method: 00:17:00 •Module 08: Running and Debugging the BlocksCounter Project - Part 1: 00:15:00 •Module 09: Running and Debugging the BlocksCounter Project - Part 2: 00:11:00 •Module 10: Running and Debugging the BlocksCounter Project - Part 3: 00:01:00 •Module 11: Creating the ObjectExtractor Plugin Project: 00:04:00 •Module 12: Creating the ExtractObjects Method: 00:07:00 •Module 13: Creating the ExtractLine Method: 00:16:00 •Module 14: Running and Debugging the ExtractLine Method: 00:05:00 •Module 15: Creating the ExtractCircle Method: 00:11:00 •Module 16: Creating the ExtractMText Method: 00:13:00 •Module 17: Creating the ExtractPolyline Method: 00:19:00 •Module 18: Creating the ExtractBlock Method: 00:10:00 •Module 01: Congratulations and Thank you very much!: 00:01:00 •Assignment - Learn AutoCAD Programming using VB.NET - Hands On!: 00:00:00

Discover Excel 2019 and become confident in using spreadsheets

This course is a beginners programmers course, to intermediate level, starting from basics through to creating methods, classes and objects. At the end of this course, one would be conversant with all the necessary basics of Java. This is a one day course in classroom, in Manchester.

In this course, you will learn full-stack web development with React JS for the frontend and Python Django for the backend. You will learn and explore various databases such as Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, and SQLite.

A beginner-level course that will help you learn all you need to know about building applications using Python 3, FAST API, MongoDB, and NoSQL as well as front-end technologies such as HTML, CSS, JSX, and REACT JS with live demonstrations. You need to know the basics of HTML, CSS, and JavaScript to get started

Learn and master Excel 2019 by learning advanced functions and formulas