Free Microsoft exercises for Excel, SQL, VBA, etc
Our main business is providing classroom training courses in the UK (or anywhere else which is warm or interesting ...!). However, we realise not everyone can make it over here, so we've published all of our training exercises free online (see hint below for limitations on use). Just choose a category from the list below!
|Analysis Services||Exercises on the two strands of SQL Server Analysis Services: the newer tabular model version of SSAS, and the older multi-dimensional model implementation of SSAS, using cubes.|
|Integration Services||Exercises in extracting, transforming and loading data using SQL Server Integration Services.|
|Microsoft Access||Exercises to help you understand how to create databases in Access, including creating tables and queries, designing forms and reports, and also writing modules in VBA.|
|Microsoft Excel||Exercises for Microsoft Excel, including not only the core spreadsheet product but also importing and analysing data using PowerPivot and automating Excel using VBA.|
|Power BI||Exercises in the Power BI tools which form part of the Microsoft BI stack, including Power BI Desktop exercises and also PowerPivot exercises.|
|Report Builder||Exercises in creating reports using Report Builder, and also using Reporting Services (the two products are virtually identical underneath their very different exteriors).|
|Reporting Services||Exercises in creating reports using SQL Server Reporting Services.|
|SQL||Exercises on writing SQL within SQL Server Management Studio.|
|Visual Basic||Exercises in programming within Visual Basic.|
|Visual Basic for Applications||Exercises in programming in Visual Basic for Applications, both within Excel and more generally within all of the other Microsoft applications.|
|Visual C#||Exercises to help you learn to program using Visual C# (or just plain C#, as it's usually called).|
Please note, however, that we don't - understandably, we hope - offer technical support for our free exercises.
None of the exercises or supporting files may be copied in any form or used commercially without the prior written permission of Wise Owl (although you're welcome to use them for testing your own knowledge).