Focus on Training courses

...Learning Objectives This intensive hands-on one-day training course has been designed to provide delegates with a very advanced set of tools and concepts for Excel... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...

...understanding of the concepts covered in the Introduction course. Maximum class size for Microsoft Excel courses is 8 delegates, which ensures that attendees... Learn about: Microsoft Excel, Microsoft excel training, MS Excel...

...Multiple Windows Printing your Workbook Module 6 Working with Charts in Excel Learning outcomes Introducing charts within Excel and explain how to create... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...

...Structures and Data Properties Creating and working with Data Models, Relationships, and Sets Workbook Analysis with Inquire Lesson 3: Using Data Tables... Learn about: MS Excel, Data analysis, Microsoft Excel...

...The course is designed to examine a combination of new and revised features which are available to help you work with data in Microsoft Excel... Learn about: MS Excel, Microsoft Excel, Data analysis...

...Cell Array Functions Multiple Cell Array Functions Module 5 - Advanced Lookup and Reference Functions GETPIVOTDATA MATCH VLOOKUP ROW / COLUMN INDEX OFFSET... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...

...Working with Data Visually Quick Data Analysis Conditional Formatting Visualise Trends with Sparklines Using Charts, Exploring Chart Types and Options Lines... Learn about: Data analysis, MS Excel, Microsoft Excel...

...process, analyse and display data in order to produce suitable output at all levels within an organisation. It is assumed that the attendees on the course... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...

...with adding hyperlinks and Custom AutoFill Lists. Topics covered: Excel and Hyperlinks Using Custom AutoFill Lists Sharing Workbooks MODULE... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...

...Serial Number TODAY / NOW DAY / MONTH / YEAR / HOUR / MINUTE / SECOND DATE EDATE EOMONTH NETWORKDAYS WORKDAY DATEDIF Module 9 - Working with Text Functions... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...

...assist you to get at the information you are interested in, quickly. We start by looking at how to get data into Excel from a number of different sources... Learn about: Business Intelligence, MS Excel, 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: MS Excel, Microsoft Excel, Microsoft excel training...

...Although VBA is derived from the programming language Visual Basic, it is normally used within a host application (e.g. Excel, Access, etc... Learn about: Microsoft Excel, Visual Basic, Visual Basic training...

...recorder and run them from shortcuts or buttons on the ribbon Topics covered: Setting Excel Macro Options Record and Run Simple Macros Assign Macros... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...

...Data Connections Understand Data Sources Data Connections Data Source Fields Use Secondary Connections Populate a Drop-Down with Data Offline Mode Query Support Lesson...

...Learning Objectives Delegates will learn how toModify SharePoint list and library form templates with InfoPath.Publish and Submit data to Form Libraries... Learn about: Ms Office, Content Management, Office IT...

...This five-day Training 2-Pack helps you prepare for Microsoft Technology Associate Exams 98-366 and 98-367, and build an understanding of these topics... Learn about: Operating System, Network Training...

...End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow... Learn about: Microsoft Office, Office IT, Ms Office...

...OneDrive and Lync Online in a cloud environment. Target Audience Delegates who wish to gain a deeper understanding of the individual applications in Office... Learn about: Office IT, Microsoft Office, Ms Office...

...is designed for experienced IT Professionals who need to administer, configure, manage and troubleshoot the next generation of cloud based collaboration platform... Learn about: Microsoft Office, Ms Office, MCSA training...