Training courses coming up!

How many of the following boxes can you tick?

1. You know Excel well, and use it every day?
2. You work with financial models?
3. You know how to create an IF function, but struggle with MATCH?

This two-day course is aimed at those who need to build or work with financial models in Excel. On this course you'll learn best-practice techniques for building models, using range names more than you could ever conceive, and you'll find out about functions like MATCH, INDEX and SUMPRODUCT. Oh, and on the way you'll learn tons of short-cut keys and tips and tricks, we promise!

If you already know how to create subroutines in VBA, are happy declaring variables and can write loops and conditions without a qualm, this is the course for you! Assuming a good working knowledge of Visual Basic for Applications, the advanced course shows you how to loop over collections, reference other applications, work with files in all of their manifestations, create your own classes (!) and much more.  The course uses examples drawn from Excel, Access, Word and Outlook.

There are three parts to creating a Power BI report, all of which are covered by this two-day course.  Firstly, you'll learn how to get data from all manner of different sources, how to use Query Editor to manipulate the results and how to build a data model; secondly, you'll learn how to create, format and use visualisations (tables, charts, gauges, maps and many more); and thirdly, you'll learn how to create calculated columns  using basic DAX language.  You'll also learn how to publish reports to Power BI Service.  If you're not sure whether you want to book on this course or on our two-day Excel Power BI tools course, have a look here.

Tired of repeating tasks in Excel? Perhaps it's time to automate your work, by learning how to write macros using the built-in VBA programming language (VBA stands for Visual Basic for Applications, and is the language also used by Access, Word, Outlook and PowerPoint).

If you're wondering whether you should be learning SQL Server Reporting Services, the answer is yes! SSRS (as it's often called) allows you to create impressive reports, including drill-through, indicators, gauges and lots of other whizzy features.  You can then publish these reports directly to your company's website in a number of different formats, or push them out to subscribers by email.

This two-day course runs in SSRS 2016, but if you're using SSRS 2012 you'll still be able to attend, as the report design interface has barely changed (even since SSRS 2008 R2).

If you already know how to write SELECT statements in SQL, maybe it's time to find out how to program in SQL with our advanced course! Learn how to create stored procedures (including passing parameters to them), write your own user-defined functions, work with temporary tables and table variables and much more.

This course will teach you how to create calculated columns and measures using DAX, including how to understand complicated DAX functions like CALCULATE, VALUES and EARLIER.  The course also covers writing DAX queries to interrogate databases.  During the course you'll pick up lots of clever techniques for building data models, including ways to model multiple calendars, parent-child hierarchies and dynamic security.  The training uses Power BI Desktop for editing measures, but is just as useful if you're using PowerPivot or SQL Server Analysis Services (tabular model).  This course is definitely more difficult than our two-day Introduction to Power BI course, and is complementary to our two-day Advanced Power BI course (there is virtually no overlap between the two).

This one-day course provides the perfect introduction to Microsoft's popular spreadsheet application.  You'll learn how to create formulae, make your worksheets look pretty, create charts and print out your work.  Take the fear-factor out of Excel, and enjoy lunch in a local restaurant at the same time!

SQL Server Integration Services (SSIS) lets you automate the import, export and conversion of data. You can use SSIS to fill your data warehouse, import a batch of CSV files or Excel workbooks or just draw beautiful flow diagrams! 

Refreshingly, this introductory course doesn't use a large, impenetrable Microsoft database, but instead just uses simple examples to illustrate real-world tasks.

There are three parts to creating a Power BI report, all of which are covered by this two-day course.  Firstly, you'll learn how to get data from all manner of different sources, how to use Query Editor to manipulate the results and how to build a data model; secondly, you'll learn how to create, format and use visualisations (tables, charts, gauges, maps and many more); and thirdly, you'll learn how to create calculated columns  using basic DAX language.  You'll also learn how to publish reports to Power BI Service.  If you're not sure whether you want to book on this course or on our two-day Excel Power BI tools course, have a look here.

You can use SQL to retrieve information from your corporate database (providing, of course, that you understand its structure). This two-day introductory course will show you how to create tables in SQL Server, and then how to write SQL to extract information from them. You'll learn about the WHERE clause (for setting criteria); the ORDER BY clause; how to aggregate data using GROUP BY; and how to create inner, outer and full joins!

SQL Server Integration Services (SSIS) lets you automate the import, export and conversion of data. You can use SSIS to fill your data warehouse, import a batch of CSV files or Excel workbooks or just draw beautiful flow diagrams! 

Refreshingly, this introductory course doesn't use a large, impenetrable Microsoft database, but instead just uses simple examples to illustrate real-world tasks.

If you've mastered the basics of creating Power BI reports, you may like to find out what else it can do - but you should only consider attending this course if you use Power BI regularly.  Learn how to create report themes and templates, find out how to use quick measures and bookmarks, delve further into Query Editor and maps, and much more!