Posts Tagged ‘excel’

Excel Magic Trick #31 Part 2: IF AND OR functions, logical

September 9, 2009 - 1:30 am 20 Comments

See how to use the IF, AND and OR functions! See how to make logical formulas. You can check to see if a cell is blank, whether it is above a certain limit, or whether the cell contains text!

See how to make the labels on your Income Statement change depending on whether or not there is a Net Loss or a Net Income. See how to use the IF, AND, and OR function to evaluate a customer’s credit.

Excel Magic Trick 167p1 IF function formula: 12 Examples!

Excel Magic Trick 167p2 IF function formula: 12 Examples!

Duration : 0:7:39

(more…)

G20 SUMMIT MISSION STATEMENT Vs AVII TRUTH EVENT 2009

September 9, 2009 - 1:30 am 2 Comments

The Alternative View
An Event Bigger than the G20 Summit for TRUTH
To advance awareness and facilitate discussion of Political, Scientific and Spiritual alternatives without constraint by Consensus Reality and/or Received Wisdom.

Mankind is at a fork in the road. Ahead, potentially, is an Orwellian nightmare, or an opportunity to participate in creating a new beginning for our world.

There is a co-ordinated effort by our world leaders (elected and unelected), with the willing help of a corporate controlled mass media, to use manufactured global crises to create what they term a New World Order. Youve heard that term in the media, indeed Gordon Brown uses the phrase with alarming regularity, but what does it mean? Simply this: A global super state, controlled by a World Government, policed by a World Army, with a single World Currency and a single world Religion!

There is, however, an Alternative View. An alternative which will be mapped out at AVII, after we have shown our delegates - through well researched evidence and facts - what is really going on around us.

The Alternative View is not just an event, its a Community. Our aim is to facilitate a community of shared values which supports, nurtures and encourages an alternative sustainable existence. An existence that does not differentiate between race or creed but which is founded upon mutual respect, understanding and support.

KEY WORDS: Alternative View, Event, Truth Financial Fools Day, four horsemen of the apocalypse, Gordon Brown, global economic crisis, G20 call for action amid protests, G20 Summit as it happens, Rob Broomby, President Dmitry Medvedev, President Obama, President Hu Jintao, Daniel Boettcher, G20 summit, Argentina, Australia, Brazil, Canada, China, France, Germany, India, Indonesia, Italy, Japan, Mexico, Russia, Saudi Arabia, South Africa, South Korea, Turkey, the United Kingdom, the US and the EU.

Duration : 0:4:6

(more…)

Microsoft Excel #06: Using “IF” in Formulas

September 6, 2009 - 1:13 am 25 Comments

More advanced formula uses including the “IF” statement. For example, “IF someone earned over $200 then charge them $20… otherwise charge them $40.” This is a very powerful tip.

Duration : 0:4:51

(more…)

Excel If Statement

August 22, 2009 - 5:14 am 5 Comments

A short presentation to show you how you can use the Excel If statement together with AND and OR statements. For more indepth tutorials and to download the file used in this tutorial - visit www.the-tutorial-library.com

Duration : 0:5:6

(more…)

Microsoft Excel, SQL & Internet Tips : How to Use an If-Then Statement in Excel VBA

July 14, 2009 - 1:27 am No Comments

Use code to create an if-then statement in Excel VBA by using corresponding worksheet cells. Use an if-then statement in Excel VBA with tips from a software developer in this free video on using Microsoft Excel.

Expert: Dave Andrews
Contact: www.daveandrews.org
Bio: Dave Andrews is a software developer that holds a degree in computer science. Currently, he is employed by a government IT department.
Filmmaker: Tim Brown

Duration : 0:2:52

(more…)

IF Statement and Nested IF Statement in Excel

July 7, 2009 - 9:30 pm 1 Comment

http://www.TeachExcel.com
How to use a basic IF statement in Excel and also how to use a nested IF statement in Excel. This is a good tutorial for a beginner and also someone looking to understand nested IF statements.

To get the Excel file used here, go to the website and download it:
http://www.TeachExcel.com

Duration : 0:9:4

(more…)