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.