• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

40190 Courses delivered Online

Get Smart With QuickBooks 2021 for Windows

By Nexus Human

Duration 2 Days 12 CPD hours Overview What's New in This Guide? Automatic Payment Reminders for open customer invoices Ability to automatically include the PO# (purchase order number) to Invoice Emails Able to combine multiple emails which allows you to attach multiple sales or purchasing documents to a single email Quickly locate a company file using the new company file search feature Smart Help is an improved search experience that includes access to live experts through messaging and call back options This course covers all features that are in QuickBooks Pro and Premier 2020 and prepares you for the QuickBooks Certified User exam. This course combines all topics in the two 1 day courses ?Get Started with QuickBooks 2021 for Windows? and ?Keep Going with QuickBooks 2021 for Windows?. First-time QuickBooks users will learn the basic features of the software. Experienced QuickBooks users will quickly learn the new features and functionality of QuickBooks 2021. Getting Started Starting QuickBooks Setting QuickBooks Preferences Components of the QuickBooks Operating Environment Using QuickBooks Help Identifying Common Business Terms Exiting QuickBooks Setting Up a Company Creating a QuickBooks Company Using the Chart of Accounts Working with Lists Creating Company Lists Working with the Customers & Jobs List Working with the Employees List Working with the Vendors List Working with the Item List Working with Other Lists Managing Lists Setting Up Inventory Entering Inventory Ordering Inventory Receiving Inventory Paying for Inventory Manually Adjusting Inventory Selling Your Product Creating Product Invoices Applying Credit to Invoices Emailing Invoices Setting Price Levels Creating Sales Receipts Invoicing for Services Setting Up a Service Item Changing the Invoice Format Creating a Service Invoice Editing an Invoice Voiding an Invoice Deleting an Invoice Entering Statement Charges Creating Billing Statements Processing Payments Displaying the Open Invoices Report Using the Income Tracker Receiving Payments for Invoices Making Deposits Handling Bounced Checks Working with Bank Accounts Writing a QuickBooks Check Voiding a QuickBooks Check Using Bank Account Registers Entering a Handwritten Check Transferring Funds Between Accounts Reconciling Checking Accounts Entering and Paying Bills Handling Expenses Using QuickBooks for Accounts Payable Using the Bill Tracker Entering Bills Paying Bills Entering Vendor Credit Memorizing Transactions Entering a New Memorized Transaction Editing a Memorized Transaction Deleting a Memorized Transaction Grouping Memorized Transactions Using a Memorized Transaction Printing the Memorized Transaction List Customizing Forms Creating a Custom Template Modifying a Template Printing Forms Using Other QuickBooks Accounts Other QuickBooks Account Types Working with Credit Card Transactions Working with Fixed Assets Working with Long-Term Liability Accounts Using the Loan Manager Creating Reports Working with QuickReports Working with Preset Reports Sharing Reports Exporting Reports to Microsoft Excel Printing Reports Creating Graphs Creating QuickInsight Graphs Using QuickZoom with Graphs Working with the Sales Graph Customizing Graphs Printing Graphs Tracking and Paying Sales Tax Using Sales Tax in QuickBooks Setting Up Tax Rates and Agencies Indicating Who and What Gets Taxed Applying Tax to Each Sale Determining What You Owe Paying Your Tax Agencies Preparing Payroll with QuickBooks Using Payroll Tracking Setting Up for Payroll Setting Up Employee Payroll Information Setting Up a Payroll Schedule Writing a Payroll Check Printing Paycheck Stubs Tracking Your Tax Liabilities Paying Payroll Taxes Preparing Payroll Tax Forms Using the EasyStep Interview Using the EasyStep Interview Using Online Banking Setting Up an Internet Connection Setting Up Bank Feeds for Accounts Viewing, Downloading, and Adding Online Transactions Creating Online Payments Transferring Funds Online Canceling Online Payments Managing Company Files Using QuickBooks in Multi-user Mode Setting Up Users and Passwords Setting a Closing Date Sharing Files with an Accountant Updating QuickBooks Backing Up and Restoring a Company File Condensing a Company File Estimating, Time Tracking, and Job Costing Creating Job Estimates Creating an Invoice from an Estimate Displaying Reports for Estimates Updating the Job Status Tracking Time Displaying Reports for Time Tracking Tracking Vehicle Mileage Displaying Vehicle Mileage Reports Displaying Other Job Reports Writing Letters Using the Letters and Envelopes Wizard Customizing Letter Templates Additional course details: Nexus Humans Get Smart With QuickBooks 2021 for Windows 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 Get Smart With QuickBooks 2021 for Windows 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.

Get Smart With QuickBooks 2021 for Windows
Delivered OnlineFlexible Dates
Price on Enquiry

Access to Payroll | Sage Payroll Courses

By Osborne Training

Payroll courses in London | Online Courses | Distance Learning Course Overview: Broken down into practical modules this course is a very popular and well-received introduction to moving from manual payroll to computerised payroll, and it incorporates all the new government requirements for RTI reporting Payroll is a vital role within any organisation. A career in payroll means specialising in a niche field with excellent progression opportunities. What support is available? Free high-quality course materials Tutorial support Highly equipped IT lab Student Discount with NUS card Exam fees and exam booking service Personalised individual study plan Specialist Career Management service State of the Art Virtual Learning Campus Free Sage Payroll Software Duration 6 Weeks Study Options Classroom Based - Osborne Training offers Daytime and Weekend sessions for Payroll Training Course from London campus. Online Live - Osborne Training offers Live Online sessions for Sage Payroll Training Classes through the Virtual Learning Campus. Distance Learning - Self Study with Study Material and access to Online study Material through Virtual Learning Campus. Benefits for Trainees Sage Payroll Qualifications open new doors to exciting careers, as well as extending payroll skills if you are currently employed. State of the Art Virtual Learning Campus Start your own payroll bureau Work in small businesses A payroll career can lead to great things Update your knowledge of Sage payroll Improve your employability prospects A career path into payroll Ideal Continuing Professional Development course Gain a qualification to boost your CV Option to gain IAB accredited qualification Start your training immediately without having to wait for the new term to begin Certification You will receive a certificate from Osborne Training once you finish the course. You have an option to get an IAB Certificate subject to passing the IAB exam or Sage certified exam. Syllabus Advanced processing of the payroll for employees Preparation and use of period end HMRC forms and returns preparation of internal reports Maintaining accuracy, security and data integrity in performing payroll tasks. Deductions - Pension schemes and pension contributions Processing the payroll -complex income tax issues Processing Payroll Giving Scheme Processing Statutory Adoption Pay (SAP) Advanced Income tax implications for company pension schemes Student Loan repayments Processing Holiday Payments Processing Car Benefit on to the Payroll System Attachment of Earnings Orders & Deductions from Earnings Orders Leavers with complex issues Advanced processing of statutory additions and deductions Recovery of statutory additions payments - from HMRC Completing the processing of the payroll Complex Reports and payments due to HMRC Introduction to Auto-enrolment Cost Centre Analysis Advanced, routine and complex payroll tasks Calculation of complex gross pay

Access to Payroll | Sage Payroll Courses
Delivered in London or OnlineFlexible Dates
Price on Enquiry

Parents of adult children at risk

By Huntington's Disease Association

Virtual course for parents of adult children at risk/pre manifest. We are pleased to invite you to our virtual course for parents of adult children at risk/pre manifest. This is an opportunity to improve your knowledge of the issues surrounding your adult child at risk, share your experiences and gain ideas of support available for yourself and your adult child. This is a 5 week course running from Thursday 22 February 2024 10am -11.30am until Thursday 21 March, with the final session being an extended session narrative therapy session facilitated by Riverbank Psychology. There will be the opportunity to join a follow up support group. Week 1 – Thursday 22 February 2024 10am Welcome and overview of support available from the Huntington Disease Association. Speaker: James O’Connor – Team Leader HDYES – Huntington’s Disease Association Week 2 – Thursday 29 February 2024 10am Genetics: How to access testing, the process and family planning options Speaker: Chris Platt – SHDA – Huntington’s Disease Association Week 3 – Thursday 7 March 2024 10am Research update and what next Speaker: Nataile Saad - Research Sister - Welcome Trust Southampton University Hospital Week 4 – Thursday 14 March 2024 10am Finances planning ahead Speaker: Lisa Pearson - Financial Advisor - Asset management Week 5 – Thursday 21 March 2024 9.30 -12.30pm (note longer session)* Narrative Therapy: Coping with Feelings, supporting a loved one and self-care. Mariangels Ferrer – Clinical Psychologist – Riverbank Psychology * We will invite previous course participants to this part of the course but can only accommodate a maximum of 12/14 people on the day. The focus of Narrative Therapy in this group is to participate in a creative activity that explores identity through values, beliefs, and support systems, enabling us to make connections to our external lives which will be sustainable in our everyday lives. Mariangels Ferrer Duch is a Clinical Psychologist trained in Narrative Therapy who will be facilitating a three-hour Narrative Therapy session. The focus of the session will be upon the many small things that are important to us in life which can often be overlooked in times of stress. We hope the conversation will help to mutually inspire us all! We take your privacy seriously and promise to never sell your data. You can find out more about your rights, how we use your personal information and how we keep your details safe and secure by reading our privacy policy here. For more information email info@hda.org.uk or call 0151 331 5444.

Parents of adult children at risk
Delivered OnlineFlexible Dates
FREE

Discipline and Grievance

By Underscore Group

Our course empowers you to handle workplace issues effectively and fairly. Learn best practices, procedures, and communication skills to maintain a harmonious and compliant workplace. Course overview Duration: 1 day (6.5 hours) This course will enable participants to manage disciplinary and grievance issues effectively. The emphasis is on the use of a structured approach where positive action and problem-solving is highlighted as a priority. The course will build knowledge, skill and confidence in handling these areas objectively, fairly and appropriately in line with policies/procedures, best practice and legal requirements. Objectives  By the end of the course you will be able to: Describe the purpose of disciplinary and grievance procedures and how these relate to relevant laws and other procedures Know your role as managers in fairly and consistently applying the procedures at the informal and formal stages Explain the grounds for disciplinary or grievance action and the need to collect, assess and present evidence Describe the structure and roles of disciplinary meetings Explain of the basis for reaching fair and reasonable decisions and possible remedies and penalties Describe the grounds and procedure for appeals Content Disciplinary Procedures Employment Contract – what an employee and employer expect and how to manage when broken. Natural Justice – ensuring ‘fair play’. Misconduct v Capability - what is the difference and which process should be used to manage both. Informal v Formal Action – understanding the processes for both informal and formal disciplinary actions. Suspensions – when, why and how to suspend an employee. Investigations – how to undertake a robust investigation and what to include in the report. Disciplinary Meeting – how to conduct the meeting, the different roles involved. Appeals – understanding how people can appeal and the process to appeal. Grievance Procedures What the law requires – what are the legal requirements for handling a grievance. Informal v Formal Action – understanding the processes for both informal and formal grievance procedures. Conducting the hearing – how to undertake a robust hearing and who should be involved. Appeals - how can people appeal and what is the process.

Discipline and Grievance
Delivered in Horsham or OnlineFlexible Dates
Price on Enquiry

Pop singing courses

By LondonSinging

Fans of Taylor Swift, Lady Gaga or Michael Jackson will be pleased to attend our fantastic pop singing courses offered in a relaxed and non-judgmental environment. Sing your favourite songs while improving your vocal abilities immensely. Open to adults from beginners to advanced.

Pop singing courses
Delivered in London or OnlineFlexible Dates
Price on Enquiry

Blues singing courses

By LondonSinging

Enjoy our outstanding blues singing courses for adults and develop the blues growl used by Bessie Smith, Big Bill Broonzy or Little Richard. Discover amazing vocal techniques that will make your blues feel authentic and enhance your vocal abilities under the tutoring of experts.

Blues singing courses
Delivered in London or OnlineFlexible Dates
Price on Enquiry

VMware vSphere: Install, Configure, Manage [v7.0]

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for Software Engineers Senior Software Engineers Java Developers DevOps Engineers Software Developers .NET Developers Systems Engineers Full Stack Developers Full Stack Java Developers Data Scientists Overview By the end of the course, you should be able to meet the following objectives: Describe the software-defined data center (SDDC) Explain the vSphere components and their function in the infrastructure Install and configure VMware ESXi™ hosts Deploy and configure VMware vCenter Server Appliance™ Use VMware vSphere Client™ to manage the vCenter Server inventory and the vCenter Server configuration Manage, monitor, back up, and protect vCenter Server Appliance Create virtual networks with vSphere standard switches Describe the storage technologies supported by vSphere Configure virtual storage using iSCSI and NFS storage Create and manage VMware vSphere VMFS datastores Use the vSphere Client to create virtual machines, templates, clones, and snapshots Create a content library and deploy virtual machines from templates in the library Manage virtual machine resource use Migrate virtual machines with VMware vSphere vMotion and VMware vSphere Storage vMotion Create and manage a vSphere cluster that is enabled with VMware vSphere High Availability and VMware vSphere Distributed Resource Scheduler™ Discuss solutions for managing the vSphere life cycle Use VMware vSphere Update Manager™ to apply patches and perform upgrades to ESXi hosts and virtual machines This five-day course features intensive hands-on training that focuses on installing, configuring, and managing VMware vSphere© 7, which includes VMware ESXi? 7 and VMware vCenter Server© 7. This course prepares you to administer a vSphere infrastructure for an organization of any size. This course is the foundation for most of the other VMware technologies in the software-defined data center Course Introduction Introductions and course logistics Course objectives Introduction to vSphere and the Software-Defined Data Center Explain basic virtualization concept Describe how vSphere fits into the software-defined data center and the cloud infrastructure Explain how vSphere interacts with CPUs, memory, networks, and storage Recognize the user interfaces for accessing the vCenter Server system and ESXi hosts Use VMware Host Client? to access and manage ESXi host Virtual Machines Create and remove a virtual machine Provision a virtual machine with virtual devices Identify the files that make up a virtual machine Explain the importance of VMware Tools vCenter Server Describe the vCenter Server architecture Discuss how ESXi hosts communicate with vCenter Server Deploy and configure vCenter Server Appliance Use the vSphere Client to manage the vCenter Server inventory Add data center, organizational objects, and hosts to vCenter Server Use roles and permissions to enable users to access objects in the vCenter Server inventory Back up vCenter Server Appliance Monitor vCenter Server tasks, events, and appliance health Use vCenter Server High Availability to protect a vCenter Server Appliance Configuring and Managing Virtual Networks Create and manage standard switches Describe the virtual switch connection types Configure virtual switch security, traffic-shaping and load-balancing policies Compare vSphere distributed switches and standard switches Configuring and Managing Virtual Storage Identify storage protocols and storage device types Discuss ESXi hosts using iSCSI, NFS, and Fibre Channel storage Create and manage VMFS and NFS datastores Explain how multipathing works with iSCSI, NFS, and Fibre Channel storage Deploy virtual machines on a VMware vSAN? datastore Virtual Machine Management Use templates and cloning to deploy new virtual machines Modify and manage virtual machines Create a content library and deploy virtual machines from templates in the library Dynamically increase the size of a virtual disk Use customization specification files to customize a new virtual machine Perform vSphere vMotion and vSphere Storage vMotion migrations Create and manage virtual machine snapshots Examine the features and functions of VMware vSphere© Replication? Resource Management and Monitoring Discuss CPU and memory concepts in a virtualized environment Describe what overcommitment of a resource means Describe methods for optimizing CPU and memory usage Use various tools to monitor resource use Create and use alarms to report certain conditions or events vSphere Clusters Describe options for making a vSphere environment highly available Explain the vSphere HA architecture Configure and manage a vSphere HA cluster Examine the features and functions of VMware vSphere© Fault Tolerance Configure a vSphere cluster using ESXi Cluster Quickstart Describe the functions of a vSphere DRS cluster Create a vSphere DRS cluster vSphere Lifecycle Management Describe how VMware vSphere© Lifecycle Manager? works Use vSphere Lifecycle Manager to update ESXi hosts in a cluster Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware vSphere: Install, Configure, Manage [v7.0] 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 VMware vSphere: Install, Configure, Manage [v7.0] 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.

VMware vSphere: Install, Configure, Manage [v7.0]
Delivered OnlineFlexible Dates
Price on Enquiry

VMware Integrated Openstack: Install, Configure, Manage [V7]

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for Cloud architects, systems engineers, data center administrators, and cloud administrators with experience in a service provider or managed services environment. Overview By the end of the course, you should be able to meet the following objectives: Describe how VMware Integrated OpenStack fits into the VMware SDDC and its use cases List the deployment options and how to install VMware Integrated OpenStack Describe the architecture of VMware Integrated OpenStack and its components Configure tenancy and manage user authentication Integrate the OpenStack Neutron Networking service with VMware NSX-T™ Data Center networking platform Deploy and manage virtual machine instances Monitor VMware Integrated OpenStack with OpenStack monitoring services Design an auto-scale, multitier application using built-in automation tools Manage a VMware Integrated OpenStack control plane using Kubernetes Use the HTML5 Web UI and CLI commands to view and edit the configuration, monitor log files, and view database tables used by VMware Integrated OpenStack components This five-day course provides you with the skills to build a private cloud using VMware© Integrated OpenStack on a proven VMware SDDC. Through a combination of lecture and hands-on labs, this course builds your skills in installing, configuring, and managing VMware Integrated OpenStack. You learn how to offer IaaS and PaaS with advanced networking and security features to end users using VMware Integrated OpenStack. Course Introduction Introductions and course logistics Course objectives References and resources Introduction to VMware Integrated OpenStack Describe what an OpenStack is Describe the services that make up VMware Integrated OpenStack Describe what VMware Integrated OpenStack is Describe what is NFV and how does VIO fit in Understand the licensing model of VIO Understand the use cases of VMware Integrated OpenStack VMware Integrated OpenStack Deployment Understand the role of Kubernetes in the VIO control plane List the VMware Integrated OpenStack deployment models How to perform VIO high-availability deployment How to perform VIO compact installation Pre-requisites for installing VMware Integrated OpenStack How to use the HTML5 web UI / VIOCLI to check the deployment configurations and deployment running status Explain steps involved in patching VIO high availability setup VMware Integrated OpenStack Architecture List the VMs deployed after a VMware Integrated OpenStack high-availability installation Describe the overall architecture of the VIO HA setup List the VIO services running within Kubernetes pods Describe the role of each service Understand ssl certificates in VIO Keystone Authentication Understand keystone use cases and services List the features offered by keystone in VIO How to integrate keystone with LDAP List the configuration, view logs, and database tables related to keystone Glance Images Understand Glance use case and its services List the features offered by Glance in VIO Explain how to create flavors and images Describe how to set up metadata, for example SPBM storage policy List the custom resources/logs and database tables related to Glance Networking with Neutron Understand the Neutron use case and its services Integrate Neutron with NSX-T Data Center List the custom resources, logs, and database tables related to Neutron Managing Instances with Nova Understand Nova use cases and services Understand regions, availability zones, and host aggregates Understand the concept of tenant VDC Nova support for multiple vCenter instances How to deploy an instance using Nova How to resize an instance and view the console logs Configuration and logs related to Nova service Cinder Block Storage Understand Cinder use cases and services List the features offered by Cinder Adding a persistent volume to an instance Explain the Snapshot of a Cinder volume and attach it to another instance List the custom resources, log files, and database tables related to Cinder Monitoring with Ceilometer List the Telemetry use cases and services How to enable Ceilometer in VIO How to monitor the VIO environment using Ceilometer Configuration and log files related to Ceilometer service Automating with Heat Define Heat use cases templates and services Describe use cases of Heat Troubleshooting Concepts List common issues in VMware Integrated OpenStack Use troubleshooting tools Describe simple troubleshooting procedures List and explain Day-2 operations Advanced Features Describe Load Balancer as a Service (Octavia) Explain Firewall as a Service Describe Designate (DNS as a Service) Demonstrate automating scaling Describe selective vCPU pinning Explain SRIOV network redundancy support Describe network trunk services support Describe Live resize Describe hardware passthrough (GPU pass through) Describe external REST API Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware Integrated Openstack: Install, Configure, Manage [V7] 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 VMware Integrated Openstack: Install, Configure, Manage [V7] 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.

VMware Integrated Openstack: Install, Configure, Manage [V7]
Delivered OnlineFlexible Dates
Price on Enquiry

Project Planning and Control

By Underscore Group

Learn how to use Microsoft Project to create and resource robust project plans and how to maintain and track throughout the project lifecycle. Course overview Duration: 1 day (6.5 hours) Our Project Planning and Control course gives you the essential skills to use Microsoft Project to build, resource and monitor project schedules. It looks at initial setup, building plans, using a work breakdown structure and managing resources through to baselining and progressing your schedule. This course is designed for new or existing users of Microsoft Project, and no previous experience of Project is required. Knowledge of planning techniques would be an advantage. Objectives  By the end of the course you will be able to: Create project schedules Build a Work Breakdown Structure Create relationships Set baselines Manage resources Set deadlines and task properties Print and report on your project Update and track project schedules Content Creating a new project Project defaults Project start date Setting default hours per day/week Setting daily working times Project timeline Building a project Creating a work breakdown structure Adding tasks and durations Estimated durations Setting milestones Recurring tasks Linking, Baselining and Resourcing Setting start dates and dependencies Task Inspector Resourcing Assigning resources Filtering available resources Baseline Setting a baseline Removing a baseline Managing resources Resource properties Dealing with over allocations Tasking information Constraint dates Setting deadline Assigning task specific calendars Task types Updating your project Completing work Completing work per resource Updating tasks Updating the project Rescheduling work Change highlighting Printing and reporting Setup and Printing Visual reports Using the Timeline Creating Dashboard reports

Project Planning and Control
Delivered in Horsham or OnlineFlexible Dates
Price on Enquiry

Excel Advanced Statistical Analysis

By Underscore Group

Use some of the hidden statistical analysis tools within Excel to build complex data models. Course overview Duration: 1 day (6.5 hours) This advanced Excel course looks at some of the statistical analysis tools available and gives examples of when they might be used. This course is aimed at advanced users of Excel who work with statistical data often and have a good knowledge of Maths. Objectives By the end of the course you will be able to: Use Goal Seek Create and view scenarios Use Forecast Sheet Create single and double input data tables Create models using the solver Install and use the Analysis Toolpak Create and use array formulas Use a range of advanced Financial and Statistical Excel functions Content Using what if analysis options Using Goal Seek Creating, saving and viewing scenarios Generating a Forecast sheet Solver Creating models Projecting scenarios with Solver Using data tables Creating single input data tables Creating double input data tables Projecting with data tables Financial functions PMT FV NPV Analysing data with Analysis ToolPak Installing the Analysis Toolpak Generating statistical analysis Visualising data using Histograms Array formulas Using embedded Excel Array formulas Create an Array formula Multi and single cell Array formula Using TRANSPOSE to flip rows or columns Use the FREQUENCY Function Use an array to count unique entries in a range Dynamic arrays Spilling data Using the new dynamic array functions Advance functions in formulas Statistical functions:MEAN, MEDIAN and MODERANKLARGE and SMALLMODPERCENTILE Use the AGGREGATE function to sum data in ranges with errors

Excel Advanced Statistical Analysis
Delivered in Horsham or OnlineFlexible Dates
Price on Enquiry