MS Office blogs
Showing blogs 61-80 (out of 111)
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!
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.
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.
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!
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.
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.
Visual Basic for Applications (VBA) is what's called an object-orientated programming language. This blog explains what this means!
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!
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!
Following on from the article discussing simple conditional formatting in Excel, this blog shows you how to add Data Bars to your lists for that extra bit of pazazz!
This short article looks at the basic settings for creating conditional formatting rules in Excel.
If you've ever had the tedious job of manually scrolling through a long list of data to remove the duplicate entries in Excel then this blog is for you! Discover how to hide or delete duplicated data in Excel 2003, 2007 and 2010.
The InputBox function in Visual Basic for Applications allows you to get - as the name suggests - input from the user. This blog shows how to use it!
If you've ever tried to enter fractions in Microsoft Excel you'll probably have become frustrated when Excel insists on converting them into dates! Read this blog to see how to prevent this from happening.
The MsgBox command in Visual Basic for Applications allows you to display basic messages, but you can also make it prettier, and even use it to ask questions or display multiple-line messages! Read on to find out more about this versatile VBA command.
If you've ever inserted a company logo or other image onto a slide with a coloured background in Microsoft PowerPoint you'll probably have been really annoyed when the image looks as though it's contained in a white box. Read this blog to find out how to remove the box and make your image appear transparent.
Have you ever been asked to reproduce your company's brand colours in your latest PowerPoint presentation, or wanted to use your corporate font colours in your latest Word report? This blog will show you how to pick your colours accurately in any of the standard Microsoft Office applications.
If you've upgraded from Access 2003 to either Access 2007 or 2010 you might be wondering why your forms don't look like forms any more. Read this blog to see how to change a simple setting that will return your forms to their normal state!