PowerPivot for Excel allows you to crunch very large amounts of data quickly, using pivot tables and slicers and other familiar Excel concepts. It also includes the DAX language, allowing you to create complex calculations.

Designing relational databases is easy once you learn the few basic rules, and the procedure is identical whether you're using SQL Server or Access. This blog illuminates the subject!

This blog is part of our tutorial on writing SQL.

The Easter Bunny stores his distribution data in SQL Server, not Access; read why!

It's not for the faint-hearted, but there is a way to capture application events (such as someone trying to create a new workbook) in Excel, using something called an event sink.  This blog explains how you might go about creating an event sink.

This blog is part of our Excel VBA training blog.

Understanding macro security is essential if you want the code you've written to run when it's supposed to, and at the same time protect yourself from potentially malicious code. This blog explains how to change your security settings to an appropriate level and discusses the ins and outs of digital certification.

This blog is part of our Excel VBA Tutorial.

If you've learnt how to create your own objects using classes in Excel VBA, the next step is to learn how to group them together into collections. This on-line tutorial will show you how.

This blog is part of our Excel VBA training blog.

Those who want to add spice to their VBA programming can learn how to create classes, or class modules, and become object-orientated programmers.  It's difficult, but fun - and this multi-part blog will guide you along the way.

This blog is part of our Excel VBA training blog.

If you've written a killer function, you'll want to be able to share it between workbooks. The best way to do this is using an add-in.

This blog is part of our Excel VBA training blog.

You can't do much in Microsoft Project without understanding how calendars work. Calendars control when work is allowed to happen, so it's important to set them up properly before you start planning your tasks. This blog teaches you how.

If you've ever been annoyed by somebody else changing parts of your Excel workbooks it's a good idea to learn about protection to prevent them from doing it again!

If you're constantly frustrated by other people entering the wrong values in your spreadsheets why not learn how to use data validation to prevent them? This blog series explains how you can control what other people can do to your spreadsheet.

The two previous parts of this mini-blog have shown how to draw forms and how to write code to handle form events.  This final part shows how to add some of the more exotic controls to user forms, like combo boxes, list boxes, multipage controls, spinners and option buttons.

This blog is part of our Excel VBA training blog.

The previous part of this three-part series showed how to draw user forms; this part shows how to write macros to get them to work (the final part shows how to use some of the more advanced controls, such as combo boxes and MultiPages).

This blog is part of our Excel VBA training blog.

Learn how to create your own custom dialog boxes in VBA, using UserForms.  This is the first part of a three-part series (the other parts are on Writing Code for UserForms and Creating Advanced Controls).

This blog is part of our Excel VBA training blog.

Scenarios are incredibly useful when performing "what-if analysis". They allow you to quickly swap a range of input values to test different possibilities without having to retype any values. Read on to find out how they work!

Goal seeking in Excel allows you to approach calculations from the "result end" and get Excel to tell you what inputs you need in order to hit a specific target. Read on to find out how it works!

On-line training in writing functions using VBA, for use either within other VBA programs or within Excel itself.

This blog is part of our Excel VBA training blog.

You can use arrays (multiple variables) in VBA to speed up code - and they are also invaluable for processing CSV files and the like.

This blog is part of our Excel VBA training blog.

Excel and other MS Office applications make extensive use of enumerations - and you should too!

This blog is part of our Excel VBA training blog.

Constantly formatting cells in the same way can be one of the most tedious and time-consuming tasks in Excel. This blog teaches you how to use styles so that you can quickly apply consistent formatting across a range of cells.