Focus on Training courses

...functions and the concept of arrays. Topics covered Using the Index Function Using the Match Function Using Index and Match Together Using Index and Match... Learn about: Microsoft Excel, Microsoft excel training, MS Excel...

...Advanced File Tasks Learning outcomes: A look at some important administrative features which are useful for managing and controlling Excel files... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

...the maximum class size is 6 delegates. Target Audience The course is intended for new users of Microsoft Excel 2007, 2010 or 2013 who want to become productive... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...

...to analysis leading to subsequent output in Excel. Analysis and outputs include data and graphical tools available in Microsoft Excel 2013.Target student... Learn about: Microsoft excel training, Data analysis, Microsoft Excel...

...Row and Calculated Transform Actions Combining Data Sources as a Mash Up Lesson 3: PowerPivot Concepts and Components Working with the Manage Console Creating... Learn about: Microsoft Excel, Microsoft excel training, Data analysis...

...Creating Macros Creating a Macro Comparing Relative and Absolute Macros Running a Macro Editing a Macro Assigning Shortcuts to Macros Macro Security Enabling... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...

...Getting the Data to your Workbook Import or Connection Data from other Excel Sources Retrieving Data from other Applications Using Web Based Data Lesson... Learn about: Data analysis, MS Excel, Microsoft excel training...

...Working with the Manage Console Connecting Data to PowerPivot Creating and Editing Data Relationships Calculated Items, Measures and KPIs Creating PivotTables... Learn about: MS Excel, Microsoft Excel, Data analysis...

...Data in a PivotTable Formatting a PivotTable Using the Classic PivotTable Layout Slicers MODULE 4 : Charting Pivoted Data Learning outcomes... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

...CONCATENATE LEFT / RIGHT MID LEN FIND / SEARCH UPPER / LOWER / PROPER VALUE... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...

...data in a professional way Topics covered: Creating Combination Charts Displaying a Secondary Axis Modifying Axis Options Display Data Trends Charting... Learn about: MS Excel, Microsoft excel training, Business Intelligence...

...training course teaches delegates how to create interactive Excel dashboards, that update with the click of the Refresh button, or with a simple copy... Learn about: Microsoft Excel, Microsoft excel training, MS Excel...

...Explore the use of Workbook and Worksheet events to react to the users actions and help control your application Topics covered: Create Workbook Events... Learn about: Visual Basic training, MS Excel, Microsoft excel training...

...TARGET AUDIENCE The course is designed for existing, experienced users of Excel 2007, 2010, 2013 or 2016 who need to use VBA to automate their spreadsheets... Learn about: Microsoft Excel, Microsoft excel training, MS Excel...

...styles and themesPublish forms to various locationsCreate Submit processes to form templates, so data can be submitted according to integrityQuery...

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

...Implementing TCP/IP in the Command Line Module 6: Working with Networking Services Module 7: Understanding Wide Area Networks Module 8: Defining Network... Learn about: Network Training, Operating System...

...and Buttons Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in... Learn about: Visual Basic, Ms Office, Office IT...

...Web App Working with email and folders Outlook Contacts and IM Contacts Using the Calendar Shared Calendars Outlook Tasks in the Web App Setting Outlook Options... Learn about: Ms Office, Office IT, Microsoft Office...

...Office 365 Module 20: MCSA Exams discussion & Preparation Overview Course Review... Learn about: Microsoft Office, Ms Office, Office IT...