The Professional Presenter Training provides you with the knowledge and skill building in the planning, preparation and delivery of truly engaging presentations. Exploring all aspects of concept, design and delivery, you will gain a range of tools and techniques to help you plan and deliver engaging and effective presentations to a range of audiences. You'll learn how to use specific tools and techniques for presentation creation and delivery which will enable you to conduct powerful presentations that engage your audience every time. This course will give you the framework needed to develop and deliver an effective, memorable presentation. You will learn proven tips and examples that will guide you through the presentation process no matter how large the audience. Who is this course for? Excel 2019 Introduction is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Excel 2019 Introduction is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Introduction Introduction 00:01:00 Section 01 What is Excel 00:04:00 Opening Excel 00:07:00 Navigating the Excel User Interface 00:10:00 Using the Excel Ribbon 00:07:00 Understanding Excel Worksheet Components 00:07:00 Using the Backstage View 00:09:00 Section 02 Creating a New Workbook 00:06:00 Creating Workbooks Using Templates 00:03:00 Saving an Excel Workbook 00:05:00 Using the Accessibility Checker 00:04:00 Section 03 Navigating a Worksheet by Mouse or Keyboard 00:05:00 Understanding Excel Data Types 00:06:00 Using the Inking Tools 00:06:00 Working with Cell and Range Addressing 00:03:00 Using various Data Selection Techniques 00:03:00 Working with Common Excel Commands 00:05:00 Using the Autofill Handle 00:04:00 Using Flash Fill 00:02:00 Section 04 What are Formulas and Functions 00:04:00 Understanding the Components of a Formula 00:06:00 Understanding Calculation Hierarchy and the Order of Operations 00:03:00 Creating Basic Formulas 00:03:00 Working with Basic Functions and AutoSum 00:06:00 Using Cell References 00:05:00 Using the Quick Analysis Tools 00:03:00 Section 05 Modifying Columns and Rows 00:06:00 Hiding and Unhiding Columns and Rows 00:04:00 Section 06 Formatting and Aligning Data 00:11:00 Merging Data 00:08:00 Wrapping Text and Adjusting Orientation 00:07:00 Formatting Numbers 00:08:00 Using Borders and Shading 00:07:00 Using the Format Painter 00:04:00 Removing Formatting Quickly 00:05:00 Section 07 Using Cell Styles 00:06:00 Applying Themes 00:04:00 Section 08 Inserting and Formatting Images 00:06:00 Inserting and Formatting Shapes 00:06:00 Inserting and Formatting SmartArt 00:09:00 Working with Icons 00:06:00 Working with 3-D Models 00:05:00 Inserting Screenshots 00:05:00 Inserting Hyperlinks 00:05:00 Inserting Symbols and Equations 00:05:00 Inserting WordArt and Text Boxes 00:08:00 Inserting Other Excel Objects 00:06:00 Arranging Objects 00:05:00 Section 09 Using Find and Replace 00:03:00 Using Go To and Go To Special 00:03:00 Using the Spell Checker 00:05:00 Using the Thesaurus and Translation Features 00:05:00 Section 10 Printing and Previewing Excel Files 00:05:00 Creating Custom Margins and Scaling 00:05:00 Adding Headers and Footers 00:05:00 Exporting to PDF and XPS 00:04:00 Section 11 Renaming and Coloring Worksheet Tabs 00:04:00 Adding, Deleting, and Navigating Worksheets 00:05:00 Section 12 Viewing Workbooks 00:05:00 Using Zoom Tools 00:02:00 Configuring Sheet Options 00:04:00 Using the Freeze Panes and Split Commands 00:06:00 Working with Window Commands 00:03:00 Adjusting Workbook Properties 00:06:00 Recap Recap 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00
Course Overview Grasp the opportunity to learn Microsoft Excel from the ABCs to an advanced level within one course. The Microsoft Excel Masterclass in 2021 course will start with the basics with MS excel and gradually turn you into an expert user. The Microsoft Excel Masterclass in 2021 course will first focus on the tools and functions of excel. You will comprehend the skills to create basic formulas in excel. In this step by the step learning process, you will have the adequate knowledge and ability to make all sorts of adjustments to your worksheets. The course will teach you many strategies for cell formatting. From the easy to follow modules, you will grasp the techniques to insert shapes and images into your sheets. You will also understand how to visualize your data in charts. In the end, you will study the benefits of using excel templates. The Microsoft Excel Masterclass in 2021 course will provide you with first-hand training on excel. Enroll in the course and take your excel skills to the next level. Learning Outcomes Get an introduction to Microsoft Excel and its functions Understand the process of data validation and data visualization Learn how to adjust excel worksheets Know about the conditional functions Familiarize yourself with the process of inserting images and shapes Who is this course for? Those who want to learn Microsoft Excel. 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 Microsoft Excel Masterclass in 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Data Operator Administrative Officer Data Analyst Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:04:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:04:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:07:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excel's IF() Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 INDEX() Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:14:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Lopps For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel Masterclass in 2021 00:00: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
Join our Microsoft Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Excel. 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 Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Microsoft Excel 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 Microsoft Excel is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand. On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level. This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Excel 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 The certification and skills you get from this Microsoft Excel Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:03:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:03:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design.mp4 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Little Slice of Pie Charts 00:05:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:06:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables.mp4 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excels IF Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 The INDEX Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:13:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Loop For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel 00:00:00
Description Register on the New & Easy Color Mixing for Painters - in Acrylic & Oil today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a certificate as proof of your course completion. The New & Easy Color Mixing for Painters - in Acrylic & Oil course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablets, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With This Course Receive a digital certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post. Method of Assessment You need to attend an assessment right after the completion of this course to evaluate your progression. For passing the assessment, you need to score at least 60%. After submitting your assessment, you will get feedback from our experts immediately. Who Is This Course For The course is ideal for those who already work in this sector or are aspiring professionals. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Course Content New & Easy Color Mixing for Painters - in Acrylic & Oil 01. Promo Video 00:01:00 02. Introduction 00:10:00 03. Materials and Preparing Your Color Palette 00:21:00 04. Mixing Purples - And Secondary Colors 00:19:00 05. Mixing Reds - And Primary Colors 00:10:00 06. Mixing Neutral Colors 00:12:00 07. More Tips on Color 00:28:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by: CPD UK & Quality License Scheme Tutor Support: Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning: Learn from anywhere, whenever you want Why Creative Color Training Course For Fine Art Painters Course right for you? Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this Creative Color For Fine Art Painters course will set you up with a solid foundation to become a confident fine art painters and develop more advanced skills. This comprehensive course is the perfect way to kickstart your career in the field of color mixing. This course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Creative Color Training Course For Fine Art Painters Course Details Accredited by International Practitioners of Holistic Medicine (IPHM) is a leading accredited organisation that certifies and regulates alternative therapists, healers, and training providers around the world. After completing the IPHM accredited course you will be eligible to apply for the insurance. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum Creative Color - for Fine Art Painters Chapter 1 - Creating an Enhanced Full Palette Chapter 2 Project - Varying Reds Chapter 3 - Color Variety in Painting Chapter 4 - Vary Color Using Stripes Chapter 5 - Favorite Colors & New Painting Ideas Chapter 6 - Using Color to Frame & Finish Your Painting Chapter 7 - Conclusion Psychology of Dog Behaviour Dealing with Dogs Behaviour in Dogs Psychology of Dogs Aggression in Dogs Exercise Lesson 2 Who should take this course? This comprehensive course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of color mixing. Entry Requirements There are no academic entry requirements for this course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Assessment Method On successful completion of the course, you will be required to sit an online multiple-choice assessment. The assessment will be evaluated automatically and the results will be given to you immediately. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org
This Level 4 bundle combines artistic skill development with vital Arts Management principles. From "Watercolor Workout" to "Digital Painting Masters," it offers diverse training. "Art Therapy Diploma" and "Mindfulness for Wellbeing" prioritize well-being in arts management. Whether aspiring artist or arts administrator, it provides a strong foundation in Arts Management. Covering various artistic skills and management techniques, it prepares for a versatile creative journey. "Basic Acrylic Painting" and "Photoshop Digital Painting" explore both traditional and digital art forms. With "Journal Therapy" and "How to Gold Leaf," it builds a comprehensive artistic toolkit. This curriculum ensures that participants enhance their creative abilities and gain the knowledge to navigate the art industry effectively. Whether artist, creative entrepreneur, or enthusiast, this bundle fosters artistic excellence and professional acumen through Arts Management. *** Course Curriculum *** Here is the curriculum breakdown of the Arts Management (Acrylic Painting & Drawing)Bundle: Course 01: Diploma in Arts Management at QLS Level 4 Course 02: Art, Drawing and Painting Course 03: Painting and Decorating Course 04: The Ultimate Acrylic Painting Course Course 05: Creative Color Course 06: The Art of Painting Beyond Technique Course 07: Watercolor Workout Course 08: Finish Your Paintings Faster with Better Results Course 09: Photoshop Digital Painting Course 10: Digital Painting Masters - Alien Planet Course 11: Advanced Digital Painting Course Course 12: Art Therapy Diploma Course 13: Journal Therapy Course Course 14: Mindfulness for Wellbeing and Peak Performance Course 15: Diploma In Occupational Therapy Course 16: Basic Acrylic Painting Course 17: Art, Drawing and Painting Diploma Course 18: New & Easy Color Mixing for Painters - in Acrylic & Oil Course 19: How to Gold Leaf & Acrylic Painting Ideas Over Gold Leaf Course 20: Secret Tricks to Pouring Acrylic Paint Learning Outcomes: Develop versatile artistic skills across traditional and digital mediums for creative expression. Gain proficiency in arts management principles and strategies for professional success. Foster holistic well-being through art therapy and mindfulness practices. Acquire a comprehensive artistic toolkit, including traditional and digital techniques. Enhance creative problem-solving abilities and adapt to diverse artistic challenges. Prepare for a successful career as an artist, creative entrepreneur, or arts administrator. Why Choose Our Arts Management Course? FREE Arts Management certificate accredited Get a free student ID card with Arts Management Training Get instant access to this Arts Management course. Learn Arts Management from anywhere in the world The Arts Management is affordable and simple to understand The Arts Management is an entirely online, interactive lesson with voiceover audio Lifetime access to the Arts Management course materials The Arts Management comes with 24/7 tutor support This QLS Level 4 course bundle combines Arts Management principles with diverse artistic skill development. From traditional techniques like "Watercolor Workout" to contemporary digital art in "Digital Painting Masters - Alien Planet," participants gain versatile creative competencies. The program also emphasizes well-being through the "Art Therapy Diploma" and "Mindfulness for Wellbeing and Peak Performance," recognizing their importance in Arts Management. Grounding learners in Arts Management principles, this bundle prepares them for varied career paths, whether as professional artists, creative entrepreneurs, or arts administrators. Courses like "Journal Therapy" and "How to Gold Leaf & Acrylic Painting Ideas Over Gold Leaf" expand their artistic toolkit, equipping them to navigate the art industry effectively with Arts Management strategies. Graduates emerge ready to combine artistic excellence with professional acumen, ensuring success in Arts Management. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Arts Management (Acrylic Painting & Drawing) Aspiring Artists Creative Entrepreneurs Arts Administrators Personal Enrichment Seekers Art Therapy Enthusiasts Requirements Arts Management (Acrylic Painting & Drawing) No prior formal qualifications in Arts Management are necessary for this bundle course. Career path Possible career paths after completing this Arts Management (Acrylic Painting & Drawing) bundle: Professional Artist Creative Entrepreneur Arts Administrator Art Therapist Creative Professional Personal Artistic Growth Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included
Anybody who works on the fabric of a building, built or refurbished before 2000, could potentially be exposed to asbestos. Not just those that work with asbestos directly. The Control of Asbestos Regulations 2012 requires anyone who is likely to be exposed to or disturb asbestos at work to undertake asbestos awareness training. This Asbestos Awareness bundle is ideal for all tradespeople and anyone who has responsibility for the management and upkeep of buildings. The Asbestos Awareness Level 2 course has been crafted with the help of industry experts and explains why Asbestos remains a palpable threat in the 21st Century. However, with this training, you will be able to identify hazardous items or buildings and handle them without fear of long-term illnesses. By understanding the facts, you will know how to react. Along with this Asbestos Awareness Level 2, you will get 10 premium courses, original hardcopy certificate, transcript and a student ID card. This Asbestos Awareness Level 2 Bundle Consists of the following Premium courses: Course 01: Asbestos Awareness Level 2 Course 02: Asbestos Surveyor Training Course 03: Environmental Health Course 04: Diploma in Construction Management Course 05: Construction Safety Course 06: COSHH Training and Safety - Level 2 Course 07: Fire Safety Awareness Level 2 Course 08: Manual Handling Level 2 Course 09: DSEAR Training Course 10: RIDDOR Training Course 11: First Aid Training Increase your knowledge of dangerous substances and be prepared to deal with Asbestos if you encounter it during your work or social life. This course presents crucial information about Asbestos and related materials, meaning you will be able to protect yourself whenever necessary. Curriculum Course 01: Asbestos Awareness Level 2 Explained Identification Law Risk Factors Surveys and Risk Assessment Awareness & Safety Asbestos-Containing Waste (ACW) Disposal Accidental Disturbance of ACMs and Dealing with Emergencies Course 02: Asbestos Surveyor Training Introduction Health Effects Asbestos-Containing Materials and Their Properties Management Risk Assessments and Legislative Requirements Surveying Bulk Sampling Procedures and Strategies Survey Report, Quality Assurance and Quality Control Personal Decontamination Course 03: Environmental Health Intro to Environmental Health Waste, Pollution and Pollutants Environment, Pollution, Climate Change and Health Recovering Resources and Managing Waste Food Waste Plastic Air Pollution Water Environmental Sustainability Course 04: Diploma in Construction Management Introduction to Construction Management Project Life Cycle and Success Cost Management Preliminary Site Investigation and Site Organisation Site Management Planning and Management of Equipment Construction Materials Management Vendor Analysis in Construction Management Construction Procurement Stock Control Supply Chain Management The Main Participators Quality Assurance and Customer Care Legal Aspects of Contracting Human Resources Management Risk and Value Management Communications, Information and Documentation of Construction Health and Safety in Construction Management Course 05: Construction Safety Managing Health and Safety Risk Assessment and Common Risks Health and Safety Guidelines and Legislations Reporting Accidents at Work General Site Issues Working at Height Excavation Work and Confined spaces Work Equipment Manual and Mechanical Handling Chemical and Biological Health Hazards and Control Electrical Hazards and Control Fire Hazards and Control Course 06: COSHH Training and Safety - Level 2 COSHH Explained COSHH Regulations Health Problems Related to Hazardous Substances Identifying Hazardous Substances COSHH Risk Assessments Control Measures and Monitoring Implementing Control Measures Course 07: Fire Safety Awareness Level 2 Introduction to Fire Safety Fire Safety Law Measures of Fire Safety Evacuation Procedures Course 08: Manual Handling Level 2 Introduction, Legislation and Guidance Manual Handling Hazards and Injuries Manual Handling Risk Assessments Controlling and Reducing the Risks Safe Lifting Techniques Course 09: DSEAR Training Introduction to DSEAR ATEX and Explosive Atmospheres General Safety Safe Working with Flammable Substances Equipment and Protection System Risk Assessment Course 10: RIDDOR Training Health and Safety at Work and the Laws Managing for Health and Safety Risk Assessment and Common Risks RIDDOR Course 11: First Aid Training Introduction to Workplace First Aid Legal Framework for Workplace First Aid Incident Management at Work Primary Survey Secondary Survey Basic First-Aid Techniques Dealing with Minor Injuries at the Workplace Secondary Illness Loss of Responsiveness and CPR Secondary Illness Breathing Problems Secondary Illnesses and Injuries Dealing With Fractures and Dislocations Call for an Emergency How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously, it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment on this Asbestos Awareness Level 2. It is available to all students, of all academic backgrounds. Requirements Our Asbestos Awareness Level 2 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various CPD certificates will increase the value in your CV and open you up to multiple job sectors such as: General maintenance workers Painters and decorators Plasterers Construction workers Roofers Shop fitters Gas fitters Heating and ventilation engineers Demolition workers Telecommunication engineers Fire/burglar alarm installers Architects Building surveyors Certificates Certificate of completion Digital certificate - Included