4684 Courses in Cardiff delivered Online

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Step into adulthood with entrepreneurial confidence. How well-versed are you in economics? Take this course from Spark Generation and find the basics of a financial education that can transform your adolescent journey.

The objective of this fast track Foundation Diploma in Accountancy - Level 3 qualification (accredited by Othm, UK) is to provide learners with a foundation for a career in a range of organisations in relation to financial management and accountancy. It is designed to ensure that each learner is equipped with knowledge of accountancy, and the skills to adapt rapidly to change and progress with their learning. Successful completion of this fast track Foundation Diploma in Accountancy Level 3 provides learners with the opportunity to progress to further study or employment. Key Highlights of Foundation Diploma in Accountancy - Level 3 (Fast Track) Program Duration: 6 Months (Regular 9 months duration programme available) Program Credits: 60 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Direct entry into Year 1 of a three-year UK Bachelor's degree LSBR Alumni Status No Cost EMI Option Who is this course for? Working Professionals, O-Level holders, professionals working in range of industries looking for a career in finance and accountancy Requirements OTHM Level 3 qualifications can be offered to learners from age 16. OTHM does not specify entry requirements for these qualifications. The learners admitted to the programme should have sufficient capability at the right level to undertake the learning and assessment criteria. The qualification is offered in English. English requirements: If a learner is not from a majority English-speaking country must provide evidence of English language competency. For more information visit English Language Expectations page. Career path Progress to Year 1 of a 3 Year UK Undergraduate Degree qualification after completion of this course Completion of your fast track Foundation Diploma in Accountancy qualification will meet the University standard academic entry requirements. However, each applicant will be subject to individual assessment and other entry requirements which may affect university entry. Certificates Certificate of Achievement Digital certificate - Included Othm courses: Once you complete the course, you would be receiving a digital copy of your Diploma along with its Transcript which can be downloaded from the awarding body website without any additional charge. You can also order Hard copy certificate by paying a nominal cost directly to the awarding body.

Evaluation questions help move people from being unaware of their trouble, into awareness and a desire to change. evaluation questions help buyers explore the extent of the damage their trouble is causing. understand all the benefits of evaluation questions and when to use this the most effectively. Learning Objectives Explain four ways people leave their comfort zone, Describe the consequences of not using Evaluation questions in a major sale, Apply Evaluation questions to build urgency for change Target Audience Managers, Team Leaders, Young Professionals, Sales Professionals, Customer Service Teams

Level 2, 3 & 4 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 10 CPD Courses | Lifetime Access

Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN 1 year email support service Take a look at the consistent excellent feedback from trainees visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Tailored in company training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements General knowledge of the Windows OS Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Thinking and doing the same has got to change. The world we live in is becoming more volatile, uncertain, complex, and ambiguous. Expanding our innovation and design thinking capabilities is a key to unlock solutions for some of our biggest global and local challenges. What do you need to learn, do, and become in order to continue in the current and future environment? It is a powerful combination of knowledge, competencies, and mindset. In an increasingly complicated context, this course provides participants with the knowledge needed to not only learn about innovation and what is needed to make it sustainable in your organization but also to inspire others to innovate and think beyond the obvious,

Every organisation needs leaders who can think and act strategically. This program will help you clarify: Why you exist (strategic purpose) Where you are now (strategic assessment) Where you want to go (strategic development) How to get there (strategic execution)

The course is relevant to anyone requiring an understanding of the use of Agile or looking to adopt it. This includes, but is not limited to, organisational leaders and managers, marketing executives and managers, and/or all professionals working in an Agile environment, including software sesters, developers, business analysts, UX designers, project management office (PMO), project support and project coordinators.

New Covid 19 inspired course to deepen participants understanding of stress, trauma and anxiety. We will work with them to strengthen them and build resilience. This work is particularly relevant to school and other teams returning to school post Covid-19 lock down experiences or similar. The training can be delivered virtually on Teams or Zoom or face to face safely. Course Category Team Building Leadership Emotional needs Description In this course we deepen participants understanding of stress, trauma and anxiety and will work with them to strengthen them and build resilience. This work is particularly relevant to school and other teams returning to school post Covid-19 lock down experiences or similar. The training can be delivered virtually on Teams or Zoom or face to face safely.  Learning Objectives Participants will: Deepen their understanding of stress, trauma and anxiety Develop creative resources for self-care Experience a reflective space in which they feel heard and validated Share narratives and strategies and develop solidarity Create a shared vision for achieving resilience within teams Who Is It For? Any team that is returning to workplace following Covid-19 lockdown or other traumatic events Any team that wants to build strength and resilience Course Content Overview of session, goals and ground rules Confidential listening: story so far… experiences shared – opportunity for mutual support. All shared in strictest confidence unless serious or dangerous. What we know about staying strong and resilient – taught input with short activities covering: Understanding anxiety and stress and how to manage/process both – what’s there already/what’s needed – building a resilience toolkit. What to do about eating, sleeping and worrying? The nature of change and chaos Building trust in each other – with activity The impact of trauma Empowering cooperative teamwork Importance of nurture and inclusion The long view – the power of individual people in our lives who really care and the impact we each make on young people Share collective ideas and resources for building strength Shared vision for a strong, resilient staff – teams that are abiding, constant, durable, established, fast, firm, lasting, firm but flexible, reliable, secure, sound, steadfast, strong, sturdy, sure and well-founded.