Wise Owl's Blog
Making Sense of Software

Excel | Microsoft training in London, UK

Wise Owl Blog - Home Page

Showing blogs 1-20 (out of 134)

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
Unfortunately, Reporting Services doesn't have a simple setting that allows you to control the number of rows you see on each page. However, you can control this using a clever combination of an expression with a grouping level. Read this blog to find out how!

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

Introduction to SQL Server Management Studio

Posted by Andrew Gould on 30 April 2012 | no comments
Before you get into writing SQL Queries you should take some time to familiarise yourself with the application in which you'll be spending most of your time. This blog shows you the basics of SQL Server Management Studio.

This blog is part of a complete SQL Server tutorial.

Tags:   SQL / Tables and columns

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

How to Delete Digital Certificates from your Computer

Posted by Andrew Gould on 06 March 2012 | no comments
Creating a digital certificate for your VBA projects is easy, but deleting them is somewhat less obvious. This blog shows you how to use the certificate manager to remove certificates that you no longer need.

Macro Security and Digital Certificates in VBA

Posted by Andrew Gould on 06 March 2012 | no comments
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.

1-20   21-40   41-60   61-80   81-100          Next