Derby Busines ICT - IT Training, support and consultancy.

  • ICT Derby on Twitter
  • Derby Business ICT Facebook page
  • Peter Smith
  • Derby Business ICT Blog
  • Derby Business ICT on Google+
  • Derby Business ICT on U Tube

01332 781856

Helping Business Transform Through ICT

Derby Business ICT Blog

Just our thoughts and opinions together those of anyone else who wishes to contribute.

Latest Google Blogger Posts by Derby Business ICT

10 Signs of Death by PowerPoint


Death by PowerPoint
Original Image Souce http://bit.ly/tsYz72

Not a definitive list by any means. You may wish to add to it.

  1. Setting up your presentation with your audience in the room and the projector on.
  2. Too much text on a slide or the text is too small.
  3. Reading directly from the slide and facing away from you audience as you do it.
  4. Over use of transitions and effects with silly sound effects on text entry/exit.
  5. Text all in Word Art
  6. Graphs and charts with too much detail.
  7. Images or pictures are inappropriate, unclear too small or none at all.
  8. Asking someone else to move you onto the next slide.
  9. Presentation does not have background and text theme.
  10. Finishing the presentation with the black screen.

The quality and use of PowerPoint reflects on the quality of the presenter.

Once you become annoyed with the presentation you become annoyed with the presenter and you stop listening to the message, however good it may be.

Best 10 Excel Features That a Business Should Be Putting Into Use.

Those that only use Excel as a fancy desktop calculator are not in any way tapping into the power of the Spread Sheet.

AutoSum Feature
You would significantly increase your business efficiency and time savings if the following features were understood, learnt and put into use.


1. AutoSum features. There are other options available with this button: Average, Count Numbers, Max and Min.
2. Formatting cells for text, size, colour and border including conditional formatting.
Formatting Cells
3. Formatting cells for Number, Time, Date and Currency.
4. Using Fill (Pull Down) to replicate formulas.
5. Setting a Print Area.
6. Saving your spread sheet as a PDF file.
7. Using the $ sign to lock cell references for fixed and variable reference values (absolute references) e.g. C4*$A$1
8. Protecting Sheets to prevent unwanted editing or entry into certain cells.
Fill Feature
9. Producing a selection list using the List option in Data Validation.
10. Adding a Filter to columns.





Learning the above is not hard and would take relatively little time.

Does anyone feel there are other features that should be in this list?

Training for CMS Websites

Many web developers will now offer content manageable websites (CMS) so that clients are not reliant on the developer to make changes to text and pictures (even create new pages) when they are required. The advantage to the client is that changes can be made as and when required and being dependent on the developer finding the time to do it. This is necessary for a website today as it can become dynamic and responsive, not just a passive brochure site.  This has to be positive moves forward in users taking control of technology.

I see two issues that need to be addressed and resolved:

1.       Every web developer I speak to seems to offer a different CMS product be it: open source, bespoke or a commercial. I guess some solutions will be more suited to some business than overs but what are they key feature we should look for or be told about when deciding on the most appropriate CMS site for a business?

Is there not a training need for business leaders and owners so they are able to make informed and therefore appropriate choices when deciding on a CMS system for their business?

2.       What is the level of training is provided by the developer to ensure that the client has the capability to manage the site as intended? As with all potentially brilliant systems it will only be as good as the training its users receive. Many web developers and programmers I find are not natural trainers and therefore undertake a training role reluctantly. What training that does take place may just consist of an hour’s introduction and some help notes. This cannot be considered adequate for the client to have the understanding and capabilities to content manage their site successfully.

Poor training leaves the risk of changes to the site looking messy and amateurish. Spoiling the original site design. My experience is with Joomla and I know form this experience that a good number of hour’s training will be required, the amount also dependent on the level you wish the user to manage at.

I would love to hear other opinions.
http://invaconsult.com.ua/ http://invaconsult.com.ua/