Focus on Training courses

...as well as on developing a concise understanding of business process including WorkFlows, Actions, CustomWorkFlow Activities, and Business Process Flows... Learn about: Best Practice, Microsoft Dynamics, Business Process...

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

...and enhance the look and appeal of workbooks by adding graphical objects. Learning Objectives Delegates will learn how toUse advanced formulasOrganise... Learn about: Microsoft Excel, Microsoft excel training, MS Excel...

...an Excel Worksheet Topic 2A: Create Formulas in a Worksheet Topic 2B: Insert Functions in a Worksheet Topic 2C: Reuse Formulas Lesson 3: Modifying a Worksheet Topic... Learn about: Ms Office, Office IT, 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: Microsoft Excel, MS Excel, Microsoft excel training...

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

...who relies on caterers, we are unable to reliably provide for differing dietary requirements, so if you are in any doubt then please bring your... Learn about: Microsoft Excel, Microsoft excel training, MS Excel...

...Query in ExcelUse PowerPivot for data connection and analysisUse Power Map to create visualisations of geo-data Lesson 1: Organising Worksheet Data Apply... Learn about: Microsoft Excel, MS Excel, Microsoft excel training...

...Scenarios What-If Analysis Using Goal Seek Consolidating Data Linking to External Workbooks Module 7 - Data Validation Number Validation Data List Validation... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...

...The goal of this course is to provide you with the knowledge required to use more advanced formulas and work with various tools to analyse data in spreadsheets... Learn about: IT Auditing, Microsoft Excel, Microsoft excel training...

...• Manage Worksheets • Freeze Rows and Columns • View Options for Worksheets and Workbooks Module 6: Printing Options • Print Preview • Print Worksheets... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

...Useful Excel functions to summarise a spreadsheet making the data easier to identify and explain. Topics covered: Outlining and Grouping Data Using... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...

...A hands-on one-day course with free pre-course online skills testing. This course covers 2007, 2010, 2013 and 2016 versions. TARGET AUDIENCE This intensive... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

...Organising Data in Data Tables using IFs Using Table Formulas to Make Dynamic Charts Using More Table Formulas with Conditional Formatting Using OFFSETs... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...

...Using VBA's debugging tools to find and correct errors in code, react to un-foreseen problems Topics covered: Review of Error Types Debugging tools Setting... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...

...manipulate data within cells, create and navigate around worksheets and workbooks Topics covered: Understanding Objects, Properties and Methods Referencing... Learn about: Microsoft Excel, MS Excel, Microsoft excel training...

...is Microsoft's newest suite of technology certification exams that validate fundamental knowledge needed to begin building a career using Microsoft technologies... Learn about: Operating System, Network Training...

...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: Office IT, Ms Office, Microsoft Office...

...and procedures with the appropriate scopeUse decision structures to create procedures that make decisions; and use loop structures to perform repetitive... Learn about: Visual Basic, Office IT, Visual Basic training...

...Integration with SharePoint Online * The applications included in Office 365 are dependent upon the type of subscription held by the organisation... Learn about: Microsoft Office, Ms Office, Office IT...