3404 Office Skills & Productivity courses in Kirkby delivered Online

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

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this class are Application Consultants, Business Process Architects, Business Process Owners/Team Leads/Power Users, and Program/Project Managers Overview Explore settings to map requirements in the area of Sales and Distribution (S&D) that require knowledge of cross-application Customizing functionsUnderstand and consider complex relationships in mapping organizational structuresConfigure and adapt special functions like copy control, text control, output controlUnderstand system modification options and personalization techniques This course is ideal for students who are requiring detailed cross-application configuration knowledge to map requirements integrated to sales and distribution. Copy Control Modifying Copy Control Text Control Identifying Text Sources Configuring Text Control Output Adjusting Output Determination Adjusting Output Types Using PDF-Based Forms in the Sales Process Enhancements & Modifications Using Enhancement Technology Adjusting the Screen Setup of a Transaction Using Table Controls Adjusting Lists in Sales and Distribution Controlling Customer Master Data Using Account Groups Adjusting the Screen Setup of a Transaction Using Transaction Variants Adding New Fields Performing System Modifications Using Classic Enhancement Technology Performing System Modifications Using the Enhancement Framework Additional course details: Nexus Humans SCM650 SAP Cross-Functional Customizing in Sales and Distribution 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 SCM650 SAP Cross-Functional Customizing in Sales and Distribution 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 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 3 Days 18 CPD hours This course is intended for This course is designed for operators and schedulers who perform duties that are related to batch workload automation. Overview In this course, you learn how to perform the following tasks:Explain the production terminology used with IBM Workload Scheduler and its production planning processMonitor production batch workload processesManage production batch workloadCreate and modify scheduling objectsSchedule new workloadsForecast future workloadsMigrate workload definitions from test to production environmentsCreate and maintain reports about production workloads This course provides professional report authors an opportunity to learn report building techniques using relational data models. Demonstrations and exercises will illustrate and reinforce key concepts during this learning opportunity. IBM Workload Scheduler Introduction About Workload Automation IBM workload automation offerings IBM Workload Scheduler terminology Workload Scheduler user interfaces Getting started with Application Lab Getting started with the Dynamic Workload Console Connecting the console to Workload Scheduler Getting started with the command-line interfaces Using the Application Lab Interface Using the processes status overview page Managing processes Using other Application Lab functions Monitoring Workload Scheduler Production Monitoring Workload Scheduler production by using queries Using the Workload Dashboard Monitoring system status and health Monitoring plan objects Using the What-if Analysis interface Monitoring the plan graphically Managing Workload Scheduler Production Managing the scheduling environment Managing scheduling objects in the plan Creating Scheduling Objects Using the Workload Designer Creating scheduling objects Creating variables and variable tables Creating prompts and resources Creating calendars Defining jobs Scheduling, Forecasting, and Migrating Workloads Creating job streams Applying jobs to job streams Setting time and date restrictions Using advanced scheduling options Creating job stream definitions by using composer Creating and using event rules Forecasting and previewing future dates Exporting and importing scheduling definitions Using Workload Application Templates Reporting with Workload Scheduler Using reporting features Using Common Reporting with Workload Scheduler Using the batch reporting utility Using the preformatted text-based report utilities

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 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.

Description: Microsoft Excel is claimed as the most-used spreadsheet program in the world. Through this course, you will understand that the web app is designed to make a few edits available anywhere as long as you are online. Know how to use Excel 2010 to do more complicated edits and learn using cell references instead of numbers in your formulas and functions. This course will help you in enhancing all your knowledge about Excel to become more efficient in your daily work. Who is the course for? Professionals who want to learn about Microsoft Office 365 Excel Web App features. People who have an interest in knowing all the essentials in Office 365 Excel Web App. 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 hardcopy 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 recognised 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 Excel 365 Essentials is a useful qualification to possess and would be beneficial for any Office job, such as: Admin Assistant PA Secretary Administrator Account Assistant Bookkeeper Accountant Office Manager. Microsoft Excel 365 Essentials Module One - Getting Started 01:00:00 Module Two - Welcome to Office 365 Web Apps 01:00:00 Module Three - Worksheets and Workbooks 02:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Editing in the Browser (I) 02:00:00 Module Six - Editing in the Browser (II) 02:00:00 Module Seven - Building Formulas 02:00:00 Module Eight - Understanding Functions 02:00:00 Module Nine - Working with Data 02:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - The Insert Tools 02:00:00 Module Twelve - Wrapping Up 01:00:00 Activities Activities- Microsoft Excel 365 Essentials 00:00:00 Mock Exam Mock Exam- Microsoft Excel 365 Essentials 00:20:00 Final Exam Final Exam- Microsoft Excel 365 Essentials 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft Excel is a program that consists powerful tools which can help you organize and manipulate your data. Learning about the Excel program will help you in sharing workbooks to advanced functions and formulas. The Excel 2010 intermediate course is created to help you keep security setting in mind when sharing workbooks with Macros. In this course, you will learn the necessary skills, knowledge and information about how to use the Track Changes feature to make comments on another's work and learn to merge copies of the shared workbook to consolidate the comments. Who is the course for? Professionals who want to learn about Microsoft Excel 2010 features and functions. People who have an interest in knowing all the essentials in Microsoft Office Excel. 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 hardcopy 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 recognised 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 Excel 2010 Intermediate Level course is a useful qualification to possess and would be beneficial for any for any Office job, such as: Admin Assistant PA Secretary Administrator Account Assistant Bookkeeper Accountant Office Manager. Microsoft Excel 2010 Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 01:00:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 01:00:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working with Functions 01:00:00 Module Seven - Working with Macros 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Applying Advanced Chart Features 01:00:00 Module Ten - Working with PivotTables and PivotCharts 01:00:00 Module Eleven - Using the Automated Analysis Tools Add -In 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Excel 2010 Intermediate Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2010 Intermediate level 00:20:00 Final Exam Final Exam- Microsoft Excel 2010 Intermediate level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00