17704 Basic courses delivered On Demand

Embark on a journey to master Microsoft Excel with our 'Excel Essentials for Office Administrators' course. Designed to transform beginners into proficient users, this comprehensive course is divided into two main sections: Excel Beginner and Excel Intermediate. In the initial phase, learners are introduced to the Excel interface, where they explore and identify its various elements. This is followed by practical activities such as creating basic worksheets, using the help system, and crafting formulas. As the course progresses, participants will delve into more advanced features like manipulating data, applying styles and formats, and managing worksheets. The intermediate section elevates your skills further, covering a wide range of topics from applying range names and specialized functions to creating sophisticated charts and PivotTables. Learning Outcomes Gain proficiency in navigating and utilizing the Excel interface. Develop the ability to create and manage complex worksheets effectively. Master a variety of Excel functions and formulas for diverse data processing needs. Learn advanced data management techniques including sorting, filtering, and using PivotTables. Acquire skills in visual data presentation and customization of Excel workbooks. Why choose this Excel Essentials for Office Administrators course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Excel Essentials for Office Administrators course for? Office administrators and secretaries seeking to enhance their Excel skills. Professionals in various sectors requiring proficiency in Excel for data management. Students and individuals interested in learning Excel from a beginner to an intermediate level. Business owners needing to manage business data more efficiently. Anyone aiming to improve their productivity and data analysis skills through Excel. Career path Data Analyst: £25,000 - £50,000 Administrative Assistant: £18,000 - £30,000 Office Manager: £22,000 - £40,000 Business Analyst: £30,000 - £60,000 Financial Analyst: £28,000 - £55,000 Project Coordinator: £24,000 - £45,000 Prerequisites This Excel Essentials for Office Administrators does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Excel Beginner Identify the Elements of the Excel Interface 00:30:00 Activity - Identify the Elements of the Excel Interface 00:05:00 Create a Basic Worksheet 01:00:00 Activity - Create a Basic Worksheet 00:05:00 Use the Help System 00:30:00 Activity - Use the Help System 00:05:00 Create Formulas in a Worksheet 01:00:00 Activity - Create Formulas in a Worksheet 00:05:00 Insert Functions in a Worksheet 00:30:00 Activity - Insert Functions in a Worksheet 00:05:00 Reuse Formulas 00:30:00 Activity - Reuse Formulas 00:05:00 Manipulate Data 00:30:00 Activity - Manipulate Data 00:05:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:30:00 Activity - Insert, Manipulate, and Delete Cells, Columns, and Rows 00:05:00 Search For and Replace Data 00:30:00 Activity - Search For and Replace Data 00:05:00 Spell Check a Worksheet 00:30:00 Activity - Spell Check a Worksheet 00:05:00 Modify Fonts 00:30:00 Activity - Modify Fonts 00:05:00 Add Borders and Colors to Cells 01:00:00 Activity - Add Borders and Colors to Cells 00:05:00 Apply Number Formats 00:30:00 Activity - Apply Number Formats 00:05:00 Align Cell Contents 00:30:00 Activity - Align Cell Contents 00:05:00 Apply Cell Styles 00:30:00 Activity - Apply Cell Styles 00:05:00 Define the Basic Page Layout for a Workbook 01:00:00 Activity - Define the Basic Page Layout for a Workbook 00:05:00 Refine the Page Layout and Apply Print Options 00:30:00 Activity - Refine the Page Layout and Apply Print Options 00:05:00 Format Worksheet Tabs 00:30:00 Activity - Format Worksheet Tabs 00:05:00 Manage Worksheets 00:30:00 Activity - Manage Worksheets 00:05:00 Manage the View of Worksheets and Workbooks 00:30:00 Activity - Manage the View of Worksheets and Workbooks 00:05:00 Customize General and Language Options 00:30:00 Activity - Customize General and Language Options 00:05:00 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Customize Proofing and Save Options 01:00:00 Activity - Customize Proofing and Save Options 00:05:00 Customize the Ribbon and Quick Access Toolbar 00:30:00 Activity - Customize the Ribbon and Quick Access Toolbar 00:05:00 Customize the Functionality of Excel by Enabling Add-Ins 00:30:00 Activity - Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:30:00 Activity - Customize Advanced and Trust Center Options 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 for Beginners 00:00:00 Excel Intermediate Apply Range Names 00:30:00 Use Specialized Functions 00:30:00 Use Text Functions 00:30:00 Use Logical Functions 00:30:00 Use Lookup Functions 00:30:00 Use Date Functions 00:30:00 Use Financial Functions 00:30:00 Create and Modify Tables 00:30:00 Sort and Filter Data 00:30:00 Use Subtotal and Database Functions to Calculate Data 00:30:00 Create Charts 00:30:00 Modify and Format Charts 00:30:00 Create a Trendline 00:30:00 Create Advanced Charts 00:30:00 Create a PivotTable 00:30:00 Filter Data by Using Slicers 00:30:00 Analyze Data with PivotCharts 00:30:00 Insert and Modify Graphic Objects 00:30:00 Layer and Group Graphic Objects 00:30:00 Incorporate SmartArt 00:30:00 Customize Workbooks 00:30:00 Manage Themes 00:30:00 Create and Use Templates 00:30:00 Protect Files 00:30:00 Preparing a Workbook for Multiple Audiences 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 Intermediate 00:00:00

Free Level 5 QLS Endorsed Certificate | CPD Accredited | 150 CPD Points | Advanced Learning Materials | Lifetime Access

Description: Microsoft Project 2010 is the latest version of Project, a companion project management application for Microsoft Office. This Microsoft Project 2010 Beginners - Complete Video Course teaches the basic commands and features of Microsoft Project 2010. Here, you will learn how to create and modify task lists, establish a project schedule, create calendars, assign resources to tasks, track costs, and work with different views and tables. You will also learn how to apply filters and groups, and sort task and resource data. This version includes a wide range of changes, including the new ribbon interface. Microsoft Project integrates with all the other Office application you regularly use. You will finish up the course with learning how to resolve resource conflicts. If you want to know more detail about Microsoft Project you have to be a part of this course. You will get all the basic knowledge from here, which will help you to pull up ahead. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Project 2010 Beginners - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Project 2010 Beginners - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started Project Management Concepts FREE 00:12:00 The Project Window 00:15:00 Project Files 00:10:00 The Help Window 00:02:00 Tasks Creating a Task List 00:10:00 Modifying a Task List 00:07:00 The Work Breakdown Structure 00:13:00 Tasks Scheduling Task Links 00:16:00 Task Relationships 00:09:00 Task Options 00:05:00 Resource Management The Base Calendar 00:07:00 Resources and Calendars 00:14:00 Project Costs 00:08:00 Views and Tables Working with Views 00:12:00 Working with Tables 00:04:00 Filters, Groups, and Sorting Filters 00:10:00 Groups 00:05:00 Sorting Tasks and Resources 00:05:00 Finalizing the Task Plan Finalizing Schedules 00:09:00 Handling Resource Conflicts 00:11:00 Mock Exam Mock Exam- Microsoft Project 2010 Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Project 2010 Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description As a beginner, do you want to learn about MS Access? Are you interested to know its various function and use? Do you want to be an expert in this field? If so, take a look at our MS Access 2016 Introduction course. It will assist you in understanding all you need to learn about this course. The course designs for the fresher who have a little or no basic knowledge of MS Access. It teaches you how to create, open, and save an Access database. It will acquaint you with the basic equipment such as ribbons and toolbar so that you can get access it flexibly to create a table, and store date smoothly. It introduces you to numeric and index field with a plenty of practical exercises so that you can learn the basic of MS Access 2016 effectively. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? MS Access 2016 Introduction is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our MS Access 2016 Introduction is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:01:00 Getting Started What is a Database? 00:03:00 Understanding Database terminology 00:05:00 Navigating the Access Interface 00:06:00 What is a flat file database 00:04:00 What is a relational database 00:09:00 Relating Tables 00:06:00 Reviewing the Access Ribbon 00:04:00 Working with Data Working with Tables 00:04:00 Navigating Tables 00:02:00 Editing Data 00:03:00 Adding New Records 00:02:00 Using Subdatasheets 00:04:00 Creating Databases and Objects Understanding Database and Table Design Principles 00:10:00 Using Table Data Sheet View 00:04:00 Working with Field Data Types 00:04:00 Using Table Design View 00:04:00 Using Calculated Fields 00:04:00 Calculating Numbers 00:03:00 Calculating Dates 00:01:00 Calculating Strings 00:02:00 Using the Lookup Wizard 00:05:00 Editing Lookups 00:04:00 Using Indexes 00:02:00 Working with Queries What are Queries 00:03:00 Creating Simple Queries 00:05:00 Understanding the Dynaset 00:02:00 Entering Criteria: Exact Match and Range Operators 00:04:00 Understanding AND versus OR 00:03:00 Using Wild Cards 00:02:00 Using Keywords 00:03:00 Sorting and Hiding Fields 00:02:00 Creating Multi-Table Queries 00:03:00 Additional Tips 00:03:00 Working with Reports What are Reports 00:03:00 Understanding Report Types 00:03:00 Building Effective Reports 00:02:00 Using AutoReport 00:04:00 Understanding the Report Wizard 00:04:00 Using the Report Design View 00:08:00 Creating Labels 00:02:00 Working with Forms What are Forms 00:04:00 Understanding Form Types 00:02:00 Creating Forms 00:02:00 Navigating Forms 00:02:00 Editing Data in Forms 00:03:00 Understanding the Form Wizard 00:03:00 Using the Form Design View 00:04:00 Working with Controls 00:03:00 Using Form Layout View 00:02:00 Additional Tips 00:03:00 Conclusion Course Recap 00:01:00 Resources Resources - MS Access 2016 Introduction 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Level 5 QLS Endorsed Course | Endorsed Certificate Included | Plus 5 Career Guided Courses | CPD Accredited

Level 5 QLS Endorsed Course | Endorsed Certificate Included | Plus 5 Career Guided Courses | CPD Accredited

Learn all the CSS Flexbox concepts and create a completely responsive design and elements - real-world hands-on training.

24-Hour Flash Sale! Prices Reduced Like Never Before!! Learn to use the world's Best Photo Editing Software with Adobe Photoshop CC. In the UK, the demand for skilled graphic designers and digital artists continues to grow, with the market projected to reach over £1 BILLION by 2025. Reach your full potential by taking our Adobe Photoshop CC Course and leap up the career ladder of your choice. The "Adobe Photoshop" course offers a comprehensive curriculum that covers every aspect of Photoshop, from basic to advanced techniques. You will start with an overview and progress to creating graphic designs, making PSD thumbnails visible, and working with Photoshop actions. Learn to create and transform images, work with text and fonts, and produce 3D image shots. You can quickly become skilled in the field by enrolling in this bestselling Adobe Photoshop CC course and stand proudly above applicants and candidates as you impress your future employer. Learning Outcomes of Adobe Photoshop CC Course: Master the basics and advanced techniques of Adobe Photoshop. Develop skills in creating and transforming graphic designs. Learn to work with text, fonts, and Photoshop actions effectively. Gain proficiency in producing 3D images and managing file formats. Understand the practical applications of Photoshop in live projects. Enhance your ability to produce professional-grade graphics and designs. Elevate your career with the "Adobe Photoshop" course and become a master of digital design. This program not only enhances your technical skills but also develops your creative abilities, allowing you to produce high-quality work that stands out. Enrol today and take the first step towards a rewarding and creative career! Why Prefer this Adobe Photoshop CC Course? Get a Free QLS Endorsed Certificate upon completion of the course Get a Free Student ID Card with this training program (£10 postal charge will be applicable for international delivery) The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! Adobe Photoshop is the world's leading technology for creating and editing photographs. It can be used to create images, logos, 3D artwork, etc. and improve them. The complete course in Adobe Photoshop will give you the overall outlook and skills needed to master this application. Curriculum Breakdown of Adobe Photoshop CC Module 01: Overview Module 02: Having Graphic Designs Created Module 03: Making PSD Thumbnails Visible on Your PC Module 04: Creating a Simple Design - Part 1 Module 05: Creating a Simple Design - Part 2 Module 06: Changing the Background Image Module 07: Changing the Font or Text Module 08: Working with Photoshop Actions Module 09: Sources for Photoshop Actions Module 10: Selecting Photoshop Actions Module 11: Producing Photoshop Actions - Part 1 Module 12: Show Transform Controls Module 13: Producing Photoshop Actions - Part 2 Module 14: Creating a Multiple 3D Image Shot Module 15: Sizing of File Formats Module 16: Saving For Certain File Formats Module 17: Live Application - Part 1 Module 18: Live Application - Part 2 Module 19: Multiple Short Live Application Module 20: Conclusion How will I get my Adobe Photoshop CC Certificate? After successfully completing the Adobe Photoshop CC course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously, it was £12.99) CPD Hard Copy Certificate: Free (For The First Course: Previously it was £29.99) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £79) CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Adobe Photoshop CC Training Right for You? This Adobe Photoshop CC training has been professionally-designed for motivated learners who are looking to add a new skill to their CV and stand head and shoulders above the competition. Requirements Adobe Photoshop CC Enrol on the Adobe Photoshop CC training Course with no formal entry requirements! If you have a passion for knowledge and want to learn something new. Career path Adobe Photoshop CC You will be able to develop precise knowledge and skills with proper trust after completing this Adobe Photoshop CC Training course to enrich yourself and brighten up your career in the related job market. Certificates Advanced Photoshop CC at QLS Level 2 Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge. CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Best Price Of The Market Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This Pool Maintenance bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Pool Maintenance bundle will help you stay ahead of the pack. Throughout the Pool Maintenance programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Pool Maintenance course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Pool Maintenance Bundle Consists of the following Premium courses: Course 01: Pool Maintenance Course 02: Diploma in Water Treatment Course 03: Diploma in Water Chemistry Course 04: Customer Relationship Management Course 05: Manual Handling Level 2 Course 06: Handyperson Course 07: Electronic & Electrical Devices Maintenance Course 08: COSHH Training and Safety - Level 2 Course 09: Health and Safety Executive Course 10: Emergency First Aid and Incident Management at Work Course 11: RIDDOR Training Enrol now in Pool Maintenance to advance your career, and use the premium study materials from Apex Learning. How will I get my Certificate? After successfully completing the Pool Maintenance 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) PS The delivery charge inside the UK is £3.99, and the international students have to pay £9.99. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Pool Maintenance expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Curriculum: Course 01: Pool Maintenance Module 01: Maintenance Equipment Module 02: Cleaning and Maintenance Module 03: Chemical Balance of Water Module 04: Water Quality Maintenance Module 05: Pool Safety CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this course bundle. Requirements This Pool Maintenance course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.

Overview Do you want to make a career out of Botany and take your knowledge of plant-life to a new level? Train to be a professional Horticulturist and find your dream job. This unique and comprehensive course will train you in every aspect of plant maintenance and help you master your skills with growing them. The Level 5 Horticulturist Course course delivers numerous learning modules that not only offer you fascinating facts on the subject of plants and their ecology but also detail advanced techniques for nurturing and protecting the most exotic varieties. This enables you to successfully secure work in garden centres or arboreal havens. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Level 5 Horticulturist Course. It is available to all students, of all academic backgrounds. Requirements Our Level 5 Horticulturist Course 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 qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 20 sections • 20 lectures • 10:57:00 total length •Basic Botany: 00:30:00 •Plant Classification: 00:15:00 •Soil Science: 00:30:00 •Plant Nutrition Requirements: 00:30:00 •Plant Pests, Diseases & Problems: 00:30:00 •Basic Concepts of Organic Gardening: 00:30:00 •Weed Control: 00:15:00 •Plant Propagation: 02:00:00 •Amenity Horticulture, Plant Selection and Native Plants: 01:00:00 •Exotic Plants: 00:37:00 •Indoor Plants: 00:45:00 •Lawns: 00:30:00 •Planting and Plant Care: 00:12:00 •Plant Nodes and Indigenous Plants: 00:23:00 •Plant Protection, Landscaping and Garden Design: 00:25:00 •Ornamental Horticulture: 00:22:00 •Permaculture: 00:18:00 •Arboriculture: 00:13:00 •Horticulture Statistics: 00:35:00 •Results from the 2018 Seasonal Labour in Horticulture End of Year: 00:37:00