3909 Office Skills courses

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

A half day workshop exploring practical ways we can invest in our workplace happiness.

Duration 4 Days 24 CPD hours This course is intended for This course is designed for IT professionals with experience or interest in delivering Field Service solutions for large-scale customers. Overview Identify the key components involved in Field Service Implementations. Define the products and services that will be delivered to customers. Determine which pricing options to use in specific scenarios. Determine which resources are required. Dynamics 365 Field Service helps organizations better position themselves in the market by providing a variety of tools that assist in identifying and scheduling resources and managing workloads for mobile workers. This course will equip students with the skills necessary to identify and configure the key components that are used to deliver Field Service and mobile solutions. Key topics include identifying the organizational considerations that will drive configuration decisions and common configuration aspects. This course helps students better understand the bigger picture and end goals focused around implementations that aid in designing more efficient solutions that align with customer and organizational goals. Configure Field Service Introduction to configuring Field Service Defining products and services Defining tax codes Resource Scheduling Configuration Mapping and location information Configuring resource components Defining account preferences Defining and Configuring Bookable Resources Defining bookable resources Resource pools, crews and facilities Configure Incidents Creating an incident Using service tasks Inventory and Work Order Management Configure Field Service work orders Creating work orders Managing work orders Field Service Agreements Using Field Service agreements Set up bookings Set up invoices Inventory and Purchasing Manage customer assets Manage inventory Purchasing and returns Field Service Mobile Mobile client overview Install and deploy Field Service mobile projects Manage mobile projects Deploy the mobile client Universal Resource Scheduling URS overview and configuration Enabling entities for URS Customize entities for URS Managing Scheduling Options Using the schedule board Schedule items Rescheduling and substituting resources Crew and pool scheduling Customizing the Schedule Board Configure the board Create additional schedule boards Use views to enhance the schedule board Configuring schedule board queries and filters Working with requirement groups Advanced Scheduling Options Working with resource scheduling optimization Defining optimization goals Defining optimization scopes Defining optimization profiles Single resource scheduling Additional course details: Nexus Humans MB-240T00 Dynamics 365 for Field 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 MB-240T00 Dynamics 365 for Field 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 This course is designed for existing Python programmers who have at least one year of Python experience and who want to expand their programming proficiency in Python 3. Overview In this course, you will expand your Python proficiencies. You will: Select an object-oriented programming approach for Python applications. Create object-oriented Python applications. Create a desktop application. Create a data-driven application. Create and secure web service-connected applications. Program Python for data science. Implement unit testing and exception handling. Package an application for distribution.   Python continues to be a popular programming language, perhaps owing to its easy learning curve, small code footprint, and versatility for business, web, and scientific uses. Python is useful for developing custom software tools, applications, web services, and cloud applications. In this course, you'll build upon your basic Python skills, learning more advanced topics such as object-oriented programming patterns, development of graphical user interfaces, data management, creating web service-connected apps, performing data science tasks, unit testing, and creating and installing packages and executable applications. Selecting an Object-Oriented Programming Approach for Python Applications Topic A: Implement Object-Oriented Design Topic B: Leverage the Benefits of Object-Oriented Programming Creating Object-Oriented Python Applications Topic A: Create a Class Topic B: Use Built-in Methods Topic C: Implement the Factory Design Pattern Creating a Desktop Application Topic A: Design a Graphical User Interface (GUI) Topic B: Create Interactive Applications Creating Data-Driven Applications Topic A: Connect to Data Topic B: Store, Update, and Delete Data in a Database Creating and Securing a Web Service-Connected App Topic A: Select a Network Application Protocol Topic B: Create a RESTful Web Service Topic C: Create a Web Service Client Topic D: Secure Connected Applications Programming Python for Data Science Topic A: Clean Data with Python Topic B: Visualize Data with Python Topic C: Perform Linear Regression with Machine Learning Implementing Unit Testing and Exception Handling Topic A: Handle Exceptions Topic B: Write a Unit Test Topic C: Execute a Unit Test Packaging an Application for Distribution Topic A: Create and Install a Package Topic B: Generate Alternative Distribution Files Additional course details: Nexus Humans Advanced Programming Techniques with Python 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 Advanced Programming Techniques with Python 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 Consultant Business Process Owner / Team Lead / Power User Help Desk/CoE Support Trainer Overview This course will prepare you to: Configure organizational structure elements and service products for SAP S/4HANA Service Perform general configuration of service processes in SAP S/4HANA Service Configure an on-site service process in SAP S/4HANA Service Configure an in-house repair process in SAP S/4HANA Service Configure service contracts in SAP S/4HANA Service This course will prepare you to configure the most important business processes in SAP S/4HANA Service. The configuration for both and on-site service process and an in-house repair process is explained. Service contract configuration is also a topic. The integration with Controlling, the Cross-Application Time Sheet (CATS) and integration with Logistics in SAP S/4HANA is also discussed. Service Processing in SAP S/4HANA - Overview and Process Steps Executing a Service Process in SAP S/4HANA Configuring Organizational Structure Elements and Service Products Configuring Organizational Structure Elements for SAP S/4HANA Service Configuring Service Products General Configuration of Service Processes Configuring a Transaction Type Configuring an Item Category Configuring Item Category Determination Copying Control for Business Transactions Configuring the Integration with Controlling Configuring the Integration with the Cross-Application Time Sheet (CATS) Configuring Pricing for Service Transactions Other Basic Settings for Business Transactions Configuring an On-site Service Process Settings for Service Requests Settings for Service Order Quotations and Service Orders Settings for Service Confirmations and Service Billing Test the New Configuration in the System Configuring In-House Repair In-House Repair Processing In-House Repair Customizing Configuring Service Contracts Configuring Service Contracts

Duration 2 Days 12 CPD hours This course is intended for Application Consultant Business Process Architect Business Process Owner / Team Lead / Power User Developer Development Consultant Enterprise Architect Solution Architect System Architect Technology Consultant Overview This course will prepare you to: Get an overview about the workflow functions and functionality in SAP S/4HANA, S/4HANA Cloud and SAP Cloud Platform Explain the possible extensions of workflows in these technologies You want to learn about the workflow functionality in S/4HANA, S/4HANA Cloud and SAP Cloud Platform? This course provides a business overview of processes, which are working 'right out-of-the box'. It explains possible extensions and comes with several exercises to deepen the theoretical lessons. Introduction Explain workflow @SAP and in SAP S/4HANA Use SAP Fiori My Inbox App, Setup and Configuration Explain the installation and set up of the My Inbox app Access the My Inbox app Add a BWF system as a task provider Add a SAP BPM system as a task provider Use roles for SAP Fiori Define the gateway scenario and catalogs Use the task gateway service Perform further settings Implement BADIs Create dynamic columns for SWF_USER_ATTR Create push notifications for the SAP Fiori Launchpad Flexible Workflow Explain Flexible Workflow Use a Workflow Scenario Explain SAP S/4HANA Cloud workflow Responsibility Management SAP Cloud Platform Workflow Service Use SAP Cloud Platform Workflow for workflow application development Strategy Recommendations and Migration Options Discuss strategy recommendations for enterprise workflow with SAP Discuss migration options for existing workflows Additional course details: Nexus Humans BIT602 SAP Workflow with SAP Fiori 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 BIT602 SAP Workflow with SAP Fiori 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 skilled users of Microsoft Windows and Office who do not have prior coding or programming experience and who are interested in creating custom business apps quickly and without writing application code. Overview In this course, you will use Microsoft Power Apps to build and deploy low-code business apps. You will: Determine how Microsoft Power Apps can meet your business needs. Plan and design apps. Build canvas apps. Build model-driven apps. Test and deploy apps. This course introduces building low-code/no-code apps with Microsoft© Power Apps©. Most out-of-the-box solutions do not meet exact business needs or integrate well with existing business apps. Power Apps eases users into app development with templates, automated app-building tools, and a streamlined programming language to enable any business user to create a custom app. Getting Started with Microsoft Power Apps Topic A: Introduction to Microsoft Power Platform Topic B: Introduction to Power Apps Topic C: Select App Types to Address Business Needs Planning and Designing Apps Topic A: Plan Apps Topic B: Design Apps Building Canvas Apps Topic A: Create an App from a Blank Canvas Topic B: Create an App from a Template Building Model-Driven Apps Topic A: Create Model-Driven Apps Topic B: Add Visualizations and Reports Testing and Deploying Apps Topic A: Make Apps Available to Other Users Topic B: Test Apps Topic C: Revise Apps

Duration 4 Days 24 CPD hours This course is intended for Primary target audiences for this training are developers and development consultants but also other roles involved with implementing or reviewing program code to optimize ABAP based applications for SAP HANA. This course will prepare students to develop and optimize ABAP applications that access data stored in the SAP HANA Database. Course Outline Technical concepts of SAP HANA Introduction to HANA Studio Introduction to ADT (ABAP Development Tools, also known as ABAP in Eclipse) Tools to detect potential functional and performance issues when migrating to SAP HANA: Code Inspector and ABAP Test Cockpit, ABAP Trace and ABAP Profiler, SQL Trace Tools to prioritize performance issues: SQL Monitor, SQL Performance Tuning Worklist Performance Rules and Guidelines for ABAP in the context of SAP HANA Optimizing ABAP by accessing SAP HANA as a Secondary Database Optimizing ABAP using SAP HANA as Primary Database Using SAP HANA Fuzzy Search in ABAP Enabling input fields for Type-Ahead search. SAP List Viewer (ALV) for SAP HANA Additional course details: Nexus Humans HA400 SAP ABAP Programming for SAP HANA 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 HA400 SAP ABAP Programming for SAP HANA 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 Microsoft Technology Associate (MTA) is Microsoft?s newest suite of technology certification exams that validate fundamental knowledge needed to begin building a career using Microsoft technologies. This program provides an appropriate entry point to a future career in technology and assumes some hands-on experience or training but does not assume on-the-job experience. Overview This five-day Training 2-Pack helps you prepare for Microsoft Technology Associate Exams 98-366 and 98-367, and build an understanding of these topics: Network Infrastructures, Network Hardware, Protocols and Services, Security Layers, Operating System Security, Network Security, Security Software. These courses leverage the same content as found in the Microsoft Official Academic Courses (MOAC) for these exams. Understand Network InfrastructuresUnderstand Network HardwareUnderstand Protocols and ServicesUnderstand Security LayersUnderstand Operating System SecurityUnderstand Network SecurityUnderstand Security Software UNDERSTANDING LOCAL AREA NETWORKINGDEFINING NETWORKS WITH THE OSI MODELUNDERSTANDING WIRED AND WIRELESS NETWORKSUNDERSTANDING INTERNET PROTOCOLIMPLEMENTING TCP/IP IN THE COMMAND LINEWORKING WITH NETWORKING SERVICESUNDERSTANDING WIDE AREA NETWORKSDEFINING NETWORK INFRASTRUCTURES AND NETWORK SECURITYUNDERSTANDING SECURITY LAYERSAUTHENTICATION, AUTHORIZATION, AND ACCOUNTINGUNDERSTANDING SECURITY POLICYUNDERSTANDING NETWORK SECURITYPROTECTING THE SERVER AND CLIENT

Duration 3 Days 18 CPD hours This course is intended for Anyone interested in getting an overview of SAP S/4HANA Overview This course will prepare you to: Explain how SAP S/4HANA supports the digital transformation Navigate in SAP S/4HANA using SAP Fiori UX and other client technologies Describe system-wide concepts such as organizational elements or master data Describe key business processes of SAP S/4HANA Enterprise Management and SAP S/4HANA LoB solutions Describe integration scenarios between SAP S/4HANA and SAP Cloud solutions Explain SAP S/4HANA embedded analytics capabilities and additional BI/BW tools Gain basic knowledge about SAP Activate to accelerate SAP S/4HANA adoption This course provides an overview of SAP S/4HANA for learners who do not yet have specific SAP background knowledge and want to build SAP S/4HANA skills. Module 1 SAP S/4HANA Overview Module 2 Navigation Module 3 System-wide concepts Module 4 Logistics capabilities Module 5 Finance capabilities Module 6 Human Resources capabilities Module 7 SAP Activate Additional course details: Nexus Humans S4H00 SAP S/4HANA Overview 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 S4H00 SAP S/4HANA Overview 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.