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.
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
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.
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
In this Video we go through the basic Concepts of the Excel Vloopup Command
Computer Lessons Made Simple
More stuff from “LessonCasts”
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.