Special Topic

30 March 2010 - 13:42

How to find (the first) capital(s) in an Excel cell?

Another interesting topic coming up through one of my clients.

I've found an enlightened discussion at one of these great Excel resource sites: http://www.dailydoseofexcel.com.
Especially the breakdown of the described first function and the elaboration on arrays is worth reading.

These are the two takes I've been going for:

{=MIN(FIND(CHAR(ROW(INDIRECT("65:90")));A1&"ABCDEFGHIJKLMNOPQRSTUVWXYZ"))}

The trick consists in finding the ASCII value of the first capital of a text-string composed out of the cell containing the evaluated text value combined with the 26 capitals of the Alphabet.

And then also a user defined function in VBA:

Function FirstCap(Cell As Range)
   For FirstCap = 1 To Len(Cell.Value)
      If Mid(Cell.Value, FirstCap, 1) Like "[A-Z]" Then Exit For
   Next FirstCap
End Function
' And =IF(firstcap(A1)>LEN(A1),NA(),firstcap(A1))
(1) Comments ·
26 March 2010 - 17:22

Corruptions during Access development

During a quite substantial development project in Access recently, I initially started developing in Access 2007. But as downgrading to the Access 2003 version the client used posed all kind of issues, I gave up and continued the development in Access 2003.

So far so good - well I thought, but not till rapidly ran into something I had never experienced. All kind of forms suddenly didn't want to load anymore as they became corrupted.
Randomly, apparently, although frequently linked to removing labels or moving fields with their labels.
And mostly with the laconic error message: "there isn't enough memory to perform this operation" .
It became really a desperating situation.... grrr :-(

I then found a message on http://www.access-programmers.co.uk/ which really saved me and pointed me to a method to save a form as a text file (!!!) and then retrieve it again... Although it didn't always work, this and regular (obsessional ;-) ) backups made me swim across this river.

The trick goes as follows. In the VIsual Basic Immediate Windows, use following code to save the form as a text file:
Application.SaveAsText acForm, "YourFormNameHere", "C:\Path\Filename.txt"
Then delete your corrupted form and retrieve it back using following code:
Application.LoadFromText acForm, "NewFormNameHere", "C:\Path\Filename.txt"

If the issue still continues, try doing a Compact and Repair before retrieving the form.
And a further comment on the forum pointing to a possible use of this technique:

If you have to provide documentation for your application you can use this technique to create text files that contain all the information about your forms. Then should anyone modify your form at any point or it becomes corrupt you can restore it from the text file.
You can be really clever and create a support database that would be similar to the MSysObjects table that contains a list of all your objects and store the contents of the text files into a memo field.

To close: you'll find a database corruption repair guide at everythingaccess.com
And some good tips to prevent corruption at the famous Allen Browns corner:http://www.allenbrowne.com/ser-25.html

(0) Comments ·
24 March 2010 - 17:25

Find the cell with the lowest value in an Excel sheet

The beauty of Excel is that there are many ways to achieve the same thing.
Take this topic e.g. : how to find the cell with the lowest value in an Excel sheet?

If you're after the exact location of that cell, and you can limit your search to a specific column or row with results, you could use a combination of the ADDRESS() and the MATCH() function which would give you something like:

=ADDRESS(MATCH(MIN(A:A);A:A;0);1;4;1)
=ADDRESS(2;MATCH(MIN(A2:Z2);A2:Z2;0);4)

Or you might be more picky as to which type of information you'd like to withdraw from that cell containing the minimum value -
it could be the range address, but also it's content, or it's column position, it's formatting or it's locked status. That's something you can do with the CELL() function -
it's first argument determines the type of info you'll get as a result. With our two examples:

to obtain the cell addresses::
=CELL("address";INDEX(A1:J2161;MATCH(MIN(A:A);A:A;0);1))
=CELL("address";INDEX(A1:J2161;2;MATCH(MIN(A2:Z2);A2:Z2;0)))

to obtain the cell values::
=CELL("contents";INDEX(A1:J2161;MATCH(MIN(A:A);A:A;0);1))
=CELL("address";INDEX(A1:J2161;2;MATCH(MIN(A2:Z2);A2:Z2;0)))

to obtain the cell lock status::
=CELL("protect";INDEX(A1:J2161;MATCH(MIN(A:A);A:A;0);1))
=CELL("protect";INDEX(A1:J2161;2;MATCH(MIN(A2:Z2);A2:Z2;0)))

If you need this approach regularly, you could also take the VBA road and insert a module with your own user defined function.
Like the one here found at http://www.excelforum.com :

Function MinCellRef(dsRange As Range)
Dim c As Range
Dim MinCell As Single

MinCell = Application.WorksheetFunction.Min(dsRange)

For Each c In dsRange
If c.Value = MinCell Then
MinCellRef = c.Address
Exit Function
End If
Next c
End Function

And if you want some VBA solution which highlights and formats the cell containing the minimum value, that's possible too : http://excelvbamacro.com

(0) Comments ·
20 March 2010 - 13:14

How to download flash from a web site

You can download flash videos from a website either with dedicated tools for that purpose or by going into the source code and tracking the path allowing you to then manually download the flash file e.g.
Obviously the latter requires a bit more technical experience. And even if you have that, it can still be a time consuming job, as many flash files are often encapsulated in all kind of codings.

A good place to start probably is wikiHow: http://www.wikihow.com/Save-Flash-Animation-from-Website .
In terms of the dedicated tools I've personally good experiences with Replay Media Catcher - amongst others I've tried are Fast Video Download, a Firefox plugin and Flash Saver (http://www.flash-screen.com/flashsaver/).

On the coding side: you'll find a very good description and approach with Firefox, free but a bit more technical, on following website: http://geeklad.com/download-flash-video-from-any-website

ps: Regarding Fast Video Download: although it's a great tool, you might run into the problem of dialog boxes starting to open extremely slow: http://support.mozilla.com/nl/forum/1/623540

(0) Comments ·
15 March 2010 - 17:10

Autosave in Excel 2007

For those who are searching the specific AutoSave feature in Excel: search no longer - it is really gone.
Well yes it was replaced by the AutoRecover feature, but it's behavior is sligthly different.

You'll need to use an add-in to get exactly what you had before, i.e. possiblity to autosave your Excel file at a specific interval on a specific place (under a specific name ?).
I've found one here: http://www.jkp-ads.com/download.asp

(0) Comments ·
10 March 2010 - 17:31

Templates location configuration in office 2007

Template location properties

If you're using a lot of templates in Office, it's a good idea to organize things a bit. This means changing the default template location and putting your templates in subfolders.
Because if you don't specify a specific location for your templates yourself, Office saves them in a very hard to tackle place in the profile folder of the user.
And if you have created sub-folders in the main template folder, Office is then going to show or represent these as separate tabs in the template dialog window.

In Office 2007 this still happens as in the older versions of the suite: rather mysteriously that is !
Because you have to go into the Word options to find the locations button - and only there ! - as it's unavailable in Excel or Powerpoint ...
So just go to the Advanced Options in the Word options dialog window, at the very bottom, you'll find the button File Locations giving you access to the default folders for the User Templates, as well as the Work group templates. Just choose the parent folder for you templates and presto.

Template location dialog box

All you have to do next is saving your Excel, Powerpoint or Word templates in this folder, or in sub-folders of this folder, and they will then automatically appear in the Template window.

(0) Comments ·
03 March 2010 - 14:57

Mailmerge with groups

Ever wondered or needed to do a mailmerge in MS Word with multiple group levels?
It is possible indeed; it involves customizing the merge fields a bit, but if that's what you need, you'll find the whole procedure through following links:

(0) Comments ·
26 February 2010 - 13:41

Video editing

I had to go into the topic of video editing recently and come across this nice overview of tools for the matter: http://www.convertdirect.com/top_10_flv_converters.html

I got the best results with AVS Video Converter in terms of reframing, cutting and merging parts of video materials. But I really liked the user interface and the friedliness of a tool not listed in this article: FLV Editor Pro - I only had problems in properly merging the pieces as this didn't happened precisely enough for what I needed... in my experience and with my limited skills in this area, that is :-)

Two other tools which I've used and tried out are Replay Converter, the best tool in my experience in terms of allowing recording from web pages - this tool really allowed recording flash from some sites where all other tools failed.
And also Super, which I've found the best tool for converting purposes; not the most user friendly, but a really Super one !

(0) Comments ·
24 February 2010 - 07:28

Transparency on iframes in IE7

If you work with iframes, you might have realised already there's an issue with the transparency settings.

Especially in the IE browsers even if you give specific CSS instructions to have the body background colour rendered transparent, you won't get what you're after - the background is still going to remain opaque.
Following article describes the issue and solution nicely : http://www.tech-recipes.com/rx/1253/htmlcss-transparent-iframes-in-all-browsers/ - in essence: you need to add allowtransparency="true" to the iframe HTML ; and of course also set the background transparency to the body CSS tagselector :-)

(0) Comments ·
10 February 2010 - 05:23

How to prevent editing when grouping sheets in Excel ?

This question came up during one of my Excel courses - clearly something to be done with VBA, so I googled it and found following code at http://www.pcreview.co.uk/forums/thread-3768672.php:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
     If ActiveWindow.SelectedSheets.Count > 1 Then
     With Application

          .EnableEvents = False
          .Undo
          MsgBox "Oh, please don't group the sheets..."
          ActiveWindow.SelectedSheets(1).Select 'Ungroups
          .EnableEvents = True
          End With
     End If
End Sub

ps: for some interesting elaboration on Events go here: http://www.cpearson.com/excel/Events.aspx and here : http://www.cpearson.com/excel/AppEvent.aspx

(1) Comments ·
08 February 2010 - 11:04

Difference between div and span element when coding CSS

I remember having prepared an blog post covering this topic, after a question during one of my courses... However it never saw the light because there's always so many things to accomplish at the same given time.
But never despair as it says: recently an article was published on Sitepoint on this matter. Which triggered also an interesting debate.

Nice reading if you're in the CSS business.

(0) Comments ·
03 January 2010 - 13:59

Merge many word documents into one single document

This sounds like something fundamental, but for some reason I never really needed something to merge many word documents into one new document.
Till recently that is.

You can of course go the direction of the Master/Child documents approach in Outline view.
For more information on this you could try these links:

But if you really envisage one flat document, apparently you need a macro to do this properly - you'll need to finetune it with the specific path containing your Word documents as well as pay attention to the specific extensions the documents have :

Sub MergeDocs()
    Dim rng As Range
    Dim MainDoc As Document
    Dim strFile As String
    Const strFolder = "C:\Courses\Word\" 'change asper your need
    Set MainDoc = Documents.Add
    strFile = Dir$(strFolder & "*.doc") ' can change to *.docx or *.rtf
    Do Until strFile = ""
        Set rng = MainDoc.Range
        rng.Collapse wdCollapseEnd
        rng.InsertFile strFolder & strFile
        strFile = Dir$()
    Loop
End Sub
(0) Comments ·
31 December 2009 - 19:00
30 December 2009 - 13:26

Adding a public folder to Outlook favorites

Add to Favorites

If you right click a public folder in Outlook, and choose the option to 'Add to favorites', you'll add this favorite to the Public folder favorites only.
But if you thought or wanted it to appear in the main mailbox favorites, you'll notice or have noticed already that nothing was actually happened.

No need to feel defeated any more, as the solution is really simple, although unfortunately not 'obvious' at all:
simply right click the Public folder favorites folder shortcut that you created earlier, and then select 'Add to favorites' again and hey presto, the favorite is now going to show up in your main mailbox favorites area.

(0) Comments ·
29 December 2009 - 08:05

On the topic of manuals, books, training and … pedagogy

When doing trainings, mostly IT trainings, a couple of questions pop-up from time to time.
Like : do you have some suggestions for a good book? Or which book do you use during your training? Or how to you organize your training?

Well firstly I have to say I don't really follow or use a manual or book when I teach.
At several occasions over the years, people personally expressed their gratitude for that, so this only fortified this conscious choice of course.

Of course this doesn't mean that I don't use a structure and/or the structure doesn't or couldn't match a manual or book.
I actually work with detailed mind-mapped structures for all of my course contents - this gives me great flexibility and the possibility to concentrate fully on the learning process itself.
I always start a course by feeling the pulse and asking participants what they want to learn. I then present the overall course contents - tailored and adapted to the level and specific questions or desiderata.
But I keep a great amount of margin to be able to surf and adapt to what the group dynamics actually bring in - in my personal view it's exactly here the magic of the pedagogical process hides.

Even when examples and structure may be identical, I always inspire questions, reflections and exchange to a maximum possible and address them with mind-mapped content.
Pedagogically that implies that I envisage to focus energy on the learning process itself more and that yet another input source as a book, manual or powerpoint content generally isn't really appropriate.
So practically every course is rather or completely different as every group and group dynamic process 'of course' always differentiates.

Now I do understand the (psychological?) need of having a written manual or book and generally refer to those as an 'after course implementation' resource.
But then it always seems hard to me to come up with suggestions which fully satisfy me - what is a good book anyway?
But even if haven't fully figured out what a 'perfect IT Manual or book' for me would be I know in which direction I'm looking: resources which focus on conceptual learning and transfer of knowledge, which don't contain overloads of written text, and use a lot of schemes and mappings, as this is the way we program our brains basically ...

Some miscellaneous links in the margin of this topic

(0) Comments ·
28 December 2009 - 07:14

Reversed Engineering on a pivot table in Excel

When you've created a pivot table in Excel, you can drill down on the results by double clicking on them - Excel then creates a new worksheet with the individual lines behind the result.
If you do so with the grand totals, all the lines, i.e. the full source sheet will be inserted into the new worksheet.

results in a pivot table like format without being a pivot table

So far so good.
But what if you have to do it the other way? I.e. if you have the results in a pivot table like format, e.g. provided by your database administrator in a simple Excel sheet - you can't do the drill down as you don't really have a pivot table. And you need to recompose the individual line behind the construction?
A simple reconstruction with some images of the starting and end situation will probably make the point clearer.

end result of the operation

To get to the desired result you'll need to do some 'reversed engineering' which is possible via the Pivot Table and Chart Wizard (which is not directly available any-more from the ribbons in Excel 2007, so if you use this version, you need to add this feature through the Customized Option for the Quick Access Toolbar). You'll find more information on this feature from the Microsoft Office site.

The wizard provides in an option to create a Pivot Table from a 'Multiple Consolidated range' of cells - even if you select just one range of data (with row and column labels), Excel is going to treat the data very much like in the Data/Consolidate feature. Each column become a data series, which is then used to compute a new pivot table. And even it's very near or exactly the same as the original data list, you know have a pivot table with access to the grand totals which you can double click to.... obtain the envisage individual results.

The Spreadsheet Page describes the procedure with screenshots for older Excel versions, but also provides in a macro automatising the whole procedure, at the following link.

Sub ReversePivotTable()
'Before running this, make sure you have a summary table with column headers.
'The output table will have three columns.
Dim SummaryTable As Range, OutputRange As Range
Dim OutRow As Long
Dim r As Long, c As Long

On Error Resume Next
Set SummaryTable = ActiveCell.CurrentRegion
If SummaryTable.Count = 1 Or SummaryTable.Rows.Count < 3 Then
	MsgBox "Select a cell within the summary table.", vbCritical
	Exit Sub
End If
SummaryTable.Select
Set OutputRange = Application.InputBox(prompt:="Select a cell for the output", Type:=8)
'Convert the range
OutRow = 2
Application.ScreenUpdating = False
OutputRange.Range("A1:C3") = Array("Column1", "Column2", "Column3")
For r = 2 To SummaryTable.Rows.Count
  For c = 2 To SummaryTable.Columns.Count
   OutputRange.Cells(OutRow, 1) = SummaryTable.Cells(r, 1)
   OutputRange.Cells(OutRow, 2) = SummaryTable.Cells(1, c)
   OutputRange.Cells(OutRow, 3) = SummaryTable.Cells(r, c)
   OutputRange.Cells(OutRow, 3).NumberFormat = SummaryTable.Cells(r, c).NumberFormat
   OutRow = OutRow + 1
  Next c
Next r
End Sub
(0) Comments ·
23 December 2009 - 03:38

How to extract images from mail messages and / or PowerPoint slideshows?

This is actually very simple, although perhaps not that obvious at first sight (or trial).
The answer is : Save As Html.

save as html

And that's valid for any Office document basically.
Have a mail message with some nice images you'd like to use? Just go to the File menu or Office button and choose to 'Save as' - then change the option 'Save as type' to Web page - html. The system is going to produce an Html file in the folder you selected as well as a subfolder with all the 'dependant' files for the html page to render properly, like CSS files and graphic files. And that's it !

Same procedure for other programs like e.g. PowerPoint slideshows: just save it to you harddisk, open it in PowerPoint, then save as Html and presto.

(0) Comments ·
19 December 2009 - 12:31

The power of the summit

If we'll remember one thing from the month of December 2009, then it's likely to be Copenhagen Summit in Denmark on environmental issues. If not because of it's size, it's worldwide media coverage, it's political impact or lack of impact and it's result or lack of result... definitely just because of it's overall importance.

If you like clear thinking and a change of perspective which that often brings along, then here's the 'Clear Thinking' issue which landed in my email box at the time of the Summit's 'warm-up'.
Clear Thinking is a bi-monthly published E-zine by the hand of Mike George, a lucid English author and lecturer on topics dealing with Change, Change Management and Change of Consciousness.
You can subscribe using this link..

Clear Thinking

The power of the summit

Will you be listening for the good news from Denmark next month? Will you be waiting to hear what changes lies in store for your lifestyle? Will you hope that ‘they’ can resolve their differences and heal the world? Yet another meeting of ‘our representatives’ will bring together those who believe that they have the ‘power to influence’ all our futures. The Copenhagen summit on climate change will once again focus minds in search of joint solutions to the environmental issues that transcend all borders. Decisions will be made that may affect generations to come. Past summits seem to have done little to translate whatever consensus was achieved into decisive action. Already the leaders who will convene next month are telling us that new decisions cannot be taken as there is not enough time to organize the right ideas, draft the treaties and build consensus. While many despair at a repeating pattern of disagreement and division, prevarication and delay, others have given up hope that anything significant can be done at such gatherings of the so called movers and shakers.

[Read more on The power of the summit...]
(0) Comments ·
18 December 2009 - 12:28

Prevent forced reboot after Windows Update operations

If you don't like to be forced to reboot after yet another Windows Update, then know you actually have a way out.

windows update message

There's several fields to play on actually, depending on what you want to achieve and on the Operating System itself.

  • You can fine-tune the behaviour of the 'Automatic Updates' feature through the 'Security Center' in your Control Panel.
  • At any given moment you can also intervene on the Service triggered off, by removing it or by changing it's settings ; it this case the 'Automatic Updates' (wuauserv service)
  • You can intervene on the Group Policy settings through the Local Security Settings in the Administrative Tools; eg the path to walk on XP is: Local Computer Policy - Computer Configuration - Administrative Templates - Windows Components - Windows Update, then set to no auto-restart for scheduled updates
  • Finally, you can also add a registry setting to change the behaviour through Regedit at the Run command prompt: NoAutoRebootWithLoggedOnUsers registry value in HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate\AU with dword value to 1.

A nice overview actually of how you'd typically approach more advanced interventions on a Windows system.
You'll find all detailed explanations on the above pathways at following sites:

(1) Comments ·
15 December 2009 - 04:16

Import WordPerfect 4 Files into Microsoft Word

In the prolongation of a previously published entree on text conversion problems with Word, I received a mail from someone who was searching for the old Wordperfect 4.2 conversion file, not available anymore in the last MS Office releases (WPFT432.CNV).

The place to be is an article called 'How to Import WordPerfect Files into Microsoft Word', published on http://www.columbia.edu/~em36/wpdos.
Somewhere within that page, you can download A replacement set of conversion filters for use by Microsoft Word.
There are the filters for the WP 5.X version, but also for WP 4.0 - the procedure described for WP 4.2 is the same, so you only need to copy the files to the described location (in a typical install under Win XP: C:\Program Files\Common Files\Microsoft Shared\TextConv).

However to get the converter presented in Word along with the other converters, you need to tweak the registry. To ease the process, you could safe following lines to a text file, save it as wp42update.reg or something; just double click the file will insert these lines in the appropriate places in the registry:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Text Converters\Import\WrdPrfct4Dos]
"Path"="C:\\Program Files\\Common Files\\Microsoft Shared\\Textconv\\wpft432.cnv"
"Name"="WordPerfect 4.x"
"Extensions"="doc"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Text Converters\Import\WrdPrfct4Dos\Options]
"DisplayWPGDialog"="No"
"Name"="WordPerfect 4.x"
"FavourSequenceFields"="Yes"
"FavourAppearance"="Yes"

Enjoy the nostalgia, as yes indeed where are the amazing times of the blue screened function keys driven interface of WP 4.2 and WP 5 :-)

(5) Comments ·
14 December 2009 - 16:04

Powerpoint Handouts

Handouts in PowerPoint can be printed through the print dialog box and settings - you have a certain control over their formatting through the handouts master.

If you're looking out for more flexibility to print out handouts, your best first step probably is creating handouts in Word.
To do so all you need is the SendTo option in the File Menu for pre-Powerpoint 2007 users or the Publish option from Powerpoint 2007 onwards. The wizard actually offers a series of options as how to layout your pages too.
You'll find a series of screenshots on these options at about.com.

And If you want even more control then have a look at the add-on available from skp.mvps.org.
The site offers a handout wizard allowing you to create your own customized layouts and more.

But coming back on the PowerPoint - Word wizard, it actually produces rather small thumbnails of the slide in the final Word document.
I've found a macro on answers.google.com to resize the graphics and tweaked it a bit as to make it work on the whole document for any number of slides.
Just copy the code into a module behind the document or into the 'Normal' project or template of your current software version.

custom handouts [Read more on Powerpoint Handouts...]
09 December 2009 - 16:12

Propagation of Custom Animation in Powerpoint

Once you have created a custom animation in PowerPoint, you might want to apply the same animation on the other slides. But... there is actually no way to propagate a custom animation in PowerPoint. No despair however, you can avoid having to redo the animation on each of your slides by applying your animation to a placeholder on the master.

Here's the procedure in a nutshell:

  • Open the Master View and select the body text placeholder (or placeholder of your choice depending on the Powerpoint version)
  • Apply the Custom Animation your choice, e.g. making text fly in and ensuring each of the bulleted topics flies in 'after previous' to then 'dim out' when going to the next one.
  • Close the Master View and save.
  • Remove all Custom Animations applied on individual slides now having become redundant.
  • Now play the slide show and check if all slides behave as wanted - if not try to 're-apply' the chosen layout to the slide or choose the correct layout.
propagate animations in PWP

Ps1 : You cannot delete animations applied by the Master slide through the custom animation features on a slide.
If you have PowerPoint 2002 or later you can take benefit of the multiple master feature to scope the animations throughout the slides and work with different masters to apply different or no custom animation asper the need.
And from Powerpoint 2007 onwards, there are much more placeholders available on the masters, so that gives margin for even more flexible solutions by choosing animation for specific placeholders.

Ps 2 For more information on this topic : http://www.jegsworks.com/Lessons/presentations/advanced/step-animatedata.htm

(0) Comments ·
06 December 2009 - 15:12

On windows explorer tooltips and thumbnails

It's amazing how many different settings can be encountered on computers ... and how confusing or complex it can all turn out for the 'normal' end-user.

Like recently during a PowerPoint course in a course room with identical computers. When browsing images to insert into the slides, some participants see the thumbnails of the images, as well as the pixel dimensions, others see thumbnails without the pixel dimensions, and still others don't seem to be able to activate the thumbnails altogether.

To start with the last one: if you don't see the thumbnails for images when you should, it's most likely linked to a setting in the folder options Windows Explorer - in the View Options, you have to make sure the option 'Always show icons, never thumbnails' is un-checked.
Remark that the word 'Thumbnails is not used anymore in Vista, but Large and Small Miniatures should then just do what they say.
If ever this is not the cause of not seeing thumbnails in your folders, you could try-out the procedure as described by the Microsoft Knowledgebase, as indeed there are issues with thumbnails: http://support.microsoft.com/kb/928572

The specific information (size, pixel dimensions, file type, etc) appearing in the tooltips are actually dependant on some registry settings; it seems a bit of a mystery how some of the settings sometimes get updated and sometimes not, probably to installation of certain software, but if you want to master it yourself you'll find the keys in following articles: http://www.ghacks.net/2008/02/10/customize-windows-explorer-tooltips/.

Happy tooltipping !

(0) Comments ·
05 December 2009 - 03:45

What is a browser?

I've always considered asking questions as a fundamental key in any teaching work.
Good questions have tremendous potential in induce insight.

And the most basic questions may sometimes be very well the most powerful triggers to insight.
That's what some people from Google have proven by going out and asking this very simple question to the general public on the street :

what is a browser?

The experiment was done in New York, but taken over in some other cities. They all proved to be very enlightening as to how few people really can answer this question properly.
An a eye-opener for the webdeveloper indeed, as in the light of this experiment, the daily concerns of browser compatibility, the decision making process towards CSS, the strive for webstandards, and so on seem suddenly to become so ... well 'futile'...
And even if all those of us, in our efforts to take our work to high standards, know these issues aren't futile at all, it's always good to practice empathy and stay in tune with the 'end user' - isn't ? :-)

browsers anno 2009

But see for yourself if you haven't done so:

Sitepoint elaborates on this experiment through one of it's Ezines.
Google itself was so struck by the results that it decided to launch a website explaining the answer and especially what's the difference between a browser and a search engine. The site has some interesting links to a browser historical line and other browser stuff.

(0) Comments ·
02 December 2009 - 09:04

Problems with printing backgrounds in Powerpoint

printing in PWP

When printing slides in PowerPoint, you might have encountered problems with the backgrounds - mostly being too dark or so and making text unreadable.
You might have realised also there's not such an option (anymore ?) in PowerPoint as 'omitting the background graphics' from printing.

The first way out in this situation is always to try print in 'grey tones' (this should inverse difficult to read text also) - the option is available from the print dialog box, in the 'print what section'.
If still in problem try it again with the 'pure black and white' option - available at the same place in the print dialog box.

You could of course also create a special master for printing purposes only, where you omit the background and/or choose a different colour scheme. You would then have to save the presentation twice, once for the screen (eg presentation.pptx) and for printing (eg presentation_prn.pptx) or if you use PWP 2003 +, create custom shows within your presentation, one for printing and one for doing the presentation as such. As from PWP 2003 onwards, there's the possibility to use multiple masters in the same presentation.

(1) Comments ·
Page 2 of 9 pages  <  1 2 3 4 >  Last »