• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

56266 Courses near london delivered Online

Adobe InDesign Advanced Training

By London Design Training Courses

Why Learn Adobe InDesign Advanced Training Course? Master Adobe InDesign for efficient page layouts with our advanced course. Learn document setup, text formatting, and special effects. Suitable for beginners and advanced users. London Design Training Course provides top InDesign course with Adobe Certified Instructors. Course Link Duration: 10 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own schedule by pre-booking hours of your choice, available from Mon to Sat between 9 am and 7 pm Flexible Learning Options: Choose between in-class training at our London center or participate online. Both options provide hands-on, practical learning with step-by-step demonstrations and ample opportunities for questions. Introduction to InDesign: Exploring InDesign Basics Customizing Preferences and Workspace Navigating Panels and Windows Setting Up Toolbar and Properties Panel Document Management: New Document, Pages, and Order Quick Navigation Techniques with Shortcuts Smart Layout: Organizing Layouts with Guides and Grids Understanding Bleed, Slug, and Margins Utilizing Smart Guides for Precision Typography: Mastering the Type Tool Adding Text to Pages and Using Placeholder Text Text Formatting with Character and Paragraph Controls Editing Text Frames and Justifying Text Multi-column Setup and Styling with Character/Paragraph Styles Working with Bullet Points and Numbering Working with Images: Creating Frames and Placing Images Content Fitting Options: Proportional Fit, Content-Aware Fit, Auto-Fit Manipulating Frame Properties: Fill, Stroke, Effects Utilizing Object Styles for Consistent Frames Advanced Techniques: Image Frame Grids, Merging Frames, Text Wrap Options Understanding Image Formats and Resolution Tabs and Alignment: Mastering Tab Palette and Alignment Options Adding Leaders for Enhanced Formatting Color Theory and Editing: Basics of Color Theory and Color Modes Creating Color Themes with the Color Theme Tool Swatches, Color Libraries, and Gradients Editing Gradient Fills and Colors Advanced Interactive Actions: Adding Animation Effects with Animation Panel Fine-tuning Animations with Timing Panel Creating Complex Object States and Action Buttons Adding and Testing Hyperlinks, Page Transitions Parent Page Basics: Understanding Parent Pages Page Numbering, Order, Headers, and Footers Inserting Text Variables for Dynamic Content Advanced Object Styles and Effects: Opacity Control and Blending Modes Black and White Conversion, Color Blending Modes Adding Dimension with Bevel and Emboss Effects Advanced Text Frame Options: Auto-sizing Text Frames and Balancing Column Height Inset Spacing and Fill Colors for Text Boxes Hot Corner Resizing Shortcuts and Anchor Objects Footnotes: Purpose and Usage of Footnotes Adding, Editing Footnotes with Footnote Options By the end of this Adobe InDesign training, participants will: Understand InDesign basics and its interface. Create effective page layouts with text formatting and image placement. Work with layers, apply special effects, and manage tables. Ensure error-free and print-ready documents through preflighting. Receive a practical training guide and an e-certificate upon completion.

Adobe InDesign Advanced Training
Delivered in London or OnlineFlexible Dates
£290

AutoCAD Mac Basic-Intermediate Training Courses

By London Design Training Courses

AutoCAD Mac Basic to Intermediate Training: Clickhere for more info Learn to produce accurate, to-scale 2D drawings with AutoCAD for Mac training.  A project-based course made for AutoCAD Mac users and focused on architecture & interior designs students and professionals. Duration: 10 hrs Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Monday to Saturday between 9 am and 7 pm. AutoCAD Mac Basic to Intermediate Training: Master precise, to-scale 2D drawings with tailored AutoCAD for Mac training. Designed for architecture and interior design professionals and students. Duration: 10 hours of in-depth learning. Method: Personalized 1-on-1 attention for an immersive learning experience. Flexible Scheduling: Choose your convenient hour from Monday to Saturday, between 9 am and 7 pm. Book now to customize your training journey! AutoCAD Mac Basic to Intermediate Training: Master precise, to-scale 2D drawings with tailored AutoCAD for Mac training. Designed for architecture and interior design professionals and students. Duration: 10 hours of in-depth learning. Method: Personalized 1-on-1 attention for an immersive learning experience. Flexible Scheduling: Choose your convenient hour from Monday to Saturday, between 9 am and 7 pm. Book now to customize your training journey! AutoCAD Mac Basic to Intermediate Training: Master precise, to-scale 2D drawings with tailored AutoCAD for Mac training. Designed for architecture and interior design professionals and students. Duration: 10 hours of in-depth learning. Method: Personalized 1-on-1 attention for an immersive learning experience. Flexible Scheduling: Choose your convenient hour from Monday to Saturday, between 9 am and 7 pm. Book now to customize your training journey! AutoCAD Mac Basic to Intermediate Training: Master precise, to-scale 2D drawings with tailored AutoCAD for Mac training. Designed for architecture and interior design professionals and students. Duration: 10 hours of in-depth learning. Method: Personalized 1-on-1 attention for an immersive learning experience. Flexible Scheduling: Choose your convenient hour from Monday to Saturday, between 9 am and 7 pm. Book now to customize your training journey!

AutoCAD Mac Basic-Intermediate Training Courses
Delivered in London or OnlineFlexible Dates
£290

Rhino 2D | 3D Training Course for Jewellery Design

By London Design Training Courses

Why Opt for the Rhino 3D Training Course in Jewelry Design? Click here for more info Within a span of 10 hours, you'll master the interface and gain insights into how Rhino leverages points, lines, surfaces, and solids to fashion printable 3D objects. Moreover, you'll explore the art of crafting repetitive and intricate geometric shapes, perfect for creating minimalist and elegant jewelry. Flexible Scheduling: 1-on-1 training sessions tailored to your schedule. Pick any hour between 9 am and 7 pm from Mon to Sat. Course Duration: 10 hours. Training Methods: Choose between in-person sessions or live online training. Why Choose Our Rhino 3D Training Course for Jewelry Design? Rhino, also known as Rhinoceros, stands as a robust 3D computer graphics and computer-aided design software extensively utilized in various industries, including architecture, industrial design, and multimedia. LDTC offers meticulously crafted Rhino courses to empower you in mastering this software. Led by experienced instructors, our courses ensure a comprehensive understanding of Rhino, equipping you to create exceptional designs, specifically tailored for jewelry creation. Rhino 3D Training for Jewelry Design: Our Rhino 3D training caters to both beginners and those aspiring to acquire advanced techniques, emphasizing its application in jewelry design. Course Highlights: Precise 3D Modeling: Master the art of crafting free-form 3D NURBS models with utmost precision. Advanced Functionality: Explore Rhino's advanced surfacing commands and features tailored for jewelry design. User Interface Mastery: Navigate Rhino's interface seamlessly and refine your skills in curves, surfaces, and solids. Expert Guidance: Acquire expertise in Rhino's modeling environment under the guidance of seasoned professionals. Modeling Why Choose Our Rhino 3D Training Course for Jewelry Design? Rhino, also known as Rhinoceros, stands as a robust 3D computer graphics and computer-aided design software extensively utilized in various industries, including architecture, industrial design, and multimedia. LDTC offers meticulously crafted Rhino courses to empower you in mastering this software. Led by experienced instructors, our courses ensure a comprehensive understanding of Rhino, equipping you to create exceptional designs, specifically tailored for jewelry creation. Rhino for Jewelry Design - 16-Hour Course Module 1: Introduction and Navigation Get acquainted with Rhino's interface, menus, and screen layout. Navigate Rhino models with precision in 2D lines, polylines, and NURBS curves. Use modeling setup features like snap, ortho, and planar constraints for accuracy. Leverage object snaps and Smart Track functionality for enhanced precision. Module 2: Solid and Surface Modeling Fundamentals Rapidly develop 3D solids and surfaces using Rhino's organized layering system. Utilize coordinates and constraints for meticulous modeling in 3D space. Create diverse shapes, including rectangles, circles, arcs, ellipses, and polygon curves. Enhance models with Rhino render, render color, and free-form curves. Efficiently handle model views with pan, zoom, and view management tools. Implement various editing commands for curve manipulation and transforming curves into surfaces and solids. Utilize history tracking for advanced editing and execute general editing actions. Module 3: Intermediate Edit and Surfacing Techniques Introduce essential NURBS modeling concepts and terminologies. Edit curves and surfaces through control point manipulation and rebuilding for optimal refinement. Use the nudge modeling aid for precise adjustments and generate deformable shapes. Create curves through projection techniques and split surfaces using curves and surfaces. Blend surfaces seamlessly, utilizing symmetry tools, lighting, and rendering effects. Convert intricate 3D objects into detailed 2D drawings and craft page layouts. Module 4: Advanced Surfacing and Solid Modeling Techniques Construct model primitives and solid text using techniques such as pipe and extrusion. Efficiently modify solids using Boolean tools, expanding surface modeling capabilities. Utilize techniques like extrusion, lofting, and revolving for intricate surfaces. Create sweeps using 1 and 2 rail curves and master surface network techniques for complex shapes. Downlaod Rhino. Upon completion of the Rhino 3D Training Course for Jewelry Design, participants can expect the following learning outcomes: Mastering Rhino Interface: Gain a comprehensive understanding of Rhino's interface, menus, and screen layout. Precision in Modeling: Navigate Rhino models with precision using 2D lines, polylines, and NURBS curves. Modeling Setup Proficiency: Utilize modeling setup features such as snap, ortho, and planar constraints for accurate designs. Enhanced Navigation Techniques: Leverage object snaps and Smart Track functionality for enhanced precision during navigation. Solid and Surface Modeling Skills: Rapidly develop 3D solids and surfaces with Rhino's organized layering system. Coordination and Constraint Application: Utilize coordinates and constraints for meticulous modeling in 3D space. Diverse Shape Creation: Create diverse shapes, including rectangles, circles, arcs, ellipses, and polygon curves. Rendering and Enhancement Techniques: Enhance models with Rhino render, render color, and free-form curves. Efficient Model View Handling: Efficiently handle model views with pan, zoom, and view management tools. Intermediate Edit and Surfacing Techniques: Edit curves and surfaces through control point manipulation and rebuilding for optimal refinement. NURBS Modeling Mastery: Introduce essential NURBS modeling concepts and terminologies. Advanced Editing and Modeling Skills: Use the nudge modeling aid for precise adjustments and generate deformable shapes. Complex Shape Creation: Create sweeps using 1 and 2 rail curves and master surface network techniques for intricate shapes. Solid Modeling Proficiency: Construct model primitives and solid text using techniques such as pipe and extrusion. Application of Boolean Tools: Efficiently modify solids using Boolean tools, expanding surface modeling capabilities. Advanced Surfacing Techniques: Utilize techniques like extrusion, lofting, and revolving for intricate surfaces. Conversion and Crafting of 2D Drawings: Convert intricate 3D objects into detailed 2D drawings and craft page layouts. Hands-On Project Experience: Engage in practical exercises and hands-on projects tailored for jewelry design applications. Upon mastering these skills, participants will be well-equipped to create sophisticated jewelry designs using Rhino 3D modeling software.

Rhino 2D | 3D Training Course for Jewellery Design
Delivered in London or OnlineFlexible Dates
£290

CMI Level 3 Certificate in Principles of Management and Leadership 3C30

By Harpar Qualifications Ltd

These qualifications are aimed at practising or aspiring managers will supervise or manage a team to achieve clearly defined outcomes. They will set and monitor goals and objectives by providing instruction, direction and guidance. Day to day operational and project activities are a key part of their role.

CMI Level 3 Certificate in Principles of Management and Leadership 3C30
Delivered Online On Demand
£449

Script Writing - CPD Certified

4.5(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 Script Writing 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 37 course mega bundle that will exceed your expectations within your budget. The Script Writing 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 Script Writing bundle will help you build a solid foundation to become a proficient worker in the sector. This Script Writing Bundle consists of the following 30 CPD Accredited Premium courses - Course 1: Creative Writing Course 2: Copywriting Course Level 4 Course 3: Novel Writing and Publishing Course 4: Creative Writing Course: Writing Storybooks For Children Course 5: Diploma in Drama and Comedy Writing Course 6: Creative Writing Course - Short Stories Course 7: Creative Writing Course - Fiction Course 8: Creative Writing Course - Horror Course 9: Creative Writing Course - Novel Course 10: Creative Writing Course - Thriller Course 11: Creative Nonfiction Book Writing Course 12: News Writing: Journalism 101 Course 13: Selling E-books: The Best Way of Earning Online Course 14: Basics of Shopify: Earn through E-books Course 15: Blogger for Beginners Course 16: Business Writing Course 17: Business Writing - How You Can Become a Great Writer Course 18: Business Writing: Influence Your Readers Course 19: Write and Publish a Research Paper: Complete Guide v6 Course 20: How to Write a Research Paper in Law and Humanities Course 21: Freelance Masterclass - Become An Expert Copywriter Course 22: Content Writing & Copy Writing For SEO and Sales Course 23: Webinar Marketing Write, Design & Market Webinars Course 24: Email Writing Training Course 25: Creative Advertising and Graphic Design for Everyone Course 26: CV Writing and Job Searching Course 27: Foundations of Leadership and Negotiation Skills Development Course 28: Personal Development and Productivity Level 2 Course 29: 10 Soft Skills for Workplace Course 30: Public Speaking 7 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5:Create a Professional LinkedIn Profile Course 6:Business English Perfection Course Course 7:Networking Skills for Personal Success Learning Outcome This tailor-made Script Writing 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 Script Writing 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 370 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 Script Writing 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 Script Writing 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.

Script Writing - CPD Certified
Delivered Online On Demand8 days
£370

Creative Writing & Copywriting - Advanced Diploma (CPD Certified)

4.5(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 Creative Writing, Copy Writing 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 37 course mega bundle that will exceed your expectations within your budget. The Creative Writing, Copy Writing 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 Creative Writing, Copy Writing bundle will help you build a solid foundation to become a proficient worker in the sector. This Creative Writing, Copy Writing Bundle consists of the following 30 CPD Accredited Premium courses - Course 1: Creative Writing Course 2: Copywriting Course Level 4 Course 3: Novel Writing and Publishing Course 4: Creative Writing Course: Writing Storybooks For Children Course 5: Diploma in Drama and Comedy Writing Course 6: Creative Writing Course - Short Stories Course 7: Creative Writing Course - Fiction Course 8: Creative Writing Course - Horror Course 9: Creative Writing Course - Novel Course 10: Creative Writing Course - Thriller Course 11: Creative Nonfiction Book Writing Course 12: News Writing: Journalism 101 Course 13: Selling E-books: The Best Way of Earning Online Course 14: Basics of Shopify: Earn through E-books Course 15: Blogger for Beginners Course 16: Business Writing Course 17: Business Writing - How You Can Become a Great Writer Course 18: Business Writing: Influence Your Readers Course 19: Write and Publish a Research Paper: Complete Guide v6 Course 20: How to Write a Research Paper in Law and Humanities Course 21: Freelance Masterclass - Become An Expert Copywriter Course 22: Content Writing & Copy Writing For SEO and Sales Course 23: Email Writing Training Course 24: Medieval History Course 25: Military History Course 26: Creative Advertising and Graphic Design for Everyone Course 27: Boost Your Confidence and Self-Esteem Course 28: Foundations of Leadership and Negotiation Skills Development Course 29: Personal Development and Productivity Level 2 Course 30: Public Speaking 7 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5:Create a Professional LinkedIn Profile Course 6:Business English Perfection Course Course 7:Networking Skills for Personal Success Learning Outcome This tailor-made Creative Writing, Copy Writing 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 Creative Writing, Copy Writing 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 370 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 Creative Writing, Copy Writing bundle! This bundle is also ideal for professionals looking for career advancement. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Creative Writing, Copy Writing 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. Certificates CPD Accredited Digital certificate - Included CPD Accredited Hard copy certificate - Included

Creative Writing & Copywriting  - Advanced Diploma (CPD Certified)
Delivered Online On Demand8 days
£370

Teaching Assistant, Remote teaching and Phonics Teaching

4.5(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 Teaching Assistant, Remote teaching and Phonics Teaching 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 37 course mega bundle that will exceed your expectations within your budget. This Teaching Assistant, Remote teaching and Phonics Teaching Bundle consists of the following 30 CPD Accredited Premium courses - Course 1: Teaching Assistant Diploma Course 2: The Complete Guide To Getting A Teaching Job Course 3: SEND Teaching Assistant Course 4: EYFS Teaching Assistant Course 5: Phonics Teaching Certificate Course 6: Remote Teaching Course 7: Lesson Planning for Teaching Course 8: Learning Disability Nursing Course 9: Nursery Nurse Course 10: Mental Health Teaching Assistant Course 11: ADHD Awareness Course 12: Leadership in Teaching Course 13: Positive Handling in Schools Course 14: Learning to Learn - Super Learning Course 15: Educational Psychology Course 16: Education Management Course 17: Education and Pedagogy Course 18: Blended Learning Course for Teachers Course 19: Understanding Autism Level 3 Course 20: Health and Safety Training for School Administrators Course 21: Child Language Disorder (CLD) Course 22: Child Playwork Course 23: Child Neglect Awareness & Protection Course 24: Communication Skills Course 25: Team Management Course 26: Problem Solving Skills Course 27: Leadership Skills Course 28: Presentation Skills Course 29: Microsoft Office Course 30: Cross-Cultural Awareness Training 7 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5:Create a Professional LinkedIn Profile Course 6:Business English Perfection Course Course 7:Networking Skills for Personal Success Learning Outcome 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 Teaching Assistant, Remote teaching and Phonics Teaching 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 370 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 Teaching Assistant, Remote teaching and Phonics Teaching 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 Teaching Assistant, Remote teaching and Phonics Teaching 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.

Teaching Assistant, Remote teaching and Phonics Teaching
Delivered Online On Demand8 days
£370

Excel Module 2 - Data Analysis and Pivot Tables

By Underscore Group

Expand your Excel knowledge and learn how to structure and analyse large data sets.

Excel Module 2 - Data Analysis and Pivot Tables
Delivered OnlineFlexible Dates
£270

Excel Module 1 - Key Skills and Formula Creation

By Underscore Group

Start from the ground up and learn tips, tricks, shortcuts and build confidence in using Excel.

Excel Module 1 - Key Skills and Formula Creation
Delivered OnlineFlexible Dates
£270

Excel Module 4 Advanced Formulas and Functions

By Underscore Group

Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time. Course overview Duration: 1 day (6.5 hours) Our Excel Module 4 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data. This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending. Objectives By the end of the course you will be able to: Use a range of Text functions to manage text data Create and use different types of date and time functions Work with rounding functions Use logical statements Build nested formula Use SUMIF, COUNTIF and AVERAGEIF Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions Use IS functions and IFERROR to test cell values Content Working with text Splitting text into multiple cells Merging data into one cell Extracting data using text functions Tidying data Working with dates and times Formatting dates and times Date and time functions Calculating date and time differences Using functions to round numbers up and down ROUND ROUNDUP ROUNDDOWN CEILING FLOOR Use lookup functions Lookup functions Creating a lookup table Range naming Using VLOOKUP Using HLOOKUP Using INDEX and MATCH Working with logical statements Creating an IF statement Using the AND plus OR functions Nesting functions Calculating values based on given criteria SUMIF(S) COUNTIF(S) AVERAGEIF(S) Using IS and IFERROR and test cell values ISBLANK ISNUMBER ISTEXT ISERROR IFERROR

Excel Module 4 Advanced Formulas and Functions
Delivered OnlineFlexible Dates
£270