3701 Office Skills courses delivered Online

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables

Use some of the hidden statistical analysis tools within Excel to build complex data models. Course overview Duration: 1 day (6.5 hours) This advanced Excel course looks at some of the statistical analysis tools available and gives examples of when they might be used. This course is aimed at advanced users of Excel who work with statistical data often and have a good knowledge of Maths. Objectives By the end of the course you will be able to: Use Goal Seek Create and view scenarios Use Forecast Sheet Create single and double input data tables Create models using the solver Install and use the Analysis Toolpak Create and use array formulas Use a range of advanced Financial and Statistical Excel functions Content Using what if analysis options Using Goal Seek Creating, saving and viewing scenarios Generating a Forecast sheet Solver Creating models Projecting scenarios with Solver Using data tables Creating single input data tables Creating double input data tables Projecting with data tables Financial functions PMT FV NPV Analysing data with Analysis ToolPak Installing the Analysis Toolpak Generating statistical analysis Visualising data using Histograms Array formulas Using embedded Excel Array formulas Create an Array formula Multi and single cell Array formula Using TRANSPOSE to flip rows or columns Use the FREQUENCY Function Use an array to count unique entries in a range Dynamic arrays Spilling data Using the new dynamic array functions Advance functions in formulas Statistical functions:MEAN, MEDIAN and MODERANKLARGE and SMALLMODPERCENTILE Use the AGGREGATE function to sum data in ranges with errors

Look at the in depth features of charts and some specialist tools to make your charts come to life. Course overview Duration: 1 day (6.5 hours) Our Excel Charting Specialist course examines how to unlock the full potential of Charts in Excel. It investigates the useful tools needed for creating bespoke Charts, allowing you to creatively present data more visually. By the end of the course, you will have an awareness of the tools used for creating more advanced Charts and will be able to create your own Dynamic Charts. The course is designed for existing users of Excel who are looking at more advanced ways to visualise data in Excel using Charts. Objectives By the end of the course you will be able to: Create and Amend Charts Format multiple areas of a Chart Use a Combo Chart Apply Conditional Formatting to a Chart Create Dynamic Charts Work with Custom Formatting Create an Advanced Dynamic Chart Content Creating and amending charts Creating Simple Charts Using the Chart Design tab Adding Chart Elements Changing the type of Chart Formatting charts Format Chart Area Format Data Series Format Data Point Format Axis Working with combo charts Adding additional data to a Chart Customising Chart types Creating Clustered Column/line Charts Applying conditional formatting on charts Using IF Statements Highlighting Max/Min Data points in Charts Using Series Overlap Dynamic charts Creating dynamic Target vs Actual Charts Introducing the NA function Hiding data used for Charts Custom formatting charts Formatting Data Labels Customising number formats Using Trend Arrows to show changes Editing Format Code Advanced dynamic charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Combining all elements to create an Advanced Chart Using Error Bars to create a line Adding a scroll bar and linking with data

Ideal for those already using Excel but who really want to get to grips with formulas and functions. Course overview Duration: 1 day (6.5 hours) Our Excel Mastering Formulas and Functions course looks at how to confidently use formulas and functions within Excel. It looks at how to correctly construct formulas and explains how to build common formulas such as working with percentages. It investigates a range of built in Excel functions and shows you how to use the formula auditing tools to help when things go wrong.  This course is aimed at existing users of Excel who want to further their skills. Participants should be able to confidently create and amend worksheets. Objectives By the end of the course you will be able to: Construct Formulas Use a range of common Functions Work with absolute and relative references in formulas Create percentage calculations Use named ranges in formulas Use the XLOOKUP command Create formulas with date and use date functions Use formulas in conditional formatting Use a range of Count functions Use the formula auditing tools Content Formulas vs Functions Constructing formulas Using functions Common Excel functions Using the function wizard vs the formula bar Formulas in tables Absolute vs relative references in formulas Using absolute references in formulas Using partial absolute referencing Range Naming Naming ranges Using range names in formulas Single and multi-cell ranges Working with percentages Creating formulas with percentages Percentage breakdowns Percentage increases Formatting as a percentage Using Lookups Using XLOOKUP to insert information from other spreadsheets Calculating with dates Calculating with dates Using date functions Using formulas in conditional formatting Using conditional formulas Using functions in conditional formatting Count functions COUNT COUNTA COUNTBLANK Formula auditing Using the auditing facility Tracing how formulas are made up Tracing precedents and dependants Evaluating formulas Error checking Showing formulas on a sheet

Duration 1 Days 6 CPD hours This course is intended for The primary audience for this course is database developers who plan to migrate their MySQL or Postgres DB workloads to Azure SQL DB. The secondary audience for this course is MySQL/Postgres administrators to raise awareness of the features and benefits of Azure SQL DB. Overview At the end of this course, the students will have learned: Migrate on-premises MySQL to Azure SQL DB for MySQL Migrate on-premises PostgreSQL to Azure SQL DB for PostgreSQL This course will enable the students to understand Azure SQL Database, and educate the students on what is required to migrate MySQL and PostgreSQL workloads to Azure SQL Database. Migrate to Azure SQL DB for MySQL & PostgreSQL OSS databases overview Common OSS database workloads Customer challenges in migration Migrate on-premises MySQL to Azure SQL DB for MySQL Configure and Manage Azure SQL DB for MySQL Migrate on-premises MySQL to SQL DB for MySQL Application Migration Post-migration considerations Migrate on-premises PostgreSQL to Azure SQL DB for PostgreSQL Configure and Manage Azure SQL DB for PostgreSQL Migrate on-premises MySQL to SQL DB for PostgreSQL Application Migration Post-migration considerations

Duration 4 Days 24 CPD hours This course is intended for This intermediate course is designed for integration specialists and senior-level developers with experience in IBM Integration Bus application development. Overview After completing this course, you should be able to:Use event driven message processing to control the flow of messages by using message aggregation, message collections, message sequences, and time-sensitive nodesTransform data by using Microsoft .NET and XML stylesheetsAnalyze and filter information in complex XML documentsExtend DFDL message modelsUse message sets and the Message Repository Manager (MRM) parserProvide a message flow application as a web serviceRequest a web service from within a message flowDescribe how to implement WS-Addressing and WS-Security standards in IBM Integration BusCreate an integration serviceCreate and implement an IBM MQ request and response service definitionCreate and implement a database service definitionConfigure security-enabled message processing nodesCreate a decision service that implements business rules to provide routing, validation, and transformationExpose a set of integrations as a RESTful web serviceUse a global cache to store static dataRecord and replay data that a message flow application processesImplement publish and subscribe with IBM Integration BusDescribe the workload management options for adjusting the message processing speed, and controlling the actions that are taken on unresponsive flows and threadsConstruct user-defined patternsDescribe how IBM Integration Bus integrates with other IBM products such as IBM WebSphere Enterprise Service Bus and IBM DataPower Appliances This course focuses on using IBM Integration Bus to develop, deploy, and support platform-independent message flow applications and integration services. Course Outline Course introduction Using event driven processing nodes Exercise: Implementing message aggregation Transforming data with Microsoft .NET Transforming data with XSL stylesheets Analyzing XML documents Modeling complex data with DFDL Exercise: Extending a DFDL model Working with message sets and the MRM domain Supporting web services Exercise: Implementing web services Developing integration solutions by using integration services Exercise: Creating an integration service Connecting a database by using a discovered service Connecting IBM MQ by using a discovered service Exercise: Creating IBM MQ and database services Creating a decision service Exercise: Creating a decision service Developing integration solutions by using a REST API Using the global cache Implementing message flow security Exercise: Implementing IBM Integration Bus runtime security Implementing publish/subscribe Monitoring message flow events Exercise: Recording and replaying message flow data Managing the workload Creating patterns for reusability Extending IBM Integration Bus Course summary Additional course details: Nexus Humans WM676 IBM Integration Bus V10 Application Development II 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 WM676 IBM Integration Bus V10 Application Development II 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 IT professionals interested in understanding the capabilities of the MDS 9000 Series, including: Data center architects Data center engineers IT directors IT managers Network architects Network engineers Solutions architects Systems engineers Overview After taking this course, you should be able to: Describe Cisco MDS SAN features and advantages Define fixed and modular platforms Understand Cisco MDS architecture and high-availability mechanisms Identify technologies used in modern SANs Describe SAN management with Cisco Data Center Network Manager (DCNM) Explain key value-add features that distinguish Cisco MDS switches The Cisco MDS 9000 Series Switches Overview (DCMDSO) v1.5 course gives you a technical overview of how Cisco Multilayer Director Switch (MDS) 9000 Series, can be used to build highly available and scalable storage networks with advanced security and unified management. The course is for technical decision makers and IT professionals who architect, implement, and manage data center Storage Area Network (SAN) environments. In this course, you?ll learn about key capabilities of the MDS 9000 Series, including platforms, architecture, software, management, and key features that contribute to performance, high availability, flexibility, and operational simplicity of storage environments. Define Cisco MDS Platform Overview Introduction and Advantages of Cisco MDS Fixed Platforms Modular Platforms Describe Cisco MDS Architecture Store-and-Forward Architecture High Availability Redundancy Explore Cisco MDS Key Features Virtual Storage Area Networks Port Channels Slow Drain Device and Path Analysis Using Congestion Control Mechanisms Cisco DCNM SAN Insights for SAN Analytics Zoning Smart Zoning Other Differentiating Features Examine Cisco MDS Management Cisco Data Center Network Manager Additional course details: Nexus Humans Cisco MDS 9000 Series Switches Overview v1.5 (DCMDSO) 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 Cisco MDS 9000 Series Switches Overview v1.5 (DCMDSO) 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 4 Days 24 CPD hours This course is intended for This course is designed for technical professionals who require the skills to administer IBM© MQ queue managers on distributed operating systems, in the Cloud, or on the IBM© MQ Appliance. Overview After completing this course, you should be able to:Describe the IBM© MQ deployment optionsPlan for the implementation of IBM© MQ on-premises or in the CloudUse IBM© MQ commands and the IBM© MQ Explorer to create and manage queue managers, queues, and channelsUse the IBM© MQ sample programs and utilities to test the IBM© MQ networkEnable a queue manager to exchange messages with another queue managerConfigure client connections to a queue managerUse a trigger message and a trigger monitor to start an application to process messagesImplement basic queue manager restart and recovery proceduresUse IBM© MQ troubleshooting tools to identify the cause of a problem in the IBM© MQ networkPlan for and implement basic IBM© MQ security featuresUse accounting and statistics messages to monitor the activities of an IBM© MQ systemDefine and administer a simple queue manager cluster This course provides technical professionals with the skills that are needed to administer IBM© MQ queue managers on distributed operating systems and in the Cloud. In addition to the instructor-led lectures, you participate in hands-on lab exercises that are designed to reinforce lecture content. The lab exercises use IBM© MQ V9.0, giving you practical experience with tasks such as handling queue recovery, implementing security, and problem determination. Note: This course does not cover any of the features of MQ for z/OS or MQ for IBM© i. Course introductionIBM© MQ reviewIBM© MQ installation and deployment optionsCreating a queue manager and queuesExercise: Using commands to create a queue manager and queuesIntroduction to IBM© MQ ExplorerExercise: Using IBM© MQ Explorer to create queue managers and queuesTesting the IBM© MQ implementationExercise: Using IBM© MQ sample programs to test the configurationImplementing distributed queuingExercise: Connecting queue managersIBM© MQ clientsExercise: Connecting an IBM© MQ clientImplementing trigger messages and monitorsExercise: Implementing a trigger monitorDiagnosing problemsExercise: Running an IBM© MQ traceImplementing basic security in IBM© MQExercise: Controlling access to IBM© MQBacking up and restoring IBM© MQ messages and object definitionsExercise: Using a media image to restore a queueExercise: Backing up and restoring IBM© MQ object definitionsIntroduction to queue manager clustersExercise: Implementing a basic clusterMonitoring and configuring IBM© MQ for performanceExercise: Monitoring IBM© MQ for performanceCourse summary

Duration 0.5 Days 3 CPD hours This course is intended for This course is designed for students who have experience using the Windows 10 operating system and need to start using the Windows 11 operating system. Overview In this course, you will use the new and updated features of Windows 11. You will: Navigate the Windows environment. Use apps available in Windows 11. Manage available apps. Configure Windows 11 settings. As an experienced Windows© 10 user, when you are ready to move to Windows 11, you might like some guidance in using the new and updated features. This course will help you identify and use those features efficiently and effectively. Navigating the Windows 11 Environment Topic A: Log in to Windows 11 Topic B: Use the Start Menu Topic C: Use the Taskbar Using Apps Topic A: Use Built-In Apps Topic B: Use the Updated File Explorer Managing Apps Topic A: Use Virtual Desktops Topic B: Obtain Apps from the Microsoft Store Configuring Windows 11 Settings Topic A: Use the Configuration Apps Topic B: Configure Accessibility Features

Duration 3 Days 18 CPD hours This course is intended for Individuals preparing for the Cisco Customer Success ManagerSpecialist certification Individuals who have experience working with customers to determine, measure, and deliver business outcomes through the implementation of technology Overview After taking this course, you should be able to: Describe the role of the Customer Success Manager Describe the tools that the Customer Success Manager uses to ensure customer experience Describe the lifecycle approach to customer experience The Cisco Customer Success Manager (DTCSM) v2.2 course gives you the confidence and competence to fulfill the Customer Success Manager (CSM) role successfully, helping your customers realize value from their solutions and achieve their business outcomes. The course offers experiential learning through practical exercises using situations based on real-life use cases and case studies. In this highly interactive course, you can practice and gain confidence in fulfilling core tasks using best-practice tools and methodologies while receiving feedback from the facilitator and your peers.This course is based on understanding the customer lifecycle and how to optimize that journey, increasing the value realized by the customer, and maximizing your likelihood to maintain their loyalty and renew or expand their business opportunities. The course helps you prepare for the 820-605 Cisco Customer Success Manager (CSM) exam. By passing this exam, you earn the Cisco Customer Success Manager Specialist certification. Course Outline Transition to Subscription Economy Customer and Industry Trends Defining Customer Success and the CSM Role Engaging the Customer for Success Engaging the Customer for Success Addressing Barriers Customer Success Management Activities Success Plan Elements Customer Success Management Activities Additional course details: Nexus Humans Cisco Customer Success Manager v2.2 (DTCSM) 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 Cisco Customer Success Manager v2.2 (DTCSM) 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.