This Excel lessons takes you through the basics of Excel while looking at a basic spreadsheet. It is worthwhile to enlarge the video to fullscreen size.
This is looking at the sounds made when the five basic sounds are combined together. It is a start on these. Suggestions for future inclusions are welcome. Other lessons that might be useful are English 1, English 2, and English 3. Please feel free to contact me if there are any points you would care to raise. Jack
I have tried to explain the following things. VLookup, HLookup, Average, Sum, Min and Max. Also how to move numbers from one cell to another by just typing = and then clicking on the relevant cell.
This is an introduction to Access Relational Databases. It begins by creating a very simple table and adding records. Subsequent lessons will develop the subject. Thank you.
This Excel video is going to teach you how to take text in Excel and to manipulate it. You can take the first name, the second name, count the letters and so on. This is the kind of teaching session you will need to run more than once to pick up what is to be done. Enlarge the screen to see this video at it's best.
What is happening in this lesson is that if the figures in Excel are important then you are able to set Excel so that it changes the colour around the figures. For example if you were measuring temperature and you wanted to show the moment the temperature dropped below zero - then you would change the 'conditional formatting' so that it showed the - minus figures with a blue surround.
Having created a database it would be useful to direct anyone using it to the vital parts without them having to go to the mechanics of the programme. Hence the production of a Frontsheet. This is what this lesson takes you through.
Early one fine autumn morning the King's Troop (Royal Horse Artillery) were practising in the Inner Circle of Regents Park. There is something very special about people working so closely with such lovely beasts.
"I went back to St Pancras the night before it was due to open to the public on 13th November, hoping to see the statue of Sir John Betchaman. The trouble was this was in a section not open till the 14th. Twas ever thus." The roof was astonishing, painted in a light blue. Vast.
What I tried to do here was to create a macro button that would 'tidy up' the Excel screen. This button when pressed was made to remove all toolbars, scroll-bars, and anything that will make the screen look 'crowded. A second button was added which 'replaced' all these items. So the user is put in control of the look of the screen.
Two men push one another into the fountain, then climb the fountain, sit on the fountain, and then begin to strip. Crowds gather then police come,(you can see the two bike policemen in bright yellow in the background), but one fountain man falls from the concrete fountain, he's ok - he gets out of the water and they leave. (see also Video 1 from same user for closer shots of these two guys)
This video takes you through Microsoft PowerPoint and looks at creating first a title slide and then adding further slides, adding pictures, charts, transition from slide to slide, movement of the words and letters, changing the background and then by pressing F5 showing your PowerPoint presentation.
This lesson takes you through the simplest means of adding in Excel. It not only uses the Autosum, (also known as the Sigma sign). It shows how to use the 'drag' cross to repeat 'addition' down through the rows.
![New Year\](http://img.youtube.com/vi/IG86O1G_Lc0/2.jpg "New Year\")
![King\](http://img.youtube.com/vi/ZkkOlbh344g/2.jpg "King\")
