Wise Owl's Blog
Making Sense of Software

Excel | Microsoft training in London, UK

Blogs by Andrew Gould

Showing blogs 1-20 (out of 46)
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!

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

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.

Using Calendars in Microsoft Project 2010

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

Protecting Worksheets and Workbooks in Excel

Posted by Andrew Gould on 28 February 2012 | no comments
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!

Using Data Validation in Microsoft Excel

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

Scheduling Data Imports in SQL Server

Posted by Andrew Gould on 27 February 2012 | no comments
If you frequently import data into a SQL Server database from the same source you'll probably be sick of going through the import wizard again and again. So why not learn how to schedule an automatic import of your data using SSIS packages and the SQL Server Agent? This blog explains how to do exactly that!
Tags:   SQL / Tables and columns

Using Scenarios in Microsoft Excel

Posted by Andrew Gould on 27 February 2012 | no comments
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 Microsoft Excel

Posted by Andrew Gould on 24 February 2012 | no comments
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!

Using Styles in Microsoft Excel

Posted by Andrew Gould on 24 February 2012 | no comments
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.
Tags:   Excel / Formatting

How to Edit all Records in a SQL Server 2008 Table

Posted by Andrew Gould on 16 February 2012 | no comments
This blog explains how you can get access to all of the records in a SQL Server 2008 table when you try to edit them, rather than just the top 200.
Tags:   SQL / Tables and columns

Calculating Age in SQL with a User-Defined Function

Posted by Andrew Gould on 16 February 2012 | no comments
A common requirement in SQL queries is calculating a person's age. The expression you need to do this accurately is relatively long, so why not replace it with a user-defined function? This blog shows you how!

This blog is part of our complete SQL Tutorial.

Tags:   SQL / Calculations   |   SQL / Functions

Changing Settings in SQL Server Management Studio

Posted by Andrew Gould on 16 February 2012 | no comments
If you've spent time in the SQL Server Management Studio application you'll probably have noticed that it's not the most user-friendly environment for writing SQL queries. This blog explains how to change a few settings to make your query writing just a little easier.

You can find many more articles like this in our complete SQL tutorial.

Tags:   SQL / SQL programming

SQL Server Tutorial

Posted by Andrew Gould on 13 February 2012 | no comments
This article provides a comprehensive tutorial in Microsoft SQL Server, taking you from the basics of writing SELECT statements all the way through to creating complex stored procedures.
Tags:   SQL / Selecting data   |   SQL / WHERE criteria   |   SQL / Calculations   |   SQL / Joins   |   SQL / Grouping   |   SQL / Stored procedures   |   SQL / Transactions   |   SQL / CTEs, subqueries

Dates and Times in SQL Server

Posted by Andrew Gould on 13 February 2012 | no comments
Dates and times can be the most frustrating data types to work with in SQL Server. Learn everything you need to know about the way dates work with this handy blog series and enjoy happier times!

This blog is part of a larger tutorial on SQL Server, which you can read here.

Tags:   SQL / WHERE criteria   |   SQL / Calculations

Custom Tables in Microsoft Project

Posted by Andrew Gould on 13 January 2012 | no comments
If you find yourself constantly deleting and inserting columns every time you create a new project it might be time to consider creating a custom table that you can share between projects. This blog shows you how to do exactly that!

This blog is part of a complete guide to customising Microsoft Project.

Tags:   Project / Custom fields

Custom Views in Microsoft Project

Posted by Andrew Gould on 13 January 2012 | no comments
If you find that you have to continuously rearrange the preset views every time you create a new file in Microsoft Project, why not try creating your own custom view? This blog explains how to do exactly that!

This blog is part of a complete guide to customising Microsoft Project.

Tags:   Project / Custom fields

Custom Reports in Microsoft Project

Posted by Andrew Gould on 13 January 2012 | no comments
Reporting on progress is an essential part of running a successful project. It's a shame that the preset reports in Microsoft Project are so limited. This blog explains how to create your own custom reports so that you can see the data you need.

This blog is part of a complete guide to customising Microsoft Project.

Tags:   Project / Reporting

Customising Microsoft Project

Posted by Andrew Gould on 12 January 2012 | no comments
There are many things that you can customise in Microsoft Project to mould it to the way you work. This blog summarises the main useful things that can be customised along with links to detailed articles explaining how to modify each one.
Tags:   Project / Reporting   |   Project / Custom fields   |   Project / Views of Project
1-20   21-40   41-46