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

1381 Courses in Cardiff delivered On Demand

Software Developer & Programmer Career Path Mini Bundle

By Compete High

In the fiercely competitive tech job market, standing out is more than just writing code—it’s about mastering a versatile skill set that employers demand. The Software Developer & Programmer Career Path Mini Bundle is designed to boost your hireability by sharpening your expertise in Python, Go Lang, UX, DevOps, and leadership skills as a Team Leader. Whether you’re aiming to land your first developer role or climb into management, companies across industries—from fintech to health tech—are actively searching for professionals fluent in Python and Go Lang, adept in UX principles, proficient in DevOps, and ready to lead teams confidently as a Team Leader. Description Software development today isn’t just about coding. Mastery in Python and Go Lang gives you the technical backbone to build scalable applications, while strong UX knowledge ensures that what you build truly serves users. Add to that the operational savvy of DevOps and the interpersonal and strategic skills of a Team Leader, and you become a powerhouse hire. Employers value candidates who blend these competencies because they can drive projects from concept to delivery, collaborate across departments, and inspire teams to success. Whether working for startups, large corporations, or remote-first teams, your command of Python, Go Lang, UX, DevOps, and Team Leader skills puts you ahead of the curve. Don’t let the competition pass you by. This bundle bundles everything recruiters are demanding—from core programming languages to leadership traits—into one job-focused package. FAQ Who benefits most from this bundle? Aspiring and current software developers, programmers, tech leads, and anyone seeking to step into a leadership role. If you want to excel with Python, Go Lang, understand UX, manage infrastructures with DevOps, or grow as a Team Leader, this bundle is for you. Why include leadership in a programming bundle? Because modern software teams need developers who can lead. Being a Team Leader means managing people, timelines, and expectations—all vital for career growth beyond coding. Is this bundle beginner-friendly or advanced? It suits all levels. Beginners can build solid foundations in Python and Go Lang, while intermediate users gain skills in UX, DevOps, and Team Leader practices to boost hireability.

Software Developer & Programmer Career Path Mini Bundle
Delivered Online On Demand11 hours
£19.99

Photoshop CC Masterclass - Beginner to Advanced

4.3(43)

By John Academy

Description Do you want to master the world's best photo editing software? Or are you new to Adobe Photoshop CC? Then enrol the Adobe Photoshop CC Foundation course and begin your acquaintance with the course. The course is for the learners who have little or no knowledge about the photo editor. You will start your journey from the beginning. You will be familiar with the user interface and know how to open and create an image in Adobe Photoshop. The course introduces you to the essential tools, brushes and other features so that you can able to decide which tools to select while editing. Additionally, the course illustrates the concepts of colour schemes and guides you on how to use the colors efficiently. The procedures of adding text and text styles, working with Layers, adjusting Layers, customizing the workspace, moving and transforming Pixels, cropping images, etc. will be covered in the course. Finally, the course shows you how to print, convert and export files from Photoshop. Shortly, the course gives you a general understanding of the application so that you can proceed with the advanced skills. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Photoshop CC Masterclass - Beginner to Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Photoshop CC Masterclass - Beginner to Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Adobe Photoshop CC Beginner Introduction Introduction FREE 00:03:00 Introduction to Photoshop Introduction to Photoshop 00:05:00 Understanding Types of Documents 00:04:00 Understanding Resolution 00:04:00 Creating New Documents 00:06:00 Using Artboards 00:05:00 Using CC Templates 00:03:00 Utilizing the Search Feature 00:02:00 Customizing the Workspace Using Workspace Presets 00:02:00 Moving, Closing, and Opening Panels 00:06:00 Understanding Document Views 00:06:00 Using the History Panel 00:06:00 Working with Layers Why Layers 00:02:00 Using Layers 00:07:00 Creating Fill Layers 00:05:00 Applying Blending Modes 00:04:00 Using Layer Styles 00:09:00 Discovering the Properties Panel 00:08:00 Understanding Selections Creating Basic Selections 00:09:00 Using the Lasso Tools 00:08:00 Understanding the Quick Select Tools 00:07:00 Editing the Quick Mask 00:04:00 Saving Selectionsv 00:04:00 Moving Selections to Layers.mp 00:03:00 Understanding and Using Color Understanding Color Modes 00:10:00 Creating Swatches 00:06:00 Using Masks and Advanced Layers Applying Layer Masks 00:00:00 Deleting Layer Masks 00:01:00 Organizing Layers 00:03:00 Merging Layers 00:02:00 Flattening Layers 00:02:00 Working with Layer Comps 00:06:00 Using Adjustment Layers Using Image Adjustments 00:07:00 Understanding Adjustment Layers 00:10:00 Using Layer Masks with Adjustment Layers 00:03:00 Cropping Images Using the Crop Tool 00:05:00 Using the Crop Tool to Add Canvas 00:02:00 Moving and Transforming Pixels Using Free Transform 00:04:00 Working with Other Transform Options 00:03:00 Flipping Pixels 00:01:00 Adding Text and Text Styles Using the Type Tool 00:10:00 Discovering Typesetting 00:08:00 Formatting Text 00:09:00 Creating Type on a Path 00:03:00 Warping Type 00:03:00 Using Styles on Type 00:08:00 Applying Special Effects Using Layer Styles 00:05:00 Working with Patterns 00:03:00 Applying Filters 00:04:00 Creating Pixels with Filters 00:06:00 Exporting from Photoshop Printing in Photoshop 00:03:00 Converting to CMYK 00:04:00 Converting to Other File Types 00:13:00 Using File Info 00:09:00 Conclusion Course Recap 00:03:00 Adobe Photoshop CC Intermediate Start Here Introduction FREE 00:03:00 Painting and Using Brushes Painting with Brushes 00:09:00 Using the Brushes Panel 00:06:00 Defining Custom Brushes 00:04:00 Saving Tool Presets 00:02:00 Using the History Brush 00:03:00 Using Vector Tools Working with Vector Shapes 00:10:00 Creating Custom Shapes 00:02:00 Using the Pen Tool 00:07:00 Discovering Paths 00:04:00 Understanding Vector Masks 00:03:00 Using Vector Objects and Spot Colors 00:06:00 Using Libraries What is the CC Library 00:02:00 Adding and Deleting Assets in the Library 00:03:00 Sharing Assets 00:02:00 Creating New Libraries 00:03:00 Sharing a Library 00:02:00 Advanced Special Effects Using the Blur Filters 00:06:00 Applying the Distort Filters 00:03:00 Creating a Pixelated Look 00:02:00 Stylizing Effects 00:02:00 Using Liquify 00:05:00 Using Smart Filters 00:04:00 Working with Smart Objects 00:03:00 Loading a Texture into Type 00:04:00 Working with RAW Images What is a Raw Image 00:05:00 Processing Raw Images 00:12:00 Opening a JPEG File in Raw 00:06:00 Retouching Basics Developing a Strategy for Retouching 00:04:00 Using Retouching Tools 00:10:00 Using the Dust and Scratches Filter 00:04:00 Applying Sharpening 00:08:00 Working with Face Aware Liquify 00:06:00 Automating Tasks Using Actions 00:03:00 Creating Actions 00:07:00 Using Droplets 00:05:00 Using the Image Processor 00:05:00 Creating an HDR Image 00:07:00 Creating a Panoramic Image 00:07:00 Integration with other Adobe Software Using PSD Files in InDesign 00:04:00 Using PSD Files in Illustrator 00:03:00 Using PSD Files in Dreamweaver 00:04:00 Understanding Color Management Why Color Management 00:03:00 Calibrating a Monitor 00:04:00 Calibrating a Printer 00:03:00 Loading Profiles into PSDs 00:02:00 Conclusion Course Recap 00:03:00 Adobe Photoshop CC Advanced Introduction Introduction FREE 00:03:00 Processing Raw Images What is the RAW Format 00:04:00 Understanding White Balance 00:05:00 Setting Exposure 00:07:00 Working with Color and Clarity 00:03:00 Working with Adobe Camera Raw Updating Adobe Camera Raw 00:01:00 Using the Before and After Views 00:05:00 Resetting the Sliders 00:01:00 Understanding the Workflow Options 00:04:00 Setting the Camera Raw Preferences 00:03:00 Working with the Tools Understanding the White Board Tool 00:03:00 Using the Color Sampler 00:01:00 Working with the Targeted Adjustment Tool 00:02:00 Cropping Images 00:03:00 Applying Straightening 00:01:00 Using the Spot Removal Tool 00:05:00 Applying the Red Eye Tool 00:03:00 Understanding the Adjustment Brush 00:04:00 Using the Graduated Filter 00:02:00 Applying the Radial Filter 00:02:00 Rotating Images 00:01:00 Using Advanced Exposure Settings and Sharpening Using Curves 00:03:00 Understanding Sharpening and Noise 00:03:00 Creating Grayscale Images 00:03:00 Using Split Toning 00:03:00 Managing Corrections and Effects Enabling Lens Profiles 00:03:00 Using Effects 00:02:00 Adding Grain 00:02:00 Applying Post Crop Vignette 00:02:00 Using Camera Calibration 00:03:00 Saving Presets 00:02:00 Applying Snapshots 00:02:00 Creating Image Adjustments Using Adjustment Layers 00:02:00 Painting Layer Masks 00:05:00 Discovering Plugins for Photoshop What are Plugins 00:04:00 Using the Nik Collection 00:08:00 Using HDR Pro Effex 00:06:00 Using On1 Effects 00:04:00 Exploring Workflows Introudcing the Workshop Videos 00:04:00 Processing a Landscape Image 00:13:00 Processing a Macro Image 00:09:00 Processing a City 00:11:00 Conclusion Course Recap 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Photoshop CC Masterclass - Beginner to Advanced
Delivered Online On Demand10 hours 52 minutes
£12

Accident investigation - CPD Accredited 3 Courses Bundle

5.0(2)

By Training Express

Accidents may be unintentional, but understanding them is no accident. Our CPD-accredited Accident Investigation 3-Course Bundle offers a thorough look into the essential processes and responsibilities tied to investigating workplace incidents. This carefully arranged online package is designed for individuals looking to build a solid base of knowledge that supports safety, awareness, and accountability in a professional environment—without overcomplicating the subject. Each course is built to suit learners from all sectors, whether you're managing teams, working in health and safety, or simply keen to strengthen your understanding of risk-related procedures. With straightforward guidance and structured modules, you’ll gain valuable insights into how to assess incidents, record findings clearly, and help reduce future hazards. Learn at your own pace from the comfort of anywhere—no travel, no fuss, just quality online learning. These comprehensive courses are available in this Accident investigation - CPD Accredited 3 Courses Bundle Course 01: Accident investigation Course 02: Criminology: Criminal Investigation Training Course 03: Criminal Psychology and Intelligence ** Special Offer: Free PDF and Hard Copy Certificates** Key Benefits Get instant PDF and Hard Copy certificate Fully online courses Developed by qualified professionals Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance Course Curriculum: Module 01: Understanding the Investigation Module 02: Why Investigate? Module 03: Accident Investigation Procedure Module 04: Documenting The Accident Scene Module 05: Conducting Effective Interviews Module 06: Investigation and Cause Analysis Module 07: Developing Solutions Module 08: Report Documentation and Communication Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing each Accident investigation - CPD Accredited 3 Courses Bundle bundle course. For each test, the pass mark will be set to 60%. CPD 30 CPD hours / points Accredited by The CPD Certification Service Who is this course for? The Accident investigation - CPD Accredited 3 Courses Bundle training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Accident investigation - CPD Accredited 3 Courses Bundle training.

Accident investigation - CPD Accredited 3 Courses Bundle
Delivered Online On Demand1 hour
£41

Content Management - CPD Accredited 3 Courses Bundle

5.0(14)

By Training Express

Managing content effectively is at the heart of every successful digital presence, and this CPD-accredited bundle offers an expertly designed pathway to mastering it. Across three focused courses, learners gain valuable insights into organising, maintaining, and optimising digital content to meet ever-evolving online demands. Whether you are refreshing your knowledge or exploring new strategies, this bundle provides the clarity and structure needed to handle content with confidence and finesse. Each course delves into key aspects such as content strategy, quality control, and digital asset management—all delivered through engaging and well-paced modules. With a blend of theory and insightful examples, you’ll discover how to create cohesive content ecosystems that support business objectives and enhance audience engagement. Perfectly suited for professionals eager to refine their digital communication, this package offers learning that is both accessible and relevant, without the need for physical attendance or impractical requirements. These comprehensive courses are available in this Content Management - CPD Accredited 3 Courses Bundle Course 01: Content Management Course 02: Digital Product Management Course 03: Creative Writing **Special Offer: Free PDF and Hard Copy Certificates** Key Benefits Get instant PDF and Hard Copy certificate Fully online courses Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance Course Curriculum: Content Management Module 01: Introduction to Content Management Module 02: Content Management System (CMS) Module 03: Basics of Content Management Systems Module 04: Content Strategy Module 05: Content Marketing Module 06: Content Marketing Tools and Tactics Module 07: Content Marketing Strategy Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing each Content Management - CPD Accredited 3 Courses Bundle bundle course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Content Management - CPD Accredited 3 Courses Bundle course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 30 CPD hours / points Accredited by The CPD Quality Standards Who is this course for? The Content Management - CPD Accredited 3 Courses Bundle training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Content Management - CPD Accredited 3 Courses Bundle training.

Content Management - CPD Accredited 3 Courses Bundle
Delivered Online On Demand1 hour
£41

Legal Advisor Training - CPD Accredited 3 Courses Bundle

5.0(14)

By Training Express

Step into the world of legal advisory with a CPD-accredited training bundle designed to sharpen your knowledge and enhance your professional standing. This three-course package offers a thorough exploration of essential legal principles and advisory techniques, crafted for busy professionals aiming to deepen their understanding without needing to attend in-person sessions. Whether you’re looking to refine your grasp on contract law, regulatory frameworks, or client advisory skills, this bundle delivers expertly developed content that fits seamlessly into your schedule. Each course has been thoughtfully structured to provide clear, concise guidance, helping you confidently navigate the complexities of legal advising. Presented entirely online, this training respects your time and allows you to learn at your own pace, making it ideal for legal practitioners, consultants, and anyone involved in providing legal support. With a subtle touch of wit woven through professional insight, this bundle ensures your learning experience is both enlightening and engaging. These comprehensive courses are available in this Legal Advisor Training - CPD Accredited 3 Courses Bundle Course 01: Legal Advisor Training Course 02: International Law (Criminal Law, Commercial Law, Environmental Law & More!) Course 03: Property Law ** Special Offer: Free PDF and Hard Copy Certificates** Key Benefits Get instant PDF and Hard Copy certificate Fully online courses Developed by professionals Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance Course Curriculum: Module 01: Legal Advice and Advisor Module 02: Legal Terminology Module 03: Law and Legal System Module 04: Property Law Module 05: Wills, Probate, Estate Law Module 06: Contract & Business Law Module 07: Family Law Module 08: Criminal and Tort Law Module 09: Human Rights Module 10: Organising Work in MS Word Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing each Legal Advisor Training - CPD Accredited 3 Courses Bundle bundle course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Legal Advisor Training - CPD Accredited 3 Courses Bundle course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 30 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Legal Advisor Training - CPD Accredited 3 Courses Bundle training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Legal Advisor Training - CPD Accredited 3 Courses Bundle training.

Legal Advisor Training - CPD Accredited 3 Courses Bundle
Delivered Online On Demand1 hour
£41

Emotional Freedom Techniques (EFT) - CPD Accredited 3 Courses Bundle

5.0(14)

By Training Express

Discover a transformative journey through our Emotional Freedom Techniques (EFT) CPD Accredited 3 Courses Bundle — thoughtfully designed to enhance emotional well-being, mental clarity, and resilience. This trio of expertly crafted courses blends EFT’s innovative tapping method, the art of emotional intelligence paired with mindfulness and empathy, and the proven strategies of Cognitive Behavioural Therapy (CBT). Each course offers insightful, accessible knowledge, perfect for anyone looking to deepen their understanding of emotional health from the comfort of their own space. Whether you’re a coach, therapist, or simply curious about emotional self-care, this bundle delivers practical frameworks and thoughtful strategies to manage stress, recognise patterns, and foster emotional balance. Delivered fully online, these courses ensure flexibility without compromising on depth or quality. It’s an inviting opportunity to broaden your emotional toolkit with a dash of lightness and professionalism — no jargon, just solid, reliable methods that resonate. If emotional wellbeing were a recipe, consider this your secret sauce. These comprehensive courses are available in this EFT - CPD Accredited 3 Courses Bundle Course 01: EFT (Emotional Freedom Techniques) Course 02: Emotional Intelligence, Mindfulness and Empathy Training Course 03: Cognitive Behavioural Therapy (CBT) ** Special Offer: Free PDF and Hard Copy Certificates** Key Benefits Get instant PDF and Hard Copy certificate Fully online courses Developed by qualified professionals Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance Course Curriculum: Module 01: What Is EFT (Emotional Freedom Technique)? Module 02: EFT and Emotions, The Brain (EFT with the body) Module 03: EFT Procedure Module 04: Detailed Instructions of EFT Module 05: Applying EFT to Physical Issues Module 06: Treating Children with EFT Module 07: EFT That Can Improve/ Heal Life & Tips Module 08: Doing Business with EFT Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing each EFT - CPD Accredited 3 Courses Bundle bundle course. For each test, the pass mark will be set to 60%. CPD 30 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The EFT - CPD Accredited 3 Courses Bundle training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our EFT - CPD Accredited 3 Courses Bundle training.

Emotional Freedom Techniques (EFT) - CPD Accredited 3 Courses Bundle
Delivered Online On Demand1 hour
£41

Deaf Awareness - CPD Accredited 3 Courses Bundle

5.0(14)

By Training Express

Understanding the nuances of deaf awareness isn't just thoughtful—it’s essential in today’s increasingly connected world. This CPD Accredited 3 Courses Bundle delivers valuable insight into how we interact, communicate, and support those who are deaf or hard of hearing. Whether you're working in healthcare, education, customer service, or just someone with a knack for being a decent human being, this trio offers foundational knowledge that’s both enlightening and surprisingly absorbing. The bundle includes Deaf Awareness & Interaction Training, Audiology, and Speech and Language Therapy—each course thoughtfully designed to highlight the various dimensions of communication and hearing health. From understanding hearing loss and communication barriers to exploring the science of sound and speech, you'll gain a broader perspective on supporting inclusive dialogue. If you're aiming to be more attuned and less awkward when faced with communication challenges, this is a solid place to start. These comprehensive courses are available in this Deaf Awareness - CPD Accredited 3 Courses Bundle Course 01: Deaf Awareness & Interaction Training Course 02: Audiology Course 03: Speech and Language Therapy ** Special Offer: Free PDF and Hard Copy Certificates** Key Benefits Get instant PDF and Hard Copy certificate Fully online courses Developed by qualified professionals Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance Course Curriculum: Module 01: Introduction to Deaf Awareness Module 02: Deaf Community and Culture Module 03: Causes of Being Deaf and Auditory Innovations Module 04: Deaf Education Module 05: British Sign Language Module 06: BSL in Its Social Context Module 07: Social Interaction between Deaf and Hearing People Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing each Deaf Awareness - CPD Accredited 3 Courses Bundle bundle course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Deaf Awareness - CPD Accredited 3 Courses Bundle course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 30 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Deaf Awareness - CPD Accredited 3 Courses Bundle training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Deaf Awareness - CPD Accredited 3 Courses Bundle training.

Deaf Awareness - CPD Accredited 3 Courses Bundle
Delivered Online On Demand1 hour
£41

SwiftUI and Node.js Full Stack - Build Twitter - iOS 16

By Packt

Do you want to create outstanding apps with SwiftUI? Moreover, are you eager to build up your professional portfolio and show up in your next job interview with confidence? This complete iOS application development course is designed to teach you how to become an advanced multiplatform app developer using Apple's native user interface framework: SwiftUI.

SwiftUI and Node.js Full Stack - Build Twitter - iOS 16
Delivered Online On Demand21 hours 13 minutes
£59.99

Testing Ruby with RSpec: The Complete Guide

By Packt

In this course, we will master the syntax and structure of RSpec then learn to utilize test-driven development principles to design and implement clean test specs and reduce dependencies in the test suite by mocking objects with class and instance doubles. We will also explore the wide collection of RSpec matches available to test the code.

Testing Ruby with RSpec: The Complete Guide
Delivered Online On Demand7 hours 30 minutes
£41.99

Level 3 Diploma in Microsoft Excel 2016

4.3(43)

By John Academy

Description Microsoft Excel is a powerful and easy to use spreadsheet program that almost all businesses use on a day-to-day basis. It is used to store and retrieve numerical data and it is ideal for entering, calculating and analysing company data such as sales figures, sales taxes or commissions. This Level 3 Diploma in Microsoft Excel 2016 is a course which will help you learn the various features incorporated in the software. This course has been specially designed to cover everything from the basic concepts to the advanced levels. This course allows you to take advantage of the online aspect of training by learning at your own pace. As long as you have access to an eligible device, such as a laptop, or smartphone, and an internet connection, you can access this Level 3 Diploma in Microsoft Excel 2016 from anywhere, and anytime. Learning Outcomes: Familiarize the excel user interface, creating basic worksheet and using the help system How to create formulas, reuse them and insert functions in a worksheet Managing cells, columns and rows and ways to manipulate data Utilizing the 'Search and replace' data options and spell checking Modifying fonts, adding borders and colours to cells, using number formats, aligning cell contents and applying cell styles Define and refine page layouts for printing options Managing large workbooks through worksheet tab formatting and using different views Options for general customization, language, formula, proofing and saving Customizing Quick Access toolbar, ribbon, advanced and Trust Center options Utilize Excel's version control features and enabling add-ins Best ways to utilize Macro Recorder, how to edit and debug a macro, and setting up macro security Customizing the Quick Access toolbar and hotkeys Utilizing Macros to insert and format texts, sort and duplicate data, and generate reports Determine appropriate dialog box types to use Using variety of techniques to capture user input Managing worksheets using macros Creating user-defined functions and ways to automate SUM functions with macros Explore PowerPivot applications Importing data from different sources Creating linked tables Organizing and formatting tables Creating calculated columns PowerPivot data filtering and sorting Creating PivotTables and PivotCharts, and filtering data using slicers Presenting Visual data through visual outlets Utilizing DAX functions for manipulating PowerPivot data Extracting data from tables using functions, and working with time-dependent data Saving data in different formats and protecting reports Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Level 3 Diploma in Microsoft Excel 2016 is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Level 3 Diploma in Microsoft Excel 2016 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module : 1 Identify the Elements of the Excel Interface 00:30:00 Activity - Identify the Elements of the Excel Interface 00:05:00 Create a Basic Worksheet 01:00:00 Activity - Create a Basic Worksheet 00:05:00 Use the Help System 00:30:00 Activity - Use the Help System 00:05:00 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 Manipulate Data 00:30:00 Activity - Manipulate Data 00:05:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:30:00 Activity - Insert, Manipulate, and Delete Cells, Columns, and Rows 00:05:00 Search For and Replace Data 00:30:00 Activity - Search For and Replace Data 00:05:00 Spell Check a Worksheet 00:30:00 Activity - Spell Check a Worksheet 00:05:00 Modify Fonts 00:30:00 Activity - Modify Fonts 00:05:00 Add Borders and Colors to Cells 01:00:00 Activity - Add Borders and Colors to Cells 00:05:00 Apply Number Formats 00:30:00 Activity - Apply Number Formats 00:05:00 Align Cell Contents 00:30:00 Activity - Align Cell Contents 00:05:00 Apply Cell Styles 00:30:00 Activity - Apply Cell Styles 00:05:00 Define the Basic Page Layout for a Workbook 01:00:00 Activity - Define the Basic Page Layout for a Workbook 00:05:00 Refine the Page Layout and Apply Print Options 00:30:00 Activity - Refine the Page Layout and Apply Print Options 00:05:00 Format Worksheet Tabs 00:30:00 Activity - Format Worksheet Tabs 00:05:00 Manage Worksheets 00:30:00 Activity - Manage Worksheets 00:05:00 Manage the View of Worksheets and Workbooks 00:30:00 Activity - Manage the View of Worksheets and Workbooks 00:05:00 Customize General and Language Options 00:30:00 Activity - Customize General and Language Options 00:05:00 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Customize Proofing and Save Options 01:00:00 Activity - Customize Proofing and Save Options 00:05:00 Customize the Ribbon and Quick Access Toolbar 00:30:00 Activity - Customize the Ribbon and Quick Access Toolbar 00:05:00 Customize the Functionality of Excel by Enabling Add-Ins 00:30:00 Activity - Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:30:00 Activity - Customize Advanced and Trust Center Options 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 for Beginners 00:00:00 Module : 2 Apply Range Names 00:30:00 Use Specialized Functions 00:30:00 Use Text Functions 00:30:00 Use Logical Functions 00:30:00 Use Lookup Functions 00:30:00 Use Date Functions 00:30:00 Use Financial Functions 00:30:00 Create and Modify Tables 00:30:00 Sort and Filter Data 00:30:00 Use Subtotal and Database Functions to Calculate Data 00:30:00 Create Charts 00:30:00 Modify and Format Charts 00:30:00 Create a Trendline 00:30:00 Create Advanced Charts 00:30:00 Create a PivotTable 00:30:00 Filter Data by Using Slicers 00:30:00 Analyze Data with PivotCharts 00:30:00 Insert and Modify Graphic Objects 00:30:00 Layer and Group Graphic Objects 00:30:00 Incorporate SmartArt 00:30:00 Customize Workbooks 00:30:00 Manage Themes 00:30:00 Create and Use Templates 00:30:00 Protect Files 00:30:00 Preparing a Workbook for Multiple Audiences 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 Intermediate 00:00:00 Module : 3 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Activity-Integrate Excel Data with the Web 00:05:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Module : 4 Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Module : 5 Enable and Navigate 00:30:00 Import Data from Various Data Sources 01:00:00 Refresh Data from a Data Source 00:30:00 Create Linked Tables 00:30:00 Organize and Format Tables 00:30:00 Create Calculated Columns 00:30:00 Sort and Filter PowerPivot Data 00:30:00 Create and Manage Table Relationships 01:00:00 Create PivotTables 01:00:00 Create PivotCharts 00:30:00 Create Power Views 01:00:00 Filter Data Using Slicers 00:30:00 Present PivotTable Data Visually 01:00:00 Manipulate PowerPivot Data Using DAX Functions 01:00:00 Extract Data from Tables Using Functions 00:30:00 Save Reports in Different File Formats 01:00:00 Work with Time Dependent Data 00:30:00 Protect Reports 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 PowerPivot 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Level 3 Diploma in Microsoft Excel 2016
Delivered Online On Demand48 hours
£19