Focus on Training courses

...Debug custom workflow activity code and use declarative workflows for On-premise deployments. Use Plug-ins to extend the functionality of events for... Learn about: Best Practice, Business Process, Microsoft Dynamics...

...Import Data from the Web Topic 7C: Create a Web Query... Learn about: XML training, Microsoft excel training, Microsoft Excel...

...worksheet and table data using various techniquesCreate and modify chartsAnalyse data using PivotTables, Slicers, and PivotChartsInsert and modify graphic... Learn about: Microsoft Excel, MS Excel, Microsoft excel training...

...gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel 2010 worksheets Learning Objectives Delegates will learn... Learn about: Office IT, Microsoft excel training, Microsoft Excel...

...Defined Functions Using VBA Learning outcomes Using VBA to create specialist procedure and to define your own Excel functions. Topics covered Creating... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

...This Microsoft Excel 2010/2013 Introduction course is suitable for complete beginners to Microsoft Excel. Excel is a spreadsheet application that can... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...

...Wrap up Note: break times can vary according to the needs of the training, and course duration for smaller class sizes can be shorter because fewer delegates... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

...only available in Microsoft Excel 2013 Professional and Pro Plus and include add-ins. This course is not suitable for anyone using Microsoft Excel Standard... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...

...Message Prompts and Alerts Conditional Data Validation Data Validation Errors Module 8 - Import/Export Data Exporting Excel Data Import Delimited... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...

...Conditional Formatting Customising Conditional Formatting Sorting and Filtering by Colour Module 9: An Introduction to Pivot Tables Understanding Pivot... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...

...• Create Relative Formulas • AutoCalculate • Insert Functions • Use AutoSum • Copy Formulas • Create Absolute Formulas Module 4: Formatting an Excel Worksheet... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...

...This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced Excel 2007, 2010 or... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...

...Use a variety of advanced functions to interrogate and manipulate spreadsheet data Topics covered: Using the GetPivotData Function Using the Index Function... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...

...paste of your new data into your spreadsheet. TARGET AUDIENCE Anyone with an advanced knowledge of Excel who wants to learn how to create dashboards which... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...

...Error Traps MODULE 5 : Creating Custom User Forms Learning outcomes: Use the VBA editor to create custom forms and controls, to gather and validate information... Learn about: MS Excel, Visual Basic training, Microsoft excel training...

...and understand (and use) the relevant techniques. MODULE 1 : Recording and Running Macros in Excel Learning outcomes: Create simple macros using the macro... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...

...Defining Networks with the OSI Model Module 3: Understanding Wired and Wireless Networks Module 4: Understanding Internet Protocol Module... Learn about: Network Training, Operating System...

...gain enhanced skills to apply VBA to develop macros to work with Office applications. You will work with the application object models, manipulate... Learn about: Ms Office, Microsoft Office, MS Excel...

...Structures Module 6: Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls... Learn about: Visual Basic training, Microsoft Office, Visual Basic...

...OneDrive and Lync Online Navigating around Office 365 Updating your Profile in Office 365 Lesson 2: Using the Outlook Web Application Overview of Outlook... Learn about: Office IT, Ms Office, Microsoft Office...