3723 Office Skills courses in Polegate delivered Online

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Process Architects, Business Process Owners/Team Leads/Power Users, Program/Project Managers, and Users. Overview Participants learn about the fundamental elements of materials management.Participants understand usage of the procurement processes for stock material, consumable materials, and services, the basic functions from purchasing, inventory management, invoice verification, service entry, and materials planning.Topic-specific exercises in the SAP system give participants the opportunity to gain first-hand practical experience of the above processes. This course will give students the fundamental knowledge and a comprehensive overview of the processes in procurement in SAP. After attending this class, students will understand the major business processes and functions in materials management. Procurement Processes Defining Processes and Organizational Levels in Procurement Maintaining Purchase Orders Posting Goods Receipts Entering Invoices Master Data Maintaining Vendor Master Records Maintaining Material Master Records Using Entry Aids for Master Data Maintenance Performing Mass Maintenance Stock Material Procurement Applying Conditions in Purchasing Handling Requests for Quotations and Quotation Processes Creating Purchase Orders with Reference Maintaining Purchasing Info Records Analyzing Material Valuation Posting Goods Receipts for Purchase Orders Entering Invoices with Reference to Purchase Orders Consumable Material Procurement Purchasing Consumable Materials Creating Purchase Requisitions Creating Purchase Orders with Reference to Purchase Requisitions Entering Valuated and Non-Valuated Goods Receipts Creating Blanket Purchase Orders External Services Procurement Maintaining Master Data for External Services Ordering Services Creating Service Entries and Verifying Invoices Automated Procurement Maintaining Data for Material Requirements Planning (MRP) Maintaining Contracts and Source Lists Performing Procurement Processes Automatically Reporting and Analytics Using Standard Reports Performing Standard Analyses in the Logistics Information System Introduction to the SAP Buyer Role Assessing the Buyer Role Self-Service Procurement Examining the Functions of Self-Service Procurement

Duration 3 Days 18 CPD hours This course is intended for Application Consultants and Team Leads Overview Be able to make all the basic customizing settings for maintenance processing In this course, students will be able to make all the basic customizing settings for maintenance processing. Notification Defining Notification Types Assigning Parameters to a Notification Type Planning Setting Up Order Types Assigning Maintenance Requirements to Orders Accessing a Spare-Parts Catalog Attaching Documents to Orders Attaching Visual Work Instructions to Orders Performing Inspection Rounds Using Work Centers in Plant Maintenance Controlling Maintenance Orders Ensuring Worker Safety Scheduling Checking Material Availability Scheduling Maintenance Orders Printing Notifications and Shop Papers Completion Performing Completion Confirmation Tracking Work Times and Activities Using Digital Signatures for Order Operations Sharing Information with Shift Notes and Shift Reports Settling Maintenance Orders Settling Refurbishment Orders Accessing Historical Maintenance Orders Additional course details: Nexus Humans PLM315 SAP Maintenance Processing - Operational Functions 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 PLM315 SAP Maintenance Processing - Operational Functions 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 1 Days 6 CPD hours This course is intended for This course is designed for Microsoft© Windows© and Microsoft© Office users who are transitioning to a SharePoint environment, and who need to access information from and collaborate with team members on a Microsoft SharePoint Team Site. Overview In this course, you will be able to use resources on a typical SharePoint Team Site in the course of performing normal business tasks. You will:Interact with SharePoint Team Sites.Work with documents, content, and libraries.Interact in SharePoint.Work with Lists.Integrate SharePoint with Microsoft Office. SharePoint is a complex platform. A strong understanding of the platform will allow students to work more efficiently & effectively. In this course, students will learn how to use a SharePoint Team Site to access, store, and share information & documents. Interacting with SharePoint Team Sites Topic A: Access SharePoint Sites Topic B: Navigate SharePoint Sites Working with Documents, Content, & Libraries Topic A: Upload Documents Topic B: Search for Documents and Content Interacting in SharePoint Topic A: Update and Share Your Profile Topic B: Follow and Share Content Working with Lists Topic A: Add and Modify List Items Topic B: Configure List Views Topic C: Filter and Group Data with List Views Integrating with Microsoft Office Topic A: Access and Save Microsoft Office Documents with SharePoint Topic B: Manage Document Versions Topic C: Work with SharePoint Data from Outlook Additional course details: Nexus Humans Microsoft SharePoint 2016 - Site User 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 Microsoft SharePoint 2016 - Site User 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 5 Days 30 CPD hours This course is intended for The primary audience for this course are Technology Consultants, System AdministratorsTechnical Architects, and Support Consultants. Overview Understand and use the Monitoring and Alerting Infrastructure (MAI) for monitoring the system landscape with SAP Solution ManagerSetup and Configure the monitoring types System Monitoring, Self- Monitoring, End-user Experience, Integration Monitoring, Job & BI MonitoringUse the features of the Technical Monitoring Work CenterUse Technical Reporting options (EWA, SL Reporting, Interactive Reporting)Use the SAP Solution Manager Administration work center for Troubleshooting In this course, students learn to understand and use the Monitoring and Alerting Infrastructure (MAI) for monitoring the system landscape with SAP Solution Manager Setup and configure the monitoring types. Course Outline Get an overview about the Technical Monitoring in SAP Solution Manager 7.1 Get an overview about the Monitoring and Alerting Infrastructure (MAI) architecture Get a deep understanding about Monitoring Templates Using the Alert Inbox including Guided Procedures Configure Work Mode Management and Notification Management Configure and using System Monitoring Configure and using Interface Channel Monitoring and Connection Monitoring Configure and using End-user Experience Monitoring Configure and using BI-Monitoring and Job Monitoring Configure and using PI-Monitoring, Message Flow Monitoring and Workflow Monitoring Using Technical Reporting (EarlyWatch Alerts, Service Level Reporting, Interactive Reporting and Dashboards) Get an overview about SAP IT Infrastructure Management Get an overview about SAP Mobile Apps for the Monitoring and Alerting Infrastructure (MAI) Configure and using SAP Solution Manager Self-Monitoring and Self Diagnosis Using Monitoring and Alerting Infrastructure Analysis Tools

Duration 5 Days 30 CPD hours This course is intended for This basic course is for IT personnel with a theoretical background of z/OS. Overview Review the main concepts of z/OS Log on to TSO and start ISPF/PDF Navigate through ISPF/PDF dialogs and use the basic ISPF/PDF functions and the ISPF Editor Use ISPF/PDF to allocate data sets and edit data sets (including hierarchical file system (HFS) files) via the ISPF Editor primary and line commands Use ISPF to create and manipulate (copy, rename, delete, list, sort and merge) data sets Identify security considerations for Multiple Virtual Storage (MVS) data sets and HFS files Describe and use TSO/E commands Perform simple modifications to existing ISPF/PDF panels Invoke a REXX exec and TSO CLIST Tailor existing JCL and submit batch jobs Review job status and job output using SDSF Invoke UNIX processes Manipulate HFS directories and file systems using the UNIX System Services ISHELL This course is designed to teach students the fundamental practical skills to navigate and work in a z/OS environment. This includes the use of ISPF/PDF dialogs, TSO/E commands, JCL, UNIX System Services shell, and BookManager. Review of the z/Architecture and z/OS An Introduction to ISPF, ISPF/PDF, and RACF System familiarization Working with ISPF/PDF (Part 1 & 2) Allocate new data sets ISPF editor primary commands ISPF editor line command Copy/move/rename/delete data sets and members Data set lists Working with TSO/E Using TSO/E commands Working with JCL Submit a job JCL exercises Working with UNIX System Services Procedures ISHELL and hierarchical file system Additional course details: Nexus Humans ES10 IBM Fundamental System Skills in z/OS 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 ES10 IBM Fundamental System Skills in z/OS 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.

Learn Excel for Business Accounting with our comprehensive course. From basic worksheet creation to advanced functions like pivot tables, charts, and data analysis, master Excel's features for efficient accounting tasks. Ideal for business professionals and students looking to enhance their Excel skills for financial management.

Unlock the power of data with our 'Sales Analysis in Excel' course. Dive into e-commerce sales analysis and craft insightful sales analysis reports. Discover how to manipulate sales data, forecast trends, and automate workbook functionality. Elevate your career with advanced Excel skills! Learning Outcomes of Sales Analysis in Excel: Master data manipulation techniques for e-commerce sales analysis. Create comprehensive sales reports with Excel's advanced functions. Visualize data effectively using charts, PivotTables, and PivotCharts. Forecast future trends and make data-driven decisions. Automate repetitive tasks to boost efficiency and productivity. Why buy this Sales Analysis in Excel? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Sales Analysis in Excel there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Business analysts seeking to enhance their data analysis skills. Sales professionals aiming to leverage Excel for deeper insights. Aspiring data scientists interested in e-commerce sales data. Students and graduates looking to gain a competitive edge. Entrepreneurs striving to optimize their sales strategies. Prerequisites This Sales Analysis in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Sales Analysis in Excel was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £50,000 Per Annum Sales Analyst: £25,000 - £45,000 Per Annum Financial Analyst: £30,000 - £55,000 Per Annum Market Research Analyst: £25,000 - £40,000 Per Annum Excel Specialist: £22,000 - £35,000 Per Annum Course Curriculum Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Welcome to the Course 00:03:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00

Dive into the world of structured data manipulation and management with the SQL course. Explore database fundamentals, constraints, functions, clauses, and advanced concepts such as joins and wild cards. From creating to altering databases, this course empowers you with a versatile skill set to navigate and manipulate data efficiently using SQL. Learning Outcomes: Acquire a foundational understanding of SQL, its role, and importance in database management. Master the creation, organization, and manipulation of databases. Implement constraints to ensure data integrity and enforce business rules. Utilize SQL functions to transform and manipulate data effectively. Employ SQL clauses to filter, sort, and analyze data for specific purposes. Perform alterations on databases and tables to accommodate evolving data needs. Explore the intricacies of joins and relationships to retrieve and consolidate data from multiple tables. Harness the power of wild cards to perform flexible and dynamic data searches. Why buy this SQL Database Management? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the SQL Database Management there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This SQL Database Management does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Aspiring Database Administrators and SQL Developers. Software Engineers Seeking Proficiency in SQL for Application Development. Data Analysts and Business Intelligence Professionals. IT Professionals Looking to Enhance Their Database Management Skills. Prerequisites This SQL Database Management was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path SQL Developer - $70,000 to $110,000/year. Database Administrator - $60,000 to $100,000/year. Data Analyst - $60,000 to $90,000/year. Business Intelligence Developer - $70,000 to $120,000/year. Database Manager - $80,000 to $130,000/year. Course Curriculum Unit 01: Introduction Module 01: Introduction 00:09:00 Module 02: Xampp (PHPmyadmin) installation 00:05:00 Unit 02: Getting Started With Databases Module 01: Creating a database 00:02:00 Module 02: Creating Tables 00:03:00 Module 03: More about Tables 00:01:00 Module 04: Inserting into Tables 00:03:00 Module 05: Updating and Deleting 00:04:00 Module 06: Data Types 00:03:00 Module 07: Conditional and comparison operators 00:04:00 Unit 03: Constraints Module 01: Primary Keys 00:05:00 Module 02: Foreign Keys 00:07:00 Module 03: Indexes 00:03:00 Module 04: Unique Indexes 00:03:00 Unit 04: SQL Functions Module 01: Functions (Part: 01) 00:02:00 Module 02: Functions (Part: 02) 00:03:00 Unit 05: SQL Clauses Module 01: Basic Queries and Where Claueses 00:04:00 Module 02: Order by 00:03:00 Module 03: Distinct 00:05:00 Module 04: In 00:04:00 Module 05: Group by 00:07:00 Unit 06: Alters Module 01: Alters (Part: 01) 00:03:00 Module 02: Alters (Part: 02) 00:05:00 Module 03: Alters (Part: 03) 00:05:00 Unit 07: All about Joins and SQL Relations Module 01: Aliases 00:04:00 Module 02: Inner joins 00:07:00 Module 03: Left and right joins 00:06:00 Module 04: Unions 00:06:00 Unit 08: Wild Cards Module 01: Wild Cards (Part: 01) 00:07:00 Module 02: Wild cards (Part: 02) 00:05:00 Unit 09: More Advanced Areas of SQL Module 01: Views 00:09:00 Module 02: Creating Functions 00:07:00 Module 03: Triggers 00:09:00 Assignment Assignment - SQL 00:00:00

Learn how to create a mail merge in Word to allow you to send personalized emails to groups of people. Course overview Duration: 2 hours This course looks at how you can create a list of contacts with emails and then build a document to email out to everyone. This ensures that everyone gets a personal email but no one else sees the recipients. Objectives  By the end of the course you will be able to: Create source data to use in a merge Create a document to email out Attach source data contacts Filter recipients Send out emails to all Content Creating source contact data Creating your source data in Excel Creating a Word mail merge document Starting a mail merge document Attaching your source contact data Building the document Emailing your document Previewing the results Running a test to a document Setting up any filters Sending your document to emails

Learn all the quick tips and tricks you didn’t know about in Word and how to properly setup new documents. Course overview Duration: 1 day (6.5 hours) Our Word Document Production (Part 1) course shows you how Word was designed to be used and demonstrates the powerful tools available. This course will enable you to originate professional documents with ease, ensuring that modifications are quick and uncomplicated. It looks at some of the common frustrations and how to avoid them. This course is aimed at existing Word users who want to get the best out of the package Objectives  By the end of the course you will be able to: Customise Word Use different Word views Use line, paragraph and page breaks correctly Set indents and tabs Use styles for easy formatting Work with section breaks Work with automatic correction features Insert and modify tables Content Word setup Using different views Customising the status bar Customising the Quick Access bar and Ribbon Document setup Using the Navigation Pane Using Show / Hide Line vs paragraph breaks Using page break Using the ruler Setting indents and tabs The different types of indent Using dot leader tab Bullets and numbering Working with simple numbered and bulleted lists Sorting lists Working with multi level lists Styles The importance of styles Creating, amending and applying Character Styles Amending and applying Paragraph Styles Setting bullet point styles Using the Style Inspector Reorganising a document Using Outline View Promoting and demoting headings Displaying Styles names in Draft and Outline views Page and number fomatting Section vs page breaks Setting page orientation Setting page margins Displaying page border Automatic corrections Working with Quick Parts Setting autocorrect options Autoformat while typing Creating simple tables Inserting or drawing a table Modifying table formatting Adding rows and columns Changing row heights and column widths