1. Episode 1 of creating an excel spreadsheet to check the affordability of an income over outgoings, this series uses a combination of VLOOKUP, IF, MATCH and Pivot tables, with a Simple Graph at the end.

    # vimeo.com/109864357 Uploaded
  2. Many People Ask How you do some basic functions in excel , such as lists and numbers, in this video short, we go through, numbers lists, month lists, and incremental values

    # vimeo.com/107872079 Uploaded
  3. in this lesson , you will learn how to use static values in a spread sheet, static values are fantastic, when you have the same value which is repeated through your spread sheet.

    # vimeo.com/107904762 Uploaded
  4. In this video we take a look at if statements and how they can be used on a spread sheet and what they mean.

    We also touch on nested if statements, which can help in making your spread sheet nice and clean

    # vimeo.com/107879694 Uploaded
  5. In this Video we go through the basic Concepts of the Excel Vloopup Command

    # vimeo.com/107869874 Uploaded

LessonCasts

Richard

Computer Lessons Made Simple

Browse This Channel

Shout Box

Heads up: the shoutbox will be retiring soon. It’s tired of working, and can’t wait to relax. You can still send a message to the channel owner, though!

Channels are a simple, beautiful way to showcase and watch videos. Browse more Channels.