Blogs by Andrew Gould
Showing blogs 21-40 (out of 61)
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.
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!
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!
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.
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.
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!
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.
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.
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!
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!
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!
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.
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.
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!
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!
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!
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.
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!