691 Microsoft courses in Cardiff delivered Live Online

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

Duration 5 Days 30 CPD hours This course is intended for This course is recommended for application or system support personnel or anyone who needs an overview of the capabilities of HP UD 10.1x. Overview Upon successful completion of this course, you should be able to: Identify the evolution of the Configuration Management System (CMS) from the Configuration Management Database (CMDB), the need for CMS, and working of CMS Define the concept of Universal Discovery (UD) and be able to identify its applications and types Identify the architecture and deployment process of UD, and the installation and setup of the data flow probe and its log files Define the concepts of discovery adapters, discovery jobs, discovery scripts, and other discovery resources Use the Universal Discovery module to perform application dependency mapping discovery and inventory discovery Use zone-based discover method and discovery activities Design and build agentless and agent-based discoveries, and use inventory scanners Work with the Software Library Viewer and various inventory tools Use the application recognition process, and discovery rules HP This course is designed to provide an understanding of the fundamental concepts and applications of the HP Universal Discovery (UD) solution. This course is designed to provide an understanding of the fundamental concepts and applications of the HP Universal Discovery (UD) solution.

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience. Overview Upon successful completion of this course, students will understand the programming environment of Visual Basic for applications and know how to create custom procedures and functions that can expand their ability to use Excel more effectively. This course is intended for the experienced Excel users that want to gain knowledge of visual basic for applications (VBA). Introduction to Macros Recording Macros Absolute and Relative How to Run a Macro Basics of Code Writing The VBA Environment (the ?VBE? window) Essential Tips, Tricks, Shortcuts Understanding VBA and Best Practice Crucial VBA Objects and Structures Variables and Data Types Conditionals (If, Select Case) Loops (For, Do) Interaction Interact with Data, Sheets, the Excel Application Interact with User (Message Box, Input Box) Errors Run Editing Debuging Handeling Errors Additional course details: Nexus Humans Excel - VBA Bootcamp 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 Excel - VBA Bootcamp 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 This class is designed for experienced BizTalk Server Developers who have at least one year of hands-on experience developing BizTalk Server applications. Overview In this 5-day course, you will learn how to apply best practices and design patterns to build smarter BizTalk Server applications. Furthermore, this course provides extensive coverage of BizTalk Server's extensibility, including such topics as: custom functoids, custom pipeline components, and invoking external .NET methods. This course is designed specifically for experienced BizTalk Server developers and focuses on best practices & pattern-based design while pulling back the curtain on some of BizTalk Server's eccentricities. Review of BizTalk Server Fundamentals The BizTalk Server Architecture Inner Workings of the Messaging Engine Messaging Engine Deep Dive Two-way Messaging Without Orchestrations Designing and Testing Schemas Schema Design Enabling Unit Testing for BizTalk Projects Data Translation and Transformation Custom Data Transformation Creating Custom Pipeline Components Working with Message Interchanges Debatching Message Interchanges Advanced Concepts of WCF Adapters Connecting to External Systems Using WCF LOB Adapters in BizTalk Server Publishing and Consuming WCF and RESTful Services Overview of Service Integration Using WCF Implementing WCF Services Preprocessing Messages with IIS Modules Consuming Services Advanced Orchestration Communication Patterns Orchestration Engine Deep Dive Splitting and Aggregating Messages using Orchestrations Orchestration Communication Bridging the Synchronous/Asynchronous Gap Across Multiple Channels Correlating Messages in Orchestration Instances Building Convoy Orchestrations Handling Orchestration Faults and Exceptions Exception Handling in Orchestrations Implementing Transactions and Compensation Creating Transactional Processes Designing Custom Tracking Models for BizTalk Applications Introduction to Business Activity Monitoring Enabling Business Activity Monitoring Extending BAM Beyond BizTalk Building Declarative Logic Using the Business Rules Engine Concepts of Declarative Logic Fundamentals of BizTalk BRE Integrating Policies with BizTalk Advanced Concepts of the Business Rules Engine Advanced Business Rule Concepts Working with Advanced Facts Integrating Across Business Boundaries Using Parties, Roles, and EDI Port Binding Option Review Role-Based Integration What is EDI? Enabling EDI-Based Messaging

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

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

Learn how to use OneNote to create, organize and populate electronic notebooks. Course overview Duration: 4 hours OneNote is a digital notebook and can be a great way to easily take notes. Whether for meetings, on training courses or to help with to do lists. It works very much like it’s paper copy equivalent but, of course, with lots of enhanced features. Its integration with Outlook and the other office applications means you can easily take notes and link them to documents meeting details and then email them out. You can even add audio and video notes as reminders. Objectives  By the end of the course you will be able to: Create and manage notebooks Add contents Tag and prioritise content Create notes from other applications Create To Do Lists and integrate into Outlook Content Using OneNote Creating notebooks Creating sections and pages Formatting pages Using page templates Creating page templates Reordering sections and pages Deleting sections and pages Creating OneNote content Adding text Bullet lists Adding tables Adding images Adding drawings Adding links Adding audio and video notes Tagging Tagging Creating custom tags Creating to-do lists Searching and filtering for tags Notes Creating quick notes Filtering them in OneNote notebooks Linked notes Outlook integration Linking to tasks in Outlook Flagging notes for follow up Inserting Outlook meeting content Taking minutes Emailing OneNote pages Send emails to OneNote

There is so much more to this free tool than just creating PDFs. Learn what else you can do for free. Duration: 2 hours This Adobe Acrobat Reader course looks at the features of the Acrobat Reader tool. Learn how to create PDF and what options you have, complete and sign and mark up PDFs. Objectives  By the end of the course you will be able to: Create PDFs from other tools Complete and sign documents Mark up PDF documents Content Creating PDFs Building PDF documents from Word, Excel and PowerPoint Working in Acrobat Home, Tools and Document Views Using the Navigation Panel and Pane Floating toolbar and Contextual menus Completing and signing documents Using fill and sign to complete forms Adding signatures Marking up documents Marking up changes Using sticky notes Using the highlighter pen Adding stamps Attaching documents and audio

Learn how to create fully relational databases and how to input, extract and report on data. Course overview Duration: 2 days (13 hours) Our Access Database Design and reporting course looks at the key elements to building fully relational databases and entering and extracting information from them. This course is designed for new users who need to build relational database systems. Objectives  By the end of the course you will be able to: Create a new database Create data tables Set field validation and properties Enter data and manage data Create forms Use queries to extract data Create parameter queries Create calculations in queries Build relational databases Use sub datasheets Build multi table queries Use advanced form and report design techniques Content Creating a database Creating a new database Database elements Creating a data table Setting field properties Using input masks Using input masks Validation rules Default values Setting a primary key Creating lookup fields Data entry Adding data Deleting data Quick keys for data entry Working with data Sorting data Filtering data Finding information Navigation Creating data form Creating quick forms The form wizard Amending forms Formatting Setting the tab order Entering data using forms Creating queries Creating a query Setting criteria Using the expression builder Creating parameter queries Using wildcards Using more than one parameter Using calculations in queries Adding a totals row Formatting results Adding calculations Printing and reporting Printing tables and queries Creating reports Building and amending reports Adding headers and footers Working with relational databases Relational database principles Importing data from other sources Linking information between tables One-to-one and one-to-many links Defining referential integrity Amending links Deleting links Sub datasheets Viewing a subdatasheet Removing a subdatasheet Connecting a subdatasheet Multiple table queries Deciding which tables to use Adding tables to the query Creating links between tables Setting join properties Advanced form design Field properties Creating lookup fields Adding calculated fields Applying conditional formatting Advanced report design Field properties Report properties Alternate colour bandings Concatenating fields Adding calculated fields Sorting and grouping Grouping settings Adding headers and footers Adding dates, times, page numbers

Learn the proper way to use PowerPoint and the background features that can make a real difference. Course overview Duration: 1 day (6.5 hours) Our PowerPoint – Professional Presentations course looks at creating professional, business focussed presentations quickly and easily. It ensures delegates are aware of the key concepts in using the tool such as slide masters and by the end of the day you will be able to create and run high quality presentations. This course is designed for new and existing users of PowerPoint who want to get the best out of the tool. Objectives  By the end of the course you will be able to: Create a new presentation Amend the slide master/template Create text slides Animate text on slides Insert pictures and objects Set object animation Insert and work with SmartArt Create charts Run a presentation Content Creating a new presentation Creating a new presentation from a template Using your company template Changing slide layouts Copying, deleting and inserting slides Using the slide master Modifying the Slide Master Using Slide layouts Multiple Slide Masters Slide dates, footers and numbers Creating text slides Working with bullet points Setting spacing Changing text and bullet styles Using Outline view Text animation on a slide Slide titles Bullet points Applying animation to the Slide Master Animating text Slide titles Bullet points Applying animation to Slide Master Drill Down vs Drill Through Review of drill down Creating drill through pages Using drill through Inserting and working with pictures Inserting pictures Inserting online pictures Formatting pictures Adding Drawings Inserting lines and shapes Using Quick Styles Selecting and grouping objects Aligning and positioning objects Add text to a shape Duplicating objects Object animation Simple object animations Working with SmartArt Inserting SmartArt Graphics SmartArt formatting Converting text to SmartArt Inserting charts Creating a slide with a graph Changing chart types Setting chart options Graph animations Presenting your presentation Slide show settings Using Presenter view Using the PowerPoint viewer Slide show presentation tips