Finance doesn't have to be a puzzle. And if you want to get anywhere with your career, it had better not be! Whatever your role, you have an impact on the financial wellbeing of the organisation you work for, whether you've got specific financial responsibilities or not. This thoroughly practical, fun and enjoyable one-day workshop will help unpuzzle finance for you. It's an ideal opportunity to master the terminology, get to grips with the concepts, learn how 'the finance department' works and understand the part you play. This course will help participants: Appreciate the role and importance of Finance within organisations Be able to recognise and describe some of the common items and jargon used Identify the elements of the Profit & Loss and the Balance Sheet Understand cashflow Make better decisions Manage budgets 1 Introduction Expectations Terminology Key financial principlesAccrualsConsistencyPrudenceGoing concern 2 The three main financial statements Profit & Loss accountIncomeCost of salesGross profitAdministrative expenses ('overheads')Net profit/(loss) for the financial year (the 'bottom line')P&L format Balance SheetTerminologyFixed AssetsCurrent AssetsCurrent LiabilitiesLong-term LiabilitiesCapitalB/S format Cashflow Statement Financial and management information systems 3 Budgets and forecasts Why budget? Types of budget - incremental or zero-based Budgeting for costs - fixed and variable Budgeting for income An eight point plan for budgeting for your department Case study: Small Brother Ltd Problems and solutions 4 Accruals Accruals - what and why? Prepayments 5 Open forum
Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar
The Sales Accelerator programme is a fresh approach to improving business development productivity. It focuses on identifying and using a series of business productivity metrics in order to build a clear action plan for improving sales results - typically within 90 days. The metrics are grouped under three headings: The basic principle is that a small improvement in each area can lead to a significant increase in sales results and productivity. And the object of the programme is to show how best to achieve that. The programme therefore looks at each of these three areas in turn, spending a day on each. Suitable for any and all businesses and all levels of experience and expertise, this is a remarkably practical and hands-on programme. During the workshop, participants discuss, review and apply many proven sales and marketing techniques and personal selling ideas. The goal is to generate and commit to changes and actions that can lead to a 10-30% increase in the next three to six months. There's also a consultancy option, rather than the workshop-based programme. See below for details. Day one - Activity Key objective This first module introduces the Sales Accelerator model. The goal here is to show participants how to increase their pro-active activity levels by around 10%. It covers all aspects of creating new business opportunities, from existing customers and non-customers alike, and is linked to personal activity improvement goals. Main elements Improve the productivity, accuracy and effectiveness of your business approach by using new and unique models and techniques. Different methods of creating and generating new business opportunities in the short, medium and long term. This includes sourcing new business, up-selling, cross-selling, warm calling and gaining referrals. Using organised persistence to track and build new customer revenue. Managing your sales time effectively. Key learning points Sales productivity - understand the dynamics of increasing the combination of activity levels, deal value and conversion rate of proposals/quotations to orders and implement an improvement plan. Sales goal setting: setting business development objectives for quantity and quality - plus tips and tricks of top performers. Maintain a peak activity level, on a consistent basis using 'organised persistence' and structured business development tracking methodology. How to prioritise opportunities and manage your time when sourcing new business. Identify potential new customers - and particularly the decision-makers and influencers - with greater accuracy. Make outbound business or appointment calls with improved confidence, control and results. Day two - Value Key objective To be able to better anticipate, identify, create, and develop business opportunities using a customer / client-focused communication-based business model and consultative skills. Main elements How to develop sales more effectively from new and existing customers; and managing the first appointment with a new customer. Use structured and assertive drawing-out skills to identify, develop and formalise business opportunities and to gain commitment. How to better position your company and your products and services against your main competitors. Create and deliver persuasive business messages based on specific need areas, criteria and value. Key learning points Advanced consultative selling - use a variety of structured and advanced questioning techniques to confidently and efficiently uncover opportunities, need areas and business criteria - confidently and efficiently. Involve the customer/client at all times, and to a far greater degree, and keep better control of business development process. Value message - differentiate your solutions clearly and accurately with customer/client-matched value statements. Presenting the right USPs, features and benefits and making them relevant and real to the customer. Qualification and reading buying signals. Day three (held around four weeks after the first module) - Conversion Key objective This module looks at how to improve the final qualification, progression and conversion of opportunities in your sales pipeline. Also includes price negotiation, overcoming objections and obstacles to gaining agreement. The module begins with a learning review, sharing participants' experiences over the last four weeks in applying the new techniques and skills acquired during the first two modules. This is an opportunity to revisit particularly challenging areas as well as to share and celebrate successes. Main elements Structuring and preparing for negotiating a deal and knowing when and how to move into the 'end-game' mode. Anticipate and answer customer objections and questions more confidently. Build more credibility and proof into your business process to reduce 'buyer's remorse' and speed-up decision-making. Being more assertive and developing better instincts and strategic thinking in progressing quotations and proposals. Key learning points Smart ways to position price, emphasise value and be a strong player without being the cheapest. Becoming more assertive in closing deals, and the importance of organised follow-up on the telephone. Qualify pipeline opportunities with more accuracy, using a proven check-list. Use an 'option generator' to simplify complex proposals, increase business value and close business faster. Writing more effective sales proposal documents and quotations. How best to draw-out, understand, isolate and answer customer objections, negotiate points and concerns. Practical methods of asking for agreement and closing a sale
Duration 5 Days 30 CPD hours The Implementing Cisco Application Centric Infrastructure (DCACI) v1.1 course shows you how to deploy and manage the Cisco© Nexus© 9000 Series Switches in Cisco Application Centric Infrastructure (Cisco ACI©) mode. You will learn how to configure and manage Cisco Nexus 9000 Series Switches in ACI mode, how to connect the Cisco ACI fabric to external networks and services, and the fundamentals of Virtual Machine Manager (VMM) integration. You will gain hands-on practice implementing key capabilities such as fabric discovery, policies, connectivity, VMM integration, and more. This course earns you 40 Continuing Education (CE) credits towards recertification. Additional course details: Nexus Humans Cisco Implementing Cisco Application Centric Infrastructure - Advanced v1.2 (DCACIA) 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 Cisco Implementing Cisco Application Centric Infrastructure - Advanced v1.2 (DCACIA) 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 Motivations: Use and manage containers from first principles & architect basic applications for Kubernetes Roles: general technical audiences & IT professionals CN251 is an intensive cloud native training bootcamp for IT professionals looking to develop skills in deploying and administering containerized applications in Kubernetes. Over the course of five days, students will start with learning about first principles for application containerization followed by learning how to stand up a containerized application in Kubernetes, and, finally, ramping up the skills for day-1 operating tasks for managing a Kubernetes production environment. CN251 is an ideal course for those who need to accelerate the development of their IT skills for a rapidly-changing technology landscape. Additional course details: Nexus Humans Cloud Native Operations Bootcamp 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 Cloud Native Operations Bootcamp 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 2 Days 12 CPD hours This course is intended for This course is aimed at anyone currently working with data who is interested in using data visualisation to more effectively communicate their results. Overview At completion, delegates will understand how data visualisations can be best used to communicate actionable insights from data and be competent with the tools required to do it. Visualising data, and analytics results, is one of the most effective ways to achieve this. This course will cover the theory of data visualisation along with practical skills for creating compelling visualisations from data. Course Outline The use of analytics, statistics and data science in business has grown massively in recent years. Harnessing the power of data is opening actionable insights in diverse industries from banking to horse breeding. The companies doing this most successfully understand that using sophisticated analytics approaches to unlock insights from data is only half the job. Communicating these insights to all of the different parts of an organisation is just as important as doing the actual analysis. Visualising data, and analytics results, is one of the most effective ways to achieve this. This course will cover the theory of data visualisation along with practical skills for creating compelling visualisations from data. To attend this course delegates should be competent in the use of data analysis tools such as reporting tools, spreadsheet software or business intelligence tools. The course will explore the following topics through a series of interactive workshop sessions: Fundamentals of data visualisation Data characteristics & dimensions Mapping visual encodings to data dimensions Colour theory Graphical perception & communication Interaction design Visualisation different characteristics of data: trends, comparisons, correlations, maps, networks, hierarchies, text Designing effective dashboards
Duration 5 Days 30 CPD hours This advanced course teaches the design principles for creating a Citrix Virtual Apps and Desktops virtualization solution. In this training, you will also learn how to assess existing environments, explore different scenarios, and make design decisions based on business requirements. This course covers the Citrix Consulting approach to design and covers the key design decisions through lectures, lab exercises, and interactive discussions. You will also learn about additional considerations and advanced configurations for multi-location solutions and disaster recovery planning. This training will help you prepare for the Citrix Certified Expert in Virtualization (CCE-V) exam. Additional course details: Nexus Humans CWS-415 Citrix Virtual Apps and Desktops 7 Assessment, Design and Advanced Configuration 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 CWS-415 Citrix Virtual Apps and Desktops 7 Assessment, Design and Advanced Configuration 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.
ð¨ Unlock the Secrets of Furniture Restoration! ð¨ Are you ready to breathe new life into old furniture pieces? Imagine transforming worn-out, forgotten chairs into stunning focal points of any room. With our comprehensive course on Furniture Restoration, you'll learn the art and techniques of reviving tired furniture to its former glory and beyond. ðï¸â¨ ð¡ Why Choose Furniture Restoration? Furniture restoration isn't just about fixing broken legs or repairing scratches. It's about preserving history, showcasing craftsmanship, and unleashing your creativity. Whether you're a DIY enthusiast or aspiring professional, this course offers invaluable skills and knowledge that will empower you to tackle any restoration project with confidence. Here's a sneak peek at the benefits you'll reap: Preserve and Repurpose: Instead of discarding old furniture, learn how to restore and repurpose them, reducing waste and contributing to a more sustainable lifestyle. Save Money: Why splurge on brand new furniture when you can breathe new life into existing pieces at a fraction of the cost? Learn cost-effective restoration techniques and save big bucks! Unleash Creativity: From traditional refinishing to innovative upcycling, furniture restoration is a canvas for your creativity. Discover new finishes, techniques, and styles to express your unique vision. Gain Valuable Skills: Master the fundamentals of woodworking, upholstery, surface finishing, and more. These versatile skills are not only practical but also highly sought after in various industries. Personal Satisfaction: There's nothing quite like the sense of accomplishment that comes from transforming something old and neglected into a beautiful, functional work of art. Get ready to impress yourself and others with your newfound talents! ð©âð§ Who is this for? Our Furniture Restoration course welcomes enthusiasts of all levels, including: DIY Hobbyists: Dive into the world of furniture restoration and unleash your inner craftsman. Interior Designers: Enhance your design repertoire by mastering the art of furniture transformation. Antique Enthusiasts: Preserve the beauty and integrity of vintage and antique furniture pieces. Entrepreneurs: Explore the lucrative world of furniture flipping and restoration businesses. No prior experience is necessary-just a passion for creativity and a desire to learn! ð Career Path Embark on a rewarding journey with endless possibilities after completing our Furniture Restoration course: Freelance Restoration Specialist: Offer your restoration services to individuals, businesses, and antique shops. Furniture Designer: Combine restoration skills with design expertise to create bespoke furniture pieces. Retailer or Online Seller: Start your own furniture restoration business, selling refurbished pieces to eager customers. Workshop Instructor: Share your knowledge and passion by teaching others the art of furniture restoration. Interior Decorator: Incorporate restored pieces into your design projects, adding character and charm to any space. With dedication and the skills acquired from our course, you'll be well-equipped to pursue a fulfilling career in the world of furniture restoration. Ready to embark on your journey to becoming a furniture restoration expert? Enroll today and unlock the limitless potential hidden within every piece of furniture! ð FAQ (Frequently Asked Questions) - Furniture Restoration Q1: What is furniture restoration? Furniture restoration is the process of repairing, refurbishing, and preserving old or damaged furniture to restore it to its original condition or enhance its appearance. This can involve various techniques such as repairing structural damage, refinishing surfaces, replacing hardware, and addressing any other issues that may affect the functionality or aesthetics of the piece. Q2: How can I determine if a piece of furniture is worth restoring? Assessing whether a piece of furniture is worth restoring depends on several factors, including its sentimental value, historical significance, craftsmanship, and the extent of damage. Consider factors such as the age and quality of the piece, its potential resale value, and the cost and effort required for restoration. Ultimately, the decision to restore furniture should align with your personal preferences and goals. Q3: What are the basic tools and materials needed for furniture restoration? Basic tools for furniture restoration may include screwdrivers, hammers, chisels, sandpaper, wood glue, clamps, brushes, and various finishing materials such as paint, stain, and varnish. Additionally, specialized tools like furniture clamps, upholstery needles, and wood fillers may be necessary depending on the specific restoration tasks involved. Q4: Can anyone learn furniture restoration, or do I need prior experience? While prior experience in woodworking or furniture repair can be helpful, anyone with an interest in learning can start practicing furniture restoration. There are numerous resources available, including books, online tutorials, workshops, and community classes, that cater to beginners as well as more experienced individuals. Starting with small, simple projects and gradually advancing to more complex ones can help build skills and confidence over time. Q5: What are some common challenges encountered during furniture restoration? Common challenges in furniture restoration include identifying the type of wood and finish used, matching colors and textures when repairing or refinishing, addressing structural weaknesses without compromising integrity, and sourcing appropriate replacement parts or materials. Patience, attention to detail, and a willingness to learn from mistakes are key to overcoming these challenges and achieving successful restoration outcomes. Course Curriculum Module 1 Introduction to Furniture Restoration Introduction to Furniture Restoration 00:00 Module 2 Wood Furniture Restoration Wood Furniture Restoration 00:00 Module 3 Upholstered Furniture Restoration Upholstered Furniture Restoration 00:00 Module 4 Metal Furniture Restoration Metal Furniture Restoration 00:00 Module 5 Wood Furniture Restoration Wood Furniture Restoration 00:00 Module 6 Upholstery Restoration Upholstery Restoration 00:00 Module 7 Leather Restoration Leather Restoration 00:00
Duration 5 Days 30 CPD hours This course is intended for This course is intended for entry-level network administrators, network support and help desk technicians. Overview Upon successful completion of this course, students will be able to build, connect and manage networks, and IP traffic routing. In this course the student will learn to install, operate, configure and secure basic and enterprise networks. Networking BasicsNetworking ModelsNetwork AddressingPacket DeliveryDevice ManagementNetwork Security BasicsAdvanced Network Security with ACLsSwitchesAdvanced Switching ConceptsRoutersAdvanced Routing ConceptsBasic Network ServicesCisco Device ManagementTroubleshooting and Data CollectionAdvanced Switch RedundancyOSPF ConfigurationEIGRP ConfigurationPPP WANsFrame Relay WANsSecure VPNs and Tunneling Additional course details: Nexus Humans Cisco Networking 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 Cisco Networking 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.