Agile techniques and management frameworks are changing the way organisations operate. Evolving to realise that organisations are no longer static and structured entities is the key to unlocking new ways to achieve better results. Agile can be utilised at an organisation, team, and project level. Transforming to an Agile way of working requires knowledge, commitment, and frameworks to lead change. The Applying Professional Scrum training teaches key implementation techniques and Scrum frameworks. Course Description Applying Professional Scrum Training ONLINE Getting results with the Scrum framework Scrum is the most used Agile framework for complex product development and project management. It is a proven system, in use for over 25 years by companies large and small. Scrum training introduces an iterative and incremental approach to product or project development – aiming to reduce complexity and achieve results faster. A Scrum team works simultaneously rather than sequentially, with more flexibility. Scrum teams learn to work better together, delivering more value for project stakeholders. Applying professional scrum training The Applying professional Scrum (APS) course introduces the Scrum framework and demonstrates its power over traditional approaches to project or product development. It is an interactive course that aims to familiarise participants with its iterative and 'Sprint' based methodology. The Scrum framework is commonly used in software development but is relevant in any industry or to any complex project. Course contents and key objectives The course will teach participants how to apply Professional Scrum and the Scrum framework. It is appropriate for anyone, whether or not they have previous exposure to Scrum. Contents of the two-day course include: Understanding more about Agile development and the value that an Agile mindset can bring. Explain how Scrum differs from traditional work models and the advantages this offers. Explain the details of the Scrum methodology and its practical application. Understand how to apply Scrum to projects and teamwork. This includes the concepts of the Scrum team, Sprints, Sprint reviews, and the Daily Scrum. Course attendees will work in Scrum teams to simulate a Scrum project. This will involve a series of 'sprints' to solve complex problems and demonstrate the Scrum approach's power. Such Sprints are key to the Scrum framework. They bring in the iterative way of working, giving teams the chance to review success and quickly adapt to meet business requirements. As part of this practical approach, participants will learn to recognize and understand common missteps and misunderstandings when using Scrum. Expected Outcomes from Applying professional scrum training Applying professional scrum training will teach attendees what Scrum is, the value it can deliver, and how to implement it. The practical and example-based nature of the course will help develop a thorough understanding of the Scrum framework. Experience is the key to implementing it in practice. As such, the course is designed to mimic this and teach the problems to look out for and their solution. Participants will emerge as proficient Scrum practitioners – ready to transform the development of their projects. Who Should Attend This Course? Scrum is beneficial for any company, or individual, with complex projects or products. This course provides an introduction and solid grounding in Scrum, enabling participants to work effectively within the Scrum team and to go on to further training if desired. It is ideal for anyone: Working in or joining a team that uses Scrum. Considering the use of Scrum or investigating its benefits. Working alongside or managing Scrum teams – even if not using the methodology directly. Your Professional Scrum Trainer Meet Jay, founder of Fractal Systems and a dedicated Professional Scrum Trainer. With over 20 years of experience in team and leadership roles, Jay is well-versed in delivering continuous value. His unique teaching approach involves zero PowerPoint and instead relies on engaging, experience-based sessions using techniques from Liberating Structures and Neuro Linguistic Programming. Jay's expertise lies in business transformations, offering training, mentoring, coaching, and consulting to foster success through collaborative efforts. Rapid learning and practical application are the hallmarks of his approach. Jay & the entire Fractal team are invested in your learning journey and are here to support you from start to end, including offering additional valuable support: Free practice assessments for certification success Free resource bundle to master Scrum Free exam revision sheets Free access to an exam simulator Free exam coaching sessions for first-time success Free 1:1 coaching to excel at work Our Clients Our Testimonials
Develop a deep understanding of electricity pricing and marginal cost analysis with EnergyEdge's virtual instructor-led training course. Enroll now for a rewarding learning journey!
Duration 4 Days 24 CPD hours This course is intended for While no prior programming or web development experience is required, target students should have good foundational computer skills. Overview Set up the tools and resources you need to perform Web Development. Create web pages in HTML, constructing valid, well-formed elements, including navigation links, sections, titles, and semantic markup. Enhance HTML content with tables, images, movies, and audio. Apply styles to HTML elements using CSS. Use CSS to format the edges, size, position, and layering of HTML elements. Apply complex style rules using advanced CSS selectors, including pseudo-class selectors, structural selectors, and pseudo-element selectors. Create complex layouts using CSS newspaper style columns, grid layouts, and flexible box layouts. Improve the quality of web content, including adaptability (different displays and devices), searchability, usability, and accessibility. Submit data through URL query strings and web forms for processing by a web application server. Write JavaScript code to make web pages more interactive, perform data processing tasks directly in the browser, and manipulate items in the current web page. Write JavaScript code to iterate through collections of elements in a page to get and set their attributes and add event listener code. Use third-party libraries and frameworks for web front-end development. Modern organizations depend heavily on the web to perform core business operations such as marketing, advertising, and selling products, providing services, and communicating with customers, partner organizations, and employees. Whatever you're creating on the web, HTML, CSS, and JavaScript? likely play an important role. These three languages provide the core toolkit for anyone looking to perform web development work. This course covers the fundamentals of web development using these three languages. Prerequisites This course assumes that students have strong experience working with computers. Previous experience programming in other languages is helpful, but not required for students to benefit from this course. Lesson 1: Setting Up Your Web Development Environment Topic A: Prepare Your Web Platform Topic B: Prepare Your Web Development Tools and Processes Topic C: Monitor the Web Request-Response Cycle Lesson 2: Creating Web Content in HTML Topic A: Create a Basic Web Page Topic B: Provide Navigation Links Between Web Pages Topic C: Improve Web Page Structure and Navigation Lesson 3: Adding Tables and Multimedia Content to a Web Page Topic A: Create a Table Topic B: Embed Images, Movies, and Audio in a Web Page Lesson 4: Applying Styles to Web Content Topic A: Apply Styles to HTML Topic B: Create a Style Sheet Topic C: Use Web Fonts Lesson 5: Controlling Edges, Size, and Position Topic A: Format Element Edges and Corners Topic B: Control an Element's Height and Width Topic C: Control an Element's Position and Layering Topic D: Normalize and Reset Browser CSS Defaults Lesson 6: Applying Complex Style Rules Topic A: Use Advanced Selectors Topic B: Manage User Interface States Topic C: Make Structure Apparent to Users Topic D: Use CSS Pseudo-Element Selectors Lesson 7: Creating Complex Layouts Topic A: Use CSS to Create Newspaper Style Columns Topic B: Use CSS to Create Grid Layouts Topic C: Use CSS to Create Flexible Box Layouts Lesson 8: Improving Web Content Topic A: Adjust the Layout for a Wide Variety of Devices Topic B: Perform Basic Search Engine Optimization Topic C: Test Your Website Lesson 9: Submitting Data to a Web Server for Processing Topic A: Submit Data Through a URL Topic B: Submit Data Through a Web Form Lesson 10: Writing JavaScript Code Topic A: Add JavaScript to a Web Page Topic B: Perform Operations on Data Topic C: Program Repetitive Tasks Topic D: Manipulate DOM Objects Lesson 11: Enumerating and Processing Collections of Elements Topic A: Enumerate Elements Topic B: Attach Events Through Code Lesson 12: Using Third-Party Libraries and Frameworks Topic A: Use a Third-Party JavaScript Library Topic B: Create a Web Page Based on a Third-Party Framework Additional course details: Nexus Humans Web Development with HTML5, CSS, and JavaScript (v1.0) 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 Web Development with HTML5, CSS, and JavaScript (v1.0) 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 5 Days 30 CPD hours This course is intended for This course is intended for anyone who is new to software development and wants, or needs, to gain an understanding of programming fundamentals and object-oriented programming concepts. They will typically be high school students, post-secondary school students, or career changers, with no prior programming experience. They might want to gain an understanding of the core programming fundamentals before moving on to more advanced courses such as Programming in C#. Overview Explain core programming fundamentals such as computer storage and processing. Explain computer number systems such as binary. Create and use variables and constants in programs. Explain how to create and use functions in a program. Create and use decisions structures in a computer program. Create and use repetition (loops) in a computer program. Explain pseudocode and its role in programming. Explain the basic computer data structures such as arrays, lists, stacks, and queues. Implement object-oriented programming concepts. Create and use classes in a computer program. Implement encapsulation, inheritance, and polymorphism. Describe the base class library (BCL) in the .NET Framework. Explain the application security concepts. Implement simple I/O in a computer program. Identify application errors and explain how to debug an application and handle errors. Identify the performance considerations for applications. In this 5-day course, students will learn the basics of computer programming through the use of Microsoft Visual Studio 2022 and the Visual C# and Visual Basic programming languages. The course assumes no prior programming experience and introduces the concepts needed to progress to the intermediate courses on programming, Programming in C#. The focus will be on core programming concepts such as computer storage, data types, decision structures, and repetition by using loops. The course also covers an introduction to object-oriented programming covering classes, encapsulation, inheritance, and polymorphism. Coverage is also included around exception handling, application security, performance, and memory management. 1 - Introduction to Core Programming Concepts Computer Data Storage and Processing Application Types Application Lifecycle Code Compilation 2 - Core Programming Language Concepts Syntax Data Types Variables and Constants 3 - Program Flow Introduction to Structured Programming Concepts Introduction to Branching Using Functions Using Decision Structures Introducing Repetition 4 - Algorithms and Data Structures Understand How to Write Pseudocode Algorithm Examples Introduction to Data Structures 5 - Error Handling and Debugging Introduction to Program Errors Introduction to Structured Error Handling Introduction to Debugging 6 - Introduction to Object-Oriented Programming Introduction to Complex Structures Introduction to Structs Introduction to Classes Introducing Encapsulation 7 - More Object-Oriented Programming Introduction to Inheritance Introduction to Polymorphism Introduction to .NET and the Base Class Library 8 - Introduction to Application Security Authentication and Authorization Code Permissions on Computers Introducing Code Signing 9 - Core I/O Programming Using Console I/O Using File I/O 10 - Application Performance and Memory Management Value Types vs Reference Types Converting Types The Garbage Collector Additional course details: Nexus Humans 55337 Introduction to Programming 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 55337 Introduction to Programming 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.
Who is this course for? The "3ds Max and Unity 3D Game Designing Training Course" is ideal for aspiring game designers, developers, graphic designers, students, and creative professionals. It's tailored for individuals keen on mastering 3D modeling, animation, and interactive game development using industry-standard software like 3ds Max and Unity 3D. Click here for more info: Website Scheduling: Available from Monday to Saturday, 9 a.m. to 7 p.m. Choose in-person or live online sessions over Zoom. Duration: 40 hours. Module 1: Introduction to 3ds Max (8 hours) Overview of 3ds Max interface and tools Basic 3D modeling techniques: primitives, Editable Poly, modifiers Material creation and application Introduction to lighting and rendering concepts Module 2: Advanced 3ds Max Techniques (8 hours) Advanced modeling: Splines, Loft, Extrude, and ProBoolean Animation basics: Keyframes, paths, and controllers Particle systems and dynamics Introduction to character rigging and animation Module 3: Introduction to Unity 3D (8 hours) Unity interface and project setup Importing 3D assets from 3ds Max Physics and colliders in Unity Basic scripting and interactions Module 4: Advanced Unity 3D Features (8 hours) Unity scripting: C# fundamentals Advanced physics and particle systems User interface design and implementation Integrating audio and visual effects Module 5: Game Design and Optimization (8 hours) Game design principles and mechanics Level design and interactive gameplay elements Optimizing game performance: LOD, batching, and asset optimization User testing and feedback incorporation Final Project (4 hours) Collaborative game development project using 3ds Max and Unity 3D Implementation of learned skills in a real-world scenario Presentation and feedback session Note: The course outline is designed to provide a comprehensive understanding of both 3ds Max and Unity 3D, covering fundamental and advanced topics. The final project aims to apply the acquired skills in a practical context, fostering creativity and collaboration among participants. Unity - Real-time 3D https://www.unity.com/. 3ds Max Trial https://www.autodesk.co.uk ⺠products ⺠free-trial Upon completion of the 40-hour 3ds Max and Unity 3D Game Design Masterclass, students will: Master 3D Modeling: Acquire proficient skills in creating detailed 3D models, understanding various techniques, and utilizing advanced tools in 3ds Max. Expertise in Animation: Gain expertise in animating characters and objects, employing keyframes, paths, and controllers for realistic motion. Material Creation and Texturing: Understand material creation, application, and advanced texturing techniques for creating visually appealing game assets. Unity Game Development: Learn Unity's interface, project setup, and scripting fundamentals to create interactive games. Physics and Interactivity: Explore physics systems, colliders, and interactive elements, enhancing gameplay experiences. Advanced Scripting: Develop proficiency in C# scripting, enabling the implementation of complex game mechanics and interactions. Optimization Techniques: Understand techniques to optimize game assets, improving performance and ensuring smooth gameplay. Game Design Principles: Grasp essential game design principles, including level design, user experience, and gameplay mechanics. Real-World Application: Apply learned skills in a collaborative final project, integrating 3D models, animations, scripting, and game design principles. Presentation Skills: Develop the ability to present and explain game concepts, designs, and mechanics effectively. Troubleshooting and Debugging: Gain skills in identifying and resolving common issues and errors in both 3ds Max and Unity 3D projects. Team Collaboration: Enhance teamwork and collaboration skills through the final project, working effectively with peers in a creative environment. Upon completing the course, students will have a well-rounded skill set in 3D modeling, animation, game design, and Unity development, making them proficient candidates for roles in game development studios, animation companies, or freelance projects. 3ds Max and Unity 3D Game Designing Training Course: Skills & Careers! Skills Acquired: Advanced 3D Modeling Texturing and Animation Unity 3D Game Development Lighting and Rendering Interactive UI/UX Design Career Opportunities: Game Developer 3D Modeler Texture Artist Game Tester UI/UX Designer Embrace Personalized Learning. Why Us? Discover the Benefits: One-on-One Training: Experience tailored coaching from practicing architects and designers, either face-to-face at (SW96DE) or in live online sessions. Available Monday to Saturday, 9 am to 7 pm. Customized Tutorials: Take home exclusive video tutorials crafted to enhance your learning journey. Comprehensive Resources: Access a digital reference book for thorough revision, ensuring a deep understanding of every concept. Free Ongoing Support: Enjoy continuous post-course assistance via phone or email, ensuring your success even after class completion. Flexible Syllabus: We adapt syllabus and projects to your needs, ensuring focused learning on what matters most to you. Official Certificate: Certificate upon course completion. Why Choose Us? Individualized Support: Our courses, ranging from 10 to 120 hours, offer unwavering assistance at every stage. With personalized homework assignments and free after-course support, we guide you toward mastering software with unparalleled expertise. Personal Attention, No Crowded Classrooms: Experience the intimacy of one-on-one learning. Bid farewell to crowded classrooms, ensuring you receive the undivided attention you deserve in a confident and comfortable environment. Financial Flexibility: Embarking on your educational journey shouldn't strain your finances. Diverse payment plans tailored to your needs. Explore available options and embark on your learning adventure today. Expert Instructors, Real-world Experience: Our instructors, chosen for their industry expertise and passion for teaching, are dedicated to imparting invaluable skills to eager learners.
Computer Science GCSE Syllabus The GCSE Computer Science Tutor Syllabus is designed to provide tutors in England with a comprehensive framework for teaching the GCSE Computer Science curriculum effectively. This syllabus aims to equip tutors with the necessary knowledge and skills to support students in their understanding and application of core computer science concepts. Module 1: Introduction to Computer Science - Overview of computer science and its relevance in today's world - Understanding the components of a computer system - Introduction to algorithms and problem-solving techniques - Exploration of programming languages and their uses Module 2: Computer Hardware - Understanding the main components of a computer system, including CPU, memory, and storage devices - Exploring input and output devices and their functionalities - Understanding the role of operating systems and software in computer systems Module 3: Software Development - Introduction to programming concepts and languages (e.g., Python or Java) - Understanding variables, data types, and operators - Building algorithms and logical reasoning skills - Introduction to flowcharts and pseudocode - Implementation of simple programs and debugging techniques Module 4: Data Representation - Understanding binary, hexadecimal, and denary number systems - Representation of text, images, and sound using binary - Introduction to data compression and encryption techniques Module 5: Computer Networks - Understanding the basics of computer networks, including LAN, WAN, and the Internet - Introduction to network topologies, protocols, and security - Exploring the impact of digital communication on society Module 6: Cybersecurity and Ethical Issues - Understanding the importance of cybersecurity and data protection - Introduction to common threats and vulnerabilities - Exploring ethical issues related to computer science, such as privacy and intellectual property rights Module 7: Algorithms and Programming Techniques - Advanced programming concepts, including conditionals, loops, and functions - Introduction to sorting and searching algorithms - Exploring data structures, such as arrays and lists Module 8: System Architecture - Understanding the structure and function of a CPU - Introduction to memory hierarchy and cache - Exploring the Von Neumann architecture and its limitations Module 9: Computational Thinking and Problem Solving - Advanced problem-solving techniques using computational thinking - Introduction to algorithms for complex problems - Exploring algorithmic efficiency and optimization techniques Module 10: Exam Preparation and Revision - Reviewing key concepts covered throughout the syllabus - Practicing past exam questions and providing guidance on exam techniques - Supporting students with exam preparation strategies Please note that the duration and depth of each module can vary depending on the level of expertise required and the specific needs of the learners. Additionally, it's important to adapt the curriculum to the learners' proficiency levels, whether they are A Level/GCSE students or adult learners with different experience levels.
The Professional Agile Leadership Essentials (PAL-E) is a 2-day hands-on workshop that uses a combination of instruction and hands-on exercises to help managers and other leaders who work directly with agile teams understand how to best support, guide, and coach their teams to improve their agile capabilities. Course Description Professional Agile Leadership Essentials (Scrum.org) Training ONLINE PAL E - Professional Agile Leadership Essentials Agile leadership has a lot to offer businesses today. Organizations have changed a great deal over the years and are no longer the static, structured entities they once were. Agile teams and agile leadership respond to these changes, offering a new way to achieve better results. PAL-E training is designed to help managers, and other leaders, understand how to approach an Agile transformation, and to guide teams to be successful. Agile teams and leadership bring real benefit Agile organisations and teams thrive in unpredictable and changing environments. They are able to improve efficiency and react quickly to changing markets and customer needs. Achieving this is not something that just happens. The transformation to become an agile organisation is profound, requiring senior leaders, managers, and team members to change how they organise themselves and others, alongside how they work and measure results. According to consultancy McKinsey: "the key to a successful Agile transformation is for leaders, particularly senior leaders, to develop substantially new mind-sets and capabilities." Scrum Training is a perfect first step in this. Professional Agile Leadership Essentials training The Professional Agile Leadership Essentials (PAL-E) course is a certified 2-day online workshop for team managers and leaders. It will show managers how to effectively develop, support, and guide agile teams to improve their performance. Agile teams are different from traditional structures. There is much more focus on continuous development and learning, as well as self-organisation. The course provides a foundation for managers' and leaders' roles in creating the conditions for a successful Agile transformation. Through detailed instruction and practical exercises, this course will teach leaders and managers how to form, support, and enhance Agile teams. It will guide them through the business, cultural and behavioural changes that must be made to take full advantages of the possibilities of Agile teams. PAL-E Course contents and key objectives The Professional Agile Leadership Essentials course will provide a solid grounding in the background and importance of agile leadership and how to apply it in leading teams. The main content and learning includes: An understanding of what Agile is, the benefits and impact it can have on business, and the role a manager plays in achieving this. Challenges and techniques of Agile management, and the role management plays in an Agile organisation. How to develop and support Agile teams. How to measure and guide Agile product delivery, and an understanding of core problems in product development. An understanding of how to measure the benefits and impacts of agility in your organisation. Expected Outcomes from a PAL-E workshop PAL-E training highlights how Agile teams perform and the role of leaders and managers in establishing and developing their teams. Agile can help an organisation thrive through a framework that provides a flexible approach to challenges and problem solving. Thje Professional Agile Leadership Essentials course enables you to lead your teams and implement core Agile frameworks that deliver real business benefits. Who Should Attend This Course? Professional Agile Leadership essentials course is designed for leaders and managers in Agile organisations. It is suited to anyone responsible for setting up or establishing Agile techniques and for those managing teams and improving ongoing methods and techniques. After completing the course, participants can obtain industry-recognised certification. This will require passing a rigorous online assessment following the training. There are then plenty more courses that can take you further into Agile techniques. Scrum Master Training, for example, will guide participants through the industry-leading scrum framework for Agile practices. Your Professional Scrum Trainer Meet Jay, founder of Fractal Systems and a dedicated Professional Scrum Trainer. With over 20 years of experience in team and leadership roles, Jay is well-versed in delivering continuous value. His unique teaching approach involves zero PowerPoint and instead relies on engaging, experience-based sessions using techniques from Liberating Structures and Neuro Linguistic Programming. Jay's expertise lies in business transformations, offering training, mentoring, coaching, and consulting to foster success through collaborative efforts. Rapid learning and practical application are the hallmarks of his approach. Jay & the entire Fractal team are invested in your learning journey and are here to support you from start to end, including offering additional valuable support: Free practice assessments for certification success Free resource bundle to master Scrum Free exam revision sheets Free access to an exam simulator Free exam coaching sessions for first-time success Free 1:1 coaching to excel at work Our Clients Our Testimonials
Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are persons who are new to reporting with Microsoft© SQL Server© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. The secondary audience for this course are persons who are using Report Designer (SSRS). Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with Microsoft© SQL Server© Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience. Overview After completing this course, students will be able to: Create parameter reports. Create list reports. Format reports with complex expressions. Add images and subreports. Add drilldown and drillthrough functionality. Add sparklines, data bars, and indicators. In this course, students will continue their learning on the foundations of report writing with Microsoft© SQL Server© Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data. 1 - Parameter Reports Parameterized Reporting Create Report Parameters Modify Report Parameters Provide Default Parameter Values Provide Available Values for Parameters Lab: Creating Parameterized Reports 2 - List Data Regions Introducing the List Data Region Create Reports Using List Data Regions Modify Reports Which Use List Data Regions Lab: Creating List Reports 3 - Enhancing Reports with Complex Expressions Formatting Reports Top N Reports Running Values Lab: Enhancing Reports with Complex Expressions 4 - Enhance Reports with Images and Subreports Add Images to Reports Retrieve Images from a Database Introducing SSRS (SQL Server Reporting Services) Report Server Add Subreports to Reports Lab: Working With Images and Subreports 5 - Drilldown and Drillthrough Reports Add and Configure Drilldown Reporting Add and Configure Drillthrough Reporting Lab: Add Drilldown and Drillthrough Functionality to Reports 6 - Sparklines, Data Bars, and Indicators Sparklines Data Bars Indicators Lab: Adding Sparklines, Data Bars, and Indicators to Reports Additional course details: Nexus Humans 55128 Writing Reports with Report Builder and SSRS Level 2 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 55128 Writing Reports with Report Builder and SSRS Level 2 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.
Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included