- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
62 Analytics courses in Nottingham
Excel - advanced (In-House)
By The In House Training Company
Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar
Access - intermediate (In-House)
By The In House Training Company
This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access
Online Options
Show all 1726his course covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom. This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language. These concepts are daily used by programmers and is your first step to working as a programmer. By the end, you'll be comfortable in programming Python code. You will have done small projects. This will serve for you as examples and samples that you can use to build larger projects.
The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.
META-Health Professional 2025
By META-Health International
Become a META-Health professional with our 6 months intensive training! Do you want to learn the scientific background of body-mind-interactions and how to integrate this knowledge in your practical work with your clients? This course contains both self-study and live training in online classes and covers the META-Health Level 1 and 2 material. It will take 6 months including 24 live sessions, 2 hours each, mainly in a weekly rhythm. You will get preparatory videos, reading material and tasks that help to understand and integrate the content, while the group sessions focus on demonstrations, discusion of the material, and practical exercises for you. All the time, our trainers and tutors will support you and we’ll be a learning family with an active chatgroup. Altogether you should reckon approximately 5 hours per week.
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
***24 Hour Limited Time Flash Sale*** Google Analytics Course - Taking Your Business to the Next Level Course Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Google Analytics for Beginners - Master Google Analytics Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Google Analytics for Beginners - Master Google Analytics Course bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Google Analytics Course - Taking Your Business to the Next Level Course Online Training, you'll receive 25 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Google Analytics Course - Taking Your Business to the Next Level Course Career Bundle: Course 01: Google Analytics for Everyone Course 02: Google Data Studio: Data Analytics Course 03: Business Data Analysis Course 04:Big Data Analytics with PySpark Tableau Desktop and MongoDB Course 05: Big Data Analytics with PySpark Power BI and MongoDB Course 06: Introduction to Data Analytics with Tableau Course 07: Develop Big Data Pipelines with R & Sparklyr & Tableau Course 08: Develop Big Data Pipelines with R, Sparklyr & Power BI Course 09: Quick Data Science Approach from Scratch Course 10: Machine Learning with Python Course Course 11: Python Programming Bible | Networking, GUI, Email, XML, CGI Course 12: Data Science & Machine Learning with Python Course 13: SQL for Data Science, Data Analytics, and Data Visualization Course 14: Customer Analytics Training Course 15: Statistical Analysis Course 16: Excel Data Analysis Course 17: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course 18: Business Intelligence and Data Mining Diploma Course 19: How To Do Keyword Research For SEO & Ranking On Google Course 20: Digital Marketing for Business Course 21: Digital Marketing Starting an Online E-Commerce Store Course 22: Marketing Strategies for Business Course 23: Strategic Planning and Analysis for Marketing Course 24: Ultimate Social Media Marketing course Course 25: Bootstrap - Responsive Web Design With Google Analytics Course - Taking Your Business to the Next Level Course, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in Google Analytics Course - Taking Your Business to the Next Level Course today and take the first step towards achieving your goals and dreams. Why buy this Google Analytics Course - Taking Your Business to the Next Level Course? Free CPD Accredited Certificate upon completion of Google Analytics Course - Taking Your Business to the Next Level Course Get a free student ID card with Google Analytics Course - Taking Your Business to the Next Level Course Lifetime access to the Google Analytics Course - Taking Your Business to the Next Level Course materials Learn Google Analytics Course - Taking Your Business to the Next Level Course from anywhere in the world 24/7 tutor support with the Google Analytics Course - Taking Your Business to the Next Level Course. Start your learning journey straightaway with our Google Analytics for Beginners - Master Google Analytics Course Training! Google Analytics Course - Taking Your Business to the Next Level Course premium bundle consists of 25 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Google Analytics Course - Taking Your Business to the Next Level Course is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the course. After passing the Google Analytics Course - Taking Your Business to the Next Level Course exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This bundle is ideal for: Students seeking mastery in this field Professionals seeking to enhance their skills Anyone who is passionate about this topic Requirements This Google Analytics Course - Taking Your Business to the Next Level Course doesn't require prior experience and is suitable for diverse learners. Career path This Google Analytics Course - Taking Your Business to the Next Level Course bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.
Learn the Fundamentals of Analytics - Become an Expert in Web & Marketing Analytics
(3)By Studyhub UK
Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Learn the Fundamentals of Analytics - Become an Expert in Web & Marketing Analytics bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 33 course mega bundle that will exceed your expectations within your budget. The Learn the Fundamentals of Analytics - Become an Expert in Web & Marketing Analytics related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Learn the Fundamentals of Analytics - Become an Expert in Web & Marketing Analytics bundle will help you build a solid foundation to become a proficient worker in the sector. This Learn the Fundamentals of Analytics - Become an Expert in Web & Marketing Analytics Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 :Diploma in Data Analysis Fundamentals Course 02 :Google Data Studio: Data Analytics Course 03 :Statistics Course 04 :Statistical Analysis Course 05 :Statistics & Probability for Data Science & Machine Learning Course 06 :Quick Data Science Approach from Scratch Course 07 :Business Intelligence and Data Mining Course 08 :Financial Analysis Course 09 :Financial Statement Analysis Masterclass Course 10 :Financial Modeling Using Excel Course 11 :Fundamentals of Business Analysis Course 12 :Business Intelligence Analyst Course 13 :Investment Course 14 :Investment Analyst Course 15 :Financial Ratio Analysis for Business Decisions Course 16 :Banking and Finance Accounting Statements Financial Analysis Course 17 :Technical Analysis Masterclass for Trading & Investing Course 18 :Strategic Planning and Analysis for Marketing Course 19 :Learn to Read, Analyse and Understand Annual Reports Course 20 :Financial Analysis : Finance Reports Course 21 :Stakeholder Management Analyst Course 22 :Purchase Analyst Course 23 :RCA: Root Cause Analysis Course 24 :Root Cause Analysis: Toolkit Course 25: Excel Data Analysis Course 26: Receptionist Skills Course 27: Minute Taking Executive Training Course 28: Time Management Training - Online Course Course 29: Complete Communication Skills Master Class for Life Course 30: Public Speaking 3 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 :Career Development Plan Fundamentals Course 02 :CV Writing and Job Searching Course 03 :Interview Skills: Ace the Interview Learning Outcome This tailor-made Learn the Fundamentals of Analytics - Become an Expert in Web & Marketing Analytics bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Learn the Fundamentals of Analytics - Become an Expert in Web & Marketing Analytics Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 330 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Learn the Fundamentals of Analytics - Become an Expert in Web & Marketing Analytics bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Learn the Fundamentals of Analytics - Become an Expert in Web & Marketing Analytics Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.
