A primer on measuring data variance in Excel. by David Goodmanson Let’s continue our look at the basic statistics functions in Excel. In our first article we looked at statistical functions that measured central tendency or averages. Most people understand Average or Mean though Median is often misused. Now lets
Office 2010 can be 50% more expensive than Office 2007. Microsoft’s price announcement for Office 2010 tries to disguise a significant price increase compared to Office 2007. The removal of upgrade discounts has led to price increases. There is the usual rearrangement of the content in MS Office bundles which
How to remove the ‘God mode’ folder. After our ‘Winks’ article on ‘God mode in Windows 7 and Vista‘, some readers had trouble removing the ‘God’ folder. Here’s more details on how to remove the special folder. For most people it’s simple – just right-click on the folder and choose
A simple table showing how bad a choice the Office 2010 Product Key Card really is. Office Watch has already talked about the Office 2010 Product Key Card (PKC) purchase option and how it is quite different from the boxed product with the same name. The main difference between the
The new Office 2010 Product Key Card is a more expensive way to buy Office. Part of the Office 2010 pricing regime is confirmation of a new way to buy Office: the Product Key Card. An innovative but more expensive way to buy Office. The idea is simple – at
From: Microsoft This is a direct copy of the Office 2010 pricing as presented by Microsoft with all the footnotes described as a ‘more detailed guide’. Microsoft Office 2010 Retail Pricing Comparison Chart January 2010 Office Home and Student1 Office Home and Business Office Professional Office Professional Academic Word 2010
Microsoft drops its long-standing benefit for loyal Office users. For as long as anyone can remember Microsoft Office has a cheaper ‘upgrade’ price option – but not for Office 2010. Microsoft has confirmed to Office Watch that there will be no upgrade pricing offers for existing Office users. Everyone, existing
What to look for on retail shelves. The Office 2010 Professional box has a small box saying ‘1 Year Technical Support included’. As in the past, the Academic edition is limited to qualified academic users only. The Product Key Card is labelled ‘for 1 preloaded PC only’.
Prices for Office 2010 have been announced with a new twist that looks cheaper but isn’t and upgrades dropped entirely. Microsoft has announced some of the US retail prices for Office 2010 and there’s a new way to buy which looks cheaper but isn’t. Boxed Product This is the standard
Should you buy Office 2007 this week instead of waiting? If you’re thinking of buying Office 2007 there’s a case for getting it this week instead of waiting until later in the month. In the USA, the Office 2007 software you get this week may be different to what you
Pity about the name but ‘God mode’ is a handy trick for Windows 7 and Vista. In fact you don’t need ‘God’ at all. Again, this isn’t MS Office but it’s too good to ignore … Given how sensitive some religious people can be, it’s little wonder Microsoft doesn’t want
Here’s the known situation regarding an enforced change to Word 2007 and Word 2003. We’ll update this page as hard information becomes available. Microsoft isn’t exactly forthcoming about this problem so there are more questions than we’d like and even less answers. Office Watch asked a series of questions to
There are some interesting upcoming NT Live screenings that I thought I’d draw to your attention. NT Live is a high-res screening of a live play – not quite as good as being there but considerably cheaper and more convenient. They only show the film a few times; it’s
Follow up on the recently reported NT error message. A follow-up on the weird NT error message reported in the WAW 2.06: “The control registers for COM2 overlaps with the COM2 control registers.” followed two lines later by “While validating that COM2 was really a serial port, the contents of
How to calculate and track elapsed time. We receive lots of questions about tracking elapsed time, which confuses everyone at first. If you’re working within the same 24 hour time period, you can use the simple expression [endtime] – [starttime] to return the number of hours and minutes spent on
Here’s a simple procedure for exporting information from a table to an Outlook calendar. Q:Elizabeth Moeck wants to know if class name and date information stored in an Access table can be exported to an Outlook calendar A:Here is a simple procedure that does this: Dim dbs As Database Dim
How to change the Overtype mode in text boxes to Insert mode. Q:John Lawrence is frustrated with the Overtype mode in Access text boxes, and wants to know if it can be changed to Insert mode. A:Yes, this can be changed in the Options dialog. Click the Keyboard tab, then
How to suppress the “OpenForm action was canceled” message. Q: Nick Els finds that when he runs a report from a form, even though he has a message on the report’s NoData event, he still gets an annoying error message stating that the OpenForm action was canceled, and he wants
A reader wants to know if there’s a tool that sets up code for error handling. Q:Stephen Young writes to ask whether there is a tool for Access that sets up the code for error handling in a function or sub. A:There is no built-in tool for this purpose in
Here are a couple of methods for creating calculations in queries vertically. Q:Gang Wei writes to ask whether it is possible to create calculations in queries not only horizontally (like Total Cost: [UnitPrice] * [Quantity]), but also vertically, pulling in data from multiple rows. A:Yes, this can be done in
Some interesting error messages and unhelpful help that readers have come across. Sometimes you get singularly unhelpful help or error messages. Here’s some we and our readers have found recently … William Ferry reports the following weird error message, which occurs whenever he boots his laptop running Win NT Workstation:
Some readers suggest efficient alternatives to writing large quantities of text to a separate document, which is then imported into Word. Several readers wrote to suggest more efficient alternatives to writing large quantities of text to a separate document, which is then imported into Word. Robin Trew and Andrew Koch
A reader wants to know why Access loses the paper size of reports if they are anything other than letter size. Q:Jericho Johnson writes: I would like to know why Access loses the paper size of reports if they are anything other than letter size. For Example: I create a
A reader offers this great tip to save time when creating new databases. Chuck Roberts writes with a suggestion that saves time when creating a new database: I frequently make new databases. So I created a blank database with a template form, a template report, and all my standard subroutines.
