Complete VBA programming training course description This course helps you extend the capabilities of the entire Office suite using Visual Basic for Applications (VBA). Even if you have no programming experience, you'll be automating routine computing processes quickly using the simple, yet powerful VBA programming language. We start at the beginning to get you acquainted with VBA so you can start recording macros right away. You'll then build upon that foundation to utilize the full capabilities of the language in Word, Excel, Outlook, and PowerPoint. What will you learn Record, write and run macros. Work with VBA Editor. Use the huge library of built-in functions. Create simple dialog boxes and complex forms. Customize Word, Excel, PowerPoint, Outlook, and Access. Program the Office 2016 ribbon. Complete VBA programming training course details Who will benefit: Anyone looking to extend the capabilities of the entire Office suite using VBA. Prerequisites: None. Duration 5 days Complete VBA programming training course contents Macros and getting started in VBA VBA syntax, variables, constants, and enumerations, array variables, finding objects, methods, and properties. Working with VBA 1 VBA syntax, variables, constants, and enumerations, array variables, finding objects, methods, and properties. Decisions, loops and functions Built-in functions, creating your own functions, making decisions in your code, using loops to repeat actions. Using message boxes, input boxes, and dialog boxes Getting user input with message boxes and input boxes, creating simple custom dialog boxes, creating complex forms. Creating effective code Building modular code and using classes, debugging your code and handling errors, building well-behaved code, exploring VBA's security features. Programming the Office applications The Word object model and key objects, working with widely used objects in Word, the Excel object model and key objects, working with widely used objects in Excel, the PowerPoint object, model and key objects, working with shapes and running slide shows, the Outlook object model and key objects, working with events in Outlook, the Access object model and key objects, manipulating the data in an Access database via VBA, accessing one application from another application, programming the Office 2016 ribbon.
Essential optical transmission course description Transmission is the process of sending information along a medium of, copper, fibre or wireless. This course looks at transmission techniques for fibre networks. The course aims to demystify the technologies involved by explaining all the buzzwords used in optical transmission. What will you learn Describe various optical transmission technologies. Explain how SDH and OTN work. Explain how WDM, CWDM and DWDM work. Explain PON, GPON and GEPON. Essential optical transmission course details Who will benefit: Anyone working in telecommunications. Prerequisites: None. Duration 2 days Essential optical transmission course contents Transmission basics nsmission basics Systems, media, signals. Signal degradation, noise, distortion, attenuation. Digital, analogue. Modulation, encoding. Fibre transmission Fibre vs copper, optical transmission, fibre characteristics, fibre component parts. Multi Mode Fibre (MMF). Single Mode Fibre (SMF). Fibre connections. Lasers. Attenuations, dispersion, optical signal noise ratios (OSNR) and their effects. Channel Spacing and Signal Direction. Limiting factors to single wavelength. SDH Timing and synchronisation of digital signals, the plesiochronous digital hierarchy (PDH), the synchronous digital hierarchy (SDH), service protection with SDH. TDM. Standards, basic units, frames, STM1 frame, bit rates, STM0, STM1, STM4, STM16, STM64, STM256, SDH architecture, rings, Add drop multiplexors. SDH network topologies, structure of SDH equipment, SDH synchronisation, protection switching in SDH networks, SDH alarm structure, testing of SDH, equipment and systems, Ethernet over SDH. OTN G.709, OTN interface structure, Optical transport modules, ONNI, OCh, OUT, ODU, OPU. G.709 amendments. WDM overview Multiplexing, TDM, WDM benefits. WDM standards. CWDM vs. DWDM. Four Wave Mixing (FWM). Impact and countermeasures to FWM on WDM. DWDM ITU G.694.1, channel and spacing. Optical Terminal Multiplexers (OTM). Optical Add/Drop Multiplexers (OADM). Adding versus dropping. Optical Amplifiers. Erbium Doped Fibre Amplifiers (EDFA). Transponders and Combiners. Optical and Electrical Cross Connects (OXCs/DXCs). Cross Connect types (Transparent/Opaque). Advantages and disadvantages of various Optical cross connects. FTTx Fibre installation and air blown fibre, FTTH, FTTC, FTTN, FTTD, FFTH topologies and wavelengths, active or passive optical network. PON variants Gigabit passive optical network (GPON), Gigabit Ethernet passive optical network (GEPON), Time division PON (TDM-PON), XG-PON, Wave Division Multiplexing PON (WDM-PON), 1Gbps, 10Gbps, 40Ggps, 100Gbps FSAN (Full Service Access Network) NGA (Next Generation Access), Strategies for TDM-PON to WDM-PON migration, Architecture of NG-PON (hybrid WDM/TDM PON), Additional services than triple play.
Who is this course for? The Diploma in Visual Effects for Film and Television Animation is tailored for individuals aspiring to work in the Visual Effects, TV, Film, and 3D animation industry. Gain essential skills necessary for a successful career in these fields. Click here for more info: Website Duration: 120 hours of 1-on-1 Training. When can I book: 9 am - 4 pm (Choose your preferred day and time once a week). Monday to Saturday: 9 am - 7 pm (Flexible timing with advance booking). Course Overview for a 120-Hour Diploma Program in Game Design and Development Term 1: Introduction to Game Design and 3D Modeling (40 hours) Module 1: Introduction to Game Design (1 hour) Understanding the game development industry and current trends Exploring game mechanics and fundamental design principles Introduction to the game engines and tools utilized in the program Module 2: 3D Modeling with 3ds Max (25 hours) Familiarization with 3ds Max and its user interface Mastering basic modeling techniques like box modeling and extrusion Advanced modeling skills including subdivision and topology Texturing and shading techniques tailored for game development Module 3: Character Design and Animation (10 hours) Introduction to character design and its developmental process Creating and rigging characters specifically for games Keyframe animation techniques for character movement Term 2: Game Development and Unity 3D (40 hours) Module 4: Unity 3D Basics (20 hours) Navigating Unity 3D and understanding its interface Grasping fundamental game development concepts within Unity Creating game objects, writing scripts, and designing scenes Introduction to scripting using C# Module 5: Advanced Game Development with Unity 3D (10 hours) Constructing game mechanics including UI, scoring, and game states Working with physics and collision systems in Unity Crafting intricate game environments and level designs Module 6: Game Assets with Photoshop (10 hours) Exploring Photoshop tools and features for game asset creation Crafting game elements such as textures, sprites, and icons Optimizing assets for seamless integration into game development Term 3: Advanced Game Design and Portfolio Development (40 hours) Module 7: Advanced Game Design (20 hours) Delving into advanced game design concepts like balancing and difficulty curves Understanding player psychology and methods for engaging audiences Implementing game analytics and user testing for refinement Module 8: Portfolio Development (24 hours) Building a comprehensive portfolio showcasing acquired skills Effective presentation techniques for showcasing work Establishing a professional online presence and networking strategies Final Project: Creating and presenting a collection of best works in collaboration with tutors and fellow students Please note: Any missed sessions or absence without a 48-hour notice will result in session loss and a full class fee charge due to the personalized one-to-one nature of the sessions. Students can request pauses or extended breaks by providing written notice via email. What can you do after this course: Software Proficiency: Master industry-standard design tools for architectural and interior projects. Design Expertise: Develop a deep understanding of design principles and spatial concepts. Visualization Skills: Acquire advanced 2D/3D rendering and virtual reality skills for realistic design representation. Communication and Collaboration: Enhance communication skills and learn to collaborate effectively in design teams. Problem-Solving: Develop creative problem-solving abilities for real-world design challenges. Jobs and Career Opportunities: Architectural Visualizer Interior Designer CAD Technician Virtual Reality Developer 3D Modeler Project Coordinator Freelance Designer Visualization Consultant Students can pursue these roles, applying their expertise in architectural and interior design across various professional opportunities. Course Expectations: Maintain a dedicated notebook to compile your study notes. Schedule makeup sessions for any missed coursework, subject to available time slots. Keep meticulous notes and maintain a design folder to track your progress and nurture creative ideas. Allocate specific time for independent practice and project work. Attain certification from the esteemed professional design team. Post-Course Proficiencies: Upon successful course completion, you will achieve the following: Develop confidence in your software proficiency and a solid grasp of underlying principles. Demonstrate the ability to produce top-tier visuals for architectural and interior design projects. Feel well-prepared to pursue positions, armed with the assurance of your software expertise. Continued Support: We are pleased to offer lifetime, complimentary email and phone support to promptly assist you with any inquiries or challenges that may arise. Software Accessibility: Access to the required software is available through either downloading it from the developer's website or acquiring it at favorable student rates. It is important to note that student software should be exclusively utilized for non-commercial projects. Payment Options: To accommodate your preferences, we provide a range of payment options, including internet bank transfers, credit cards, debit cards, and PayPal. Moreover, we offer installment plans tailored to the needs of our students. Course Type: Certification. Course Level: Basic to Advanced. Time: 09:00 or 4 pm (You can choose your own day and time once a week) (Monday to Friday, 09 am to 7 pm, you can choose anytime by advance booking. Weekends can only be 3 to 4 hrs due to heavy demand on those days). Tutor: Industry Experts. Total Hours: 120 Price for Companies: £3500.00 (With VAT = £4200) For Companies. Price for Students: £3000.00 (With VAT = £3600) For Students.
CRRUK equips professionals with the concepts, skills and tools to build conscious, intentional relationships, and to coach relationship systems of any size.
This session will combine knowledge as well as practical interactive scenarios to work through to assist delegates in evaluating themselves to identify areas they might need to improve on. The course will cover: The purpose of the role (reminder) How the role has evolved What lessons can be gained so far How do you create a culture of compliance What good systems, policies and procedures look like Easy tips on what, where and how you should be looking Target Audience This online course is suitable for those new to the COFA role, those supporting the COFA and for those that would like a refresher of the role and their responsibilities. Resources An information pack including the course slides, scenarios and suggested answers will be provided to all delegates, which may be useful for ongoing reference. Please note a recording of the course will not be made available. Speaker Sarah Charlton, Consultant, DG Legal Sarah has a BSc (Hons) in Applied Accounting and is a Fellow member of the Association of Chartered and Certified Accountants. Her career spans over 35 years working within the legal sector, fulfilling roles from COFA through to CEO. During her career she has worked with a number of legal regulators, professional bodies and government organisations. Sarah has been a member of the Institute of Legal Finance and Management throughout her career, qualifying as a Fellow member in 2005. Sarah also served as chairperson between 2010-2012 and continues to serve as an Executive Council Member.
Online Asset Management Diploma course. Sit the IAM Diploma anywhere in the world. February to March 2024
Professional Management is crucial to your company's success. In fact, managers can have the single largest impact on your organisation's productivity and overall profitability, with more influence over employee morale and performance than anyone else.
Project Accounting and Finance Skills: In-House Training Do you manage both project schedules and budgets, but do not have insight into how actual results relate to the approved budget? Do you desire to have more clarity about the relationship between your project's performance with the accounting and financial systems in your organization? Do you need to understand financial and accounting terminology to bridge the gap between the 'world of finance' and the 'world of project management? Organizations have a need to manage-by-projects, because projects are the means to deliver on strategic goals and objectives. Therefore, the project manager must have an understanding of the financial world of investments to ensure the organization will realize expected business value. This requires a foundation in the principles of accounting and finance to comprehend how the project's contribution provides an organization with a competitive advantage. Learn what you must do to give your organization the assurance it needs that its investment in your project will realize business value. Learn what you must do to give your organization the assurance it needs to know that its investment in your project will realize business value. What You Will Learn At the end of this program, you will be able to: Explain the aspects of classical corporate accounting and finance effects on managing projects Determine how your project fits into the corporate income statement, balance sheet, and cash flow statement Analyze the financial aspects of managing projects Use earned value management as the basis for decision making throughout the project life Recognize the importance of the project manager's financial responsibilities Focus on what PMs do and should be doing, in support of accounting and finance Use financial information within a project environment to meet financial results Track and analyze the project's financial status and forecast with the goal of realizing benefits Generate work performance data to ensure a project's outcome aligns with financial metrics Foundation Concepts Accounting and Finance Terms and Concepts Accounting and Finance Essentials Financial Terms and Concepts Projects as Financial Investments Overview of 'Two Worlds' Project as Investments Accounting and Finance World: Standards, Principles and Practices Accounting and Finance Standards and Principles Accounting and Finance Practices Capital Budgeting Corporate Budgeting Accounting and Finance World: Economic Project Selection Methods Economic Project Selection Methods Economic Project Selection and the Business Case Project Management World Project Management and Financial Controls Project Management and Work Performance Data Project Management and Earned Value Management Project Management and Work Performance Reporting
Disciplined Agile Senior Scrum Master (DASSM): In-House Training Do you want to take Disciplined Agile® to a new level? Are you looking for tools to solve complex problems and enhance your organization's agility? Do you want to learn how to lead your team to excellence? Expand your knowledge and build practical skills around Disciplined Agile®, business agility, leadership, and team development. Disciplined Agile Senior Scrum Master is a nine-lesson, instructor-led course that shows you how to use the Disciplined Agile tool kit to solve a variety of advanced problems, work with allies within your organization, and optimize how teams work. You will gain knowledge in planning, reporting and metrics, and coordinating activities, as well as how to meet challenges in these areas. And you'll develop the skills you need to foster emotional intelligence, resolve conflicts, and lead high-performance teams at any stage of development. Filled with activities, supplemental reading, and more, this course will prepare you to take the Disciplined Agile Senior Scrum Master (DASSM) exam and, equally important, start using Disciplined Agile immediately within your leadership role. What You Will Learn After the completion of this course, you will be able to: Accelerate your ability to lead high-profile initiatives that are critical to enterprise success Take a deep dive into the Disciplined Agile® tool kit to develop a comprehensive understanding of the hundreds of practices and strategies it contains and the trade-offs of applying them Apply the Disciplined Agile tool kit in hands-on exercises to guide your team in choosing and evolving your best way of working (WoW) in real-life situations Use the tool kit to solve complex challenges commonly encountered in development and operational teams, the value stream, and at the enterprise level Learn how to design and implement metrics that measure your improvements in areas where your teams are struggling Understand how to nurture emotional intelligence Feel confident empowering others on your team(s) Learn how to lead your teams in any situation to improve value delivery for your customers Apply the Disciplined Agile tool kit to guide your team in choosing and evolving the best way of working (WoW) in the situation you face Be prepared to take the Disciplined Agile® Senior Scrum Master (DASSM) exam and earn a valuable, credible certification Roles and responsibilities of DASSM Tuckman Team Development Model Emotional intelligence and why it is essential to team performance Business agility Tactical scaling factors in more complex situations Disciplined DevOps layer 'Test-first' method as it relates to the quality of requirements Scope and purpose of the value stream layer Coordinate activities process goal and why it is important Value creation structure of teams DA™ tool kit to optimize the flow of work and solve challenges related to coordinating and collaborating across teams, or within a larger team of teams Thomas-Kilmann Conflict Resolution Planning Five levels of scope Metrics