26842 Courses in Manchester delivered Online

Ideal for those already using Excel but who really want to get to grips with formulas and functions. Course overview Duration: 1 day (6.5 hours) Our Excel Mastering Formulas and Functions course looks at how to confidently use formulas and functions within Excel. It looks at how to correctly construct formulas and explains how to build common formulas such as working with percentages. It investigates a range of built in Excel functions and shows you how to use the formula auditing tools to help when things go wrong.  This course is aimed at existing users of Excel who want to further their skills. Participants should be able to confidently create and amend worksheets. Objectives By the end of the course you will be able to: Construct Formulas Use a range of common Functions Work with absolute and relative references in formulas Create percentage calculations Use named ranges in formulas Use the XLOOKUP command Create formulas with date and use date functions Use formulas in conditional formatting Use a range of Count functions Use the formula auditing tools Content Formulas vs Functions Constructing formulas Using functions Common Excel functions Using the function wizard vs the formula bar Formulas in tables Absolute vs relative references in formulas Using absolute references in formulas Using partial absolute referencing Range Naming Naming ranges Using range names in formulas Single and multi-cell ranges Working with percentages Creating formulas with percentages Percentage breakdowns Percentage increases Formatting as a percentage Using Lookups Using XLOOKUP to insert information from other spreadsheets Calculating with dates Calculating with dates Using date functions Using formulas in conditional formatting Using conditional formulas Using functions in conditional formatting Count functions COUNT COUNTA COUNTBLANK Formula auditing Using the auditing facility Tracing how formulas are made up Tracing precedents and dependants Evaluating formulas Error checking Showing formulas on a sheet

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables

Look at the in depth features of charts and some specialist tools to make your charts come to life. Course overview Duration: 1 day (6.5 hours) Our Excel Charting Specialist course examines how to unlock the full potential of Charts in Excel. It investigates the useful tools needed for creating bespoke Charts, allowing you to creatively present data more visually. By the end of the course, you will have an awareness of the tools used for creating more advanced Charts and will be able to create your own Dynamic Charts. The course is designed for existing users of Excel who are looking at more advanced ways to visualise data in Excel using Charts. Objectives By the end of the course you will be able to: Create and Amend Charts Format multiple areas of a Chart Use a Combo Chart Apply Conditional Formatting to a Chart Create Dynamic Charts Work with Custom Formatting Create an Advanced Dynamic Chart Content Creating and amending charts Creating Simple Charts Using the Chart Design tab Adding Chart Elements Changing the type of Chart Formatting charts Format Chart Area Format Data Series Format Data Point Format Axis Working with combo charts Adding additional data to a Chart Customising Chart types Creating Clustered Column/line Charts Applying conditional formatting on charts Using IF Statements Highlighting Max/Min Data points in Charts Using Series Overlap Dynamic charts Creating dynamic Target vs Actual Charts Introducing the NA function Hiding data used for Charts Custom formatting charts Formatting Data Labels Customising number formats Using Trend Arrows to show changes Editing Format Code Advanced dynamic charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Combining all elements to create an Advanced Chart Using Error Bars to create a line Adding a scroll bar and linking with data

Course Overview Naresh IT's DevOps Online Training is a comprehensive program that explores the multifaceted realm of DevOps. Covering essential components, from foundational concepts to advanced tools and methodologies, this course delves into industry-best practices. DevOps is an innovative approach that combines software development (Dev) and IT operations (Ops) to promote collaboration, enhance efficiency, and boost productivity throughout the software development lifecycle. Participants can learn through live classes, either with or without videos, tailored to their preferences. Description This course provides in-depth training on DevOps principles, practices, and tools used in modern software environments. Topics include version control, continuous integration, continuous delivery, automation, infrastructure as code, and monitoring. Hands-on experience with tools like Git, Jenkins, Docker, Kubernetes, Ansible, and Terraform ensures a practical understanding of DevOps concepts. Course Objectives Understand the fundamental concepts and principles of DevOps. Learn about various DevOps tools and their usage in development and deployment. Gain proficiency in implementing continuous integration and continuous delivery pipelines. Master automation techniques for infrastructure provisioning, configuration management, and deployment. Acquire skills in containerization and orchestration using Docker and Kubernetes. Develop the ability to monitor, measure, and improve DevOps processes and systems. Prepare for industry-recognized DevOps certifications to enhance career prospects. Prerequisites Basic understanding of the software development lifecycle (SDLC). Familiarity with version control systems (e.g., Git). Knowledge of CI/CD concepts. Understanding of containerization technologies (e.g., Docker). Awareness of cloud computing platforms (e.g., AWS, Azure). Experience with the command line interface (CLI). Who can learn this course This course is suitable for: Software developers System administrators Operations engineers Quality assurance professionals IT managers Anyone interested in adopting DevOps practices for improved software delivery and IT operations efficiency. No prior experience with DevOps is required, although a basic understanding of software development and IT concepts is beneficial.

Duration 4 Days 24 CPD hours This course is intended for Hadoop Developers Overview Through instructor-led discussion and interactive, hands-on exercises, participants will navigate the Hadoop ecosystem, learning topics such as:How data is distributed, stored, and processed in a Hadoop clusterHow to use Sqoop and Flume to ingest dataHow to process distributed data with Apache SparkHow to model structured data as tables in Impala and HiveHow to choose the best data storage format for different data usage patternsBest practices for data storage This training course is the best preparation for the challenges faced by Hadoop developers. Participants will learn to identify which tool is the right one to use in a given situation, and will gain hands-on experience in developing using those tools. Course Outline Introduction Introduction to Hadoop and the Hadoop Ecosystem Hadoop Architecture and HDFS Importing Relational Data with Apache Sqoop Introduction to Impala and Hive Modeling and Managing Data with Impala and Hive Data Formats Data Partitioning Capturing Data with Apache Flume Spark Basics Working with RDDs in Spark Writing and Deploying Spark Applications Parallel Programming with Spark Spark Caching and Persistence Common Patterns in Spark Data Processing Spark SQL and DataFrames Conclusion Additional course details: Nexus Humans Developer Training for Spark and Hadoop 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 Developer Training for Spark and Hadoop 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.

Infection prevention and control is essential for all businesses, particularly where the working environment or work activities could put employees and those around them at risk of infection. This includes those working in healthcare, in close contact with people or animals, and those involved in the cleaning of human and animal waste. Infections can be easily spread, but by understanding the correct steps to take, the risk of their occurrence can be both prevented and controlled.

Time for you to talk, explore and work through challenges you are facing... I help individuals find / reconnect with their passion & purpose, so they get up & do what they love! Giving people direction, self-confidence and belief to do the thing they want to do... Through 1:1 coaching, I create a space that supports people to explore and find solutions; giving clarity, confidence and energy to move forwards. ​If you feel stuck in your life or career, frustrated or unsure of how to move forwards, don't know what you want to do next... that's ok - we can work through your challenges at your pace over a series of coaching sessions that works for your time and budget.

Duration 1 Days 6 CPD hours This course is intended for This course is intended for: Developers responsible for developing Deep Learning applications Developers who want to understand concepts behind Deep Learning and how to implement a Deep Learning solution on AWS Overview This course is designed to teach you how to: Define machine learning (ML) and deep learning Identify the concepts in a deep learning ecosystem Use Amazon SageMaker and the MXNet programming framework for deep learning workloads Fit AWS solutions for deep learning deployments In this course, you?ll learn about AWS?s deep learning solutions, including scenarios where deep learning makes sense and how deep learning works. You?ll learn how to run deep learning models on the cloud using Amazon SageMaker and the MXNet framework. You?ll also learn to deploy your deep learning models using services like AWS Lambda while designing intelligent systems on AWS. Module 1: Machine learning overview A brief history of AI, ML, and DL The business importance of ML Common challenges in ML Different types of ML problems and tasks AI on AWS Module 2: Introduction to deep learning Introduction to DL The DL concepts A summary of how to train DL models on AWS Introduction to Amazon SageMaker Hands-on lab: Spinning up an Amazon SageMaker notebook instance and running a multi-layer perceptron neural network model Module 3: Introduction to Apache MXNet The motivation for and benefits of using MXNet and Gluon Important terms and APIs used in MXNet Convolutional neural networks (CNN) architecture Hands-on lab: Training a CNN on a CIFAR-10 dataset Module 4: ML and DL architectures on AWS AWS services for deploying DL models (AWS Lambda, AWS IoT Greengrass, Amazon ECS, AWS Elastic Beanstalk) Introduction to AWS AI services that are based on DL (Amazon Polly, Amazon Lex, Amazon Rekognition) Hands-on lab: Deploying a trained model for prediction on AWS Lambda Additional course details: Nexus Humans Deep Learning on AWS 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 Deep Learning on AWS 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 Duration: Half-day or full-day program (with virtual delivery options) Target Audience: Mid-to-senior level leaders, executives, managers, HR professionals, and leadership development coaches looking to enhance their leadership capabilities and create high-performing teams. Course Objectives By the end of this course, participants will be able to: Understand the role of coaching in leadership development and high-impact performance. Learn effective coaching strategies to inspire and elevate team performance. Develop skills in active listening, providing feedback, and fostering accountability. Enhance their ability to set clear goals, motivate teams, and create a culture of continuous improvement. Build an action plan for coaching their teams towards high-impact performance. Course Outline Module 1: The Role of Leadership in High-Impact Performance What defines high-impact leadership and performance? The difference between managing and coaching: leadership approaches that drive results The impact of leadership on organisational culture, productivity, and morale Essential leadership competencies for driving high performance Module 2: The Coaching Mindset Understanding the coaching mindset: shifting from directive leadership to empowering leadership Coaching as a tool for leadership development and team performance The benefits of a growth mindset in leadership and performance Key attributes of an effective coach: empathy, active listening, emotional intelligence Module 3: Key Coaching Skills for Leaders Active listening: asking the right questions, listening beyond the words Giving and receiving feedback: providing constructive feedback to motivate and improve performance Building rapport and trust with team members Coaching for growth: helping individuals unlock their potential and build confidence Challenging and supporting: knowing when to push for growth and when to provide support Module 4: Setting Clear, Achievable Goals The importance of goal-setting in coaching for high-performance Setting SMART goals (Specific, Measurable, Achievable, Relevant, Time-bound) Aligning team goals with organisational objectives and strategy Techniques for holding team members accountable to their goals Creating a culture of continuous feedback and improvement Module 5: Motivating and Inspiring Teams The psychology of motivation: intrinsic vs extrinsic motivation Leveraging strengths: identifying and utilising team members’ core strengths for high impact Building team ownership: fostering a sense of responsibility and autonomy Using recognition and reward systems to motivate performance Building resilience: coaching through setbacks and challenges Module 6: Coaching for Performance and Development Balancing short-term performance goals with long-term development needs Identifying potential and growth opportunities in your team Conducting effective one-on-one coaching sessions: structure and frameworks Using assessments and data to drive coaching decisions (e.g., 360-degree feedback, performance metrics) Encouraging self-reflection and self-coaching in team members Module 7: Leading through Change and Uncertainty Coaching leaders to navigate change: resilience in times of uncertainty The role of leadership in creating clarity and stability during change Helping teams embrace change and uncertainty with a growth mindset Leading with emotional intelligence during periods of transition Module 8: Action Planning for High-Impact Leadership Coaching Reflecting on your coaching style and leadership strengths Developing an action plan for coaching individual team members and leading high-performing teams Defining key coaching strategies and techniques for ongoing leadership development Creating a culture of feedback and continuous growth within your team Setting up regular check-ins and performance reviews to monitor progress Delivery Style Highly interactive with coaching demonstrations, role-playing, and peer-to-peer coaching exercises Real-world case studies and leadership scenarios to apply key concepts Practical tools, templates, and frameworks for implementing coaching in the workplace Personal action planning for leadership development and team performance Group discussions and reflection activities Course Materials Provided Leadership Coaching Framework and Templates SMART Goals Worksheet and Coaching Conversation Guide Feedback and Accountability Tools Leadership Development Action Plan Resource list: Books, podcasts, and articles on leadership coaching Optional Add-ons One-on-one leadership coaching sessions for personalised development Post-course check-ins and follow-up coaching to track progress Group coaching sessions for team leaders to share best practices and support one another Tailored modules focused on specific leadership challenges (e.g., change management, team dynamics)

Course Duration: Half-day or full-day program (with virtual delivery options) Target Audience: Mid-to-senior level leaders, executives, managers, HR professionals, and leadership development coaches looking to enhance their leadership capabilities and create high-performing teams. Course Objectives By the end of this course, participants will be able to: Understand the role of coaching in leadership development and high-impact performance. Learn effective coaching strategies to inspire and elevate team performance. Develop skills in active listening, providing feedback, and fostering accountability. Enhance their ability to set clear goals, motivate teams, and create a culture of continuous improvement. Build an action plan for coaching their teams towards high-impact performance. Course Outline Module 1: The Role of Leadership in High-Impact Performance What defines high-impact leadership and performance? The difference between managing and coaching: leadership approaches that drive results The impact of leadership on organisational culture, productivity, and morale Essential leadership competencies for driving high performance Module 2: The Coaching Mindset Understanding the coaching mindset: shifting from directive leadership to empowering leadership Coaching as a tool for leadership development and team performance The benefits of a growth mindset in leadership and performance Key attributes of an effective coach: empathy, active listening, emotional intelligence Module 3: Key Coaching Skills for Leaders Active listening: asking the right questions, listening beyond the words Giving and receiving feedback: providing constructive feedback to motivate and improve performance Building rapport and trust with team members Coaching for growth: helping individuals unlock their potential and build confidence Challenging and supporting: knowing when to push for growth and when to provide support Module 4: Setting Clear, Achievable Goals The importance of goal-setting in coaching for high-performance Setting SMART goals (Specific, Measurable, Achievable, Relevant, Time-bound) Aligning team goals with organisational objectives and strategy Techniques for holding team members accountable to their goals Creating a culture of continuous feedback and improvement Module 5: Motivating and Inspiring Teams The psychology of motivation: intrinsic vs extrinsic motivation Leveraging strengths: identifying and utilising team members’ core strengths for high impact Building team ownership: fostering a sense of responsibility and autonomy Using recognition and reward systems to motivate performance Building resilience: coaching through setbacks and challenges Module 6: Coaching for Performance and Development Balancing short-term performance goals with long-term development needs Identifying potential and growth opportunities in your team Conducting effective one-on-one coaching sessions: structure and frameworks Using assessments and data to drive coaching decisions (e.g., 360-degree feedback, performance metrics) Encouraging self-reflection and self-coaching in team members Module 7: Leading through Change and Uncertainty Coaching leaders to navigate change: resilience in times of uncertainty The role of leadership in creating clarity and stability during change Helping teams embrace change and uncertainty with a growth mindset Leading with emotional intelligence during periods of transition Module 8: Action Planning for High-Impact Leadership Coaching Reflecting on your coaching style and leadership strengths Developing an action plan for coaching individual team members and leading high-performing teams Defining key coaching strategies and techniques for ongoing leadership development Creating a culture of feedback and continuous growth within your team Setting up regular check-ins and performance reviews to monitor progress Delivery Style Highly interactive with coaching demonstrations, role-playing, and peer-to-peer coaching exercises Real-world case studies and leadership scenarios to apply key concepts Practical tools, templates, and frameworks for implementing coaching in the workplace Personal action planning for leadership development and team performance Group discussions and reflection activities Course Materials Provided Leadership Coaching Framework and Templates SMART Goals Worksheet and Coaching Conversation Guide Feedback and Accountability Tools Leadership Development Action Plan Resource list: Books, podcasts, and articles on leadership coaching Optional Add-ons One-on-one leadership coaching sessions for personalised development Post-course check-ins and follow-up coaching to track progress Group coaching sessions for team leaders to share best practices and support one another Tailored modules focused on specific leadership challenges (e.g., change management, team dynamics)