Excel 2007 Tutorial 2: Basic Spreadsheet

Excel 2007 Tutorial 2: Basic Spreadsheet. Introduction to Excel and the creation of a basic spreadsheet.

Category:

People & Blogs

Tags:

• Excel 2007 Basic Spreadsheet
• 10minutetrain
• beginner
• tutorial
• basic spreadsheet
• beginner spreadsheet
• excel 2007 tutorial
• excel 2007
• excel tutorial
• excel instruction
• how to excel

[markoamanita1981]

Can you explane me why didi you put number one in your first formula B2*(1-C2) ? Thank you.

[10minutetrain]

@markoamanita1981

It is the price which is in cell B2 times (1 - discount percentage). The discount is determined by multiplying the price x discount percentage. The sale price is determined by multiplying the price x (1 - discount) which gives you the remaining price percentage amount. For example, a $100 item with a 10% discount sells for $90 (100 * (1-.10)) or 100 * .90.

[xxtina24]

@markoamanita1981 the 1 was added so that the formula can now be copied and pasted without rewriting all of the different discount percentages. by adding the 1 the formula can autmatically calculate each individual discount percentage.

[purin0504]

Thanks for your detailed tutorial! :) Feeling you teach with heart ~

[007sumedha]

thanxs a lot for ur help :)

[thewisestpoor]

thanks alot

[948290]

THANK YOU

[nkishorlavanya]

nic video



[RandomCoked]

THANK YOU!

[ployna2001]

and more importantly thank you so much for this.

[ployna2001]

how can I type size 7 black shoes and then so on without typing in every excel but i want just the number that been changed but keep the text as it is.

[Bose459]

Thanks for the video mate it has been very helpful