3417 Office Skills & Productivity courses in Ponteland delivered Online

Duration 5 Days 30 CPD hours This course is intended for Application Consultants, Business Analysts, Program/Project Managers, System Architects Overview At the end of this course, students will be able to explain and use major features of SAP Extended Warehouse Management. This course will give you a solid fundamental and comprehensive overview of SAP Extended Warehouse Management and is a mandatory prerequisite for all other EWM courses. Warehousing Structures and Master Data Differentiating the SAP Solutions for Warehouse Management Outlining Organizational Structures Maintaining Master Data for SAP EWM Warehouse Monitoring & Processing with Mobile Devices Managing the Warehouse Outlining the Radio Frequency (RF) Framework Additional Functions in SAP EWM Applying Storage Control Employing Serial Numbers Processing Batches Mapping Quality Inspection Processes Applying Value-Added Services Warehouse Organization Performing Slotting Applying Replenishment Methods Performing a Physical Inventory Optimization of Resources Applying Wave Management Applying Labor Management Executing the Production Supply Process Executing Expected Goods Receipts Processes Applying Cross Docking Warehouse Extensions Planning the Shipping and Receiving of Products Controlling the Material Flow System (MFS) SAP EWM Rapid Deployment Solution Accelerating Implementation Processes Combined Inbound and Outbound Processes Executing an End-to-End Process with SAP EWM

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course are Application Consultants, Developers, Developer Consultants, and Technology Consultants. Overview Define Data ServicesDefine Source and Target ConnectionsTrace, Validate, and Debug Data Services JobsUse Data Services TransformsImplement Change Data Capture in Data Services In this course, students will learn how to define data services, source, and target connections, as well as use data services transforms and implement change in data capture within data services. Data Services Defining Data Services Source and Target Metadata Defining Datastores in Data Services Defining a Data Services Flat File Format Batch Job Creation Creating Batch Jobs Batch Job Troubleshooting Writing Comments with Descriptions and Annotations Validating and Tracing Jobs Debugging Data Flows Auditing Data Flows Functions, Scripts, and Variables Using Built-In Functions Using Variables, Parameters, and Scripts Platform Transforms Using Platform Transforms Using the Map Operation Transform Using the Validation Transform Using the Merge Transform Using the Case Transform Using the SQL Transform Error Handling Setting Up Error Handling Changes in Data Capturing Changes in Data Using Source-Based Change Data Capture (CDC) Using Target-Based Change Data Capture (CDC) Data Services (Integrator) Platform Transforms Using Data Services (Integrator) Platform Transforms Using the Pivot Transform Using the Data Transfer Transform Additional course details: Nexus Humans DS10 SAP Data Services - Platform and Transforms training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the DS10 SAP Data Services - Platform and Transforms course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Master VLOOKUP in Excel in just 60 minutes! From menus to list comparisons, learn essential VLOOKUP skills fast.

Description: The knowledge of Microsoft Word is a must for both employee and business owners. Even students, teachers, researchers and people from all background need to know the application because of its versatile use. The advanced course on Microsoft Word allows the learner to know the advanced features of the most used program. Microsoft Word 2016 Advanced will teach you the procedures for creating more advanced documents. You will know how to add reference marks or notes, the ways of simplifying and managing large contents, how to create forms, how to secure a document or how to handle document versions. After completing the course, you will know almost all the advanced techniques for creating an outstanding document. Learning Outcomes: Changing user information, sharing documents, working with comments and comparing document changes Collaborate on documents by reviewing them, merging changes and co-authoring Discover how to best use reference tools, like captions, cross-references, bookmarks, hyperlinks, footnotes, endnotes, citations and bibliographies Working with master documents and subdocuments Adding cover page; creating an index, table of contents, and ancillary tables; and managing outlines to simplify and manage large documents Suppressing information from a document, setting editing restrictions, adding digital signature platforms, and restricting document access Find out techniques for saving and exporting form data, along with creating and manipulating forms Using SharePoint Server with Word in order to create, compare and combine different document versions 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 Word 2016 Advanced 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 Word 2016 Advanced 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. Collaborating on Documents Modify User Information 00:15:00 Share a Document 00:30:00 Work with Comments 00:15:00 Compare Document Changes 00:15:00 Review a Document 00:15:00 Merge Document Changes 00:15:00 Coauthor Documents 00:15:00 Adding Reference Marks and Notes Add Captions 00:15:00 Add Cross-References 00:15:00 Add Bookmarks 00:15:00 Add Hyperlinks 00:15:00 Insert Footnotes and Endnotes 00:15:00 Add Citations 00:30:00 Insert a Bibliography 00:15:00 Simplifying and Managing Long Documents Insert Blank and Cover Pages 00:15:00 Insert an Index 00:30:00 Insert a Table of Contents 00:30:00 Insert an Ancillary Table 00:15:00 Manage Outlines 00:30:00 Create a Master Document 00:30:00 Securing a Document Suppress Information 00:30:00 Set Editing Restrictions 00:30:00 Add a Digital Signature to a Document 00:15:00 Restrict Document Access 00:15:00 Forms Create Forms 00:30:00 Manipulate Forms 00:15:00 Form Data Conversion 00:15:00 Managing Document Versions Create a New Document Version 00:30:00 Compare Document Versions 00:15:00 Merge Document Versions 00:15:00 Activities Activities - Microsoft Word 2016 Advanced 00:00:00 Mock Exam Mock Exam- Microsoft Word 2016 Advanced 00:20:00 Final Exam Final Exam- Microsoft Word 2016 Advanced 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: By this Microsoft Office 2016 Word Advanced Level - Complete Video Course you will be introduce with the advanced level of Microsoft Word 2016. This advanced level will help you to broad up your knowledge which you got from the intermediate level. Here you will learn how to work with tables of content, footnotes and endnotes, how to insert bibliographies and indexes, how to use comments, track changes including accepting and rejecting changes, compare and combine documents, how to use mail merge and create envelope and labels, protect document ,use bookmarks, add watermarks, and customize the Ribbon, and more. You can join this course, if you have intermediate skills and knowledge with Microsoft Word 2016 and want to take another step forward or want to learn the topics covered in this course in the 2016 interface. So, don't be late, come and join this course now. 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 Office 2016 Word Advanced Level - 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 Office 2016 Word Advanced Level - 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. Manipulating Images Integrate Pictures and Text FREE 00:15:00 Adjust Image Appearance 00:09:00 Insert Other Media Elements 00:02:00 Using Custom Graphic Elements Create Text Boxes and Pull Quotes 00:06:00 Add WordArt and Other Text Effects 00:05:00 Draw Shapes 00:07:00 Create Complex Illustrations with SmartArt 00:08:00 Collaborating on Documents Prepare a Document for Collaboration 00:09:00 Mark Up a Document 00:06:00 Review Markups 00:04:00 Merge Changes from Other Documents 00:06:00 Adding Document References and Links Add Captions 00:06:00 Add Cross References 00:08:00 Add Bookmarks 00:05:00 Add Hyperlinks 00:06:00 Insert Footnotes and Endnotes 00:05:00 Add Citations and a Bibliography 00:11:00 Securing a Document Suppress Information 00:07:00 Set Formatting and Editing Restrictions 00:06:00 Restrict Document Access 00:02:00 Add a Digital Signature to a Document 00:04:00 Using Forms to Manage Content Create Forms 00:09:00 Modify Forms 00:03:00 Automating Repetitive Tasks with Macros Automate Tasks by Using Macros 00:10:00 Create a Macro 00:19:00 Mock Exam Mock Exam- Microsoft Office 2016 Word Advanced Level - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Word Advanced Level - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: In this course, you will learn the necessary expert skills, knowledge, and information about Word 2010. This course will help you utilize the most advanced tools and features for your documents. You will learn how to edit and develop documents like an expert. Learn to take advantage of the many customization options in the Word Options dialogue box. You will know how master documents allow you to use smaller files to create a large, complicated document. Who is the course for? Professionals who want to learn about the Word 2010 People who have an interest in the features of Word 2010 Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft Word 2010 Intermediate Level course is a useful qualification to possess and would be beneficial for professions or careers from industries which are: Administrative Assistant PA Secretary Administrator Office Manager. Microsoft Word 2010 Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Document Information and Word Customization 01:00:00 Module Three - Working with Reusable Content 01:00:00 Module Four - Working with Templates 01:00:00 Module Five - Working with Sections and Linked Content 01:00:00 Module Six - Managing Versions and Tracking Documents 01:00:00 Module Seven - Using Cross References 01:00:00 Module Eight - Working with Mail Merges 01:00:00 Module Nine - Working with Master Documents 01:00:00 Module Ten - Working with Macros 01:00:00 Module Eleven - Working with Forms 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities Activities - Microsoft Word 2010 Intermediate Level 00:00:00 Mock Exam Mock Exam- Microsoft Word 2010 Intermediate Level 00:20:00 Final Exam Final Exam- Microsoft Word 2010 Intermediate Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Think your slides are just there to hold text? Think again. Whether you're pitching a plan or sharing a birthday quiz, Microsoft PowerPoint is your not-so-secret weapon for turning plain ideas into polished, professional visuals. This course strips away the waffle and gets straight into what matters – building presentations that look sharp, sound smart and don’t send your audience to sleep. From smart layouts to slick animations, you’ll get to know the tools that make even the most number-heavy talk feel like a TED moment. With a clear, user-friendly approach, the Microsoft PowerPoint Course guides you through each feature in a way that actually makes sense. No jargon, no drama – just straightforward lessons that show you how to save time, stay organised and create decks that get the job done. Whether you’re working solo or presenting to a crowd over Zoom, this course helps you handle PowerPoint like it’s second nature. Because when your slides are spot-on, everything else feels a bit easier too. Enroll now and unleash your potential! This bundle includes the following courses: Course 01: Microsoft PowerPoint Presentation: Slide Creation Course 02: Microsoft PowerPoint Beginner to Expert Level (Gift) Course 03: Public Speaking (Gift) Course 03: Life Coaching(Gift) Key Features Accredited by CPD Instant e-certificate Fully online, interactive Microsoft PowerPoint course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Enrol now in this Microsoft PowerPoint course to excel! How You will be Benefited from Microsoft PowerPoint Bundle All through this self-paced training, you will get engaging learning materials and acquire the necessary knowledge to work with various concepts to gain a competitive advantage in the employment market. Course Curriculum: Microsoft PowerPoint for Beginner Module 01: Microsoft Word Essentials Module 02: Microsoft Powerpoint Essentials Module 03: Microsoft Outlook Essentials Module 04: Microsoft Excel Keyboard Shortcuts Power Point Presentation: Slide Creation Module 01: Introduction and Welcome Module 02: Map Out Your Message Module 03: Add Variety to Your Visuals Module 04: Additional Material Public Speaking Module 01: Effective Communication Module 02: How to Talk to Anyone Module 03: Power of Storytelling Module 04: Becoming an Influencer Module 05: Importance of Body Language Module 06: Communication Skills for Job Interviews Module 07: Public Speaking Life Coaching Module 01: Life Coaching: The Purpose and Fundamentals Module 02: Develop Your Self-Awareness Module 03: The Development of Core Beliefs and Managing Fears Module 04: Life Coaching Types and Key Attributes of a Life Coach Module 05: Understanding Emotional Intelligence Module 06: Body Language and Communication Techniques Module 07: A Structure for Client Work and Goal Setting Module 08: Basic Principles for Business Development and Growth Module 09: The Ethical Coach: Protect Yourself and Your Clients Learning Outcomes: Create captivating PowerPoint presentations with diverse visual elements. Master the art of persuasive storytelling for effective communication. Enhance public speaking skills and confidence in various settings. Develop a strong understanding of life coaching principles and techniques. Apply advanced PowerPoint features to convey messages with impact. Cultivate self-awareness and emotional intelligence for personal growth. Accreditation All of our courses included in this Microsoft PowerPoint bundle are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Microsoft PowerPoint course, you will immediately be sent digital certificates for the bundle courses. CPD 40 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Microsoft PowerPoint Course can be taken by anyone who wants to understand more about the topic. With the aid of this course, you will be able to grasp the fundamental knowledge and ideas. Additionally, this Microsoft PowerPoint Course is ideal for: Individuals seeking career advancement in various industries. Entrepreneurs aiming to enhance their presentation and communication skills. Students preparing for job interviews and professional networking. Professionals interested in exploring the field of life coaching. Anyone eager to master PowerPoint for personal and professional growth. Requirements Learners do not require any prior qualifications to enrol on this Microsoft PowerPoint Course. You just need to have an interest in Microsoft PowerPoint Course. Career path After completing this Microsoft PowerPoint Course you will have a variety of careers to choose from. The following job sectors of Microsoft PowerPoint Course are: Marketing Executive - £25K to 45K/year. Business Development Manager - £30K to 60K/year. Training and Development Specialist - £25K to 50K/year. HR Consultant - £25K to 55K/year. Executive Coach - £40K to 80K/year. Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Sage 50 Payroll Basics course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Sage 50 Payroll Basics course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Sage 50 Payroll Basics and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Sage 50 Payroll Basics course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Sage 50 Payroll Basics course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path The Sage 50 Payroll Basics will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Sage 50 Payroll Basics Module 1: Payroll Basics 00:10:00 Module 2: Company Settings 00:08:00 Module 3: Legislation Settings 00:07:00 Module 4: Pension Scheme Basics 00:06:00 Module 5: Pay Elements 00:14:00 Module 6: The Processing Date 00:07:00 Module 7: Adding Existing Employees 00:08:00 Module 8: Adding New Employees 00:12:00 Module 9: Payroll Processing Basics 00:11:00 Module 10: Entering Payments 00:12:00 Module 11: Pre-Update Reports 00:09:00 Module 12: Updating Records 00:09:00 Module 13: e-Submissions Basics 00:09:00 Module 14: Process Payroll (November) 00:16:00 Module 15: Employee Records and Reports 00:13:00 Module 16: Editing Employee Records 00:07:00 Module 17: Process Payroll (December) 00:12:00 Module 18: Resetting Payments 00:05:00 Module 19: Quick SSP 00:10:00 Module 20: An Employee Leaves 00:13:00 Module 21: Final Payroll Run 00:07:00 Module 22: Reports and Historical Data 00:08:00 Module 23: Year-End Procedures 00:09:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

This one-day workshop is intended for participants who have a basic understanding of Outlook but who want to know how to use its advanced features to manage their email communications, calendar events, contact information and other communication tasks. This course will help participants: Gain confidence using Outlook and its advanced features Organise and prioritise email messages Archive messages for safe-keeping Use rules to process received or sent messages automatically Manage scheduled meetings with others Give others permission to view and manage their folders and items Use contacts and commands to find out more about a person or company Prioritise work-flow using tasks and assigning tasks to others 1 Email messages Combining multiple clicks with quick steps Following up flag options Saving multiple attachments Attaching a folder of files Recalling and replacing a message Categorising messages with conditional formatting 2 Message options Adding options to messages Marking a message as private Receiving quick responses with voting buttons Directing replies to specific users Delaying sent messages Inserting links in messages 3 Stay organised with rules Using rules to automate message flow Moving messages with rules Using the rules wizard Setting up rules with conditions Using rules that work whilst you are away 4 Message clean-up Using conversation clean-up Using mailbox clean-up Moving messages to the archive folder Archiving folder properties Auto-archiving properties 5 Managing calendars Creating calendar groups Sharing calendars with permissions Setting up working days and times Managing time zones Categorise appointments with conditional formatting Publishing a calendar 6 Schedule meetings Scheduling a meeting Managing meeting responses Proposing new meeting times Adding attendees to a meeting Viewing multiple appointments 7 Using contacts Merging contacts to letters Merging contacts to labels Mail merging contacts in Word Exporting contacts to Excel 8 Managing tasks Organising your workload with tasks Categorising tasks Assigning tasks to others Sending a task status report Allocating time for tasks Regenerating a new task Viewing your tasks in the calendar 9 Adding message items Adding calendars to messages Adding business cards to messages 10 Email accounts Adding multiple user accounts Adding account permissions

This one-day introduction workshop is intended for users who need to get to grips with the essentials of Microsoft Outlook. It will provide you with the basic skills you need to effectively start using Outlook to manage your emails, calendar, contacts, tasks and notes. This course will help participants: Send messages with added email options applied Quickly file messages away for safe keeping Manage messages and attachments Organise calendar meetings and check other people's schedules Respond to a meeting request Create a contacts list Manage daily tasks Use reading and folder panes Create and manage folders Use auto reply Use notes Utilise Outlook's printing functionality 1 Getting started Using the reading pane Using the folder pane Changing inbox views Managing the to-do bar 2 Emailing messages Replying to and forwarding messages Adding message options Attaching files to an email message Opening and saving attachments 3 Outlook folders Creating and managing folders Moving messages into folders Adding folders to favourites Using search folder Always moving messages in conversation Automatically move messages with rules 4 Managing messages Using instant search Finding messages by criteria Grouping and sorting messages Categorising messages Adding message follow up flags Filtering messages with the people pane 5 Using auto reply Replying to messages whilst you are away Managing auto reply settings Applying rules to auto reply 6 Outlook calendars Adding and editing appointments Adding calendar reminders Moving and copying appointments Creating all day events Recurring appointments Sharing your calendar Opening another user's calendar 7 Planning a meeting Arranging meetings Inviting attendees to meetings Responding to meeting invites 8 Outlook contacts Creating and editing a contact Saving emails as contacts Finding contacts Sending messages to contacts Creating contact groups 9 Adding tasks Creating and editing tasks Completing tasks Assigning a task to another user Responding to a task request 10 Notes Creating and editing tasks Emailing notes Sticking notes on your desktop 11 Printing Printing messages Printing calendars Printing contacts