4295 Courses in Liverpool delivered Online

Course Overview The "Microsoft Excel Complete Course" is designed to equip learners with the essential skills to master Microsoft Excel, one of the most widely used tools in data analysis and business operations. This course covers a comprehensive range of topics, including Excel's new features, formula creation, data visualisation, and workbook management. It offers practical knowledge that will help learners work more efficiently, whether they are managing large datasets, analysing trends, or presenting information. By the end of this course, learners will be confident in using Excel for various business tasks, gaining a strong foundation for further professional development. Course Description This course covers all key aspects of Microsoft Excel, from the basics to advanced techniques. Learners will explore Excel’s new features in the 2019 version, as well as how to perform calculations, modify worksheets, and apply formatting. The course delves into functions, lists, and data analysis tools, including PivotTables and charts. Learners will also learn how to work with multiple worksheets and workbooks, use lookup functions, and automate workbook functionality. With a focus on essential Excel tools and techniques, learners will gain the ability to efficiently manage and analyse data for business or personal use. Course Modules Module 01: Microsoft Excel 2019 New Features Module 02: Getting Started with Microsoft Office Excel Module 03: Performing Calculations Module 04: Modifying a Worksheet Module 05: Formatting a Worksheet Module 06: Printing Workbooks Module 07: Managing Workbooks Module 08: Working with Functions Module 09: Working with Lists Module 10: Analyzing Data Module 11: Visualizing Data with Charts Module 12: Using PivotTables and PivotCharts Module 13: Working with Multiple Worksheets and Workbooks Module 14: Using Lookup Functions and Formula Auditing Module 15: Sharing and Protecting Workbooks Module 16: Automating Workbook Functionality Module 17: Creating Sparklines and Mapping Data Module 18: Forecasting Data (See full curriculum) Who is this course for? Individuals seeking to improve their data management and analysis skills. Professionals aiming to enhance their productivity in Excel for business applications. Beginners with an interest in data analysis or office administration. Anyone looking to build a strong foundation in Excel for career advancement. Career Path Data Analyst Financial Analyst Office Administrator Project Manager Business Analyst Operations Manager Administrative Assistant HR Specialist

Course Overview This comprehensive Data Analytics course provides an in-depth exploration of data analysis, covering the essential principles and techniques used to extract valuable insights from data. Learners will engage with core concepts, such as data mining, statistical analysis, and visualisation, enabling them to make informed decisions and drive business outcomes. By the end of the course, participants will have the skills to analyse and interpret data, apply analytical tools effectively, and present their findings clearly. This course equips learners with the necessary tools to understand and leverage data in various professional settings, adding significant value to their career prospects. Course Description The Data Analytics course covers a wide range of topics, including the fundamentals of data analysis, statistical methods, and various data visualisation techniques. Learners will explore essential tools such as Excel and specialised software, while gaining a deep understanding of how to collect, store, and process data effectively. Emphasis is placed on developing the analytical mindset required to interpret data accurately and draw actionable insights. This course is designed to ensure learners can confidently navigate the world of data analytics and apply their knowledge in diverse industries, enhancing their problem-solving and decision-making abilities. Course Modules Module 01: Introduction to the World of Data Module 02: Basics of Data Analytics Module 03: Statistics for Data Analytics Module 04: Actions Taken in the Data Analysis Process Module 05: Gathering the Right Information Module 06: Storing Data Module 07: Data Mining Module 08: Excel for Data Analytics Module 09: Tools for Data Analytics Module 10: Data-Analytic Thinking Module 11: Data Visualisation That Clearly Describes Insights Module 12: Data Visualisation Tools (See full curriculum) Who is this course for? Individuals seeking to enhance their analytical skills for data-driven decision-making. Professionals aiming to transition into data analytics or enhance their data-related roles. Beginners with an interest in understanding data and its applications across industries. Business professionals seeking to leverage data for strategic growth. Career Path Data Analyst Business Intelligence Analyst Data Scientist Market Research Analyst Operations Analyst Financial Analyst Business Analyst Data Visualisation Specialist

Course Overview: This course on Decision Making and Critical Thinking offers a comprehensive exploration of how to develop and apply critical thinking skills in both personal and professional contexts. Learners will gain the ability to analyse complex situations, make well-informed decisions, and approach problems with a logical mindset. By the end of this course, participants will have a clear understanding of critical thinking principles, decision-making processes, and how to apply these techniques effectively in various scenarios. The course is designed to enhance problem-solving capabilities and promote more thoughtful, reasoned approaches to decision-making. Course Description: The Decision Making and Critical Thinking course covers a wide range of essential topics, including understanding the key components of critical thinking, identifying and overcoming common barriers, and exploring decision-making strategies. Learners will delve into how to evaluate claims, the benefits of critical thinking, and the practical applications of these skills in real-world situations. With engaging lessons and interactive content, participants will develop the cognitive tools needed to think critically, solve problems, and make decisions that are both informed and objective. Key areas of focus include problem-solving techniques, critical thinking strategies, and the structured decision-making process. Upon completion, learners will be equipped to make more effective decisions and analyse situations with a critical mindset. Course Modules: Module 01: Introduction to Critical Thinking Module 02: Critical Thinking and the Judgment of Claims Module 03: Benefits and Barriers of Critical Thinking Module 04: Importance of Critical Thinking Module 05: Recognising a Critical Thinker Module 06: What Are the Critical Thinking Steps? Module 07: Critical Thinking Strategies Module 08: Problem-Solving Through Critical Thinking Module 09: Decision Making with Critical Thinking (See full curriculum) Who is this course for? Individuals seeking to improve their decision-making skills. Professionals aiming to enhance their critical thinking abilities. Beginners with an interest in logic, problem-solving, and decision-making. Anyone looking to develop a more analytical and structured approach to challenges. Career Path: Analyst roles in business, marketing, and consulting. Leadership positions requiring strategic decision-making. Project management and operations management positions. Careers in education, research, or policy analysis. Roles in human resources, where critical thinking is key to recruitment and development.

Course Overview The Criminal Psychology and Profiling course offers an insightful exploration into the psychological underpinnings of criminal behaviour and the art of criminal profiling. Learners will develop a strong foundation in understanding the minds of offenders, the impact of mental health disorders, and the various methods used to classify and investigate crime. Through studying forensic science, behavioural analysis, and victimology, participants will be equipped with the theoretical knowledge and analytical techniques needed to interpret criminal behaviour. Upon completion, learners will possess a deeper appreciation of how criminal psychology informs investigative strategies, legal processes, and crime prevention efforts, positioning them for further study or professional growth in this fascinating field. Course Description This course delves into the intricate relationship between psychology and criminal behaviour, offering a comprehensive study of mental disorders, forensic science applications, and profiling methodologies. Learners will examine the classification of crime, the phases of offender profiling, and the importance of victimology within investigations. The course also provides an overview of the criminal justice system in England and Wales, ensuring a contextual understanding of the legal framework surrounding criminal cases. Designed to strengthen analytical and critical thinking abilities, this programme encourages learners to apply logical reasoning and metacognitive strategies to criminal profiling. By the end of the course, participants will have cultivated a well-rounded skill set valuable for careers in criminal psychology, forensic science, and investigative fields. Course Modules Module 01: Understanding Criminal Psychology Module 02: Influence of Mental Disorders Module 03: Classification of Crime Module 04: Forensic Science Module 05: Criminal Profiling: Science, Logic and Metacognition Module 06: Phases of Profiling Module 07: Offender Profiling: Pragmatic Solution and Behavioural Investigative Advice Module 08: Victimology Module 09: The Criminal Justice System in England and Wales (See full curriculum) Who is this course for? Individuals seeking to understand criminal behaviour and profiling methods. Professionals aiming to enhance their expertise in psychology, criminology, or investigative roles. Beginners with an interest in forensic psychology, crime analysis, or criminal justice. Anyone aspiring to explore a career pathway in criminal psychology, forensic science, or legal support services. Career Path Criminal Psychologist Forensic Psychologist Behavioural Analyst Crime Analyst Offender Profiler Criminal Investigator Legal Assistant within criminal law practices Victim Support Worker

Course Overview Learn all the essential skills to become an expert in Makeup Artistry. From this comprehensive Makeup Artistry Course course, you will be able to understand the principles of Makeup Artistry. In the step-by-step training process, you will acquire practical skills along with theoretical knowledge. The Qualified professionals will assist you throughout this learning process. This Makeup Artistry Course is structured to ensure you have all the adequate skills to secure a position in this competitive industry. You will achieve the confidence and competency to bear all the responsibilities of this profession. The course will add all the right credentials to your resume and increase your employability in this growing industry. Learning Outcomes Learn how to organise professional makeup appointments and prepare for them Discover how to perform skin preparation and foundation matching Know how to highlight and contour any facial type or skin tone Gain knowledge on how to apply eye makeup for any situation or event Explore the differences between day makeup and evening makeup Understand how to bring different cosmetics together for a stunning look Who is this course for? Anyone who is now employed in this field or who aspires to be one should take this course. Your knowledge will grow through taking this course, which will also strengthen your resume. To demonstrate your newly gained knowledge, develop crucial abilities and receive a professional credential. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Makeup Artistry Course course is intended to assist you in obtaining the dream job or maybe the promotion you've always desired. With the assistance and direction of our Makeup Artistry Course course, learn the vital abilities and knowledge you require to succeed in your life. Section 01: Introduction Promo 00:01:00 Introduction: Makeup Artistry from Basic to Masterclass 00:02:00 Section 02: Sanitation & Hygiene Personal Hygiene 00:01:00 Brush Hygiene 00:02:00 Product Contamination 00:01:00 Contraindications & how to deal with them 00:01:00 Product Expiry 00:01:00 Make Up Kit Hygiene 00:01:00 Sum Up 00:01:00 Section 03: Brushes Introduction & Application Intro & Must- Have Brushes for your Make Up Starter Kit 00:08:00 The Different Kind of Eye Blending Brushes 00:03:00 The Different Kind of Foundation Brushes 00:02:00 Section 04: Make Up Appointment & Peparations How to prepare for a professional & organized Make Up appointment 00:04:00 Section 05: Color Theory & Color Correcting Intro: Color Theory in Make Up Artistry 00:02:00 Understanding the Pocket Color Wheel 00:01:00 Warm and Cool based Colors & the meaning of Complementary Colors 00:02:00 Why do we Color Correct? 00:01:00 Correcting Dark Eye Circles on different Skin Tones 00:02:00 Correcting other Surface Tones : Redness & Dullness 00:02:00 Section 06: Skin prep & Primers Begin with the Skin 00:03:00 Intro : What are Primers ? 00:01:00 An Overview of the main different Primers 00:01:00 Silicon Based Primers : A Good or Bad Choice for the skin? 00:01:00 Alternative to a Primer? 00:01:00 How to Prepare & Prime common skintypes : Dry/ Dehydrated & Combinational/Oily 00:03:00 Section 07: Foundation Matching The first Step before Foundation Matching 00:02:00 Introducing the Undertones 00:01:00 What is a Surface Tone? 00:01:00 How to determine the Undertone visually 00:01:00 Foundation Matching: Striping Method 00:03:00 Section 08: Foundation: Different Coverages, Textures & Finishes The Different Foundation Coverages 00:05:00 Section 09: Foundation Application How to apply Foundation correctly 00:05:00 Section 10: Concealer Application Concealer's Purpose & Tools to apply 00:02:00 The Correct Concealer Application 00:02:00 The Term : 'Baking' in Make Up Artistry 00:01:00 Section 11: Highlight & Contour Intro : What is the Purpose of Highlighting & Contouring ? 00:01:00 The Steps you need to take & The different Face Shapes 00:01:00 Highlight & Contour EVERY Face Shape easily 00:02:00 Products : Which Texture & Shade ? 00:02:00 Tools 00:01:00 Practice Time : Master the Highlight & Contour Game! 00:04:00 Section 12: Blush Application Blush : A pop of Color for a more healthy looking Face 00:03:00 Section 13: Eye Make Up: Everyday Eye Makeup Look The Different Parts of the Eyes & How to apply Eye Products on them 00:02:00 Tools for perfect Application + Shade & Texture of Eyeshadows 00:02:00 Practice Time: Flawless Eye Make Up Application 00:06:00 Section 14: Eyeliner Application Intro Eyeliner : What to avoid ( Do's & Dont's) 00:04:00 An Overview of the different Eyeliner Products 00:02:00 The Different Eyeshapes 00:01:00 Practice Time: Basic & Winged Eyeliner Application 00:03:00 Recommendations & Tips 00:02:00 Section 15: Mascara Application The correct Mascara Application 00:03:00 Section 16: False Lashes How to apply False Lashes correctly 00:04:00 Section 17: Eyebrow Application Determining the Shape of the Eyebrows 00:01:00 Different Eyebrow Products, different Applications 00:01:00 Practice Time: Eyebrow Application with Brow Pomade 00:03:00 Practice Time 2: Eyebrow Application with a Brow Pencil 00:03:00 Section 18: Lip Product Application Intro : Lip Product Application & How to Prep & Prime the Lips 00:02:00 Which Lip Shade & Texture to Choose 00:01:00 Practice Time : Apply the Perfect Red Lips + Strobe 00:04:00 Section 19: Clients Consultation & How to Manage your Business Finding out the suitable Make Up look for your Client 00:04:00 The Definition of a 'Natural Look' to you and your Clients 00:02:00 Analyzing the Clients Facial Features 00:02:00 Build a good Clientelle 00:02:00 Create your own Price-List 00:02:00 Manage your Bookings 00:01:00 Section 20: Apply your Skills & Level Up: Welcome to the Master Make Up Class Section Consultation & Meeting with your Client 00:06:00 Foundation Matching: on Neutral Light Skin Undertone 00:01:00 Skin Prep & Prime on a dry Skintype 00:01:00 Halo Eye Make Up Look on Round, heavy Lidded Eyeshapes 00:09:00 Correct Light Blemishes, Apply Foundation , Highlight & Contour Long Face Shape 00:07:00 Applying Bronzer & Blush 00:02:00 Creating the Perfect 3D Glow Effect: For lifted Cheekbones area 00:02:00 Shaping & Filling in Eyebrows with Gaps 00:01:00 Creating Nude Brown Ombre Lips & the Final Results 00:03:00 Section 21: Day to Evening Make Up Look on Dark Complexions Intro Course Content: Focus of this Lesson L21 00:01:00 Foundation Matching on dark Complexions: Lets find the Correct shade (Mixing) 00:01:00 Skin Prep & Prime for Combinational Skin (Oily/ Dehydrated) 00:01:00 Day Eye Make Up Look on Small Upturned Eye Shape 00:03:00 Color Correcting Hyperpigmentation/ Spots on dark Skin Colors 00:01:00 Highlight & Contour: Oblong Face Shape with short Chin part 00:02:00 Apply Warmth, Color & Glow on dark Complexions 00:01:00 Make Big Lips appear Smaller & Final Results of Day Make Up Look 00:01:00 Transform Day to Night: Nightout Eye Make Up Look 00:02:00 Touch Ups: Another method to make Lips appear smaller & Final Results 00:03:00 Section 22: Glamorous Make Up Look on Asian Model Intro Course Content: Focus of this Lesson L22 00:01:00 Monolid & Close-Set Eyeshapes : How to Enhance them with Eyeshadow 00:03:00 Monolid Eyeshapes : Apply Eyeliner 00:07:00 Triangular Face Shape: Soft Highlight & Contour 00:02:00 Asian Nose: Creating a Prominent Nose Bridge 00:02:00 Touch Up & Final Results 00:02:00 Section 23: Golden Brown Half Cut Crease Eye Make Up Look on a fair Model Intro Course Content: Focus of this Lesson L23 00:01:00 Downturned Eyeshapes : Create bright & flattering Eyes 00:05:00 Color Correct Redness & Cover large-scale Freckles 00:01:00 Round Face Shape: Highlight & Contour 00:03:00 Filling in Brows with Brow Pomade & applying Cherry Red Lipstick & Final Results 00:02:00 Section 24: Makeup on South Asian Model Intro Course Content: Focus of this Lesson L24 00:01:00 Foundation Mixing & Matching on Medium Dark Skin Colors 00:01:00 Skin Prep & Prime: Dry Skin 00:02:00 Round Upturned Eyeshapes Makeup Application 00:07:00 Round Upturned Eyeshapes : Apply Eyeliner & Lashes 00:03:00 Color Correct on Medium dark Skin Tones 00:01:00 Square Face Shape: Highlight & Contour 00:03:00 How to Contour a Wide Nose 00:01:00 Apply Bronzer, Blush & Glow on medium dark Skin Colors 00:02:00 How to Correct Wide-apart & Thin Eyebrow Shapes 00:03:00 Perfect Pumpkin Nude Shade for Medium dark Skin Tones 00:01:00 Setting Spray & Final Results 00:01:00 Section 25: Day to Evening Make Up on South European Model with Tanned Skin Intro Course Content : Focus of this Lesson L25 00:01:00 Foundation Matching on Neutral Warm (Tanned) Skin Tone 00:01:00 Skin Prep & Prime on Combinational/Oily Skintype 00:02:00 Soft Pink Eye Make Up Look for Daytime 00:05:00 Color Correct Dark Circles around the Eyes 00:03:00 Rectangle Face Shape: Highlight & Contour 00:02:00 How to apply Bushy Brows & Final Results of Daytime Look 00:03:00 The Night Out Eye Make Up Transformation 00:05:00 Final Touch Ups & Results for the Evening Make Up Look 00:02:00 Section 26: Day to Evening Make Up for Wearer of Glasses Intro Course Content: Focus of this Lesson L26 00:01:00 Slightly Hooded Eyeshapes : How to apply Eyeliner correctly 00:02:00 Skin Prep & Prime: Very Dry Skintype 00:01:00 Brighten Up & Enhance the Eyes of Wearer of Glasses 00:05:00 How to Prevent Red Marks That Glasses Leave Behind & giving back Structure 00:04:00 Creating a dewy Look, Applying Brow Mascara & Lip Gloss & Final Results Day 00:03:00 Evening Make Up: Sparkly, Glittery Eye Make Up Look & smudgy Burgundy Eyeliner 00:02:00 Section 27: Smokey Eyeliner with Bordeaux & Rose Gold Eyeshadow Shades Intro Course Content: Focus of this Lesson L27 00:01:00 Skin Prep & Prime on Acne Prone/Sensitive Skin 00:01:00 Deep-Set Eyeshapes: How to enhance them beautifully 00:07:00 Color Correcting & Evening out the Skin 00:02:00 Inverted Triangle Face Shape: Highlight & Contour 00:03:00 Applying Depth, Pop of Colour & Glow on problematic Skin 00:01:00 Tatooed Eyebrows: How to make the Eyebrow shade looking freshly pigmented again 00:01:00 Apply Matte Warm Pink Nude Lipstick 00:01:00 Set the Make Up & Final Results 00:01:00 Section 28: NEW UPDATE: Classic Smokey Eye Makeup Look Skin Prep & Prime on Combinational T-Zone to dry Cheek area 00:03:00 Application of Smokey Eye Makeup Look 00:21:00 Highlight & Contour Rectangle Face Shape 00:03:00 Last Touch Ups to Complete The Makeup: Setting, Bronzer, Blush,Highlighter etc. 00:07:00 Section 29: NEW UPDATE Roségold Eye Makeup Look Intro & Skincare Products Recommendations for Acne Prone+ Sensitive Skin Types 00:02:00 Roségold Eye Makeup Application 00:14:00 Individual Lashes Application 00:04:00 Color Correcting & Foundation Application on Acne Prone Skin 00:08:00 Slim Oval Face Shape : Contouring & Highlight 00:05:00 Eyebrow Application on Natural, full and well-shaped Brows 00:01:00 Overlining Lips naturally 00:02:00 Results & Ending 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office skills are in high demand across industries, and proficiency in Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft Office 365 opens up numerous career opportunities. In the UK, administrative roles, data analysis positions, office management, project coordination, and marketing support roles are just a few examples of job prospects. With average salaries ranging from £20,000 to £45,000 per year, individuals with comprehensive Microsoft Office skills can secure stable employment and contribute to the success of various organisations. Enrol in the Ultimate Microsoft Office Skills Training course today and equip yourself with the knowledge and expertise needed to thrive in the ever-evolving workplace. You Will Learn Following Things: Develop a solid foundation in Microsoft Office applications, including Word, Excel, PowerPoint, and Office 365. Acquire essential skills to efficiently navigate and manipulate data in Microsoft Excel, such as organising, sorting, filtering, and writing formulas. Gain proficiency in creating professional presentations in Microsoft PowerPoint, utilising features like multimedia, transitions, animations, and smart graphics. Master the art of document creation and formatting in Microsoft Word, including tables, styles, page layouts, envelopes, labels, and mail merges. Understand advanced features like pivot tables, charts, and data analysis tools in Microsoft Excel, enabling effective data visualisation and decision-making. This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. Enrol today and complete the course to achieve a certificate that can change your career forever. Process of Evaluation After studying the course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This course is designed for individuals who want to enhance their Microsoft Office skills for personal or skilled purposes. Whether you are a student, an experienced entrepreneur, or anyone who regularly works with Microsoft Word, Excel, PowerPoint, and Office 365, this Microsoft Office skills course will provide you with a solid foundation and advanced techniques to maximise your productivity and efficiency. No prior experience is required, making it suitable for beginners and intermediate users looking to expand their knowledge and capabilities in the Microsoft Office suite. On the other hand, anyone who wants to establish their career as: like MS Office User Microsoft Office 2019 User Touch Typing Worker Audio Typist Can take this Ultimate Microsoft Office Skills Training (Word, Excel, PowerPoint, and 365) course. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career path Administrative Assistant - £20K to £30K/year Data Analyst - £25K to £45K/year Office Manager - £25K to £40K/year Project Coordinator - £25K to £35K/year Marketing Assistant - £20K to £30K/year Course Curriculum Section 01: Getting Started Introduction 00:03:00 Getting started on Windows, macOS, and Linux 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: Excel 2021: Basics Excel Overview 00:05:00 Start Excel Spreadsheet 00:04:00 Enter Text and Numbers 00:07:00 Relative References 00:04:00 Working with ranges 00:07:00 Save and Save as Actions 00:08:00 File Extensions, Share, Export, and Publish files 00:06:00 Section 03: Excel 2021: Rows, Columns, and Cells Adding Rows and Columns 00:03:00 Modifying Rows and Column lengths 00:05:00 Section 04: Excel 2021: Data Handling Copy, Cut, and Paste 00:07:00 Copying Formulas 00:03:00 Section 05: Excel 2021: Page Setting Up and Print Page setup options 00:06:00 Fit to print on One Page 00:03:00 Print Workbooks 00:03:00 Section 06: Excel 2021: Sorting and Filtering Sorting Data Ascending Order 00:04:00 Sorting Data Descending Order 00:02:00 Filter Data 00:04:00 Section 07: Excel 2021: Writing Formulas Creating Basic Formulas 00:06:00 Datetime Formulas 00:06:00 Mathematical formulas phase1 00:20:00 Mathematical formulas phase2 00:12:00 Section 08: Excel 2021: Advanced Formulas VLOOKUP formula 00:12:00 HLOOKUP formula 00:04:00 Section 09: Excel 2021: XLOOKUP only for 2021 and Office 365 XLOOKUP 00:08:00 Handling #NA and Approximates match in XLOOKUP 00:11:00 Section 10: Excel 2021: Data and Tools Split Text into columns 00:07:00 Flash Fill 00:07:00 Data Validation 00:07:00 Remove Duplicates 00:08:00 Import Data from Text files 00:06:00 Import Data from .CSV files 00:03:00 Section 11: Excel 2021: Formatting data and tables Formatting Font 00:04:00 Formatting Alignment 00:06:00 Formatting Numbers 00:05:00 Formatting Date 00:03:00 Formatting Tables 00:05:00 Section 12: Excel 2021: Pivot Tables Pivot Tables 00:07:00 Pivot Charts 00:02:00 Section 13: Excel 2021: Charts Excel Charts - Categories 00:03:00 Elements of a chart 00:04:00 Creating Charts 00:02:00 Column or Bar charts 00:04:00 Formatting charts 00:04:00 Line Charts 00:02:00 Pie and Doughnut charts 00:04:00 Section 14: PowerPoint 2021: Course Introduction Overview 00:04:00 Start PowerPoint Presentation 00:05:00 Screen setting and Views 00:05:00 Section 15: PowerPoint 2021: Basics Presentation Tips and Guidelines 00:06:00 Creating a New Presentation 00:04:00 Working with Slides 00:04:00 Save a Presentation 00:04:00 Print Slides 00:03:00 Section 16: PowerPoint 2021: Text and Bullet Options Formatting Text 00:05:00 Slide Text Alignments 00:03:00 Multi-Column Text Alignments 00:02:00 Adding Bullets and Numbered List Items 00:03:00 Section 17: PowerPoint 2021: Adding Graphic Assets Insert Shapes 00:03:00 Insert Icons 00:03:00 Insert Graphics 00:04:00 Add 3D Models 00:03:00 Insert Pictures 00:03:00 Section 18: PowerPoint 2021: Picture Formatting Picture Options 00:04:00 Picture Cropping 00:03:00 Applying Built-in Picture Styles 00:04:00 Section 19: PowerPoint 2021: SmartArt Graphics Add SmartArt Graphic 00:03:00 Modifying SmartArt 00:03:00 Creating a Target Chart using SmartArt 00:03:00 Section 20: PowerPoint 2021: Working with Tables Create a Table on Slide 00:04:00 Formatting Tables 00:02:00 Inserting Tables 00:02:00 Table Layouts 00:01:00 Section 21: PowerPoint 2021: Working with Charts Add a Chart 00:02:00 Formatting Charts 00:02:00 Insert Chart from Microsoft Excel 00:03:00 Section 22: PowerPoint 2021: Adding Multimedia Adding Video to a Presentation 00:03:00 Adding Audio to a Presentation 00:02:00 Screen Recording and Adding 00:02:00 Section 23: PowerPoint 2021: Working with Transition Applying Transitions to Presentation 00:04:00 Section 24: PowerPoint 2021: Animation Object Animation 00:03:00 Effect Options 00:02:00 Advanced Animation 00:02:00 Triggers to control animation 00:02:00 Section 25: PowerPoint 2021: Slideshow Effects Onscreen Presentation 00:02:00 Hiding Slides 00:02:00 Changing Order of Slides 00:02:00 Copying Slides 00:02:00 Section 26: Word 2021: Introduction Overview of MS Word 00:04:00 Start MS Word 2021 00:05:00 Section 27: Word 2021: Basics Create a new blank document 00:04:00 Creating a paragraph text 00:05:00 Non-printing characters 00:03:00 Save a document 00:03:00 Open a document 00:01:00 Find and replace 00:04:00 Section 28: Word 2021: Word Formatting AutoCorrect options 00:03:00 Formatting text 00:04:00 Copy cut and paste 00:04:00 Character formatting 00:02:00 Format painter 00:04:00 Work with numbers 00:02:00 Add bullets 00:03:00 Outline creation 00:04:00 Section 29: Word 2021: Tables Creating a table 00:03:00 Adding rows and columns to a table 00:02:00 Formatting table data 00:02:00 Borders and shading 00:02:00 Sorting in a table 00:04:00 Draw a table 00:04:00 Convert text to table 00:03:00 Convert table to text 00:02:00 Insert a spreadsheet 00:02:00 Quick tables - readily available formats 00:02:00 Section 30: Word 2021: Styles Working with styles 00:02:00 Creating styles 00:02:00 Clear formatting 00:01:00 Section 31: Word 2021: Page Layout Margins 00:02:00 Orientation 00:01:00 Page size setting 00:01:00 Adding columns 00:03:00 Page break - section break 00:02:00 Adding watermark 00:03:00 Headers and footers 00:03:00 Section 32: Word 2021: Envelops and Lables Create envelops 00:02:00 Creating labels 00:02:00 Section 33: Word 2021: Mail Merges Creating a mail merge document 00:03:00 Section 34: Word 2021: Review and Printing Thesaurus and spell check 00:01:00 Word count 00:01:00 Speech - read aloud 00:01:00 Language - translate 00:01:00 Tracking 00:01:00

Child Psychology: Child Psychology Course Online Embark on an enriching journey into the world of Child Psychology. Our Child Psychology course is a comprehensive exploration of Child Psychology theories, Child Psychology methodologies, and practical Child Psychology applications. Dive deep into Child Psychology and acquire essential Child Psychology knowledge. Elevate your expertise with our Child Psychology course today! Our Child Psychology: Child Psychology Course introduces the major issues in infancy, childhood, and adolescence and enables you to understand psychological problems in developmental stages. This Child Psychology: Child Psychology Course teaches students the key areas required for a child's psychological development. Furthermore, the Child Psychology: Child Psychology Course provides in-depth knowledge to understand the impacts of privation, deprivation, separation, and grief on children. This Child Psychology: Child Psychology Course also describes the personality development process in detail, explaining how a child's upbringing influences its personality. Main Course: Level 4 Diploma in Child Psychology Free Courses included with Child Psychology: Child Psychology course. Course 01: Level 4 Child Care and Development Course 02: Level 4 Diploma in Child Counselling Course 03: Level 3 Award in Childcare and Education [ Note: Free PDF certificate as soon as completing the Child Psychology: Child Psychology course] Child Psychology: Child Psychology Course Online This Child Psychology: Child Psychology Course consists of 09 modules. Assessment Method of Child Psychology: Child Psychology Course After completing Child Psychology: Child Psychology Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Child Psychology: Child Psychology Course After completing the Child Psychology: Child Psychology Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Child Psychology: Child Psychology Course Online The Child Psychology: Child Psychology Course is ideal for students who want to understand child psychology thoroughly. Requirements Child Psychology: Child Psychology Course Online To enrol in this Child Psychology: Child Psychology Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Child Psychology: Child Psychology Course. Be energetic and self-motivated to complete our Child Psychology: Child Psychology Course. Basic computer Skill is required to complete our Child Psychology: Child Psychology Course. If you want to enrol in our Child Psychology: Child Psychology Course, you must be at least 15 years old.

Duration 5 Days 30 CPD hours This course is intended for Experienced system administrators and network administrators Overview By the end of the course, you should be able to meet the following objectives: Describe the NSX Advanced Load Balancer architecture Describe the NSX Advanced Load Balancer components and main functions Explain the NSX Advanced Load Balancer key features and benefits Deploy and configure the NSX Advanced Load Balancer infrastructure within private or public clouds using Write and No Access Cloud Connectors Explain, deploy, and configure Service Engines Explain and configure local load balancing constructors such as virtual services, pools, health monitors, and related components Understand and modify application behavior through profiles, policies, and DataScripts Configure advanced services such as global server load balancing Describe how to use NSX Advanced Load Balancer REST API interfaces and related automation capabilities Describe and configure NSX Advanced Load Balancer application and infrastructure monitoring Gather relevant information and perform basic troubleshooting of applications that use built-in NSX Advanced Load Balancer tooling This five-day, fast-paced course provides comprehensive training to install, configure, and manage a VMware NSX© Advanced Load Balancer? (Avi Networks) solution. This course covers key NSX Advanced Load Balancer (Avi Networks) features and functionality offered in the NSX Advanced Load Balancer 20.x release. Features include the overall infrastructure, virtual services and application components, global server load balancing, various cloud connectors, application troubleshooting, and solution monitoring. Hands-on labs provide access to a software-defined data center environment to reinforce the skills and concepts presented in the course. Course Introduction Introduction and course logistics Course objectives Introduction to NSX Advanced Load Balancer Introduce NSX Advanced Load Balancer Discuss NSX Advanced Load Balancer use cases and benefits Explain NSX Advanced Load Balancer architecture and components Explain the management, control, data, and consumption planes and their respective functions Virtual Services Configuration Concepts Explain Virtual Service components Explain Virtual Service types Explain and configure basic Virtual Service components such as Application Profiles, Network Profiles Profiles and Policies Explain and deep dive on Advanced Virtual Service creation Explain and deep dive on Application Profiles and Types such as L4, DNS, Syslog, and HTTP Explain and configure advanced application HTTP Profile options Deep dive on Network Profiles and Types Explain and configure SSL Profiles and Certificates Explain and Configure HTTP and DNS policies Pools Configuration Concepts Explain and deep dive on Pools configuration options Describe available Load Balancing algorithms Explain multiple Health Monitor types Explain multiple Persistence Profiles Explain and configure Pool Groups Modifying Application Behavior Design and apply application solutions leveraging application profiles Design and apply application solutions leveraging Network and HTTP Policies and DataScripts Explain DataScript fundamentals Explain and leverage NSX Advanced Load Balancer analytics to understand application behavior Describe and configure Client SSL Certificate Validation Describe and configure Virtual Service DDoS, Rate Limiting, and Throttling capabilities Modify Network Profiles properties such as TCP connection properties Design and apply application solutions leveraging Persistence Profiles NSX Advanced Load Balancer Infrastructure Architecture Deep dive on the management, control, data, and consumption planes and functions Describe Control Plane Clustering and High Availability Describe Controller Process Sharding Describe Controller Sizing Describe Service Engine CPU and NIC Architecture Explain Tenants Deep dive and configure properties of Service Engine Groups Explain Service Engine Group High Availability Modes Describe and configure Active/Standby High Availability Mode Describe and configure Elastic HA High Availability Mode (Active/Active, N+M) Explain Service Engine Failure Detection and Self-Healing Describe Service Engine as a Router Deep dive on Virtual Service scale out options, such as Layer 2 (Native), Layer 3 (BGP), and DNS-based Introduction to Cloud Connector Introduce Cloud Connectors Review Cloud Connector integration modes Introduce Cloud Connector types Install, Configure and Manage NSX Advanced Load Balancer in No-Access Cloud Explain No Access Cloud concepts Configure No Access Cloud integration Explain and Configure Linux Server Cloud Describe the Advanced Configuration options available in Bare-Metal (Linux Server Cloud) Install, Configure and Manage NSX Advanced Load Balancer in VMware Environment: Cloud Configuration Introduce VMware integration options Explain and configure VMware No Access Cloud Connector Explain and configure VMware Write Access Cloud Connector Describe VMware Write with NSX-V Access Cloud Connector Describe VMware NSX-T integration AWS Cloud Configuration Describe NSX Advanced Load Balancer Public Cloud integrations Explain and demonstrate AWS Public Cloud Integration DNS Foundations Review, discuss, and explain DNS fundamentals Describe NSX Advanced Load Balancer DNS and IPAM providers Global Server Load Balancing Introduce Global Server Load Balancing Concepts and Benefits Explain and configure NSX Advanced Load Balancer infrastructure Explain and configure DNS Virtual Service components Explain and configure GSLB Service Engine Group Describe and configure GSLB Sites Explain and configure basic GSLB Services to include pools and health monitors Describe GSLB Service Load Balancing algorithms Explain and configure Data and Control Plane-based Health Monitors Describe GSLB Health Monitor Proxy NSX Advanced Load Balancer: Troubleshooting Introduce Infrastructure and Application Troubleshooting Concepts Describe Control Plane and Data Plane-based Troubleshooting Explain Application Analytics and Logs Describe client logs analysis Explain Headers troubleshooting and Packet Capture mechanism Leverage CLI for detailed data plane troubleshooting Explain Service Engine Logs Explain Health Monitors troubleshooting Explain BGP session troubleshooting Describe Control Plane Troubleshooting, Clustering, and Cloud Connector issues Events and Alerts Describe NSX Advanced Load Balancer Events Describe and configure NSX Advanced Load Balancer Alerts Describe NSX Advanced Load Balancer monitoring capabilities, leveraging SNMP, Syslog, and Email Introduction to NSX Advanced Load Balancer Rest API Introduce NSX Advanced Load Balancer REST API interface Describe REST API Object Schema Explain and interact with REST API interface, leveraging browser and command line utility Explain Swagger-based API documentation Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware NSX Advanced Load Balancer: Install, Configure, Manage [V20.x] training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the VMware NSX Advanced Load Balancer: Install, Configure, Manage [V20.x] course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours This course is intended for This introductory-level course is for experienced DBAs who will be working with MongoDB. In order to gain the most from this course you should have: Prior practical experience in Database Administration Experience working with Linux and be comfortable working with command line Overview This skills-focused course is approximately 50% hands-on. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment, guided by our expert team, attendees will explore: The MongoDB Basic Architecture and Installation MongoDB administration User Management MongoDB security Indexes Backup & Recovery High Availability / Replication Diagnostics & Troubleshooting MongoDB is fast becoming the database of choice for big data applications, being one of the most popular and widely implemented NoSQL databases. Its scalability, robustness, and flexibility have made it extremely popular among business enterprises who use it to implement a variety of activities including social communications, analytics, content management, archiving and other activities. This has led to an increased demand for MongoDB administrators who have the skills to handle cross functional duties. Geared for experienced DBAs, MongoDB for DBAs is a three-day hands-on course that explores the concepts, architecture and pitfalls of managing a MongoDB installation. This course is targeted to the DBA who is familiar with the concepts and tasks of working with a Relational database and is not responsible for a NoSQL MongoDB database. You will learn the critical aspects of MongoDB and use it to solve data management challenges. You will learn to manage MongoDB effectively by gaining expertise in MongoDB administration tools, syntax, MongoDB installations, configurations, security, troubleshooting, backup, scaling and many other features. The focus of this course is on practical skills and applying the DBA existing database knowledge to a MongoDB installation. Introduction to MongoDB Basic Architecture and Installation Differentiate database categories Learn MongoDB design goals List MongoDB tools Describe JSON and BSON Understanding the basic concepts of a Database Database categories: What is NoSQL? Why NoSQL? Benefit over RDBMS Types of NoSQL Database, and NoSQL vs. SQL Comparison, ACID & Base Property CAP Theorem, implementing NoSQL and what is MongoDB? Graph Database Overview of MongoDB, Design Goals for MongoDB Server and Database, MongoDB tools Understanding the following: Collection, Documents and Key/Values, etc., Introduction to JSON and BSON documents Environment setup (live Handson) and using various MongoDB tools available in the MongoDB Package MongoDB Administration Take database backup and restore MongoDB© Export and import data from/ to a MongoDB© instance Check server status and DB status Monitor various resource utilization of a mongod instance Understand various optimization strategies Administration concepts in MongoDB Monitoring issues related to Database Monitoring at Server, Database, Collection level, and various Monitoring tools related to MongoDB Database Profiling, Locks, Memory Usage, No of connections, page fault etc., Backup and Recovery Methods for MongoDB Export and Import of Data to and from MongoDB Run time configuration of MongoDB Production notes/ best practices Data Managements in MongoDB (Capped Collections/ Expired data from TTL), TTL Collection Features GridFS Memory-Mapped Files Journaling Mechanics Storage Engines Power of 2-Sized Allocations No Padding Allocation Strategy Diagnosing Performance Issues Optimization Strategies for MongoDB Configure Tag Sets for Replica Set. Optimize Query Performance Monitoring Strategies for MongoDB . MongoDB Utilities MongoDB Commands MongoDB Management Service (MMS) Data Backup Strategies in MongoDB Copying Underlying Data Files Backup with MongoDump Fsync and Lock MongoDB Ops Manager Backup Software Security Strategies in MongoDB Authentication Implementation in MongoDB . Authentication in a Replica set Authentication on Sharded Clusters Authorization End-to-End Auditing for Compliance User Management Create a User Administrator. Add a User to a Database. Create/Assign User a Role. Verify/Modify a User Access/Privileges. Change a User?s Password MongoDB Security Knowing security concepts in MongoDB Understand how Authentication and Authorisation works Security Introduction Security Concepts Indexes Index Introduction, Index Concepts, Index Types Index Properties Index Creation and Indexing Reference Introduction to Aggregation Aggregation Approach to Aggregation sort Order Pipeline Operators and Indexes Text Indexes Aggregate Pipeline Stages Text Search MapReduce Index Creation Aggregation Operations Index Creation on Replica Set Remove, Modify, and Rebuild Indexes Listing Indexes Measure Index Use Control Index Use Index Use Reporting Geospatial Indexes MongoDB?s Geospatial Query Operators GeoWith Operator Backup & Recovery Import and Export MongoDB Data Restore and recovery of MongoDB(Including point in time Recovery) Restore a Replica Set from MongoDB Backups Recover Data after an Unexpected Shutdown Backup and Restore with Filesystem Snapshots Back Up and Restore with MongoDB Tools Backup and Restore Sharded Clusters High Availability (Replication ) Understand the concept of Replication in MongoDB© ? Create a production like Replica Set Introduction to Replication (High Availability), Concepts around Replication What is Replica Set and Master Slave Replication? Type of Replication in MongoDB How to setup a replicated cluster & managing replica sets etc., Master-Slave Replication Replica Set in MongoDB Automatic Failover Replica Set Members Write Concern Write Concern Levels Write Concern for a Replica Set Modify Default Write Concern Read Preference Read Preference Modes Blocking for Replication Tag Set Configure Tag Sets for Replica set. Replica Set Deployment Strategies . Replica Set Deployment Patterns Oplog File Replication State and Local Database, Replication Administration Diagnostics & Troubleshooting Troubleshoot slow queries Diagnose connectivity problems Understand diagnostic tools Learn common production issues Learn fixes and solutions. Additional course details: Nexus Humans Introduction to MongoDB for DBAs (TTDB4680) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Introduction to MongoDB for DBAs (TTDB4680) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

You will be learning from the basics of a Composable function to how to handle state in Compose and how to build full-fledged Android apps that leverage the full power of Jetpack Compose and Kotlin. This course is tailored for beginners and advanced developers.