2766 EDI courses in Cardiff delivered On Demand

Podcasting is EXPLODING! An ever increasing number of individuals are turning into podcasts every single day. Having your own podcast can do as such much for you, regardless of whether you're attempting to build your brand, advance your current business, or simply need to get your thoughts out there. In this course, you'll pick up all that you have to know to make your own podcast and record your first scene. You will learn how to prepare your guests. You will learn how to grow your podcast audience reputation by giving an excellent interview. By the end this course, you will learn how to host a podcast like a pro. Course Highlights Accredited Diploma in TV Podcast Presenter is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Accredited Diploma in TV Podcast Presenter into 17 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 9 hours, 45 minutes and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Accredited Diploma in TV Podcast Presenter Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Accredited Diploma in TV Podcast Presenter is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Accredited Diploma in TV Podcast Presenter 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. What is a Podcast FREE 00:30:00 Using Podcasts as a Listener FREE 00:30:00 What Equipment do I Need to Create a Podcast 00:30:00 Recording Your Podcast 00:30:00 Editing Your Podcast 00:30:00 Publishing Your Podcast 00:30:00 That's all folks 00:30:00 Why Do Interviews? 00:30:00 What Is Involved In Hosting A Podcast Show? 00:30:00 NEW PODCAST start-up TIPS! 01:00:00 What Equipments WILL You Need 00:30:00 HOW TO CONTACT THE PEOPLE YOU WANT TO INTERVIEW ON YOUR PODCAST SHOW 00:30:00 HOW TO PREPARE FOR AN INTERVIEW 00:30:00 HOW WILL YOU CONDUCT THE INTERVIEW 00:30:00 Editing Your Interviews For Publishing 01:00:00 Hosting & Uploading Your MEDIA FILEs 01:00:00 WRAPPING UP 00:15:00 Mock Exam Final Exam

Learning Objectives Introduction , Getting Started with Access , Working with Data , Creating Databases and Objects , Working with Queries , Working with Reports , Working with Forms , Conclusion   Pre-Requisites Basic computer skills. Knowledge of basic database concepts is helpful but not required.   Description This course is an introduction to Microsoft Access 2019. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 2019 Intermediate course. Access 2019 Beginner Module 1: Introduction to the course 00:01:00 Module 2: What is Database 00:03:00 Module 3: Understanding Database terminology 00:04:00 Module 4: Navigating the Access Interface 00:09:00 Module 5: What is Flat file Database 00:03:00 Module 6: What is Relational Database 00:10:00 Module 7: Relating Tables 00:08:00 Module 8: Reviewing the Access Ribbon 00:02:00 Module 9: Working with Tables 00:07:00 Module 10: Navigating Tables 00:03:00 Module 11: Editing Data 00:03:00 Module 12: Adding New Records 00:03:00 Module 13: Using Subdatasheets 00:04:00 Module 14: Understanding Database and Table Design Principles 00:09:00 Module 15: Using Table Data Sheet View 00:04:00 Module 16: Working with Field Data Types 00:07:00 Module 17: Using Table Design View 00:04:00 Module 18: Using Calculated Fields 00:08:00 Module 19: Calculating Dates 00:04:00 Module 20: Calculating Strings 00:04:00 Module 21: Using the Lookup Wizard 00:11:00 Module 22: Lookup Wizard Linking Tables 00:06:00 Module 23: Using Indexes 00:05:00 Module 24: What are Queries 00:06:00 Module 25: Creating Simple Queries 00:05:00 Module 27: Entering Criteria-Exact Match and Ranger Operators 00:06:00 Module 28: Understanding And VS Or 00:06:00 Module 29: Using Wild Cards 00:04:00 Module 30: Using Key Words 00:04:00 Module 31: Sorting and Hiding Fields 00:03:00 Module 32: Creating Multi-Table Queries 00:03:00 Module 33: Creating a Calculated Field in Query 00:05:00 Module 34: Additional Tips 00:05:00 Module 35: What are Reports 00:04:00 Module 36: Understanding Report Types 00:03:00 Module 37: Building Good Reports 00:02:00 Module 38: Using Autoreport 00:06:00 Module 39: The Report Wizard 00:12:00 Module 40: Using the Report Design View 00:07:00 Module 41: Printing Reports 00:04:00 Module 42: Creating Labels 00:05:00 Module 43: Additional Tips 00:09:00 Module 44: What are Forms 00:03:00 Module 45: Understanding Form Types 00:03:00 Module 46: Creating Forms 00:02:00 Module 47: Navigating Forms 00:02:00 Module 48: Editing Data in Forms 00:05:00 Module 49: Understanding the Form Wizard 00:05:00 Module 50: Using the Form Design View 00:04:00 Module 51: Working with Controls 00:07:00 Module 52: Using the Form Layout View 00:03:00 Module 53: Additional Tips 00:07:00 Downloadable Resources Resources - Access 2019 Beginner 00:00:00 Final Exam Final Exam - Access 2019 Beginner 00:20:00

Portable Document Format (PDF) is now an open standard maintained by the ISO and has taken over of our everyday life. It is used all over the world but, hardly few know how to create and work with PDF files efficiently. Through this Adobe Acrobat Pro XI Accredited Training, you'll be familiar with new advanced Acrobat Pro XI features including creating and editing PDFs. You'll know about the interface and ways to view and modifying PDF documents, converting PDF files, touchscreen capabilities and many more. Course Highlights Adobe Acrobat Pro XI Accredited Training is an award winning and the best selling course that has been given the CPD Qualification Standards & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Adobe Acrobat Pro XI Accredited Training into 20 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 16 hours, 30 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Adobe Acrobat Pro XI Accredited Training Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Adobe Acrobat Pro XI Accredited Training is CPD Qualification Standards and IAO accredited. 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 backgrounds. Requirements Our Adobe Acrobat Pro XI Accredited Training 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD Qualification Standards and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Adobe Acrobat Pro XI Open a PDF Document 01:00:00 Browse a PDF Document 01:00:00 Create and Save a PDF Document from an Existing Document 01:00:00 Create a PDF Document from a Web Page 01:00:00 Combine Multiple PDF Documents 01:00:00 PDF Portfolios 00:30:00 Perform a Search in a PDF Document 01:00:00 Search Multiple PDF Documents 00:30:00 Work with Bookmarks 00:30:00 Create Links and Buttons 01:00:00 Manipulate PDF Document Pages 01:00:00 Edit Content in a PDF Document 00:30:00 Add Page Elements 01:00:00 Add Comments and Markup 00:30:00 Compare PDF Documents 01:00:00 Initiate and Manage a Review 01:00:00 Reduce the File Size of a PDF Document 00:30:00 Optimize PDF Files 00:30:00 Convert and Reuse PDF Document Content 01:00:00 Using Touchscreen Devices 01:00:00 Mock Exam Final Exam

Want to create PDF files or can't open PDF files? Don't know how to work with PDF files? If it's a yes, then you have come to the right place. Adobe Acrobat Pro 8 is a set of tools for viewing, editing, printing and manipulating PDF files. The Diploma in Adobe Acrobat 8 Pro is designed to help you get started with Acrobat 8 including discovering different ways to create PDF files, use Acrobat's editing tools and learn the fundaments of this program's advanced features. Discover each and every single detail of Adobe Acrobat 8 Pro in this course. Course Highlights Diploma in Adobe Acrobat 8 Pro is an award-winning and the best selling course that has been given the CPD Qualification Standards & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Diploma in Adobe Acrobat 8 Pro into 24 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 16 hours, 15 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Diploma in Adobe Acrobat 8 Pro Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Diploma in Adobe Acrobat 8 Pro is CPD Qualification Standards and IAO accredited. 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 backgrounds. Requirements Our Diploma in Adobe Acrobat 8 Pro 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD Qualification Standards and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Starting Out 00:15:00 Opening Adobe Acrobat 00:30:00 Understanding the Interface 00:15:00 Navigating Through Your PDF File 00:30:00 Getting Help in Acrobat 8 00:30:00 Working With PDF Files 00:30:00 Working with a PDF File 01:00:00 Ways to Create a PDF File 00:30:00 Creating a PDF Package 01:00:00 Using Acrobat's Tools 00:30:00 Moving Text 00:15:00 Window Tools 01:00:00 Working With PDF Pages 00:30:00 Polishing Your File 01:00:00 Linking Files 01:00:00 Creating Forms 01:00:00 Using Collections 00:30:00 Sending a File for Review 01:00:00 Reviewing the File 00:30:00 Viewing and Sending Comments 00:30:00 Protecting Your File 01:00:00 Adobe Reader 01:00:00 Internet Explorer 01:00:00 Using PDF Files with Microsoft Office 00:30:00 Mock Exam Final Exam

Take a course on Microsoft Publisher 2010 and you will be able to customize your own page layout and design, create your own cards, brochures, calendars. It is an easy to use software with a user-friendly interface with all the features you need at your disposal. You'll have no trouble producing high quality publications, no matter what your level of skill is. New features includes office backstage, enhanced photo editing, easy targeted email, integrated print properties, catalog merge and improved templates and building blocks. This course will teach you how to use Microsoft Publisher in real life and you can reap its reward as Microsoft Publisher comes with helpful wizards and hundreds of templates which are designed to simplify the layout and make creating your ideal publication quick and easy. Microsoft Publisher has an integrated mail merge feature that allows you to effortlessly send your publications to a wide range of recipients. This course will particularly provide you all the necessary theories, guidelines and techniques to become a successful publisher. When you have completed the course, you will be able to to do most of the work related to Microsoft Publisher and will also be able to effortlessly publish visiting cards, brochures. flyers. calendars, newsletter. Course Highlights Certificate in Microsoft Publisher 2010 for Beginners is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certificate in Microsoft Publisher 2010 for Beginners into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certificate in Microsoft Publisher 2010 for Beginners Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certificate in Microsoft Publisher 2010 for Beginners is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Certificate in Microsoft Publisher 2010 for Beginners 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module One - Getting Started 00:30:00 Module Two - Opening and Closing Publisher 01:00:00 Module Three - Working with Publications 01:00:00 Module Four - Your First Publication 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Using the Page Design Tab 01:00:00 Module Seven - Basic Font Formatting 01:00:00 Module Eight - Formatting Paragraphs 01:00:00 Module Nine - Working with Objects 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Adding the Finishing Touches 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities - Certificate in Microsoft Publisher 2010 for Beginners CPD Accredited CPD Accredited 00:00:00 Mock Exam Final Exam

Course based on all the Essentials of Microsoft One Note Have you ever faced a situation where you wanted to note something down but you didn't have your diary or notebook because you didn't want to carry the extra load? With Microsoft One Note you don't need to face this situation again. Write anything down anywhere, whenever you feel like. Store your drawings, screen clippings and audio commentaries on this useful app. This application can be used on your mobile phones. One note can be downloaded on any platform. It is very easy to use and useful for anyone living a busy life. One note is beneficial for improved workflow and daily organization. It has an easy access and improves transparency. The app itself can also be downloaded for free. This course will give you all the idea you need on how to operate microsoft one note as a professional. After completion you will be able to learn all of the functions of this useful application and store all your thoughts and writings on it while also organizing your daily life. Course Highlights Microsoft One Note 365 Skills Training is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Microsoft One Note 365 Skills Training into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 40 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft One Note 365 Skills Training Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Microsoft One Note 365 Skills Training is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Microsoft One Note 365 Skills Training 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module One - Getting Started 00:30:00 Module Two - Welcome to Office 365 Web Apps 01:00:00 Module Three - Working with Notebooks 01:00:00 Module Four - Working with Pages and Sections 01:00:00 Module Five - Editing in the Browser 01:00:00 Module Six - Basic Editing Tasks 01:00:00 Module Seven - Formatting Your Text 01:00:00 Module Eight - Paragraph Formatting, Styles and Tags 01:00:00 Module Nine - The Insert Tools (I) 01:00:00 Module Ten - The Insert Tools (II) 01:00:00 Module Eleven - The View Tab 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft One Note 365 Essentials 00:00:00 Mock Exam Mock Exam- Microsoft One Note 365 Essentials 00:20:00 Final Exam Final Exam- Microsoft One Note 365 Essentials 00:20:00

Grow Green Vegetables on Your Own Garden Do you love gardening as your hobby and create your own beautiful garden? Or want to become a professional gardener? If any one of them is what you desire, you should take our Vegetable Gardening Diploma Course course and make your wishes come true. This course focuses on vegetable gardening and a complete guide to prepare one. You will learn about the requisites of gardening, preparing a plan for plantation, keeping records, implement different techniques, use of fertilisers etc. You will also learn about different types of vegetable plants, process of sowing the soil, keeping the plants safe and also providing enough nutrition so that they can grow properly. Finally, you will learn about harvesting the vegetables that you have grown and how to pick them up. As bonus, you will get to know about different types of fruits and berries along with how to plant them in your garden. So, why wait? Enrol to our Vegetable Gardening Diploma Course now and become a professional gardener for your own garden in no time. Course Highlights Vegetable Gardening Diploma Course is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Vegetable Gardening Diploma Course into 16 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 9 hours, 25 minutes and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Vegetable Gardening Diploma Course Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Vegetable Gardening Diploma Course is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Vegetable Gardening Diploma 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Vegetable Gardening Module 01: Introduction FREE 00:15:00 Module 02: Soil FREE 00:25:00 Module 03: Fertilisers, Manures, and Compost 00:25:00 Module 04: Planning Your Garden (Part-1) 00:35:00 Module 05: Planning Your Garden (Part-2) 00:20:00 Module 06: Clearing Ground and Preparing Soil 00:45:00 Module 07: Seeding and Planting 00:30:00 Module 08: Raising Plants under Cover 00:25:00 Module 09: Keeping the Garden Healthy 00:35:00 Module 10: Hands on Training: Sowing and Growing (Part-1) 00:35:00 Module 11: Hands on Training: Sowing and Growing (Part-2) 00:35:00 Module 12: Container Gardening 00:40:00 Module 13: Indoor Edible Garden (Part-1) 00:40:00 Module 14: Indoor Edible Garden (Part-2) 00:25:00 Module 15: Hydroponic Gardens: Hands on Training (Part-1) 00:40:00 Module 16: Hydroponic Gardens: Hands on Training (Part-2) 00:35:00 Mock Exam Mock Exam - Vegetable Gardening Diploma Course 00:30:00 Final Exam Final Exam - Vegetable Gardening Diploma Course 00:30:00

If you are looking forward to advance your skills with Microsoft Excel 2016 and want to learn more advanced skills or want to learn the topics covered in this course in the 2016 interface, this Excel 2016 Advanced will be the perfect choice for you! Through the course you will gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. Additionally, you will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in your worksheets and workbooks. You will also learn about Excel's many collaboration features, as well as how to import and export data to and from your workbooks. What Will I Learn? Use Advanced IF Statements Use Advanced Lookup Functions Use Complex Logical and Text Functions Auditing Formulas Working with What-If Analysis Tools Protecting Worksheet and Workbook Use Advanced PivotTables and PowerPivot Tools Automate with Macros Work with Form Controls Ensure Data Integrity Collaborate in Excel Import and Export Data to a Text File Requirements Excel Introduction and Intermediate courses or equivalent experience. Who is the target audience? Students who want to expand their Excel knowledge. Introduction Introduction FREE 00:01:00 Using Advanced IF Statements Summarize Data with SUMIF FREE 00:04:00 Summarize Data with AVERAGIF 00:03:00 Summarize Data with COUNTIF 00:02:00 Using Advanced Lookup Functions Using VLOOKUP with TRUE to find an Approximate Match 00:04:00 Using HLOOKUP TRUE to find an Approximate Match 00:01:00 Using the Index Function 00:03:00 Using the Match Function 00:02:00 Creating a Combined Index and Match Formula 00:04:00 Comparing Two Lists with VLOOKUP 00:02:00 Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Using Complex Logical and Text Functions Creating a Nested IF Function 00:03:00 Using the IFERROR Function 00:02:00 Using the LEN Function 00:02:00 Using the TRIM Function 00:01:00 Using the Substitute Function 00:02:00 Formula Auditing Showing Formulas 00:01:00 Tracing Cell Precedents and Dependents 00:03:00 Adding a watch Window 00:02:00 Error Checking 00:02:00 What-If Analysis Tools Using the Scenario Manager 00:03:00 Using Goal Seek 00:02:00 Analyzing with Data Tables 00:02:00 Worksheet and Workbook Protection Protection Overview 00:02:00 Excel File Password Encryption 00:03:00 Allowing Specific Worksheet Changes 00:01:00 Adding Protection to only Certain Cells in a Worksheet 00:03:00 Additional Protection Features 00:02:00 Advanced Use of PivotTables and PowerPivot Using the Pivot Tables Charts Wizard 00:02:00 Adding a Calculated Field 00:02:00 Adding a Caculated Item 00:02:00 Apply Conditional Formatting to a Pivot Table 00:03:00 Using Filters in the Pivot Table Fields Pane 00:02:00 Creating Filter Pages for a Pivot Table 00:01:00 Enabling a Power Pivot Add In 00:04:00 Automating with Macros What are Macros 00:03:00 Displaying the Developer Tab and Enabling Macros in Excel 00:03:00 Creating a Basic Formatting Macro 00:03:00 Running a Macro 00:02:00 Assigning a Macro to a Button 00:02:00 Creating a More Complex Macro 00:02:00 Viewing and Editing the VBA Code for an Existing Macro 00:03:00 Adding a Macro to the Quick Access Toolbar 00:02:00 Working with Form Controls What are Form Controls 00:02:00 Adding Spin Buttons and Check Boxes to a Spreadsheet 00:02:00 Adding a Combo Box to a Spreadsheet 00:02:00 Ensuring Data Integrity What is Data Validation 00:01:00 Restricting Data Entries to Whole Numbers 00:02:00 Data Validation Restricting Data Entry to a List 00:01:00 Data Validation Restricting Data Entry to a Date 00:01:00 Data Validation Restricting Data Entry to Different Text Lengths 00:01:00 Composing Input Messages 00:02:00 Composing Error Alters 00:02:00 Finding Invalid Data 00:02:00 Editing and Deleting Data Validation Rules 00:01:00 Collaborating in Excel Working with Comments 00:03:00 Printing Comments and Errors 00:02:00 Sharing a Workbook 00:03:00 Tracking Changes in a Workbook 00:03:00 Working with Versions 00:02:00 Sharing Files via Email 00:02:00 Importing and Exporting Data to a Text File Importing a Text File 00:03:00 Exporting a Text File 00:01:00 Conclusion Course Recap 00:01:00 Course Certification

Sage 50 Payroll Complete Course Overview If you want to work in the accounting or finance sector but lack the necessary payroll knowledge and abilities, the Sage 50 Payroll Complete Course is the ideal course for you. Sage is a widely used software system that is utilized by both large and small organizations worldwide. You must be familiar with Sage 50 Payroll in order to stay up to date with technology and get hired by the majority of firms. You will be a great addition to any business after completing this course. An annual cost of salaries, tax code modification, SSP processing, employing advanced payment choices, and more will all be covered in this course. While the list is endless, one thing always stays the same: Sage 50 Payroll will keep you informed about the newest techniques and technology, enabling you to utilize it with assurance. Why You Should Choose Sage 50 Payroll Complete Course Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Sage 50 Payroll Complete Course is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Sage 50 Payroll Complete 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Sage 50 Payroll For Beginners Module 1: Payroll Basics Payroll Basics 00:10:00 Module 2: Company Settings Company Settings 00:08:00 Module 3: Legislation Settings Legislation Settings 00:07:00 Module 4: Pension Scheme Basics Pension Scheme Basics 00:06:00 Module 5: Pay Elements Pay Elements 00:14:00 Module 6: The Processing Date The Processing Date 00:07:00 Module 7: Adding Existing Employees Adding Existing Employees 00:08:00 Module 8: Adding New Employees Adding New Employees 00:12:00 Module 9: Payroll Processing Basics Payroll Processing Basics 00:11:00 Module 10: Entering Payments Entering Payments 00:12:00 Module 11: Pre-Update Reports Pre-Update Reports 00:09:00 Module 12: Updating Records Updating Records 00:09:00 Module 13: E-Submissions Basics e-Submissions Basics 00:09:00 Module 14: Process Payroll (November) Process Payroll (November) 00:16:00 Module 15: Employee Records And Reports Employee Records and Reports 00:13:00 Module 16: Editing Employee Records Editing Employee Records 00:07:00 Module 17: Process Payroll (December) Process Payroll (December) 00:12:00 Module 18: Resetting Payments Resetting Payments 00:05:00 Module 19: Quick SSP Quick SSP 00:10:00 Module 20: An Employee Leaves An Employee Leaves 00:13:00 Module 21: Final Payroll Run Final Payroll Run 00:07:00 Module 22: Reports And Historical Data Reports and Historical Data 00:08:00 Module 23: Year-End Procedures Year-End Procedures 00:09:00 Sage 50 Payroll Intermediate Level Section 01: The Outline View And Criteria The Outline View and Criteria 00:11:00 Section 02: Global Changes Global Changes 00:07:00 Section 03: Timesheets Timesheets 00:12:00 Section 04: Departments And Analysis Departments and Analysis 00:11:00 Section 05: Holiday Schemes Holiday Schemes 00:10:00 Section 06: Recording Holidays Recording Holidays 00:12:00 Section 07: Absence Reasons Absence Reasons 00:13:00 Section 08: Statutory Sick Pay Statutory Sick Pay 00:16:00 Section 09: Statutory Maternity Pay Statutory Maternity Pay 00:17:00 Section 10: Student Loans Student Loans 00:09:00 Section 11: Company Cars Company Cars 00:13:00 Section 12: Workplace Pensions Workplace Pensions 00:21:00 Section 13: Holiday Funds Holiday Funds 00:13:00 Section 14: Roll Back Roll Back 00:03:00 Section 15: Passwords And Access Rights Passwords and Access Rights 00:08:00 Section 16: Options And Links Options and Links 00:10:00 Section 17: Linking Payroll To Accounts Linking Payroll to Accounts 00:08:00 Assignment Assignment - Sage 50 Payroll Complete Course 00:00:00

This Microsoft Word course is designed for all individuals, whether a beginner or someone who is looking into learning about its advanced techniques. This course will drive you from the very basic to the advanced level of Microsoft Word. You will explore how to design, create and customise professional data with Microsoft Word. You will also go through the advanced features and functions that Microsoft Word provides. In this course, you will learn the necessary skills, knowledge, and information of Microsoft Word. Course Highlights Level 3 Diploma in Microsoft Word is an award-winning and the best selling course that has been given the CPD Qualification Standards & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Level 3 Diploma in Microsoft Word into 39 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 1 day, 15 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Level 3 Diploma in Microsoft Word Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Level 3 Diploma in Microsoft Word is CPD Qualification Standards and IAO accredited. 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 backgrounds. Requirements Our Level 3 Diploma in Microsoft Word 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD Qualification Standards and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Word for Beginners Module One - Getting Started FREE 00:30:00 Module Two - Opening Word FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities- Microsoft Word for Beginners Accredited Course 00:00:00 Microsoft Word for Intermediate Level Module One - Getting Started 00:30:00 Module Two - Customizing Word 01:30:00 Module Three - Working with Reusable Content 01:30:00 Module Four - Working with Templates 01:30:00 Module Five - Working with Sections and Linked Content 01:30:00 Module Six - Managing Versions and Tracking Documents 01:30:00 Module Seven - Using Cross References 01:30:00 Module Eight - Creating Mail Merges and Labels 01:30:00 Module Nine - Working with Master Documents 01:30:00 Module Ten - Working with Macros 01:30:00 Module Eleven - Working with Forms 01:30:00 Module Twelve - Wrapping Up 01:00:00 Activities-Accredited Microsoft Word Intermediate Level - IAO & CPD certified 00:00:00 Microsoft Word Advanced Level Module One - Getting Started 00:30:00 Module Two - Working with the Word Window 01:00:00 Module Three - Advanced Editing and Formatting Tasks 01:00:00 Module Four - Working with Illustrations 01:00:00 Module Five - Formatting Pictures 01:00:00 Module Six - Adding SmartArt 01:00:00 Module Seven - Adding Tables 01:00:00 Module Eight - Inserting Special Objects 01:00:00 Module Nine - Working with Document References 01:00:00 Module Ten - Reviewing Your Document 01:00:00 Module Eleven - Using Comments and Tracking 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Accredited Microsoft Word Advanced Level Training 00:00:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Word 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Word 00:30:00