9603 Courses

The Environmental Studies & Public Policy Course brings together essential knowledge from multiple disciplines to explore the dynamic relationships between public health, administration, law, and the environment. Designed for those interested in the growing intersection between policy and sustainability, this course introduces key concepts such as epidemiology, public health systems, environmental legislation, waste and pollution control, and ethical considerations in policymaking. Learners will examine how policy influences health outcomes, environmental quality, and social equity, while gaining insights into strategies that support sustainable governance and environmentally conscious decision-making. With a strong emphasis on policy, leadership, communication, and environmental responsibility, this course weaves together topics ranging from climate change and resource recovery to public realm management and effective time scheduling. It covers everything from understanding air and water quality to the frameworks guiding international environmental agreements like the Paris Agreement and Kyoto Protocol. Whether you're interested in public administration, environmental law, or sustainability planning, this programme offers a solid foundation for those seeking to understand and influence the policies shaping modern environmental challenges. Key Features: CPD QS Certified Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum: Public Health Module 1: Introduction to Public Health Module 2: Principles of Public Health Module 3: Understanding Epidemiology Module 4: Disease Control Module 5: Understanding Measures of Disease Frequency Module 6: Maternity and Childbirth Module 7: Environment and Public Health Module 8: Health System and Policy Module 9: Public Health and Ethics Public Administration Module 01: Introduction to Public Relations Module 02: Concepts of Public Relations Module 03: Management and Organisation of Public Relations Module 04: Crisis management Module 05: Meeting Management Module 06: Project Management Module 07: Risk Management Module 08: Team Work Team Building Module 09: Performance Management Module 10: Critical Thinking Implications for Leadership Module 11: Effective Time Management Techniques Module 12: Leadership Skills and Competencies. Module 13: Emotional Intelligence Module 14: Employee Relations Module 15: Avoiding the Unconscious Biases at Workplace Module 16: Effective Decision Making to Prevent Chaos Module 17: Skills of an Effective Administrator Module 18: Communication Skills Module 19: Prioritize Module 20: Scheduling Your Time Module 21: To Do Lists Module 22: Organizing Your Inbox Module 23: Negotiation Techniques Module 24: Conflict Management Module 25: Stress Management Module 26: Linguistics and Psychology Module 27: Communication and Media Studies Module 28: Corporate Social Responsibility Module 29: Stakeholders & the Social Contract Module 30: CRM Strategies Public Realm Manager Module 01: Introduction to Public Realm Management Module 02: Planning and Design Principles Module 03: Management and Maintenance Module 04: Sustainability and Resilience Module 05: Legal and Regulatory Framework Module 06: Public Realm and Social Equity Environmental Health Module 01: Intro to Environmental Health Module 02: Waste, Pollution and Pollutants Module 03: Environment, Pollution, Climate Change and Health Module 04: Recovering Resources and Managing Waste Module 05: Food Waste Module 06: Plastic Module 07: Air Pollution Module 08: Water Module 09: Environmental Sustainability Environmental Law Module 01: Legal System Module 02: What Is Environmental Law Module 03: International Environment Law Module 04: Environmental Organisations Module 05: National Environmental Legacy Act Module 06: The Environment And Economics Part 1 Module 07: The Environment And Economics Part 2 Module 08: Climate Change Module 09: Environmental Impact Assessment Module 10: Nature Conservation Module 11: Kyoto Protocol And Paris Agreement Module 12: Sustainable Development Module 13: Compliance And Governance Of Law Module 14: Right To Information, Participation And Justice Module 15: Enforcement Of Environmental Law Environmental Awareness Training Module 01: Introduction to Environmental Awareness Module 02: Climate Change and the Carbon Footprint Module 03: The Hidden Pollution inside Workplace Module 04: Benefits of Energy Efficiency Module 05: Environmental Planning and Decision-Making Module 06: Sustainable Development for Environment Module 07: Eco Friendly and Green Living Environmental engineering Module 01: Introduction to Environmental Engineering Module 02: Environmental Pollutions Module 03: Wastewater Treatment Module 04: Drinking Water and Groundwater Treatment Module 05: Groundwater Hydrology Module 06: Air Pollution Module 07: Solar Energy Module 08: Waste Disposal and Recycling Module 09: Land Management Module 10: Environmental Law Module 11: Sustainable Development Learning Outcomes: Gain expertise in Public Health principles and practices. Understand the foundations of Public Administration for effective governance. Develop skills as a Public Realm Manager for community development. Explore the intricacies of Environmental Health and its impact. Grasp the complexities of Environmental Law for responsible decision-making. Acquire practical knowledge in Environmental Engineering for sustainable solutions. Accreditation All of our courses, including theCourse are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed yourCourse, you will immediately be sent your digital certificates. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we recommend renewing them every 12 months. Assessment At the end of theCourse, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. CPD 70 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals passionate about public health and environmental sustainability Aspiring public administrators seeking to make a difference Environmental enthusiasts keen on understanding legal frameworks Professionals aiming to enhance their expertise in environmental engineering Those interested in community welfare and public realm management Requirements Learners do not require any prior knowledge or qualifications to enrol in this course. Career path Environmental Health Officer - £25K to £40K/year. Public Health Analyst - £30K to £45K/year. Environmental Consultant - £28K to £50K/year. Public Administrator - £25K to £45K/year. Environmental Engineer - £30K to £55K/year. Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

14 in 1 "Retail Assistant Training" Bundle only at £79 Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Tired of browsing and searching for a Retail Assistant Training course you are looking for? Can't find the complete Training package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive bundle that has everything you need to succeed in Retail and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one bundle has been designed by industry experts. We prioritised what learners were looking for in a complete Retail Assistant Training package and developed this in-demand course that will enhance your skills and prepare you for the competitive job market. Furthermore, to help you showcase your expertise in Retail, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Retail Assistant Training Bundle Consists of the following Premium courses: Course 01: Retail Management - Level 5 Course 02: Logistic Management Course 03: Retail Strategy Course 04: Basic Product Management Course 05: Purchasing & Procurement Course - Level 3 Course 06: Level 3 Tax Accounting Course 07: Introduction to VAT Course 08: Commercial Law 2021 Course 09: Operations Management Course 10: Strategic Planning and Analysis for Marketing Course 11: Sales Negotiation Training Course 12: Basic Business Finance Course 13: Diploma in Quickbooks Bookkeeping Course 14: Customer Relationship Management Enrol now to advance your career, and use the premium study materials from Apex Learning. Benefits you'll get from choosing Apex Learning for this Retail Assistant Training: Pay once and get lifetime access to 14 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID included in a one-time fee Free up your time - don't waste time and money travelling for classes Learn anytime, from anywhere Study from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) Curriculum Course 01: Retail Management - Level 5 Module 01: Introduction to Retail Management Module 02: Retail Strategy Module 03: Retail Buying and Merchandising Module 04: Retail Pricing Module 05: Supply Chain Management in Retailing Module 06: The Sales Process and Dealing with Customers at the Checkout Module 07:Importance of Consumer Behaviour Module 08: Taking Trends and Targeting Customers Effectively Module 09: The Importance of Communicating with Customers Module 10: Choosing a Retail Location Module 11: Retail Psychology Module 12: Negotiate the Right Deal with Suppliers Module 13: Develop Store Security Procedures Module 14: Management Skills for Leading Your Team Module 15: Selling in Multiple Channels Module 16: Retail Brand Management Module 17: Health & Safety for Retail Stores Module 18: Consumer Rights Act Course 02: Logistic Management Module 01: Introduction to Logistic Management Module 02: Planning Framework for Logistics Module 03: Supply Chain Management Module 04: Logistics Management and Organisation Module 05: Sourcing, Purchasing, and Procurement Module 06: Channels of Distribution Module 07: Supplier Relationship Management Module 08: Inventory Planning and Management Module 09: Principles of Warehousing Module 10: Transport Management Module 11: Negotiation Techniques Module 12: Customer Service and Logistics Course 03: Retail Strategy Module 01: Introduction to Retail Management Module 02: Retail Strategy Module 03: Retail Buying and Merchandising Module 04: Retail Pricing Module 05: Supply Chain Management in Retailing Module 06: The Sales Process and Dealing with Customers at the Checkout Module 07:Importance of Consumer Behaviour Module 08: Taking Trends and Targeting Customers Effectively Module 09: The Importance of Communicating with Customers Module 10: Choosing a Retail Location Module 11: Retail Psychology Module 12: Negotiate the Right Deal with Suppliers Module 13: Develop Store Security Procedures Module 14: Management Skills for Leading Your Team Module 15: Selling in Multiple Channels Module 16: Retail Brand Management Module 17: Health & Safety for Retail Stores Module 18: Consumer Rights Act Course 04: Basic Product Management Module 01: Course Introduction - Product Module 02: Definition of Product Module 03: Classification of Product Module 04: Consumer Goods Module 05: Business Goods Module 06: Levels of a Product Module 07: Product Quality Module 08: Product Mix Module 09: Product Life Cycle Module 10: Branding Module 11: Branding Strategies Module 12: Brand Equity Course 05: Purchasing & Procurement Course - Level 3 Module 01: Supply Chain Basics Module 02: Role of Procurement in an Organisation Module 03: The Purchasing Cycle Module 04: Purchasing Toolkits Module 05: Managing Competitive Bids Module 06: Quality Management Module 07: Supplier Relationship Management Module 08: Analysing and Reducing Risk in the Supply Chain Module 09: Improving Efficiency and Accuracy Module 10: Category Management Module 11: Inventory Management Module 12: E-Procurement Course 06: Level 3 Tax Accounting Module 01: Tax System and Administration in the UK Module 02: Tax on Individuals Module 03: National Insurance Module 04: How to Submit a Self-Assessment Tax Return Module 05: Fundamentals of Income Tax Module 06: Advanced Income Tax Module 07: Payee, Payroll and Wages Module 08: Capital Gain Tax Module 09: Value Added Tax Module 10: Import and Export Module 11: Corporation Tax Module 12: Inheritance Tax Module 13: Double Entry Accounting Module 15: Career as a Tax Accountant in the UK Course 07: Introduction to VAT Module 01: Understanding VAT Module 02: VAT Terminology and Calculation Module 03: VAT Taxable Persons Module 04: VAT Registration Module 05: VAT Rates Module 06: Invoicing and Records Module 07: VAT Application in Goods, Services and Vehicles Module 08: Supply Module 09: The VAT Return Module 10: Tips on VAT Compliance Module 11: VAT Exemptions and Zero-Rated VAT Module 12: Miscellaneous VAT Issues and Penalties Module 13: Making Tax Digital Course 08: Commercial Law 2021 Module 01: Introduction of Commercial law Module 02: Business Organisations Module 03: International Trade: the Theory, the Institutions, and the Law Module 04: Sales of Goods Law Module 05: Consumer Law and Protection Module 06: E-Commerce Law Module 07: Competition Law Course 09: Operations Management Module 01: Introduction Module 02: Project Module 03: Business Development and Succession Planning Module 04: Process Module 05: Supply Chain Module 06: Planning & Forecasting Operations Module 07: Procurement & Purchasing Module 08: Manufacturing & Delivery Operations Module 09: Quality Module 10: Managing Risk and Recovery Module 13: Communication Skills Module 14: Negotiation Techniques Module 18: Business Environment Module 19: Business Writing Skills Course 10: Strategic Planning and Analysis for Marketing Module 01: An Introduction to Strategic Planning Module 02: Development of a Strategic Plan Module 03: Strategic Planning for Marketing Module 04: Strategic and Marketing Analysis Module 05: Internal Analysis Module 06: External Analysis Module 07: Market Segmentation, Targeting and Positioning Module 08: Approaches to Customer Analysis Module 09: Approaches to Competitor Analysis Course 11: Sales Negotiation Training Sales Negotiation Training Negotiation Station - How To Negotiate Successfully Course 12: Basic Business Finance Module 01: What is Business Finance? Module 02: Why Businesses Fail Module 03: The Principles of Business Finance Part 1 Module 04: The Principles of Business Finance Part 2 Module 05: The Balance Sheet Module 06: The Income Statement Module 07: The Cashflow Statement Module 08: A Business Finance Exercise Module 09: Financial Performance Indicators Module 10: Investment Analysis Module 11: Investment Analysis Exercise Module 12: Key Learning Points in Business Finance Course 13: Diploma in Quickbooks Bookkeeping Getting prepared - access the software and course materials Getting started Setting up the system Nominal ledger Customers Suppliers Sales ledger Purchases ledger Sundry payments Sundry receipts Petty cash VAT - Value Added Tax Bank reconciliation Payroll / Wages Reports Tasks Course 14: Customer Relationship Management Module 01: Introduction Module 02: CRM Fundamentals Module 03: CRM Strategies CRM Strategies Module 04: Data Analysis in CRM Module 05: CRM Databases Module 06: Deepening Customer Relationship Module 07: Handling Customer Complaints Module 08: Future of CRM CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Retail Assistant Training bundle including- Students Graduates Job Seekers Job Holders Requirements Our Retail Assistant Training is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones, so you can access your course on Wi-Fi, 3G or 4G. Career path Having this Retail Assistant Training expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Retail Management - Level 5) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Retail Management - Level 5) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Enhance your asset management skills with EnergyEdge's classroom training on the principles of asset management. Gain valuable insights and advance your career.

Office Politics for Managers is a comprehensive training program that equips managers with the knowledge and skills to navigate the complex landscape of office politics effectively. This course covers a range of topics, from understanding office dynamics and dealing with gossip to resolving conflicts and maintaining ethical conduct. Participants will learn strategies for building relationships, gaining support for their projects, and excelling in their managerial roles. Learning Outcomes: Upon completion of this course, participants will be able to: Understand the dynamics of office politics and its impact on the workplace. Develop effective communication and influencing skills. Learn to address and mitigate rumors, gossip, and misinformation. Identify and manage various office personalities to build productive relationships. Acquire strategies for gaining support and buy-in for managerial initiatives. Master conflict resolution techniques to maintain a harmonious work environment. Uphold high ethical standards in all professional interactions. Recognize the importance of teamwork and collaboration in managerial success. Why buy this Office Politics for Managers? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Office Politics for Managers there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Office Politics for Managers does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Current and aspiring managers seeking to enhance their leadership skills. Professionals who want to excel in their careers by navigating office politics adeptly. Team leaders, supervisors, and project managers. Human resources professionals responsible for organizational culture. Prerequisites This Office Politics for Managers was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Middle Manager - Potential earning of £40,000 - £70,000 per year. Senior Manager/Director - Median earning of £70,000 - £120,000 per year. HR Manager - Median earning of £35,000 - £70,000 per year. Organizational Development Consultant - Potential earning of £40,000 - £80,000 per year. Executive Coach - Potential earning of £50 - £150 per hour. Course Curriculum Module 01: New Hires New Hires 00:04:00 Module 02: It's About Interacting and Influencing It's About Interacting and Influencing 00:04:00 Module 03: Dealing with Rumors, Gossip, and Half - Truths Dealing with Rumors, Gossip, and Half - Truths 00:04:00 Module 04: Office Personalities (I) Office Personalities (I) 00:05:00 Module 05: Office Personalities (II) Office Personalities (II) 00:05:00 Module 06: Getting Support for Your Projects Getting Support for Your Projects 00:04:00 Module 07: Conflict Resolution Conflict Resolution 00:05:00 Module 08: Ethics Ethics 00:05:00 Module 09: You Are Not an Island You Are Not an Island 00:04:00 Module 10: Social Events Outside of Work Social Events Outside of Work 00:05:00

Enhance your knowledge in coal power plant life cycle management and flexible operations with EnergyEdge. Learn about decommissioning, preservation, repurposing, and recommissioning.

Uncover the world of Building Surveying with our comprehensive course. Delve into the fascinating realm of building surveying, where you'll gain invaluable insights into building law principles, procurement, and contract administration. Learn the art of Building Information Modelling (BIM) and explore the latest in building technology. This course equips you with the skills and knowledge required for building surveys, including historical buildings, foundation assessments, and in-depth wall surveys. You'll also master the inspection of floors, roofs, chimneys, joinery, woodwork, and building services. Dive into building pathology, adaptation, and work breakdown structure. By the end of this course, you'll be proficient in report writing and legal aspects, making it an ideal choice for those aspiring to a career in building surveying. Learning Outcomes Understand the fundamental principles of building law and procurement. Master Building Information Modelling (BIM) techniques. Gain expertise in building technology and pathology. Learn the process of building surveys, including historical and in-depth assessments. Develop skills in report writing and legal aspects of building surveying. Why choose this Building Surveying course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Building Surveying course for? Students pursuing a career in building surveying and construction. Construction professionals looking to enhance their skills and knowledge. Building inspectors and surveyors seeking comprehensive training. Individuals interested in historical building assessments. Anyone passionate about the built environment and construction industry. Career path Building Surveyor: £24,000 - £60,000 Chartered Surveyor: £25,000 - £60,000 Construction Manager: £30,000 - £70,000 Architect: £25,000 - £55,000 Structural Engineer: £28,000 - £55,000 Project Manager: £32,000 - £70,000 Prerequisites This Building Surveying does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Building Surveying was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Building Surveying Building Survey: An Introduction 00:22:00 Building Law Principles 00:28:00 Building Procurement and Contract Administration 00:50:00 Building Information Modelling 00:33:00 Building Technology 00:31:00 The Procedure of Building Survey and Surveys of Historic Buildings 00:20:00 Beginning of the Survey: Foundation and In-depth Survey in Walls 00:45:00 Ground Level Investigation: Floors and Investigation Above the Ground: Roofs and Chimneys 00:24:00 Inspection of Joinery and Woodwork 00:21:00 Finishes and Surfaces of the Building 00:17:00 Services Inspection 00:16:00 Building Pathology 00:22:00 Building Adaption 00:36:00 Understanding Work Breakdown Structure 00:13:00 Report Writing 00:17:00 Legal Aspects 00:17:00 Assignment Assignment - Building Surveying 00:00:00

Welcome to the world of Excel 2016 Formulas and Functions, your key to unlocking the full potential of Microsoft Excel. Whether you're a novice or looking to enhance your spreadsheet skills, this course is your passport to becoming an Excel expert. Get ready to excel in Excel! In this engaging program, you'll embark on a journey through the fundamentals of Excel. You'll learn to navigate Excel commands, create and save workbooks, and enter data efficiently. Dive into the world of formulas and functions, where you'll discover how to create and reuse them effectively. With hands-on activities and customizable options, you'll master Excel like never before, making it an indispensable tool for both personal and professional use. Learning Outcomes Navigate Excel commands with ease. Create and manage basic workbooks. Efficiently enter data into Excel. Harness the power of formulas and functions. Customize Excel to suit your needs. Why choose this Excel 2016 Formulas and Functions course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Excel 2016 Formulas and Functions course for? Beginners looking to master Excel. Professionals seeking to enhance their spreadsheet skills. Students wanting to excel in data management. Individuals aiming to boost their productivity. Anyone eager to unlock the potential of Excel 2016. Career path Data Analyst: £25,000 - £55,000 Financial Analyst: £30,000 - £70,000 Business Analyst: £30,000 - £70,000 Accountant: £25,000 - £60,000 Project Manager: £35,000 - £80,000 Office Manager: £25,000 - £45,000 Prerequisites This Excel 2016 Formulas and Functions does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Getting Started with Microsoft Excel 2016 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Basic Formulas and Functions Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Formulas and Functions Activities Create Formulas in a Worksheet 01:00:00 Activity - Create Formulas in a Worksheet 00:05:00 Insert Functions in a Worksheet 00:30:00 Activity - Insert Functions in a Worksheet 00:05:00 Reuse Formulas 00:30:00 Activity - Reuse Formulas 00:05:00 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Assignment Assignment - Excel 2016 Formulas and Functions 00:00:00

Dive deep into the realm of Excel with our meticulously designed course on 'Excel Pivot Tables, Pivot Charts, Slicers, and Timelines'. Unlock the secrets of powerful data visualisation tools like Dashboards, Slicers, and Timelines, while mastering the art of reporting by varying time intervals. Whether you wish to streamline your reporting tasks or augment your analytical capabilities, this course will provide you with the tools and techniques to extract insights from data seamlessly. Highlights of the Dynamic Excel Gantt Chart and Timelines : Discover the secrets of finding the key to doing your best work Understand how to reach your most productive level based on scientific research and principles Explore the hidden productivity recipes of professionals and the most successful people in the world Develop a routine for greater productivity both at home and at work Understand the time management strategies for managing your time when dealing with multiple urgent tasks Discover how to achieve higher productivity by making just a few simple changes Learn simple yet highly effective productivity hacks that you can apply in minutes or less Explore science-backed advice for developing a 'Productivity Mindset' and beat procrastination Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Who is this Course for? Data analysts aiming to bolster their data visualisation techniques. Professionals in finance, sales, and marketing looking to generate detailed reports. Researchers keen on presenting data in an insightful manner. Students aspiring to enhance their data representation and analysis skills. Project managers wanting to make data-driven decisions How is the course assessed? To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Will I receive a certificate of completion? Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15. Requirements The Dynamic Excel Gantt Chart and Timelines is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16. Career Path Data Analyst: £30,000 - £50,000 Financial Analyst: £35,000 - £55,000 Sales Analyst: £28,000 - £47,000 Market Researcher: £24,000 - £45,000 Data Visualization Specialist: £32,000 - £52,000 Business Intelligence Analyst: £38,000 - £60,000 Course Curriculum Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Getting started with your Pivot Table 00:04:00 Drill Down 00:01:00 Managing the Field List 00:02:00 Changing the Calculation type with Value Field Settings 00:06:00 Growing your Pivot Table with Multiple Fields 00:04:00 Formatting the Pivot Table 00:05:00 Sorting and Filtering the Pivot Table 00:03:00 Creating a Dashboard with Slicers, Timelines and Pivot Charts 00:09:00 Reporting by day, month, qtr, or year within the Pivot Table 00:04:00 Refreshing the Pivot Data with new data 00:03:00 Adding your own calculations into the Pivot Table 00:03:00 The power of the Filter Section in the Pivot Table 00:04:00 PowerQuery 00:12:00 PowerPivot 00:21:00 Assignment Assignment - Excel Pivot Tables, Pivot Charts, Slicers, and Timelines 00:00:00

Going the digital experience research route? Learn how a human centric approach to digital transformation results in a positive experience for all involved.

Participants gain a foundational understanding of the UX design process, tools and techniques through an engaging mix of theory and practical application exercises.