ð Unlock the Power of Microsoft Excel with Our Excel VBA Programming Training Course! ð Are you ready to take your Excel skills to the next level? Dive deep into the world of Excel VBA programming and unleash the full potential of this powerful tool! Our comprehensive online course, 'Microsoft Excel VBA Programming Training,' is designed to equip you with the expertise needed to automate tasks, streamline processes, and boost productivity within Excel. Here's what you'll learn in this dynamic course: ð Section 1: Introduction Get acquainted with the fundamentals of Excel VBA programming. Understand its significance and explore the vast possibilities it offers to transform your Excel experience. ð Section 2: Macros Master the art of creating and executing macros to automate repetitive tasks and significantly reduce manual work. Learn to streamline your workflow like a pro! ð Section 3: VBA Editor Navigate the VBA Editor seamlessly. Gain proficiency in using this interface to write, edit, and debug your VBA code effectively. ð Section 4: Variables and Procedures Understand the concept of variables and procedures in VBA. Learn how to declare, assign, and utilize them efficiently to optimize your coding process. ð Section 5: Loops and IF Statements Discover the power of loops and conditional IF statements. Harness these constructs to create dynamic and responsive Excel applications. ð Section 6: Error Handling Learn robust error-handling techniques to troubleshoot issues and create resilient VBA programs. ð Section 7: User Defined Functions Unlock the potential of creating custom functions tailored to your specific needs, enhancing Excel's capabilities beyond its default functions. ð Section 8: Assignments Apply your newfound knowledge through hands-on assignments and practical exercises to reinforce your skills. ð Section 9: Creating Forms Explore the creation of user-friendly forms and interfaces within Excel, making interactions more intuitive and efficient. Whether you're a beginner or have some experience in Excel, this course is tailored to suit your learning needs. With comprehensive modules, real-world examples, and expert guidance, you'll gain the confidence to create powerful VBA scripts and automate Excel operations like never before! Join us today and embark on a transformative journey in mastering Microsoft Excel VBA programming. Elevate your Excel skills and become a proficient VBA programmer! Enroll now and excel in Excel VBA programming! ð¡ð⨠Course Curriculum Section 1 - Introduction What is VBA 00:00 Object Orientated Programming 00:00 Section 2 - Macros Macros Initial Setup 00:00 Recording a Macro 00:00 Saving a Macro 00:00 Section 3 - VBA Editor Launching VBA 00:00 VB Editor 00:00 Custom Menu 00:00 Naming Projects 00:00 Modules 00:00 Code Window 00:00 Comments 00:00 Section 4 - Variables and Procedures Introduction 00:00 Vraibales 00:00 Variable Exercise 00:00 What are Procedures 00:00 What are Procedures - Part Two 00:00 What are Procedures - Part Three 00:00 Message Boxes 00:00 Input Box 00:00 Input Box - Part Two 00:00 Basic Navigation 00:00 Sheets 00:00 Draft LessonCell Navigation 00:00 Advanced Sheets 00:00 Offset 00:00 Section 5 - Loops and IF Statements Introduction 00:00 Operators 00:00 Using Variables 00:00 What is Automation 00:00 For Loop 00:00 Do Loops 00:00 IF Statements 00:00 IF Statements - Part Two 00:00 Select Case 00:00 Section 6 - Error Handling Debugging 00:00 Section 7 - User Defined Functions UDFs 00:00 Section 8 - Assignments Introduction 00:00 Exercise 1 - Record a Macro 00:00 Exercise 2 - Duplicating Data 00:00 Exercise 3 - Generate a Report 00:00 Generate a Report - Part Two 00:00 Exercise 4 - Inner and Outer Loops 00:00 Inner and Outer Loops - Part Two 00:00 Inner and Outer Loops - Part Three 00:00 Inner and Outer Loops - Part Four 00:00 Inner and Outer Loops - Part Five 00:00 Section 9 - Creating Forms Form Controls 00:00 Building the Form 00:00 Initialize the Form 00:00 Command Buttons 00:00 Command Buttons - Part Two 00:00
Advance your data skills by mastering Spark programming in Python. This beginner's level course will help you understand the core concepts related to Apache Spark 3 and provide you with knowledge of applying those concepts to build data engineering solutions.
Duration 1 Days 6 CPD hours This course is intended for The Azure AI Fundamentals course is designed for anyone interested in learning about the types of solution artificial intelligence (AI) makes possible, and the services on Microsoft Azure that you can use to create them. You don?t need to have any experience of using Microsoft Azure before taking this course, but a basic level of familiarity with computer technology and the Internet is assumed. Some of the concepts covered in the course require a basic understanding of mathematics, such as the ability to interpret charts. The course includes hands-on activities that involve working with data and running code, so a knowledge of fundamental programming principles will be helpful. This course introduces fundamentals concepts related to artificial intelligence (AI), and the services in Microsoft Azure that can be used to create AI solutions. The course is not designed to teach students to become professional data scientists or software developers, but rather to build awareness of common AI workloads and the ability to identify Azure services to support them. Prerequisites Prerequisite certification is not required before taking this course. Successful Azure AI Fundamental students start with some basic awareness of computing and internet concepts, and an interest in using Azure AI services. Specifically: Experience using computers and the internet. Interest in use cases for AI applications and machine learning models. A willingness to learn through hands-on exp... 1 - Fundamental AI Concepts Understand machine learning Understand computer vision Understand natural language processing Understand document intelligence and knowledge mining Understand generative AI Challenges and risks with AI Understand Responsible AI 2 - Fundamentals of machine learning What is machine learning? Types of machine learning Regression Binary classification Multiclass classification Clustering Deep learning Azure Machine Learning 3 - Fundamentals of Azure AI services AI services on the Azure platform Create Azure AI service resources Use Azure AI services Understand authentication for Azure AI services 4 - Fundamentals of Computer Vision Images and image processing Machine learning for computer vision Azure AI Vision 5 - Fundamentals of Facial Recognition Understand Face analysis Get started with Face analysis on Azure 6 - Fundamentals of optical character recognition Get started with Vision Studio on Azure 7 - Fundamentals of Text Analysis with the Language Service Understand Text Analytics Get started with text analysis 8 - Fundamentals of question answering with the Language Service Understand question answering Get started with the Language service and Azure Bot Service 9 - Fundamentals of conversational language understanding Describe conversational language understanding Get started with conversational language understanding in Azure 10 - Fundamentals of Azure AI Speech Understand speech recognition and synthesis Get started with speech on Azure 11 - Fundamentals of Azure AI Document Intelligence Explore capabilities of document intelligence Get started with receipt analysis on Azure 12 - Fundamentals of Knowledge Mining with Azure Cognitive Search What is Azure Cognitive Search? Identify elements of a search solution Use a skillset to define an enrichment pipeline Understand indexes Use an indexer to build an index Persist enriched data in a knowledge store Create an index in the Azure portal Query data in an Azure Cognitive Search index 13 - Fundamentals of Generative AI What is generative AI? Large language models What is Azure OpenAI? What are copilots? Improve generative AI responses with prompt engineering 14 - Fundamentals of Azure OpenAI Service What is generative AI Describe Azure OpenAI How to use Azure OpenAI Understand OpenAI's natural language capabilities Understand OpenAI code generation capabilities Understand OpenAI's image generation capabilities Describe Azure OpenAI's access and responsible AI policies 15 - Fundamentals of Responsible Generative AI Plan a responsible generative AI solution Identify potential harms Measure potential harms Mitigate potential harms Operate a responsible generative AI solution Additional course details: Nexus Humans AI-900T00 - Microsoft Azure AI Fundamentals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the AI-900T00 - Microsoft Azure AI Fundamentals course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
Duration 4 Days 24 CPD hours This course is intended for This advanced course is the third in a series of three classes designed for RPG IV programmers. Programming experience using RPG IV is mandatory when enrolling in this course. You should have attended RPG IV Programming Fundamentals Workshop for IBM i (AS060) and RPG IV Programming Intermediate Workshop for IBM i (AS070). This course is not designed for RPG III programmers who want RPG IV. RPG III programmers should review the agenda carefully before they make a decision to attend this class. Overview Use address pointers and user spaces in RPG IV programs Write database triggers in RPG IV Develop ILE modular objects and package them in service programs Explain the purpose of ILE activation groups Explain the behavior of error handling and percolation in ILE Code an ILE error handling program Call application program interfaces (APIs) from RPG IV program Programmers who can write comprehensive RPG IV programs using the IBM i RPG IV compiler (v7), learn additional skills & techniques. Comprehensive exposure to advanced features of the Integrated Language Environment (ILE) RPG compiler and the IBM i. Programmers who can write comprehensive RPG IV programs using the IBM i RPG IV compiler (v7), learn additional skills & techniques. Comprehensive exposure to advanced features of the Integrated Language Environment (ILE) RPG compiler and the IBM i.
Learn Python with 200+ real-world examples implemented on PyCharm. Ace functions, classes, objects, dictionary, lists, sets, and tuples. The course also covers math, statistics, and random modules. This is the ideal course for you if you want to advance your Python programming skills or switch to Python programming.
This course provides basic introductory guidance to FinTech. You will be using an easy programming language R to learn some basic statistics in money management. You will also understand how to time the stock market and build tradeable factor-based algorithms from scratch. This course provides some of the most basic rules of thumb and intuition that every successful trader should know.
The comprehensive AutoCAD Programming using VB.NET with Windows Forms MasterClass has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the AutoCAD Programming using VB.NET with Windows Forms MasterClass today, and learn from the very best the industry has to offer! This best selling AutoCAD Programming using VB.NET with Windows Forms MasterClass has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth AutoCAD Programming using VB.NET with Windows Forms MasterClass is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The AutoCAD Programming using VB.NET with Windows Forms MasterClass is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The AutoCAD Programming using VB.NET with Windows Forms MasterClass is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the AutoCAD Programming using VB.NET with Windows Forms MasterClass, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the AutoCAD Programming using VB.NET with Windows Forms MasterClass will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the AutoCAD Programming using VB.NET with Windows Forms MasterClass to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.