978 Programming Languages courses in Edinburgh delivered Online

Register on the C++ Development: The Complete Coding Guide today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The C++ Development: The Complete Coding Guide 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 C++ Development: The Complete Coding Guide 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 C++ Development: The Complete Coding Guide, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.  Course Content Section 01: Introduction & Setting Up Introduction 00:04:00 What Is C++? 00:03:00 Setting up A Project 00:07:00 Section 02: Basics Console Out 00:04:00 Data Types 00:03:00 Variables 00:04:00 Console In 00:03:00 Strings 00:04:00 Constants 00:05:00 Section 03: Operators Assignment Operator 00:03:00 Arithmetic Operators 00:04:00 Compound Assignment Operator 00:03:00 Increment & Decrement Operators 00:04:00 Relation & Comparison Operators 00:06:00 Logical Operators 00:07:00 Conditional Ternary Operator 00:04:00 Comma Operator 00:03:00 Type Casting Operator 00:02:00 Bitwise Operators 00:12:00 Size of Operator 00:03:00 Operator Precedence 00:05:00 Section 04: String Streams String Streams 00:04:00 Section 05: Statements & Loops Conditional Statements 00:07:00 For Loop 00:04:00 While Loop 00:03:00 Do While Loop 00:04:00 Range-Based For Loop 00:03:00 GoTo Statement 00:04:00 Switch Statement 00:05:00 Section 06: Functions Functions 00:03:00 Function Return Statement 00:04:00 Function Arguments Passed By Value 00:05:00 Function Arguments Passed By Reference 00:05:00 Function Parameter Default Values 00:03:00 Overloaded Functions 00:04:00 Function Templates 00:04:00 Namespaces 00:06:00 Section 07: Advanced Data Types Arrays 00:03:00 Multidimensional Arrays 00:03:00 References 00:02:00 Pointers 00:04:00 Delete Operator 00:02:00 Struct 00:04:00 Type Aliasing 00:03:00 Unions 00:04:00 Enumerators 00:04:00 Section 08: Classes Introduction to Classes 00:05:00 Class Access 00:04:00 Class Constructor 00:05:00 Class Pointers 00:04:00 Overloading Operators 00:06:00 This Keyword 00:04:00 Constant Objects 00:03:00 Getters and Setters 00:05:00 Static Variables 00:04:00 Static Functions 00:06:00 Template Classes 00:05:00 Class Destructor 00:04:00 Class Copy Constructor 00:03:00 Friend Function 00:06:00 Friend Class 00:06:00 Class Inheritance 00:07:00 Multiple Class Inheritance 00:05:00 Virtual Methods 00:04:00 Abstract Base Class 00:03:00 Section 09: Errors Error Handling 00:04:00 Section 10: The Mighty Preprocessor Preprocessor Macro Definitions 00:04:00 Preprocessor Conditional Directives 00:05:00 Preprocessor Line Directive 00:04:00 Preprocessor Error Directive 00:03:00 Preprocessor Source File Inclusion 00:02:00 Section 11: File I/O Opening A File 00:06:00 Writing to a File 00:04:00 Section 12: Extras Commenting 00:04:00 Class Header and Implementation 00:09:00 Lists 00:04:00 Vectors 00:05:00 Section 13: Resource Resource 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.

This course will walk you through a whole real-world scenario for developing and deploying an ecommerce website with Blazor, and we will tackle numerous obstacles along the way. You will learn how to create a .NET 6 API from scratch and deploy .NET API, Blazor WASM, and Server to Azure in this course.

This course primarily focuses on explaining the concepts of Python and PySpark. It will help you enhance your data analysis skills using structured Spark DataFrames APIs.

Looking to build an AI application from scratch? Look no further than this compact course with ChatGPT! Using the OpenAI API and the latest web development technologies, including React, Next.js, JavaScript, Node, and CSS, you will gain hands-on experience building an AI-powered application that generates pet names for users.

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

Elevate your web development skills with our Python Django Training. Master the Django framework and unleash the power of Python for building robust, scalable, and feature-rich web applications. Join our comprehensive training program to gain hands-on experience, expert guidance, and propel your career in the world of web development. Start your journey today!

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

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