Home
Videos uploaded by user “Optimum Technology Transfer”
Microsoft Excel 2016 - Recording a Macro
 
06:59
Recording a Macro in Microsoft Excel 2016. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Dynamics AX - Working In Dynamics AX Screens Tutorial
 
05:11
This 'Working in Dynamics AX Screens' tutorial is provided by Optimum - the IT training consultancy. Optimum provide bespoke end-user training on a series of different ERP platforms - including Microsoft Dynamics AX. For more information for the training services offered, follow this link: http://www.optimum.co.uk/erp/microsoft-dynamics/
Microsoft Excel 2016 - Creating Sunburst Charts
 
02:15
Creating Sunburst Charts in Microsoft Excel 2016. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Excel 2016 - Recording a Macro to Import a Plain Text File
 
04:54
Recording a Macro to Import a Plain Text File in Microsoft Excel 2016. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-of...
Microsoft Dynamics AX - Getting Started With Dynamics AX Tutorial
 
04:44
This 'Getting Started with Dynamics AX' tutorial is provided by Optimum - the IT training consultancy. Optimum provide bespoke end-user training on a series of different ERP platforms - including Microsoft Dynamics AX. For more information for the training services offered, follow this link: http://www.optimum.co.uk/erp/microsoft-dynamics/
Microsoft Dynamics AX - Intro to AX and Enterprise Portal Tutorial
 
04:54
This 'Intro to Dynamics AX and Enterprise Portal' tutorial is provided by Optimum - the IT training consultancy. Optimum provide bespoke end-user training on a series of different ERP platforms - including Microsoft Dynamics AX. For more information for the training services offered, follow this link: http://www.optimum.co.uk/erp/microsoft-dynamics/
Microsoft Excel 2013 - Using Excel's MATCH and INDEX functions
 
10:53
Using the MATCH and INDEX functions in Microsoft Excel 2013. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Dynamics AX - Tips And Techniques Tutorial
 
03:44
This 'Tips & Techniques' tutorial is provided by Optimum - the IT training consultancy. Optimum provide bespoke end-user training on a series of different ERP platforms - including Microsoft Dynamics AX. For more information for the training services offered, follow this link: http://www.optimum.co.uk/erp/microsoft-dynamics/
Microsoft Excel 2013 - Combining the SUMIFS and INDIRECT functions
 
11:19
This video demonstrates using Microsoft Excel’s SUMIFS function to total up a range of cells across multiple worksheets based multiple criteria ranges / criteria and adds a further level of complexity by nesting Excel’s INDIRECT function and concatenation. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Dynamics AX - Filters and Inquiries in Dynamics AX Tutorial
 
05:55
This 'Filters & Inquiries in Microsoft Dynamics AX' tutorial is provided by Optimum - the IT training consultancy. Optimum provide bespoke end-user training on a series of different ERP platforms - including Microsoft Dynamics AX. For more information for the training services offered, follow this link: http://www.optimum.co.uk/erp/microsoft-dynamics/
Microsoft Excel 2016: Creating Waterfall Charts - Part Two
 
02:58
Creating Waterfall Charts in Microsoft Excel 2016 - Part two. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Excel 2016 - Using the REPLACE() Function
 
03:43
Using the Replace() Function in Microsoft Excel 2016. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Creating dynamic charts in Microsoft Excel - Part 1
 
08:10
This video demonstrates how to make your charts more dynamics. It shows how to combine the OFFSET and COUNTA function with named ranges to achieve this functionality. Related videos: Creating Dynamic Charts - Part 2: https://youtu.be/CXcOrMcwiKs Creating Basic Charts: https://youtu.be/Q0m2-iy_6_k This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Unit4 Agresso Business World v5.6 ERP System - New Features
 
09:14
The new features of UNIT4 Agresso v5.6 ERP System. This video was created by Optimum - the IT training consultancy, specifically for a property management organisation which upgraded to Agresso v5.6 in early 2013. A range of 5-10 minute self-service video tutorials were designed to identify changes and best practices. They were then uploaded to the organisations intranet together with additional reference material in the form of quick cards. For more information on our Unit4 Agresso training solutions - please click here: http://www.optimum.co.uk/erp/unit4-agresso/
Unit4 Agresso ERP - General Ledger Journals via the Posting Screen Tutorial
 
03:16
General Ledger Journals via the Unit4 Agresso Posting Screen This video was created by Optimum - the IT Training Consultancy. Optimum are the most experienced Unit4 Agresso training consultancy in the world, having designed, developed and delivered customised learning solutions for over 250+ organisations worldwide. For more information on our Unit4 Agresso end-user training solutions - please click here: http://www.optimum.co.uk/erp/unit4-agresso/
Microsoft Excel 2013 - Using the SUMIFS function across multiple worksheets
 
09:19
This video demonstrates using Microsoft Excel’s SUMIFS function to total up a range of cells across multiple worksheets based multiple criteria ranges / criteria. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Excel 2016: Creating Waterfall Charts - Part One
 
02:54
Creating Waterfall Charts in Microsoft Excel 2016 - Part one. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Unit4 Business World (Agresso) - Intro to Agresso Web 5.7 Tutorial
 
04:54
Introduction to Unit4 Business World (Agresso) Web 5.7 Milestone 4. This video was created by Optimum - the IT Training Consultancy. Optimum are the most experienced Unit4 Agresso training consultancy in the world, having designed, developed and delivered customised learning solutions for over 250+ organisations worldwide. For more information on our Unit4 Agresso end-user training solutions - please click here: http://www.optimum.co.uk/erp/unit4-business-world-agresso-training/
Microsoft Word 2016 - Tell me what you want to do Function
 
02:34
Using the 'Tell me what you want to do; function in Microsoft Word 2016. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Excel 2016 - Using the DATEVALUE() function
 
04:10
Using the DATEVALUE() function in Microsoft Excel 2016. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Excel 2016 - Using the SUBSTITUTE() Function
 
04:10
Using the Substitute() function in Microsoft Excel 2016. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Unit4 Business World (Agresso) - Raising a Requisition Tutorial
 
03:37
Raising a Requisition in Unit4 Business World (Agresso) 5.7 Milestone 4. This video was created by Optimum - the IT Training Consultancy. Optimum are the most experienced Unit4 Business World (Agresso) training consultancy in the world, having designed, developed and delivered customised learning solutions for over 250+ organisations worldwide. For more information on our Unit4 Business World Agresso end-user training solutions - please click here: http://www.optimum.co.uk/erp/unit4-business-world-agresso-training/
Microsoft Excel 2010 - Named Cells and Table Ranges
 
05:27
Named Cells and Table Ranges in Microsoft Excel 2010. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Office 2010 - Importing an Outline from Word into PowerPoint
 
03:03
Importing an outline from MS Word into MS PowerPoint in Microsoft Office 2010. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Excel 2013 - Using Text Functions - RIGHT, LEN, SEARCH & PROPER
 
04:30
Using Text Functions in Microsoft Excel 2013 - RIGHT, LEN, SEARCH & PROPER. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Excel 2016 - Using Value Driver Trees (VDT): Part One
 
06:05
Recording a Macro to Import a Plain Text File in Microsoft Excel 2016. This video introduces the idea of translating / converting a Value Driver Tree (VDT) into an Excel model. This video is part one. Part two is available to view here:https://youtu.be/l6Gs08VeNs0 This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-of....
5 ERP End-User Training Tips - from Optimum
 
04:09
Have you considered end-user training for your ERP implementation or upgrade project yet? Here are 5 tips to give you a head-start in that process... This video is provided by Optimum - the IT training consultancy. We have assisted over 300 global clients (private and public sector) in delivering effective end-user training for ERP system implementations and upgrades. We are able to develop training solutions that also take into consideration any integrated systems and add-ons that link into the ERP system. For more information on our offering - please follow this link: http://www.optimum.co.uk/erp/
Optimum IFS ERP Training Success Story - Binding Site
 
03:13
Optimum works with some of the world's leading brands. Binding Site provides specialist diagnostic products to clinicians and laboratory professionals worldwide. Our people are dedicated to improving patient lives, delivering innovative medical solutions that improve the diagnosis and management of blood cancers and immune system disorders. Discover how Optimum helped this global brand with their recent implementation of IFS Applications ERP system. Find out more about Optimum's end-user training programmes here: http://www.optimum.co.uk.
Optimum U4BW ERP Training Success Story - The National Trust
 
03:02
Optimum provides business systems end-user training programmes to some of the world's leading brands. The National Trust is a conservation organisation in England, Wales and Northern Ireland, and the largest membership organisation in the United Kingdom. The trust describes itself as "a charity that works to preserve and protect historic places and spaces—for ever, for everyone." It owns over 350 heritage properties which includes many historic houses and gardens, industrial monuments, and social history sites. The Trust is one of the largest landowners in the United Kingdom, owning over 247,000 hectares (950 sq mi) of land, including many characteristic sites of natural beauty, most of which are open to the public free of charge. Discover how Optimum provided the end-user training programme for this not for profit organisations recent implementation of the Unit4 Business World (Agresso) ERP system. Find out more about Optimum's end-user training programmes here: http://www.optimum.co.uk.
Microsoft Excel 2016 - Using the TIMEVALUE() function
 
06:10
Using the TIMEVALUE function in Microsoft Excel 2016. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Excel 2016 - Using Value Driver Trees (VDT): Part Two
 
05:30
Recording a Macro to Import a Plain Text File in Microsoft Excel 2016. Two more Value Driver Trees are used here to develop the spreadsheet into a Savings / Retirement model. It also introduces two more Microsoft Excel financial functions: FV (Future Value) and PMT (Payment). This video is Part Two. Part One is available here: https://www.youtube.com/watch?v=3Ydx4s-NvBk This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office.
Microsoft Excel 2013 - 3 New Skills in 3 Minutes
 
03:28
Microsoft Excel 2013 - 3 News Skills in 3 Minutes. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Excel 2010 - Multiple IF Statements
 
04:06
How to Create Multiple IF Statements in Microsoft Excel 2010. This video was created by Optimum - the IT Skills Consultancy. For more information on our Microsoft Office training courses - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Excel 2016 - Introducing the DATE() function
 
06:21
Introducing the DATE() function in Microsoft Excel 2016. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Excel 2013 - Recording an Excel Macro
 
02:41
How to Record an Excel Macro in Microsoft Excel 2013. This video was created by Optimum - the IT Skills Consultancy. For more information on our Microsoft Office training courses - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Excel 2013 - Using Text Functions - LEFT, FIND & PROPER
 
03:56
Using Text Functions in Microsoft Excel 2013 - LEFT, FIND & PROPER. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Excel - Creating dependent drop-down lists in Excel using Data Validation
 
08:03
Creating dependent drop-down lists in Excel using Data Validation in Microsoft Excel. In this video we take a look at developing Excel’s Data Validation functionality to create ‘dependent’ or ‘cascading’ drop-down lists. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Dynamics AX2012 - Deployment Challenges during Implementation - Webinar
 
38:30
This webinar was hosted in late 2012 in collaboration with John Rosbotham of PwC and Philip Stride of InfoData Solutions Limited. This will discuss the challenges of deployment when implementing Microsoft Dynamics AX2012. Optimum offer a range of bespoke training solutions across a variety of ERP solutions - one of which is Microsoft Dynamics AX. More information on these training solutions is available here: http://www.optimum.co.uk/erp/microsoft-dynamics/
Microsoft Excel 2013 - Using Named Ranges - Part 1
 
04:34
Using Named Ranges in Microsoft Excel 2013. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Dynamics AX2012 Training - eLearning Example
 
04:21
eLearning allows users to learn where and when they wish to, providing a permanent resource for refresher training and for training new staff. It can be a great approach for giving users access to training at a time and place which suits them – if designed in the right way. This is where Optimum can help. This video provides a walkthrough of an example eLearning piece using a Contoso build of Microsoft Dynamics AX2012 R2. More info on our Microsoft Dynamics AX training capabilities: http://www.optimum.co.uk/erp/microsoft-dynamics/ More info on our eLearning training method: http://www.optimum.co.uk/methods/#elearning
Microsoft Excel Tutorial - Using Excel’s ‘Rate’ function (=RATE)
 
03:46
Excel’s RATE function returns the interest rate per period of a loan or investment based on periodic constant payments. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Optimum - Our Business System End User Training Solutions
 
01:44
Optimum is an IT training consultancy with over 20 years experience. Our training solutions allow our clients to maximise the benefits from new or existing business systems and desktop applications, enabling business change. We specialise in providing end-user focused business system training programmes which add long-term value to your technology investment. Just a few of the business systems we've previously provided end-user training programmes for include: - ERP - Civica Financials - Epicor ERP - IFS ERP - Infor ERP - Microsoft Dynamics 365, AX, NAV and CRM - NetSuite ERP - Oracle ERP - Oracle JD Edwards ERP - SAP - Unit4 Business World (Agresso) - Bespoke Systems - PLM Systems - MRP Systems and many more. For more information, please visit us at http://www.optimum.co.uk.
Microsoft PowerPoint 2013 - Using the Slide Master
 
03:51
Using the Slide Master in Microsoft PowerPoint 2013 to ensure consistency, add background graphics and modify background colours. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Excel 2016: Creating Pareto Charts
 
04:42
Creating Pareto Charts in Microsoft Excel 2016. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Word 2016 - Using Smart Lookup
 
03:04
Using Smart Lookup in Microsoft Word 2016. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Excel 2013 - Introducing the SUMIFS function
 
10:33
This video introduces using Microsoft Excel’s SUMIFS function to total up a range of cells based multiple criteria ranges / criteria. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Excel 2016 - Creating Treemap Charts
 
02:13
Creating Treemap Charts in Microsoft Excel 2016. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Excel 2016 - Combining the DATE() function with Text functions to 'clean' data
 
06:39
Combining the DATE() function with Text functions to 'clean' data in Microsoft Excel 2016. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Using Keyboard Shortcuts to Copy and Paste Formats in Word and PowerPoint
 
03:22
Using keyboard shortcuts to copy and paste formats in Microsoft Word and PowerPoint. This video was created by Optimum - the IT Training Consultancy. For more information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/
Microsoft Dynamics 365 Tutorial - Dashboards and Workspaces
 
02:23
Welcome to this tutorial about Dashboards and Workspaces in Microsoft Dynamics 365 for Finance and Operations (D365FO). This video was created by Optimum - the IT Training Consultancy. We are the world leader in the design, development and delivery of bespoke Microsoft Dynamics 365 end-user training programmes. Having perfected our ERP training methodology for over 20 years, working with over 500 global clients in the process, Optimum's bespoke offering really is the obvious choice. For more information on our D365 end-user training solutions - please select the following link: https://www.optimum.co.uk/systems/microsoft-dynamics-365-training/