Focus on Training courses

...again. Target Audience Users with a solid understanding of, and experience with, Microsoft Excel 2007, 2010 or 2013 who want to increase their ability... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...

...Working with Functions and Formulas Learning outcomes: Some key formulas and functions essential to Excel users along with features to help manage formulas... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...

...The timetable is as follows: 9:15: - Arrival time9:30: - Training starts11:00: - Mid-morning break1:00: - Lunch break (one hour)3:15: - Mid-afternoon break4:30... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...

...other Excel Sources Retrieving data from other applications Using web based data Lesson 2: Preparing Data, Organising Data and Workbook Analysis Tabular... Learn about: Microsoft excel training, Data analysis, MS Excel...

...Technologies covered include PivotTables, Power Query, PowerPivot and Power Map. Target student - Anyone who needs to work with Excel in order to connect... Learn about: Microsoft excel training, Microsoft Excel, Data analysis...

...INDIRECT LOOKUP (Array format) LOOKUP (Vector format) Module 6 - Analysing Data Creating a Single Input Data Table Create a Two-Variable Data Table Creating... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...

...View Reports Using Tables, Cards and Matrices Charting in Power View Reports Mapping Geo-Data... Learn about: MS Excel, Microsoft excel training, Data analysis...

...Data Transforms using the Query Editor Editing Queries and Query Steps Combining Data Sources as a Mash Up Lesson 3: Using PowerPivot Concepts and Components... Learn about: Microsoft Excel, Microsoft excel training, Data analysis...

...The timetable is roughly as follows: 9:15: - Arrival time9:30: - Training starts11:00: - Mid-morning break1:00: - Lunch break (one hour)3:15... Learn about: Microsoft Excel, Microsoft excel training, MS Excel...

...or Multiple Cell Arrays Single Cell or Multiple Cell Array Functions Module 6 - Lookup and Reference Functions GETPIVOTDATA MATCH VLOOKUP ROW / COLUMN... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

...Using the Match Function Using Index and Match Together Using the Choose Function Using the Frequency Function MODULE 4 : Automating Reports with Controls Learning outcomes... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

...Creating Bespoke Navigation Bars Creating Dashboard Links Using Named Objects MODULE 5 : Preparing your Workbook's Layout and Structure Topics covered... Learn about: Microsoft Excel, Microsoft excel training, MS Excel...

...conversant with all its subject matter. Maximum class size for Microsoft Excel courses is 6 delegates, which ensures that attendees get adequate time... Learn about: Microsoft excel training, Visual Basic, Microsoft Excel...

...Using the IF Statement Using the Select Case Statement Using For Next Loops Using Do Loops Using For Next Loops... Learn about: Microsoft Excel, MS Excel, Microsoft excel training...

...You will be shown how to design and create complete form templates to support your business needs. You will implement data integrity and rules into forms to manage data entry...

...processes in InfoPath with and without SharePoint workflows. Target Audience This course is aimed at users who have full control permissions in a SharePoint... Learn about: Office IT, Ms Office, Content Management...

...Defining Network Infrastructures and Network Security Module 9: Understanding Security Layers Module 10: Authentication, Authorization, and Accounting Module... Learn about: Network Training, Operating System...

...Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working... Learn about: Ms Office, Visual Basic, Microsoft Office...

...These online solutions are extended through the interface with Microsoft Office 2013. This 1 day course is designed to assist existing Microsoft Office... Learn about: Office IT, Ms Office, Microsoft Office...

...Configuring the Office 365 Lab Environment Module 2: Portal Administration – Users – Groups – Roles Based Administration Lab 2: Piloting Office 365 Module 3... Learn about: MCSA training, Ms Office, Office IT...