Focus on Training courses

...2010 and 2013 in order to further increase their knowledge and productivity. This course is a one-day training course structured into 6 modules... Learn about: Microsoft Excel, MS Excel, Microsoft excel training...

...(SUMIF & AVERAGEIF) Formula Auditing Formulas with Absolute References Text Functions MODULE 3 : Managing Tables in Microsoft Excel Learning outcomes... Learn about: Microsoft Excel, Microsoft excel training, MS Excel...

...be described as a two-dimensional database (in other words it’s not relational like Access). On a basic level it can be used to store and present data... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

...data into Excel 2013Create connections to external data sourcesUse Workbook AnalysisUtilise new Excel 2013 features to analyse dataPresent external... Learn about: MS Excel, Data analysis, Microsoft Excel...

...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 training, Data analysis...

...You have been using Excel 2016 for a while and either in training or through self-development you have a solid foundation in the basic and intermediate... Learn about: Microsoft Excel, Microsoft excel training, MS Excel...

...Creating Decoupled PivotCharts from a Connection or Data Model Filtering the Data using Slicers and Timelines Lesson 6: Power View Reports Creating Power... Learn about: MS Excel, Microsoft Excel, Data analysis...

...Dashboards using PowerPivot Lesson 4: Visualising Data with Power Map Overview of Power Map What is Geo-Data? Creating Maps and Applying Options Tours... Learn about: Microsoft excel training, Microsoft Excel, Data analysis...

...Mid-afternoon break4:30: - Wrap up Note: break times can vary according to the needs of the training, and course duration for smaller class sizes... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...

...INDEX OFFSET INDIRECT Module 7 - The Aggregate Function AGGREGATE (new Function in Excel 2010) AGGREGATE Module 8 - Date and Time Functions Dates are... Learn about: Microsoft Excel, MS Excel, Microsoft excel training...

...Microsoft Query to Control Linked Data Modify and Update Connections MODULE 2 : Data Manipulation with Pivot Tables Learning outcomes: Summarise information... Learn about: Microsoft Excel, MS Excel, Business Intelligence...

...Looking at Macros and the Visual Basic Interface Configuring Controls using Macros Ironing out Minor Issues in your Dashboard with VBA The Select... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

...AUDIENCE This is a course which naturally follows on from the Introduction course. Delegates must either have attended the Introduction course or be fully... Learn about: MS Excel, Visual Basic training, Microsoft excel training...

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

...Submit Save Forms Submit Forms Submit Forms via E-mail Submit Forms to Databases Submit Data Using Rules and Code Customise Submit Messages Lesson...

...courses from which you may also benefit: InfoPath 2013 Designing Forms SharePoint 2013 Office Integration Level 1 SharePoint 2013 Workflows... 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...

...and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions... Learn about: Microsoft Office, Office IT, Visual Basic training...

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