Wise Owl's Blog
Making Sense of Software

Excel | Microsoft training in London, UK

Blogs by Andy Brown

Showing blogs 1-20 (out of 77)

Creating a website using CSS - a full worked example

Posted by Andy Brown on 16 May 2012 | no comments

Sometimes online training in style sheets isn't enough: you need a tutorial which takes you through the thought processes involved in creating styles for a web page, step by step.  This blog gives a full worked example (you may find it helpful first to look at the two previous parts of this CSS tutorial, on the principles of CSS and applying styles to HTML tags).

This blog is part of a larger online ASP.NET online training series.

Tags:   HTML and CSS / CSS

How to create styles for HTML tags using CSS

Posted by Andy Brown on 16 May 2012 | no comments

This is the second of a three-part online training series of blogs on CSS style sheets.  This blog shows how to create styles for specific HTML tags (the first part covers the principles of CSS style sheets, and the third part gives a worked example of CSS).

This blog is part of a larger online ASP.NET online training series.

Tags:   HTML and CSS / HTML   |   HTML and CSS / CSS

Creating CSS cascading style sheets for HTML

Posted by Andy Brown on 16 May 2012 | no comments

This is the first of a series of 3 tutorials showing how to create and use CSS style sheets for HTML web pages.  This first part explains how CSS works, a second part shows how to create styles for HTML tags and a final part gives a full worked example of creating a style sheet.

This blog is part of a larger online ASP.NET online training series.

Tags:   HTML and CSS / HTML   |   HTML and CSS / CSS

New in SQL 2012 - code snippets and surrounding code

Posted by Andy Brown on 15 May 2012 | no comments
In a previous blog on new features of SQL 2012, I missed out the ability to insert code snippets, and also to embed or surround code in an IF, BEGIN or WHILE block. This blog rectifies this!
Tags:   SQL Server 2012 / SQL 2012   |   SQL / General

New features for SQL within SQL Server 2012

Posted by Andy Brown on 08 May 2012 | no comments
SQL 2012 has 14 new functions, a new FileTable construct and new ways to sequence and fetch records - as this blog explains.
Tags:   SQL Server 2012 / SQL 2012   |   SQL / General

SQL Server Reporting Services 2012 - What's New?

Posted by Andy Brown on 08 May 2012 | no comments
SQL Server Reporting Services 2012 (SSRS 2012) has been completely rewritten (it's now called SQL Server Data Tools), and yet looks strangely familiar. This blog explains the new features introduced.

What is PowerPivot for Excel 2010 - an Overview

Posted by Andy Brown on 04 May 2012 | no comments
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.
Tags:   Excel / PowerPivot

Createing master pages, CSS, skins and themes

Posted by Andy Brown on 01 May 2012 | no comments
How to create the perfect ASP.NET website, including using master pages, CSS style sheets, and whether to use skins and themes or not.

This blog is part of a larger online tutorial in ASP.NET.

Tags:   ASP.NET / Master pages   |   ASP.NET / Themes, skins, CSS   |   ASP.NET / General

Tutorial - creating the perfect ASP.NET website

Posted by Andy Brown on 24 April 2012 | no comments
This free online tutorial shows how to create the perfect website using ASP.NET using Visual Basic or Visual C#, user controls, styles, master pages, gridviews, data classes and stored procedures.

Wise Owl is 20 years old this year: 1992-2012

Posted by Andy Brown on 23 April 2012 | 1 comment
To celebrate our 20th anniversary, we thought we'd look back on how software training has changed over the last 20 years.
Tags:   Musings / Nostalgia

Designing databases for SQL Server and Access

Posted by Andy Brown on 23 April 2012 | no comments
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.

Why the Easter Bunny prefers SQL Server to Access

Posted by Andy Brown on 30 March 2012 | 1 comment
The Easter Bunny stores his distribution data in SQL Server, not Access; read why!

Finding missing WPF controls in the Toolbox

Posted by Andy Brown on 23 March 2012 | no comments
Sometimes the tool you need for a window isn't in the All WPF tools section of the toolbox - here's how to add it.
Tags:   WPF / General

Windows Forms or WPF ? Choosing software.

Posted by Andy Brown on 23 March 2012 | no comments
If you're developing software, should you use old-fashioned but reliable WinForms, or the exciting new concept, WPF?
Tags:   WPF / General   |   Windows Forms / General

Why VB trumps C#, and how trolls don't agree!

Posted by Andy Brown on 15 March 2012 | 2 comments
I recently wrote a blog on why (I believe) VB is a better programming language than C# - I wasn't prepared for the flames this would unleash.

Capture Excel application events - event sinks

Posted by Andy Brown on 06 March 2012 | 1 comment

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.

Tags:   Excel / Excel Visual Basic   |   VBA macros / Classes

Collections of class object using Excel VBA

Posted by Andy Brown on 05 March 2012 | no comments
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.

Tags:   Excel / Excel Visual Basic   |   VBA macros / Classes

Creating classes in VBA - class modules

Posted by Andy Brown on 05 March 2012 | no comments

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.

Tags:   Excel / Excel Visual Basic   |   VBA macros / Classes

Using Excel Add-Ins to Share VBA Code

Posted by Andy Brown on 05 March 2012 | no comments

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.

Tags:   Excel / Excel Visual Basic   |   VBA macros / References

Advanced controls in userforms with VBA macros

Posted by Andy Brown on 28 February 2012 | no comments

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.

Tags:   Excel / Excel Visual Basic   |   VBA macros / User forms
1-20   21-40   41-60   61-77