3644 Office Skills & Productivity courses

Duration 5 Days 30 CPD hours This course is intended for This course is aimed at consultants, project managers, project team members and key users. In this course, participants learn about the fundamental business processes in sales and distribution. Participants learn how to perform the most important functions in the process chain, from presales to customer payment, in the SAP system. Course Outline Organizational structures in sales and distribution Working with the relevant master data for the processes Overview of the process chain Introduction to the availability check Sales and distribution processing with make-to-order production Complaints processing Introduction to sales and distribution reporting Additional course details: Nexus Humans SCM600 SAP Sales Order Management 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 SCM600 SAP Sales Order Management 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.

Duration 3 Days 18 CPD hours This course is intended for Project team members In this course, students learn how to successfully set up functions and customizing settings for pricing in Sales and Distribution. Course Outline Condition technique for definition and maintenance of prices, surcharges and discounts Creating condition tables, access sequences, and condition types Using prices and other conditions in sales documents Promotions and sales deals Introduction to rebate processing

Duration 5 Days 30 CPD hours This course is intended for Application Consultants, Business Analysts, and Solution Architects. Overview Gain a detailed knowledge of using the functions and customizing settings in sales. This course is ideal for students requiring detailed knowledge about customizing of sales processes and basic functions. Introduction to the Sales and Distribution Process Processing Sales Documents Enterprise Structures in Sales and Distribution Setting Up Enterprise Structures Sales Order Processing Identifying Sources of Document Data Using Additional Functions During Sales Order Processing Sales Document Customizing Controlling Sales Processes Defining Sales Document Types Applying Item Categories Interpreting the Item Category Determination Using Bills of Material in Sales Documents Applying Schedule Line Categories Interpreting the Schedule Line Category Determination Data Flow Interpreting the Document Flow of Sales Processes Setting Up the Copying Control Special Business Processes Executing Special Business Processes Incomplete Documents Handling Incomplete Documents Setting Up an Incompletion Procedure Business Partners Using Partner Functions in Sales and Distribution Processes Setting Up Partner Determination Procedures Outline Agreements Using Different Types of Outline Agreements Interpreting the Set-Up of Value Contracts Setting Up Specific Contract Data Material Determination Setting Up Material Determination Material Listing and Exclusion Setting Up Master Data for Material Listing / Exclusion Free Goods Setting Up the Determination of Free Goods Sales Scenarios Setting Up a Cash Sales Scenario Controlling the Usage of Bills of Material in a Sales Order Setting Up a Material Determination Scenario Additional course details: Nexus Humans SCM605 SAP Sales Processing in SAP ERP 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 SCM605 SAP Sales Processing in SAP ERP 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.

Duration 2 Days 12 CPD hours This course is intended for Project team members & consultants In this course, students learn how to set up the billing interface points between sales and distribution and financial accounting. Course Outline Forms of billing in SD Methods for creating billing documents Methods for creating billing documents Invoice lists Billing plans and down payments Revenue account determination Special features of the SD/FI interface Additional course details: Nexus Humans SCM615 SAP Sales and Customer Service 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 SCM615 SAP Sales and Customer Service 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.

Duration 3 Days 18 CPD hours This course is intended for Application consultants Overview In this course, participants use and customize functions in delivery processing. In this course, students learn the customizing settings of delivery documents and the set-up of corresponding functions. Idea and Function of the Delivery Document Explaining the Concept and Structure of the Delivery Document Basic Organizational Units for the Delivery Process Maintaining the Organizational Units for Delivery Processes Controlling Deliveries Controlling Delivery Documents The Goods Issue Process Based on the Delivery Adjusting Automatic Determination of Relevant Fields for Outbound Delivery Creation Adjusting Delivery and Transportation Scheduling Processing Outbound Deliveries Using the Outbound Delivery Monitor Processes and Functions based on the Delivery Picking Outbound Deliveries Packing Materials Handling Goods Issues Using Special Functions in Deliveries Further Application Areas of the Delivery Document Transferring Stock Between Plants Performing Goods Receipts Using Deliveries Specified Delivery Scenario Setting Up a Specified Delivery Scenario

Duration 1 Days 6 CPD hours This course is intended for This course is designed for all levels of experience in using Microsoft Project, as well as all levels of experience in project management. In particular, this course is designed for persons who need to author Microsoft Project work schedules including Project Managers and Project Assistants. Overview To be properly introduced, or reintroduced, to Microsoft Project. To gain an understanding of a proven mindset Microsoft Project users should possess each time they open and work Microsoft Project schedules. To gain an understanding of globally accepted project management principles. To be able to effectively apply Microsoft Project into the Initiation and Planning phases of a normal project life cycle. MS Project: Project Initiation and Planning (part 1 of a 3 part series) course provides proven tools and techniques for successfully using Microsoft Project to assist with managing projects. MS Project: Project Initiation and Planning (part 1 of a 3 part series) course provides proven tools and techniques for successfully using Microsoft Project to assist with managing projects.

Duration 4 Days 24 CPD hours This course is intended for Project administrators and ETL developers responsible for data extraction and transformation using DataStage. Overview Describe the uses of DataStage and the DataStage workflowDescribe the Information Server architecture and how DataStage fits within itDescribe the Information Server and DataStage deployment optionsUse the Information Server Web Console and the DataStage Administrator client to create DataStage users and to configure the DataStage environmentImport and export DataStage objects to a fileImport table definitions for sequential files and relational tablesDesign, compile, run, and monitor DataStage parallel jobsDesign jobs that read and write to sequential filesDescribe the DataStage parallel processing architectureDesign jobs that combine data using joins and lookupsDesign jobs that sort and aggregate dataImplement complex business logic using the DataStage Transformer stageDebug DataStage jobs using the DataStage PX Debugger This course enables the project administrators & developers to acquire the skills necessary to develop parallel jobs in DataStage. Students will learn to create parallel jobs that access sequential & relational data, and combine and transform the data. Course Outline Introduction to DataStage Deployment DataStage Administration Work with Metadata Create Parallel Jobs Access Sequential Data Partitioning and Collecting Algorithms Combine Data Group Processing Stages Transformer Stage Repository Functions Work with Relational Data Control Jobs

The SharePoint Foundation Advanced Skills is organised into 6 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 4 hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Why Choose This Course Earn an e-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 Full Tutor Support on Weekdays 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 Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post.  Course Content SharePoint Libraries Changing the Look and Feel Customizing a Site Controlling Information Display Creating Workflows Adding to Site Galleries

Be an expert professional in using Microsoft Access with the Microsoft Access - Beginners, Intermediate & Advanced course. Microsoft Access is a database management system that helps you to store information for reference, reporting, and analysis. Using this information management tool, you can able to analyze large amounts of information, and manage related data more quickly. The course starts by explaining the very basic features of Microsoft Access which will be later followed on the advanced features. Therefore the course is suitable for the novice to the advanced learners who want to exceed their skill. The course teaches you how to work with queries, forms, reports, and how to work with Macros, advanced database apps, and more. Who is this Course for? Microsoft Access - Beginners, Intermediate & Advanced is 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. 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. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Microsoft Access for Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Access 01:00:00 Module Three - An Introduction to Databases 01:00:00 Module Four - Sharing Data Using Apps 01:00:00 Module Five - Working in Your App 01:00:00 Module Six - An Introduction to Desktop Databases 01:00:00 Module Seven - Performing Basic Table Tasks 01:00:00 Module Eight - Working with Fields 01:00:00 Module Nine - Working with Table Relationships 01:00:00 Module Ten - An Introduction to Queries, Forms, and Reports 01:00:00 Module Eleven - Protecting Your Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access for Beginners 00:00:00 Microsoft Access for intermediate level Module One - Getting Started 00:30:00 Module Two - Creating a Custom App 01:00:00 Module Three - Customizing App Actions 01:00:00 Module Four - Customizing Your App Views with Macros 01:00:00 Module Five - Working with Validation Rules and Messages 01:00:00 Module Six - Working with Macros 01:00:00 Module Seven - Advanced Query Tasks 01:00:00 Module Eight - Designing Forms 01:00:00 Module Nine - Advanced Reporting Tasks 01:00:00 Module Ten - Advanced Database Tools 01:00:00 Module Eleven - Working with the Access Environment 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access Intermediate Level 00:00:00 Microsoft Access Advanced Level Module One - Getting Started 00:30:00 Module Two - Using App Views 01:00:00 Module Three - Customizing Apps, Part One 01:00:00 Module Four - Customizing Apps, Part Two 01:00:00 Module Five - Working with More Record Tasks 01:00:00 Module Six - Using Advanced Field Tasks 01:00:00 Module Seven - Working in Table Design View 01:00:00 Module Eight - Working with the Expression Builder 01:00:00 Module Nine - Working with External Data 01:00:00 Module Ten - Creating Queries 01:00:00 Module Eleven - Creating Forms and Reports 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Access - Beginners, Intermediate, Advanced 00:30:00 Final Exam Final Exam- Microsoft Access - Beginners, Intermediate, Advanced 00:30:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

If databases were kingdoms, SQL Server would be the crown jewel—and this bootcamp helps you understand why. Whether you're a curious beginner or someone who once dabbled in database queries, this course introduces you to Microsoft SQL Server in a way that feels both structured and digestible. From creating databases to querying data with finesse, you'll gain a clear understanding of how SQL Server works—without needing to download every technical manual Microsoft ever wrote. This course doesn't drown you in jargon or drag you into a tech fog. Instead, it’s paced with clarity, peppered with useful insights, and designed to help you genuinely grasp how to manage data efficiently. You'll learn key SQL concepts, explore table relationships, get to know stored procedures, and understand the logic that powers business intelligence—all while keeping your learning screen-based and refreshingly jargon-free. Let’s face it: data isn’t going anywhere, so you might as well learn to speak its language. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Course Curriculum: Microsoft SQL Server Bootcamp 2022 Section 01: Getting Started Section 02: SQL Server setting up Section 03: SQL Database basic Section 04: SQL DML (Data Manipulation Language) Section 05: SQL DDL (Data Definition Language) Section 06: SQL DCL (Data Control Language) Section 07: SQL Statement Basic Section 08: Filtering Data rows Section 09: Aggregate functions Section 10: SQL Query statements Section 11: SQL Group by statement Section 12: JOINS Section 13: SQL Constraints Section 14: Views Section 15: Advanced SQL commands Section 16: SQL Stored procedures Section 17: Import & Export data Section 18: Backup and Restore Database Course Assessment To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%. When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme. Certification Once you have finished the course, you will be eligible to apply for a CPD QS accredited certificate as proof of your new skills and your continued professional development. Certificates are available as PDF for £9, or you can request a hard copy to be sent in the post for £15. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). Who is this course for? This Microsoft SQL Server Bootcamp 2022 course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This Microsoft SQL Server Bootcamp 2022 course is open to all, with no formal entry requirements. Career path Upon successful completion of the Microsoft SQL Server Bootcamp 2022 Course, learners will be equipped with many indispensable skills and have the opportunity to grab.