Focus on Training courses

...and their pros and cons over processes Introduce the ability to access the data platform via WCF Web Service calls Skills Learn the major areas of extensibility... Learn about: Microsoft Dynamics, Best Practice, Business Process...

...with others workbook users Audit worksheets Analyse data Work with multiple workbooks Import and export data Integrate Excel data with the web Structure... Learn about: Microsoft Office, Office IT, MS Excel...

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

...You will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks. Target Student This course is designed for students who desire... Learn about: Microsoft excel training, Microsoft Office, Ms Office...

...Pivot Table Data Calculated Fields in Pivot Tables Showing Pivot Data as a Percentage Creating Custom Pivot Tables Styles Module 6 Introduction to... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...

...different tabs and options the Ribbon offers. Topics covered The Quick Access Toolbar and File Menu The Home Tab The Insert Tab The Page Layout Tab... Learn about: Microsoft excel training, MS Excel, Microsoft 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 training, MS Excel, Microsoft 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, Microsoft excel training, MS Excel...

...attended Excel 2016 Intermediate course or have equivalent knowledge. Learning Objectives Delegates will learn how to: At the end of this course you... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...

...Errors Using the Watch Window Evaluating a Formula Module 3: Mastering Excel Tables Introducing Excel Tables Using Advanced Table Tools Module... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...

...Replace • Spelling • Undo and Redo • Insert and Delete Options • Column Width and Row Height • Hide and Unhide Options Module 3: Using Formulas and Functions... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

...concepts covered in the Introduction and Intermediate courses. Class sizes Maximum class size for Excel Advanced (2007, 2010 & 2013) courses is 8 delegates... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

...to produce professional and interactive reports and charts. Delegates should have a very good existing knowledge of Excel and ideally would have attended... Learn about: Business Intelligence, MS Excel, Microsoft Excel...

...VLOOKUPs and Name Range Lists MODULE 6 : Using Excel Objects for Specialist Dashboard Views Topics covered: Adding a Data Bar into your Dashboard Creating... Learn about: Microsoft Excel, Microsoft excel training, MS Excel...

...References using Late Binding Create a PowerPoint Presentation Create a Letter in Word MODULE 4 : Debugging and Error Traps Learning outcomes... Learn about: Microsoft excel training, Microsoft Excel, Visual Basic training...

...has been designed for people who wish to learn the basics of the Excel VBA programming language, get used to the concepts and methods of VBA programming... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

...These courses leverage the same content as found in the Microsoft Official Academic Courses (MOAC) for these exams. Target Audience The Microsoft Technology Associate (MTA)... Learn about: Operating System, Network Training...

...Applications Topic A - Classes and References Topic B - Working with Objects in another Application Topic C - Editing Documents across MS Office Module... Learn about: Office IT, MS Excel, Microsoft Office...

...This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, basic VBA programming... Learn about: Microsoft Office, Visual Basic training, Office IT...

...365 should attend the appropriate application specific courses. An end user who will be required to use Office 365 and needs an understanding of its features... Learn about: Office IT, Microsoft Office, Ms Office...