Are you interested in becoming a qualified immigration adviser? Do you want to practice immigration law in the UK? Our 3-month immigration law course will teach you everything you need to know! It’s taught by our skilled team of solicitors and qualified immigration advisers, and it includes CPD accredited training to help you further your career.
An 8 week coaching programme like no other. Discover how to build your business, free your time all the while making more money and doing more of the stuff you love. Stop not-earning when you're off on holiday, off for the weekend or off sick... Create a business that works for you, even when you're not there.
Duration 1 Days 6 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who receive Tableau data visualizations from data analysts or from data visualization engineers. These data report recipients want to take advantage of the many Tableau features and capabilities that enable them to explore the data behind the initial analysis, perform additional analysis to ask next-level questions of the data, and to customize visualizations and dashboards to share new insights and create compelling reports. Overview Explore Tableau reports. Analyze data to get answers and insights. Sort and group data for analysis and reporting. Filter views. Prepare reports. Troubleshoot, collaborate, and share views and analysis As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and the computing power to analyze it has increased the use of data analysis and data visualization across a broad range of job roles. Decision makers of all types, including managers and executives, must interact with, interpret, and develop reports based on data and analysis provided to them. Tableau© software is designed for data analysis and the creation of visualizations. Data analysts prepare data, perform initial analysis, and create visualizations that are then passed on to business data-driven decision makers. These decision makers can use Tableau's tools to explore the data, perform further analysis to find new insights, make decisions, and create customized reports to share their findings. Prerequisites To ensure your success in this course, you should have experience managing data with Microsoft© Excel© or Google Sheets? Lesson 1: Exploring Tableau Reports Topic A: Data Analysis Workflow with Tableau Topic B: Explore Views Topic C: Edit Workbooks Lesson 2: Analyzing Data to Get Answers and Insights Topic A: Configure Marks with the Marks Card Topic B: Ask New Questions by Changing Aggregation Topic C: Find Answers with Calculations Topic D: Answer Questions with Table Calculations Lesson 3: Sorting and Grouping Data for Analysis and Reporting Topic A: Sort Data Topic B: Group Data Lesson 4: Filtering Views Topic A: Filter Data to Refine Analysis Topic B: Create Interactive Filters for Reports Lesson 5: Preparing Reports Topic A: Format and Annotate Views to Tell Your Story Topic B: Emphasize Data in Reports Topic C: Animate Visualizations for Clarity Lesson 6: Troubleshooting, Sharing, and Collaborating Topic A: Troubleshoot Data Issues Topic B: Collaborate in Tableau Online Topic C: Collaborate with Non-Tableau Users
Scrum Product Owner Exam Prep: Virtual In-House Training This workshop prepares you for the Scrum.org PSPO™ I certification. A voucher for the exam and the access information you will need to take the exam will be provided to you via email after you have completed the course. NOTE: If you have participated in any of IIL's other Scrum workshops, you can bypass this program and focus on reading/studying the Scrum Guide and taking practice exams from Scrum.org The Product Owner is responsible for maximizing the value of the product and the work of the Development Team. The Product Owner must be knowledgeable, available, and empowered to make decisions quickly in order for an Agile project to be successful. The Product Owner's key accountability is the Product Backlog. Managing, maintaining, and evolving the Product Backlog involves: Establishing a clear vision that engages the Development Team and stakeholders Clearly expressing Product Backlog items Ordering the items in the Product Backlog to best achieve the vision and goals Ensuring that the Product Backlog is visible, transparent, and clear to all Working with the Development Team throughout the project to create a product that fits the customer's need What you will Learn You'll learn how to: Successfully prepare for the Scrum.org PSPO I exam Identify the characteristics of a successful Product Owner Create a powerful vision statement Apply techniques to understand your customers and the market Manage and engage stakeholders Write effective user stories with acceptance criteria Utilize techniques to visualize and prioritize the Product Backlog Participate in the 5 Scrum events as the Product Owner Understand the Product Owner's role in closing a Scrum project Getting Started Introductions Workshop orientation Exam prep preview Fundamentals Recap Agile Manifesto, values, and mindset Product Owner characteristics Good vs. great Product Owner Product Ownership Product ownership Project vision Understand your customers and market Personas Stakeholder management and engagement The Product Backlog User Stories and Acceptance Criteria Preparing User Stories for a Sprint The Product Backlog Visualizing the Product Backlog Product Backlog Prioritization Technical Debt Sprint Planning and Daily Standups Sprint Planning Planning Poker Team Engagement Daily Standups Sprint Review, Retrospectives, and Closing Sprint Reviews Key Agile Patterns Retrospectives Closing the Project
This course is designed to enable candidates to develop the knowledge of the terminology and basic concepts of TOGAF Standard, 10th Edition and principles of Enterprise Architecture. Candidates will also be able to analyze and apply knowledge of TOGAF Standard.
Who is this course for? The 3D Printing Bespoke 1-on-1 Training Course is designed for individuals seeking personalized instruction and hands-on experience in the field of 3D printing. Click here for more info: Website Training: 40 hrs, split as per your availability. When: 9 a.m. to 7 p.m., Mon-Sat. Call 02077202581 to reserve. Live online, or in-person. Option A: AutoCAD 10 hrs, Rhino 16 hrs, Vray 4 hrs, Photoshop 4 hrs, 3D Printing 6 hrs Option B: AutoCAD 12 hrs, 3ds Max 16 hrs, Vray 4 hrs, Photoshop 4 hrs, 3D Printing 4 hrs. Option A: AutoCAD, Rhino, Vray, Photoshop, 3D Printing (Total: 40 hours) AutoCAD (10 hours): Module 1: Introduction to AutoCAD (2 hours) Familiarization with AutoCAD interface and tools Creating, opening, and saving drawings Basic drawing and editing commands Module 2: Drawing and Editing (3 hours) Lines, circles, and arcs Polylines and polygons Modifying objects: Move, Copy, Rotate, and Scale Module 3: Precision Drawing (3 hours) Using coordinate systems Dimensioning and text Hatching and gradients Module 4: Advanced Tools (2 hours) Blocks and attributes Layers and object properties Creating layouts and plotting Rhino (16 hours): Module 1: Introduction to Rhino (2 hours) Navigating the Rhino interface Basic 2D and 3D modeling concepts Creating and manipulating objects Module 2: Advanced Modeling (6 hours) Modeling with curves and surfaces Editing and transforming geometry Building complex 3D structures Module 3: Visualization with Vray (4 hours) Understanding the Vray rendering engine Applying materials and textures Setting up lighting and cameras for realistic rendering Module 4: Presentation and Editing (2 hours) Exporting and sharing Rhino models Post-processing and enhancing designs Photoshop (4 hours): Module 1: Introduction to Photoshop (2 hours) Navigating Photoshop interface Image resolution and size Basic image editing tools Module 2: Image Editing and Enhancement (2 hours) Adjusting colors and tones Using layers and masks Retouching and image manipulation 3D Printing (6 hours): Module 1: Introduction to 3D Printing (2 hours) Basics of 3D printing technology Understanding file formats and requirements Module 2: Preparing 3D Models (2 hours) Model optimization for 3D printing Creating supports and rafts Ensuring successful prints Option B: AutoCAD, 3ds Max, Vray, Photoshop, 3D Printing (Total: 38 hours) AutoCAD (12 hours): Module 1: Introduction to AutoCAD (2 hours) Overview of AutoCAD interface and tools Creating, opening, and saving drawings Basic drawing and editing commands Module 2: Drawing and Editing (3 hours) Lines, circles, and arcs Polylines and polygons Modifying objects: Move, Copy, Rotate, and Scale Module 3: Precision Drawing (3 hours) Using coordinate systems Dimensioning and text Hatching and gradients Module 4: Advanced Tools (4 hours) Blocks and attributes Layers and object properties Creating layouts and plotting 3ds Max (16 hours): Module 1: Introduction to 3ds Max (2 hours) Exploring the 3ds Max interface Navigating viewports and objects Basic modeling techniques Module 2: 3D Modeling (6 hours) Creating and editing 3D objects Modifiers and deformations Working with shapes and splines Module 3: Visualization with Vray (4 hours) Setting up lights and cameras Rendering settings and options Post-production and compositing Photoshop (4 hours): Module 1: Introduction to Photoshop (2 hours) Navigating Photoshop interface Image resolution and size Basic image editing tools Module 2: Image Editing and Enhancement (2 hours) Adjusting colors and tones Using layers and masks Retouching and image manipulation 3D Printing (4 hours): Module 1: Introduction to 3D Printing (2 hours) Basics of 3D printing technology Understanding file formats and requirements Module 2: Preparing 3D Models (2 hours) Model optimization for 3D printing Creating supports and rafts Ensuring successful prints Training Duration: 40 hours Flexible Timings: Students can choose their preferred time slots based on our availability, operating from 9:00 am to 7:00 pm (Monday to Saturday). Pricing Details: Company Rate: £1200 (Plus 20% VAT) = £1440 inc VAT. Student, Self-Financed, and Live Online Rate: £1000 (Plus 20% VAT) = £1200 inc VAT. Who Should Enroll: This course caters to a wide range of individuals, including: Novices: Perfect for beginners unfamiliar with AutoCAD, 3ds Max, Adobe Photoshop, Rhino, Vray, and 3D printing, providing a solid foundational understanding. Architects and Interior Designers: Tailored insights for professionals seeking precision in enhancing their design skills, valuable for design firms. Industry Professionals: Establishes industry benchmarks, offering adaptable education applicable across sectors like interior design, architecture, and civil engineering. Learning Approach: Hands-On Practicality: Emphasizes practical, real-world skills through personalized one-on-one training, available in face-to-face or live online sessions. Step-by-Step Instruction: Experienced instructors guide you systematically through techniques using AutoDesk AutoCAD, Autodesk 3ds Max, Adobe Photoshop, and Trimble Sketchup. What You'll Receive: Certificate of Achievement: Upon completion, receive a certificate validating your expertise. Comprehensive Training Guide: Access an extensive PDF guide compatible with both Windows and MAC. Live Feedback: Connect with your tutor for real-time feedback during sessions and the option to record each session for future reference. Our Benefits: Price Assurance: Guaranteeing exceptional value for your career investment. Personalized Training: Tailored one-on-one sessions, adjusting to your learning pace and style. Flexible Scheduling: Choose your preferred training time and day, available Monday to Sunday, from 9 am to 8 pm. Lifetime Support: Ongoing email and phone support beyond the course completion. Computer Setup Assistance: We assist in configuring your computer for seamless software installation. Referral Benefits: Recommend a friend and enjoy discounts, including significant savings on group training courses. Advantages of Option A: Diverse Skill Enhancement: Acquire proficiency in AutoCAD, Rhino, Vray, Photoshop, and 3D Printing, expanding your skill repertoire. Career Opportunities: Access a wide range of career paths in design, architecture, and 3D printing fields, enhancing your professional prospects. Compelling Visualizations: Craft realistic and visually appealing 3D renderings using Vray, elevating the quality of your design presentations. Image Editing Expertise: Master the art of enhancing design projects with Photoshop, adding finesse to your creative work. Prototyping Prowess: Develop essential skills in 3D Printing, enabling you to create physical design prototypes for various applications. Advantages of Option B: Versatile Skill Mastery: Excel in AutoCAD, 3ds Max, Vray, Photoshop, and 3D Printing, gaining expertise in diverse areas of design and visualization. Career Advancement: Unlock opportunities in architecture, animation, and visualization fields, broadening your career horizons. High-Quality Renderings: Showcase your designs impressively with high-quality renderings generated through Vray, leaving a lasting impact on viewers. Image Editing Mastery: Polish your design concepts and presentations using advanced Photoshop techniques, ensuring your visuals are refined and professional. 3D Printing Expertise: Bring your digital designs to life across various industries, mastering the intricate art of 3D printing. Our training courses cater to both Mac and Windows operating systems and provide: Price Assurance: Ensuring the best value for your investment. Personalized Attention: Benefit from one-on-one training sessions tailored to your learning pace and style. Flexible Scheduling: Choose your preferred time and day for training sessions, available seven days a week from 9 am to 8 pm. Ongoing Support: Enjoy lifetime email and phone support, ensuring you're never alone on your learning journey. Technical Assistance: Receive guidance in configuring your computer for software installation, ensuring a seamless learning experience. Special Benefits: Avail special discounts when you refer a friend and significant savings on group training courses, maximizing the value of your training investment.
Do you want to learn how to crochet, but don't know where to start? Let us help! Our crochet workshop will start from scratch and finish as a confident crocheter. You'll learn the basic stitches and develop onto decorative stitches, so that by the end of the course you can produce a number of products of your choice from decorations to cardigans. We offer one-to-one sessions in the comfort of your own home and are always available for help in between sessions.
Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' 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 course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk 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 classrom, 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate 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
Duration 1 Days 6 CPD hours This course is intended for The Power BI in a Day course is designed for beginners and intermediate users of Power BI. Overview #NAME? Students will discover the full capabilities of Power BI in a one-day, hands-on workshop. Please Note: This workshop is primarily self-directed and students will work at their own pace while having access to an instructor for questions. 1 - Accessing & Preparing data Data Set Power BI Desktop Power BI Desktop ? Accessing Data Power BI Desktop ? Data Preparation 2 - Data Modeling and Exploration Power BI Desktop ? Data Modeling and Exploration Power BI Desktop ? Data Exploration Continued References 3 - Data Visualization Power BI Desktop Power BI Desktop ? Data Visualization References 4 - Publishing & Accessing Reports Power BI Desktop ? Creating Mobile View Power BI Service Power BI Service ? Publishing Report Power BI Mobile ? Accessing Report on Mobile Device Power BI Service ? Collaboration and Distribution References 5 - Dashboard and Collaboration Power BI Service Building Dashboard References Additional course details: Nexus Humans Power BI: Dashboard in a Day 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 Power BI: Dashboard in a Day 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 Information This course aims to empower you with the expertise to proficiently navigate process mapping and master the art of crafting Standard Operating Procedures (SOPs) within regulated environments. Whether you're engaged in activities that demand process improvement, continual enhancement, or SOP creation, this course offers invaluable insights tailored to your needs. It caters to individuals tasked with managing, documenting, and implementing processes and SOPs, irrespective of prior experience or skills. Our curriculum does not focus on specific software or approaches, focusing instead on fundamental principles and adaptable concepts applicable across diverse organisational landscapes. Benefits include: Hands-on experience in mapping processes An understanding of how process maps can be used to define, communicate and continually improve complex processes An understanding of best practice for SOPs using of process maps/process flow diagrams and process mind maps to complement text An insight into the preparation of concise and user friendly SOPs. This course is structured to encourage delegates to: Discuss and develop ideas Develop a practical approach for creating process maps and writing SOPs Understand how to use process maps in SOPs effectively Discuss how process mapping for preparing SOPs can be applied to process improvement for SOPs. Is this course for you? The course is designed for all those with responsibility for managing, documenting and implementing processes and SOPs. It assumes no prior experience or skills. The course does not recommend any specific software or approach, but explores the principles and ideas that can be applied in any organisation. What will you learn? Hands-on experience in mapping processes An understanding of how process maps can be used to define, communicate and continually improve complex processes An understanding of best practice for SOPs using of process maps/process flow diagrams and process mind maps to complement text An insight into the preparation of concise and user friendly SOPs. By the end of the course you will be able to: Create process maps and write clearer more concise SOPs Understand how to use process maps in SOPs effectively Understand how process mapping can be applied to process improvement and better SOPs. Tutors Tutors will be comprised of (click the photos for biographies): Laura Brown Director, Laura Brown Training and Development David Butler VP of Quality, Resolian Programme Please note timings may be subject to alteration. Day 1 09:00 Welcome, Introductions and Course Objectives Why Companies manage by process. 10:00 Exercise 1 - First Steps Mechanisms for process mapping, levels at which it can be applied, and the roles and responsibilities of process owners. 10:30 Exercise 1 - Feedback 10:45 Break 11:00 Mapping Processes The stages involved in mapping processes including how to construct a SIPOC chart. 11:45 Exercise 2 - Mapping A Process A first opportunity to practice your new process mapping skills. 12:30 Exercise 2 - Feedback 13:00 Lunch 14:00 Exercise 3 - Discussion of Options for Format, Structure and Layout What Makes A Good SOP? Discussion of options for format, structure, level of detail of SOPs and the use of process maps for SOP writing. A case study example of a good SOP which uses a flow chart/process map. 14:45 Exercise 3 - Feedback 15:00 Break 15:15 A Case Study example of a good SOP that uses a flow chart / process map 15:30 Exercise 4 Discussion of the content of an SOP using a Process Map 15:35 Exercise 4 - Feedback 15:45 Key Writing Considerations 16:15 Exercise 5 16:45 Exercise 5 - Feedback 17:00 Close of Day Day 2 09:00 Review of Day 1 09:15 Using Metrics Selecting and using metrics to monitor and improve processes. 10:00 Exercise 6 - Practice in Process Mapping Creating Process Maps from multi-source information. 11:00 Break 11:15 Exercise 6 - Feedback 11:45 Common Pitfalls Common problems and tips for good Process Mapping. 12:15 Demonstration of Process Mapping on a PC 12:45 Lunch 13:30 Exercise 7 - Mind Mapping 14:30 Exercise 7 - Feedback 15:00 Break 15:15 Exercise 8 - Using Process Maps to Write an SOP Applying your process mapping skills as part of writing an SOP 15:30 Exercise 8 - Feedback 15:45 Course Review and Follow-up 16:00 Close of Course Extra Information Face-to-face course Course Material Course material will be available in PDF format for delegates attending this course. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course. The material will be emailed in advance of the course and RQA will not be providing any printed copies of the course notes during the training itself. Delegates wishing to have a hard copy of the notes should print these in advance to bring with them. Alternatively delegates are welcome to bring along their own portable devices to view the material during the training sessions. Remote course Course Material This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event. Please note this course will run in UK timezone. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course Access to an online course group to enhance networking. You will need a stable internet connection, a microphone and a webcam. Development Level Learn