COMPUTER COURSES HOME TUITION

Computer Courses Home Tuition

Computer Foundation Course

Windows 8,MS Office 2013, Blogs making

Graphic Suits Plus

Corel Draw X6,Photoshop CS6,inpage

Web Page Expert

HTML/DHTML,CSS,Dreamweaver,Photoshop

Search Engine Optimizations

Keyword research,onsite tags,link building, SEO Tools

MCSE 2012

Calculating Age in Years,Months,Days

AGE Calculator in MS Excel

In MS Excel there are many formula to calculate age, but i am explaining here very simple and quick formula for you.you just note down and practice in Excel

Step By Step instructions

Step no.1

• Create statement in excel, start your work from A1
• in A1 type Heading Date of Birth, in B1 type Current Date, in C1 type Age, in D1 type Months
• in E1 type Day of week, in F1 type Days, in G1 type My Age is and in H1 type Bithday Reminder

Step no.2

• in A2 use following statement
  =DATE(1971,7,28) or enter your date of birth using this format =Date(year,month,day) and press Enter key
• in B2 use Today(0 function type this=today()
• in C2 type this
  =DATEDIF(A2,B2,"Y") and press Enter
  Y means you want to calculate no of years.
• In D2 type this
  =DATEDIF(A2,B2,"YM")
  YM means you want to calculate remaining months
• in E2 type this
  =CHOOSE(WEEKDAY(A2),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday",
  "Saturday")
  this formula return us Day of birth in character
• in F2 type
  DATEDIF(A2,B2,"MD")
  this formula return us remaining days of your age
• in G2 type
  =C2& " yrs. "&D2&" Months "& F2 &" Days old"
  this formula summarize all previous columns in to single cell
• in H2 type
  =IF(AND(MONTH(A2)=MONTH(B2),DAY(A2)=DAY(B2)),"happy birthday","")
  if current date column is your date of birth, then this column shows your date of birt as reminder

Boston Computer Solutions

Haafiz Muhammad Ali 

Mob:03334461460

skype id:plhr38

Microsoft Excel 2007/2010 Lecture Slides

By Computer Courses Expert

Microsoft Excel Lecture Slides

MS Excel is in electronic spreadsheet that is used to create accounting statements, apply formulas on it and presents our statements graphically, By default extension of excel is xls till Excel 2003, but there are many changes in Excel 2007 and onward versions of Excel, now the file extension is XLSX.

What is Difference between XLS and XLSX

for explanation, it is good practice that you will create one statement is excel 2003, and save it, and open the same file in excel 2007 or 2010 or 2013 and now save it with different name, and now check the size of both files, file that is created in old version of excel is larger than the file that is created in excel 2007 or above.

Because in Office 2007 and above version compression feature has been added, when you save your file in new version of excel it automatically be compressed, otherwise if you want to reduce its size you have to compress it using compression software. 

For my complete lecture slide of Excel lecture no.1 please visit, that covers the following Topics

1. Define excel, key terms, excel layout
2. Relational operators, Mathematical operators and how to create formulas.
3. Basic formatting in excel
4. Example to create formula in excel

After completing lecture slides do practice in excel, and after good practice answer the following questions.

• What is the concept of Spreadsheet,Workbook,cell ?
• Write down all mathematical operators?
• Write down all Relational operators?
• What is the purpose of =?
• What is the name and syntax of built in excel function that is used for addition?  

if you feel any difficulty so please use the following link students help desk or chat me on kype my  id:plhr38

MS Excel Lecture no.2

Boston Computer Solutions now bring second training session of computer courses excel lecture 2 for you. in this lecture you will learn

1. Basic Formatting in excel
2. alignment of cells
3. conditional formatting
4. Moving sheets into new files or existing one's.
5. Using fill command

In previous versions of excel we can add only 3 conditions in conditional formatting but in excel 2007 and onward we put 64 conditions as conditional formatting. using learning computer courses training we will also learn how to use fill command in multiple (many) sheets, selected more than one sheets at the same time, to select more than on sheet use following trick

hold down shift key and  click on sheet.

for complete lecture slides excel tutorials click here 

Excel Lesson no.3

it is the time to start learning Excel lecture no.3 under the platform Boston Computer Solutions, that provides high quality lecture slides on computer courses,excel Tutorials.

in this lession you will learn complete tab of Data in Excel

1. Text to columns
2. Data Validation
3. Simple Filter and Advance Filter
4. Goal Seek

for complete lecture slides click on here, for any assistance help desk is available for you.

Microsoft Excel 2013 Training.....

Excel Lesson

Ms Excel is an electronic spreadsheet that is used to create accounting statements and we present these statement graphically.

Key Terms

Workbook

workbook like a folder that contain sheets, workbook is a file name and this file we found number of sheets, by default on workbook contains one sheet in excel 2013, and we have the option to add unlimited sheets in book.

Sheet

Sheet is the combination of columns and rows, Sheet consists of number of columns and rows,in excel columns recognized as alphabet and rows in numbers, but still we have the option to represent our columns also in numbers.

Cell

One column and one row make single cell, its mean there is a number of cells in sheet.For example, A is a column and 1 is row, so A1 is Cell.One cell is also called reference.

Work space file

if we open more than one workbooks in excel, and show all workbook windows as tiled, so number of files that is appear on one screen called workspace file. we also have a option to save all different files as on file.

Total Columns in Excel sheet:16384
Total Rows in Excel sheet:1048576

Jumping Tricks.........

if you want to move your cursor or pointer just press  END key and then press right arrow from direction pad.

Similarly if you want to move your pointer from any row to last row, so press END key and then press down arrow key from numeric keypad.

Type of Addressing in Excel

There are two type of addressing in excel.

1. Absolute Addressing

the exact address of a cell, regardless the position of a cell that contain the formula. the absolute cell reference take the form$column and $row.

Example no.1              $A$1  

Example no.2              $a$100
The main advantage of this type of formula is if you want to copy exact cell in different locations.

1. Relative Addressing

Address of a cell based on the relative position of cell that contains a formula and cell reference, if you copy this formula the reference automatically adjusts. A relative reference take the form ColumnRow

Example no.1              A1  

Example no.2              A100
in  many cases we used this type of addressing.