Our brand new Online GCSE Mathematics Course is the international version. This course aims to develop your knowledge and understanding of mathematical concepts and techniques to provide a foundation of mathematical skills for further study. Through studying this course, you will become more confident in applying mathematical techniques and concepts to solve problems and you will develop an understanding of the importance of maths in everyday life. The same International GCSE qualification you'd get in school or college Unlimited 1:1 support from your Maths tutor Fast-track - get the qualification when you need it Study 24/7, 365 on your phone, tablet or laptop You don't need any previous qualifications to study this International GCSE course. This course will teach you the Edexcel International GCSE Maths syllabus (4MA1). You'll study 6 units: Numbers and the number system Equations, formulae and identities Sequences, functions and graphs Geometry Vectors and transformation geometry Statistics For a full breakdown of course content, download the IGCSE Maths Brochure. All of your lessons and assessments are available on CloudPort - our Moodle-based learning environment (Moodle VLEs are used by most colleges and universities in the UK). Start with lesson 1 and work through the course in a linear pathway or choose to jump to the section that you need. Your learning is completely flexible and allows you to set your programme of learning around the skills you need. Submit assessments as you work through the course. Get instant results and feedback on activities to track your progress. Use these assessments as learning launchpads, allowing you to focus your time on the topics you need to brush up on. You will have access to all course materials, assessments and tutor support for 12 months from the day of enrolment. Extensions are available for students who wish to study over a longer period. You are not alone! You will be assigned a personal 1:1 tutor on your day of enrolment. Your tutor will remain by your side, throughout your learning journey until you get qualified. All tutors are qualified teachers and subject matter specialists who will ensure you have the correct guidance and support when you need it. As a CloudLearn student you will have unlimited access to tutor support. CloudLearn GCSEs and A-Levels are structured around formative assessments allowing you to test your knowledge as you work towards qualification. Before taking your exam you will submit a mock exam to give you the practise you need before the big day. When ready we arrange your exam. We have agreements with exam centres all over the UK. Our students also take advantage of preferential pricing due to the volume of students we channel to exam centres. As part of your enrolment service package we will make all the arrangements for your final exam. This includes locating a centre and booking the relevant exam/s. Exam fees are additional. Exam fees can be bundled using the Exam Bundles drop down when adding to basket. Have a look on our Exams Page for a detailed explanation of this service. The Edexcel International GCSE Maths exam is available in May/June and Oct/Nov each year. It is assessed over 2 exam papers: Paper 1 4MA1 1F/1H - 2 hour Paper 2 4MA1 2F/2H - 2 hour We generally ask that you book written exams at least 6 months in advance. Booking your exam after the booking deadline will incur late fees (available for one month after deadline) and high late fees (available up until exam entry closure). Some students will study for the exam over a period of months or years, as they dictate their own study schedule. We do however have students who will study intensively and prepare in a matter of weeks. You are only constrained by the exam diet. GCSE exams are available in May/June of each year, with core subjects also assessed in January. We are so confident in the CloudLearn model of study that we guarantee you will pass your exam. As long as you do what we recommend, we offer a full money-back guarantee. The UK's only GCSE and A-Level specialist Study at your pace, where and when you want Study interactively on any device We guarantee your exam pass We arrange your exams Our flexible study, unlimited support, and interest-free payment plans allow you to fit learning around your busy schedule That's why we support thousands of students every year, to get the GCSEs they need to prosper. Choose to pay in full or spread the cost over our 6 months interest-free payment plans. We offer longer payment plans of 12, 24, 36 or 48 months. These extended plans are subject to interest. For more details contact our student advisors on 0330 111 4006 or visit our payment plan page. During your Online GCSE Mathematics Course experience you will gain a multi-faceted skill-set that will be useful in further learning or a variety of professions. You will acquire a foundation of mathematical skills that will be invaluable in any course or career-path. You will also bolster your problem-solving, critical thinking, analytical and interpretative skills through translating mathematical or non-mathematical problems into a series of mathematical processes and solving them. You will also be challenged to use this new knowledge innovatively. Additionally, you will improve your communication and organisational skills through learning how to accurately disseminate complex mathematical techniques, processes and solutions. Furthermore, through open-mindedness and appreciating your social responsibility as a student, you will learn the importance of mathematics in society, employment and study. We also hope to show you the benefits of continuous learning and intellectual curiosity by inspiring a sustained enjoyment of, and interest in mathematics. Thus, the skills that you will gain through participating in the CloudLearn GCSE Mathematics Course will set you apart from other candidates when you are applying for further studies or taking your first steps on your chosen career-path.
Conflict Resolution and Mediation in International Relations Course Overview This course, "Conflict Resolution and Mediation in International Relations," offers an in-depth exploration of the complexities of global conflicts and the mechanisms used to resolve them. Students will gain a thorough understanding of the theories, practices, and institutions that play a key role in mediation and conflict management within the context of international relations. Emphasising the practical application of conflict resolution, the course explores contemporary case studies, providing learners with the essential skills to engage in diplomatic negotiations. By the end of the course, participants will be equipped to navigate the intricate dynamics of international diplomacy and contribute meaningfully to peace-building efforts globally. Course Description "Conflict Resolution and Mediation in International Relations" delves into the foundational theories and methods that underpin the field of conflict resolution within the international sphere. Key topics include the historical context of international conflicts, the roles of global actors, and an analysis of the major theories of international relations, such as realism, liberalism, and constructivism. Students will explore contemporary challenges such as global economic tensions, regional conflicts, and the role of international organisations in peace-building. This course is designed to offer learners a comprehensive understanding of conflict dynamics and the strategies for resolution, equipping them with essential diplomatic, negotiation, and analytical skills. Learners will emerge with the capability to analyse complex international issues and formulate effective strategies for conflict resolution in the global context. Conflict Resolution and Mediation in International Relations Curriculum Module 01: Understanding International Relations Module 02: Historical Context Module 03: Actors in International Relations Module 04: Theories in International Relations I: Realism and Liberalism Module 05: Theories in International Relations II: The Marxist, The Constructivist and The Feminist Tradition Module 06: International Political Economy Module 07: Recent Issues in International Relations Module 08: War Module 09: International Organisation (See full curriculum) Who is this course for? Individuals seeking to understand the dynamics of global conflict and its resolution. Professionals aiming to enhance their career in international diplomacy or global governance. Beginners with an interest in international relations and global issues. Students considering careers in international organisations or conflict resolution. Career Path Diplomat International Relations Consultant Conflict Resolution Specialist Political Analyst Foreign Affairs Advisor International Development Officer United Nations/NGO Specialist
This two day programme is designed to support participants to work through the technical steps and stages as well as the more practical realities of project management.
Overview Education and training can significantly influence one's ability to flourish. This Focus Awards Level 4 Certificate in Education and Training (RQF) qualification will encourage you to think strategically and critically, allowing you to perform successfully.This 36-credit Level 4 Certificate in Education and Training (RQF) qualification is offered by Focus Awards. This honourable awarding organisation is regulated by Ofqual and assures competence and recognition of your qualifications.The remarkable course is crafted into mandatory and optional units so you can acknowledge the concepts better. It starts with the basic insights and proceeds towards advanced levels to encourage you to focus. It covers almost every aspect of education and training. You will discover ingenious ways to teach, learn, and assess alongside other professional practices. You'll become a useful employee capable of innovating, tackling challenges, and progressing on your own. So what are you waiting for? Roll up your sleeves and get yourself enrolled in this thriving certification! Benefits You Will Gain Top-notch e-learning materials Modules availability 24/7 An easy-to-use online learning platform Flexible learning hours Recognised qualification Exquisite customer service Qualification Focus Awards Level 4 Certificate in Education and Training (RQF) Description Learners must complete all mandatory units totalling 21 credits along with 15 credits from the remaining optional units to create a total credit value of 36.From this qualification, you will: Know the roles, responsibilities and relationships in education and training. Understand how to assess learners in education and training. Develop and prepare resources for learning and development. Meet the needs of learners. Qualification Purpose The Focus Awards Level 4 Certificate in Education and Training (RQF) qualification is designed to provide students with knowledge and understanding of delivering education and training, assessing learners, using resources, and understanding the roles and responsibilities in relevant fields. Who is this course for? Individuals interested in pursuing a career as an Education and Training Specialist, Teacher or other related fields. Requirements This qualification has no specific entry requirements. However, the learners must be at least 18 or above. Progression Upon successfully completing this qualification, learners may wish to continue their development by undertaking the following qualification. Level 5 Diploma in Education and Training (RQF) Total Qualifications Time Total Qualification Time is comprised of GLH and an estimate of the number of hours a learner is likely to spend in preparation, study or any other learning, including assessment, which takes place as directed by, but not under the supervision of a lecturer, supervisor or tutor. Total Qualification Time for this qualification is 360 hours.The credit for this qualification is 36. Guided Learning Hours These hours are made up of all contact time, guidance or supervision of a learner by a lecturer, supervisor, tutor, trainer or other appropriate providers of education or training. Guided Learning Hours for this qualification is 140. Method of Assessment The Focus Awards Level 4 Certificate in Education and Training (RQF) is internally assessed, and each student must construct a portfolio of evidence demonstrating the achievement of all learning outcomes and assessment criteria linked with each unit, like- Assessor observation - completed observational checklists on related action plans. Witness testimony Learner product Worksheets Assignments / projects / reports Record of oral and written questioning Learner and peer reports Recognition of prior learning (RPL) Career Path Education and Training Specialist Child and Youth Program Assistant Academic Advisor English Educator Teacher Professional Trainer Course Curriculum 42 sections • 187 lectures • 00:00:00 total length •Induction Form: 00:00:00 •Registration Entry Form: 00:00:00 •0 - Certificate Units - Information for Delivery: 00:00:00 •0 - Resource Information and Terms and Conditions of Use: 00:00:00 •At018c - Pre Course Assessment Certificate: 00:00:00 •At050c - Sample Action Plan for the Certificate in Education and Training: 00:00:00 •Pgu1c - Guidance for Evidencing Achievement - Understanding Roles , Responsibilities and Relationships: 00:00:00 •Sau1c - Self Assessment Grid - Understanding Roles, Responsibilities and Relationships: 00:00:00 •G9001C - Information leaflet - An introduction to the Certificate in Education and Training: 00:00:00 •G9002C - Information leaflet - Teaching Roles, Responsibilites, Relationships and Boundaries: 00:00:00 •G9003C - Information leaflet - Legislation, Regulatory Requirements, Codes of Practice: 00:00:00 •G9007C - Information leaflet - Promoting Equality and Valuing Diversity: 00:00:00 •G9008C - Information leaflet - Promoting Appropriate Behaviour and Respect: 00:00:00 •I0001A - PP - Learner Needs and Points of Referral: 00:00:00 •I9001C - Information leaflet - Learner Needs and Points of Referral: 00:00:00 •M9063a - Information Leaflet - Beginners Guide to Referencing: 00:00:00 •G0001C - PP - An Introduction to the Certificate in Education and Training: 00:00:00 •G0002A - PP - Teaching Roles, Responsibilities, Relationships and Boundaries: 00:00:00 •G0003A - PP - Legislation, Regulatory Requirements and Codes of Practice: 00:00:00 •G0007A - PP - Promoting Equality and Valuing Diversity: 00:00:00 •G0008A - PP - Promoting Appropriate Behaviour and Respect: 00:00:00 •H9001 - Handout - Identifying Inequality: 00:00:00 •H9002 - Handout - Learner Differences: 00:00:00 •H9003 - Handout - Ways to promote and advance equality: 00:00:00 •H9004 - Glossary of educational terms: 00:00:00 •H9005 - Educational abbreviations and acronyms: 00:00:00 •H9007 - Demonstrating good practice to promote inclusion: 00:00:00 •H9008 - Handout - Safeguarding Prevent British Values: 00:00:00 •H9010 - Handout - Table of examples of teaching roles and responsibilities: 00:00:00 •H9011a - Handout - Boundaries of Teaching: 00:00:00 •H9014C - Verbs used in the Certificate in Education and Training units: 00:00:00 •H9015 - Handout - the Teaching and Learning Cycle: 00:00:00 •H9020a - Handout - Table of Examples of Potential Needs and Points of Referral: 00:00:00 •H9051 - Handout - Tips for New Teachers and Trainers: 00:00:00 •HC004 - Checklist for Equality and Diversity: 00:00:00 •Hc012 - Checklist for Teaching: 00:00:00 •I9011- Handout - Equality and Diversity - Glossary of Terms: 00:00:00 •0 - Certificate Units - Information for Delivery: 00:00:00 •0 - Resource Information and Terms and Conditions of Use: 00:00:00 •Pgu2c - Guidance for Evidencing Achievement - Planning to Meet the Needs of Learners: 00:00:00 •Sau2c - Self Assessment Grid - Planning to Meet the Needs of Learners: 00:00:00 •Atmc01 - Checklist - Minimum Core Personal Skills: 00:00:00 •Hc012 - Checklist for Teaching: 00:00:00 •Hc014 - Checklist for Reviewing Own Practice - Planning: 00:00:00 •AT005 - Template - Reflective Learning Journal: 00:00:00 •At007 - Template - Session Plan Pro-forma: 00:00:00 •At013 - Template - Scheme of Work Rationale: 00:00:00 •At014 - Template - Scheme of Work: 00:00:00 •At022 - Template - Initial and Diagnostic Assessment: 00:00:00 •At023 - Template - Individual Learning Plan: 00:00:00 •At024 - Template - Group Profile: 00:00:00 •At025 - Template - Workshop Plan: 00:00:00 •C9007 - Information leaflet - Initial and Diagnostic Assessment: 00:00:00 •C9008 - Information leaflet - Devising a Scheme of Work: 00:00:00 •C9009 - Information Leaflet - Designing a Session Plan: 00:00:00 •C9010 - Information Leaflet - the Minimum Core Planning: 00:00:00 •C9011 - Information Leaflet - Reviewing Own Practice Planning: 00:00:00 •C0007 - Pp - Initial and Diagnostic Assessment: 00:00:00 •C0008 - Pp - Devising a Scheme of Work: 00:00:00 •C0009 - Pp - Designing a Session Plan: 00:00:00 •C0010 - PP - The Minimum Core Planning: 00:00:00 •C0011 - PP - Reviewing own Practice Planning: 00:00:00 •C9054 - Group Profile Completed Example: 00:00:00 •A9051a - Handout - Table of Assessment Methods, Approaches and Activities: 00:00:00 •A9058 - Handout - Table of Strengths and Limitations of Teaching and Learning Approaches: 00:00:00 •H9012 - Handout - Table of Resources: 00:00:00 •I9015A - Handout - Example Completed Reflective Learning Journal: 00:00:00 •M9060 - Handout - Example Completed Scheme of Work: 00:00:00 •M9061 - Handout - Completed Example Scheme of Work Rationale: 00:00:00 •M9062 - Handout - Example Completed Session Plan: 00:00:00 •M9064 - Handout - Five Minute Session Plan: 00:00:00 •M9065 - Handout - Example Three Stage Session Plan: 00:00:00 •U9053a - Handout - Table of Objectives at Different Levels: 00:00:00 •0 - Certificate Units - Information for Delivery: 00:00:00 •0 - Resource Information and Terms and Conditions of Use: 00:00:00 •Pgu3c - Guidance for Evidencing Achievement - Delivering Education and Training: 00:00:00 •Sau3c - Self Assessment Grid - Delivering Education and Training: 00:00:00 •Atmc01 - Checklist - Minimum Core Personal Skills: 00:00:00 •Hc003 - Checklist for Verbal, Listening, Non Verbal and Written Communication: 00:00:00 •Hc004 - Checklist for Equality and Diversity: 00:00:00 •Hc005 - Checklist for Demonstrating a Task: 00:00:00 •Hc012 - Checklist for Teaching: 00:00:00 •Hc013 - Observation Checklist - Certificate Units: 00:00:00 •Hc015 - Checklist for Reviewing Own Practice - Delivery: 00:00:00 •AT003 - Template - Personal Development Plan: 00:00:00 •AT005 - Template - Reflective Learning Journal: 00:00:00 •At009 - Template - Self Evaluation of a Delivered Session Pro-forma: 00:00:00 •At021 - Template - Teaching Practice Log: 00:00:00 •At026 - Template - Tutorial Review: 00:00:00 •C9006 - Information Leaflet - Reviewing Own Practice Delivering: 00:00:00 •C9012 - Information Leaflet - Observations and Teaching Practice: 00:00:00 •C9016 - Information Leaflet - Communication With Learners and Others: 00:00:00 •C9022 - Information Leaflet - the Minimum Core Delivering: 00:00:00 •C9023 - Information Leaflet - Teaching and Learning Approaches: 00:00:00 •C9024 - Information Leaflet - an Inclusive Teaching and Learning Environment: 00:00:00 •C9025 - Information Leaflet - Teaching and Learning Theories: 00:00:00 •C9026 - Information Leaflet - Using Technologies in Teaching and Learning: 00:00:00 •C0006 - Pp - Reviewing Own Practice Delivering: 00:00:00 •C0012 - Pp - Observations and Teaching Practice: 00:00:00 •C0016 - Pp - Communication With Learners and Others: 00:00:00 •C0022 - Pp - the Minimum Core Delivering Education and Training: 00:00:00 •C0023 - Pp - Teaching and Learning Approaches: 00:00:00 •C0024 - Pp - an Inclusive Teaching and Learning Environment: 00:00:00 •C0025- Pp - Teaching and Learning Theories: 00:00:00 •C0026 - Pp - Using Technologies in Teaching and Learning: 00:00:00 •A9058 - Handout - Table of Strengths and Limitations of Teaching and Learning Approaches: 00:00:00 •A9060 - Handout - Example Completed Personal Development Plan: 00:00:00 •H9006 - the Environment - Examples of Physical, Social and Learning Aspects: 00:00:00 •H9012 - Handout - Table of Resources: 00:00:00 •H9016 - Handout - Teaching Practice Log Information: 00:00:00 •H9019 - Handout - List of Technologies: 00:00:00 •H9021 - Handout - Advantages and Disadvantages of Using Technology: 00:00:00 •H9022 - Handout - Online Safety: 00:00:00 •H9025 - Examples of Verbal and Non Verbal Communication: 00:00:00 •H9026 - Handout Examples of CPD activities: 00:00:00 •H9027 - Handout Working with an LSA: 00:00:00 •H9031 - Handout Starter and closing activities: 00:00:00 •H9032 - Handout Reviewing Learner Progress: 00:00:00 •H9033 - Handout Individual and Group Tutorials: 00:00:00 •H9034 - Handout Facilitating Group Learning: 00:00:00 •H9035 - Handout Facilitating Individual Learning: 00:00:00 •H9036 - Handout Extension Activities: 00:00:00 •I9015a - Handout - Example Completed Reflective Learning Journal: 00:00:00 •M9057 - Handout - Example Completed Self Evaluation Form: 00:00:00 •0 - Certificate Units - Information for Delivery: 00:00:00 •0 - Resource Information and Terms and Conditions of Use: 00:00:00 •Pgu4c - Guidance for Evidencing Achievement - Assessing Learners in Education and Training: 00:00:00 •Sau4c - Self Assessment Grid - Assessing Learners in Education and Training: 00:00:00 •Atmc01 - Checklist - Minimum Core Personal Skills: 00:00:00 •Hc012 - Checklist for Teaching: 00:00:00 •Hc013 - Observation Checklist - Certificate Units: 00:00:00 •Hc016 - Checklist for Reviewing Own Practice - Assessment: 00:00:00 •AT001 - Templates - Assessment Records: 00:00:00 •AT005 - Template - Reflective Learning Journal: 00:00:00 •At021 - Template - Teaching Practice Log: 00:00:00 •C9012 - Information Leaflet - Observations and Teaching Practice: 00:00:00 •C9017 - Information Leaflet - the Minimum Core Assessing: 00:00:00 •C9018 - Information Leaflet - Reviewing Own Practice Assessment: 00:00:00 •C9019 - Information leaflet - Types of Assessment: 00:00:00 •C9020 - Information Leaflet - Assessment Methods: 00:00:00 •C9021 - Information Leaflet - Making Decisions Giving Feedback and Keeping Records: 00:00:00 •C0012 - Pp - Observations and Teaching Practice: 00:00:00 •C0017 - Pp - The Minimum Core Assessment: 00:00:00 •C0018 - Pp - Reviewing Own Practice Assessment: 00:00:00 •C0019 - Pp - Types of Assessment: 00:00:00 •C0020 - PP - Assessment Methods: 00:00:00 •C0021 - Pp - Making Assessment Decisions, Giving Feedback and Keeping Records: 00:00:00 •A9050 - Handout - Table of Assessment Types: 00:00:00 •A9051a - Handout - Table of Assessment Methods, Approaches and Activities: 00:00:00 •A9053 - Handout - Table of Assessment Requirements: 00:00:00 •A9057 - Handout - Assessor Roles and Responsibilities: 00:00:00 •A9059 - Handout - Completed Example of Assessment Records: 00:00:00 •G9052 - Handout - Table of Advantages and Limitations of Peer and Self Assessment: 00:00:00 •H9016 - Handout - Teaching Practice Log Information: 00:00:00 •H9050 - Handout - Table of Example Teaching Records: 00:00:00 •I9015a - Handout - Example Completed Reflective Learning Journal: 00:00:00 •0 - Certificate Units - Information for Delivery: 00:00:00 •0 - Resource Information and Terms and Conditions of Use: 00:00:00 •Pgu5c - Guidance for Evidencing Achievement - Using Resources for Education and Training: 00:00:00 •Sau5c - Self Assessment Grid - Using Resources for Education and Training: 00:00:00 •Atmc01 - Checklist - Minimum Core Personal Skills: 00:00:00 •Hc012 - Checklist for Teaching: 00:00:00 •Hc013 - Observation Checklist - Certificate Units: 00:00:00 •Hc017 - Checklist for Reviewing Own Practice - Resources: 00:00:00 •AT005 - Template - Reflective Learning Journal: 00:00:00 •At021 - Template - Teaching Practice Log: 00:00:00 •C9012 - Information Leaflet - Observations and Teaching Practice: 00:00:00 •C9013 - Information Leaflet - Using Resources: 00:00:00 •C9014 - Information Leaflet - the Minimum Core Resources: 00:00:00 •C9015 - Information Leaflet - Reviewing Own Practice Resources: 00:00:00 •C0012 - Pp - Observations and Teaching Practice: 00:00:00 •C0013 - PP - Using Resources: 00:00:00 •C0014 - PP - The Minimum Core Resources: 00:00:00 •C0015 - Pp - Reviewing Own Practice Resources: 00:00:00 •H9012 - Handout - Table of Resources: 00:00:00 •H9016 - Handout - Teaching Practice Log Information: 00:00:00 •H9018 - Handout - Hints and Tips for Creating and Using Handouts and Visual Presentations: 00:00:00 •H9023 - Handout - Resource Box: 00:00:00 •H9024 - Handout - Assistive Resources: 00:00:00 •I9015a - Handout - Example Completed Reflective Learning Journal: 00:00:00 •Policy and Regulatory Frameworks on Inclusive Practice: 00:00:00 •Maintaining Inclusive Learning Environment: 00:00:00 •Inclusive Practice Roles and Responsibilities: 00:00:00 •Factors-Influencing-Learning: 00:00:00 •Evaluating Own Inclusive Practice: 00:00:00 •Assignment: Optional Unit 34 - Inclusive Practice: 00:00:00 •Submit Your Assignments: 00:00:00
Power Query and Power Pivot in Microsoft Excel: A Quickstart Guide Course Description Copyright Ross Maynard 2022 Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide. Key Learning Points On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points Pre-Course Requirements There are no pre-course requirements Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented. Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type
Compassion-focussed leadership is a transformative move for driving both individual and organisational performance. Long-term success comes from creating a workplace where people actually want to stay and thrive. For all leaders and managers of all levels to attend — Learn an actionable workplace wellbeing action plan that generates a real culture change to workplace wellbeing
Business Management: Business Management Course Online Are you prepared to master effective business management techniques in order to secure your company? Our Business Management: Business Management Course program is designed to help students develop theoretical and practical business management knowledge and abilities. You will learn how a business manager effectively contributes to the success of the organisation in our Business Management: Business Management Course. The Business Management: Business Management Course will cover the fundamentals of human resource management.The Basic Principles of Performance Management will be taught to you as part of your Business Management: Business Management Course. After completing the Business Management: Business Management Course programme, you will be able to handle the risk involved in this industry. Enrolling This Business Management: Business Management Course will provide you useful knowledge and necessary abilities that are in demand in contemporary organisations. Main Course: Level 2 Certificate in Business Management Course Free Courses are including with this Business Management: Business Management Course Along with The Business Management Course, We Offer a free Business Administration Course Along with The Business Management Course, We Offer a free Project Management Course Along with The Business Management Course, We Offer a free Business Analysis Diploma Course Special Offers of this Business Management: Business Management Course This Business Management: Business Management Course includes a FREE PDF Certificate. Lifetime access to this Business Management: Business Management Course Instant access to this Business Management: Business Management Course Get FREE Tutor Support to this Business Management: Business Management Course Business Management: Business Management Course Online You will also gain a solid understanding of organizational structures from this Level 1 Business Management: Business Management course. All things considered, the Level 1 Business Management: Business Management course gives you a thorough understanding of the ideas and procedures that underpin many important business management subjects. Who is this course for? Business Management: Business Management Course Online Those who are interested in business management and in learning more about the business sector and its administration should take this Business Management: Business Management Course. Requirements Business Management: Business Management Course Online To enrol in this Business Management: Business Management Course, students must fulfil the following requirements. To join in our Business Management: Business Management Course, you must have a strong command of the English language. To successfully complete our Business Management: Business Management Course, you must be vivacious and self driven. To complete our Business Management: Business Management Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Business Management: Business Management Course. Career path Business Management: Business Management Course Online This Business Management: Business Management Course will help you to enter this relative field.
Business Analysis: Business Analysis Course Online Introducing Business Analysis: Business Analysis Course "Empowering the Next Generation" Online course! This Business Analysis: Business Analysis Course provides a thorough introduction to the primary functions and objectives of business analysis: business analysis activities. Learn about the business analyst's main duties and responsibilities, as well as the six primary phases of the business analysis: business analysis process, the art of effective business process improvement, and how to perform a gap analysis. Whether you are looking for a promotion or a major career change, this Business Analysis: Business Analysis Course could make all the difference. Business Analysis: Business Analysis Course are responsible for implementing positive change at all levels of an organisation. The business analyst, appointed by both employers and stakeholders, must establish objectives (financial or otherwise) and oversee the creation and implementation of solutions. Ultimately, they work with complex business intelligence data to continuously improve performance and profitability. To become a skilled business analyst is to become one of the most in-demand commodities for employers and decision-makers worldwide. Why choose this Business Analysis: Business Analysis Course from the School of Health Care? Self-paced Autism: Autism course, access available from anywhere in the world. Business Analysis: Business Analysis Course developed by industry experts. After each module of Autism: Autism Course, there will be an MCQ quiz to assess your learning. Free PDF certificate after completing the Business Analysis: Business Analysis Course Courses you will Get with This Business Analysis: Business Analysis Course Course 01: Business Analysis Course 02: Business Process Management Course 03: Creating a Business Start-Up Course 04: Level 3 Business Administration Course 05: Strategic Management Special Offers of this Business Analysis: Business Analysis Course: This Business Analysis: Business Analysis Course includes a FREE PDF Certificate. Lifetime access to this Business Analysis: Business Analysis Course Instant access to this Business Analysis: Business Analysis Course 24/7 Support Available to this Business Analysis: Business Analysis Course [ Note: Free PDF certificate as soon as completing Business Analysis: Business Analysis Course] Business Analysis: Business Analysis Course Online This Business Analysis: Business Analysis Course consists of 12 modules. This Business Analysis: Business Analysis course is your gateway to mastering the skills needed to drive positive change in organisations. As a business analyst, you'll be responsible for setting objectives, whether financial or operational, and overseeing the creation of solutions. Through this Business Analysis: Business Analysis course, you’ll learn how to work with complex business intelligence data to improve performance and profitability. Becoming a skilled professional in Business Analysis: Business Analysis makes you an in-demand asset for employers and decision-makers globally. Who is this course for? Business Analysis: Business Analysis Course Online This Business Analysis: Business Analysis Course is suitable for anyone looking to take a current or prospective career in business to the next level. Requirements Business Analysis: Business Analysis Course Online To enrol in this Business Analysis: Business Analysis Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Business Analysis: Business Analysis Course. Be energetic and self-motivated to complete our Business Analysis: Business Analysis Course. Basic computer Skill is required to complete our Business Analysis: Business Analysis Course. If you want to enrol in our Business Analysis: Business Analysis Course, you must be at least 15 years old. Career path Business Analysis: Business Analysis Course Online A Business Analysis: Business Analysis Course may prepare you for a successful career in practically any corporate environment.
Curious about how electricity works without turning your brain into a tangled mess of wires? Our Basic Electricity Course is designed to illuminate the subject without overloading your mental circuits. From the very first module, we ease you in with the foundational concepts—no dramatic jargon, just clear explanations with a spark of wit. You'll explore electrical units, Ohm’s Law, and the mysterious ways of direct and alternating currents. It’s structured, logical, and dare we say, surprisingly enjoyable. Whether you’re brushing up on knowledge or starting from scratch, this course gives you a strong understanding of electricity, minus the guesswork. Voltage, resistance, capacitance, and even magnetism are tackled in a way that doesn’t require a physics degree—or a stiff upper lip. And yes, we take safety seriously (because frizzy eyebrows are nobody’s look). With clear, accessible content and a few nods to good humour, this course keeps things bright without blowing a fuse. Learning Outcomes: Demonstrate understanding of electrical units of measurement and electrical symbols Get introduced to atoms, electrons, electric current, resistance and electric power Understand the difference between a direct current (DC) and alternating current (AC) Be aware of various electrical hazards and what safety precautions to take at all times Identify the domestic electrical injuries and hazards that can occur in the home Show an understanding of the relationship between voltage, current and resistance List the different forms of electricity and understand how they are generated Show an understanding of the relationship between capacitance and resistance Explore emergency and life-saving procedures, which is vital in an emergency It's your chance to start with our Electricity & Electronics course and give your resume the stamp of approval that employers are looking for. So, pick up your card now and fill up your virtual basket with this highly-rated Basic Electricity Course - CPD Accredited online training program from Training Express Still not convinced? Take a glimpse of the key benefits you'll get with - Lessons prepared in collaboration with Professionals User-friendly Learner Management System (LMS) Syllabus designed in line with the standards of the UK Education System Updated Study Materials focusing both on Knowledge and Skill based training Guidance to expand in 'a' territory and move forward with Electrician profession Free Assessment to test learners' knowledge and skills Accredited learning and widely recognised certificate from reputed CPD Accreditation Bodies Course Curriculum: Module 01: Introduction and Basics Module 02: Electrical Units and Ohm's Law Module 03: Direct Current Module 04: Alternating Current Basics Module 05: Voltage and Resistance Module 06: Capacitance and Capacitors Module 07: Magnetism Module 08: Safety Precautions Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the Basic Electricity Course - CPD Accredited course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Basic Electricity Course - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Basic Electricity Course - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Basic Electricity Course - CPD Accredited training.
If you’re aiming to sharpen your recruitment expertise and elevate your career without leaving your desk, this CPD accredited Recruitment Consultant course is tailor-made for you. Designed to deliver essential knowledge on sourcing, engaging, and placing the right talent, the course offers insights into the recruitment lifecycle, candidate management, and client relationship building. Whether you’re a budding consultant or looking to refresh your skillset, this course provides the building blocks to succeed in today’s competitive recruitment landscape. Delivered entirely online, this course fits effortlessly around your schedule, allowing you to absorb key concepts at your own pace. Expect clear, engaging modules packed with up-to-date industry approaches and strategies to help you navigate recruitment with confidence. Plus, it’s CPD accredited, meaning you gain recognised professional development credentials that can enhance your CV and career prospects. In short, a clever way to sharpen your recruitment know-how without leaving the comfort of your favourite chair. Learning Outcomes: Demonstrate an excellent understanding of the recruitment process Develop a solid recruitment and hiring strategy for your company Understand best practices to lure in great candidates and attract talent Look after candidate welfare and assess the competition Review job applications, resumes and cover letters Conduct phone and face-to-face candidate interviews Carry out background checks on candidates and check references Explain the difference between education and experience Discuss the key principles of the Equality Act 2010 and the legal recruitment process It's your chance to start with our Office Skills course and give your resume the stamp of approval that employers are looking for. So, pick up your card now and fill up your virtual basket with this highly-rated Recruitment Consultant - CPD Accredited online training program from Training Express Still not convinced? Take a glimpse of the key benefits you'll get with - Lessons prepared in collaboration with Professionals User-friendly Learner Management System (LMS) Syllabus designed in line with the standards of the UK Education System Updated Study Materials focusing both on Knowledge and Skill based training Guidance to expand in 'a' territory and move forward with HR , Recruit Officer profession Free Assessment to test learners' knowledge and skills Course Curriculum: Module 01: Defining and Knowing the Position Module 02: Hiring Strategy Module 03: Lure in Great Candidates Module 04: Filtering Applicants to Interview Module 05: The Interview (I) Module 06: The Interview (II) Module 07: Selection Process (I) Module 08: Selection Process (II) Module 09: Making an Offer Module 10: Legal Recruitment Process Module 11: Employment Contracts Module 12: Onboarding Module 13: Employee Training and Development Process Module 14: Motivation and Counselling Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the Recruitment Consultant - CPD Accredited course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Recruitment Consultant - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Recruitment Consultant - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Recruitment Consultant - CPD Accredited training.