Showing 17–32 of 92 results

  • D.O.T.S. Power Query and M Intermediate

    £485.00£13,500.00

    This is the Dual Online Training Solution (D.O.T.S.) version of our Power Query and M Intermediate course. This course is designed for experienced Power BI users. Topics covered include: Working with Related Queries; Using Parameters; Parameters and Incremental Refresh; Assessing Data Quality; Reducing the Cardinality of Columns; Creating Non-Tabular Queries; and Dealing with Errors.

  • D.O.T.S. Power Query and M Introduction

    £485.00£13,500.00

    Power Query is a robust data connection and transformation tool which is built into Power BI and which allows you to connect to data from a wide variety of sources and then transform that data into exactly the right shape and format for your reporting needs. In this one-day Introduction to Power Query and M, delegates will learn to use the Power Query interface to perform a wide variety of useful transformations on data, making it ready for use in the data model.

  • Essential Excel Formulas and Functions

    £50.00£1,500.00

    Our self-paced Excel Formulas online training course provides clear and easy-to-follow instructions on how to build formulas for analysis, projection and data cleansing. Formulas and functions are at the core Microsoft Excel 2013 and learning to use them effectively is an essential step in becoming proficient in Excel. Sign up for a free trial of…

  • Essential Excel Formulas and Functions – Peterborough

    £250.00

    Functions are at the core of Microsoft Excel and provide much of its power. However, many users find working with functions and formulas confusing and frustrating. This Excel training course focuses on the creation of formulas using the most useful and essential functions in each of Excel’s main function categories. Delegates will also be shown…

  • Excel Intermediate Workshop

    £62.50£1,875.00

    This Intermediate Excel online training course uses a practical approach to learning this powerful software tool: analysis of key features, combined with step-by-step tutorials which will reinforce your understanding of what Microsoft Excel is all about. Why not sign up for a free trial of this course. Aimed at beginner to intermediate Excel users, who…

  • Excel VBA Programming Introduction

    £75.00£2,250.00

    The video tutorials in this self-paced, Excel VBA online training course will show you how to automate Microsoft Excel tasks and operations. It is aimed particularly at Excel users, without much programming experience, who struggle to remember the syntax and structure of the VBA programming language. During the course, we will use a style of…

  • Excel VBA Programming Level 2

    £75.00£2,250.00

    If you know the basics of Excel VBA macros and are looking to expand your knowledge, this course could be just what you need. Moving on from the creation of Excel VBA macros, this self-paced Advanced Excel Online training course shows you how to write code which responds to events. <ahref=”https://www.gcomsolutions.com/courses/excel-vba-programming-level-2″>Sign up for afree trial…

  • Excel XML, XPath and XSLT Workflows

    £75.00£2,250.00

    Microsoft Excel is a very XML aware application, featuring not only XML, but also XPath and XSLT capabilities; and This self-paced Intermediate/Advanced Excel online training course explains all of Excel’s XML-related features in depth. The course assumes a good familiarity with Microsoft Excel and the use of Excel formulas. However, no knowledge of XML, or…

  • Free Subscription

    Free Subscription

    £0.00

    Get started on your Power BI journey for free. Sign up for a free subscription. No credit card is required and you will gain immediate access to the following courses. Microsoft Power BI Basics Power BI Excel Integration SQL Server Integration

  • Microsoft Excel Advanced

    £195.00

    This course is suitable only for those with considerable prior experience and covers: importing & exporting data; importing and exporting data; formatting numbers; working with ranges; working with macros; customizing excel; data analysis tools; summarizing data; what-if data analysis; and workgroup collaboration.

  • Microsoft Excel Intermd

    £195.00

    This course is suitable for those with prior experience and covers: working with tables; working with charts; working with graphics; workgroup collaboration; financial & logical functions; financial and logical functions; date and time functions; and managing workbooks.

  • Microsoft Excel Intro

    £195.00

    This course is designed for beginners and covers: excel basics; working with data; editing a worksheet; editing text; formatting a worksheet; page setup and printing; working with pages; formulas and functions; and modifying workbooks.

  • Microsoft Excel VBA Introduction

    £1,590.00

    Our Excel VBA Introduction shows delegates how to create and customise macros and gives them a basic familiarity with the Visual Basic for Applications environment. Best practices are introduced from the outset and delegates are encouraged to learn VBA by understanding its key principles, rather than simply memorising syntax.

  • Microsoft Excel VBA Level 2

    £495.00

    Our Excel VBA Level 2 course is designed for experienced Excel users who have already begun to create macros and know their way around Excel’s Visual Basic Editor. This course delves deeper into the Excel object model and provides delegates with practical experience of developing their own VBA solutions.

  • Microsoft Power BI Basics

    Microsoft Power BI Basics

    £19.50

    Microsoft Power BI Basics is a short course designed to give you a quick and painless introduction to Power BI’s capabilities. You may sign up for this course free of charge.

  • Microsoft Word Training

    Microsoft Word Introduction (Tutor-led Online Training)

    £995.00

    This course is designed for beginners and covers: word basics; editing text; formatting text; working with paragraphs; working with pages; and printing a document.