4197 Courses

This course covers the essential Excel data skills. Our course is interactive, instructor-led. This Excel Data course is on offered on intermediate level of Excel and concentrates on the Data Analytical capabilities of Excel. These concepts are daily used by data analysts and is a basic essential skill for data professionals. By the end, you'll be able to use Excel for analytics, data summaries, trends and statistics. You will create Excel data analytical spreadsheets and samples that you can use as examples at work.

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience. Overview Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data. This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data. Working with Multiple Worksheets and Workbooks Working with Named Ranges Link Cells Across Worksheets and Workbooks Use 3D References to Calculate Across Worksheets Consolidate Data Use Formula Auditing and Error Checking Reveal Formulas Trace Cell Precedents and Dependents Locate Errors in Formulas Watch and Evaluate Formulas Reviewing and Protecting Workbooks Control Data Entry via Data Validation Protect Workbook Access Protect Worksheets and Cell Content Add and Edit Comments Prepare a Workbook for Distribution Modify Excel's Default Settings Using Macros to Automate Workbook Functionality Create Macros via Recording Run Macros via Buttons and Shortcuts Assign Macros to the Quick Access Toolbar and Ribbon Assign Macros to Objects View Macro Code Forecasting and Analysis Data Use Conditional Formatting to Highlight, Sort and Filter Key Data Advanced Conditional Formatting using Formulas Create Sparklines to Visualise Data Add Trendlines to Charts to Visualise and Forecast Trends Use Data Tables and Scenarios to Project Potential Outcomes Use Goal Seek to Calculate Outcomes Forecast Data Trends Using Solver

Are you looking to enter the dynamic world of real estate? Our course is designed to equip you with the knowledge and tools you need to communicate effectively with real estate professionals and develop key skills in real estate investment strategy and analytics. At the end of the course, you'll be able to read and interpret real estate market reports, and have a firm grasp of how iconic buildings, cities, and companies fit into the overall picture of the real estate sector. On this course, you will… Become familiar with the players, structure, general terminology and overall needs of Real Estate. Learn what is Real Estate and why it is different from other asset classes Get to grips with the overall size and structure of the UK Real Estate Market Learn and analyse the links between the different parts of the property market Understand who works in the Real Estate Market, their qualifications and their job descriptions Recognise how and when to use basic real estate concepts: Rent, Value, Yield, Risk and Return, etc… Learn how to read a real estate market report Understand how current affairs, politics and economics affects Real Estate Investment Use household names and iconic companies, cities and buildings to help consolidate your appreciation of this exciting sector Who will benefit from this course: Graduates or undergraduates studying economics, finance. Professionals working in Marketing or Accounting teams within Real Estate firms. APC students. Anyone interested in Real Estate. School leavers/A-Level Students looking to gain an understanding of Real Estate. Non cognate students who wish to transfer into Real Estate/Finance careers. Course Outline Module 1: What is and why buy Real Estate? The property Market The Size and Structure of the UK property market The impact of Real Estate in the Economy Module 2: The Real Estate Market System The Space Market The Asset Market The Development Market Module 3: How to value Real Estate An Introduction to Financial Mathematics The difference between Price, Value and Worth Property Yield Conventional Valuation Methods Module 4: How to read a Real Estate Market Report Property Market Indicators: Stock Indicators Property Market Indicators: Investment Indicators Module 5: Who works in Real Estate? The build Environment by Cobalt Recruitment Rea; Estate Agents Examples of Real Estate Market Agents CVs Real Estate Network

This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.

Elevate your knowledge in petroleum risk analysis and portfolio management with Energyedge. Sign up with us today!

This comprehensive 7-hour online course is designed for professional drivers who need to complete Driver CPC Periodic Training to maintain their Driver CPC Licence. Participants will explore crucial topics such as managing fatigue, understanding the impact of diet and lifestyle on driving performance, and adopting economical driving practices. Who Should Attend: This course is ideal for all professional drivers required to undertake Driver CPC Periodic Training to ensure compliance with current legislation and to enhance their driving skills. Topics Covered: • Tiredness and Fatigue Management: Techniques for managing driver fatigue, understanding rest requirements, and learning strategies to stay alert on long drives. • Diet and Lifestyle: Insights into nutrition and lifestyle habits that promote sustained energy, mental focus, and overall health. • Economical Driving: Practical tips and techniques for fuel-efficient driving that benefit both the driver and the environment, reducing overall operational costs. Course Format: Online Join us for this training session to enhance your skills, maintain compliance, and stay up-to-date with industry standards.

Dashboards will summarize and present the key indications of large data in an attractive visual display, hightlighting the most important trends so the most imporatnf aspects of data could could be seen in a snap second by glancing at attractive, colourful charts. PowerPivot helps analyze the data and brings new capabilities to business users to analyse, explore and gain new insight into business and marketing data. Power Pivot help analyze and understand the growing quantities of data that are created on a daily basis.

Enhance your knowledge of exploration and production in oil & gas with EnergyEdge's course. Ideal for new engineers and non-technical professionals.

QA Level 3 Award In Emergency Paediatric First Aid (RQF) Full day course Would you know what to do if you saw a child in need of First Aid? Being able to deal with paediatric emergencies can make the difference between the life and death of children, and save them a lot of suffering Course Contents: The Roles and Responsibilities of an Emergency Paediatric First Aider Assessing an Emergency Situation Accident Recording Minor Injuries Cuts, Grazes and Bruises Minor Burns and Scalds Managing an Unresponsive Infant or Child Recovery Position CPR Safe Use of an AED (Automated External Defibrillator) Choking Anaphylaxis Seizures Wounds and Bleeding Shock Benefits of this course: Would you know what to do if you saw a child in need of First Aid? Children are prone to minor injuries, but suffer from serious injuries also In 2014, 2,269 children in the UK were so badly bitten by an animal they had to be admitted to hospital More than 2 million children have accidents in the home for which they're taken to A&E - every year, with Under 5s accounting for 7% of all hospital emergency treatments Being able to deal with peadiatric emergencies can make the difference between the life and death of children, and save them a lot of suffering. This QA Level 3 Award in Emergency Paediatric First Aid (RQF) qualification is ideal for: - Parents/carers or family members who want to learn key paediatric first aid skills - Those who work with children and are not required to comply with Ofsted’s Childcare Register or Early Years Foundation Stage (EYFS) 2014 requirements Those who want to provide additional support in their organisation to existing paediatric first aiders that are trained to meet Ofsted’s Childcare Register or Early Years Foundation Stage (EYFS) 2014 requirements. For those who will be directly responsible for children, Ofsted requires people to do our two day Paediatric First Aid course instead We also run a Paediatric Annual Refresher to keep those life-saving skills up to date Accredited, Ofqual regulated qualification: Our Emergency Paediatric First Aid at Work course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your Emergency Paediatric First Aid certificate will fulfill the legal requirements. It is a very good way to make sure you and your employees are trained in First Aid for Children and Infants (babies).The Ofqual Register number for this course is 603/0786/9

For Excel users. Extend the capabilities of Excel with Macros and VBA code.