Microsoft training courses | Wise Owl - home page

Phone (01457) 858877 or email

Blogs written in 2011

Showing blogs 1-20 (out of 76)

Ten Useful Applications That You Can Get For Free

Posted by Andrew Gould on 15 December 2011 | no comments
As Christmas 2011 approaches we thought it would be a nice idea to list some geeky gifts that you can give to yourself. And the best thing is that they're all completely free!
Tags:   Musings / Random musings

10 reasons why Santa Claus does not use Project

Posted by Andy Brown on 14 December 2011 | 1 comment
Santa Claus has decided not to use Microsoft Project to manage the present distribution process - read this blog to find out why!

Using CreateObject and GetObject to create references

Posted by Andy Brown on 09 December 2011 | 1 comment
Although it's usually easiest to create references to other applications using Tools -> References as described in an earlier blog, you can use the method shown in this blog instead.
Tags:   Excel / Excel Visual Basic   |   VBA macros / References

Referencing Word and other applications in Excel VBA

Posted by Andy Brown on 05 December 2011 | 6 comments
Even if you're writing Visual Basic macros within Excel, there's nothing to stop you inserting text into Word documents, manipulating PowerPoint slides or sending Outlook emails. This blog explains how to reference other applications, and write macros in Excel to link to other Microsoft Office software
Tags:   Excel / Excel Visual Basic   |   VBA macros / References

10 Excel Quick Tips

Posted by Andrew Gould on 02 December 2011 | no comments
Some tasks in Excel always seem to take longer than they should - if only you knew a bunch of quick shortcuts to speed up the simple things. Read on to see how much time you could save!
Tags:   Excel / Formulae   |   Excel / Excel functions   |   Excel / Charts
What happens when your macros go wrong? That depends what error-handling you have in place. Learn how to use ON ERROR and other commands to trap errors in a structured way.
Tags:   Excel / Excel Visual Basic   |   VBA macros / General

Debugging macros in Excel Visual Basic / VBA

Posted by Andy Brown on 25 November 2011 | 1 comment
This series of blogs is intended to provide online training in how to debug in Visual Basic for Applications, including using breakpoints and the immediate window.
Tags:   Excel / Excel Visual Basic   |   VBA macros / General

Event-handling macros in Excel Visual Basic

Posted by Andy Brown on 22 November 2011 | 2 comments
Want to do something when a user opens a workbook, or stop them clicking on a particular cell? You need to learn how to attach code to Excel workbook or worksheet events!

Looping in Visual Basic for Applications macros

Posted by Andy Brown on 15 November 2011 | 5 comments
There are 4 types of loop in Visual Basic for Applications - this blog shows how and when to use each type of VBA loop structure.
This part of the Excel VBA training series of blogs shows how to use IF / ELSE / END IF within VBA, and also how to use the alternative SELECT / CASE syntax within macros.

How to Create Custom Charts in Microsoft Excel

Posted by Andrew Gould on 10 November 2011 | 1 comment
One of the most time-consuming things when creating charts in Excel is having to format them. This blog shows you how to save and reuse custom charts to ensure that you'll never have to format a chart again!
Tags:   Excel / Charts

Setting the Default Chart Type in Microsoft Excel

Posted by Andrew Gould on 10 November 2011 | no comments
When you create a chart, by default Excel always tries to give you a boring old column chart. If you primarily create pie charts it can be really annoying having to change the chart type every time you create one. This blog shows you how to set Excel to always create the type of chart that you want.
Tags:   Excel / Charts

Collections, objects, methods and properties in Excel VBA

Posted by Andy Brown on 09 November 2011 | 9 comments
Visual Basic for Applications (VBA) is what's called an object-orientated programming language. This blog explains what this means!

Differences between Report Builder and Reporting Services

Posted by Andy Brown on 07 November 2011 | 2 comments
Report Builder and BIDS (the Visual Studio add-in for creating Reporting Services reports) are essentially the same underneath their very different looking skins. This blog lists the small number of differences.
Tags:   SSRS / Report Builder

Multivalue parameters in Reporting Services

Posted by Andy Brown on 07 November 2011 | 2 comments
This blog shows how to create multivalue parameters based on dropdowns, whether in SQL Server Reporting Services or Report Builder 3.0.
Tags:   SSRS / Parameters   |   SSRS / Report Builder
Struggling to install Report Builder 3.0 because of a message about the .NET 3.5 framework? The problem is more likely to be to do with Internet Explorer 9.0, as this blog explains.
Tags:   SSRS / Report Builder

How To Create Custom Date Formats in Microsoft Excel

Posted by Andrew Gould on 31 October 2011 | no comments
When you enter dates into cells in Microsoft Excel you're initially limited to a short list of fairly boring formats. Using custom date formats means that you can display your dates in almost any way you like!
Tags:   Excel / Formatting

Common Table Expressions (CTEs) - SQL Training

Posted by Andy Brown on 20 October 2011 | no comments
This blog gives training on writing CTEs in SQL, or Common Table Expressions to give them their full title. The blog also includes a section on creating recursive CTEs.
Tags:   SQL / CTEs, subqueries

Temporary Tables in SQL - a Training Blog

Posted by Andy Brown on 20 October 2011 | no comments
If you want training in how to use temporary tables in SQL, read on! This blog shows how to create temporary tables and how to drop them safely whether or not they exist. Finally, the blog lists the pros and cons of using temporary tables in SQL.
Tags:   SQL / Tables and columns
This article looks at one of the new features in Conditional Formatting in Excel 2007/2010 which we can use to make our boring lists more interesting!
Tags:   Excel / Formatting
1-20   21-40   41-60   61-76  

All content copyright Wise Owl Business Solutions Ltd 2014. All rights reserved.