517 Courses

Are you looking to enhance your Microsoft Office All-in-One Package skills? If yes, then you have come to the right place. Our comprehensive course on Microsoft Office All-in-One Package will assist you in producing the best possible outcome by mastering the Microsoft Office All-in-One Package skills. The Microsoft Office All-in-One Package is for those who want to be successful. In the Microsoft Office All-in-One Package, you will learn the essential knowledge needed to become well versed in Microsoft Office All-in-One Package. Our Microsoft Office All-in-One Package starts with the basics of Microsoft Office All-in-One Package and gradually progresses towards advanced topics. Therefore, each lesson of this Microsoft Office All-in-One Package is intuitive and easy to understand. Why would you choose the Microsoft Office All-in-One Package from Compliance Central: Lifetime access to Microsoft Office All-in-One Package materials Full tutor support is available from Monday to Friday with the Microsoft Office All-in-One Package Learn Microsoft Office All-in-One Package skills at your own pace from the comfort of your home Gain a complete understanding of Microsoft Office All-in-One Package Accessible, informative Microsoft Office All-in-One Package learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Microsoft Office All-in-One Package bundle Study Microsoft Office All-in-One Package in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Microsoft Office All-in-One Package Improve your chance of gaining in demand skills and better earning potential by completing the Microsoft Office All-in-One Package Microsoft Office All-in-One Package Curriculum Breakdown of the Microsoft Office All-in-One Package Section 01: Getting Started Section 02: Excel 2021: Basics Section 03: Excel 2021: Rows, Columns, and Cells Section 04: Excel 2021: Data Handling Section 05: Excel 2021: Page Setting Up and Print Section 06: Excel 2021: Sorting and Filtering Section 07: Excel 2021: Writing Formulas Section 08: Excel 2021: Advanced Formulas Section 09: Excel 2021: XLOOKUP only for 2021 and Office 365 Section 10: Excel 2021: Data and Tools Section 11: Excel 2021: Formatting data and tables Section 12: Excel 2021: Pivot Tables Section 13: Excel 2021: Charts Section 14: PowerPoint 2021: Course Introduction Section 15: PowerPoint 2021: Basics Section 16: PowerPoint 2021: Text and Bullet Options Section 17: PowerPoint 2021: Adding Graphic Assets Section 18: PowerPoint 2021: Picture Formatting Section 19: PowerPoint 2021: SmartArt Graphics Section 20: PowerPoint 2021: Working with Tables Section 21: PowerPoint 2021: Working with Charts Section 22: PowerPoint 2021: Adding Multimedia Section 23: PowerPoint 2021: Working with Transition Section 24: PowerPoint 2021: Animation Section 25: PowerPoint 2021: Slideshow Effects Section 26: Word 2021: Introduction Section 27: Word 2021: Basics Section 28: Word 2021: Word Formatting Section 29: Word 2021: Tables Section 30: Word 2021: Styles Section 31: Word 2021: Page Layout Section 32: Word 2021: Envelops and Lables Section 33: Word 2021: Mail Merges Section 34: Word 2021: Review and Printing CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Microsoft Office All-in-One Package helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Microsoft Office All-in-One Package. It is also great for professionals who are already working in Microsoft Office All-in-One Package and want to get promoted at work. Requirements To enrol in this Microsoft Office All-in-One Package, all you need is a basic understanding of the English Language and an internet connection. Career path The Microsoft Office All-in-One Package will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Microsoft Office All-in-One Package. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

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

Everyone thinks that they can bake and decorate a cake, but there's a difference between a homemade cake and a professionally baked and decorated cake that you see displayed in bakery windows. Start your journey through the exciting world of cake decorating and get techniques from the industry experts, with our Cake Decorating Course - Level 4 course. Whether you're keen to take your baking hobby to the next level, or you want to start your own cake baking and decorating service, this cake decoration and design course will teach you the practical skills you need to get started. Throughout this Cake Decorating Course - Level 4, you'll learn expert decorating techniques, including how to sculpt and create breath-taking cakes for various special occasions. Want to get creative with frosting and icing to really impress clients? This cake decorating and design course will teach you the perfect piping techniques to help you out. Enrol today and turn your passion into a profitable business! Benefits of studying Cake Decorating Course - Level 4 with Janets include: Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Learning Outcomes of Cake Decorating Course - Level 4: Discover the techniques, skills, and practical knowledge you need to bake and decorate beautiful cakes for any occasion Explore the history and popular methods of cake decorating to master the art of cake decoration Explore popular cake decorating styles and designs Familiarise with expert cake decorating supplies and equipment Familiarise with classic cake recipes and learn how to recreate those recipes for your personal hobby or business Understand the techniques of frosting, icing and working with chocolates Learn how to create standout stands and displays for layer cake decoration Get expert guidance on starting your own baking and cake decorating business Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Assignment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this course for? This Cake Decorating Course - Level 4 is perfectly designed for the learners who take deep interests in this topic and want to explore the subject and the relevant industry. The course will expedite the newcomers to establish an astounding career in this arena. With this skills and knowledge-based course, anyone can earn expert excellence and move the career forward. Career path After completing this Cake Decorating Course - Level 4 course and with experience, you could progress to the highest standard of this field.

Start your productivity potential! Master Microsoft Office with our comprehensive Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course. Conquer Excel formulas (VLOOKUP, HLOOKUP, XLOOKUP!), design impactful presentations in PowerPoint, and craft professional documents in Word. Take your skills to the next level and unlock a world of opportunity. Enrol now and become a Microsoft Office pro!

Master Microsoft Office 2021 with our comprehensive course. From Excel to PowerPoint and Word, learn essential tools and techniques for enhanced productivity and efficiency.

Duration 4 Days 24 CPD hours This course is intended for This intermediate course is designed for technical support personnel who implement, operate, and perform day-to-day administration of IBM MQ V8 on z/OS. Overview Describe message-oriented middleware and the capabilities it must provideIdentify the key components of IBM MQ for z/OSSummarize the responsibilities of the IBM MQ administratorConfigure IBM MQ IBM V8 for z/OSEnable IBM MQ for z/OS eight-byte RBA and buffers above 2 GBDemonstrate how to create and change queues and place and retrieve messages from a queueDefine and demonstrate how to set up and work with distributed queuingDifferentiate between an IBM MQ queue manager and an IBM MQ clientDescribe and demonstrate how to set up an IBM MQ clusterContrast point-to-point and publish/subscribe messaging stylesDescribe shared queues and queue sharing groupsSummarize IBM MQ for z/OS recovery and restart activitiesDemonstrate how to use IBM MQ events for monitoringSummarize performance considerationsDescribe security considerations for IBM MQ for z/OSDescribe and implement connection authentication and channel authorizationIdentify correct problem determination techniques for IBM MQ for z/OSSummarize basic use and configuration of IBM MQ Managed File TransferDescribe IBM MQ support for CICS and IMS interfaces This course provides the skills that are necessary to configure and manage an IBM MQ V8 queue manager on z/OS. Through lectures and hands-on lab exercises, students learn how to install, customize, operate, and administer IBM MQ V8. Course Outline Course introduction IBM MQ review IBM MQ architecture, installation, and configuration Exercise: Configuring an IBM MQ for z/OS queue manager IBM MQ for z/OS administrative interface options Exercise: Working with queues Distributed queuing Exercise: Working with channels IBM MQ clients Exercise: Working with IBM MQ clients IBM MQ cluster basics Exercise: Working with IBM MQ clusters Publish/subscribe basics Exercise: Publish/subscribe basics Queue sharing groups Using IBM MQ events and the dead-letter queue utility Exercise: Working with IBM MQ events Security considerations Exercise: Security Problem determination IBM MQ Managed File Transfer Exercise: IBM MQ Managed File Transfer configuration for z/OS IBM MQ for z/OS backup, recovery, and related file tasks Exercise: Working with file handling utilities Support for CICS, IMS, and HTTP applications Course summary

Duration 3 Days 18 CPD hours This course is intended for This intermediate-level hands-on course is geared for experienced Administrators, Analysts, Architects, Data Scientists, Database Administrators and Implementers Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our Oracle Certified expert facilitator, students will learn how to: Administer ODI resources and setup security with ODI Apply ODI Topology concepts for data integration Describe ODI Model concepts Describe architecture of Oracle Data Integrator Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations Explore, audit data, and enforce data quality with ODI Implement Changed Data Capture with ODI Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements from high-volume, high-performance batch loads, to event-driven integration processes and SOA-enabled data services. Oracle Data Integrator's Extract, Load, Transform (E-LT) architecture leverages disparate RDBMS engines to process and transform the data - the approach that optimizes performance, scalability and lowers overall solution costs. Throughout this course participants will explore how to centralize data across databases, performing integration, designing ODI Mappings, and setting up ODI security. In addition, Oracle Data Integrator can interact with the various tools of the Hadoop ecosystem, allowing administrators and data scientists to farm out map-reduce operations from established relational databases to Hadoop. They can also read back into the relational world the results of complex Big Data analysis for further processing. Working in a hands-on learning environment led by our Oracle Certified expert facilitator, students will learn how to: Administer ODI resources and setup security with ODI Apply ODI Topology concepts for data integration Describe ODI Model concepts Describe architecture of Oracle Data Integrator Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations Explore, audit data, and enforce data quality with ODI Implement Changed Data Capture with ODI Introduction to Integration and Administration Oracle Data Integrator: Introduction Oracle Data Integrator Repositories Administering ODI Repositories Create and connect to the Master Repository Export and import the Master Repository Create, connect, and set a password to the Work Repository ODI Topology Concepts ODI Topology: Overview Data Servers and Physical Schemas Defining Topology Agents in Topology Planning a Topology Describing the Physical and Logical Architecture Topology Navigator Creating Physical Architecture Creating Logical Architecture Setting Up a New ODI Project ODI Projects Using Folders Understanding Knowledge Modules Exporting and Importing Objects Using Markers Oracle Data Integrator Model Concepts Understanding the Relational Model Understanding Reverse-Engineering Creating Models Organizing ODI Models and Creating ODI Datastores Organizing Models Creating Datastores Constraints in ODI Creating Keys and References Creating Conditions Exploring Your Data Constructing Business Rules ODI Mapping Concepts ODI Mappings Expressions, Join, Filter, Lookup, Sets, and Others Behind the Rules Staging Area and Execution Location Understanding Knowledge Modules Mappings: Overview Designing Mappings Multiple Sources and Joins Filtering Data Overview of the Flow in ODI Mapping Selecting a Staging Area Configuring Expressions Execution Location Selecting a Knowledge Module Mappings: Monitoring and Troubleshooting Monitoring Mappings Working with Errors Designing Mappings: Advanced Topics 1 Working with Business Rules Using Variables Datasets and Sets Using Sequences Designing Mappings: Advanced Topics 2 Partitioning Configuring Reusable Mappings Using User Functions Substitution Methods Modifying Knowledge Modules Using ODI Procedures Procedures: Overview Creating a Blank Procedure Adding Commands Adding Options Running a Procedure Using ODI Packages Packages: Overview Executing a Package Review of Package Steps Model, Submodel, and Datastore Steps Variable Steps Controlling the Execution Path Step-by-Step Debugger Starting a Debug Session New Functions Menu Bar Icons Managing ODI Scenarios Scenarios Managing Scenarios Preparing for Deployment Using Load Plans What are load plans? Load plan editor Load plan step sequence Defining restart behavior Enforcing Data Quality with ODI Data Quality Business Rules for Data Quality Enforcing Data Quality with ODI Working with Changed Data Capture CDC with ODI CDC implementations with ODI CDC implementation techniques Journalizing Results of CDC Advanced ODI Administration Setting Up ODI Security Managing ODI Reports ODI Integration with Java