Microsoft training courses | Wise Owl - home page

Phone (01457) 858877 or email

MS Office blogs

Showing blogs 61-80 (out of 133)

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!
Tags:   Excel / What-if analysis

Writing functions for Excel using VBA

Posted by Andy Brown on 24 February 2012 | no comments
On-line training in writing functions using VBA, for use either within other VBA programs or within Excel itself.
Tags:   Excel / Excel Visual Basic   |   VBA macros / Functions

Arrays in Visual Basic for Applications macros

Posted by Andy Brown on 24 February 2012 | no comments
You can use arrays (multiple variables) in VBA to speed up code - and they are also invaluable for processing CSV files and the like.

Using enumerations in VBA

Posted by Andy Brown on 24 February 2012 | no comments
Excel and other MS Office applications make extensive use of enumerations - and you should too!

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

Writing recursive programs in VBA

Posted by Andy Brown on 20 February 2012 | no comments
In certain cases in VBA (displaying the contents of folders, listing hierarchical data) writing a program which calls itself is by far the easiest way to go - this blog gives worked examples of 3 such recursive programs.
Tags:   Excel / Excel Visual Basic   |   VBA macros / General

Passing arguments to subroutines in VBA

Posted by Andy Brown on 09 February 2012 | 1 comment
To become an efficient programmer, you need to stop writing one long subroutine and start writing lots of small ones instead - and to do this, you're going to need to know everything there is to know about passing arguments.
Tags:   Excel / Excel Visual Basic   |   VBA macros / General

Linking to ADO databases with VBA

Posted by Andy Brown on 06 February 2012 | 1 comment
Learn how to write VBA macros to add, edit and delete data in Access, SQL Server and other databases, using something called ADO.
Tags:   Excel / Excel Visual Basic   |   VBA macros / References

Copy, rename, delete and move files and folders

Posted by Andy Brown on 23 January 2012 | 1 comment
By referencing the unintuitively named Microsoft Scripting Runtime object library you can write VBA code to access files and folders on your hard disk. This blog explains how, and gives a couple of worked examples.

Reading and writing to/from a text file using TextStreams

Posted by Andy Brown on 13 January 2012 | 2 comments
The easiest way to work with text files in VBA is using TextStream objects - this blog explains how they work.

How to choose files and folders in VBA

Posted by Andy Brown on 13 January 2012 | 1 comment
To make it easier for users of your VBA systems to choose files, you can show FileDialogs on screen. This blog explains what these are, and how to customise them.

Linking to the Microsoft Scripting Runtime library

Posted by Andy Brown on 13 January 2012 | no comments
In order to work efficiently with files and folders you first need to create a FileSystemObject. This blog explains how to do this!

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!
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!
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.
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

Creating references programmatically in VBA

Posted by Andy Brown on 03 January 2012 | no comments
Did you know that you can create and manage references from within VBA code? This article gives you ideas on how to do just that.
Tags:   Excel / Excel Visual Basic   |   VBA macros / References

Importing Bank Holidays into the Outlook Calendar

Posted by Michael Allsop on 03 January 2012 | no comments
A quick guide to adding public holidays to the Calendar in Outlook 2010.
Tags:   Outlook / General topics

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
1-20   21-40   41-60   61-80   81-100          Next

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