3721 Office Skills courses delivered Online

Duration 3 Days 18 CPD hours This course is intended for Anyone starting to write SAS programs Overview Use SAS Studio and SAS Enterprise Guide to write and submit SAS programs. Access SAS, Microsoft Excel, and text data. Explore and validate data. Prepare data by subsetting rows and computing new columns. Analyze and report on data. Export data and results to Excel, PDF, and other formats. Use SQL in SAS to query and join tables. This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence. Essentials The SAS programming process. Using SAS programming tools. Understanding SAS syntax. Accessing Data Understanding SAS data. Accessing data through libraries. Importing data into SAS. Exploring and Validating Data Exploring data. Filtering rows. Formatting columns. Sorting data and removing duplicates. Preparing Data Reading and filtering data. Computing new columns. Conditional processing. Analyzing and Reporting on Data Enhancing reports with titles, footnotes, and labels. Creating frequency reports. Creating summary statistics reports. Exporting Results Exporting data. Exporting reports. Using SQL in SAS Using Structured Query Language in SAS. Joining tables using SQL in SAS. Additional course details: Nexus Humans SAS Programming 1 - Essentials 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 SAS Programming 1 - Essentials 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 Implementation Consultants Key Technical Business Users involved in a GRC 12.0 project IT Governance Experts Consultants for SAP Security and GRC IT Auditors Business Project Team Leaders Overview This course will prepare you to: Introduce SAP Governance, Risk, and Compliance (GRC) 12.0 Identify key governance, risk, and compliance processes supported in the SAP GRC 12.0 solution Describe key features and business benefits of the integrated solution Identify applications that integrate with the SAP GRC 12.0 solution Describe the purpose and location of key user interface components Discuss harmonized navigation and how authorizations affect what users see Describe how common functions and relative master data are shared across the SAP GRC solutions Describe the IMG organization for GRC 12.0 Describe a general implementation process and key steps This course provides foundation knowledge for SAP Governance, Risk and Compliance (GRC) 12.0. By gaining familiarity with this solution?s harmonized navigation, common functions, shared master data, and the harmonized reporting framework, you will be better able to get the most value out of using the integrated applications in SAP GRC. Introduction to SAP Governance, Risk, and compliance (GRC) 12.0 Solution Introduction Solution Overview ? Enterprise Risk and Compliance Solution Overview ? Access Governance Solution Overview ? International Trade Management Solution Overview ? Cybersecurity Information Architecture, Security, and Authorizations Understanding the SAP Fiori Concept and Architecture Security and Authorizations The SAP GRC 12.0 User Interface Work Centers SAP Fiori Common Functions and Data User Interface Configuration Framework Shared Master Data Implementation and Configuration Streamlined Configuration Reporting Harmonized Reporting Framework SAP HANA Integration

Duration 2 Days 12 CPD hours This course is intended for Application Consultants, Business Analysts, and Program Managers Overview Describe how to organize and run payroll including subsequent activities and problem-solving aids This course provides the mandatory foundation knowledge required for processing payroll transactions in SAP HCM. Payroll Overview Setting Up the User Interface Identifying Payroll Elements Payroll Data Entering payroll data Payroll Elements Organizing a Payroll Run Reviewing the Payroll Status Infotype Identifying Retroactive Payroll Entries Payroll Process Running Payroll Payroll Reports Reporting on Payroll Generating Remuneration Statements Analyzing Payroll Results Analyzing Wage Types Reviewing Ad Hoc Query Functionality Post Payroll Results Posting Environments Verifying a Posting Run Updating a Live Posting Run Verifying Documents Bank Transfers & Check Preparation Generating Employee Payments Process Model Running a Payroll Process Model SuccessFactors Employee Central Payroll Outling employee central payroll basics

Duration 4 Days 24 CPD hours This course is intended for This advanced course is the third in a series of three classes designed for RPG IV programmers. Programming experience using RPG IV is mandatory when enrolling in this course. You should have attended RPG IV Programming Fundamentals Workshop for IBM i (AS060) and RPG IV Programming Intermediate Workshop for IBM i (AS070). This course is not designed for RPG III programmers who want RPG IV. RPG III programmers should review the agenda carefully before they make a decision to attend this class. Overview Use address pointers and user spaces in RPG IV programs Write database triggers in RPG IV Develop ILE modular objects and package them in service programs Explain the purpose of ILE activation groups Explain the behavior of error handling and percolation in ILE Code an ILE error handling program Call application program interfaces (APIs) from RPG IV program Programmers who can write comprehensive RPG IV programs using the IBM i RPG IV compiler (v7), learn additional skills & techniques. Comprehensive exposure to advanced features of the Integrated Language Environment (ILE) RPG compiler and the IBM i. Programmers who can write comprehensive RPG IV programs using the IBM i RPG IV compiler (v7), learn additional skills & techniques. Comprehensive exposure to advanced features of the Integrated Language Environment (ILE) RPG compiler and the IBM i.

Description: Microsoft Excel 2016 and VBA continues Velsoft's in-depth training material for Excel 2016. This course covers the duration of five lessons, by taking it you will get the skills you need to harness Visual Basic for Applications, or VBA, to automate many tasks you will encounter while using Excel 2016. This course will help you to get all the knowledge you need to gain about Microsoft Excel 2016 and VBA. So, if you are interested to develop your skills and knowledge, you shouldn't be late to join this course. Learning Outcomes: Best ways to utilize Macro Recorder, how to edit and debug a macro, and setting up macro security Customizing the Quick Access toolbar and hotkeys Utilizing Macros to insert and format texts, sort and duplicate data, and generate reports Determine appropriate dialog box types to use Using variety of techniques to capture user input Managing worksheets using macros Creating user-defined functions and ways to automate SUM functions with macros Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Excel 2016 and VBA is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Excel 2016 and VBA is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Developing Macros Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Formatting Worksheets Using Macros Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Creating an Interactive Worksheet Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Working with Multiple Worksheets Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Performing Calculations Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2016 and VBA 00:20:00 Final Exam Final Exam- Microsoft Excel 2016 and VBA 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Content Management System is now the most popular computer software that is used to create and modify digital contents. This course has been illustrated to educate you on how it functions. It discusses the fundamental aspects of CMS. Hit the course to enter into the digital world. Start learning Content Management System Training that will give you enough knowledge and skills to build your dream career. About this course This Content Management System Training helps to grow your skills faster through the power of relevant content and world-class tutors. In this industry-leading bite-sized course, you will learn up-to-date knowledge in the relevant field within a few hours and get certified immediately. The modules of this course are very easy to understand and all of the topics are split into different sections. You will easily grasp and use the knowledge gained from this course in your career and go one step ahead of your competitors. The course is designed to improve your employability and provide you with the tools you need to succeed. Enrol today and start learning your essential skills. Why choose this course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Get 24/7 help or advice from our email and live chat teams Get full tutor support on weekdays (Monday to Friday) Course Design The Content Management System Training is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Who Is This Course For:​ This Content Management System Training is ideal for those who want to be skilled in this field or who wish to learn a new skill to build their dream career. If you want to gain extensive knowledge, potential experience, and be an expert in the related field then this is a great course for you to grow your career. Requirements This course is for anyone who would like to learn Content Management System Training related skills to aid his/her career path. No formal entry prerequisites are required Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Course Content Module 1: Content Management Basics Module 2: Introduction to Content Management System (CMS) Module 3: Fundamentals of Content Management System Course Content Content Management Basics Module 1: Content Management Basics 00:18:00 Module 2: Introduction to Content Management System (CMS) 00:09:00 Module 3: Fundamentals of Content Management System 00:17:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

GDPR Data Protection Law [Updated 2023] Stay ahead in compliance with our updated 2023 GDPR Data Protection Law course. Equip yourself with the latest in GDPR Data Protection standards. Secure your organisation's future with comprehensive GDPR Data Protection knowledge. Learning Outcomes: Navigate the Introduction to GDPR for compliance. Uphold the Principles of GDPR in data management. Ensure Lawful Basis for Processing personal data. Defend the Rights of Data Subject under GDPR. Differentiate roles of Data Controller and Processor. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from GDPR Data Protection Law [Updated 2023]: Introduction to GDPR: Familiarise yourself with the GDPR's scope and its impact on GDPR Data Protection practices. Principles of GDPR: Grasp the key GDPR principles that underpin effective GDPR Data Protection strategies. Lawful Basis for Processing: Understand the legal grounds for processing personal data within GDPR Data Protection frameworks. Rights of Data Subject: Recognise the rights individuals hold over their data, a cornerstone of GDPR Data Protection. Data Controller and Data Processor: Define and distinguish between the responsibilities of data controllers and processors under GDPR Data Protection laws. Data Protection by Design and by Default: Implement GDPR Data Protection requirements throughout your data processing activities. Security of Data: Master the security measures required to protect data in line with GDPR Data Protection guidelines. Data Breaches: Learn how to effectively manage and report data breaches in accordance with GDPR Data Protection procedures. Workplace and GDPR: Apply GDPR Data Protection policies within your organisational processes and workplace culture. Transferring Data Outside of EEA: Navigate the complexities of transferring data internationally under GDPR Data Protection rules. Exemptions: Identify the exemptions within GDPR Data Protection law and how they may apply to certain data processing scenarios.

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Power Query and Power Pivot in Microsoft Excel:  A Quickstart Guide   Course Description   Copyright Ross Maynard 2022   Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.     Key Learning Points  On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot     Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented.     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations   Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases     Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets     Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise   The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user   As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI   How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type  

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step