8103 Courses 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

Learn how to work with and connect multiple data sets to effectively analyse and report on data. Course overview Duration: 1 day (6.5 hours) Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them. This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability. Knowledge of working with Excel workbooks and relational databases would be an advantage. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Add extra columns of data Append data Merge data from other tables Create data models Build data relationships Build Pivot Tables Build Pivot Charts Use Slicers and Timeline Filters Content Importing data Data sources Importing data Transforming data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Appending queries Appending data from other tables Adding text Columns from example Custom columns Conditional columns Merge queries Setting up and using merge queries Merging in columns of data Creating a data model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Analysing information using pivot tables Creating and modifying a Pivot Table Recalculating the Pivot Table Filtering the Pivot Table Searching the Pivot Table Drilling down to underlying data Customising field names Changing field formatting Pivot charts, slices and timelines Creating Pivot Charts Adding and using Slicers

Learn how create and structure enterprise projects and programmes. Course overview Duration: 2 days (13 hours) Our P6 Project Planning and Controls Fundamentals course is an intensive two day course aimed at experienced planners and project controllers who need to use Primavera to create and manage detailed plans. It includes creating EPS levels, projects, WBS levels and detailed activity and resource planning. Experience of project planning and scheduling techniques is essential. Objectives  By the end of the course you will be able to: Create a programme structure Create projects and set project properties Create programme milestones Create a Work Breakdown Structure (WBS) Create detailed plans including activities, links and resources Progress the schedule Manage actuals Customise layouts Use the reporting tools in Primavera Content Programme Management Creating EPS elements Defining the programme structure Navigating the EPS structure Finding programmes Project Management and WBS Creating projects Setting project properties Validating projects Assigning project codes Building a work breakdown structure Creating a WBS structure Creating WBS elements Work package management Top Down budgets Allocating top down budgets Budget change Programming milestones and activity planning Creating programme milestones Setting constraints Linking milestones Scheduling Using the schedule function Detailed activity planning Creating activities Relationship types Creating relationships Adding milestones Assigning activity codes Resourcing, workloads and baselining Resource types Creating resources Resource attributes Assigning resources Switching resources Split load resource assignment Reduced hours resource assignment Checking workload Reviewing workload Dealing with resource conflicts Assignments view Baselining Creating baselines Assigning baselines Working with layouts Creating layouts Customising columns Setting filters Sorting and grouping Changing the timescale Customising the Gantt Creating activity code breakdown structures Progressing the schedules Updating task status and remaining duration Setting the data date Monitoring and reporting Exporting and importing information Primavera standard reports Creating custom reports Creating portfolios Printing Printing your schedule Printing to other packages

Did you know that sexual harassment continues to be a pervasive issue affecting millions of individuals in the workplace? In fact, studies have shown that a staggering 81% of women and 43% of men have experienced some form of sexual harassment in their lifetime. But there is hope. Introducing our empowering course, "Resolution Strategies for Sexual Harassment," where we provide you with the skills and techniques to address and resolve these incidents effectively. Join us in creating safer work environments as we equip you with the knowledge to prevent, address, and overcome sexual harassment. Together, let's make a stand and foster a culture of respect and dignity. Learning Outcomes: Identify and address instances of sexual harassment, fostering a safe and inclusive work environment. Understand the legal framework surrounding sexual harassment and organisational policies for prevention and resolution. Employ effective strategies to manage and resolve cases of sexual harassment in the workplace. Implement robust policies, procedures, and awareness campaigns to prevent sexual harassment. Navigate the aftermath of sexual harassment incidents through mediation, support mechanisms, and advocacy. Promote a culture of respect and accountability, ensuring the well-being and productivity of all individuals in the workplace. Gain the knowledge and skills to address sexual harassment effectively with our course, "Resolution Strategies for Sexual Harassment." Dive into the legal framework, organisational policies, and effective preventive measures to create a respectful work environment. Equip yourself with practical strategies for managing and resolving instances of sexual harassment. Foster a culture of accountability and support through our comprehensive training program. Ready to be part of the solution? Enrol now and empower yourself with the skills to combat sexual harassment in the workplace. Together, let's create a safer and more inclusive professional environment. Certification Upon course completion, you're eligible for a FREE certificate titled Sexual Harassment Awareness Training in PDF or hardcopy format. The PDF certificate will be sent to your registered email without any cost. For hardcopies, the UK delivery fee is £3.99 and the International delivery fee is £10. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Human Resources professionals responsible for managing and addressing instances of sexual harassment in the workplace. Managers and supervisors seeking to create a safe and respectful work environment, free from sexual harassment. Employees at all levels who want to understand their rights and responsibilities regarding sexual harassment. Individuals interested in promoting awareness, prevention, and resolution of sexual harassment incidents. Career path Human Resources Manager: £35,000 - £60,000 per annum Equal Employment Opportunity (EEO) Specialist: £30,000 - £50,000 per annum Workplace Mediator: £35,000 - £60,000 per annum Diversity and Inclusion Consultant: £40,000 - £70,000 per annum Compliance Officer: £30,000 - £50,000 per annum Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

You and your child will have different deschooling journeys. For those children who have had difficult school experiences and suffered with anxiety, lack of autonomy, or been masking for extended periods of time then the adjustment period can be a rocky one. This webinar proposes three distinct phases that children will journey through and how you can support them through each of those phases. A recording of this webinar is included and available for two weeks after the live event.  These webinars are FREE for Unschooling Village Hub Members along with a back catalogue of Unschooling Webinars, regular live coaching sessions, and discounts on coaching and mentoring services and more. Sign up for just £20 per month. Yes! I want to join the LPL Unschooling Village Hub

A step by step video tutorial on how to paint a Fairytale Fairy for children, beginners, all levels.

DontGoToDramaSchool - Teaching you the screen-acting techniques of the Hollywood stars. "Making quality, industry relevant drama training accessible to all." Don't waste your time and money going to traditional drama school. We teach you screen-acting not stage, at a time when streaming content is booming while theatres are being demolished. And costing a fraction of the price of traditional drama schools, start your training today. Don't wait for term time to begin.

DontGoToDramaSchool - Teaching you the screen-acting techniques of the Hollywood stars. "Making quality, industry relevant drama training accessible to all." Don't waste your time and money going to traditional drama school. We teach you screen-acting not stage, at a time when streaming content is booming while theatres are being demolished. And costing a fraction of the price of traditional drama schools, start your training today. Don't wait for term time to begin.

DontGoToDramaSchool - Teaching you the screen-acting techniques of the Hollywood stars. "Making quality, industry relevant drama training accessible to all." Don't waste your time and money going to traditional drama school. We teach you screen-acting not stage, at a time when streaming content is booming while theatres are being demolished. And costing a fraction of the price of traditional drama schools, start your training today. Don't wait for term time to begin.

DontGoToDramaSchool - Teaching you the screen-acting techniques of the Hollywood stars. "Making quality, industry relevant drama training accessible to all." Don't waste your time and money going to traditional drama school. We teach you screen-acting not stage, at a time when streaming content is booming while theatres are being demolished. And costing a fraction of the price of traditional drama schools, start your training today. Don't wait for term time to begin.