1633 Office courses in Cardiff delivered Live Online

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report

Duration 2 Days 12 CPD hours This course is intended for Data Modelers Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing a dynamic cube, and enabling end users to easily author reports and analyze data. Introduction to IBM Cognos Dynamic Cubes Define and differentiate Dynamic Cubes Dynamic Cubes characteristics Examine Dynamic Cube requirements Examine Dynamic Cube components Examine high level architecture IBM Cognos Dynamic Query Review Dimensional Data Structures Dynamic Cubes caching Create & Design a Dynamic Cube Explore the IBM Cognos Cube Designer Review the cube development process Examine the Automatic Cube Generation Manual development overview Create dimensions Model the cube Best practice for effective modeling Deploy & Configure a Dynamic Cube Deploy a cube Explore the Estimate Hardware Requirements Identify cube management tasks Examine Query Service administration Explore Dynamic Cube properties Schedule cube actions Use the DCAdmin comment line tool Advanced Dynamic Cube Modelling Examine advanced modeling concepts Explore modeling caveats Calculated measures and members Model Relative Time Explore the Current Period property Define period aggregation rules for measures Advanced Features of Cube Designer Examine multilingual support Examine ragged hierarchies and padding members Define Parent-Child Dimensions Refresh Metadata Import Framework Manager packages Filter measures and dimensions Optimize Performance with Aggregates Identify aggregates and aggregate tables In-memory aggregates Use Aggregate Advisor to identify aggregates User defined in-memory aggregates Optimize In-Memory Aggregates automatically Aggregate Advisor recommendations Monitor Dynamic Cube performance Model aggregates (automatically vs manually) Use Slicers to define aggregation partitions Define Security Overview of Dynamic Cube security Identify security filters The Security process - Three steps Examine security scope Identify scope rules Identify roles Capabilities and access permissions Cube security deep dive Model a Virtual Cube Explore virtual cubes Create the virtual cube Explore virtual cube objects Examine virtual measures and calculated members Currency conversion using virtual cubes Security on virtual cubes Introduction to IBM Cognos Analytics Define IBM Cognos Analytics Redefined Business Intelligence Self-service Navigate to content in IBM Cognos Analytics Interact with the user interface Model data with IBM Cognos Analytics IBM Cognos Analytics components Create reports Perform self-service with analysis and Dashboards IBM Cognos Analytics architecture (high level) IBM Cognos Analytics security Package / data source relationship Create Data modules Upload files Additional course details: Nexus Humans B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0) 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 B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0) 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.

Course Summary: This workshop is designed for Club Welfare Officers and it is highly recommended that attendees complete UK Coaching's Safeguarding and Protecting Children Workshop first. Are you new to the Welfare Officer role or has it been three years since you last attended a Time to Listen workshop? The 3 hour workshop covers the following and learners will be able to: Describe how a club welfare officer works with others to create a child centered environment. Explain how the club welfare officer role fits into the wider safeguarding environment. Apply learning to case studies including sharing good safeguarding practice.

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

Duration 4 Days 24 CPD hours This course is intended for This course is the first in a series of two courses designed for programmers who are new to RPG IV. Basic programming experience is required. The student should have attended at least an introductory course to programming such as one of those available at technical colleges. The student is not taught the concepts of programming. Experienced programmers who are new to the Power System with IBM i should also attend this course. Examples of other programming languages are BASIC, COBOL, or RPG II. This course focuses entirely on the features of the RPG IV Version 7 compiler and the techniques that this compiler provides. Features of V7 are discussed. Previous techniques and the maintenance of programs that are written using legacy techniques, such as fixed format calculations, are not covered in the classroom. Some additional material and the bibliography will assist the new RPG IV programmer in the maintenance of legacy applications. Overview Write RPG IV version 7.1 programs to produce reportsWrite simple RPG IV version 7.1 inquiry programs that interact with displaysReview compilation listing, find and correct compilation errorsMaintain existing applications written in the RPG IV Version 7.1 languageUse many popular RPG IV built-in functions This course is a comprehensive exposure to the basic features and functions of RPG IV for Version 7. Course Outline RPG IV introduction Coding specifications for RPG IV Data representation and definition Manipulating data in calculations Using printer and display files in an RPG IV program Structured programming, error handling, subprocedures, and subroutines Using arrays, data structures, and data areas Accessing the DB2 database using RPG IV What's next? Additional course details: Nexus Humans AS06 IBM RPG IV Programming Fundamentals Workshop for IBM i 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 AS06 IBM RPG IV Programming Fundamentals Workshop for IBM i 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.

Read and discuss this witty, best-selling murder mystery - clever and compelling Highlights Join this book club and gain extra motivation to read in English 7 hours of live classes to help you develop fluent speaking in English Read this amusing book to develop your understanding of colloquial English Be corrected by an expert English teacher to remove errors and mistakes Practise and develop your English online in this 7 week English book club course using the Richard Osman's new series after The Thursday Murder Club, We Solve Murders. Each week you read some chapters, discuss them in class and improve specific areas of vocabulary or grammar while also examining literary aspects of the novel. Personalised feedback improves your grammar, vocabulary and pronunciation. The Book Club book This is the first in a new series for detective duo Steve and Amy Wheeler. Steve is happily retired and likes his routines: the pub quiz, sitting outside, his cat. His past was full of adventure, but now he likes a quiet life. His daughter-in-law Amy, however, loves adrenaline. She's a private security officer, protecting a world-famous author Rosie D’Antonio on a remote island. It should be a simple job, until there's a murder, a lot of money and someone trying to kill Amy. This thriller is filled with action, amusing lines and warmth. And you need to work out "whodunnit" - who committed the crime! 'The thing that shines through in Osman’s writing is that he really likes people and revels in all their foibles and eccentricities. All of which makes for a delightful read' THE OBSERVER Geoff says: "Richard Osman is the famous author of the best-selling Thursday Murder Club series. This new book has broken all records as the best-selling adult hardback fiction book in the UK. It is full of action, yet witty, with interesting characters, and full of British English idioms and colloquialisms - great for improving your knowledge of how English is actually spoken!"

Read and discuss this witty, best-selling murder mystery - clever and compelling Highlights Join this book club and gain extra motivation to read in English 7 hours of live classes to help you develop fluent speaking in English Read this amusing book to develop your understanding of colloquial English Be corrected by an expert English teacher to remove errors and mistakes Practise and develop your English online in this 7 week English book club course using the Richard Osman's new series after The Thursday Murder Club, We Solve Murders. Each week you read some chapters, discuss them in class and improve specific areas of vocabulary or grammar while also examining literary aspects of the novel. Personalised feedback improves your grammar, vocabulary and pronunciation. The Book Club book This is the first in a new series for detective duo Steve and Amy Wheeler. Steve is happily retired and likes his routines: the pub quiz, sitting outside, his cat. His past was full of adventure, but now he likes a quiet life. His daughter-in-law Amy, however, loves adrenaline. She's a private security officer, protecting a world-famous author Rosie D’Antonio on a remote island. It should be a simple job, until there's a murder, a lot of money and someone trying to kill Amy. This thriller is filled with action, amusing lines and warmth. And you need to work out "whodunnit" - who committed the crime! 'The thing that shines through in Osman’s writing is that he really likes people and revels in all their foibles and eccentricities. All of which makes for a delightful read' THE OBSERVER Geoff says: "Richard Osman is the famous author of the best-selling Thursday Murder Club series. This new book has broken all records as the best-selling adult hardback fiction book in the UK. It is full of action, yet witty, with interesting characters, and full of British English idioms and colloquialisms - great for improving your knowledge of how English is actually spoken!"

Read and discuss this witty, best-selling murder mystery - clever and compelling Highlights Join this book club and gain extra motivation to read in English 7 hours of live classes to help you develop fluent speaking in English Read this amusing book to develop your understanding of colloquial English Be corrected by an expert English teacher to remove errors and mistakes Practise and develop your English online in this 7 week English book club course using the Richard Osman's new series after The Thursday Murder Club, We Solve Murders. Each week you read some chapters, discuss them in class and improve specific areas of vocabulary or grammar while also examining literary aspects of the novel. Personalised feedback improves your grammar, vocabulary and pronunciation. The Book Club book This is the first in a new series for detective duo Steve and Amy Wheeler. Steve is happily retired and likes his routines: the pub quiz, sitting outside, his cat. His past was full of adventure, but now he likes a quiet life. His daughter-in-law Amy, however, loves adrenaline. She's a private security officer, protecting a world-famous author Rosie D’Antonio on a remote island. It should be a simple job, until there's a murder, a lot of money and someone trying to kill Amy. This thriller is filled with action, amusing lines and warmth. And you need to work out "whodunnit" - who committed the crime! 'The thing that shines through in Osman’s writing is that he really likes people and revels in all their foibles and eccentricities. All of which makes for a delightful read' THE OBSERVER Geoff says: "Richard Osman is the famous author of the best-selling Thursday Murder Club series. This new book has broken all records as the best-selling adult hardback fiction book in the UK. It is full of action, yet witty, with interesting characters, and full of British English idioms and colloquialisms - great for improving your knowledge of how English is actually spoken!"

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