13367 Courses delivered Online

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is an IT, facilities or data centre operations professional working in and around the data centre and having the responsibility to achieve and improve high-availability and manageability of the data centre. Overview After completion of the course the participant will be able to:? Understand the design life cycle of data centres and the stages involved? Discuss the data centre requirements in great level of detail with vendors, suppliers and contractors to ensure that these requirements are met? Validate design plans, quotes and offers proposed by vendors/contractors? Understand redundancy levels for both the data centre design/setup and maintenance? Understand the various building considerations such as bullet proofing, mitigation of seismic activity, fire ratings and thermal stability? Understand how to install a raised floor that meets requirements, avoiding misalignment, level differences and leakage? Understand how to read a Single Line Electrical Diagram to identify and avoid the most common design issues? Choose the correct UPS and parallel configuration, learn and avoid classic parallel installation mistakes? Understand how to calculate battery banks, validate offered configurations to ensure they meet requirements? Understand what distance to keep to avoid EMF issues for human safety and equipment disturbances? Understand the fundamental cooling setup, CFM, Delta-T and other important factors? Understand contamination factors and limitations? Understand full details of fire suppression options, how to calculate gas content and verify installations? Understand how to measure data centre energy efficiency and how to improve it The course will bring participants to the level of a suitable sparring partner with suppliers. They will be able to verify offers provided by vendors for correctness, effectiveness and efficiency. Data Centre Design/Life Cycle Overview Overview of the phases of a data centre life cycle Planning, re-alignment and continuous improvement Standards and Rating Level Definitions Rating level history Difference between Uptime and TIA-942 Rating level definitions Redundancy options (N+1), 2N, 2(N+1) Concurrent Maintainability/Compartmentalisation Example configurations Substation and feed requirements Maintenance options Operational processes guidelines/standards Skill development Building Considerations Building location considerations Floor and hanging loads requirements Fire rating for walls and glass Blast protection Bullet proofing Forced entry protection Advanced Raised Floor & Suspended Ceiling Raised floor installation guidelines Techniques to install a proper and leveled raised access floor Common mistakes Choosing the right tiles and their locations Seismic-mitigating floor constructions Choosing the correct suspended ceiling Advanced Power Power infrastructure layout; Formulas which you should know for the data centre Single Line Electrical diagrams; how to read to ensure key components are present for protection Over current protection devices (MCB/MCCB/VCB/ACB/Fuses) definitions and what to use where Earth Leakage devices (RCB/RCD/ELCB/GFCI/ALCI/RCBO), definitions and what to use where Sizing of protective components Lightning strikes and surge protection devices (TVSS/SPD), how they operate, where to use and how to install Power cabling and cable run considerations PDU/DB setup and minimum requirements Generators; Generator types: Standy/Prime/Continuous Component make up and functions Fuel storage and calculation Paralleling of gen-sets Generator room/area requirements UPS Systems; Required specifications for UPS systems How to read data sheets and select the correct UPS Requirements for parallel configurations and avoid pitfalls such as single point of failures How parallel installation should be done, classic mistakes made by installers and how to avoid these Harmonic Filters; Active/Passive filters and their application Battery Banks; Battery bank terminology Designing battery banks, how to calculate, and double check the battery bank to be installed Battery charging pitfalls and ensuring the right charger is being installed and used Using parallel battery banks; how to properly install them, limitations and risks when using batteries in parallel How to test batteries correctly and make decisions on cell/block or string replacement Battery casing choices; ABS, V0, V1, V2 Alternative energy storage; flywheel, re-usable cell, compressed air UPS, etc. Advanced Electro Magnetic Fields Sources of EMF Difference between single, three phase and bus-bar EMF Options available to measure EMF and how to interpret the results from single-axes and composite measurements Guidance on safe distance for equipment and humans Calculation of EMF attenuation factor for shielding material permeability and saturation factors Advanced Cooling Important definitions; dry-bulb, wet-bulb, dew-point, RH, sensible and latent heat Psychometric chart and ASHRAE recommendations Environmental class definitions and thermal specifications Temperature/humidity measurements guideline Heat dissipation methods Altitude impact on temperature intake to ICT equipment Floor plan setup for effective cooling Differences in tile surface and supporting structure and the air-flow performance impact Rack door construction and the flow performance impact Equipment Delta-T and its impact Optimising air flow Thermal units conversions Calculations for air volume displacement (CFM/CMH) Cooling capacity calculations Air-conditioning selection De- / humidifying options Air conditioning efficiency SHR impact on cost saving Efficiency indicator New cooling principle and techniques (Submerged, VSD/VRF/ECF/water- and air side economisers) Redundancy guidelines for air-conditioners avoiding classic misconceptions and mistakes for meeting ANSI/TIA-942 compliant designs Installation requirements Connections to fire panel and EPO Commissioning of air conditioners Set points and calibration CFD (Computational Fluid Dynamics) Advanced Fire Protection The fire triangle and elements to stop a fire Detection systems in detail (VESDA, VIEW, smoke sensors) Considerations for installation of sensors Proper testing of smoke sensors Water based systems i.e. deluge, wet-pipe, dry-pipe, pre-action and why most of them don't work and how to detect this Details on Inert and Halocarbon systems and how to select the correct system for your data centre How to calculate the gas content ensuring the appropriate level is installed to suppress the fire including safety considerations Other requirements for gas systems such as release times, hold times, pipe install requirements and other important factors Requirements for the fire detection panel Installation verification, methods, what to check and how New advanced fire suppression technologies Design and Install Scalable Networking Cabling System ANSI/TIA942 cabling structure topology ToR, EoR Design Intelligent patching systems Installation best practice such as routing, bending radius, separation from power, containment fill ratio, fiber link loss calculator, bonding and grounding requirement Standard for telecommunications labeling and administration Environmental Specifications and Contamination Control Acoustic noise effects, regulations, specifications and limits Data centre contaminations and classifications Measurements, standards and limits Preventive measures and avoidance Data Centre Efficiency Business drivers to go Green High-availability or Green? Green guidelines and standards How to measure it and what are acceptable numbers compared to the general industry PUE classes defined by Green Grid and issues with PUE Techniques for saving energy in all parts of the data centre i.e. application/system level, cooling, power distribution Mock ExamEXAM: Certified Data Centre Specialist

Adobe After Effects Training Fundamentals to Essentials. Learn essential techniques for creating visual effects and animations. Adobe After Effects Essentials VFX Course to learn auto-correction methods and tools, adjust video effects or presets to layers, and utilize 3D space for modifying composition. Click here for more info: Website Duration: 20 hours Approach: 1-on-1 personalized sessions and Tailored content. Flexibility: Book a time convenient for you, Monday to Saturday, between 9 am and 5 pm. Duration: 20 Hours Module 1: Introduction to After Effects (2 hours) Understanding the After Effects interface Project planning and organization techniques Module 2: Asset Preparation and Composition Setup (3 hours) Importing and organizing multimedia assets Setting up compositions for different media formats Module 3: Applying Transformations and Effects (5 hours) Animating images, videos, and text Applying diverse transformations and effects for dynamic visuals Module 4: Mastering Masking and Compositing (5 hours) Creating and refining masks for precise editing Advanced compositing techniques for seamless integration Module 5: Rendering High-Quality Videos (3 hours) Configuring rendering settings for various output formats Ensuring optimal quality in the final video output Module 6: Project Review and Q&A Session (2 hours) Reviewing projects and addressing individual queries Fine-tuning techniques based on participants' needs Course Benefits: Hands-on learning with personalized attention Mastering crucial After Effects skills for diverse media projects Access to recorded lessons for future reference Continuous email support for post-course inquiries After Effects Download  https://www.adobe.com Upon completing the Essential After Effects Skills Mastery course, participants will: Proficiency in After Effects: Master the After Effects interface, gaining confidence in navigating the software effectively. Strategic Project Planning: Acquire skills in project organization and planning, ensuring a systematic approach to video projects. Advanced Asset Management: Learn efficient techniques for importing, organizing, and managing multimedia assets within After Effects projects. Dynamic Composition Creation: Gain expertise in setting up compositions tailored to various media formats, understanding their intricacies and potential applications. Creative Animation Techniques: Apply diverse transformations and effects to images, videos, and text, enhancing the visual appeal of multimedia content. Precision in Masking and Compositing: Master the art of masking, enabling precise editing, and explore advanced compositing techniques for seamless visual integration. High-Quality Video Rendering: Understand rendering settings, ensuring optimal video quality for different output formats, whether for online platforms or professional presentations. Project Review and Refinement: Engage in project reviews and Q&A sessions, refining techniques and addressing individual queries for comprehensive learning. Confidence in Video Production: Develop confidence in producing high-quality videos, equipped with a robust skill set essential for various creative projects. Continuous Learning Support: Benefit from continuous email support, providing assistance with post-course inquiries, ensuring ongoing learning and skill refinement. In this course, you will learn: Efficient workflow planning and asset organization in After Effects projects. Creative project development techniques for engaging visuals. Image and video asset preparation using Photoshop. After Effects project setup, compositions, and asset integration. Animation of transformations and effects on layers. Advanced mask creation and animation for creative compositing. Dynamic text animation and 3D exploration. Keying and seamless visual integration techniques. Understanding export settings, project backup, and archiving. Learning Objectives: Upon completion, you will master asset organization, animations, masks, text effects, and seamless integration, ensuring proficiency in After Effects projects. Prerequisites: Basic computer skills and a fast-paced learning mindset are required. No prior experience is necessary, making this course suitable for beginners. Key Features: Personalized one-on-one or live online coaching sessions. Suitable for both beginners and professionals in motion graphics and animation. Tailored Training: Courses customized to meet your specific requirements. Flexible scheduling options to suit your availability. Industry Standard: Adobe After Effects, the industry-preferred software for visual effects, motion graphics, and compositing. Widely used in filmmaking, video games, and TV production. Learning Approach: Hands-on training with detailed, step-by-step demonstrations. Real-time feedback during sessions, along with access to session recordings. Course Benefits: Certificate of Attendance upon completion. Comprehensive practical training guide for reference. Lifetime email and phone support for continuous assistance. Help with software installation for a seamless learning experience. Lifetime Support: Ongoing email and phone/WhatsApp support for lifelong learning assistance. Elevate your motion graphics expertise with our Adobe After Effects Basic to Fundamentals Training Course. Open doors to exciting opportunities in the ever-evolving realm of visual effects.

Effective Presentation Skills (Virtual) In today's results-oriented, global working environment, the ability to create and deliver presentations effectively is a necessary skill set for people at all levels of an organization. Regardless of your role, it's important to know how to synthesize your ideas into a coherent and focused narrative, add visuals that support and reinforce your message, and deliver it in a way that resonates with your audience. In this highly interactive course, we will unpack and practice some of the tools and techniques used by top speakers and influencers all over the world. In this engaging two-day course, you will plan, write, refine, practice, and deliver a presentation to the class. Your presentation will be filmed on both days, and you will leave the course with a flash-drive copy of your videos; participants of the virtual classroom workshop should be prepared to present via webcam. In addition to discovering and enhancing your own personal delivery style, you will learn how to create an overarching goal for your presentation and then organize and structure it for maximum impact. You'll gain insight into how to anticipate your audience's needs and tailor the content and delivery in a way that connects with them and sustains their attention and engagement. You will also learn skills that will help you control nervous energy, remain focused on and attuned to your audience, improvise under pressure, deal effectively with questions, and build a compelling call to action. What you will Learn At the end of this program, you will be able to: Construct an effective presentation goal statement, opening, body, and closing that connect with an audience Analyze an audience's needs and style preferences, including relevant DiSC®-related elements Deliver a complete criteria-based presentation that will persuade others Align usage of visuals as well as verbal and non-verbal techniques to maximize the impact of your presentation Getting Started Introductions and social agreements Course structure Course goals and objectives Opening activities Planning and Organizing Video: 'The Art of Misdirection' Setting your presentation goal Writing a goal statement Analyzing your audience Applying the 'reality' test Creating and strengthening supports Structuring your presentation 5 components of an effective opening Presentation body Presentation closing Write your presentation opening Audience Analysis Video: 'How to Tie Your Shoes' Everything DiSC® introduction Audience DiSC® Styles Analyzing your audience Further audience analysis Effective Delivery Delivery challenges and in-person Keeping your audience engaged Your body as your instrument Verbal / paraverbal elements Body stance and nonverbal communication What are your 'tells?' Controlling nervousness Staying attuned to your audience Responding to questions Review and edit your opening Deliver your opening Visuals and Enriching Elements Using images in your presentation Guidelines for visual composition Using questions to engage your audience The power of the pause Practicing and Applying What You've Learned Preparation Delivery Feedback Opportunity to put into practice the program content and receive a video copy Summary and Next Steps What did we learn and how can we implement this in our work environment? Your personal action plan

We communicate daily in many ways, including email, phone, text, Zoom, Teams, Google Meets, Slack, and even that old-fashioned thing, what was it now... oh yes, talking face-to-face. But, when we look at communication closely and really drill down into what we are doing in conjunction with how our brain works (neuroscience), how internal, organisational, and social politics control what we believe we can say, how hierarchical positioning impacts our honesty and how the lack of psychological safety means we say what we know others want to hear rather than what they need to hear…. It is oh so complicated! This workshop not only explores the concept of excellent communication, but we also want to hear what you believe it is too. We also delve into how organisational culture influences our perception of speaking up. Factors that hinder open and honest communication, and we work collaboratively towards removing these barriers to achieve a communication style that fosters trust and transparency, creating psychological safety. This workshop is particularly relevant to our Emotional Intelligence workshop (EI and Me). We firmly believe that developing emotional intelligence is the key to unlocking Clean Communication, a skill that is crucial for all of us, regardless of our roles and responsibilities, so that we thrive in our professional environment. If you want to see if we are correct, why not have us facilitate a workshop for you and see what you get by the end of it?  LENGTH - Normally, one day. But please contact us to discuss your specific needs, or we can offer advice. NEXT WORKSHOP START - Please ask for more information as we deliver bespoke closed events for your people at your location or a mutually suitable location. WORKSHOP DELIVERY - The best environment for this workshop is face-to-face, but we can facilitate this workshop online. Suitability - Who should attend? Who Should Attend and Why? Who? - Perhaps think of this another way… who shouldn’t attend to ensure we can attain Clean Communication? There’s your answer. Why? - Every person needs to understand what we are saying above about how we get trapped in this organisational formatting which changes how we communicate and how it prevents us from communicating cleanly. EVERY organisation has this, despite what our values profess. And 'Values', that’s a whole other story. Workshop Content Using the 'Moccasin Approach'® to clean our personal and organisational communication LaPD’s Communication Cycle and what we must consider. (Can you work out what the ? represent above? Accountability and Responsibility raises its head in Communication. It has to. Bias, unconscious bias and its impacts on our communication. The conundrum of communicating with others and their styles (The TRAP). How would my perfect Manager/Leader communicate with me? Nonverbal communication (body language), rapport, Clean Communication. Negative communication can go viral (Self-Fulfilling Prophecy). Reflections, findings and goals (individual and team). Meeting our workshop objectives by listing five areas for development. Workshop delivery and venue This workshop is usually one day in duration, and it focuses solely on how we communicate with each other. It can also be a two-day event incorporating aspects of Emotional Intelligence (EI) with group, and individual activities to allow discussions about the various communication we need in your organisation. When you consider the content we deliver, we are sure you will understand why we always prefer to deliver our workshops, courses and programmes face-to-face. Face-to-face workshops and courses can be held at a location of your choice or, if you wish, a central UK location, such as the Macdonald Burlington Hotel in Birmingham, located directly across from the Birmingham New Street train station. We can deliver our workshops, courses and programmes online, although this will mean splitting elements into manageable learning events to suit the online environment.

TEACHERS TRAINING COURSES are designed for those of you who are looking to take your dancing skills to a higher level. As the art of belly dance becomes more popular, the demand for teachers is rising and it is an extremely rewarding gift to be able to transfer and share your skills with others. This course is also beneficial for those of you who wish to gain a deeper understanding of Belly Dance and dancing in general. If you’ve ever thought of doing what you enjoy for a living, this is definitely for you.

Diploma in Project and Quality Management - Level 7 is a 120 credits qualification. Project and quality management can be used in a variety of industries to bring projects in on time, on budget and to the right quality. Project management elements of this Diploma in Project and Quality Management - Level 7 course will focus on management techniques and applications to help you plan and implement activities to complete projects to your customers expectations. Quality management elements of the course will help you make sure that the outcome of the project is fit for your customer's purposes. Program Overview: Diploma in Project and Quality Management - Level 7 Key Highlights of Diploma in Project and Quality Management - Level 7 qualification are: Program Duration: 9 Months (Fast Track Mode Available) Program Credits: 120 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Masters Degree programme. Alumni Status No Cost EMI Option Key facts about Level 7 Diploma in Project and Quality Management 100% Online: Study online with the UK's leading online course provider. Global programme: Study anytime, anywhere using your laptop, phone or a tablet. Study material: Comprehensive study material and e-library support available at no additional cost. Payment plans: Interest free monthly, quarterly and half yearly payment plans available for all courses. Why choose LSBR ? Transform your career: Enrol today and make a life changing decision, get necessary knowledge to transform your career. Move up in your career: With our fully accredited course, you can move up to the next level in your organisation with ease. Upgrade your skills: Add value to your current educational profile and achieve skill sets to compete in your job role. Cost effective: Typically a British qualification starts from GBP £3000 per annum, but with LSBR, you enjoy savings of up to 60% on your educational investment. Assessments: Assessment is done through written assignments and/ or dissertation project. Support: We offer live tutor support via online chat and email for all qualifications delivered by us. Career ProgressionLearners completing the Diploma in Project and Quality Management - Level 7 can progress to: A University partner to complete a dissertation to then receive a full master's degree, or Level 8 Diploma qualification, or Directly into employment in an associated profession University ExemptionsLearners can progress to a number of universities to complete a Master's Degree after completing their Diploma in Project and Quality Management - Level 7. This generally requires completion of a Dissertation only. The pathways are an indication of a learner's progress towards a university degree and are based on the university's review of Eduqual's learning programmes and outcomes. As our EduQual accredited qualifications are approved and regulated by Ofqual (Office of the Qualifications and Examinations Regulation)and Scottish Credit and Qualifications Framework (SCQF), learners are also eligible to progress to a Top-Up Degree, Master's programme, or MBA at many universities in UK and Overseas with advanced standing. Our qualifications are credit-rated for the Scottish Credit and Qualifications Framework (SCQF), a globally-recognised national qualifications framework aligned to other recognised frameworks such as the European Qualifications Framework (EQF) and the Ofqual Regulated Qualifications Framework (RQF).

The global financial markets have seen significant volatility in recent months, with shifts in economic policies, geopolitical tensions, and technological advancements driving fluctuations in Forex Trading & Stock Trading. Investors and traders are seeking comprehensive knowledge and strategic insights to navigate these turbulent waters effectively. In today's dynamic financial landscape, mastering Forex Trading & Stock Trading is paramount for anyone aiming to thrive in the investment arena. Our Forex Trading, Stock Trading & Penny Stocks Day Trading QLS Endorsed Diploma offers a comprehensive set of courses, meticulously designed to equip learners with the expertise needed to excel in these domains. With a blend of theoretical insights and practical strategies, this bundle provides a solid foundation for individuals aspiring to conquer the intricacies of financial markets. Whether you're a novice investor or a seasoned trader looking to refine your skills, this bundle caters to diverse skill levels, ensuring holistic development in Forex Trading & Stock Trading. QLS Endorsed Courses: Course 01: Certificate in Stock Market Investing for Beginners at QLS Level 3 Course 02: Certificate in Penny Stocks Day Trading at QLS Level 3 Course 03: Advanced Diploma in Forex Trading at QLS Level 7 CPD QS Accredited Courses: Course 04: Investment Course 05: Stock Market Day Trading Strategies Course 06: Financial Analysis Course 07: Complete Swing Trading Training Course 08: Day Trade Stocks with Price Action and Tape Reading Strategy Course 09: Capital Budgeting & Investment Decision Rules Course 10: Stock Market Investing for Beginners Course 11: Cryptocurrency: Wallets, Investing & Trading Take your career to the next level with our bundle that includes technical courses and five guided courses focused on personal development and career growth. Course 12: Career Development Plan Fundamentals Course 13: CV Writing and Job Searching Course 14: Networking Skills for Personal Success Course 15: Ace Your Presentations: Public Speaking Masterclass Course 16: Decision Making and Critical Thinking Seize this opportunity to elevate your career with our comprehensive bundle, endorsed by the prestigious QLS and accredited by CPD. With industry-specific knowledge and essential career skills, you'll be well-equipped to make your mark in Forex Trading, Stock Trading & Penny Stocks Day Trading QLS Endorsed Diploma. Learning Outcomes: Understand advanced concepts and techniques in Forex Trading & Stock Trading. Develop proficiency through Forex Trading & Stock Trading in analyzing market trends and making informed investment decisions. Implement effective day trading strategies for penny stocks and mainstream stocks alike. Gain insights into financial analysis and its application in investment strategies over Forex Trading & Stock Trading courses. Master swing trading techniques and capitalize on market fluctuations for maximum returns. Enhance personal development skills by learning Forex Trading & Stock Trading such as networking, confidence, time management, and stress management. Explore the world of financial markets through our immersive bundle, encompassing an array of topics vital for success in Forex Trading & Stock Trading. From deciphering market trends to implementing effective trading strategies, participants delve into the intricacies of investment analysis, gaining actionable insights into maximizing returns. With a focus on practical application and theoretical underpinnings, learners develop a nuanced understanding of capital budgeting, investment decision rules, and cryptocurrency trading, equipping them with the tools needed to thrive in dynamic market environments. Whether you're embarking on a career in finance or seeking to augment your existing skill set, this bundle provides a comprehensive roadmap for success in Forex Trading & Stock Trading. CPD 160 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Through this comprehensive course Forex Trading & Stock Trading, you should be able to: Students pursuing degrees in finance, economics, or related fields seeking practical knowledge in Forex Trading & Stock Trading. Working professionals in finance, accounting, or investment management aiming to enhance their skill set and stay abreast of industry trends over Forex Trading & Stock Trading courses. Entrepreneurs and individuals interested in diversifying their investment portfolios and generating passive income streams throughForex Trading & Stock Trading. Anyone passionate about personal development and seeking to sharpen their skills in networking, confidence-building, and stress management within the context of financial markets. Seasoned traders looking to refine their strategies and stay ahead of market trends in the ever-evolving landscape of Forex Trading & Stock Trading. Career switchers exploring opportunities in the finance sector and seeking comprehensive training in Forex Trading & Stock Trading to transition smoothly into new roles. Requirements You are warmly invited to register for this bundle. Please be aware that there are no formal entry requirements or qualifications necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path This Forex Trading & Stock Trading courses are beneficial for anyone looking to build their career as: Financial Analyst Investment Manager Day Trader Stock Broker Hedge Fund Manager Portfolio Manager Financial Consultant Certificates 13 CPD Quality Standard Certificates Digital certificate - Included 3 QLS Endorsed Certificates Hard copy certificate - Included

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

Project Communication Skills (On-Demand) In this course, participants will actively explore best communication practices from a variety of perspectives: in-person, virtual, electronic, and via formal project documentation. Communication is the single most critical project success factor. When effective, projects get executed on time, within budget, and with objectives being met. But that isn't all. Strong communication also nurtures healthy team relationships. And in today's highly diverse world, where projects are often fast-paced, complex, and virtual, that is more important than ever. Strong communication skills foster cultural awareness, trust, and empathy. Together, they contribute greatly to project success-and ultimately, to future project success. In this course, participants will actively explore best communication practices from a variety of perspectives: in-person, virtual, electronic, and via formal project documentation. In order to be transformative, however, those perspectives will be filtered further through the lens of their formal, personalized assessment. It is a powerful tool which identifies individuals' internal needs and priorities. It translates those into descriptive profiles and reports, gifting users with valuable information about themselves and others. Paired with the course's real-world activities, it will provide uniquely strategic opportunities for communicating effectively and meaningfully-and with less conflict, both personally and professionally. What You Will Learn At the end of this program, you will be able to: Identify basic elements of communication and explain how they affect teams Explore how your assessment style impacts you and how you communicate with people of other styles Infer how your style impacts the way(s) you send and interpret emails and instant messages Analyze real world email and instant messaging practices to determine how they affect communication and relationships Explore best practices for formal project communications and presentations Analyze how your assessment style and global diversity can contribute to both strong team communication and conflict Identify solutions for virtual team work communication challenges Getting Started Foundation Concepts Communication as a foundation skill Elements of communication Communicating across media Targeting your audience How communication impacts team performance The Assessment Framework Overview of the assessment's approach Exploring assessment report Increasing your effectiveness with other assessment styles Email and Instant Messages Preferred communications and assessment styles The email brands we create Assessment styles and email Emotion and email Email guidelines and best practices Anatomy of an email The seven deadly email sins Instant messages and other interfaces Project Communications and Presentations Communicating across the project lifecycle Project templates Structuring a presentation Delivering a presentation Interpersonal and Team Communication Skills Communication styles and techniques Managing conflict in a project environment Styles and conflict Communication and global team leadership Virtual Communication Leading global virtual teams Virtual processes and technology Virtual team leadership Summary and Next Steps

Revit face to face training customised and bespoke. Online or Face to Face