- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
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
Excel - intermediate (In-House)
By The In House Training Company
This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print
Excel - introduction (In-House)
By The In House Training Company
This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report
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 1725his 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.
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.
Scheduling your social media content can help you to stay organised, keep consistent with your posting, and help you stay true to your goals for your business on Social Media! In this course, we’ll be looking at Social Media Scheduling – what it is, how it can benefit you, and most importantly – how to do it! We’ll cover: How social media scheduling can benefit your business The platforms you can use for social media scheduling and what might be the best option for you How to use Meta Business Suite to schedule posts for Facebook and Instagram How schedule posts on Linkedin Using a Third party and paid software like Hootsuite or an alternative platform As part of the live event of this workshop, we will also have a Questions and Answers session to finish this online workshop, where participants can ask specific questions about social media scheduling for their business. Event details: Date: Wednesday 15th January 2025 Time: 10am – 11.30am Location: Online (ZOOM) For: Businesses based in Luton The Luton Online: Digital Marketing Launchpad is a project funded by the UK Government through the UK Shared Prosperity Fund. The UK Shared Prosperity Fund is a central pillar of the UK government's Levelling Up agenda and provides £2.6 billion of funding for local investment by March 2025. The Fund aims to improve pride in place and increase life chances across the UK investing in communities and place, supporting local business, and people and skills. For more information, visit: https://www.gov.uk/government/publications/uk-shared-prosperity-fund-prospectus
***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.
Google Analytics
By Compete High
Overview With the ever-increasing demand for Google Analytics in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Google Analytics may be. Learning about Google Analytics or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Google Analytics . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Google Analytics is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Google Analytics course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Google Analytics course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Google Analytics course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Google Analytics , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Google Analytics , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Google Analytics , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Google Analytics course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 1 Installing Analytics Installing Analytics 00:00 Module 2 The Five Report Suites The Five Report Suites 00:00 Module 3 Basic Date Range Reports Basic Date Range Reports 00:00 Module 4 Goals Goals 00:00 Module 5 Practical Uses for Analytics Practical Uses for Analytics 00:00
Data Analytics with Tableau
By Course Cloud
The comprehensive Data Analytics with Tableau has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Data Analytics with Tableau today, and learn from the very best the industry has to offer! This best selling Data Analytics with Tableau has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Data Analytics with Tableau is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Data Analytics with Tableau is CPD-accredited, so you can be confident you're completing a quality training course which will boost your CV and enhance your career potential. The Data Analytics with Tableau is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Data Analytics with Tableau, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Data Analytics with Tableau will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Data Analytics with Tableau to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.
