Focus on Training courses

...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: Microsoft excel training, MS Excel, Microsoft Excel...

...2010 and 2013, in order to increase their knowledge and productivity. Target Audience Users with a basic understanding of Microsoft Excel... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...

...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: MS Excel, Microsoft excel training, Microsoft 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: MS Excel, Data analysis, Microsoft excel training...

...Excel 2013 and include add-ins. This course is not suitable for anyone using Microsoft Excel Standard, Home or Student Editions. Learning Objectives Delegates... Learn about: MS Excel, Microsoft Excel, Data analysis...

...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...

...View Reports Using Tables, Cards and Matrices Charting in Power View Reports Mapping Geo-Data... Learn about: Microsoft Excel, 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: Microsoft excel training, Microsoft Excel, MS Excel...

...Creating Pivot Tables in order to display and summarise large quantities of data effectively. Topics covered: Getting Started with PivotTables Displaying... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...

...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, MS Excel, Microsoft excel training...

...from large data sets? This is what our Excel BI Reporting and Charting course is designed to help you with: to show you a range of techniques that... Learn about: Microsoft Excel, Microsoft excel training, MS Excel...

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

...not as a standalone language MODULE 1 : Advanced Procedures Learning outcomes: Explore the more advanced options of sub and function procedures to create... Learn about: Visual Basic, Microsoft excel training, Microsoft Excel...

...Maximum class size for Microsoft Excel courses is 6 delegates, which ensures that attendees get adequate time for personal attention from the instructor... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...

...Rules Manage Rules Formatting Rules Validation Rules Action Rules Test a Form Design Lesson 6: Views Work with Views Create a Print Version for a View Lesson...

...site and will be working with InfoPath and SharePoint Server Enterprise / Office 365 E3 or E4 plan solutions to improve data control and process... Learn about: Ms Office, Office IT, Content Management...

...Network Infrastructures, Network Hardware, Protocols and Services, Security Layers, Operating System Security, Network Security, Security Software... Learn about: Network Training, Operating System...

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

...Installing Office 365 Pro Plus Module 12: Deploying Mobile Device Management Solutions for Office 365 Day 3 Review Day 4 Module 13: Data Loss Prevention Module... Learn about: Ms Office, Microsoft Office, MCSA training...