3721 Office Skills courses delivered Online

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access

Duration 1 Days 6 CPD hours This course is intended for This course is intended for students who have a foundational working knowledge of PowerPoint, who wish to take advantage of the application's higher-level usability, security, collaboration, and distribution functionality. Overview In this course, you will use the advanced tools and features in PowerPoint to create and deliver engaging presentations.You will: Customize design templates. Add tables. Add charts. Work with media. Build advanced transitions and animations. Collaborate on a presentation. Customize the delivery of a presentation. Modify presentation navigation. Secure and distribute a presentation. Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. Oh, and by the way, you need to make it interesting, informative, and memorable. So, how do you do it? Without the help of a robust set of tools, it would be nearly impossible. But Microsoft© PowerPoint© provides you with a variety of such tools that can help you deliver content in nearly any situation, while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd, but also don't consume all of your available time. Note: Most Office users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Microsoft 365? subscription. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version. This course may be a useful component in your preparation for the PowerPoint Associate (Microsoft 365 Apps and Office 2019): Exam MO-300 certification exam. Lesson 1: Customizing Design Templates Topic A: Modify Slide Masters and Slide Layouts Topic B: Modify the Notes Master and the Handout Master Topic C: Add Headers and Footers Lesson 2: Adding Tables Topic A: Create a Table Topic B: Format a Table Topic C: Insert a Table from Other Office Applications Lesson 3: Adding Charts Topic A: Create a Chart Topic B: Format a Chart Topic C: Insert a Chart from Microsoft Excel Lesson 4: Working with Media Topic A: Add Audio to a Presentation Topic B: Add Video to a Presentation Topic C: Add a Screen Recording Lesson 5: Building Advanced Transitions and Animations Topic A: Use the Morph Transition Topic B: Customize Animations Lesson 6: Collaborating on a Presentation Topic A: Review a Presentation Topic B: Co-author a Presentation Lesson 7: Customizing Presentation Delivery Topic A: Enhance a Live Presentation Topic B: Record a Presentation Topic C: Set Up a Slide Show Lesson 8: Modifying Presentation Navigation Topic A: Divide a Presentation into Sections Topic B: Add Links Topic C: Create a Custom Slide Show Lesson 9: Securing and Distributing a Presentation Topic A: Secure a Presentation Topic B: Create a Video or a CD

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Business Process Owners/Team Leads/Power Users, Industry Specialists, and Program/Project Managers. Overview Explain Maintenance and Repair business processesExecute maintenance tasksDefine relevant organizational elements used in Plant Maintenance In this course, students learn how to describe the maintenance and repair business processes within SAP ERP. This foundation knowledge is mandatory in order for students to have the confidence to complete the subsequent configuration courses. Plant Maintenance Organization Outlining EAM Processes and SAP Solution Portfolio Outlining the SAP User Interfaces and Roles Executing Maintenance Tasks with NetWeaver Business Client (NWBC) Checking Organizational Levels in Plant Maintenance Technical Objects Checking Functional Locations Managing Equipment Checking Linear Asset Management (LAM) Assigning Bills of Material (BOMs) to Technical Objects Breakdown Maintenance Planning Breakdown Maintenance Processing a Breakdown Maintenance Order Corrective Maintenance Outlining Corrective Maintenance Processing External Services Creating Notifications of Maintenance Requirements Creating Maintenance Orders Planning of Maintenance Orders Planning of Maintenance Orders for Operation Account Assignment (OAA) Selecting Maintenance Orders Planning for Maintenance Orders Scheduling Maintenance Executing Maintenance Tasks with SAP GUI Completing Notifications and Orders Confirm and Technically Complete an Order Creating a Shift Report Refurbishment of Spare Parts Checking Prerequisites in Materials Management (MM) Refurbishing Spare Parts Internally Refurbishing Spare Parts Externally Preventive Maintenance Outlining Preventive Maintenance Checking the Maintenance Task List Creating Maintenance Plans Scheduling Maintenance Plans Project-Oriented Maintenance Outlining Project-Oriented Maintenance Supplementary Processes for SAP Enterprise Asset Management Outlining Mobile Applications for SAP Enterprise Asset Management (SAP EAM) Using Visual Enterprise Documents Describing Basic Maintenance Processing Outlining Pool Asset Management (PAM) Outlining SAP Work Clearance Management (WCM) Applying Worker Safety Report and Analysis of Information for SAP Enterprise Asset Management (EAM) Analyzing Maintenance History with the Logistic Information System (LIS) Evaluating Plant Maintenance with SAP Business Warehouse (SAP BW) Outlining Rapid Deployment Solution EAM Analytics SAP Enterprise Asset Management Customizing Implementation Outlining SAP Enterprise Asset Management Customizing Implementation

Duration 4 Days 24 CPD hours This course is intended for Architect Database Administrators Overview Configure and use Policy-Based Cluster Management in conjunction with Policy-Managed Database and Oracle Multitenant Architecture Migrate from a standard cluster to a Flex Cluster and configure highly available application resources on Flex Cluster Leaf Nodes Implement Oracle Database In-Memory on an existing Oracle RAC database Configure an Oracle RAC database to use Application Continuity Configure and use Global Data Services in conjunction with Oracle RAC and Data Guard Upgrade an existing database to use Oracle ASM Filter Driver Migrate from standard ASM to Flex ASM and examine the effect of using Flex ASM Perform a database rolling upgrade, from Oracle Database 11gR2 to Oracle Database 12c, using a transient logical standby database Practice configuring, administering and using noteworthy features associated with Oracle Database 12c RAC and Grid Infrastructure. Practice configuring, administering and using noteworthy features associated with Oracle Database 12c RAC and Grid Infrastructure. Additional course details: Nexus Humans Oracle Database 12c - RAC and Grid Infra Deployment Workshop 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 Oracle Database 12c - RAC and Grid Infra Deployment Workshop 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 and Program Managers Overview Participants learn about the SAP Activate methodology in agile implementation techniques in SAP projects.The course enables participants to apply the Agile techniques in their projects through project use cases and simulations.This class is highly interactiveThis course complements agile courses from other providers, like Certified Scrum Master and/or PMI-ACP training. In this course, students will gain knowledge on how to use techniques in SAP projects. The Basics Agile and SCRUM 101 Introduction to SAP Activate Agile Project Fit Starting Agile Roles and Responsibilities Agile Project Organisation Prepare Agile Project Backlog Explore Phase Overview Create Product Backlog Definition of Done Iterative Build Release Planning Sprint Cycle Testing and Deploy Summary of Key Points Summary and key points Appendices Agile Manifesto Agile Use Cases Agile Fit Questions Agile Lean Design Templates Agile and SAP Solution Manager Additional course details: Nexus Humans ACT200 SAP Agile Project Delivery 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 ACT200 SAP Agile Project Delivery 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 Application Consultant Business Process Owner/ Team Lead/ Power User Overview This course will prepare you to: configure asset accounting manage asset master data perform day to day asset transactions perform periodic asset transactions manual legacy data transfer for assets This course gives you a thorough overview of Asset Accounting configuration and processes with SAP S/4HANA. Course Outline Chart of Depreciation/Depreciation Areas Asset Classes Asset Master Data Daily Asset Accounting Business Processes Valuation and Depreciation Period and Year-End Closing Processes Investment Support Measures Information System Asset Legacy Data Transfer Additional course details: Nexus Humans S4F17 SAP Asset Accounting in SAP S/4HANA 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 S4F17 SAP Asset Accounting in SAP S/4HANA 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 Application Consultants, Business Analysts, and Process Owners Overview Learn to navigate the catalog, create and approve requisitions, and receive against POs. This course covers all of the functions of SAP Ariba Buying related to the creation of requisitions, the issuing of purchase orders, and receiving against purchase orders. Course Outline Introduction The Dashboard Catalogs Requisitions Accounting Approval Managing POs Receiving SAP Ariba Mobile Searching and Reporting Collaboration Demand Aggregation

Duration 5 Days 30 CPD hours This course is intended for This course is for experienced information technology (IT) professionals, typically described as Enterprise Desktop Administrators (EDAs). These EDAs deploy, manage, and maintain PCs, devices, and applications across medium, large, and enterprise organizations. A significant portion of this audience uses, or intends to use, the latest release of Configuration Manager to manage and deploy PCs, devices, and applications. Overview After completing this course, students will be able to: •Analyze data by using queries and reports. •Prepare a management infrastructure, including configuring boundaries, boundary groups, and resource discovery, and integrating mobile-device management with Microsoft Exchange Server. •Deploy and manage the Configuration Manager client. •Configure, manage, and monitor hardware and software inventory, and use Asset Intelligence and software metering. •Identify and configure the most appropriate method to distribute and manage content used for deployments. •Distribute, deploy, and monitor applications for managed users and systems. •Maintain software updates for PCs that Configuration Manager manages. •Implement Endpoint Protection for managed PCs. •Manage configuration items, baselines, and profiles to assess and configure compliance settings and data access for users and devices. •Configure an operating-system deployment strategy by using Configuration Manager. •Manage and maintain a Configuration Manager site. In this course, students will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You also will learn how to optimize System Center Endpoint Protection, manage compliance, and create management queries and reports. Managing computers and mobile devices in the enterprise Overview of systems management by using enterprise management solutions Overview of the Configuration Manager architecture Overview of the Configuration Manager administrative tools Tools for monitoring and troubleshooting a Configuration Manager site Lab : Exploring the Configuration Manager tools Analyzing data using queries, reports, and CMPivot Introduction to queries Configuring SQL Server Reporting Services Analyzing the real-time state of a device by using CMPivot Lab : Creating and running queries Lab : Configuring SSRS Lab : Analyzing the real-time state of a device by using CMPivot Preparing the Configuration Manager management infrastructure Configuring site boundaries and boundary groups Configuring resource discovery Organizing resources using device and user collections Lab : Configuring boundaries and resource discovery Lab: Configuring user and device collections Deploying and managing the Configuration Manager client Overview of the Configuration Manager client Deploying the Configuration Manager client Configuring and monitoring client status Managing client settings and performing management operations Lab : Deploying the Microsoft System Center Configuration Manager client software Lab: Configuring and monitoring client status Lab : Managing client settings Managing inventory for PCs and applications Overview of inventory collection Configuring hardware and software inventory Managing inventory collection Configuring software metering Configuring and managing Asset Intelligence Lab : Configuring and managing inventory collection Lab : Configuring software metering Lab : Configuring and managing Asset Intelligence Distributing and managing content used for deployments Preparing the infrastructure for content management Distributing and managing content on distribution points Lab : Distributing and managing content for deployments Deploying and managing applications Overview of application management Creating applications Deploying applications Managing applications Deploying virtual applications by using System Center Configuration Manager (Optional) Deploying and managing Windows Store apps Lab : Creating and deploying applications Lab : Managing application supersedence and removal Lab : Deploying virtual applications by using Configuration Manager (Optional) Lab : Using Configuration Manager to deploy Windows Store apps Maintaining software updates for managed PCs The software updates process Preparing a Configuration Manager site for software updates Managing software updates Configuring automatic deployment rules Monitoring and troubleshooting software updates Enabling third-party updates Lab : Configuring the site for software updates Lab : Deploying and managing software updates Implementing Endpoint Protection for managed PCs Overview of Endpoint Protection in Configuration Manager Configuring, deploying, and monitoring Endpoint Protection policies Configuring and deploying advanced threat policies Lab : Implementing Microsoft System Center Endpoint Protection Lab : Implementing advanced threat policies Managing compliance and secure data access Overview of Compliance Settings Configuring compliance settings Viewing compliance results Managing resource and data access Lab : Managing compliance settings Managing operating system deployment An overview of operating system deployment Preparing a site for operating system deployment Deploying an operating system Managing Windows as a service Lab : Preparing the site for operating -system deployment Lab : Deploying operating -system images for bare-metal installations Managing and maintaining a Configuration Manager site Configuring role-based administration Configuring Remote Tools Overview of Configuration Manager site maintenance Backing up and recovering a Configuration Manager site Lab : Configuring role-based administration Lab : Configuring Remote Tools Lab : Maintaining a Configuration Manager site Additional course details: Nexus Humans 20703-1 Administering System Center Configuration Manager 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 20703-1 Administering System Center Configuration Manager 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 This course is appropriate for advanced users, system administrators and web site administrators who want to use Python to support their server installations, as well as anyone else who wants to automate or simplify common tasks with the use of Python scripts. Students can apply the course skills to use Python in basic web development projects or automate or simplify common tasks with the use of Python scripts. Overview This skills-focused course is about 50% hands-on lab to lecture ratio, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert instructor, you'll learn how to: Create working Python scripts following best practices Use python data types appropriately Read and write files with both text and binary data Search and replace text with regular expressions Work with with the standard library and its work-saving modules Create 'real-world', professional Python applications Know when to use collections such as lists, dictionaries, and sets Work with Pythonic features such as comprehensions and iterators Write robust code using exception handling Introduction to Python Programming Basics is a hands-on Python programming course that teaches you the key skills you?ll need to get started with programming in Python to a solid foundational level. The start of the course will lead you through writing and running basic Python scripts, and then guide you through how to use more advanced features such as file operations, regular expressions, working with binary data, and using the extensive functionality of Python modules. Extra emphasis is placed on features unique to Python, such as tuples, array slices, and output formatting. This course provides you with an excellent kick start for users new to Python and scripting, enabling you to quickly use basic Python skills on the job in a variety of ways. You?ll be able use Python in basic web development projects, or use it to automate or simplify common tasks with the use of Python scripts. The course also serves as a solid primer course / foundation for continued Python study in support for next level web development with Python, using Python in DevOps, Python for data science / machine learning or Python for systems admin or networking support. Python Quick View What is Python? Python timeline Advantages/disadvantages Installing Python Getting help The Python Environment Starting Python Using the interpreter Running a Python script Editors and IDEs Getting Started with Python Using variables Builtin functions String data Numberic data Converting types Console input/output Command line parameters Flow Control About flow control The if statement Relational and Boolean operators while loops Exiting from loops Array Types About array types Lists and list methods Tuples Indexing and slicing Iterating through a sequence Sequence functions, keywords, and operators List comprehensions and generators Working with Files File overview Opening a text file Reading a text file Writing to a text file Dictionaries and Sets About dictionaries Creating dictionaries Iterating through a dictionary About sets Creating sets Working with sets Functions Defining functions Returning values Parameters and arguments Variable scope Sorting The sorted() function Custom sort keys Lambda functions Sorting in reverse Using min() and max() Errors and Exception Handling Exceptions Using try/catch/else/finally Handling multiple exceptions Ignoring exceptions Modules and Packages Creating Modules The import statement Module search path Using packages Function and module aliases Getting Started with Object Oriented Programming and Classes About object-oriented programming Defining classes Constructors Understanding self Properties Instance Methods and data Class methods and data Inheritance Additional course details: Nexus Humans Introduction to Python Programming Basics (TTPS4800) 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 Introduction to Python Programming Basics (TTPS4800) 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 Application Consultant Business Process Owner / Team Lead / Power User Overview This course will prepare you to: Provide an overview of basic customizing settings in the main components of Financial Accounting with SAP S/4HANA Configure the Master Data Settings (G/L Accounts, Customer and Vendor Accounts) of Financial Accounting with SAP S/4HANA Configure the Document Control and Posting Control Settings of Financial Accounting with SAP S/4HANA Configure the Settings for Financial Document Clearing of Financial Accounting with SAP S/4HANA The course provides an overview of how to implement Financial Accounting capabilities of SAP S/4HANA in order to cover the related business requirements. You will gain the mandatory foundation knowledge required in order to understand and configure business processes for the SAP S/4HANA financials module in the areas of general ledger, accounts payable, and accounts receivable accounting. For the Master Data, the Document Control/Posting Control and Financial Document Clearing you will practice some configurations and verify the result by using the application. Course Outline Short Overview of SAP S/4HANA Core Financial Accounting (FI) Configuration Managing Organizational Units in Financial Accounting (FI) Checking the Basic Settings in New General Ledger (G/L) Accounting Outlining the Variant Principle Managing Fiscal Year Variants Master Data Maintaining General Ledger (G/L) Accounts Managing Customer and Vendor Accounts Document Control Configuring the Header and Line Items of Financial Accounting (FI) Documents Managing Posting Periods Managing Posting Authorizations Posting Control Analyzing Document Splitting Maintaining Default Values Configuring Change Control Configuring Document Reversal Configuring Payment Terms and Cash Discounts Maintaining Taxes and Tax Codes Posting Cross-Company Code Transactions Financial Document Clearing Performing Open Item Clearing Managing Payment Differences Additional course details: Nexus Humans S4F12 SAP Basics of Customizing for Financial Accounting: GL, AP, AR in SAP S/4HANA 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 S4F12 SAP Basics of Customizing for Financial Accounting: GL, AP, AR in SAP S/4HANA 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.