28557 Courses

Duration 2 Days 12 CPD hours This course is intended for Report Authors Overview Create query models Create reports based on query relationships Introduction to dimensional data Introduction to dimensional data in reports Dimensional report context Focus your dimensional data Calculations and dimensional functions Create advanced dynamic reports This offering teaches Professional Report Authors about advanced report building techniques using relational data models, dimensional data, and ways of enhancing, customizing, managing, and distributing professional reports. The course builds on topics presented in the Fundamentals course. Activities will illustrate and reinforce key concepts during this learning activity. Create query models Build a query and connect it to a report Answer a business question by referencing data in a separate query Create reports based on query relationships Create join relationships between queries Combine data containers based on relationships from different queries Create a report comparing the percentage of change Introduction to dimensional reporting concepts Examine data sources and model types Describe the dimensional approach to queries Apply report authoring styles Introduction to dimensional data in reports Use members to create reports Identify sets and tuples in reports Use query calculations and set definitions Dimensional report context Examine dimensional report members Examine dimensional report measures Use the default measure to create a summarized column in a report Focus your dimensional data Focus your report by excluding members of a defined set Compare the use of the filter() function to a detail filter Filter dimensional data using slicers Calculations and dimensional functions Examine dimensional functions Show totals and exclude members Create a percent of base calculation Create advanced dynamic reports Use query macros Control report output using a query macro Create a dynamic growth report Create a report that displays summary data before detailed data and uses singletons to summarize information Design effective prompts Create a prompt that allows users to select conditional formatting values Create a prompt that provides users a choice between different filters Create a prompt to let users choose a column sort order Create a prompt to let users select a display type Examine the report specification Examine report specification flow Identify considerations when modifying report specifications Customize reporting objects Distribute reports Burst a report to email recipients by using a data item Burst a list report to the IBM Cognos Analytics portal by using a burst table Burst a crosstab report to the IBM Cognos Analytics portal by using a burst table and a master detail relationship Enhance user interaction with HTML Create interactive reports using HTML Include additional information with tooltips Send emails using links in a report Introduction to IBM Cognos Active Reports Examine Active Report controls and variables Create a simple Active Report using Static and Data-driven controls Change filtering and selection behavior in a report Create interaction between multiple controls and variables Active Report charts and decks Create an Active Report with a Data deck Use Master detail relationships with Decks Optimize Active Reports Create an Active Report with new visualizations

Duration 2 Days 12 CPD hours Overview What's New in This Guide? The behind-the-scenes journal entry for transactions is now included. This course is a continuation of topics following ?Get Started with QuickBooks 2020 for Windows?. First-time QuickBooks users will learn the basic features of the software. Experienced QuickBooks users will quickly learn the new features and functionality of QuickBooks 2020. This course covers features that are in QuickBooks Pro and Premier 2020. Memorizing Transactions Entering a New Memorized Transaction Editing a Memorized Transaction Deleting a Memorized Transaction Grouping Memorized Transactions Using a Memorized Transaction Printing the Memorized Transaction List Customizing Forms Creating a Custom Template Modifying a Template Printing Forms Using Other QuickBooks Accounts Other QuickBooks Account Types Working with Credit Card Transactions Working with Fixed Assets Working with Long-Term Liability Accounts Using the Loan Manager Creating Reports Working with Quick Reports Working with Preset Reports Sharing Reports Exporting Reports to Microsoft Excel Printing Reports Creating Graphs Creating QuickInsight Graphs Using QuickZoom with Graphs Working with the Sales Graph Customizing Graphs Printing Graphs Tracking and Paying Sales Tax Using Sales Tax in QuickBooks Setting Up Tax Rates and Agencies Indicating Who and What Gets Taxed Applying Tax to Each Sale Determining What You Owe Paying Your Tax Agencies Preparing Payroll with QuickBooks Using Payroll Tracking Setting Up for Payroll Setting Up Employee Payroll Information Setting Up a Payroll Schedule Writing a Payroll Check Printing Paycheck Stubs Tracking Your Tax Liabilities Paying Payroll Taxes Preparing Payroll Tax Forms Using Online Banking Setting Up an Internet Connection Setting Up Bank Feeds for Accounts Viewing, Downloading, and Adding Online Transactions Creating Online Payments Transferring Funds Online Canceling Online Payments Managing Company Files Using QuickBooks in Multi-user Mode Setting Up Users and Passwords Setting a Closing Date Sharing Files with an Accountant Updating QuickBooks Backing Up and Restoring a Company File Condensing a Company File Estimating, Time Tracking, and Job Costing Creating Job Estimates Creating an Invoice from an Estimate Displaying Reports for Estimates Updating the Job Status Tracking Time Displaying Reports for Time Tracking Tracking Vehicle Mileage Displaying Vehicle Mileage Reports Displaying Other Job Reports Writing Letters Using the Letters and Envelopes Wizard Customizing Letter Templates

Duration 3 Days 18 CPD hours This course is intended for Authors Overview Please refer to course overview This course provides authors with an introduction to build reports using Cognos Analytics. Techniques to enhance, customize, and manage reports will be explored. Activities will illustrate and reinforce key concepts during this learning opportunity. What is IBM Cognos Analytics - Reporting The Welcome page Consume report content Interactive filtering Working with reports Dimensionally modeled relational dataUse personal data sources and data modules Upload personal data Upload custom images Using navigation paths in a data module Examine list reports Group data Format columns Include headers and footers Aggregate fact data Identify differences in aggregation Multiple facts and repeated information Use shared dimensions to create multi-fact queries Present repeated information Add repeated information to reports Create a mailing list report Create crosstab reports Add measures to a crosstab Data sources for a crosstab Create complex crosstab reports Add items as peers Create crosstab nodes and crosstab members Work with crosstab data Format, sort, and aggregate a crosstab Create discontinuous crosstab reportsCreate visualization reports Visualization categories Customize visualizations Client side visualizations Enhanced map visualizations Focus reports using filters Create filters to narrow the focus Use advanced detail filters Apply a filter with aggregation Use summary filters Focus reports using prompts Examine parameters and prompts Create a parameter for a report item Add a prompt page Add a prompt item to a report Identify a prompt type Create a cascading prompt Use calculations What are calculations Add Date and Time functions Add string functions Display prompt selections in report titles Customize reports with conditional formatting Three steps for conditional formatting Create a variable Assign the variable to a report object Format based on the conditional value Conditionally render report objects Drill-through definitions Navigate to related data Enhance report layout View the structure of a report Use Guided report layout Force page breaks Create horizontal pagination Modify the report structure Format objects across reports Use additional report-building techniques Enhance a report design Add objects to reports Convert a list to a crosstab Explore reuse Additional course details: Nexus Humans B6258 IBM Cognos Analytics - Author Reports Fundamentals V11.1.x 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 B6258 IBM Cognos Analytics - Author Reports Fundamentals V11.1.x 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 Report authors working with dimensional data sources. Through interactive demonstrations & exercises, participants will learn how to author reports that navigate & manipulate dimensional data structures using the specific dimensional functions & features available in IBM Cognos Analytics. Introduction to Dimensional Concepts Identify different data sources and models Investigate the OLAP dimensional structure Identify dimensional data items and expressions Differentiate the IBM Cognos Analytics query language from SQL and MDX Differentiate relational and dimensional report authoring styles Introduction to Dimensional Data in Reports Work with members Identify sets and tuples in IBM Cognos Analytics Dimensional Report Context Understand the purpose of report context Understand how data is affected by default and root members Focus Your Dimensional Data Compare dimensional queries to relational queries Explain the importance of filtering dimensional queries Evaluate different filtering techniques Filter based on dimensions and members Filter based on measure values Filter using a slicer Calculations & Dimensional Functions Use IBM Cognos Analytics dimensional functions to create sets and tuples Perform arithmetic operations in OLAP queries Identify coercion errors and rules Functions for Navigating Dimesional Hierarchies Navigate dimensional data using family functions Relative Functions Navigate dimensional data using relative functions Navigate dimensional data using relative time functions Advanced Drilling Techniques & Member Sets Understand default drill-up and drill-down functionality Identify cases when you need to override default drilling behavior Configure advanced drilling behavior to support sophisticated use cases Define member sets to support advanced drilling Define member sets to support functions Set Up Drill-Through Reports Navigate from a specific report to a target report Drill down to greater detail and then navigate to target report Navigate between reports created using different data sources End-to-End Workshop Review concepts covered throughout the course

Duration 3.5 Days 21 CPD hours This course is intended for Intermediate Users of Office 365 and Excel Overview Creating Advanced Formulas Analyzing Data with Logical and Lookup Functions Organizing Worksheet Data with Tables Visualizing Data with Charts Analyzing Data with PivotTables, Slicers, and PivotCharts Inserting Graphics Enhancing Workbooks This course builds upon the foundational Microsoft Office Excel 2016, you create advanced workbooks and worksheets using advanced formulas and organizing your data into tables. Excel Intermediate Learn how to navigate Pivot Tables, (for example, Create a Pivot Table/ add data/ Add calculations); Formulas, Data organization (for example, multiple worksheets) Excel Advanced Data Analysis (for example, sparklines) , Macros (making changes to macros) and Building A Fast Dashboard (PivotCharts, slicers, etc.) Office 365 Training Getting More with OneDrive Office 365 Training When is a Team a Team? Includes Using Video with Audio, Exploring Teams/Navigating among Teams etc.

Join us for a round table discussion with Ginger Gregory, CHRO. Age Diversity and Inclusivity: From Early Career and beyond, How do we best grow our talent? As part of the UKI Wellbeing day we’re inviting everyone to participate in one of a series of roundtable focus groups hosted by HR and Ginger Gregory, our CHRO. These sessions are current organisational challenges designed to foster open dialogue, enhance collaboration, and gather your valuable insights. This is an opportunity to connect, share experiences, and contribute meaningfully to our organisation.

For Excel users. Extend the capabilities of Excel with Macros and VBA code.

Duration 48.125 Days 288.75 CPD hours Cisco Learning Library: Collaboration provides on-demand training to help your IT staff design, implement, manage, and troubleshoot your organization?s collaboration and video infrastructure based on Cisco collaboration and unified communications solutions.This comprehensive technical training library includes full-length interactive certification courses, product and technology courses with labs, and thousands of reference materials. Collaboration Library Certification Courses CCNP Collaboration Implementing Cisco Collaboration Core Technologies (CLCOR) v1.0 Implementing Cisco Collaboration Applications (CLICA) v1.0 Implementing Cisco Advanced Call Control and Mobility Services (CLACCM) v1.0 Implementing Cisco Collaboration Cloud and Edge Solutions (CLCEI) v1.0 Implementing Automation for Cisco Collaboration Solutions (CLAUI) v1.0 CCIE Collaboration Implementing Cisco Collaboration Core Technologies (CLCOR) v1.0 Product and technology training Cisco Video Infrastructure Design (VID) v1.0 Developing Applications for Cisco Webex and Webex Devices (DEVWBX) v1.0 Implementing Automation for Cisco Collaboration Solutions (CLAUI) v1.0 Implementing Cisco Advanced Call Control and Mobility Services (CLACCM) v1.0 Implementing Cisco Collaboration Applications (CLICA) v1.0 Implementing Cisco Collaboration Cloud and Edge Solutions (CLCEI) v1.0 Implementing Cisco Collaboration Core Technologies (CLCOR) v1.0 Understanding Cisco Collaboration Foundations (CLFNDU) v1.0

Slinger Signaller Training The aim of the NPORS Slinger Signaller Training or Slinger Signaller Course is to provide both theoretical and practical training in the safe and efficient operation of slinging and moving loads using hand signals or radios Guided by the Lift Supervisor. On successful completion of the slinger and signaller course you will be issued with the NPORS Slinger Signaller trained identity card with or without the CSCS Logo or testing can be carried out on your site nationwide or at our training centre in Gloucestershire NPORS Slinger Signaller Test Book with Confidence at Vally Plant Training At Vally Plant Training, we guarantee unbeatable value with our Slinger And Signaller Test Price Match Promise. When you choose us, you can book with confidence, knowing that we will not be beaten on price. If you find a lower price for the same NPORS Slinger and Signaller Worker Test, we’ll match it—ensuring you receive top-quality training at the best possible rate. Click for our terms and conditions Your skills, our commitment—always at the best price. NPORS Slinger Signaller Experienced Worker Test .This test is for operators who have received some form of training in the past or alternatively has been operating as a Slinger Signaller for a period of time. If you are unsure if you qualify to go down the test route please contact us to discuss this in more detail. This test is held at our test centre in Gloucestershire or at your site nationwide. Discounts are available for multiple bookings Turn your Slinger Signaller red card to blue with our hassle free NVQ, for more information CLICK HERE Slinger Signaller Course Duration Novice: 2 days, maximum of 3 candidates Experienced Worker Test: 1 day test only, maximum of 6 candidates. Location: Tewkesbury Training Centre At Our Customers Site*: Our instructors travel throughout the UK to deliver the slinger signaller training *Mileage and accommodation charges may apply Certification NPORS Traditional card – lasts for 5 years and is mainly accepted with housebuilders, utilities, port and marine as proof of competence OR NPORS card with CSCS logo – accepted by all major building contractor’s. The initial card is the RED trained operator card which lasts for 2 years and can be upgraded to BLUE competent operator card further to completion of relevant NVQ. CSCS Health & Safety Test If you require the NPORS Slingers Red operator card with the CSCS logo on then you must have completed the operatives health and safety test within the last two years. In house certificates: suitable as proof of operator competence accepted for insurance and HSE compliance. Slinger Signaller Course Contents: A Slinger Signaller course typically covers a range of topics related to the safe operation of lifting equipment and the signalling procedures involved in crane and lifting operations. While specific course contents may vary depending on the training provider and the regulations of the region, here’s a general outline of what will be included: 1. Introduction to Lifting Operations: Overview of lifting equipment and machinery. Importance of safe lifting operations. Legal and regulatory requirements for lifting operations, LOLLER, PUWER and BS 7121. 2. Roles and Responsibilities of Slinger and Signaller: Duties of the slinger signaller. Understanding the roles of other personnel involved in lifting operations (crane operator, banksman, etc.). Importance of effective communication and coordination. 3. Health and Safety: Risk assessment and hazard identification. Personal protective equipment (PPE) requirements. Safe working practices around lifting equipment and machinery. 4. Lifting Equipment and Accessories: Types of lifting equipment (cranes, hoists, slings, etc.). Inspection and maintenance requirements for lifting gear. Proper selection and use of lifting accessories. 5. Signals and Communication: Standard hand signals for crane operations. Radio communication procedures between Crane Driver & The Slinger and Signaller. Clear and effective communication techniques. 6. Load Identification and Weight Estimation: Methods for identifying loads and determining their weights. Estimating centre of gravity and load stability. 7. Slinging Techniques: Types of slings and their applications. Correct methods for attaching and securing loads. Precautions for different types of loads (e.g., fragile, hazardous). 8. Lifting Operations Planning: Pre-lift checks and planning considerations. Site-specific factors affecting lifting operations (e.g., terrain, weather). Emergency procedures and contingency planning. 9. Practical Exercises and Demonstrations: Hands-on training with lifting equipment and machinery. Practice sessions for signalling and communication. Simulation of real-world lifting scenarios. 10. Assessment and Certification: Written tests to assess theoretical knowledge. Practical assessments of signalling and slinging skills. Certification upon successful completion of the course. It’s essential for the Slinger Signaller Course to provide a balance of theoretical knowledge and practical skills to ensure that participants can effectively carry out their duties as slinger signallers in various lifting operations. Additionally, the course should emphasise the importance of safety and adherence to regulations throughout all aspects of lifting operations. Slinger Signaller Training Available 7 days a week to suit your business requirements. VPT have a team of friendly and approachable instructors, who have a wealth of knowledge of the Slinger Signaller and the construction industry We have our own training centre conveniently located close to the M5 junction 9, In Tewkesbury. With its own purpose-built practical training area to simulate an actual working environment as a slinger signaller Our slinger and signaller training and test packages are priced to be competitive. Discounts are available for multiple bookings We can send a fully qualified NPORS slinger Tester to your site nationwide, to reduce the amount of time away from work Other courses: Master the operation of essential machinery with our Lift Supervision Training, Telehandler Training, Cat & Genny Training, Ride-On Road Roller, Scissor Lift, Abrasive Wheel Training, Lorry Loader Training and Telehandler Training. Elevate your skills for safer and more efficient operations in construction and maintenance projects. Enrol today to advance your career prospects in these industries. Location Advantage: NPORS Slinger Signaller Training Near Me For those looking for a “NPORS Slinger Signaller Training near me,” our widespread operations make it convenient for you to access Vally Plant Trainings top-quality training no matter where you are in the UK

To increase your awareness and understanding of what safeguarding children means, in order to increase your confidence to enable you to make a positive contribution towards the process.